alitaslimiEvmos Transactions Transaction Count Daily
    Updated 2023-06-02
    select
    block_timestamp::date as "Date",
    count(distinct tx_id) as "Values"
    from
    evmos.core.fact_transactions
    where
    -- block_timestamp::date >= (current_date - 5)
    block_timestamp::date >= '2022-01-01'
    group by
    "Date"
    qualify
    "Date" < last_value("Date") over (order by "Date")
    order by
    "Date"
    Run a query to Download Data