-- forked from Motilola / Jupiter swap v6 : No of transaction @ https://flipsidecrypto.xyz/Motilola/q/3vJZd7ZKlJgO/jupiter-swap-v6-no-of-transaction
SELECT
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