Query editor
WITH gas_price AS (SELECTDATE_TRUNC('day', block_time) AS date,APPROX_PERCENTILE(gas_price, 0.5) / POWER(10, 9) AS median_gas,21000 * APPROX_PERCENTILE(gas_price, 0.5) / POWER(10, 18) AS median_eth_transfer_gasFROM evms.transactions AS txsWHEREblockchain = 'ethereum'GROUP BY1)SELECTgp.date,gp.median_gas,gp.median_eth_transfer_gasFROM gas_price AS gpLEFT JOIN prices.usd AS puON pu.minute = gp.date AND pu.blockchain = 'ethereum' AND pu.symbol = 'ETH'WHEREgp.date > CURRENT_TIMESTAMP - INTERVAL '2' yearORDER BYgp.date