Query editor
WITHd AS (SELECTDATE_TRUNC('hour', "minute") AS "time",AVG("price") AS "price"FROMprices."usd"WHEREblockchain = 'ethereum'AND "contract_address" = 0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d /* LQTY */AND "minute" >= CAST('2021-07-07' AS TIMESTAMP)GROUP BY1),u2 AS (SELECTDATE_TRUNC('hour', s."evt_block_time") AS "time",SUM(e."price" * (s."amount1In" + s."amount1Out")) / SUM(s."amount0In" + s."amount0Out") AS "price"FROMuniswap_v2_ethereum.Pair_evt_Swap AS sJOIN prices."usd" AS e ON DATE_TRUNC('minute', s."evt_block_time") = e."minute"WHEREe.blockchain = 'ethereum'AND s."contract_address" = 0xb13201b48b1e61593df055576964d0b3aab66ea3AND e."contract_address" = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 /* WETH */AND s."evt_block_time" > CAST('2021-04-04' AS TIMESTAMP)AND e."minute" > CAST('2021-04-04' AS TIMESTAMP)AND s."evt_block_time" < CAST('2021-05-12' AS TIMESTAMP)AND e."minute" < CAST('2021-05-12' AS TIMESTAMP)GROUP BY1),u3 AS (SELECTDATE_TRUNC('hour', s."evt_block_time") AS "time",AVG(e."price" * POWER((s."sqrtPriceX96" / POWER(2, 96)), 2)) AS "price"FROMuniswap_v3_ethereum.Pair_evt_Swap AS sJOIN prices."usd" AS e ON DATE_TRUNC('minute', s."evt_block_time") = e."minute"WHEREe.blockchain = 'ethereum'AND s."contract_address" = 0xd1d5a4c0ea98971894772dcd6d2f1dc71083c44eAND e."contract_address" = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 /* WETH */AND s."evt_block_time" >= CAST('2021-05-12' AS TIMESTAMP)AND e."minute" >= CAST('2021-05-12' AS TIMESTAMP)AND s."evt_block_time" < CAST('2021-07-07' AS TIMESTAMP)AND e."minute" < CAST('2021-07-07' AS TIMESTAMP)GROUP BY1),l AS (SELECT*FROMdUNION ALLSELECT*