PREVIEW / futures_5min / 2011-01-26
file: by_date/futures_5min/2011/2011-01-26.parquet size: 225 KB rows: 13,464
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-26 00:00:00 | ES | Futures | 1277.22 | 1277.22 | 1276.72 | 1276.72 | 181.0 |
| 2011-01-26 00:05:00 | ES | Futures | 1276.72 | 1276.97 | 1276.72 | 1276.97 | 181.0 |
| 2011-01-26 00:10:00 | ES | Futures | 1276.97 | 1276.97 | 1276.72 | 1276.97 | 166.0 |
| 2011-01-26 00:15:00 | ES | Futures | 1276.72 | 1277.22 | 1276.72 | 1277.22 | 146.0 |
| 2011-01-26 00:20:00 | ES | Futures | 1277.22 | 1277.71 | 1276.97 | 1277.71 | 322.0 |
| 2011-01-26 00:25:00 | ES | Futures | 1277.47 | 1277.71 | 1277.22 | 1277.71 | 246.0 |
| 2011-01-26 00:30:00 | ES | Futures | 1277.47 | 1279.69 | 1277.47 | 1278.46 | 4084.0 |
| 2011-01-26 00:35:00 | ES | Futures | 1278.21 | 1278.95 | 1278.21 | 1278.46 | 855.0 |
| 2011-01-26 00:40:00 | ES | Futures | 1278.46 | 1278.95 | 1278.21 | 1278.46 | 540.0 |
| 2011-01-26 00:45:00 | ES | Futures | 1278.46 | 1278.7 | 1278.46 | 1278.46 | 195.0 |
| 2011-01-26 00:50:00 | ES | Futures | 1278.46 | 1278.7 | 1278.21 | 1278.7 | 269.0 |
| 2011-01-26 00:55:00 | ES | Futures | 1278.7 | 1278.7 | 1278.21 | 1278.46 | 294.0 |
| 2011-01-26 01:00:00 | ES | Futures | 1278.21 | 1278.7 | 1278.21 | 1278.46 | 284.0 |
| 2011-01-26 01:05:00 | ES | Futures | 1278.46 | 1278.95 | 1277.96 | 1278.7 | 426.0 |
| 2011-01-26 01:10:00 | ES | Futures | 1278.46 | 1279.2 | 1278.21 | 1278.7 | 1005.0 |
| 2011-01-26 01:15:00 | ES | Futures | 1278.7 | 1279.2 | 1278.46 | 1278.95 | 493.0 |
| 2011-01-26 01:20:00 | ES | Futures | 1278.95 | 1279.2 | 1278.95 | 1278.95 | 256.0 |
| 2011-01-26 01:25:00 | ES | Futures | 1278.7 | 1278.7 | 1278.46 | 1278.46 | 216.0 |
| 2011-01-26 01:30:00 | ES | Futures | 1278.46 | 1278.7 | 1278.21 | 1278.21 | 251.0 |
| 2011-01-26 01:35:00 | ES | Futures | 1278.21 | 1278.21 | 1277.96 | 1278.21 | 83.0 |
| 2011-01-26 01:40:00 | ES | Futures | 1278.21 | 1278.21 | 1277.96 | 1278.21 | 191.0 |
| 2011-01-26 01:45:00 | ES | Futures | 1278.21 | 1278.46 | 1278.21 | 1278.46 | 88.0 |
| 2011-01-26 01:50:00 | ES | Futures | 1278.46 | 1278.46 | 1277.71 | 1277.96 | 429.0 |
| 2011-01-26 01:55:00 | ES | Futures | 1277.96 | 1277.96 | 1277.47 | 1277.71 | 206.0 |
| 2011-01-26 02:00:00 | ES | Futures | 1277.47 | 1277.71 | 1276.97 | 1277.22 | 1194.0 |
| 2011-01-26 02:05:00 | ES | Futures | 1277.22 | 1278.46 | 1277.22 | 1278.46 | 1095.0 |
| 2011-01-26 02:10:00 | ES | Futures | 1278.21 | 1278.46 | 1277.96 | 1278.21 | 739.0 |
| 2011-01-26 02:15:00 | ES | Futures | 1277.96 | 1278.21 | 1277.96 | 1278.21 | 148.0 |
| 2011-01-26 02:20:00 | ES | Futures | 1277.96 | 1278.21 | 1277.96 | 1278.21 | 287.0 |
| 2011-01-26 02:25:00 | ES | Futures | 1277.96 | 1278.21 | 1277.71 | 1277.71 | 321.0 |
| 2011-01-26 02:30:00 | ES | Futures | 1277.96 | 1277.96 | 1277.47 | 1277.71 | 483.0 |
| 2011-01-26 02:35:00 | ES | Futures | 1277.71 | 1277.96 | 1277.22 | 1277.47 | 807.0 |
| 2011-01-26 02:40:00 | ES | Futures | 1277.47 | 1277.71 | 1277.22 | 1277.71 | 475.0 |
| 2011-01-26 02:45:00 | ES | Futures | 1277.47 | 1278.21 | 1277.47 | 1277.96 | 432.0 |
| 2011-01-26 02:50:00 | ES | Futures | 1277.96 | 1277.96 | 1276.23 | 1276.48 | 3174.0 |
| 2011-01-26 02:55:00 | ES | Futures | 1276.23 | 1277.22 | 1276.23 | 1276.97 | 951.0 |
| 2011-01-26 03:00:00 | ES | Futures | 1276.72 | 1277.22 | 1276.23 | 1276.72 | 2578.0 |
| 2011-01-26 03:05:00 | ES | Futures | 1276.97 | 1276.97 | 1276.23 | 1276.48 | 1468.0 |
| 2011-01-26 03:10:00 | ES | Futures | 1276.48 | 1276.97 | 1276.48 | 1276.48 | 1882.0 |
| 2011-01-26 03:15:00 | ES | Futures | 1276.48 | 1277.47 | 1276.48 | 1277.47 | 894.0 |
| 2011-01-26 03:20:00 | ES | Futures | 1277.47 | 1277.71 | 1277.22 | 1277.71 | 891.0 |
| 2011-01-26 03:25:00 | ES | Futures | 1277.71 | 1277.96 | 1277.47 | 1277.71 | 1170.0 |
| 2011-01-26 03:30:00 | ES | Futures | 1277.96 | 1277.96 | 1277.47 | 1277.71 | 944.0 |
| 2011-01-26 03:35:00 | ES | Futures | 1277.47 | 1277.96 | 1277.22 | 1277.22 | 1130.0 |
| 2011-01-26 03:40:00 | ES | Futures | 1277.47 | 1277.96 | 1277.47 | 1277.96 | 715.0 |
| 2011-01-26 03:45:00 | ES | Futures | 1277.96 | 1279.45 | 1277.71 | 1278.21 | 4494.0 |
| 2011-01-26 03:50:00 | ES | Futures | 1278.21 | 1279.2 | 1278.21 | 1278.7 | 1943.0 |
| 2011-01-26 03:55:00 | ES | Futures | 1278.95 | 1279.2 | 1278.7 | 1278.95 | 1552.0 |
| 2011-01-26 04:00:00 | ES | Futures | 1278.95 | 1279.45 | 1278.7 | 1279.2 | 1735.0 |
| 2011-01-26 04:05:00 | ES | Futures | 1279.2 | 1279.45 | 1278.7 | 1279.2 | 1192.0 |
> showing 50 of 13,464 rows — these rows as CSV