Query editor
SELECTapprox_percentile(value, 0.5) AS medEtherPriceFROM dune.fidi.common_metricsWHERE chain = 'moonbeam'AND metric = 'etherPrice' -- fees, dailyTransactionsCount, etherPrice, dailyGasAND date >= cast('2024-01-01' as timestamp)AND date <= cast('2024-12-31' as timestamp)