SELECT

block_timestamp,

tx_hash,

project_name,

nft_to_address,

tokenid

-- count(distinct nft_to_address) as distinct_minters_count,

-- count(tx_hash) as brush_count,

-- count(DISTINCT tokenid) AS tokenid

FROM base.nft.ez_nft_transfers

WHERE event_type = 'mint'

AND nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'

SELECT

block_timestamp::date AS day,

count(tx_hash) AS brushes,

count(DISTINCT from_address) AS minters,

SUM(value) AS eth_paid,

SUM(tx_fee) AS fee_paid

FROM base.core.fact_transactions

WHERE tx_hash IN (SELECT tx_hash FROM mint_brush)

GROUP BY 1