adambalanear.,
    Updated 2022-10-22
    WITH INFO as
    (select
    TX_HASH ,
    BLOCK_TIMESTAMP ,
    TX_SIGNER AS MINTER ,
    PROJECT_NAME ,
    NETWORK_FEE AS FEE,
    AVG(PRICE_USD) * NETWORK_FEE AS FEE_USD,
    'NEAR'as title
    FROM near.core.ez_nft_mints INNER JOIN near.core.fact_prices ON BLOCK_TIMESTAMP::DATE =TIMESTAMP ::DATE
    where METHOD_NAME ='nft_mint' AND SYMBOL ='wNEAR'
    GROUP BY 1,2,3,4,5



    union

    select
    TX_HASH ,
    BLOCK_TIMESTAMP ,
    NFT_TO_ADDRESS AS MINTER,
    PROJECT_NAME ,
    TX_FEE AS FEE,
    TX_FEE *AVG(PRICE) AS FEE_USD ,
    'Ethereum'as title
    FROM ethereum.core.ez_nft_mints INNER JOIN ethereum.core.fact_hourly_token_prices
    ON HOUR::DATE =BLOCK_TIMESTAMP::DATE
    where EVENT_TYPE='nft_mint' AND SYMBOL='WETH'
    GROUP BY 1,2,3,4,5

    )


    select
    title ,
    Run a query to Download Data