Switchboardtest
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from devops_pyth_ci_checker @ https://flipsidecrypto.xyz/edit/queries/96fcb6dc-b096-4969-b41f-4d6c5f202761
WITH e AS (
SELECT tx_id AS e_id
FROM solana.core.fact_events
WHERE block_timestamp >= CURRENT_DATE - 1
AND program_id = 'FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe4975bi2epH'
AND instruction:accounts[1] = 'Gnt27xtC473ZT2Mw5u8wZ68Z3gULkSTb5DuxJy7eJotD'
)
SELECT *
FROM solana.core.fact_transactions t
JOIN e ON e.e_id = t.tx_id
WHERE block_timestamp >= CURRENT_DATE - 1
LIMIT 100
Run a query to Download Data