PREVIEW / futures_5min / 2011-10-31
file: by_date/futures_5min/2011/2011-10-31.parquet size: 250 KB rows: 13,647
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-10-31 00:00:00 | ES | Futures | 1275.86 | 1276.11 | 1275.36 | 1275.86 | 953.0 |
| 2011-10-31 00:05:00 | ES | Futures | 1276.11 | 1276.11 | 1274.85 | 1275.1 | 1402.0 |
| 2011-10-31 00:10:00 | ES | Futures | 1275.1 | 1275.1 | 1273.85 | 1274.35 | 1148.0 |
| 2011-10-31 00:15:00 | ES | Futures | 1274.35 | 1274.85 | 1273.85 | 1274.1 | 620.0 |
| 2011-10-31 00:20:00 | ES | Futures | 1274.1 | 1274.6 | 1273.1 | 1274.6 | 2092.0 |
| 2011-10-31 00:25:00 | ES | Futures | 1274.6 | 1275.1 | 1273.85 | 1275.1 | 403.0 |
| 2011-10-31 00:30:00 | ES | Futures | 1275.1 | 1275.86 | 1274.85 | 1275.36 | 907.0 |
| 2011-10-31 00:35:00 | ES | Futures | 1275.36 | 1275.61 | 1274.85 | 1275.61 | 238.0 |
| 2011-10-31 00:40:00 | ES | Futures | 1275.61 | 1276.36 | 1275.36 | 1275.36 | 383.0 |
| 2011-10-31 00:45:00 | ES | Futures | 1275.36 | 1275.86 | 1274.85 | 1275.61 | 435.0 |
| 2011-10-31 00:50:00 | ES | Futures | 1275.61 | 1275.61 | 1275.1 | 1275.61 | 133.0 |
| 2011-10-31 00:55:00 | ES | Futures | 1275.61 | 1275.86 | 1274.6 | 1274.85 | 492.0 |
| 2011-10-31 01:00:00 | ES | Futures | 1274.6 | 1274.85 | 1273.35 | 1273.85 | 1350.0 |
| 2011-10-31 01:05:00 | ES | Futures | 1273.85 | 1273.85 | 1272.6 | 1272.85 | 1130.0 |
| 2011-10-31 01:10:00 | ES | Futures | 1272.6 | 1272.85 | 1271.09 | 1271.84 | 3182.0 |
| 2011-10-31 01:15:00 | ES | Futures | 1272.1 | 1272.6 | 1271.84 | 1272.1 | 544.0 |
| 2011-10-31 01:20:00 | ES | Futures | 1272.1 | 1272.85 | 1272.1 | 1272.6 | 799.0 |
| 2011-10-31 01:25:00 | ES | Futures | 1272.6 | 1272.85 | 1271.59 | 1272.35 | 913.0 |
| 2011-10-31 01:30:00 | ES | Futures | 1272.6 | 1273.1 | 1272.1 | 1272.35 | 499.0 |
| 2011-10-31 01:35:00 | ES | Futures | 1272.6 | 1272.6 | 1272.1 | 1272.1 | 264.0 |
| 2011-10-31 01:40:00 | ES | Futures | 1272.1 | 1273.35 | 1271.84 | 1273.35 | 754.0 |
| 2011-10-31 01:45:00 | ES | Futures | 1273.35 | 1273.6 | 1273.1 | 1273.1 | 539.0 |
| 2011-10-31 01:50:00 | ES | Futures | 1273.35 | 1274.1 | 1273.1 | 1274.1 | 703.0 |
| 2011-10-31 01:55:00 | ES | Futures | 1273.85 | 1274.6 | 1273.6 | 1273.85 | 670.0 |
| 2011-10-31 02:00:00 | ES | Futures | 1273.6 | 1274.1 | 1272.85 | 1274.1 | 1070.0 |
| 2011-10-31 02:05:00 | ES | Futures | 1274.1 | 1274.6 | 1273.1 | 1273.35 | 669.0 |
| 2011-10-31 02:10:00 | ES | Futures | 1273.35 | 1273.6 | 1272.85 | 1273.1 | 394.0 |
| 2011-10-31 02:15:00 | ES | Futures | 1273.1 | 1273.6 | 1272.85 | 1272.85 | 593.0 |
| 2011-10-31 02:20:00 | ES | Futures | 1272.6 | 1272.6 | 1271.59 | 1272.35 | 939.0 |
| 2011-10-31 02:25:00 | ES | Futures | 1272.1 | 1272.6 | 1271.84 | 1272.1 | 330.0 |
| 2011-10-31 02:30:00 | ES | Futures | 1272.1 | 1272.1 | 1271.59 | 1271.84 | 318.0 |
| 2011-10-31 02:35:00 | ES | Futures | 1271.84 | 1273.6 | 1271.84 | 1273.35 | 899.0 |
| 2011-10-31 02:40:00 | ES | Futures | 1273.35 | 1274.1 | 1273.1 | 1274.1 | 647.0 |
| 2011-10-31 02:45:00 | ES | Futures | 1274.1 | 1274.1 | 1273.35 | 1273.6 | 360.0 |
| 2011-10-31 02:50:00 | ES | Futures | 1273.6 | 1274.35 | 1273.35 | 1274.1 | 432.0 |
| 2011-10-31 02:55:00 | ES | Futures | 1274.35 | 1275.61 | 1274.1 | 1274.85 | 1060.0 |
| 2011-10-31 03:00:00 | ES | Futures | 1274.6 | 1274.85 | 1274.1 | 1274.35 | 1553.0 |
| 2011-10-31 03:05:00 | ES | Futures | 1274.1 | 1275.36 | 1273.6 | 1274.85 | 1588.0 |
| 2011-10-31 03:10:00 | ES | Futures | 1275.1 | 1275.36 | 1274.6 | 1274.6 | 768.0 |
| 2011-10-31 03:15:00 | ES | Futures | 1274.85 | 1275.86 | 1274.85 | 1275.1 | 1139.0 |
| 2011-10-31 03:20:00 | ES | Futures | 1275.36 | 1275.36 | 1274.35 | 1274.6 | 514.0 |
| 2011-10-31 03:25:00 | ES | Futures | 1274.35 | 1274.85 | 1274.35 | 1274.6 | 537.0 |
| 2011-10-31 03:30:00 | ES | Futures | 1274.6 | 1274.85 | 1274.1 | 1274.85 | 854.0 |
| 2011-10-31 03:35:00 | ES | Futures | 1274.85 | 1276.86 | 1274.85 | 1276.61 | 1546.0 |
| 2011-10-31 03:40:00 | ES | Futures | 1276.61 | 1276.61 | 1275.86 | 1276.11 | 1137.0 |
| 2011-10-31 03:45:00 | ES | Futures | 1275.86 | 1277.61 | 1275.61 | 1277.36 | 2011.0 |
| 2011-10-31 03:50:00 | ES | Futures | 1277.36 | 1278.11 | 1276.86 | 1277.61 | 951.0 |
| 2011-10-31 03:55:00 | ES | Futures | 1277.61 | 1277.61 | 1275.86 | 1275.86 | 948.0 |
| 2011-10-31 04:00:00 | ES | Futures | 1275.86 | 1276.11 | 1274.35 | 1275.61 | 4750.0 |
| 2011-10-31 04:05:00 | ES | Futures | 1275.61 | 1276.86 | 1275.1 | 1275.36 | 3701.0 |
> showing 50 of 13,647 rows — these rows as CSV