rajsSol Balance Stats
    Updated 2023-01-27
    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