PREVIEW / futures_5min / 2009-11-20
file: by_date/futures_5min/2009/2009-11-20.parquet size: 166 KB rows: 9,422
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-20 00:00:00 | ES | Futures | 1060.45 | 1060.69 | 1060.45 | 1060.45 | 136.0 |
| 2009-11-20 00:05:00 | ES | Futures | 1060.45 | 1060.69 | 1060.45 | 1060.45 | 50.0 |
| 2009-11-20 00:10:00 | ES | Futures | 1060.69 | 1060.93 | 1060.2 | 1060.2 | 265.0 |
| 2009-11-20 00:15:00 | ES | Futures | 1060.2 | 1060.45 | 1059.96 | 1059.96 | 216.0 |
| 2009-11-20 00:20:00 | ES | Futures | 1059.96 | 1060.2 | 1059.72 | 1060.2 | 378.0 |
| 2009-11-20 00:25:00 | ES | Futures | 1060.2 | 1060.93 | 1060.2 | 1060.93 | 366.0 |
| 2009-11-20 00:30:00 | ES | Futures | 1060.69 | 1060.93 | 1060.45 | 1060.93 | 261.0 |
| 2009-11-20 00:35:00 | ES | Futures | 1060.93 | 1060.93 | 1059.96 | 1059.96 | 359.0 |
| 2009-11-20 00:40:00 | ES | Futures | 1059.96 | 1060.45 | 1059.96 | 1060.2 | 115.0 |
| 2009-11-20 00:45:00 | ES | Futures | 1060.45 | 1060.45 | 1059.72 | 1059.72 | 335.0 |
| 2009-11-20 00:50:00 | ES | Futures | 1059.72 | 1059.96 | 1059.72 | 1059.72 | 187.0 |
| 2009-11-20 00:55:00 | ES | Futures | 1059.96 | 1059.96 | 1059.72 | 1059.96 | 225.0 |
| 2009-11-20 01:00:00 | ES | Futures | 1059.96 | 1060.2 | 1059.72 | 1059.72 | 251.0 |
| 2009-11-20 01:05:00 | ES | Futures | 1059.96 | 1059.96 | 1059.48 | 1059.48 | 68.0 |
| 2009-11-20 01:10:00 | ES | Futures | 1059.48 | 1059.96 | 1059.48 | 1059.96 | 67.0 |
| 2009-11-20 01:15:00 | ES | Futures | 1059.96 | 1059.96 | 1059.48 | 1059.72 | 127.0 |
| 2009-11-20 01:20:00 | ES | Futures | 1059.72 | 1059.96 | 1059.72 | 1059.96 | 22.0 |
| 2009-11-20 01:25:00 | ES | Futures | 1059.72 | 1059.96 | 1059.72 | 1059.96 | 58.0 |
| 2009-11-20 01:30:00 | ES | Futures | 1059.96 | 1059.96 | 1059.72 | 1059.96 | 278.0 |
| 2009-11-20 01:35:00 | ES | Futures | 1059.96 | 1059.96 | 1059.72 | 1059.72 | 74.0 |
| 2009-11-20 01:40:00 | ES | Futures | 1059.72 | 1059.72 | 1059.24 | 1059.48 | 299.0 |
| 2009-11-20 01:45:00 | ES | Futures | 1059.24 | 1059.72 | 1058.99 | 1059.48 | 316.0 |
| 2009-11-20 01:50:00 | ES | Futures | 1059.48 | 1059.48 | 1058.75 | 1058.99 | 427.0 |
| 2009-11-20 01:55:00 | ES | Futures | 1058.99 | 1059.72 | 1058.75 | 1059.48 | 188.0 |
| 2009-11-20 02:00:00 | ES | Futures | 1059.48 | 1059.48 | 1058.99 | 1059.24 | 876.0 |
| 2009-11-20 02:05:00 | ES | Futures | 1059.48 | 1059.48 | 1058.51 | 1058.51 | 549.0 |
| 2009-11-20 02:10:00 | ES | Futures | 1058.75 | 1059.72 | 1058.75 | 1059.48 | 807.0 |
| 2009-11-20 02:15:00 | ES | Futures | 1059.48 | 1059.48 | 1058.75 | 1058.99 | 649.0 |
| 2009-11-20 02:20:00 | ES | Futures | 1059.24 | 1059.24 | 1058.27 | 1058.51 | 564.0 |
| 2009-11-20 02:25:00 | ES | Futures | 1058.27 | 1058.75 | 1058.27 | 1058.51 | 495.0 |
| 2009-11-20 02:30:00 | ES | Futures | 1058.51 | 1058.51 | 1057.78 | 1058.02 | 640.0 |
| 2009-11-20 02:35:00 | ES | Futures | 1058.02 | 1058.02 | 1057.54 | 1057.78 | 353.0 |
| 2009-11-20 02:40:00 | ES | Futures | 1057.54 | 1058.51 | 1057.54 | 1058.27 | 302.0 |
| 2009-11-20 02:45:00 | ES | Futures | 1058.27 | 1058.51 | 1058.02 | 1058.51 | 516.0 |
| 2009-11-20 02:50:00 | ES | Futures | 1058.27 | 1059.24 | 1058.27 | 1059.24 | 702.0 |
| 2009-11-20 02:55:00 | ES | Futures | 1059.48 | 1059.72 | 1058.99 | 1059.24 | 849.0 |
| 2009-11-20 03:00:00 | ES | Futures | 1059.24 | 1059.48 | 1058.27 | 1058.75 | 2130.0 |
| 2009-11-20 03:05:00 | ES | Futures | 1058.75 | 1058.75 | 1058.02 | 1058.75 | 1698.0 |
| 2009-11-20 03:10:00 | ES | Futures | 1058.75 | 1059.72 | 1058.51 | 1059.72 | 1565.0 |
| 2009-11-20 03:15:00 | ES | Futures | 1059.48 | 1060.45 | 1059.48 | 1059.96 | 2126.0 |
| 2009-11-20 03:20:00 | ES | Futures | 1059.96 | 1060.45 | 1059.96 | 1059.96 | 3040.0 |
| 2009-11-20 03:25:00 | ES | Futures | 1059.96 | 1060.69 | 1059.96 | 1060.69 | 1497.0 |
| 2009-11-20 03:30:00 | ES | Futures | 1060.45 | 1060.45 | 1060.2 | 1060.2 | 868.0 |
| 2009-11-20 03:35:00 | ES | Futures | 1060.45 | 1060.45 | 1059.96 | 1060.2 | 661.0 |
| 2009-11-20 03:40:00 | ES | Futures | 1060.45 | 1060.45 | 1059.72 | 1059.72 | 1450.0 |
| 2009-11-20 03:45:00 | ES | Futures | 1059.72 | 1059.96 | 1059.48 | 1059.72 | 1149.0 |
| 2009-11-20 03:50:00 | ES | Futures | 1059.48 | 1060.2 | 1059.48 | 1059.96 | 1225.0 |
| 2009-11-20 03:55:00 | ES | Futures | 1059.96 | 1060.45 | 1059.72 | 1059.96 | 1486.0 |
| 2009-11-20 04:00:00 | ES | Futures | 1059.96 | 1060.2 | 1059.48 | 1059.72 | 1280.0 |
| 2009-11-20 04:05:00 | ES | Futures | 1059.72 | 1059.96 | 1059.48 | 1059.96 | 1022.0 |
> showing 50 of 9,422 rows — these rows as CSV