sinahosseinzadehUntitled Query
    Updated 2022-08-30
    SELECT COUNT(*)
    , SUM(nft.price) AS eth_vol
    , SUM(nft.price*t.price) AS usd_vol
    FROM ethereum.core.ez_nft_sales nft
    JOIN ethereum.core.fact_hourly_token_prices t
    ON hour = DATE_TRUNC('HOUR', block_timestamp)
    WHERE token_address ilike '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2'
    AND nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
    AND block_timestamp::DATE >= '2022-01-01'
    Run a query to Download Data