kellendevops_feed_result_checker
Updated 2024-01-12
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
›
⌄
-- look at decoded instruction column for
-- oracle keys and reported max, min and final mantissa and scale
WITH tx AS (
SELECT
tx_id AS id
FROM solana.core.fact_decoded_instructions
WHERE block_timestamp BETWEEN '2024-01-10 22:10' AND '2024-01-10 22:30'
AND program_id = 'SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f'
AND decoded_instruction:accounts[0]:pubkey = 'B7Gzb3BubnEHVtMNYaE1EagkTk9r6MLBnDLkGpWgdW9E'
AND decoded_instruction:name = 'aggregatorSaveResult'
ORDER BY 1
)
SELECT
block_timestamp,
block_id,
tx_id,
log_messages
FROM solana.core.fact_transactions t
JOIN tx ON tx.id = t.tx_id
WHERE block_timestamp BETWEEN '2024-01-10 22:10' AND '2024-01-10 22:30'
ORDER BY 1 ASC, 2 ASC
QueryRunArchived: QueryRun has been archived