ChiefSWAPS
Updated 2023-05-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Sales @ https://flipsidecrypto.xyz/edit/queries/92c1ce56-5f20-4c02-9363-a4673c42d306
-- program_id = E1XRkj9fPF2NQUdoq41AHPqwMDHykYfn5PzBXAyDs7Be
-- this tx went through but had an "error" for part of it tx_id = 2GNs1XJqHEtj4Yn5oWQAdk56ySskEmx6rECtZ8AF38u5eUo3kjjPr8m3AGC1tsRbFNgSxcrLQe4MnXFtTYtLLJJ4
-- this could be the ovals royalty address ovo1kT7RqrAZwFtgSGEgNfa7nHjeZoK6ykg1GknJEXG
-- with events as (
-- SELECT tx_id
-- -- ,
-- -- instruction:programId as program_id
-- FROM solana.core.fact_events
-- -- FROM solana.core.fact_transactions
-- WHERE program_id = 'E1XRkj9fPF2NQUdoq41AHPqwMDHykYfn5PzBXAyDs7Be'
-- AND block_timestamp > current_date - 2
-- LIMIT 50
-- )
with swaps as
(SELECT *
FROM solana.core.fact_swaps s
-- JOIN events
-- ON s.tx_id = events.tx_id
WHERE s.block_timestamp > current_date - 2
AND swap_to_mint = 'DjzG1gPn2cotdV9cvkho4KxD3Poy2VjJeghCivv8U8Wj'
or swap_from_mint = 'DjzG1gPn2cotdV9cvkho4KxD3Poy2VjJeghCivv8U8Wj'
ORDER BY s.tx_id
LIMIT 20)
SELECT *
FROM swaps
JOIN solana.core.fact_events e
ON e.tx_id = swaps.tx_id
WHERE e.block_timestamp > current_date - 2
Run a query to Download Data