PREVIEW / futures_5min / 2011-10-07
file: by_date/futures_5min/2011/2011-10-07.parquet size: 215 KB rows: 11,009
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-07 00:00:00 | ES | Futures | 1162.77 | 1162.77 | 1162.01 | 1162.01 | 356.0 |
| 2011-10-07 00:05:00 | ES | Futures | 1162.01 | 1162.51 | 1161.76 | 1161.76 | 448.0 |
| 2011-10-07 00:10:00 | ES | Futures | 1162.01 | 1162.26 | 1161.51 | 1162.01 | 300.0 |
| 2011-10-07 00:15:00 | ES | Futures | 1162.01 | 1162.26 | 1161.51 | 1161.76 | 281.0 |
| 2011-10-07 00:20:00 | ES | Futures | 1161.51 | 1162.26 | 1161.51 | 1162.01 | 297.0 |
| 2011-10-07 00:25:00 | ES | Futures | 1162.01 | 1162.51 | 1161.51 | 1162.01 | 233.0 |
| 2011-10-07 00:30:00 | ES | Futures | 1162.01 | 1162.26 | 1161.76 | 1162.01 | 184.0 |
| 2011-10-07 00:35:00 | ES | Futures | 1162.26 | 1162.26 | 1161.01 | 1161.26 | 432.0 |
| 2011-10-07 00:40:00 | ES | Futures | 1161.26 | 1161.51 | 1161.01 | 1161.51 | 105.0 |
| 2011-10-07 00:45:00 | ES | Futures | 1161.26 | 1161.51 | 1161.01 | 1161.26 | 162.0 |
| 2011-10-07 00:50:00 | ES | Futures | 1161.51 | 1161.51 | 1161.26 | 1161.51 | 392.0 |
| 2011-10-07 00:55:00 | ES | Futures | 1161.51 | 1161.76 | 1160.76 | 1161.01 | 382.0 |
| 2011-10-07 01:00:00 | ES | Futures | 1160.76 | 1161.51 | 1160.76 | 1161.51 | 356.0 |
| 2011-10-07 01:05:00 | ES | Futures | 1161.26 | 1161.26 | 1160.76 | 1161.26 | 160.0 |
| 2011-10-07 01:10:00 | ES | Futures | 1161.26 | 1161.26 | 1160.26 | 1160.26 | 894.0 |
| 2011-10-07 01:15:00 | ES | Futures | 1160.51 | 1160.51 | 1158.5 | 1159.0 | 1373.0 |
| 2011-10-07 01:20:00 | ES | Futures | 1159.25 | 1160.51 | 1158.75 | 1160.51 | 835.0 |
| 2011-10-07 01:25:00 | ES | Futures | 1160.26 | 1160.51 | 1159.51 | 1160.01 | 528.0 |
| 2011-10-07 01:30:00 | ES | Futures | 1160.26 | 1160.76 | 1159.51 | 1160.51 | 277.0 |
| 2011-10-07 01:35:00 | ES | Futures | 1160.51 | 1160.76 | 1160.26 | 1160.51 | 322.0 |
| 2011-10-07 01:40:00 | ES | Futures | 1160.26 | 1160.76 | 1160.01 | 1160.26 | 256.0 |
| 2011-10-07 01:45:00 | ES | Futures | 1160.26 | 1160.26 | 1159.0 | 1159.51 | 524.0 |
| 2011-10-07 01:50:00 | ES | Futures | 1159.51 | 1159.76 | 1159.0 | 1159.51 | 297.0 |
| 2011-10-07 01:55:00 | ES | Futures | 1159.51 | 1160.01 | 1158.75 | 1159.25 | 479.0 |
| 2011-10-07 02:00:00 | ES | Futures | 1159.25 | 1159.76 | 1158.5 | 1159.51 | 1605.0 |
| 2011-10-07 02:05:00 | ES | Futures | 1159.76 | 1159.76 | 1158.75 | 1159.51 | 1594.0 |
| 2011-10-07 02:10:00 | ES | Futures | 1159.25 | 1159.51 | 1158.75 | 1158.75 | 564.0 |
| 2011-10-07 02:15:00 | ES | Futures | 1158.75 | 1159.76 | 1158.75 | 1159.25 | 1463.0 |
| 2011-10-07 02:20:00 | ES | Futures | 1159.25 | 1160.01 | 1159.25 | 1160.01 | 1076.0 |
| 2011-10-07 02:25:00 | ES | Futures | 1160.01 | 1162.01 | 1160.01 | 1160.51 | 2314.0 |
| 2011-10-07 02:30:00 | ES | Futures | 1160.51 | 1162.01 | 1159.76 | 1161.76 | 2080.0 |
| 2011-10-07 02:35:00 | ES | Futures | 1161.51 | 1162.26 | 1161.51 | 1162.01 | 1309.0 |
| 2011-10-07 02:40:00 | ES | Futures | 1161.76 | 1162.26 | 1161.51 | 1162.01 | 752.0 |
| 2011-10-07 02:45:00 | ES | Futures | 1162.01 | 1163.27 | 1161.51 | 1163.27 | 1392.0 |
| 2011-10-07 02:50:00 | ES | Futures | 1163.02 | 1163.27 | 1161.76 | 1161.76 | 1801.0 |
| 2011-10-07 02:55:00 | ES | Futures | 1161.76 | 1162.01 | 1160.76 | 1160.76 | 1639.0 |
| 2011-10-07 03:00:00 | ES | Futures | 1160.76 | 1161.51 | 1159.76 | 1160.01 | 5374.0 |
| 2011-10-07 03:05:00 | ES | Futures | 1160.01 | 1161.26 | 1159.25 | 1160.51 | 4681.0 |
| 2011-10-07 03:10:00 | ES | Futures | 1160.51 | 1161.01 | 1159.25 | 1159.76 | 2712.0 |
| 2011-10-07 03:15:00 | ES | Futures | 1159.51 | 1160.76 | 1158.25 | 1159.76 | 3917.0 |
| 2011-10-07 03:20:00 | ES | Futures | 1160.01 | 1161.51 | 1159.51 | 1161.51 | 3394.0 |
| 2011-10-07 03:25:00 | ES | Futures | 1161.51 | 1162.26 | 1160.26 | 1160.51 | 4094.0 |
| 2011-10-07 03:30:00 | ES | Futures | 1160.76 | 1162.77 | 1160.76 | 1162.26 | 3840.0 |
| 2011-10-07 03:35:00 | ES | Futures | 1162.26 | 1162.51 | 1161.01 | 1162.26 | 2981.0 |
| 2011-10-07 03:40:00 | ES | Futures | 1162.26 | 1163.27 | 1162.01 | 1162.77 | 2257.0 |
| 2011-10-07 03:45:00 | ES | Futures | 1163.02 | 1163.02 | 1161.26 | 1162.26 | 2246.0 |
| 2011-10-07 03:50:00 | ES | Futures | 1162.26 | 1163.02 | 1162.01 | 1162.51 | 1004.0 |
| 2011-10-07 03:55:00 | ES | Futures | 1162.26 | 1162.77 | 1161.76 | 1162.51 | 2241.0 |
| 2011-10-07 04:00:00 | ES | Futures | 1162.51 | 1163.27 | 1161.76 | 1162.01 | 2140.0 |
| 2011-10-07 04:05:00 | ES | Futures | 1162.01 | 1162.26 | 1161.51 | 1162.01 | 1505.0 |
> showing 50 of 11,009 rows — these rows as CSV