BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS as CLAIMER,

EVENT_INPUTS:amount/1E18 AS amount

from ethereum.core.fact_event_logs

where EVENT_NAME = 'Claimed'

and CONTRACT_ADDRESS = '0xe50b2ceac4f60e840ae513924033e753e2366487'

and EVENT_INPUTS:rewardToken = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f')

select

'Across Airdrop' as "Type",

count(distinct tx_hash) as "Number of Claims",

count(distinct claimer) as "Number of Claimers",

sum(amount) as "Volume of ACX Claimed as Airdrop",

("Volume of ACX Claimed as Airdrop"/"Number of Claimers") as "Average ACX Claimed per Each Claimer",

min (amount) as "Minimum ACX Claimed as Airdrop",

avg (amount) as "Average ACX Claimed as Airdrop",

max (amount) as "Maximum ACX Claimed as Airdrop",

("Number of Claims" / count(distinct block_timestamp::date)) as "Number of Claims per Day",

("Volume of ACX Claimed as Airdrop" / count(distinct block_timestamp::date)) as "Volume of ACX Claimed per Day"

from maintable