-- forked from level price (vertex) @ https://flipsidecrypto.xyz/edit/queries/3a5014c8-beaf-4865-a060-cdb08b352628
select
ceil(price_amount,-2) as price_level,
sum(amount_usd) as volume
from blast.blitz.ez_perp_trades
where symbol = 'BTC-PERP'
and is_taker = 'TRUE'
and block_timestamp::date >= dateadd(day, -7, current_date)
group by 1