select 1e9 as Total_APE_Supply,

150000000 as Airdrop_Amount,

(Airdrop_Amount/Total_APE_Supply) * 100 as Airdrop_Ratio,

count (distinct tx_hash) as TX_Count,

count (distinct origin_from_address) as Users_Count,

sum (event_inputs:value/1e18) as Claimed_Ape_Volume,

(Claimed_Ape_Volume / Airdrop_Amount)*100 as Received_Ratio,

Airdrop_Amount - Claimed_Ape_Volume as Remaining_Volume,

(Remaining_Volume / Airdrop_Amount)*100 as Remaining_Ratio,

avg (event_inputs:value/1e18) as Average_APE_Volume,

median (event_inputs:value/1e18) as Median_APE_Volume,

min (event_inputs:value/1e18) as Minimum_APE_Volume,

max (event_inputs:value/1e18) as Maximum_APE_Volume

from ethereum.core.fact_event_logs

where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'

and event_name = 'Transfer'

and origin_function_signature = '0x48c54b9d'

and tx_status = 'SUCCESS'