nasdfajsklj2024-05-25 Solana rug investigation queries
Updated 2024-05-26
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
›
⌄
-- select * from solana.core.ez_events_decoded limit 10
select
-- block_timestamp::date
block_id
,event_type
,decoded_instruction
,decoded_args
,tx_id
from solana.core.ez_events_decoded
where 1=1
and block_id >= 267950027
-- and tx_id = '2fQd5DgNsstPgegXQ3VbBWRAjZbBpdak1uTNwYyk85AFpJDphb529fCEaX6jdxeEkbftFgWYMxyxJxepYXGQ6fn'
and signers[0] = '3LnoLYdveiGPGFhBC2v9otXuq5gNqqn5UV8HeNphqyJa'
-- and event_type = 'SwapEvent'
limit 200
---why aren't the transfers out here?
--maybe transfers don't emit an 'event' whatever that is
-- select
-- *
-- from solana.core.fact_transfers
-- where 1=1
-- and block_id >= 267967847
-- -- and tx_id = 'vULfpZCjthX7ca6nmgMsZrR878rn95ovqLEyt8wgJpuChv2U3YyppfPrKApmmTVN3NrM39FVehjwq7oWSLyqBqR'
-- and tx_from = '3LnoLYdveiGPGFhBC2v9otXuq5gNqqn5UV8HeNphqyJa'
-- -- and event_type = 'SwapEvent'
-- limit 10
QueryRunArchived: QueryRun has been archived