superflyUniswap USDC airdrop
Updated 2022-12-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select BLOCK_TIMESTAMP::date date,
count(EVENT_INPUTS:recipient) user,
sum(EVENT_INPUTS:amount / 1e6) amount
from ethereum.core.fact_event_logs
where 1=1 --tx_hash = '0xf455823f1f16bae178c3f1744a48fd34221fb39f4a3d6818ea3a190339a87571'
and EVENT_NAME = 'Claimed'
and TX_STATUS = 'SUCCESS'
and CONTRACT_ADDRESS = '0x8b799381ac40b838bba4131ffb26197c432afe78'
group by 1
order by 1
Run a query to Download Data