MLDZMNbond_overtime
    Updated 2025-02-16
    select
    DATE_TRUNC('Month', BLOCK_TIMESTAMP) AS date,
    count(distinct tx_hash) as no_bonds,
    count(distinct ORIGIN_FROM_ADDRESS) as bonders,
    sum(OLAS_AMOUNT) as vol_olas,
    sum(OLAS_AMOUNT_USD) as vol_usd,
    vol_olas/bonders as avg_olas_per_bonder,
    avg(OLAS_AMOUNT) as avg_vol_olas
    from crosschain.olas.ez_olas_bonding
    group by 1
    order by 1 desc

    QueryRunArchived: QueryRun has been archived