with tx as (

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

count(distinct tx_hash) as transaction_counts,

sum(price_usd) as transaction_volumes,

count(distinct nft_address) as transaction_collections,

count(distinct concat(nft_address, tokenid)) as transaction_nfts

from ethereum.core.ez_nft_sales

where platform_name = 'blur'

and price_usd is not null

group by 1

),

trader as (

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

count(distinct wallets) as traders

from (

select block_timestamp,

buyer_address as wallets

from ethereum.core.ez_nft_sales

where platform_name = 'blur'

and price_usd is not null

union all

select block_timestamp,

seller_address as wallets

from ethereum.core.ez_nft_sales

where platform_name = 'blur'

and price_usd is not null

)

group by 1

),

eth_price as (