Query editor
WITH transfers AS (SELECTblock_time,contract_address,token_id,amount,"from" AS from_address,"to" AS to_address,tx_hashFROM nft.transfersWHERE contract_address = 0xb3f2ddaed136cf10d5b228ee2eff29b71c7535fc),-- Mint events = transfers from zero addressmints AS (SELECTtoken_id,to_address AS minter,block_time AS mint_time,tx_hash AS mint_txFROM transfersWHERE from_address = 0x0000000000000000000000000000000000000000),-- Mint price in USD using ETH price at the block minutemint_prices AS (SELECTm.token_id,m.minter,m.mint_time,p.price AS eth_price_usdFROM mints mLEFT JOIN prices.usd pON p.blockchain = 'ethereum'AND p.symbol = 'ETH'AND p.minute = date_trunc('minute', m.mint_time)),-- Compute current holdersholder_balances AS (SELECTto_address AS wallet,token_id,1 AS balance_changeFROM transfersUNION ALLSELECTfrom_address AS wallet,token_id,-1 AS balance_changeFROM transfers),final_balances AS (SELECTwallet,token_idFROM holder_balancesGROUP BY wallet, token_idHAVING SUM(balance_change) > 0