Ali3NTotal Mints Stats (Brand NFTs)
    Updated 2023-02-18
    with ethpricet as (
    select hour::date as day,
    avg (price) as ETHPrice
    from ethereum.core.fact_hourly_token_prices
    where symbol = 'WETH'
    group by 1),

    reddit as (
    select block_timestamp,
    tx_hash,
    event_inputs:_to as Buyer_Minter,
    event_inputs:_from as Seller,
    event_inputs:_id as TokenID,
    event_inputs:_value as TokensCount
    from polygon.core.fact_event_logs
    where event_name ='TransferSingle'
    and origin_function_signature in ('0x669f5a51','0x5a86c41a')
    and tx_status = 'SUCCESS'
    and contract_address = '0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5'
    and event_inputs:_from = '0x0000000000000000000000000000000000000000'), -- Mints (Primary Sales)

    chickenderby as (
    select block_timestamp,
    tx_hash,
    event_inputs:to as Buyer_Minter,
    event_inputs:from as Seller,
    event_inputs:tokenId as TokenID,
    contract_address as collection
    from polygon.core.fact_event_logs
    where event_inputs:tokenId is not null
    and event_name = 'Transfer'
    and tx_status = 'SUCCESS'
    and event_inputs:from = '0x0000000000000000000000000000000000000000'
    and event_inputs:to != '0x0000000000000000000000000000000000000000'
    and contract_address = '0x8634666ba15ada4bbc83b9dbf285f73d9e46e4c2')

    Run a query to Download Data