freemartianPIKA airdrop - Hourly Claim stats
Updated 2023-09-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 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
sum(amount) as Total_PIKA_Claimed,
count(distinct to_address) as Claimers_Count,
date_trunc('hour', block_timestamp) as time
from optimism.core.ez_token_transfers
where from_address = '0x67a9e34a763395266612ffc8c9305eb2fca4d4be'
and contract_address = '0x1508fbb7928aedc86bee68c91bc4afcf493b0e78'
and origin_function_signature = '0x3d13f874'
group by time
Run a query to Download Data