Date_trunc(day , block_timestamp) AS date,

COUNT(DISTINCT tx_id) AS no_of_transactions

FROM solana.defi.fact_swaps

WHERE swap_program = 'jupiter swap v6'

AND succeeded = 'true'

AND swap_to_amount IS NOT NULL

AND Date >= '2023-01-01'

GROUP BY 1

ORDER BY 2 DESC