DAY | TRADERS | VOLUME | SWAPS | |
|---|---|---|---|---|
1 | 2025-03-31 00:00:00.000 | 182427 | 701114874.882001 | 2908461 |
2 | 2025-03-30 00:00:00.000 | 210123 | 718127630.352387 | 3618721 |
3 | 2025-03-29 00:00:00.000 | 234801 | 690376017.003947 | 3940671 |
4 | 2025-03-27 00:00:00.000 | 275095 | 804643478.050844 | 4116786 |
5 | 2025-03-25 00:00:00.000 | 297094 | 962824146.479703 | 4012794 |
6 | 2025-03-23 00:00:00.000 | 348200 | 657920616.68659 | 4046442 |
7 | 2025-03-24 00:00:00.000 | 375441 | 1034759035.7265 | 4725920 |
8 | 2025-03-26 00:00:00.000 | 303197 | 937264294.650612 | 4217998 |
9 | 2025-03-28 00:00:00.000 | 256697 | 1002544542.87751 | 3999778 |
Hashflownjk
Updated 3 days ago
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 base AS (
SELECT
tx_id,
block_id,
swap_from_mint,
swap_to_mint,
swap_from_amount,
swap_to_amount,
swap_from_amount_usd,
swap_to_amount_usd
FROM solana.defi.ez_dex_swaps
WHERE block_timestamp >= DATE_TRUNC('day', DATEADD(day, -8, CURRENT_TIMESTAMP()))
),
flattened AS (
SELECT
tx_id,
block_id,
swap_from_mint AS address,
COALESCE(swap_from_amount_usd, swap_to_amount_usd) / NULLIF(swap_from_amount, 0) AS price
FROM base
UNION ALL
SELECT
tx_id,
block_id,
swap_to_mint AS address,
COALESCE(swap_to_amount_usd, swap_from_amount_usd) / NULLIF(swap_to_amount, 0) AS price
FROM base
),
prices AS (
SELECT
address,
tx_id,
block_id,
MAX(price) AS price
Last run: 3 days ago
9
539B
76s