Eman-RazNumber of Users & Transactions Over Time
    Updated 2024-05-10
    select date_trunc('{{Time_Frame}}',created_at) as "Date", count(distinct id) as "TXs Count",
    sum("TXs Count") over (order by "Date") as "Total TXs Count", count(distinct call:transaction:from) as "Users Count"
    from axelar.axelscan.fact_gmp
    where call ilike '%0xD0FFD6fE14b2037897Ad8cD072F6d6DE30CF8e56%' and created_at between '{{Start_Date}}' and '{{End_Date}}'
    group by 1
    order by 1
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived