potmoopt price percentiles
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select '1st' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales) as price_usd
union all
select '10th' as percentile, (select PERCENTILE_CONT( 0.1 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales) as price_usd
union all
select '25th' as percentile, (select PERCENTILE_CONT( 0.25 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales) as price_usd
union all
select '50th' as percentile, (select PERCENTILE_CONT( 0.5) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales) as price_usd
union all
select '75th' as percentile, (select PERCENTILE_CONT( 0.75 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales) as price_usd
union all
select '90th' as percentile, (select PERCENTILE_CONT( 0.9 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales) as price_usd
union all
select '95th' as percentile, round((select PERCENTILE_CONT( 0.95 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales),2) as price_usd
union all
select '99th' as percentile, round((select PERCENTILE_CONT( 0.99 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales),2) as price_usd
union all
select '99.9th' as percentile, round((select PERCENTILE_CONT( 0.999 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sales),2) as price_usd
union all
select 'max' as precentile, (select max(price_usd)from optimism.core.ez_nft_sales) as price_usd
Run a query to Download Data