PERCENTILE_CONT( 0.05 ) WITHIN GROUP (order by price_usd) as "5th",

PERCENTILE_CONT( 0.1 ) WITHIN GROUP (order by price_usd) as "10th",

PERCENTILE_CONT( 0.25 ) WITHIN GROUP (order by price_usd) as "25th",

PERCENTILE_CONT( 0.5 ) WITHIN GROUP (order by price_usd) as "50th",

PERCENTILE_CONT( 0.75 ) WITHIN GROUP (order by price_usd) as "75th",

PERCENTILE_CONT( 0.9 ) WITHIN GROUP (order by price_usd) as "90th",

PERCENTILE_CONT( 0.95 ) WITHIN GROUP (order by price_usd) as "95th",

PERCENTILE_CONT( 0.99 ) WITHIN GROUP (order by price_usd) as "99th",

PERCENTILE_CONT( 0.999 ) WITHIN GROUP (order by price_usd) as "99.9"

from optimism.core.ez_nft_sales

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.01 ) WITHIN GROUP (order by price_usd)from optimism.core.ez_nft_sale) as price_usd

union all

select '25th' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd) as price_usd from optimism.core.ez_nft_sales)

select 'median' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)) as price_usd

select '75th' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)) as price_usd

select '90th' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)) as price_usd

select '95th' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)) as price_usd

select '99th' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)) as price_usd

select '99.9' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)) as price_usd

select '99.99' as percentile, (select PERCENTILE_CONT( 0.01 ) WITHIN GROUP (order by price_usd)) as price_usd

select 'max' as percentile