PREVIEW / futures_5min / 2011-11-02
file: by_date/futures_5min/2011/2011-11-02.parquet size: 245 KB rows: 13,662
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-11-02 00:00:00 | ES | Futures | 1229.97 | 1230.22 | 1229.72 | 1229.97 | 232.0 |
| 2011-11-02 00:05:00 | ES | Futures | 1229.97 | 1230.47 | 1229.47 | 1229.72 | 286.0 |
| 2011-11-02 00:10:00 | ES | Futures | 1229.72 | 1230.22 | 1229.47 | 1230.22 | 148.0 |
| 2011-11-02 00:15:00 | ES | Futures | 1230.22 | 1230.47 | 1229.97 | 1230.47 | 133.0 |
| 2011-11-02 00:20:00 | ES | Futures | 1230.47 | 1230.97 | 1230.47 | 1230.72 | 508.0 |
| 2011-11-02 00:25:00 | ES | Futures | 1230.97 | 1231.72 | 1230.72 | 1231.47 | 883.0 |
| 2011-11-02 00:30:00 | ES | Futures | 1231.72 | 1232.23 | 1231.47 | 1231.97 | 633.0 |
| 2011-11-02 00:35:00 | ES | Futures | 1231.97 | 1232.23 | 1231.47 | 1231.72 | 189.0 |
| 2011-11-02 00:40:00 | ES | Futures | 1231.97 | 1231.97 | 1230.97 | 1231.22 | 288.0 |
| 2011-11-02 00:45:00 | ES | Futures | 1231.22 | 1231.72 | 1230.72 | 1231.22 | 339.0 |
| 2011-11-02 00:50:00 | ES | Futures | 1231.22 | 1231.47 | 1230.97 | 1231.22 | 269.0 |
| 2011-11-02 00:55:00 | ES | Futures | 1231.22 | 1231.22 | 1230.47 | 1230.72 | 248.0 |
| 2011-11-02 01:00:00 | ES | Futures | 1230.72 | 1230.97 | 1229.97 | 1229.97 | 441.0 |
| 2011-11-02 01:05:00 | ES | Futures | 1230.22 | 1230.97 | 1229.97 | 1230.22 | 319.0 |
| 2011-11-02 01:10:00 | ES | Futures | 1230.22 | 1230.97 | 1229.72 | 1230.47 | 680.0 |
| 2011-11-02 01:15:00 | ES | Futures | 1230.47 | 1231.47 | 1230.22 | 1230.72 | 259.0 |
| 2011-11-02 01:20:00 | ES | Futures | 1230.72 | 1231.97 | 1230.72 | 1231.47 | 467.0 |
| 2011-11-02 01:25:00 | ES | Futures | 1231.47 | 1231.97 | 1230.97 | 1231.22 | 745.0 |
| 2011-11-02 01:30:00 | ES | Futures | 1231.22 | 1232.23 | 1230.72 | 1232.23 | 391.0 |
| 2011-11-02 01:35:00 | ES | Futures | 1231.97 | 1232.48 | 1231.47 | 1232.48 | 360.0 |
| 2011-11-02 01:40:00 | ES | Futures | 1232.23 | 1232.23 | 1231.47 | 1231.47 | 310.0 |
| 2011-11-02 01:45:00 | ES | Futures | 1231.47 | 1232.23 | 1231.22 | 1232.23 | 201.0 |
| 2011-11-02 01:50:00 | ES | Futures | 1232.23 | 1232.48 | 1231.72 | 1231.72 | 548.0 |
| 2011-11-02 01:55:00 | ES | Futures | 1231.97 | 1233.23 | 1231.72 | 1232.98 | 1177.0 |
| 2011-11-02 02:00:00 | ES | Futures | 1232.98 | 1234.98 | 1232.48 | 1234.48 | 3450.0 |
| 2011-11-02 02:05:00 | ES | Futures | 1234.23 | 1234.98 | 1233.73 | 1234.98 | 987.0 |
| 2011-11-02 02:10:00 | ES | Futures | 1234.98 | 1237.74 | 1234.73 | 1237.24 | 4105.0 |
| 2011-11-02 02:15:00 | ES | Futures | 1236.99 | 1237.74 | 1236.99 | 1237.24 | 606.0 |
| 2011-11-02 02:20:00 | ES | Futures | 1237.24 | 1237.74 | 1236.49 | 1237.24 | 1142.0 |
| 2011-11-02 02:25:00 | ES | Futures | 1236.99 | 1239.0 | 1236.99 | 1237.99 | 1291.0 |
| 2011-11-02 02:30:00 | ES | Futures | 1238.24 | 1238.24 | 1237.49 | 1237.99 | 551.0 |
| 2011-11-02 02:35:00 | ES | Futures | 1237.74 | 1237.99 | 1236.74 | 1236.99 | 1129.0 |
| 2011-11-02 02:40:00 | ES | Futures | 1236.99 | 1239.25 | 1236.49 | 1239.25 | 1733.0 |
| 2011-11-02 02:45:00 | ES | Futures | 1239.0 | 1239.0 | 1237.99 | 1238.49 | 695.0 |
| 2011-11-02 02:50:00 | ES | Futures | 1238.49 | 1238.74 | 1236.74 | 1236.99 | 1659.0 |
| 2011-11-02 02:55:00 | ES | Futures | 1236.99 | 1239.0 | 1236.99 | 1238.24 | 967.0 |
| 2011-11-02 03:00:00 | ES | Futures | 1238.24 | 1238.49 | 1236.49 | 1238.24 | 2156.0 |
| 2011-11-02 03:05:00 | ES | Futures | 1238.24 | 1240.5 | 1237.99 | 1239.5 | 3347.0 |
| 2011-11-02 03:10:00 | ES | Futures | 1239.5 | 1239.5 | 1238.24 | 1239.25 | 954.0 |
| 2011-11-02 03:15:00 | ES | Futures | 1239.5 | 1240.0 | 1238.24 | 1238.24 | 1778.0 |
| 2011-11-02 03:20:00 | ES | Futures | 1237.99 | 1238.49 | 1237.49 | 1237.49 | 1433.0 |
| 2011-11-02 03:25:00 | ES | Futures | 1237.49 | 1237.74 | 1236.49 | 1236.74 | 1112.0 |
| 2011-11-02 03:30:00 | ES | Futures | 1236.49 | 1236.74 | 1234.23 | 1235.23 | 3001.0 |
| 2011-11-02 03:35:00 | ES | Futures | 1235.23 | 1237.24 | 1234.98 | 1236.99 | 1395.0 |
| 2011-11-02 03:40:00 | ES | Futures | 1236.99 | 1238.49 | 1236.24 | 1237.74 | 1760.0 |
| 2011-11-02 03:45:00 | ES | Futures | 1237.74 | 1238.24 | 1237.49 | 1237.74 | 1375.0 |
| 2011-11-02 03:50:00 | ES | Futures | 1237.74 | 1238.49 | 1237.24 | 1237.49 | 1544.0 |
| 2011-11-02 03:55:00 | ES | Futures | 1237.49 | 1237.99 | 1237.24 | 1237.49 | 1008.0 |
| 2011-11-02 04:00:00 | ES | Futures | 1237.49 | 1237.74 | 1234.48 | 1236.49 | 5940.0 |
| 2011-11-02 04:05:00 | ES | Futures | 1236.74 | 1239.25 | 1236.24 | 1239.25 | 5724.0 |
> showing 50 of 13,662 rows — these rows as CSV