jun88899living-amaranth
Updated 2024-12-28
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
›
⌄
SELECT DISTINCT swap_from_mint FROM solana.defi.fact_swaps
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '14 days'
AND
swapper = '687kTFNvKG9GXf8UsPzyrKbKpz5ExNrSCWfs7S4PTGiL'
-- SELECT * FROM solana.defi.fact_swaps
-- LIMIT 100
-- WITH unique_mint_to_addresses AS (
-- SELECT DISTINCT mint_to_address
-- FROM solana.defi.fact_swaps
-- WHERE
-- block_timestamp >= CURRENT_DATE - INTERVAL '14 days'
-- AND swapper = '687kTFNvKG9GXf8UsPzyrKbKpz5ExNrSCWfs7S4PTGiL'
-- )
-- SELECT *
-- FROM solana.defi.fact_swaps
-- WHERE
-- block_timestamp >= CURRENT_DATE - INTERVAL '14 days'
-- AND swap_from_mint IN (SELECT mint_to_address FROM unique_mint_to_addresses)
-- AND swap_to_mint IN (SELECT mint_to_address FROM unique_mint_to_addresses);
WITH unique_swap_to_mint AS (
SELECT DISTINCT swap_to_mint
FROM solana.defi.fact_swaps
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '14 days'
AND swapper = '687kTFNvKG9GXf8UsPzyrKbKpz5ExNrSCWfs7S4PTGiL'
),
filtered_rows AS (
SELECT
block_timestamp,
ROW_NUMBER() OVER (ORDER BY block_timestamp) AS row_num
FROM
solana.defi.fact_swaps
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '14 days'
QueryRunArchived: QueryRun has been archived