select to_date(date_trunc('day', block_timestamp)) as block_date,

platform_name,

count(distinct tx_hash) as transaction_counts,

sum(price_usd) as transaction_volumes

from ethereum.core.ez_nft_sales

where block_timestamp > '2022-10-19'

and price_usd is not null

group by 1, 2

),

trader as (

select to_date(date_trunc('day', block_timestamp)) as block_date,

platform_name,

count(distinct wallets) as traders

from (

select block_timestamp,

platform_name,

buyer_address as wallets

from ethereum.core.ez_nft_sales

where block_timestamp > '2022-10-19'

and price_usd is not null

union all

select block_timestamp,

platform_name,

seller_address as wallets

from ethereum.core.ez_nft_sales

where block_timestamp > '2022-10-19'

and price_usd is not null

)

group by 1, 2

),

agg as (

select tx.block_date,

sum(tx.transaction_counts) as transaction_counts,

sum(tx.transaction_volumes) as transaction_volumes,

sum(trader.traders) as traders