date_trunc(DAY, BLOCK_TIMESTAMP::DATE) AS DAY,

COUNT(TOKENID) AS tokens,

sum(tokens) over (order by DAY) as cum_mint

FROM ethereum.core.ez_nft_mints

WHERE NFT_ADDRESS = LOWER('0x9C8fF314C9Bc7F6e59A9d9225Fb22946427eDC03')

GROUP BY 1

select * from ethereum.core.fact_event_logs

where tx_hash = '0xa4450914275a48b52670176ccdcfa9e9db895504052db72641bc57300533c13a'

tokenid

from ethereum.core.ez_nft_transfers

where nft_address = '0x9c8ff314c9bc7f6e59a9d9225fb22946427edc03'

and block_timestamp = '2022-02-08'

select max(tokenid) from ethereum.core.ez_nft_transfers

where nft_address = '0x9c8ff314c9bc7f6e59a9d9225fb22946427edc03'

and nft_from_address = '0x0000000000000000000000000000000000000000'

where block_timestamp >