ArioThe Typical Minter - GodMode Status
    Updated 2022-06-09
    with
    list_of_users as (
    select
    BLOCK_TIMESTAMP,
    NFT_TO_ADDRESS as Users
    from flipside_prod_db.ethereum_core.ez_nft_mints
    where NFT_ADDRESS = '0x903e2f5d42ee23156d548dd46bb84b7873789e44'
    and EVENT_TYPE = 'nft_mint'
    and MINT_PRICE_ETH != 0
    and NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    and block_timestamp between '2022-06-07 16:00:00.000' and '2022-06-07 17:00:00.000'
    ),
    Minters as (
    select distinct nft_to_address as minter
    from ethereum.core.ez_nft_mints m join list_of_users l on m.nft_to_address = l.Users
    where m.BLOCK_TIMESTAMP > current_date - 180
    and m.BLOCK_TIMESTAMP < '2022-06-07'
    ),
    nft_buyers as (
    select distinct origin_from_address as nft_buyer
    from ethereum.core.ez_nft_sales es join list_of_users l on es.origin_from_address = l.Users
    where es.BLOCK_TIMESTAMP > CURRENT_DATE - 180

    ),
    Swappers as (
    select distinct origin_from_address as swapper
    from ethereum.core.ez_dex_swaps s join list_of_users l on s.origin_from_address = l.Users
    where s.BLOCK_TIMESTAMP > CURRENT_DATE - 180
    ),
    final_table as (
    select
    Users,
    minter,
    nft_buyer,
    swapper
    from list_of_users