flyingfishSOL Transfers OUT RAW
    Updated 2023-01-07
    SELECT *
    -- block_timestamp
    -- , tx_id
    -- , signers
    -- , instructions[0]:parsed:info:destination as receiver
    -- , instructions[0]:parsed:info:lamports / pow(10,9) as lamports
    -- , instructions[0]:parsed:type as tx_type
    -- , instructions[0]:parsed:program as tx_program
    FROM solana.core.fact_transactions
    WHERE block_timestamp > '2022-06-01'
    and signers[0] = 'FiSMbrZLnWkZ6RnnJtdkJiZeGgovCVeCwPRudJ6TdTJT'
    AND instructions[0]:parsed:type = 'transfer'
    AND instructions[0]:programId = '11111111111111111111111111111111'
    ORDER BY block_timestamp
    limit 3
    Run a query to Download Data