PREVIEW / futures_5min / 2011-07-29
file: by_date/futures_5min/2011/2011-07-29.parquet size: 204 KB rows: 10,719
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-07-29 00:00:00 | ES | Futures | 1285.44 | 1285.69 | 1285.19 | 1285.44 | 201.0 |
| 2011-07-29 00:05:00 | ES | Futures | 1285.44 | 1285.69 | 1285.19 | 1285.44 | 402.0 |
| 2011-07-29 00:10:00 | ES | Futures | 1285.44 | 1285.44 | 1284.44 | 1285.19 | 560.0 |
| 2011-07-29 00:15:00 | ES | Futures | 1285.19 | 1286.43 | 1285.19 | 1286.18 | 337.0 |
| 2011-07-29 00:20:00 | ES | Futures | 1286.18 | 1286.43 | 1285.93 | 1285.93 | 244.0 |
| 2011-07-29 00:25:00 | ES | Futures | 1285.93 | 1286.93 | 1285.69 | 1286.68 | 272.0 |
| 2011-07-29 00:30:00 | ES | Futures | 1286.93 | 1286.93 | 1286.18 | 1286.68 | 281.0 |
| 2011-07-29 00:35:00 | ES | Futures | 1286.68 | 1286.68 | 1286.18 | 1286.43 | 116.0 |
| 2011-07-29 00:40:00 | ES | Futures | 1286.43 | 1286.68 | 1285.93 | 1286.18 | 556.0 |
| 2011-07-29 00:45:00 | ES | Futures | 1286.18 | 1286.43 | 1285.19 | 1285.44 | 319.0 |
| 2011-07-29 00:50:00 | ES | Futures | 1285.44 | 1285.93 | 1285.19 | 1285.44 | 155.0 |
| 2011-07-29 00:55:00 | ES | Futures | 1285.44 | 1286.18 | 1285.44 | 1286.18 | 371.0 |
| 2011-07-29 01:00:00 | ES | Futures | 1286.18 | 1286.68 | 1286.18 | 1286.18 | 564.0 |
| 2011-07-29 01:05:00 | ES | Futures | 1286.18 | 1286.43 | 1285.93 | 1286.43 | 358.0 |
| 2011-07-29 01:10:00 | ES | Futures | 1285.93 | 1286.43 | 1285.69 | 1286.18 | 260.0 |
| 2011-07-29 01:15:00 | ES | Futures | 1286.18 | 1286.93 | 1285.19 | 1285.44 | 803.0 |
| 2011-07-29 01:20:00 | ES | Futures | 1285.44 | 1285.69 | 1284.94 | 1285.19 | 574.0 |
| 2011-07-29 01:25:00 | ES | Futures | 1285.19 | 1285.19 | 1282.44 | 1283.19 | 2550.0 |
| 2011-07-29 01:30:00 | ES | Futures | 1283.19 | 1283.69 | 1282.94 | 1283.19 | 465.0 |
| 2011-07-29 01:35:00 | ES | Futures | 1282.94 | 1284.19 | 1282.94 | 1283.69 | 767.0 |
| 2011-07-29 01:40:00 | ES | Futures | 1283.69 | 1284.19 | 1283.44 | 1283.94 | 224.0 |
| 2011-07-29 01:45:00 | ES | Futures | 1284.19 | 1284.44 | 1283.19 | 1283.44 | 810.0 |
| 2011-07-29 01:50:00 | ES | Futures | 1283.69 | 1284.19 | 1283.44 | 1283.94 | 672.0 |
| 2011-07-29 01:55:00 | ES | Futures | 1284.19 | 1285.69 | 1283.69 | 1285.69 | 1743.0 |
| 2011-07-29 02:00:00 | ES | Futures | 1285.69 | 1286.18 | 1284.94 | 1285.93 | 2773.0 |
| 2011-07-29 02:05:00 | ES | Futures | 1285.93 | 1287.43 | 1285.69 | 1287.18 | 2309.0 |
| 2011-07-29 02:10:00 | ES | Futures | 1287.18 | 1287.43 | 1286.18 | 1287.18 | 1812.0 |
| 2011-07-29 02:15:00 | ES | Futures | 1287.18 | 1288.43 | 1287.18 | 1287.43 | 1815.0 |
| 2011-07-29 02:20:00 | ES | Futures | 1287.43 | 1287.93 | 1286.93 | 1286.93 | 675.0 |
| 2011-07-29 02:25:00 | ES | Futures | 1286.93 | 1287.18 | 1285.19 | 1285.19 | 1516.0 |
| 2011-07-29 02:30:00 | ES | Futures | 1285.44 | 1285.69 | 1284.69 | 1285.44 | 1401.0 |
| 2011-07-29 02:35:00 | ES | Futures | 1285.44 | 1286.18 | 1284.94 | 1285.93 | 1030.0 |
| 2011-07-29 02:40:00 | ES | Futures | 1285.69 | 1286.68 | 1285.69 | 1286.68 | 795.0 |
| 2011-07-29 02:45:00 | ES | Futures | 1286.43 | 1287.43 | 1286.18 | 1287.18 | 1404.0 |
| 2011-07-29 02:50:00 | ES | Futures | 1287.18 | 1287.43 | 1286.93 | 1287.18 | 469.0 |
| 2011-07-29 02:55:00 | ES | Futures | 1287.18 | 1287.43 | 1286.93 | 1287.18 | 410.0 |
| 2011-07-29 03:00:00 | ES | Futures | 1287.18 | 1287.68 | 1286.18 | 1286.18 | 4554.0 |
| 2011-07-29 03:05:00 | ES | Futures | 1285.93 | 1287.18 | 1284.94 | 1286.43 | 4516.0 |
| 2011-07-29 03:10:00 | ES | Futures | 1286.68 | 1288.18 | 1286.18 | 1287.43 | 3018.0 |
| 2011-07-29 03:15:00 | ES | Futures | 1287.68 | 1287.93 | 1286.93 | 1287.43 | 4298.0 |
| 2011-07-29 03:20:00 | ES | Futures | 1287.68 | 1288.18 | 1287.18 | 1287.93 | 3565.0 |
| 2011-07-29 03:25:00 | ES | Futures | 1287.93 | 1288.93 | 1287.18 | 1288.68 | 3515.0 |
| 2011-07-29 03:30:00 | ES | Futures | 1288.68 | 1291.42 | 1288.43 | 1290.42 | 7099.0 |
| 2011-07-29 03:35:00 | ES | Futures | 1290.42 | 1290.42 | 1288.68 | 1288.68 | 3375.0 |
| 2011-07-29 03:40:00 | ES | Futures | 1288.68 | 1289.43 | 1288.18 | 1288.93 | 2319.0 |
| 2011-07-29 03:45:00 | ES | Futures | 1288.68 | 1289.18 | 1288.18 | 1288.18 | 1148.0 |
| 2011-07-29 03:50:00 | ES | Futures | 1288.43 | 1289.18 | 1287.68 | 1287.93 | 3048.0 |
| 2011-07-29 03:55:00 | ES | Futures | 1287.93 | 1287.93 | 1286.93 | 1287.18 | 1705.0 |
| 2011-07-29 04:00:00 | ES | Futures | 1287.43 | 1287.43 | 1285.44 | 1285.93 | 4213.0 |
| 2011-07-29 04:05:00 | ES | Futures | 1285.93 | 1287.18 | 1285.69 | 1286.93 | 1553.0 |
> showing 50 of 10,719 rows — these rows as CSV