select tx_id

from solana.core.fact_events

where program_id='SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

AND succeeded = true

), vol as (

select

date_trunc('day', block_timestamp) as date,

sum(instructions[0]:parsed:info:amount/1e8) as volome

from solana.core.fact_transactions inner join swim on swim.tx_id=solana.core.fact_transactions.tx_id

group by DATE

select

sum(volome) as volume

from vol