msafadoostdaily value of the Nouns DAO
    Updated 2022-07-06
    SELECT date(BLOCK_TIMESTAMP),
    avg(AMOUNT_USD)*COUNT(DISTINCT(TX_HASH)) as noun_value
    FROM ethereum.core.ez_eth_transfers
    WHERE TX_HASH IN (SELECT TX_HASH
    FROM ethereum.core.ez_nft_mints
    WHERE NFT_ADDRESS = lower('0x9C8fF314C9Bc7F6e59A9d9225Fb22946427eDC03')
    AND TOKENID NOT LIKE '%0'
    GROUP by 1)
    GROUP by 1
    ORDER by 1

    Run a query to Download Data