PREVIEW / futures_5min / 2011-01-24
file: by_date/futures_5min/2011/2011-01-24.parquet size: 224 KB rows: 13,174
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-24 00:00:00 | ES | Futures | 1269.8 | 1270.04 | 1269.8 | 1270.04 | 102.0 |
| 2011-01-24 00:05:00 | ES | Futures | 1269.8 | 1270.04 | 1269.8 | 1270.04 | 198.0 |
| 2011-01-24 00:10:00 | ES | Futures | 1269.8 | 1270.04 | 1269.55 | 1269.8 | 67.0 |
| 2011-01-24 00:15:00 | ES | Futures | 1269.8 | 1270.04 | 1269.55 | 1269.8 | 103.0 |
| 2011-01-24 00:20:00 | ES | Futures | 1269.55 | 1270.04 | 1269.55 | 1270.04 | 232.0 |
| 2011-01-24 00:25:00 | ES | Futures | 1270.29 | 1270.29 | 1270.04 | 1270.29 | 200.0 |
| 2011-01-24 00:30:00 | ES | Futures | 1270.04 | 1270.54 | 1270.04 | 1270.29 | 383.0 |
| 2011-01-24 00:35:00 | ES | Futures | 1270.54 | 1270.54 | 1270.29 | 1270.29 | 339.0 |
| 2011-01-24 00:40:00 | ES | Futures | 1270.54 | 1270.79 | 1270.29 | 1270.79 | 264.0 |
| 2011-01-24 00:45:00 | ES | Futures | 1270.79 | 1270.79 | 1270.29 | 1270.54 | 287.0 |
| 2011-01-24 00:50:00 | ES | Futures | 1270.54 | 1270.79 | 1270.29 | 1270.54 | 177.0 |
| 2011-01-24 00:55:00 | ES | Futures | 1270.29 | 1270.79 | 1270.29 | 1270.54 | 156.0 |
| 2011-01-24 01:00:00 | ES | Futures | 1270.79 | 1271.53 | 1270.54 | 1271.53 | 1097.0 |
| 2011-01-24 01:05:00 | ES | Futures | 1271.28 | 1271.78 | 1271.03 | 1271.53 | 1343.0 |
| 2011-01-24 01:10:00 | ES | Futures | 1271.53 | 1272.02 | 1271.28 | 1271.78 | 903.0 |
| 2011-01-24 01:15:00 | ES | Futures | 1272.02 | 1272.02 | 1271.53 | 1271.53 | 265.0 |
| 2011-01-24 01:20:00 | ES | Futures | 1271.53 | 1272.02 | 1271.53 | 1271.78 | 135.0 |
| 2011-01-24 01:25:00 | ES | Futures | 1271.78 | 1271.78 | 1271.03 | 1271.03 | 267.0 |
| 2011-01-24 01:30:00 | ES | Futures | 1271.28 | 1271.28 | 1270.54 | 1270.79 | 511.0 |
| 2011-01-24 01:35:00 | ES | Futures | 1271.03 | 1271.28 | 1270.79 | 1271.03 | 147.0 |
| 2011-01-24 01:40:00 | ES | Futures | 1271.03 | 1271.03 | 1270.54 | 1270.79 | 247.0 |
| 2011-01-24 01:45:00 | ES | Futures | 1270.54 | 1270.79 | 1270.29 | 1270.79 | 145.0 |
| 2011-01-24 01:50:00 | ES | Futures | 1270.79 | 1271.53 | 1270.79 | 1271.28 | 783.0 |
| 2011-01-24 01:55:00 | ES | Futures | 1271.28 | 1271.28 | 1270.79 | 1271.03 | 276.0 |
| 2011-01-24 02:00:00 | ES | Futures | 1271.28 | 1271.28 | 1270.04 | 1270.29 | 1146.0 |
| 2011-01-24 02:05:00 | ES | Futures | 1270.54 | 1270.54 | 1270.04 | 1270.54 | 588.0 |
| 2011-01-24 02:10:00 | ES | Futures | 1270.54 | 1270.79 | 1270.04 | 1270.04 | 704.0 |
| 2011-01-24 02:15:00 | ES | Futures | 1270.29 | 1270.79 | 1270.04 | 1270.54 | 587.0 |
| 2011-01-24 02:20:00 | ES | Futures | 1270.54 | 1270.54 | 1269.8 | 1270.29 | 440.0 |
| 2011-01-24 02:25:00 | ES | Futures | 1270.29 | 1270.79 | 1270.29 | 1270.79 | 405.0 |
| 2011-01-24 02:30:00 | ES | Futures | 1270.79 | 1270.79 | 1270.04 | 1270.29 | 420.0 |
| 2011-01-24 02:35:00 | ES | Futures | 1270.29 | 1270.54 | 1270.29 | 1270.29 | 93.0 |
| 2011-01-24 02:40:00 | ES | Futures | 1270.29 | 1270.79 | 1270.29 | 1270.54 | 777.0 |
| 2011-01-24 02:45:00 | ES | Futures | 1270.54 | 1270.54 | 1269.8 | 1269.8 | 336.0 |
| 2011-01-24 02:50:00 | ES | Futures | 1269.8 | 1269.8 | 1269.05 | 1269.3 | 666.0 |
| 2011-01-24 02:55:00 | ES | Futures | 1269.3 | 1269.55 | 1269.05 | 1269.3 | 614.0 |
| 2011-01-24 03:00:00 | ES | Futures | 1269.55 | 1270.79 | 1269.55 | 1270.04 | 2708.0 |
| 2011-01-24 03:05:00 | ES | Futures | 1270.29 | 1271.28 | 1269.8 | 1270.54 | 2362.0 |
| 2011-01-24 03:10:00 | ES | Futures | 1270.54 | 1270.79 | 1269.8 | 1270.04 | 1391.0 |
| 2011-01-24 03:15:00 | ES | Futures | 1270.29 | 1270.29 | 1269.55 | 1269.8 | 781.0 |
| 2011-01-24 03:20:00 | ES | Futures | 1269.8 | 1270.04 | 1268.56 | 1268.56 | 2110.0 |
| 2011-01-24 03:25:00 | ES | Futures | 1268.81 | 1268.81 | 1267.57 | 1268.31 | 3814.0 |
| 2011-01-24 03:30:00 | ES | Futures | 1268.06 | 1268.31 | 1267.57 | 1267.57 | 1810.0 |
| 2011-01-24 03:35:00 | ES | Futures | 1267.82 | 1269.05 | 1267.57 | 1268.56 | 2893.0 |
| 2011-01-24 03:40:00 | ES | Futures | 1268.81 | 1269.55 | 1268.31 | 1269.05 | 1534.0 |
| 2011-01-24 03:45:00 | ES | Futures | 1268.81 | 1269.3 | 1268.31 | 1268.56 | 879.0 |
| 2011-01-24 03:50:00 | ES | Futures | 1268.56 | 1269.05 | 1267.57 | 1267.57 | 1906.0 |
| 2011-01-24 03:55:00 | ES | Futures | 1267.57 | 1268.06 | 1266.08 | 1267.57 | 6101.0 |
| 2011-01-24 04:00:00 | ES | Futures | 1267.57 | 1268.06 | 1267.32 | 1267.57 | 1957.0 |
| 2011-01-24 04:05:00 | ES | Futures | 1267.57 | 1267.57 | 1266.33 | 1266.58 | 1490.0 |
> showing 50 of 13,174 rows — these rows as CSV