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

),

total_sells AS (

SELECT

s.block_timestamp AS swap_timestamp,

s.swapper,

s.tx_id,

s.swap_to_mint,

s.swap_to_amount,

s.swap_from_mint

FROM

solana.defi.fact_swaps s

JOIN giga_tokens g ON s.swap_from_mint = g.swap_to_mint

WHERE

s.block_timestamp > '2024-09-02 00:00:00'

AND s.swap_to_mint = 'So11111111111111111111111111111111111111112'

AND s.succeeded = TRUE

),

total_buys AS (

SELECT

s.block_timestamp AS swap_timestamp,

s.swapper,

s.tx_id,

s.swap_to_mint,

s.swap_from_mint,

s.swap_from_amount

FROM