Query editor
SELECTDATE_TRUNC('day', timestamp) as day,priceFROM prices.dayWHERE contract_address = 0x405fbc9004d857903bfd6b3357792d71a50726b0ORDER BY 1 DESC
Query editor
1SELECT2DATE_TRUNC('day', timestamp) as day,3price4FROM prices.day5WHERE contract_address = 0x405fbc9004d857903bfd6b3357792d71a50726b06ORDER BY 1 DESC