date_trunc('week', BLOCK_TIMESTAMP) AS Weekly,

CASE WHEN currency = 'uosmo' THEN 'OSMO'

WHEN currency = 'uion' THEN 'ION' END AS token_type,

sum(amount/pow(10,DECIMAL)) AS total_amount,

COUNT(tx_id) AS total_txs,

COUNT(DISTINCT sender) AS total_claimers

FROM osmosis.core.fact_airdrop

WHERE (currency = 'uosmo' OR currency = 'uion') AND TX_STATUS='SUCCEEDED' AND TRANSFER_TYPE='AIRDROP'

GROUP BY 1, 2

ORDER BY 1