-- forked from austin-D3Njwz / Animetas - daily owners (counted only on days where a transfer takes place) @ https://flipsidecrypto.xyz/austin-D3Njwz/q/animetas-daily-owners-counted-only-on-days-where-a-transfer-takes-place-RW1tks
with mint_tokenid as (
select
tokenid
from ethereum.core.ez_nft_mints
where nft_address = lower('0x4a537f61ef574153664c0dbc8c8f4b900cacbe5d')
),
transfers_date as (
select
distinct block_timestamp::date as day
from ethereum.core.ez_nft_transfers
where nft_address = lower('0x4a537f61ef574153664c0dbc8c8f4b900cacbe5d')
),
mint_x_transfers_date as (
select* from mint_tokenid cross join transfers_date
),
mint_tx as (
select
tx_hash from ethereum.core.ez_nft_mints
where nft_address = lower('0x4a537f61ef574153664c0dbc8c8f4b900cacbe5d')
),
minters as (
select
tokenid,
nft_to_address as minters_address
from ethereum.core.ez_nft_mints
where nft_address = lower('0x4a537f61ef574153664c0dbc8c8f4b900cacbe5d')
),
raw_transfers as (
select