dr1888Daily and cumulative DEXALOT count of transcation
    Updated 2023-03-11
    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
    Run a query to Download Data