binhachonGMT Airdrop - Airdrop summary
    Updated 2022-03-22
    with tx as (
    select
    distinct tx_id, block_timestamp, pretokenbalances, posttokenbalances
    from solana.events
    where block_timestamp::date >= '2022-03-15' --tx_id = '33jvVyBGqxqGuXswGD7w82PfEVBYX8BZ1QvA7c7fBGdxdJ4m7jLbBbFKnfwEbYQdVfxSrm75MSSAZzDwjgtN8tu5'
    and instruction:programId::string = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
    -- and event_type = 'transfer'
    and succeeded = 'TRUE'
    and instruction:parsed:info:source::string = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
    and instruction:parsed:info:authority::string = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    ),
    pretokenbalances as (
    select
    tx_id,
    block_timestamp,
    value:owner::string as owner,
    value:uiTokenAmount:uiAmount::float as amount
    -- split(key, '_')[0] as number,
    -- split(key, '_')[1]::string as type
    from tx
    ,LATERAL flatten( input => pretokenbalances )
    where owner != 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    ),
    posttokenbalances as (
    select
    tx_id,
    block_timestamp,
    value:owner::string as owner,
    value:uiTokenAmount:uiAmount::float as amount
    -- split(key, '_')[0] as number,
    -- split(key, '_')[1]::string as type
    from tx
    ,LATERAL flatten( input => posttokenbalances )
    where owner != 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    ),
    airdrop_total as (
    Run a query to Download Data