CHAIN | DAU | TOTAL | CUMULATIVE_TOTAL | |
|---|---|---|---|---|
1 | arb | 576671 | 6315467566.58 | 73449620045.91 |
2 | avax | 2162543 | 66942183561.2 | 67134152479.33 |
3 | bsc | 191510 | 186338012.66 | 191968918.13 |
4 | eth | 919 | 5630905.47 | 5630905.47 |
Trader JoeTrader Joe Dex total vol
Updated 2024-02-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select chain,DAU, total,sum(total) over (order by chain desc) cumulative_total
from (
select sum(amount_in_usd) as total, 'arb' as chain,count (distinct ORIGIN_FROM_ADDRESS) as DAU from arbitrum.defi.ez_dex_swaps where (platform LIKE '%trader%' )
-- Union all
-- select sum(amount_in_usd) as total, 'arb v2' as chain from arbitrum.defi.ez_dex_swaps where platform LIKE ('trader-joe-v2')
-- Union all
-- select sum(amount_in_usd) as total, 'arb v1' as chain from arbitrum.defi.ez_dex_swaps where platform like ('trader-joe-v1')
union all
select sum(amount_in_usd) as total, 'avax' as chain, count (distinct ORIGIN_FROM_ADDRESS) as DAU from avalanche.defi.ez_dex_swaps where (platform LIKE '%trader%' )
union all
select sum(amount_in_usd) as total, 'eth' as chain,count (distinct ORIGIN_FROM_ADDRESS) as DAU from ethereum.defi.ez_dex_swaps where (platform LIKE '%trader%' )
union all
select sum(amount_in_usd) as total, 'bsc' as chain,count (distinct ORIGIN_FROM_ADDRESS) as DAU from bsc.defi.ez_dex_swaps where (platform LIKE '%trader%' )
)
order by chain asc
Last run: about 1 year ago
4
166B
15s