Specterdex aggrgate
Updated 2024-11-15
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
›
⌄
WITH dex_swap AS (
SELECT
block_timestamp,
event_name, amount_in_usd, sender,
platform,
tx_hash
FROM
blast.defi.ez_dex_swaps
WHERE
(
token_in = '0x4300000000000000000000000000000000000003'
OR token_out = '0x4300000000000000000000000000000000000003'
)
AND amount_in_usd != 0
)
SELECT
SUM(amount_in_usd) AS Amount_usd,
COUNT(DISTINCT tx_hash) AS tx_count,
COUNT(DISTINCT sender) AS swappers
FROM
dex_swap
ORDER BY
Amount_usd DESC;
QueryRunArchived: QueryRun has been archived