select
BLOCK_TIMESTAMP::Date as BTD,
count(TX_HASH) as CTH,
sum(CTH) over (order by BTD)
from
avalanche.core.fact_token_transfers
JOIN
avalanche.core.dim_contracts
ON
avalanche.core.fact_token_transfers.contract_address=avalanche.core.dim_contracts.address
where symbol = 'ALOT'
group by 1