PREVIEW / futures_5min / 2010-07-27
file: by_date/futures_5min/2010/2010-07-27.parquet size: 199 KB rows: 12,145
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-07-27 00:00:00 | ES | Futures | 1087.28 | 1087.52 | 1087.03 | 1087.28 | 165.0 |
| 2010-07-27 00:05:00 | ES | Futures | 1087.28 | 1087.52 | 1087.28 | 1087.28 | 79.0 |
| 2010-07-27 00:10:00 | ES | Futures | 1087.52 | 1087.52 | 1087.28 | 1087.52 | 98.0 |
| 2010-07-27 00:15:00 | ES | Futures | 1087.28 | 1087.52 | 1087.03 | 1087.03 | 221.0 |
| 2010-07-27 00:20:00 | ES | Futures | 1087.28 | 1087.52 | 1087.03 | 1087.28 | 74.0 |
| 2010-07-27 00:25:00 | ES | Futures | 1087.28 | 1087.28 | 1086.54 | 1086.54 | 625.0 |
| 2010-07-27 00:30:00 | ES | Futures | 1086.54 | 1087.03 | 1086.54 | 1086.79 | 496.0 |
| 2010-07-27 00:35:00 | ES | Futures | 1087.03 | 1087.03 | 1086.54 | 1086.79 | 92.0 |
| 2010-07-27 00:40:00 | ES | Futures | 1086.79 | 1087.03 | 1086.54 | 1086.79 | 409.0 |
| 2010-07-27 00:45:00 | ES | Futures | 1087.03 | 1087.77 | 1087.03 | 1087.28 | 752.0 |
| 2010-07-27 00:50:00 | ES | Futures | 1087.28 | 1087.52 | 1087.03 | 1087.28 | 530.0 |
| 2010-07-27 00:55:00 | ES | Futures | 1087.28 | 1087.52 | 1087.03 | 1087.28 | 56.0 |
| 2010-07-27 01:00:00 | ES | Futures | 1087.28 | 1087.28 | 1086.79 | 1086.79 | 335.0 |
| 2010-07-27 01:05:00 | ES | Futures | 1086.79 | 1087.03 | 1086.54 | 1086.54 | 234.0 |
| 2010-07-27 01:10:00 | ES | Futures | 1086.79 | 1087.03 | 1086.54 | 1086.79 | 193.0 |
| 2010-07-27 01:15:00 | ES | Futures | 1086.79 | 1087.03 | 1086.54 | 1087.03 | 266.0 |
| 2010-07-27 01:20:00 | ES | Futures | 1086.79 | 1087.03 | 1086.54 | 1086.54 | 279.0 |
| 2010-07-27 01:25:00 | ES | Futures | 1086.79 | 1086.79 | 1086.54 | 1086.79 | 15.0 |
| 2010-07-27 01:30:00 | ES | Futures | 1086.79 | 1087.52 | 1086.79 | 1087.28 | 390.0 |
| 2010-07-27 01:35:00 | ES | Futures | 1087.03 | 1087.03 | 1086.79 | 1086.79 | 400.0 |
| 2010-07-27 01:40:00 | ES | Futures | 1086.79 | 1087.03 | 1086.54 | 1086.79 | 20.0 |
| 2010-07-27 01:45:00 | ES | Futures | 1086.79 | 1087.03 | 1086.79 | 1087.03 | 52.0 |
| 2010-07-27 01:50:00 | ES | Futures | 1087.03 | 1087.03 | 1086.54 | 1087.03 | 234.0 |
| 2010-07-27 01:55:00 | ES | Futures | 1087.03 | 1087.28 | 1086.79 | 1087.03 | 429.0 |
| 2010-07-27 02:00:00 | ES | Futures | 1087.03 | 1087.77 | 1086.79 | 1087.52 | 852.0 |
| 2010-07-27 02:05:00 | ES | Futures | 1087.52 | 1087.52 | 1086.79 | 1087.03 | 631.0 |
| 2010-07-27 02:10:00 | ES | Futures | 1087.03 | 1087.28 | 1086.3 | 1086.54 | 1224.0 |
| 2010-07-27 02:15:00 | ES | Futures | 1086.54 | 1087.28 | 1086.54 | 1087.03 | 445.0 |
| 2010-07-27 02:20:00 | ES | Futures | 1087.28 | 1088.01 | 1087.28 | 1087.77 | 990.0 |
| 2010-07-27 02:25:00 | ES | Futures | 1087.77 | 1088.26 | 1087.52 | 1088.01 | 357.0 |
| 2010-07-27 02:30:00 | ES | Futures | 1088.01 | 1088.99 | 1088.01 | 1088.5 | 1348.0 |
| 2010-07-27 02:35:00 | ES | Futures | 1088.75 | 1088.99 | 1088.26 | 1088.5 | 562.0 |
| 2010-07-27 02:40:00 | ES | Futures | 1088.75 | 1089.24 | 1088.5 | 1089.24 | 469.0 |
| 2010-07-27 02:45:00 | ES | Futures | 1089.24 | 1091.94 | 1088.99 | 1091.2 | 4486.0 |
| 2010-07-27 02:50:00 | ES | Futures | 1091.2 | 1091.45 | 1090.22 | 1090.71 | 2272.0 |
| 2010-07-27 02:55:00 | ES | Futures | 1090.71 | 1090.96 | 1090.22 | 1090.71 | 1182.0 |
| 2010-07-27 03:00:00 | ES | Futures | 1090.71 | 1091.45 | 1090.22 | 1091.2 | 4324.0 |
| 2010-07-27 03:05:00 | ES | Futures | 1090.96 | 1091.69 | 1090.96 | 1091.2 | 2053.0 |
| 2010-07-27 03:10:00 | ES | Futures | 1090.96 | 1092.18 | 1090.96 | 1091.94 | 2232.0 |
| 2010-07-27 03:15:00 | ES | Futures | 1092.18 | 1092.18 | 1090.96 | 1091.45 | 2356.0 |
| 2010-07-27 03:20:00 | ES | Futures | 1091.2 | 1091.45 | 1090.71 | 1090.96 | 2283.0 |
| 2010-07-27 03:25:00 | ES | Futures | 1091.2 | 1092.43 | 1090.96 | 1092.18 | 2857.0 |
| 2010-07-27 03:30:00 | ES | Futures | 1092.18 | 1092.92 | 1091.94 | 1092.43 | 3138.0 |
| 2010-07-27 03:35:00 | ES | Futures | 1092.43 | 1093.17 | 1092.18 | 1092.92 | 1586.0 |
| 2010-07-27 03:40:00 | ES | Futures | 1093.17 | 1093.41 | 1092.67 | 1093.17 | 3084.0 |
| 2010-07-27 03:45:00 | ES | Futures | 1092.92 | 1093.41 | 1091.94 | 1092.18 | 2703.0 |
| 2010-07-27 03:50:00 | ES | Futures | 1092.18 | 1092.67 | 1091.94 | 1092.18 | 1890.0 |
| 2010-07-27 03:55:00 | ES | Futures | 1092.18 | 1092.43 | 1091.69 | 1092.43 | 2441.0 |
| 2010-07-27 04:00:00 | ES | Futures | 1092.43 | 1092.92 | 1091.69 | 1092.67 | 1701.0 |
| 2010-07-27 04:05:00 | ES | Futures | 1092.67 | 1093.9 | 1092.43 | 1093.66 | 3615.0 |
> showing 50 of 12,145 rows — these rows as CSV