SELECT

date_trunc('day', s.block_timestamp) AS date,

s.tx_id,

s.swapper,

coalesce(l1.label, s.swap_from_mint) AS sold,

swap_from_amount,

coalesce(l2.label, s.swap_to_mint) AS bought,

swap_to_amount

FROM

solana.core.fact_transfers t

JOIN solana.defi.fact_swaps_jupiter_summary s

ON s.tx_id = t.tx_id

LEFT JOIN solana.core.dim_labels l1

on l1.address = s.swap_from_mint

LEFT JOIN solana.core.dim_labels l2

on l2.address = s.swap_to_mint

WHERE 1 = 1

AND t.tx_to = 'GbKKt2QquzQkGDeXH8Fdw1DjP1UMhszy7L4AHh68EFyw'

date,

COUNT(tx_id) AS daily_swaps,

SUM(daily_swaps) OVER (ORDER BY date) AS cumulative_swaps

FROM swaps

GROUP BY date

ORDER BY date DESC;