Mrfti2024-03-23 03:40 PM
    Updated 2024-11-12
    select
    date_trunc(day, block_timestamp) as date,
    count(distinct TX_HASH) as "Total transactions",
    sum("Total transactions") over (order by date) as "Cumulative transaction",
    count(distinct ORIGIN_FROM_ADDRESS) as "Total users",
    sum("Total users") over (order by date) as "Cumulative users",
    sum(AMOUNT_USD) as "Total volume (USD)",
    sum ("Total volume (USD)") over (order by date) as "Cumulative volume (USD)"
    from
    base.core.ez_token_transfers
    where
    CONTRACT_ADDRESS = lower('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
    group by 1
    order by 1
    QueryRunArchived: QueryRun has been archived