geektechblushing-cyan
Updated 2024-07-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
⌄
⌄
-- forked from Same Block - defi_fact_swaps @ https://flipsidecrypto.xyz/studio/queries/d832198a-4a18-4967-9fc3-2be939735477
/*
select * from solana.defi.fact_swaps
where swap_to_mint = 'So11111111111111111111111111111111111111111'
or swap_from_mint = 'So11111111111111111111111111111111111111111'
limit 100
*/
/*
select * from solana.defi.fact_swaps where tx_id = '3KukFg254HKZaWYJ5Uay3yjfBqUC7vAfUu857QH8sjem6vGdGwAXdKms679FUpj9gKciw2YaWFmRfXRvo9qCL3vF'
and block_timestamp > CURRENT_DATE -3
*/
select * from solana.core.fact_events where tx_id = '3KukFg254HKZaWYJ5Uay3yjfBqUC7vAfUu857QH8sjem6vGdGwAXdKms679FUpj9gKciw2YaWFmRfXRvo9qCL3vF'
and block_timestamp > CURRENT_DATE -3
QueryRunArchived: QueryRun has been archived