0xBlackfish2023-11-06 11:01 PM
Updated 2023-11-07
9
1
2
3
4
5
6
7
8
9
›
⌄
select ft.*
from solana.core.fact_events fe
inner join solana.core.fact_transactions ft using(tx_id, block_timestamp, succeeded)
where
fe.succeeded
and fe.program_id = 'dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH'
--and date(fe.block_timestamp) = date('2023-10-31')
and fe.tx_id = '2SJpkCXcb9mpFmPLTS6rPyUrVH8Fje65uh2cB6QxZRxmbbfKik9V9H74Mn3BjATUQ7vwgaZ1mBXkJW5LLNGfpxVY'
limit 100
Run a query to Download Data