A squid that saves USDC Transfers to a BigQuery dataset

This tiny blockchain indexer scrapes Transfer events emitted by the USDC contract and saves the data to a dataset on Google BigQuery.

Dependencies: NodeJS, Git, Squid CLI.

To try it out, first download it and install local dependencies:

git clone https://github.com/subsquid-labs/squid-bigquery-example
cd squid-bigquery-example
npm ci

then populate the .env file and execute

sqd process

Make sure to use an ID of an existing dataset for GOOGLE_DATASET_ID!

If you visit the console now you should see that the two new tables status and transfers have been created and are being populated within your dataset.

Visit the documentation page for more details on using squids with BigQuery.