keean82clever-plum
Updated 2024-09-04
999
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 giga_tokens AS (
SELECT
swap_to_mint,
COUNT(tx_id) as tx_id_count
FROM
solana.defi.fact_swaps
GROUP BY
swap_to_mint
HAVING
tx_id_count > 10000
),
all_sells AS (
SELECT DISTINCT
s.block_timestamp AS swap_timestamp,
s.swapper,
s.tx_id,
s.swap_from_mint,
s.swap_to_mint,
s.swap_from_amount,
s.swap_to_amount
FROM
solana.defi.fact_swaps s
JOIN giga_tokens g ON s.swap_from_mint = g.swap_to_mint
WHERE
date_trunc('day', s.block_timestamp) = '2024-09-04 00:00:00'
AND s.swap_to_mint = 'So11111111111111111111111111111111111111112'
AND s.succeeded = TRUE
AND s.swap_to_amount > 0.0001
),
total_buys AS (
SELECT DISTINCT
s.block_timestamp AS swap_timestamp,
s.swapper,
s.tx_id,
s.swap_to_mint as the_mint,
s.swap_from_mint,
QueryRunArchived: QueryRun has been archived