sum(RAW_AMOUNT / 1e6) as USD_AMOUNT,

avg(RAW_AMOUNT / 1e6) as avg_AMOUNT,

median(RAW_AMOUNT / 1e6) as median_AMOUNT,

count(distinct ORIGIN_FROM_ADDRESS) as users,

count(distinct TX_HASH) as txns,

USD_AMOUNT/users as amt_per_user,

txns/users as txns_per_user

FROM BSC.core.fact_token_transfers

WHERE tx_hash in (

SELECT tx_hash

FROM BSC.core.fact_token_transfers

WHERE to_address ilike '0xce16f69375520ab01377ce7b88f5ba8c48f8d666')

and contract_address LIKE lower('0x4268B8F0B87b6Eae5d897996E6b845ddbD99Adf3')

and BLOCK_TIMESTAMP >= CURRENT_DATE - 10