PapasotGardian airdrop & staking overlap
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with gardian_airdrops as(
SELECT
asset_receiver,
asset_amount as Gardian_airdrop_rewards
from algorand.asset_transfer_transaction
where sender = 'B7YLKLF7FGTURCSGOPO2GHTLEQKXEQHVTIMFOZWBYUY55RDGTADQDS3ICI'
and asset_transferred = '692432647'
and block_timestamp > '2022-05-06'
and block_timestamp < '2022-05-08'
)
SELECT
count(b.sender) as staking_airdrop_overlap
from algorand.asset_transfer_transaction b
left join gardian_airdrops a on a.asset_receiver = b.sender
where b.asset_receiver = '4ZK3UPFRJ643ETWSWZ4YJXH3LQTL2FUEI6CIT7HEOVZL6JOECVRMPP34CY'
and b.asset_transferred = '684649988'
and b.sender = a.asset_receiver
Run a query to Download Data