freemartianPika Airdrop - All Claimers
Updated 2023-08-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from PIKA airdrop - Hourly stats @ https://flipsidecrypto.xyz/edit/queries/f80f038b-ed37-41f0-ab1a-fbbbcbe97a44
-- forked from PIKA airdrop - Total @ https://flipsidecrypto.xyz/edit/queries/c431c744-6871-46c3-939e-cfd723719914
-- select * from optimism.core.ez_token_transfers
-- where tx_hash = '0x4cfb9e104bc1287ee3601147c702993987b6e34f9d30ab8fe9f22486ddeb41e9'
select
to_address,
sum(amount) as esPIKA_Claimed
from optimism.core.ez_token_transfers
where from_address = '0x67a9e34a763395266612ffc8c9305eb2fca4d4be'
and contract_address = '0x1508fbb7928aedc86bee68c91bc4afcf493b0e78'
and origin_function_signature = '0x3d13f874'
group by to_address
order by esPIKA_Claimed desc
Run a query to Download Data