NakedCollectorSOLANA: Tokens That Have Rebounded 4h vs. 24h
Updated 2024-08-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 last_24h_data AS (
SELECT
SWAP_TO_MINT as "Address",
SWAP_TO_SYMBOL as "Token",
COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) as "Bought_24h",
COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Sold_24h",
COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) - COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Net_24h"
FROM
solana.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '24 hours'
GROUP BY
1, 2
),
last_12h_data AS (
SELECT
SWAP_TO_MINT as "Address",
SWAP_TO_SYMBOL as "Token",
count (distinct SWAPPER) as "Unique Swapper (12h)",
COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) as "Bought_12h",
COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Sold_12h",
COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) - COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Net_12h"
FROM
solana.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '4 hours'
GROUP BY
1, 2
)
SELECT
l12."Address",
l12."Token",
l12."Unique Swapper (12h)",
(l12."Bought_12h" + l24."Bought_24h")as "Bought",
(l12."Sold_12h" + l24."Sold_24h")as "Sold",
(l12."Net_12h" + l24."Net_24h")as "Net",
QueryRunArchived: QueryRun has been archived