MahrooUntitled Query
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select block_timestamp::date as date,
count (distinct event_inputs:recipient) as Claimers,
sum (event_inputs:amount/1e18) as Claimed_Volume,
avg (event_inputs:amount/1e18) as AVG_Claimed_Volume,
min (event_inputs:amount/1e18) as Min_Claimed_Volume,
max (event_inputs:amount/1e18) as Max_Claimed_Volume,
214748364.80::numeric as Total_Airdrop_Volume,
248699::numeric as Total_Eliglble_Users,
(claimers/Total_Eliglble_Users)*100 as Claimers_Ratio,
(Claimed_Volume/Total_Airdrop_Volume)*100 as Claimed_Ratio,
Total_Eliglble_Users - Claimers as Remaining_Users,
Total_Airdrop_Volume - Claimed_Volume as Remaining_Volume
from optimism.core.fact_event_logs
where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and origin_function_signature = '0x2e7ba6ef'
and event_name = 'Claimed'
group by 1
order by 1
--and tx_hash = '0xf82170fc6323da072a808f91769ab751c06338b9dfed20256988cf456ea6750b'
Run a query to Download Data