ben-wyattaggregate-all
    Updated 2025-02-07
    with all_chains as (
    select *, 'arbitrum' as chain
    from $query('b2ca9bcc-0363-4397-b56a-9b6a9bb50cd2')
    union all
    select *, 'avalanche' as chain
    from $query('0a36f04d-89f6-4f0a-95ef-4d1d6092d64b')
    union all
    select *, 'base' as chain
    from $query('fe92bf46-7561-46a7-ae0c-c076e6295742')
    union all
    select *, 'bsc' as chain
    from $query('a13e879e-8161-4e11-9cce-527336633d22')
    union all
    -- select *, 'cosmos' as chain
    -- from
    -- union all
    select *, 'ethereum' as chain
    from $query('6ed3c699-c3a5-46f9-ab50-53181a3e1e66')
    union all
    -- select *, 'near' as chain
    -- from
    -- union all
    select *, 'polygon' as chain
    from $query('50b7989d-771d-414f-bd5e-ad4bfb88bd8d')
    -- union all
    -- select *, 'solana' as chain
    -- from


    )
    select *
    from all_chains
    where tx_vol_usd >1e6;


    QueryRunArchived: QueryRun has been archived