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

solana.defi.fact_swaps s

WHERE

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

AND s.swap_from_mint = 'So11111111111111111111111111111111111111112'

AND s.swap_from_amount > 0.1

AND s.succeeded = TRUE

),

token_creations AS (

SELECT

mint AS created_mint,

block_timestamp AS creation_timestamp

FROM

solana.defi.fact_token_mint_actions

WHERE

event_type = 'initializeMint2'

AND block_timestamp > '2024-09-05 00:00:00'

),

recent_buys AS (

SELECT

tb.swap_timestamp,

tb.swapper,

tb.tx_id,

tb.swap_to_mint,

tb.swap_from_mint,

tb.swap_from_amount,

tc.creation_timestamp

FROM