ben-wyattaggregate-all
Updated 2025-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
›
⌄
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