crypto_edgarLucky Buy Investigation copy
    Updated 2023-10-01
    -- forked from Lucky Buy Investigation @ https://flipsidecrypto.xyz/edit/queries/f8c7d377-3790-4a9e-985a-fc0c33e76e7a
    WITH
    -- meegos_mint as (
    -- select
    -- BLOCK_TIMESTAMP,
    -- TX_ID,
    -- CASE
    -- WHEN ARRAY_SIZE(instructions [1] :accounts) > 1 THEN instructions [1] :accounts [6] :: varchar
    -- ELSE instructions [2] :accounts [6] :: varchar
    -- END AS MINT,
    -- CASE
    -- WHEN ARRAY_SIZE(instructions [1] :accounts) > 1 THEN instructions [1] :accounts [5] :: varchar
    -- ELSE instructions [2] :accounts [5] :: varchar
    -- END AS TX_TO
    -- from
    -- solana.core.fact_transactions
    -- where
    -- SUCCEEDED
    -- AND BLOCK_TIMESTAMP BETWEEN TIMESTAMP '2023-08-21'
    -- AND CURRENT_TIMESTAMP
    -- AND (
    -- instructions [1] :accounts [3] = 'DYPHVB6gNNHPn1qQzEyQGkZPCVMx3DAKLq8v4n4bjgEp'
    -- OR instructions [2] :accounts [3] = 'DYPHVB6gNNHPn1qQzEyQGkZPCVMx3DAKLq8v4n4bjgEp'
    -- )
    -- AND array_size(INNER_INSTRUCTIONS [0] :instructions) > 1
    -- ),
    -- reavers_mint as (
    -- select
    -- BLOCK_TIMESTAMP,
    -- TX_ID,
    -- instructions [1] :accounts [10] :: varchar AS MINT,
    -- instructions [1] :accounts [2] :: varchar AS TX_TO
    -- from
    -- solana.core.fact_transactions
    -- where
    -- SUCCEEDED
    Run a query to Download Data