KaskoazulStepN all tx with amount
Updated 2022-03-01
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 ALLTX AS (
select
block_timestamp::date as fecha,
tx_id,
pre_mint,
post_mint,
tx_from_address,
tx_to_address,
transfer_tx_flag,
program_id
from solana.transactions
where block_timestamp::date >= '2022-01-01' and block_timestamp::date <= '2022-02-27'
and succeeded = 'TRUE'
and (pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
),
TRANSFER_AMOUNT AS (
SELECT
fecha,
tx.tx_id,
t.amount/pow(10,3) as Transfer,
--t.pretokenbalances,
--t.posttokenbalances,
t.event_type
FROM ALLTX tx
INNER JOIN solana.transfers t
ON tx.tx_id = t.tx_id
)
SELECT
fecha,
sum(Transfer) as TotalAmount
--sum(Transfer) over (ORDER BY fecha) as TotalAmountAcc
FROM TRANSFER_AMOUNT
GROUP BY 1--, 2
Run a query to Download Data