SWAP_DATE | POOL_NAME | Daily Swappers | Daily Swaps | Daily Volume (USD) | |
|---|---|---|---|---|---|
1 | 2025-02-13 00:00:00.000 | AXS / WETH | 408 | 531 | 34843.965718414 |
2 | 2025-02-13 00:00:00.000 | AXS / WRON | 1618 | 2506 | 653658.590267362 |
3 | 2025-02-13 00:00:00.000 | KOKU / WRON | 254 | 399 | 69862.521771573 |
4 | 2025-02-13 00:00:00.000 | SLP / WETH | 130 | 309 | 64698.907747096 |
5 | 2025-02-13 00:00:00.000 | SLP / WRON | 347 | 619 | 197500.862669889 |
6 | 2025-02-13 00:00:00.000 | USDC / WETH | 161 | 351 | 67621.240254377 |
7 | 2025-02-13 00:00:00.000 | USDC / WRON | 697 | 1791 | 1366095.77649348 |
8 | 2025-02-13 00:00:00.000 | WRON / WETH | 1929 | 3342 | 1811296.20197545 |
9 | 2025-02-12 00:00:00.000 | AXS / WETH | 688 | 1167 | 184563.984297726 |
10 | 2025-02-12 00:00:00.000 | AXS / WRON | 2838 | 4161 | 1036445.68930186 |
11 | 2025-02-12 00:00:00.000 | KOKU / WRON | 355 | 646 | 92849.753811695 |
12 | 2025-02-12 00:00:00.000 | SLP / WETH | 205 | 664 | 216236.833184429 |
13 | 2025-02-12 00:00:00.000 | SLP / WRON | 537 | 1162 | 395841.839383493 |
14 | 2025-02-12 00:00:00.000 | USDC / WETH | 380 | 1035 | 101928.393088825 |
15 | 2025-02-12 00:00:00.000 | USDC / WRON | 1058 | 2813 | 1839849.59853178 |
16 | 2025-02-12 00:00:00.000 | WRON / WETH | 2989 | 5267 | 2413813.0979355 |
17 | 2025-02-11 00:00:00.000 | AXS / WETH | 551 | 876 | 81939.767092382 |
18 | 2025-02-11 00:00:00.000 | AXS / WRON | 1905 | 2809 | 405660.614875486 |
19 | 2025-02-11 00:00:00.000 | KOKU / WRON | 673 | 1471 | 303859.250335975 |
20 | 2025-02-11 00:00:00.000 | SLP / WETH | 202 | 510 | 144637.568866363 |
datavortex1:7
Updated 2025-02-13
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_data AS (
SELECT
tx_hash,
contract_name,
contract_address,
origin_from_address,
SPLIT_PART(contract_name, ' - ', 1) AS base_token,
SPLIT_PART(contract_name, ' - ', 2) AS quote_token,
decoded_log:_amount0In::FLOAT AS amount_1_raw,
decoded_log:_amount1In::FLOAT AS amount_2_raw,
DATE_TRUNC('day', block_timestamp) AS swap_date,
CASE
WHEN decoded_log:_amount0In = 0 THEN SPLIT_PART(contract_name, ' - ', 2)
ELSE SPLIT_PART(contract_name, ' - ', 1)
END AS final_token,
CASE
WHEN decoded_log:_amount0In = 0 THEN decoded_log:_amount1In
ELSE decoded_log:_amount0In
END AS final_amount_raw
FROM ronin.core.ez_decoded_event_logs
WHERE event_name = 'Swap'
AND block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
),
pool_data AS (
SELECT
POOL_ADDRESS,
POOL_NAME,
BASE_TOKEN_NAME,
BASE_TOKEN_SYMBOL,
BASE_TOKEN_DECIMALS,
BASE_TOKEN_PRICE_USD,
QUOTE_TOKEN_NAME,
QUOTE_TOKEN_SYMBOL,
QUOTE_TOKEN_DECIMALS,
QUOTE_TOKEN_PRICE_USD
Last run: about 1 month ago
65
4KB
2s