date_trunc('d', a.block_timestamp) as date,

mint,

sum(amount) as volume

FROM solana.core.fact_events a

LEFT JOIN solana.core.fact_transfers b using(tx_id)

WHERE program_id = 'CrX7kMhLC3cSsXJdT7JDgqrRVWGnUpX3gfEfxxU2NVLi'

AND mint is NOT NULL

and date > current_date - 30

GROUP BY 1 , 2

ORDER BY 1 DESC

SELECT *

FROM solana.core.fact_liquidity_pool_actions

WHERE tx_id = '2GagD1gL99qAaFqzxZFSnMj3Z1B7io1D3ejtG6tLTYaKqhnJ3JRcPYLXyHDAComtor1tnVyMbbgbQugcdTfjDjiJ'