Query editor
SELECTdate,value AS zkPriceFROMdune.fidi.common_metricsWHEREchain = 'zkSync'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 zkPrice4FROM5dune.fidi.common_metrics6WHERE7chain = 'zkSync'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