ChiefCursory exploration
Updated 2023-04-13
999
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
36
›
⌄
-- -- DESCRIBE TABLE solana.core.fact_transactions;
-- DESCRIBE TABLE solana.core.fact_transactions;
-- instructions:program_id
SELECT *
FROM solana.core.fact_events
WHERE program_id = '8BnEgHoWFysVcuFFX7QztDmzuH8r5ZFvyP3sYwn1XTh6'
LIMIT 20
-- with agg as (
-- SELECT tx.tx_id, program_id, log_messages, account_keys, inner_instructions, instructions, signers
-- FROM solana.core.fact_transactions as tx
-- JOIN (SELECT tx_id, program_id FROM solana.core.fact_events WHERE program_id = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg' AND block_timestamp >= current_date - 1 ORDER BY tx_id) e
-- ON tx.tx_id = e.tx_id
-- WHERE block_timestamp >= current_date - 10
-- -- LIMIT 25
-- )
-- -- ,
-- -- agg1 as (
-- SELECT log.value as value
-- FROM agg, lateral flatten(input => agg.log_messages) as log
-- -- WHERE NOT (value ~ 'TokenUpdateIndexAndRate|PerpUpdateFunding|PerpPlaceOrder|PerpCancelAllOrders')
-- WHERE value NOT LIKE '%TokenUpdateIndexAndRate%'
-- AND value NOT LIKE '%TokenLiqWithToken%'
-- AND value NOT LIKE '%liquidated%'
-- AND value NOT LIKE '%TokenLiqBankruptcy%'
-- AND value NOT LIKE '%CreateOrder%'
-- AND value NOT LIKE '%insufficient funds%'
-- AND value NOT LIKE '%Withdraw%'
-- AND value NOT LIKE '%Deposit%'
-- AND value NOT LIKE '%Burn%'
-- AND value NOT LIKE '%PerpUpdateFunding%'
-- AND value NOT LIKE '%PerpDeactivatePosition%'
-- AND value NOT LIKE '%PerpPlaceOrder%'
-- AND value NOT LIKE '%PerpSettlePnl%'
Run a query to Download Data