Untitled Query

adambalaUntitled Query

Updated 2022-09-27

select NFT_TO_ADDRESS ,TOKENID ,(MINT_PRICE_ETH)/NFT_COUNT as MINT_PRICE_ETHs ,(MINT_PRICE_USD)/NFT_COUNT as MINT_PRICE_USDs ,tx_hash ,BLOCK_TIMESTAMP::DATE AS MINT_TIME ,NFT_COUNT ,MINT_PRICE_ETH ,MINT_PRICE_USD

from ethereum.core.ez_nft_mints

where NFT_ADDRESS=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')

and EVENT_TYPE ='nft_mint'

and PROJECT_NAME='doodles'

and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000'

and MINT_PRICE_ETH > 0 and MINT_PRICE_USD > 0 and TOKENID ='2912'

flipside

flipside