PREVIEW / futures_5min / 2011-03-18
file: by_date/futures_5min/2011/2011-03-18.parquet size: 213 KB rows: 11,502
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-03-18 00:00:00 | ES | Futures | 1272.46 | 1273.21 | 1272.21 | 1272.96 | 899.0 |
| 2011-03-18 00:05:00 | ES | Futures | 1272.96 | 1273.45 | 1272.71 | 1273.45 | 1142.0 |
| 2011-03-18 00:10:00 | ES | Futures | 1273.21 | 1273.7 | 1272.71 | 1272.96 | 985.0 |
| 2011-03-18 00:15:00 | ES | Futures | 1272.96 | 1273.7 | 1272.96 | 1273.7 | 612.0 |
| 2011-03-18 00:20:00 | ES | Futures | 1273.45 | 1274.45 | 1273.21 | 1273.95 | 1205.0 |
| 2011-03-18 00:25:00 | ES | Futures | 1273.95 | 1274.45 | 1273.21 | 1273.21 | 958.0 |
| 2011-03-18 00:30:00 | ES | Futures | 1273.21 | 1274.2 | 1273.21 | 1273.21 | 492.0 |
| 2011-03-18 00:35:00 | ES | Futures | 1273.45 | 1273.95 | 1272.96 | 1273.7 | 394.0 |
| 2011-03-18 00:40:00 | ES | Futures | 1273.45 | 1273.7 | 1272.71 | 1272.71 | 205.0 |
| 2011-03-18 00:45:00 | ES | Futures | 1272.71 | 1272.71 | 1271.96 | 1272.21 | 511.0 |
| 2011-03-18 00:50:00 | ES | Futures | 1272.21 | 1272.21 | 1271.72 | 1271.96 | 291.0 |
| 2011-03-18 00:55:00 | ES | Futures | 1271.96 | 1271.96 | 1271.72 | 1271.72 | 242.0 |
| 2011-03-18 01:00:00 | ES | Futures | 1271.96 | 1272.46 | 1271.47 | 1271.72 | 418.0 |
| 2011-03-18 01:05:00 | ES | Futures | 1271.47 | 1272.46 | 1271.47 | 1271.72 | 386.0 |
| 2011-03-18 01:10:00 | ES | Futures | 1271.72 | 1272.96 | 1271.72 | 1272.71 | 237.0 |
| 2011-03-18 01:15:00 | ES | Futures | 1272.71 | 1272.71 | 1271.96 | 1271.96 | 353.0 |
| 2011-03-18 01:20:00 | ES | Futures | 1271.96 | 1272.71 | 1271.47 | 1272.21 | 480.0 |
| 2011-03-18 01:25:00 | ES | Futures | 1272.21 | 1272.46 | 1271.72 | 1271.72 | 618.0 |
| 2011-03-18 01:30:00 | ES | Futures | 1271.72 | 1271.96 | 1271.47 | 1271.47 | 425.0 |
| 2011-03-18 01:35:00 | ES | Futures | 1271.72 | 1271.72 | 1271.22 | 1271.47 | 256.0 |
| 2011-03-18 01:40:00 | ES | Futures | 1271.47 | 1271.72 | 1271.22 | 1271.47 | 91.0 |
| 2011-03-18 01:45:00 | ES | Futures | 1271.47 | 1271.72 | 1271.22 | 1271.22 | 133.0 |
| 2011-03-18 01:50:00 | ES | Futures | 1271.22 | 1271.47 | 1270.47 | 1270.72 | 472.0 |
| 2011-03-18 01:55:00 | ES | Futures | 1270.72 | 1270.97 | 1270.23 | 1270.23 | 455.0 |
| 2011-03-18 02:00:00 | ES | Futures | 1270.47 | 1270.97 | 1269.48 | 1269.73 | 1110.0 |
| 2011-03-18 02:05:00 | ES | Futures | 1269.98 | 1270.47 | 1269.73 | 1269.98 | 239.0 |
| 2011-03-18 02:10:00 | ES | Futures | 1269.98 | 1270.47 | 1269.98 | 1269.98 | 235.0 |
| 2011-03-18 02:15:00 | ES | Futures | 1270.23 | 1270.97 | 1270.23 | 1270.72 | 269.0 |
| 2011-03-18 02:20:00 | ES | Futures | 1270.72 | 1270.97 | 1269.98 | 1270.47 | 214.0 |
| 2011-03-18 02:25:00 | ES | Futures | 1270.47 | 1270.97 | 1269.98 | 1270.23 | 164.0 |
| 2011-03-18 02:30:00 | ES | Futures | 1270.23 | 1270.23 | 1269.48 | 1269.73 | 282.0 |
| 2011-03-18 02:35:00 | ES | Futures | 1269.98 | 1269.98 | 1269.48 | 1269.48 | 124.0 |
| 2011-03-18 02:40:00 | ES | Futures | 1269.73 | 1269.98 | 1269.48 | 1269.73 | 130.0 |
| 2011-03-18 02:45:00 | ES | Futures | 1269.73 | 1269.98 | 1269.73 | 1269.98 | 183.0 |
| 2011-03-18 02:50:00 | ES | Futures | 1269.98 | 1270.23 | 1269.73 | 1270.23 | 223.0 |
| 2011-03-18 02:55:00 | ES | Futures | 1269.98 | 1270.23 | 1269.48 | 1269.73 | 823.0 |
| 2011-03-18 03:00:00 | ES | Futures | 1269.48 | 1270.23 | 1269.48 | 1269.48 | 1959.0 |
| 2011-03-18 03:05:00 | ES | Futures | 1269.48 | 1269.73 | 1269.23 | 1269.73 | 1580.0 |
| 2011-03-18 03:10:00 | ES | Futures | 1269.73 | 1271.96 | 1269.73 | 1271.72 | 2174.0 |
| 2011-03-18 03:15:00 | ES | Futures | 1271.72 | 1272.21 | 1270.97 | 1270.97 | 2261.0 |
| 2011-03-18 03:20:00 | ES | Futures | 1270.97 | 1271.47 | 1270.72 | 1271.47 | 613.0 |
| 2011-03-18 03:25:00 | ES | Futures | 1271.22 | 1271.96 | 1270.72 | 1270.97 | 803.0 |
| 2011-03-18 03:30:00 | ES | Futures | 1270.72 | 1271.22 | 1270.47 | 1270.72 | 1077.0 |
| 2011-03-18 03:35:00 | ES | Futures | 1270.72 | 1270.97 | 1270.47 | 1270.97 | 958.0 |
| 2011-03-18 03:40:00 | ES | Futures | 1270.97 | 1271.22 | 1270.47 | 1270.97 | 793.0 |
| 2011-03-18 03:45:00 | ES | Futures | 1270.97 | 1270.97 | 1268.73 | 1268.98 | 2402.0 |
| 2011-03-18 03:50:00 | ES | Futures | 1268.98 | 1269.48 | 1268.49 | 1268.98 | 2369.0 |
| 2011-03-18 03:55:00 | ES | Futures | 1268.98 | 1268.98 | 1268.49 | 1268.73 | 1134.0 |
| 2011-03-18 04:00:00 | ES | Futures | 1268.98 | 1270.23 | 1268.49 | 1270.23 | 5343.0 |
| 2011-03-18 04:05:00 | ES | Futures | 1270.23 | 1270.72 | 1269.48 | 1270.23 | 4043.0 |
> showing 50 of 11,502 rows — these rows as CSV