BLOCK_TIMESTAMP::date as date,

PERCENTILE_CONT(0.1) WITHIN GROUP (ORDER BY AMOUNT_IN_USD) as "10%",

PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY AMOUNT_IN_USD) as "25%",

PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY AMOUNT_IN_USD) as "50%",

PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY AMOUNT_IN_USD) as "75%",

PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY AMOUNT_IN_USD) as "90%",

avg(AMOUNT_IN_USD) as "AVG"

from ethereum.core.ez_dex_swaps

where AMOUNT_IN_USD is not NULL

and BLOCK_TIMESTAMP >= '2022-10-01'

and AMOUNT_IN_USD > 0

and AMOUNT_IN_USD < 1e10

and BLOCK_TIMESTAMP < CURRENT_DATE

and EVENT_NAME = 'Swap'

group by 1