eth_volume as (

select

block_timestamp::date as date,

PLATFORM_NAME as marketplace,

sum(price_usd) as volume_usd

from ethereum.core.ez_nft_sales

where block_timestamp >= current_date() - interval '2 months'

and price_usd < 1e7

group by 1,2

select * from eth_volume

order by date, marketplace