binhachonGMT Airdrop - Airdrop summary
Updated 2022-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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