@uniswap/retroactive-query

This repository contains queries that produce the tables of retroactive UNI token distributions.

The queries run in Google BigQuery against the bigquery-public-data.crypto_ethereum dataset.

Data for this dataset is extracted to Google BigQuery using blockchain-etl/ethereum-etl.

Specifications

All queries have a cutoff timestamp of 2020-09-01 00:00:00+00 GMT. Total distribution is aimed at 150_000_000 UNI.

Reproduction

You can reproduce the results of this query by forking this repository and adding your own secrets to run in your own GCP account.

1. Create a Google Cloud project here
2. Find your Project ID in the Google Cloud console here
3. Fork this repository
4. Add the secret GCP_PROJECT_ID under Settings > Secrets containing your project ID from the GCP dashboard
5. Add the secret GCP_SA_KEY under Settings > Secrets containing the base64 encoded JSON key of a service account
6. Go to the actions tab of your fork
7. Run the workflow (roughly ~7 minutes to complete)
8. Inspect the resulting user_proxy table

Verifier

You can verify that no proxy in defiaver_accounts.json had the airdrop by running:

1. npm install
2. node verify.js