Query editor
SELECTdate,value AS glmrPriceFROMdune.fidi.common_metricsWHEREchain = 'moonbeam'AND metric = 'etherPrice'AND date BETWEEN cast('2024-01-01 00:00:00' as timestamp) AND cast('2024-12-31 23:59:59' as timestamp)ORDER BYdate ASC
Query editor
1SELECT2date,3value AS glmrPrice4FROM5dune.fidi.common_metrics6WHERE7chain = 'moonbeam'8AND metric = 'etherPrice'9AND date BETWEEN cast('2024-01-01 00:00:00' as timestamp) AND cast('2024-12-31 23:59:59' as timestamp)10ORDER BY11date ASC