mints as (

select

tx_hash,

block_timestamp,

tokenid,

nft_to_address as minter,

mint_price_eth,

mint_price_usd / nft_count as mint_price_usd_unit

from

ethereum.core.ez_nft_mints

where

nft_address = lower({{address}}) -- kanpai pandas nft address

--and tx_hash = '0x410ec95567344493c9de5c87b56b45683ad8b8961ee2d9dce08c6628f4fdb64a'

-- and tokenid = '2743'

and mint_price_eth >= 0

)

*

FROM