HitmonleeCryptolulo stuff
Updated 2024-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
select block_timestamp, signers, succeeded, event_type, program_id, instruction, inner_instruction, tx_id
from solana.core.fact_events
where program_id = 'FL3X2pRsQ9zHENpZSKDRREtccwJuei8yg9fwDu9UN69Q'
-- and tx_id = '4vw7WZ1A7NQo1WDvHJH6CTLemAyLmoAfPfenKet9rtLA588CNYEyFtsY11R6xBBJ7v2HEc58jcZaEEgEVKmnPmGy'
--and inner_instruction ILIKE '%createAccount%'
--and inner_instructions::owner ILIKE 'FL3X2pRsQ9zHENpZSKDRREtccwJuei8yg9fwDu9UN69Q'
--and inner_instructions::source[0] ILIKE '6GLittqZbJRMmNCKWyMEN9j24wk8eH6H4VtDBtk4mvVd'
limit 10
/*
select *
from solana.core.fact_transactions
where
--program_id = 'FL3X2pRsQ9zHENpZSKDRREtccwJuei8yg9fwDu9UN69Q'
tx_id = '4vw7WZ1A7NQo1WDvHJH6CTLemAyLmoAfPfenKet9rtLA588CNYEyFtsY11R6xBBJ7v2HEc58jcZaEEgEVKmnPmGy'
-- and inner_instruction ILIKE '%createAccount%'
*/
QueryRunArchived: QueryRun has been archived