Query editor
WITH syrup_price AS(SELECT date_trunc ('hour', block_time) AS hour,SUM(cast(amount_usd AS DOUBLE))/SUM(cast(token_bought_amount_raw/1e18 AS DOUBLE)) AS syrup_priceFROM dex.tradesWHERE token_bought_address = 0x643c4e15d7d62ad0abec4a9bd4b001aa3ef52d66GROUP BY 1),mpl_price AS(SELECT date_trunc ('hour', block_time) AS hour,SUM(cast(amount_usd AS DOUBLE))/SUM(cast(token_bought_amount AS DOUBLE)) AS mpl_priceFROM dex.tradesWHERE token_bought_address = 0x33349b282065b0284d756f0577fb39c158f935e6GROUP BY 1),price_variance_data AS (SELECTsyrup_price.hour,syrup_price.syrup_price,mpl_price.mpl_price,((syrup_price.syrup_price * 100) - mpl_price.mpl_price) / mpl_price.mpl_price AS price_varianceFROM syrup_priceLEFT JOIN mpl_price ON syrup_price.hour = mpl_price.hourWHERE ((syrup_price.syrup_price * 100) - mpl_price.mpl_price) / mpl_price.mpl_price > -0.10)SELECThour,syrup_price,mpl_price,price_variance,AVG(price_variance) OVER () AS average_price_varianceFROM price_variance_dataORDER BY hour DESC