saber-jlQuixotic daily trading volume
    Updated 2022-08-02
    with OP_Price as(
    SELECT date_trunc('day', HOUR) as date, avg(price) as OP_price
    From optimism.core.fact_hourly_token_prices
    WHERE SYMBOL = 'OP'
    AND hour >= '2022-06-15'
    GROUP BY 1
    ORDER BY 1),


    Eth_price as (
    SELECT date_trunc('day', BLOCK_TIMESTAMP) as date, avg(amount_out / amount_in) as ETH_price
    From ethereum.core.ez_dex_swaps
    WHERE SYMBOL_IN = 'WETH'
    And SYMBOL_OUT = 'USDC'
    AND BLOCK_TIMESTAMP >= '2022-06-15'
    and PLATFORM = 'uniswap-v2'
    GROUP BY 1
    ORDER BY 1),


    OPvol as (
    SELECT date_trunc('day', block_timestamp) as date, CURRENCY_SYMBOL as Currency, sum(PRICE) as Volume
    FROM optimism.core.ez_nft_sales
    WHERE PLATFORM_NAME = 'quixotic'
    AND block_timestamp >= '2022-06-15'
    AND EVENT_TYPE = 'sale'
    and currency_symbol = 'OP'
    AND nft_address != '0xbe81eabdbd437cba43e4c1c330c63022772c2520'
    GROUP BY 1 , 2
    ORDER BY 1
    ),

    ETHvol as (

    SELECT date_trunc('day', block_timestamp) as date, CURRENCY_SYMBOL as Currency, sum(PRICE) as Volume
    Run a query to Download Data