mitchperionAnimetas - daily owners (counted only on days where a transfer takes place) copy
    Updated 2023-09-16
    -- 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
    Run a query to Download Data