MLDZMNSource chains
    Updated 2025-02-11
    select
    p.SOURCE_CHAIN,
    count(distinct p.tx_hash) as bonds,
    sum(OLAS_AMOUNT) as vol_olas,
    avg(OLAS_AMOUNT) as avg_vol_olas,
    count(distinct p.ORIGIN_FROM_ADDRESS) as bonders,
    vol_olas/bonders as avg_bond_per_bonders

    from crosschain.olas.fact_pol_transfers p
    left join crosschain.olas.ez_olas_bonding b on b.tx_hash = p.tx_hash
    where p.BLOCK_TIMESTAMP >= current_date - 90
    group by 1
    QueryRunArchived: QueryRun has been archived