date_trunc('day', BLOCK_TIMESTAMP) as time,

count("TX_HASH") as "ERC20 token transafer",

count(distinct "ORIGIN_FROM_ADDRESS") as "Sender count",

count(distinct "ORIGIN_TO_ADDRESS") as "Receive count",

count(distinct "ORIGIN_FROM_ADDRESS") + count(distinct "ORIGIN_TO_ADDRESS") AS "Active ERC-20 Addresses",

SUM("ERC20 token transafer") OVER (ORDER BY time) AS "Total token transfer for current interval",

SUM("Sender count") OVER (ORDER BY time) AS "Senders count for current interval",

SUM("Receive count") OVER (ORDER BY time) AS "Receive count for current interval",

SUM("Active ERC-20 Addresses") OVER (ORDER BY time) AS "Active ERC-20 Addresses for current interval"

FROM polygon.core.fact_token_transfers

where BLOCK_TIMESTAMP >= CURRENT_DATE() - interval '90 days'

group by time

order by time desc