rajsSol Balance Stats
Updated 2023-01-27Copy 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
24
25
26
27
28
29
30
›
⌄
SELECT
'Exchange Art' as marketplace,
avg(sol_balance) as avg_sol_balance,
median(sol_balance) as median_sol_balance,
min(sol_balance) as min_sol_balance,
percentile_cont(0.1) within group (order by sol_balance) as "10_pct_sol_balance",
percentile_cont(0.3) within group (order by sol_balance) as "30_pct_sol_balance",
percentile_cont(0.7) within group (order by sol_balance) as "70_pct_sol_balance",
percentile_cont(0.9) within group (order by sol_balance) as "90_pct_sol_balance",
max(sol_balance) as max_sol_balance
from
(
SELECT
signers[0] as user,
-- tx_id,
post_balances[0] / pow(10,9) as sol_balance,
-- *,
rank() over (partition by signers[0] order by block_timestamp desc) as rank
from solana.core.fact_transactions
where signers[0] in
(
select distinct purchaser
from solana.core.fact_nft_sales
where succeeded
and marketplace = 'exchange art'
)
qualify rank = 1
-- order by 3 desc
)
group by 1
Run a query to Download Data