Transactions | Swappers | Pairs | Volume | Assets | Largest Trade Amount | Average Trade Amount | |
|---|---|---|---|---|---|---|---|
1 | 6714190 | 129504 | 623 | 12425485224.17 | 238 | 2274012.845 | 1859.495737045 |
i_danPharaoh: Total
Updated 2025-03-10
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
›
⌄
SELECT
Count(*) AS "Transactions"
, Count(DISTINCT origin_from_address) AS "Swappers"
, COUNT(DISTINCT pool_name) AS "Pairs"
, SUM(CASE WHEN amount_in_usd IS NOT NULL AND amount_out_usd IS NOT NULL THEN (amount_in_usd+amount_out_usd)/2
WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) AS "Volume"
, COUNT(DISTINCT symbol) AS "Assets"
, MAX(CASE WHEN amount_in_usd IS NOT NULL AND amount_out_usd IS NOT NULL THEN (amount_in_usd+amount_out_usd)/2
WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) AS "Largest Trade Amount"
, AVG(CASE WHEN amount_in_usd IS NOT NULL AND amount_out_usd IS NOT NULL THEN (amount_in_usd+amount_out_usd)/2
WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) AS "Average Trade Amount"
FROM (
SELECT
platform
, symbol_in AS symbol
, origin_from_address
, pool_name
, amount_in_usd
, amount_out_usd
FROM avalanche.defi.ez_dex_swaps
WHERE platform LIKE '%pharaoh%'
UNION ALL
SELECT
platform
, symbol_out AS symbol
, origin_from_address
, pool_name
, amount_in_usd
, amount_out_usd
FROM avalanche.defi.ez_dex_swaps
WHERE platform LIKE '%pharaoh%'
)
--GROUP BY 1
--ORDER BY 2 DESC
Last run: about 2 months ago
1
68B
4s