PREVIEW / futures_5min / 2011-08-02
file: by_date/futures_5min/2011/2011-08-02.parquet size: 250 KB rows: 13,392
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-08-02 00:00:00 | ES | Futures | 1273.46 | 1273.71 | 1273.22 | 1273.71 | 141.0 |
| 2011-08-02 00:05:00 | ES | Futures | 1273.71 | 1273.96 | 1273.46 | 1273.71 | 134.0 |
| 2011-08-02 00:10:00 | ES | Futures | 1273.71 | 1273.71 | 1273.46 | 1273.71 | 135.0 |
| 2011-08-02 00:15:00 | ES | Futures | 1273.71 | 1273.96 | 1273.22 | 1273.96 | 181.0 |
| 2011-08-02 00:20:00 | ES | Futures | 1273.71 | 1273.96 | 1273.22 | 1273.46 | 248.0 |
| 2011-08-02 00:25:00 | ES | Futures | 1273.46 | 1273.46 | 1272.72 | 1273.22 | 207.0 |
| 2011-08-02 00:30:00 | ES | Futures | 1273.22 | 1273.46 | 1272.72 | 1272.97 | 400.0 |
| 2011-08-02 00:35:00 | ES | Futures | 1272.97 | 1272.97 | 1272.47 | 1272.97 | 252.0 |
| 2011-08-02 00:40:00 | ES | Futures | 1272.72 | 1273.22 | 1272.47 | 1273.22 | 581.0 |
| 2011-08-02 00:45:00 | ES | Futures | 1273.22 | 1273.46 | 1272.47 | 1272.72 | 634.0 |
| 2011-08-02 00:50:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.72 | 351.0 |
| 2011-08-02 00:55:00 | ES | Futures | 1272.72 | 1272.97 | 1272.22 | 1272.47 | 441.0 |
| 2011-08-02 01:00:00 | ES | Futures | 1272.47 | 1272.97 | 1272.22 | 1272.72 | 456.0 |
| 2011-08-02 01:05:00 | ES | Futures | 1272.72 | 1272.72 | 1269.97 | 1271.22 | 2636.0 |
| 2011-08-02 01:10:00 | ES | Futures | 1271.22 | 1271.72 | 1270.97 | 1271.47 | 159.0 |
| 2011-08-02 01:15:00 | ES | Futures | 1271.47 | 1271.47 | 1270.72 | 1270.97 | 330.0 |
| 2011-08-02 01:20:00 | ES | Futures | 1270.72 | 1271.72 | 1270.72 | 1271.47 | 544.0 |
| 2011-08-02 01:25:00 | ES | Futures | 1271.47 | 1272.47 | 1271.22 | 1271.72 | 594.0 |
| 2011-08-02 01:30:00 | ES | Futures | 1271.47 | 1271.97 | 1271.22 | 1271.97 | 232.0 |
| 2011-08-02 01:35:00 | ES | Futures | 1271.97 | 1272.97 | 1271.97 | 1272.97 | 690.0 |
| 2011-08-02 01:40:00 | ES | Futures | 1272.72 | 1272.97 | 1272.47 | 1272.97 | 226.0 |
| 2011-08-02 01:45:00 | ES | Futures | 1272.97 | 1273.46 | 1272.97 | 1272.97 | 361.0 |
| 2011-08-02 01:50:00 | ES | Futures | 1273.22 | 1273.22 | 1272.47 | 1272.97 | 488.0 |
| 2011-08-02 01:55:00 | ES | Futures | 1272.97 | 1273.46 | 1272.72 | 1272.97 | 686.0 |
| 2011-08-02 02:00:00 | ES | Futures | 1272.97 | 1273.96 | 1272.97 | 1273.22 | 2167.0 |
| 2011-08-02 02:05:00 | ES | Futures | 1273.22 | 1273.22 | 1271.97 | 1272.72 | 800.0 |
| 2011-08-02 02:10:00 | ES | Futures | 1272.47 | 1272.72 | 1272.22 | 1272.72 | 687.0 |
| 2011-08-02 02:15:00 | ES | Futures | 1272.72 | 1272.72 | 1271.72 | 1272.22 | 1075.0 |
| 2011-08-02 02:20:00 | ES | Futures | 1272.47 | 1273.71 | 1271.97 | 1273.71 | 2773.0 |
| 2011-08-02 02:25:00 | ES | Futures | 1273.71 | 1274.46 | 1273.71 | 1273.96 | 1996.0 |
| 2011-08-02 02:30:00 | ES | Futures | 1273.96 | 1273.96 | 1272.97 | 1273.22 | 1086.0 |
| 2011-08-02 02:35:00 | ES | Futures | 1273.22 | 1273.71 | 1272.97 | 1273.22 | 2579.0 |
| 2011-08-02 02:40:00 | ES | Futures | 1273.22 | 1273.22 | 1272.22 | 1272.72 | 1971.0 |
| 2011-08-02 02:45:00 | ES | Futures | 1272.97 | 1272.97 | 1272.47 | 1272.97 | 1773.0 |
| 2011-08-02 02:50:00 | ES | Futures | 1272.97 | 1272.97 | 1271.47 | 1271.47 | 2645.0 |
| 2011-08-02 02:55:00 | ES | Futures | 1271.47 | 1271.72 | 1269.97 | 1270.22 | 4143.0 |
| 2011-08-02 03:00:00 | ES | Futures | 1270.22 | 1272.97 | 1270.22 | 1272.72 | 7169.0 |
| 2011-08-02 03:05:00 | ES | Futures | 1272.47 | 1273.71 | 1271.22 | 1272.97 | 9760.0 |
| 2011-08-02 03:10:00 | ES | Futures | 1273.22 | 1273.22 | 1270.22 | 1270.47 | 5929.0 |
| 2011-08-02 03:15:00 | ES | Futures | 1270.47 | 1271.47 | 1269.47 | 1269.72 | 5934.0 |
| 2011-08-02 03:20:00 | ES | Futures | 1269.72 | 1270.47 | 1268.98 | 1269.72 | 6540.0 |
| 2011-08-02 03:25:00 | ES | Futures | 1269.72 | 1269.97 | 1267.48 | 1269.22 | 10965.0 |
| 2011-08-02 03:30:00 | ES | Futures | 1269.22 | 1269.97 | 1268.73 | 1269.72 | 5178.0 |
| 2011-08-02 03:35:00 | ES | Futures | 1269.72 | 1270.47 | 1269.22 | 1269.47 | 3459.0 |
| 2011-08-02 03:40:00 | ES | Futures | 1269.47 | 1269.72 | 1268.48 | 1269.47 | 2796.0 |
| 2011-08-02 03:45:00 | ES | Futures | 1269.22 | 1270.22 | 1268.98 | 1270.22 | 4302.0 |
| 2011-08-02 03:50:00 | ES | Futures | 1269.97 | 1269.97 | 1268.73 | 1269.22 | 3843.0 |
| 2011-08-02 03:55:00 | ES | Futures | 1269.22 | 1270.72 | 1269.22 | 1269.72 | 3538.0 |
| 2011-08-02 04:00:00 | ES | Futures | 1269.72 | 1271.47 | 1269.47 | 1270.97 | 3699.0 |
| 2011-08-02 04:05:00 | ES | Futures | 1270.97 | 1272.47 | 1270.97 | 1271.97 | 4424.0 |
> showing 50 of 13,392 rows — these rows as CSV