SELECT SUM(swap_to_amount_usd) AS swap_amount_usd

, COUNT(DISTINCT fs.tx_id) AS cnt_tx

, COUNT(DISTINCT fs.swapper) AS cnt_users

FROM solana.defi.ez_dex_swaps fs

WHERE TRUE

AND block_timestamp::DATE BETWEEN DATEADD(day, -{{days_to_look_back}}, current_date()) AND current_date() - 1

SELECT *

FROM dest_swap