headitmanagerGMT Airdrop - What have recipients done with the airdrop
    Updated 2022-03-19
    with wallets0 as (select POSTTOKENBALANCES[0]:owner as owner ,POSTTOKENBALANCES[0]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
    and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
    and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    and POSTTOKENBALANCES[0]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
    and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    )
    , wallets1 as (select POSTTOKENBALANCES[1]:owner as owner ,POSTTOKENBALANCES[1]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
    and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
    and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    and POSTTOKENBALANCES[1]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
    and POSTTOKENBALANCES[1]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    )
    , wallets2 as (select POSTTOKENBALANCES[2]:owner as owner ,POSTTOKENBALANCES[2]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
    and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
    and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    and POSTTOKENBALANCES[2]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
    and POSTTOKENBALANCES[2]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    )
    , wallets3 as (select POSTTOKENBALANCES[3]:owner as owner ,POSTTOKENBALANCES[3]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
    and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
    and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    and POSTTOKENBALANCES[3]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
    and POSTTOKENBALANCES[3]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    )
    , wallets4 as (select POSTTOKENBALANCES[4]:owner as owner ,POSTTOKENBALANCES[4]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
    and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
    and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    and POSTTOKENBALANCES[4]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
    and POSTTOKENBALANCES[4]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    )
    , wallets5 as (select POSTTOKENBALANCES[5]:owner as owner ,POSTTOKENBALANCES[5]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
    and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
    and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    and POSTTOKENBALANCES[5]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
    and POSTTOKENBALANCES[5]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    )
    Run a query to Download Data