select

block_timestamp,

tx_hash,

to_address as claimant,

from base.core.ez_token_transfers

where from_address = '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'

and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

and origin_function_signature = '0x69659658'

count(*) as n_claims,

1000000000 as "Total supply",

100000000 as "Initial Community supply",

count(DISTINCT claimant) as n_claimants,

sum(amount) as claimed_amt,

avg(amount) as avg_claimed_amt,

median(amount) as median_claimed_amt,

claimed_amt/1000000000 as "% of TS Claimed",

100 * (sum(amount) / 100000000) as claimed_percentage,

100 - claimed_percentage as unclaimed_percentage

FROM claim_txs