banterlytics2022-11-20 11:04 AM
    Updated 2022-11-23
    with mint_tokenid as (
    select
    tokenid
    from ethereum.core.ez_nft_mints
    where nft_address = '0x57a204aa1042f6e66dd7730813f4024114d74f37'
    and tokenid <= 1000
    ),

    transfers_date as (
    select
    distinct block_timestamp::date as day
    from ethereum.core.ez_nft_transfers
    where nft_address = '0x57a204aa1042f6e66dd7730813f4024114d74f37'
    ),

    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 = '0x57a204aa1042f6e66dd7730813f4024114d74f37'
    ),
    minters as (
    select
    tokenid,
    nft_to_address as minters_address
    from ethereum.core.ez_nft_mints
    where nft_address = '0x57a204aa1042f6e66dd7730813f4024114d74f37'
    ),

    raw_transfers as (
    select
    block_timestamp::date as day,
    Run a query to Download Data