msafadoostvalue of the Lil Nouns DAO
    Updated 2022-07-06
    SELECT avg(AMOUNT_USD)*COUNT(DISTINCT(TX_HASH)) as lil_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('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
    AND TOKENID NOT LIKE '%0'
    AND TOKENID NOT LIKE '%1'
    GROUP by 1)

    Run a query to Download Data