TOTAL_DISTINCT_SWAPS | TOTAL_AMOUNT_USD | TOTAL_WETH_AMOUNT_USD | AVG_SWAP_AMOUNT_USD | ACTIVE_SWAP_DAYS | AVG_DAILY_SWAP_VOLUME_USD | LATEST_SWAP_TIMESTAMP | TOTAL_UNIQUE_TRADERS | AVG_SWAP_VOLUME_PER_TRADER | MAX_SWAP_VOLUME_PER_TRADER | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 266631 | 5188319.51 | 5185542.71 | 19.106806325 | 71 | 73074.922676056 | 2025-03-06 08:37:30.000 | 57598 | 90.078119206 | 10014.2 |
datavortexVolume
Updated 2025-03-06
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 swap_events AS (
SELECT
tx_hash,
origin_to_address AS pool_address,
block_timestamp,
DATE_TRUNC('day', block_timestamp) AS swap_day,
origin_from_address AS trader_address
FROM
ink.core.ez_decoded_event_logs
WHERE
event_name = 'Swap'
AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
AND block_timestamp IS NOT NULL
AND tx_succeeded = TRUE
),
token_transfers AS (
SELECT
tx_hash,
contract_address,
symbol,
amount_usd
FROM
ink.core.ez_token_transfers
),
amounts_with_weth AS (
SELECT
t1.tx_hash,
t1.contract_address,
t1.symbol,
t1.amount_usd,
MAX(CASE WHEN LOWER(t2.symbol) = 'weth' THEN t2.amount_usd END)
OVER (PARTITION BY t1.tx_hash) AS weth_amount_usd,
ROW_NUMBER() OVER (PARTITION BY t1.tx_hash ORDER BY LOWER(t1.symbol) ASC) AS row_num
FROM
Last run: 2 months ago
1
117B
4s