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)

select avg (claimers), avg (claimed_volume) from t1