Skip to content

StakeDAO/airdrop

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 

Repository files navigation

airdrop

Airdrop files

Gitcoin 8

The data was indexed in Gitcoin database which is managed by an open source codebase: https://github.com/gitcoinco/web/ to include the zk list which couldn't be fetched from endpoint.

Script:

select 
    distinct admin_address
from grants_grant
union
select 
    distinct contributor_address
from 
    grants_subscription

Data was verified by Gitcoin Team.

Fix for ZkSync:

select 
    distinct contributor_address
from 
    grants_subscription
INNER JOIN grants_contribution
ON grants_contribution.subscription_id = grants_subscription.id
where checkout_type = 'eth_zksync'
and grants_subscription.created_on < '2020-12-17'

Releases

No releases published

Packages

No packages published