Chuqs_emxtxSwap Average
Updated 2024-09-28
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 coq AS (
SELECT
COUNT(DISTINCT tx_hash) AS number_swaps,
SUM(AMOUNT_IN_USD) AS swap_volume,
AVG(AMOUNT_IN_USD) AS average_swap_volume,
COUNT(DISTINCT origin_from_address) AS number_of_traders
FROM avalanche.defi.ez_dex_swaps
WHERE block_timestamp >= '2024-01-01'
AND SYMBOL_IN = 'COQ' OR SYMBOL_OUT = 'COQ'
),
kimbo AS (
SELECT
COUNT(DISTINCT tx_hash) AS number_swaps,
SUM(AMOUNT_IN_USD) AS swap_volume,
AVG(AMOUNT_IN_USD) AS average_swap_volume,
COUNT(DISTINCT origin_from_address) AS number_of_traders
FROM avalanche.defi.ez_dex_swaps
WHERE block_timestamp >= '2024-01-01'
AND SYMBOL_IN = 'KIMBO' OR SYMBOL_OUT = 'KIMBO'
),
nochill AS (
SELECT
COUNT(DISTINCT tx_hash) AS number_swaps,
SUM(AMOUNT_IN_USD) AS swap_volume,
AVG(AMOUNT_IN_USD) AS average_swap_volume,
COUNT(DISTINCT origin_from_address) AS number_of_traders
FROM avalanche.defi.ez_dex_swaps
WHERE block_timestamp >= '2024-01-01'
AND SYMBOL_IN = 'NOCHILL' OR SYMBOL_OUT = 'NOCHILL'
),
GEC AS (
SELECT
COUNT(DISTINCT tx_hash) AS number_swaps,
SUM(AMOUNT_IN_USD) AS swap_volume,
AVG(AMOUNT_IN_USD) AS average_swap_volume,
COUNT(DISTINCT origin_from_address) AS number_of_traders
QueryRunArchived: QueryRun has been archived