with
nft_sale as (
select
block_timestamp::date as date,
platform_name,
seller_address,
buyer_address,
price_usd,
platform_fee_usd,
tx_fee_usd
from
ethereum.core.ez_nft_sales
where
block_timestamp::date > current_date - interval '30 day'
)
select
date,
platform_name,
sum(price_usd) as sum_price_usd
from
nft_sale
group by
1,
2
order by
1