Updated 2024-04-10
    select
    date_trunc('day',block_timestamp) as day,
    count(distinct TX_FROM) as DAU
    from osmosis.core.fact_transactions
    where block_timestamp >= '2023-01-01'
    and block_timestamp < '2024-03-16'
    and TX_SUCCEEDED = 'TRUE'
    group by 1
    order by 1 desc
    QueryRunArchived: QueryRun has been archived