crypto_edgarunique-aqua
    Updated 2024-11-21
    -- 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