-- order by duplicates columns and creates invalid timestamp index
WITH
  offsets AS (
    SELECT offs*100000 AS usec_offs, offs
    FROM (
      SELECT (x-51) AS offs
      FROM long_sequence(101)
    )
  ),
  orders AS (
    SELECT *  
    FROM trades
    WHERE timestamp IN '2025-05-21'
    LIMIT 10
  ),
  points AS (
    SELECT orders.*, offsets.usec_offs*0.001 AS msec_offs, offs, timestamp + usec_offs AS tsXYZ
    FROM orders CROSS JOIN offsets
    ORDER BY timestamp + usec_offs ASC
  )
select * from points;

WITH
  offsets AS (
    SELECT offs*100000 AS usec_offs, offs
    FROM (
      SELECT (x-51) AS offs
      FROM long_sequence(101)
    )
  ),
  orders AS (
    SELECT *  
    FROM trades
    WHERE timestamp IN '2025-05-21'
    LIMIT 10
  ),
  points AS (
    SELECT orders.*, offsets.usec_offs*0.001 AS msec_offs, offs, timestamp + usec_offs AS tsXYZ
    FROM orders CROSS JOIN offsets
    ORDER BY timestamp + offs ASC
  )
select * from points;