andurilATLAS claim vs sell unique wallets
Updated 2022-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with sa_claimers as (
select
date(block_timestamp) as date,
--instruction:programId as program,
--inner_instruction:instructions[0]:parsed:info:source as program,
tx_id,
inner_instruction:instructions[0]:parsed:info:authority as sender,
instruction:accounts[0] as reciever,
inner_instruction:instructions[0]:parsed:info:amount/POW(10,8) as amount
--pretokenbalances,posttokenbalances
from solana.events
where
sender = '2ahn5m4zeujE56qKMuEeyX2jktEuJPH5UzoznHKmUMka' and
--tx_id = '2YLzYHCEhCjTcTKfoQd1xJpGPh8PTWx6RAeTb51ZCSmH29RvD7RGYCoApKrRBEgqoAHthp8ewjCZ6WywfiXkGMUC' --test transaction
date >= CURRENT_DATE()-30
)
,
atlas_sellers as (
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 dest
--instruction,
--inner_instruction
from solana.events
where
--tx_id = '2WobSCGwUyB8TW78fdF1vopB5Ua1hJPUdhMxGpFsKboF8aMrtn5xcyPuVX3UWUt1vRRMqtKqCVtrMKK5wBgUDv1b' and
date(block_timestamp) >= CURRENT_DATE()-30
and succeeded = 'TRUE'
Run a query to Download Data