MoeUntitled Query
Updated 2022-02-26
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
›
⌄
with wallets as ( Select block_timestamp::date as date,
count(distinct tx_from_address) as uniquewallets
from Solana.Transactions
where (POST_MINT = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' OR
Pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
)
and SUCCEEDED = 'TRUE'
group by date
order by date),
amount as( Select block_timestamp::date as date1,
round ((sum(AMOUNT)/1e3),2) as amount
from Solana.Transfers
where tx_id in (select tx_id from Solana.Transactions
WHERE (POST_MINT = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' OR
Pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
)
)
group by date1
order by date1)
SELECT
wallets.date,
wallets.uniquewallets,
amount.amount
from wallets
join amount on wallets.date = amount.date1
order by date
Run a query to Download Data