distinct TO_ADDRESS as claimer,

sum(amount) as Claimed_Amount

from ethereum.core.ez_token_transfers

where CONTRACT_ADDRESS = lower('0x63696Fc66795B51d02c1590b536484A41fbDDF9a')

and FROM_ADDRESS in ('0x3db08a08434bfb774271e46d277468f8da0da144')

and ORIGIN_FUNCTION_SIGNATURE = '0xf0fd1084'

group by 1

select

42000000000 as "Total Supply", -- 42,000,000,000

6846000000 as "Circulating Supply", --6,846,000,000

20 as allocation,

1260000000 as "Claimable Amount",

count(distinct claimer) as claimers ,

round(sum(claimed_amount),0) as volume ,

round(avg(claimed_amount),0) as avg_volume,

round(max(claimed_amount),0) as max_volume,

round(min(claimed_amount),0) as min_volume,

round(median(claimed_amount),0) as median_volume,

round(1260000000 - volume,0) as unclaimed_amount,

round((volume * 100)/1260000000,1) as claimed_percentage,

round((1260000000*100)/42000000000,1) as ratio

from claimert