flyingfishmarqu CoREEN copy
Updated 2025-02-16
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
›
⌄
⌄
/* select
block_timestamp
, tx_id
, value:programId
, substr(utils.udf_base58_to_hex(instruction:data), 3, 16) as hex_data
, substr(utils.udf_base58_to_hex(value:data), 3, 16) as hex_data_inner
from solana.core.fact_events evt
, lateral flatten (input => inner_instruction:instructions)
where 1 = 1
and array_contains('CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'::variant, instruction:accounts)
--and block_timestamp > current_timestamp() - interval '2 days'
and block_timestamp > '2024-09-05'
and block_timestamp < '2024-09-08'
and (program_id = 'CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'
or
value:programId = 'CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'
)
and (hex_data = '0000000000005300' or hex_data_inner = '0000000000005300')
*/
select
substr(utils.udf_base58_to_hex(instruction:data), 3, 16) as hex_data
, block_timestamp
, tx_id
from solana.core.fact_events_inner
where 1 = 1
and succeeded
and block_timestamp > '2024-09-05'
and block_timestamp < '2024-09-08'
and instruction_program_id = 'CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'
and program_id = 'CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'
and hex_data = '0000000000005300'
-- and tx_id = '4ZetEnUiCg6SUnPqghYw9Hn1wtjXMG9sMXmaWKvLCNJWSkHCoNLPdDjR3JVE3xy7CrcB5UK1kVEGzxpjKeuKBw5Q'
-- and block_id = 287985360
QueryRunArchived: QueryRun has been archived