crypto_edgarunique-aqua
Updated 2024-11-21
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
36
›
⌄
-- WITH FIRST_SCAN AS (
-- SELECT
-- EVENT_TYPE,
-- COUNT(TX_ID)
-- FROM
-- solana.core.fact_decoded_instructions
-- WHERE
-- PROGRAM_ID = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'
-- AND BLOCK_TIMESTAMP >= '2024-11-06 06:57:00'
-- AND DECODED_INSTRUCTION:accounts [1] :pubkey = 'EBTeWW78L3LeeyAof5kNeQ9tNCfspd8SiXdTxXzz9qfR'
-- GROUP BY
-- EVENT_TYPE
-- )
WITH SWAP AS (
SELECT *
FROM solana.core.fact_decoded_instructions
WHERE BLOCK_TIMESTAMP >= '2024-11-06 06:57:00'
AND TX_ID = '54crGgNewNVvBb2uSyQBkzwooTYBXtqYGkDdQUni5kLFkHWp7qAqyiwQAL3RcWUz2Boe99HUmyUXn791k3ZZZZxK'
)
SELECT *
FROM SWAP
-- WITH ADD_LIQUIDITY AS (
-- SELECT
-- DECODED_INSTRUCTION:args:liquidityParameter:amountX / POW(10, 6) AS FRED_LIQ,
-- DECODED_INSTRUCTION:args:liquidityParameter:amountY / POW(10, 9) AS SOL_LIQ
-- FROM
-- solana.core.fact_decoded_instructions
-- WHERE
-- PROGRAM_ID = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'
-- AND DECODED_INSTRUCTION:accounts [1] :pubkey = 'EBTeWW78L3LeeyAof5kNeQ9tNCfspd8SiXdTxXzz9qfR'
-- AND BLOCK_TIMESTAMP >= '2024-11-06 06:57:00'
-- AND EVENT_TYPE = 'addLiquidityByStrategy'
-- ),
-- REMOVE_LIQUIDITY AS (
-- SELECT
-- DECODED_INSTRUCTION:args:liquidityParameter:amountX / POW(10, 6) AS FRED_LIQ,
QueryRunArchived: QueryRun has been archived