PREVIEW / futures_5min / 2011-01-23
file: by_date/futures_5min/2011/2011-01-23.parquet size: 47 KB rows: 2,285
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-23 18:00:00 | ES | Futures | 1266.33 | 1267.07 | 1265.84 | 1267.07 | 2116.0 |
| 2011-01-23 18:05:00 | ES | Futures | 1267.07 | 1267.07 | 1266.33 | 1266.33 | 751.0 |
| 2011-01-23 18:10:00 | ES | Futures | 1266.33 | 1266.33 | 1265.84 | 1266.08 | 450.0 |
| 2011-01-23 18:15:00 | ES | Futures | 1266.08 | 1266.08 | 1265.84 | 1265.84 | 384.0 |
| 2011-01-23 18:20:00 | ES | Futures | 1265.84 | 1266.33 | 1265.34 | 1265.34 | 983.0 |
| 2011-01-23 18:25:00 | ES | Futures | 1265.59 | 1265.59 | 1265.09 | 1265.59 | 481.0 |
| 2011-01-23 18:30:00 | ES | Futures | 1265.34 | 1265.59 | 1265.34 | 1265.59 | 249.0 |
| 2011-01-23 18:35:00 | ES | Futures | 1265.59 | 1265.59 | 1264.6 | 1264.85 | 863.0 |
| 2011-01-23 18:40:00 | ES | Futures | 1265.09 | 1265.09 | 1264.85 | 1265.09 | 115.0 |
| 2011-01-23 18:45:00 | ES | Futures | 1264.85 | 1265.34 | 1264.85 | 1265.34 | 115.0 |
| 2011-01-23 18:50:00 | ES | Futures | 1265.34 | 1265.84 | 1265.34 | 1265.59 | 213.0 |
| 2011-01-23 18:55:00 | ES | Futures | 1265.34 | 1266.08 | 1265.34 | 1266.08 | 231.0 |
| 2011-01-23 19:00:00 | ES | Futures | 1266.08 | 1266.83 | 1266.08 | 1266.83 | 588.0 |
| 2011-01-23 19:05:00 | ES | Futures | 1266.83 | 1267.32 | 1266.33 | 1266.58 | 1045.0 |
| 2011-01-23 19:10:00 | ES | Futures | 1266.58 | 1266.58 | 1265.59 | 1265.84 | 702.0 |
| 2011-01-23 19:15:00 | ES | Futures | 1265.59 | 1265.84 | 1265.09 | 1265.59 | 401.0 |
| 2011-01-23 19:20:00 | ES | Futures | 1265.34 | 1265.84 | 1265.09 | 1265.09 | 419.0 |
| 2011-01-23 19:25:00 | ES | Futures | 1265.09 | 1265.59 | 1264.85 | 1265.59 | 452.0 |
| 2011-01-23 19:30:00 | ES | Futures | 1265.34 | 1265.84 | 1264.85 | 1265.84 | 407.0 |
| 2011-01-23 19:35:00 | ES | Futures | 1265.59 | 1265.84 | 1265.34 | 1265.84 | 410.0 |
| 2011-01-23 19:40:00 | ES | Futures | 1265.84 | 1266.58 | 1265.84 | 1266.33 | 422.0 |
| 2011-01-23 19:45:00 | ES | Futures | 1266.08 | 1266.33 | 1265.59 | 1265.84 | 457.0 |
| 2011-01-23 19:50:00 | ES | Futures | 1266.08 | 1266.33 | 1265.84 | 1266.33 | 147.0 |
| 2011-01-23 19:55:00 | ES | Futures | 1266.58 | 1267.57 | 1266.58 | 1267.07 | 1176.0 |
| 2011-01-23 20:00:00 | ES | Futures | 1266.83 | 1267.32 | 1266.33 | 1266.33 | 399.0 |
| 2011-01-23 20:05:00 | ES | Futures | 1266.33 | 1267.82 | 1266.33 | 1267.82 | 697.0 |
| 2011-01-23 20:10:00 | ES | Futures | 1267.57 | 1267.82 | 1267.07 | 1267.57 | 616.0 |
| 2011-01-23 20:15:00 | ES | Futures | 1267.57 | 1267.82 | 1267.07 | 1267.32 | 216.0 |
| 2011-01-23 20:20:00 | ES | Futures | 1267.07 | 1267.32 | 1267.07 | 1267.32 | 136.0 |
| 2011-01-23 20:25:00 | ES | Futures | 1267.57 | 1267.82 | 1267.07 | 1267.57 | 350.0 |
| 2011-01-23 20:30:00 | ES | Futures | 1267.82 | 1268.06 | 1267.57 | 1268.06 | 731.0 |
| 2011-01-23 20:35:00 | ES | Futures | 1268.06 | 1268.31 | 1267.82 | 1268.06 | 501.0 |
| 2011-01-23 20:40:00 | ES | Futures | 1268.06 | 1268.31 | 1267.82 | 1268.06 | 315.0 |
| 2011-01-23 20:45:00 | ES | Futures | 1267.82 | 1268.06 | 1267.07 | 1267.57 | 638.0 |
| 2011-01-23 20:50:00 | ES | Futures | 1267.57 | 1267.82 | 1267.57 | 1267.57 | 275.0 |
| 2011-01-23 20:55:00 | ES | Futures | 1267.82 | 1268.31 | 1267.32 | 1268.06 | 278.0 |
| 2011-01-23 21:00:00 | ES | Futures | 1268.06 | 1268.31 | 1267.57 | 1268.31 | 268.0 |
| 2011-01-23 21:05:00 | ES | Futures | 1268.31 | 1268.56 | 1267.82 | 1268.06 | 638.0 |
| 2011-01-23 21:10:00 | ES | Futures | 1268.06 | 1268.31 | 1267.82 | 1268.31 | 109.0 |
| 2011-01-23 21:15:00 | ES | Futures | 1268.31 | 1268.81 | 1268.31 | 1268.81 | 261.0 |
| 2011-01-23 21:20:00 | ES | Futures | 1268.81 | 1269.3 | 1268.31 | 1269.05 | 756.0 |
| 2011-01-23 21:25:00 | ES | Futures | 1269.05 | 1269.55 | 1268.81 | 1269.55 | 751.0 |
| 2011-01-23 21:30:00 | ES | Futures | 1269.55 | 1269.55 | 1269.3 | 1269.55 | 428.0 |
| 2011-01-23 21:35:00 | ES | Futures | 1269.3 | 1269.55 | 1269.05 | 1269.05 | 188.0 |
| 2011-01-23 21:40:00 | ES | Futures | 1269.3 | 1269.8 | 1269.3 | 1269.55 | 276.0 |
| 2011-01-23 21:45:00 | ES | Futures | 1269.55 | 1269.8 | 1269.05 | 1269.3 | 228.0 |
| 2011-01-23 21:50:00 | ES | Futures | 1269.3 | 1269.3 | 1269.05 | 1269.3 | 105.0 |
| 2011-01-23 21:55:00 | ES | Futures | 1269.3 | 1269.3 | 1268.81 | 1268.81 | 312.0 |
| 2011-01-23 22:00:00 | ES | Futures | 1268.81 | 1269.05 | 1268.56 | 1268.81 | 300.0 |
| 2011-01-23 22:05:00 | ES | Futures | 1268.81 | 1269.05 | 1268.81 | 1269.05 | 263.0 |
> showing 50 of 2,285 rows — these rows as CSV