kaibladeArt Gobblers - Daily Max, Min, Avg, Med Prices
    Updated 2022-11-28
    WITH eth_price AS
    (SELECT price, symbol
    FROM ethereum.core.fact_hourly_token_prices
    WHERE symbol = 'WETH'
    ORDER BY hour DESC
    LIMIT 1),
    gobbler_resale AS
    (SELECT *, 'WETH' AS symbol
    FROM ethereum.core.ez_nft_sales
    WHERE nft_address= LOWER('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
    ORDER BY block_timestamp),
    gobbler_resale_usd AS
    (SELECT sale.tx_hash, sale.block_timestamp,sale.platform_fee, sale.tx_fee, sale.platform_name,sale.price*price.price AS amount
    FROM gobbler_resale sale
    JOIN eth_price price
    ON sale.symbol = price.symbol
    ),

    daily_max_price AS
    (
    SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
    MAX(amount) AS "Daily Maximum Sale Price in USD"
    FROM gobbler_resale_usd
    GROUP BY "Days"
    ),

    daily_min_price AS
    (
    SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
    MIN(amount) AS "Daily Minimum Sale Price in USD"
    FROM gobbler_resale_usd
    Run a query to Download Data