PLATFORM | TOTAL_VOLUME | |
---|---|---|
1 | trader-joe-v2 | $ 3,979,835 |
2 | pharaoh-v2 | $ 1,585,554 |
3 | balancer | $ 80,201 |
4 | wombat | $ 3,137 |
5 | uniswap-v3 | $ 22 |
GoGoPoolggAVAX 7 Day Volume Per Platform
Updated 2 days ago
999
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 ggAVAX_swaps_excl_wom as (
SELECT
DATE_TRUNC('hour', block_timestamp) AS hour,
CASE
WHEN token_in = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN amount_in
WHEN token_out = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN amount_out
END AS ggAVAX_volume,
platform
FROM
avalanche.defi.ez_dex_swaps
WHERE
(
token_in = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
OR token_out = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
)
),
ggAVAX_wom_swaps as (
SELECT
DATE_TRUNC('hour', block_timestamp) as hour,
CASE
WHEN decoded_log:fromToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN decoded_log:fromAmount / 1e18
WHEN decoded_log:toToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN decoded_log:toAmount / 1e18
END AS ggAVAX_volume,
'wombat' as platform
FROM
avalanche.core.fact_decoded_event_logs
WHERE
contract_address = '0xbba43749efc1bc29ea434d88ebaf8a97dc7aeb77'
AND event_name = 'Swap'
AND (
decoded_log:fromToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
OR decoded_log:toToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
)
),
ggAVAX_swaps as (
SELECT
Last run: 2 days ago
5
153B
3s