SELECT

'polygon' as chain,

block_timestamp::date as day,

sum(raw_amount/power(10,6)) as total_volume,

avg(raw_amount/power(10,6)) as avg_volume,

median(raw_amount/power(10,6)) as median_volume,

count(distinct TX_HASH) as tx_count,

count(DISTINCT FROM_ADDRESS) as senders_cnt,

count(DISTINCT TO_ADDRESS) as receivers_cnt

FROM polygon.core.fact_token_transfers

where contract_address =lower('0x2791Bca1f2de4661ED88A30C99A7a9449Aa84174')

and raw_amount/power(10,6)!=0

GROUP BY 1,2

order by 2