elsinadaily activity
    Updated 2024-10-01
    SELECT
    date_trunc('month', block_timestamp) as date,
    count(DISTINCT origin_from_address) as user_count,
    count(DISTINCT tx_hash) as tx_count,
    count(distinct program_name) as program_count,
    sum(amount_usd) as total_vol,
    avg(amount_usd) as avg_stake_vol,
    sum(total_vol) over (order by date) as cum_total_vol,
    sum(tx_count) over (order by date) as cum_tx_count
    from
    crosschain.olas.ez_olas_staking
    group by
    date
    order by
    date asc

    QueryRunArchived: QueryRun has been archived