Aephialateral flatten select *
Updated 2023-07-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
/*SELECT
*
FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
WHERE program_Id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
AND block_timestamp > current_date -30
limit 100
*/
SELECT
fact_events.*
, f.value
, f.this
FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions) f
WHERE program_Id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'
AND block_timestamp > current_date -30
limit 100
Run a query to Download Data