block_timestamp::date as date,

SWAP_PROGRAM,

Sum(SWAP_TO_AMOUNT) as from_Sol_swap

from solana.core.fact_swaps

where SUCCEEDED = 'TRUE'

and SWAP_TO_MINT = 'So11111111111111111111111111111111111111112'

and date >= CURRENT_DATE - {{period}}

group by 1 , 2