mlhUntitled Query
Updated 2022-11-17
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
›
⌄
select 'claim airdrop' as type,
count(distinct airdrop_claimer) as winner_count,
sum(airdrop_volume) as volume
from (select block_timestamp,
event_inputs:amount/pow(10,18) as airdrop_volume,
event_inputs:recipient as airdrop_claimer
from optimism.core.fact_event_logs
where contract_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and event_name = 'Claimed'
)
group by 1
UNION ALL
select 'unclaim airdrop' as type,
248699 - count(distinct airdrop_claimer) as winner_count,
214748364.8 - sum(airdrop_volume) as volume
from (select block_timestamp,
event_inputs:amount/pow(10,18) as airdrop_volume,
event_inputs:recipient as airdrop_claimer
from optimism.core.fact_event_logs
where contract_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and event_name = 'Claimed'
)
group by 1
Run a query to Download Data