PREVIEW / futures_5min / 2012-06-25
file: by_date/futures_5min/2012/2012-06-25.parquet size: 220 KB rows: 13,380
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-25 00:00:00 | ES | Futures | 1344.4 | 1344.65 | 1344.14 | 1344.4 | 313.0 |
| 2012-06-25 00:05:00 | ES | Futures | 1344.4 | 1344.4 | 1343.89 | 1344.4 | 293.0 |
| 2012-06-25 00:10:00 | ES | Futures | 1344.4 | 1344.4 | 1343.89 | 1343.89 | 155.0 |
| 2012-06-25 00:15:00 | ES | Futures | 1344.14 | 1344.4 | 1344.14 | 1344.4 | 86.0 |
| 2012-06-25 00:20:00 | ES | Futures | 1344.14 | 1344.4 | 1343.89 | 1344.4 | 77.0 |
| 2012-06-25 00:25:00 | ES | Futures | 1344.14 | 1344.14 | 1343.89 | 1344.14 | 49.0 |
| 2012-06-25 00:30:00 | ES | Futures | 1344.14 | 1344.14 | 1343.89 | 1344.14 | 152.0 |
| 2012-06-25 00:35:00 | ES | Futures | 1344.14 | 1344.4 | 1343.38 | 1343.63 | 477.0 |
| 2012-06-25 00:40:00 | ES | Futures | 1343.38 | 1343.89 | 1343.13 | 1343.89 | 642.0 |
| 2012-06-25 00:45:00 | ES | Futures | 1343.63 | 1344.14 | 1343.63 | 1343.89 | 157.0 |
| 2012-06-25 00:50:00 | ES | Futures | 1343.89 | 1344.14 | 1343.63 | 1343.89 | 160.0 |
| 2012-06-25 00:55:00 | ES | Futures | 1344.14 | 1344.14 | 1343.63 | 1343.89 | 256.0 |
| 2012-06-25 01:00:00 | ES | Futures | 1343.89 | 1344.14 | 1343.38 | 1343.89 | 354.0 |
| 2012-06-25 01:05:00 | ES | Futures | 1343.89 | 1343.89 | 1343.63 | 1343.89 | 93.0 |
| 2012-06-25 01:10:00 | ES | Futures | 1343.63 | 1343.89 | 1343.13 | 1343.63 | 441.0 |
| 2012-06-25 01:15:00 | ES | Futures | 1343.89 | 1343.89 | 1343.63 | 1343.89 | 161.0 |
| 2012-06-25 01:20:00 | ES | Futures | 1343.63 | 1343.63 | 1343.13 | 1343.38 | 377.0 |
| 2012-06-25 01:25:00 | ES | Futures | 1343.38 | 1343.63 | 1343.13 | 1343.63 | 121.0 |
| 2012-06-25 01:30:00 | ES | Futures | 1343.63 | 1343.63 | 1342.62 | 1342.87 | 749.0 |
| 2012-06-25 01:35:00 | ES | Futures | 1343.13 | 1343.13 | 1342.62 | 1342.62 | 189.0 |
| 2012-06-25 01:40:00 | ES | Futures | 1342.62 | 1343.89 | 1342.62 | 1343.89 | 621.0 |
| 2012-06-25 01:45:00 | ES | Futures | 1343.63 | 1344.91 | 1343.63 | 1344.91 | 1135.0 |
| 2012-06-25 01:50:00 | ES | Futures | 1344.91 | 1345.16 | 1344.4 | 1344.4 | 305.0 |
| 2012-06-25 01:55:00 | ES | Futures | 1344.4 | 1344.65 | 1343.89 | 1343.89 | 448.0 |
| 2012-06-25 02:00:00 | ES | Futures | 1344.14 | 1344.65 | 1343.13 | 1343.38 | 1305.0 |
| 2012-06-25 02:05:00 | ES | Futures | 1343.38 | 1344.4 | 1343.13 | 1344.14 | 582.0 |
| 2012-06-25 02:10:00 | ES | Futures | 1344.14 | 1344.65 | 1344.14 | 1344.65 | 412.0 |
| 2012-06-25 02:15:00 | ES | Futures | 1344.65 | 1344.91 | 1344.14 | 1344.4 | 517.0 |
| 2012-06-25 02:20:00 | ES | Futures | 1344.4 | 1344.91 | 1344.4 | 1344.91 | 533.0 |
| 2012-06-25 02:25:00 | ES | Futures | 1344.91 | 1344.91 | 1344.14 | 1344.4 | 391.0 |
| 2012-06-25 02:30:00 | ES | Futures | 1344.4 | 1344.65 | 1342.11 | 1342.87 | 1704.0 |
| 2012-06-25 02:35:00 | ES | Futures | 1342.62 | 1342.87 | 1342.11 | 1342.36 | 1136.0 |
| 2012-06-25 02:40:00 | ES | Futures | 1342.36 | 1343.63 | 1342.36 | 1343.13 | 1228.0 |
| 2012-06-25 02:45:00 | ES | Futures | 1342.87 | 1342.87 | 1342.11 | 1342.11 | 1398.0 |
| 2012-06-25 02:50:00 | ES | Futures | 1342.11 | 1343.63 | 1342.11 | 1342.62 | 1332.0 |
| 2012-06-25 02:55:00 | ES | Futures | 1342.62 | 1343.38 | 1342.11 | 1342.36 | 1382.0 |
| 2012-06-25 03:00:00 | ES | Futures | 1342.62 | 1343.13 | 1341.35 | 1342.36 | 3948.0 |
| 2012-06-25 03:05:00 | ES | Futures | 1342.11 | 1342.36 | 1341.09 | 1342.11 | 6918.0 |
| 2012-06-25 03:10:00 | ES | Futures | 1341.85 | 1342.62 | 1340.84 | 1341.35 | 6742.0 |
| 2012-06-25 03:15:00 | ES | Futures | 1341.35 | 1342.11 | 1340.58 | 1340.84 | 4253.0 |
| 2012-06-25 03:20:00 | ES | Futures | 1341.09 | 1341.09 | 1339.82 | 1340.58 | 8956.0 |
| 2012-06-25 03:25:00 | ES | Futures | 1340.33 | 1340.58 | 1339.82 | 1339.82 | 4909.0 |
| 2012-06-25 03:30:00 | ES | Futures | 1340.07 | 1340.84 | 1339.57 | 1340.58 | 7088.0 |
| 2012-06-25 03:35:00 | ES | Futures | 1340.58 | 1341.6 | 1340.58 | 1341.09 | 4999.0 |
| 2012-06-25 03:40:00 | ES | Futures | 1341.09 | 1341.35 | 1340.58 | 1340.84 | 2375.0 |
| 2012-06-25 03:45:00 | ES | Futures | 1340.84 | 1340.84 | 1339.82 | 1340.33 | 3794.0 |
| 2012-06-25 03:50:00 | ES | Futures | 1340.33 | 1340.33 | 1339.82 | 1339.82 | 2368.0 |
| 2012-06-25 03:55:00 | ES | Futures | 1339.82 | 1340.07 | 1339.31 | 1339.57 | 5711.0 |
| 2012-06-25 04:00:00 | ES | Futures | 1339.57 | 1340.58 | 1339.31 | 1340.58 | 2170.0 |
| 2012-06-25 04:05:00 | ES | Futures | 1340.58 | 1340.58 | 1339.82 | 1340.33 | 2166.0 |
> showing 50 of 13,380 rows — these rows as CSV