PREVIEW / futures_1hour / 2010-01-03
file: by_date/futures_1hour/2010/2010-01-03.parquet size: 13 KB rows: 235
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2010-01-03 18:00:00 | ES | Futures | 1083.72 | 1086.39 | 1083.23 | 1084.93 | 11645.0 |
| 2010-01-03 19:00:00 | ES | Futures | 1085.18 | 1086.15 | 1084.93 | 1085.66 | 3765.0 |
| 2010-01-03 20:00:00 | ES | Futures | 1085.42 | 1085.91 | 1083.96 | 1084.2 | 4097.0 |
| 2010-01-03 21:00:00 | ES | Futures | 1084.2 | 1085.66 | 1083.96 | 1085.66 | 2931.0 |
| 2010-01-03 22:00:00 | ES | Futures | 1085.66 | 1085.66 | 1084.69 | 1085.18 | 2941.0 |
| 2010-01-03 23:00:00 | ES | Futures | 1085.18 | 1085.42 | 1084.45 | 1084.69 | 1835.0 |
| 2010-01-03 18:00:00 | NQ | Futures | 2131.36 | 2138.51 | 2131.36 | 2136.51 | 1963.0 |
| 2010-01-03 19:00:00 | NQ | Futures | 2136.51 | 2138.79 | 2135.93 | 2136.22 | 526.0 |
| 2010-01-03 20:00:00 | NQ | Futures | 2136.22 | 2137.08 | 2133.36 | 2133.36 | 614.0 |
| 2010-01-03 21:00:00 | NQ | Futures | 2133.36 | 2136.51 | 2133.08 | 2136.51 | 360.0 |
| 2010-01-03 22:00:00 | NQ | Futures | 2136.51 | 2136.51 | 2135.08 | 2136.22 | 296.0 |
| 2010-01-03 23:00:00 | NQ | Futures | 2136.22 | 2136.51 | 2135.08 | 2135.65 | 290.0 |
| 2010-01-03 18:00:00 | YM | Futures | 9717.5 | 9745.5 | 9717.5 | 9739.0 | 442.0 |
| 2010-01-03 19:00:00 | YM | Futures | 9740.9 | 9747.4 | 9739.9 | 9744.6 | 329.0 |
| 2010-01-03 20:00:00 | YM | Futures | 9743.7 | 9744.6 | 9729.6 | 9729.6 | 374.0 |
| 2010-01-03 21:00:00 | YM | Futures | 9729.6 | 9737.1 | 9727.8 | 9737.1 | 283.0 |
| 2010-01-03 22:00:00 | YM | Futures | 9737.1 | 9739.0 | 9730.6 | 9733.4 | 380.0 |
| 2010-01-03 23:00:00 | YM | Futures | 9734.3 | 9736.2 | 9730.6 | 9733.4 | 97.0 |
| 2010-01-03 18:00:00 | CL | Futures | 171.0 | 171.79 | 171.0 | 171.66 | 1400.0 |
| 2010-01-03 19:00:00 | CL | Futures | 171.68 | 171.79 | 171.58 | 171.7 | 742.0 |
| 2010-01-03 20:00:00 | CL | Futures | 171.75 | 171.77 | 171.58 | 171.6 | 346.0 |
| 2010-01-03 21:00:00 | CL | Futures | 171.58 | 171.79 | 171.3 | 171.68 | 718.0 |
| 2010-01-03 22:00:00 | CL | Futures | 171.7 | 171.79 | 171.49 | 171.77 | 918.0 |
| 2010-01-03 23:00:00 | CL | Futures | 171.73 | 171.79 | 171.66 | 171.79 | 627.0 |
| 2010-01-03 18:00:00 | GC | Futures | 1548.8 | 1552.0 | 1545.1 | 1545.3 | 1795.0 |
| 2010-01-03 19:00:00 | GC | Futures | 1545.4 | 1546.5 | 1541.5 | 1543.4 | 3723.0 |
| 2010-01-03 20:00:00 | GC | Futures | 1543.6 | 1545.1 | 1542.2 | 1544.6 | 1849.0 |
| 2010-01-03 21:00:00 | GC | Futures | 1544.6 | 1549.6 | 1544.6 | 1548.7 | 2684.0 |
| 2010-01-03 22:00:00 | GC | Futures | 1548.7 | 1550.5 | 1547.0 | 1549.6 | 1622.0 |
| 2010-01-03 23:00:00 | GC | Futures | 1549.5 | 1554.7 | 1549.2 | 1553.4 | 2979.0 |
| 2010-01-03 18:00:00 | ZN | Futures | 93.562741 | 93.651582 | 93.550049 | 93.613507 | 4003.0 |
| 2010-01-03 19:00:00 | ZN | Futures | 93.613507 | 93.664274 | 93.600816 | 93.63889 | 2926.0 |
| 2010-01-03 20:00:00 | ZN | Futures | 93.63889 | 93.676965 | 93.63889 | 93.651582 | 2589.0 |
| 2010-01-03 21:00:00 | ZN | Futures | 93.664274 | 93.676965 | 93.613507 | 93.613507 | 1443.0 |
| 2010-01-03 22:00:00 | ZN | Futures | 93.613507 | 93.626199 | 93.550049 | 93.588124 | 2896.0 |
| 2010-01-03 23:00:00 | ZN | Futures | 93.600816 | 93.600816 | 93.499282 | 93.511974 | 2860.0 |
> showing 36 of 235 rows — these rows as CSV