kaibladeDaily Uniswap NFT Aggregator Sales Count
    Updated 2022-12-16
    WITH universal_tx AS
    (SELECT DISTINCT (tx_hash)
    FROM ethereum.core.fact_event_logs
    WHERE origin_to_address= '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'),

    uniswap_sales AS
    (SELECT *
    FROM ethereum.core.ez_nft_sales
    WHERE tx_hash IN (SELECT tx_hash FROM universal_tx)
    ORDER BY block_timestamp DESC)

    SELECT DATE_TRUNC ('day', block_timestamp) AS "Days",
    COUNT(tx_hash) AS "Sales Volume"
    FROM uniswap_sales
    GROUP BY "Days"


    -- AND nft_from_address =
    Run a query to Download Data