datavortexSub
Updated 2024-12-12
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 token_to_wnear AS (
SELECT
DISTINCT s.tx_hash,
s.symbol_in AS token_in,
s.symbol_out AS token_out, -- wNEAR
s.amount_in_usd AS volume_in,
s.amount_out_usd AS usd_received
FROM
near.defi.ez_dex_swaps s
WHERE
s.symbol_out = 'wNEAR' -- Ensure it's swapped to wNEAR
AND s.amount_in_usd BETWEEN 10000 AND 99999 -- Dolphin size (between 10k to 99k)
AND s.block_timestamp >= '2024-01-01' -- Focus on 2024 swaps
),
subsequent_swaps AS (
SELECT
DISTINCT s.tx_hash,
s.symbol_in AS token_in,
s.symbol_out AS token_out,
s.amount_in_usd AS volume_in,
s.amount_out_usd AS usd_received
FROM
near.defi.ez_dex_swaps s
WHERE
s.symbol_in = 'wNEAR' -- Swap from wNEAR
AND s.symbol_out != 'wNEAR' -- Exclude swaps back to wNEAR
AND s.block_timestamp >= '2024-01-01' -- After January 1, 2024
)
SELECT
tt.token_in || '->wNEAR->' || ss.token_out AS swap_chain,
COUNT(DISTINCT tt.tx_hash) AS distinct_tx_count
FROM
token_to_wnear tt
JOIN
subsequent_swaps ss ON tt.tx_hash = ss.tx_hash
QueryRunArchived: QueryRun has been archived