ellerydurwinweekly metrics by program name
    Updated 2024-11-05
    select
    date_trunc('week', BLOCK_TIMESTAMP) as date,
    PROGRAM_NAME,
    count(distinct BLOCK_NUMBER) as number_block,
    count(distinct TX_HASH) as number_stakes,
    count(distinct ORIGIN_FROM_ADDRESS) as number_users,
    sum(AMOUNT_USD) as USD_amount_staked,
    from
    crosschain.olas.ez_olas_staking
    group by
    PROGRAM_NAME,
    date



    QueryRunArchived: QueryRun has been archived