pecio222total volume sum lfj
Updated 2024-09-24
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
36
›
⌄
with all_data_avax as (
select
CONTRACT_ADDRESS,
POOL_NAME,
platform,
sum(coalesce(AMOUNT_OUT_USD, AMOUNT_IN_USD, 0)) as coalesced
from
avalanche.defi.ez_dex_swaps
where
(
platform = 'trader-joe-v2'
or platform = 'trader-joe-v1'
)
group by
CONTRACT_ADDRESS,
POOL_NAME,
platform
order by
coalesced desc
),
all_data_arbi as (
select
CONTRACT_ADDRESS,
POOL_NAME,
platform,
sum(coalesce(AMOUNT_OUT_USD, AMOUNT_IN_USD, 0)) as coalesced
from
arbitrum.defi.ez_dex_swaps
where
(
platform = 'trader-joe-v2'
or platform = 'trader-joe-v1'
)
group by
CONTRACT_ADDRESS,
POOL_NAME,
QueryRunArchived: QueryRun has been archived