select block_timestamp::date as date

, platform_name

, project_name

, seller_address

, buyer_address

, price_usd

, platform_fee_usd

, tx_fee_usd

, tx_hash

from ethereum.core.ez_nft_sales

where block_timestamp::date > current_date - interval '30 day'

), blur as

select date

, seller_address as active_user

from nft_sale

where platform_name = 'blur'

union

select date

, buyer_address as active_user

from nft_sale

where platform_name = 'blur'

select date as "Date"

, count(distinct active_user) as "Number of active users"

from blur

group by 1

order by 1