KaskoazulStepN Events
Updated 2022-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH TX AS (
SELECT
block_timestamp::date as fecha,
tx_id
FROM
solana.transactions
where fecha >= '2022-01-01' and fecha <= '2022-02-27'
and succeeded = 'TRUE'
and (pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
)
SELECT
tx_id,
inner_instruction,
posttokenbalances,
pretokenbalances,
FROM solana.events
WHERE tx_id IN (SELECT tx_id FROM TX)
Run a query to Download Data