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

1 = 1

and nft_address = lower('0x5Af0D9827E0c53E4799BB226655A1de152A425a5') -- kanpai pandas nft address

--and tx_hash = '0x410ec95567344493c9de5c87b56b45683ad8b8961ee2d9dce08c6628f4fdb64a'

-- and tokenid = '2743'

and mint_price_eth >= 0

),

first_sales as (

select

tx_hash,

block_timestamp,

tokenid,

seller_address,

buyer_address,

price as sale_in_eth,

price_usd as sale_in_usd

from

ethereum.core.ez_nft_sales

where

1 = 1

and nft_address = lower('0x5Af0D9827E0c53E4799BB226655A1de152A425a5') -- kanpai pandas nft address

--and tx_hash = '0x410ec95567344493c9de5c87b56b45683ad8b8961ee2d9dce08c6628f4fdb64a'

--and tokenid = '2743'

and currency_address in ('ETH')