SELECT

block_timestamp::date as sell_date,

seller_address,

tx_hash,

nft_address,

tokenid,

price as selling_ETH_price,

price_usd as selling_usd_price

FROM ethereum.core.ez_nft_sales

WHERE project_name LIKE 'cryptopunks'

AND price_usd > 0

and event_type LIKE 'sale'

),

buyer_data as (

SELECT

block_timestamp::date as buy_date,

buyer_address,

tx_hash,

nft_address,

tokenid,

price as buying_ETH_price,

price_usd as buying_usd_price

FROM ethereum.core.ez_nft_sales

WHERE project_name LIKE 'cryptopunks'

AND price_usd > 0

and event_type LIKE 'sale'

),

together as (

SELECT

buy_date,

seller_address,

COUNT(DISTINCT id1.tx_hash) as selling_number,

COUNT(DISTINCT id2.tx_hash) as buying_number,

id2.tokenid as tokenid,

sell_date,