date_trunc('day', block_timestamp) as date

, swap_program

, count(1) as txs

from solana.defi.fact_swaps

where succeeded

and block_timestamp > current_date() - 7

group by 1,2