sum(raw_amount)/pow(10,6) as amnt,

sum (amnt)over(ORDER BY date) as cum,

avg(raw_amount)/pow(10,6) as avg_amnt,

median (raw_amount)/pow(10,6) as median_amnt,

count(DISTINCT origin_from_address) as n_wallets

FROM avalanche.core.fact_token_transfers

WHERE contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

AND block_timestamp >= dateadd('month', -1*{{last_n_month}}, current_date) and block_timestamp <= CURRENT_DATE-1

GROUP BY date

ORDER by date DESC