andurilATLAS Sells
    Updated 2022-03-15
    --select * from solana.transactions where TX_ID = '5HnjnYziafQwGVtxLCNiwTyTea2VkgaFxsLem8DbdX4aPt4pkHTMz9ZQ8Kh1bmd2D9pieqKhzT2VLuTzGG3jdg93'


    --Serum Swap ATLAS to USDC.
    select
    date(block_timestamp) as date,
    tx_id,
    inner_instruction:instructions[1]:parsed:info:authority as seller,
    inner_instruction:instructions[1]:parsed:info:destination as atlas_acct,
    inner_instruction:instructions[1]:parsed:info:amount/POW(10,8) as atlas_swapped
    --inner_instruction:instructions[4]:parsed:info:destination as usdc_acct,
    --instruction,
    --inner_instruction
    from solana.events
    where
    --tx_id = '2WobSCGwUyB8TW78fdF1vopB5Ua1hJPUdhMxGpFsKboF8aMrtn5xcyPuVX3UWUt1vRRMqtKqCVtrMKK5wBgUDv1b' and
    date(block_timestamp) >= CURRENT_DATE()-14
    and succeeded = 'TRUE'
    and seller is not null
    and atlas_acct = '22a8dDQwHmmnW4M4WuSXHC9NdQAufZ2V8at3EtPzBqFj' --and usdc_acct = '3m91z83pDTGVBQ3W43bwtse66zKRdLv9r1woDfLGHJUB'


    --3m91z83pDTGVBQ3W43bwtse66zKRdLv9r1woDfLGHJUB
    Run a query to Download Data