andurilATLAS Sells
Updated 2022-03-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
--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