1673646668 as total_supply, -- 1,673,646,668

86633159 as airdrop_amt, -- 86,633,159

count(distinct To_ADDRESS) as claimers ,

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

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

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

round(min(amount),2) as min_volume,

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

86633159 - volume as unclaimed_amount,

(volume * 100)/86633159 as claimed_percentage,

(86633159 * 100)/1673646668 as ratio

distinct TO_ADDRESS ,

sum(amount) as amount

from ethereum.core.ez_token_transfers

where contract_address = lower('0xec53bf9167f50cdeb3ae105f56099aaab9061f83')

and FROM_ADDRESS = lower('0xa105c3abedbaf4295ac6149bf24d5311f629934c')

group by 1)

where amount > 0

group by 1,2