PREVIEW / futures_5min / 2012-05-07
file: by_date/futures_5min/2012/2012-05-07.parquet size: 200 KB rows: 12,527
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-05-07 00:00:00 | ES | Futures | 1365.1 | 1365.36 | 1364.85 | 1365.1 | 446.0 |
| 2012-05-07 00:05:00 | ES | Futures | 1365.36 | 1365.61 | 1365.1 | 1365.61 | 313.0 |
| 2012-05-07 00:10:00 | ES | Futures | 1365.61 | 1365.61 | 1365.1 | 1365.36 | 368.0 |
| 2012-05-07 00:15:00 | ES | Futures | 1365.61 | 1365.61 | 1365.1 | 1365.36 | 343.0 |
| 2012-05-07 00:20:00 | ES | Futures | 1365.36 | 1365.61 | 1365.1 | 1365.36 | 246.0 |
| 2012-05-07 00:25:00 | ES | Futures | 1365.36 | 1365.36 | 1365.1 | 1365.36 | 177.0 |
| 2012-05-07 00:30:00 | ES | Futures | 1365.1 | 1365.36 | 1363.59 | 1364.09 | 1049.0 |
| 2012-05-07 00:35:00 | ES | Futures | 1364.09 | 1364.34 | 1363.84 | 1364.09 | 168.0 |
| 2012-05-07 00:40:00 | ES | Futures | 1364.09 | 1365.86 | 1364.09 | 1365.61 | 1196.0 |
| 2012-05-07 00:45:00 | ES | Futures | 1365.86 | 1365.86 | 1365.36 | 1365.36 | 109.0 |
| 2012-05-07 00:50:00 | ES | Futures | 1365.61 | 1365.61 | 1365.36 | 1365.61 | 93.0 |
| 2012-05-07 00:55:00 | ES | Futures | 1365.61 | 1365.61 | 1365.1 | 1365.1 | 234.0 |
| 2012-05-07 01:00:00 | ES | Futures | 1365.36 | 1365.36 | 1365.1 | 1365.36 | 169.0 |
| 2012-05-07 01:05:00 | ES | Futures | 1365.36 | 1365.86 | 1365.1 | 1365.61 | 512.0 |
| 2012-05-07 01:10:00 | ES | Futures | 1365.86 | 1365.86 | 1365.36 | 1365.61 | 242.0 |
| 2012-05-07 01:15:00 | ES | Futures | 1365.36 | 1365.61 | 1364.85 | 1365.1 | 585.0 |
| 2012-05-07 01:20:00 | ES | Futures | 1365.36 | 1365.36 | 1364.34 | 1364.85 | 497.0 |
| 2012-05-07 01:25:00 | ES | Futures | 1364.85 | 1364.85 | 1363.84 | 1364.09 | 477.0 |
| 2012-05-07 01:30:00 | ES | Futures | 1364.34 | 1364.34 | 1363.08 | 1363.59 | 821.0 |
| 2012-05-07 01:35:00 | ES | Futures | 1363.33 | 1364.85 | 1363.08 | 1364.6 | 606.0 |
| 2012-05-07 01:40:00 | ES | Futures | 1364.6 | 1364.6 | 1364.34 | 1364.34 | 296.0 |
| 2012-05-07 01:45:00 | ES | Futures | 1364.6 | 1364.85 | 1363.33 | 1363.33 | 669.0 |
| 2012-05-07 01:50:00 | ES | Futures | 1363.33 | 1364.34 | 1363.08 | 1364.34 | 1167.0 |
| 2012-05-07 01:55:00 | ES | Futures | 1364.09 | 1364.6 | 1363.84 | 1363.84 | 882.0 |
| 2012-05-07 02:00:00 | ES | Futures | 1363.84 | 1365.1 | 1363.59 | 1365.1 | 2494.0 |
| 2012-05-07 02:05:00 | ES | Futures | 1365.1 | 1365.36 | 1364.09 | 1364.34 | 1749.0 |
| 2012-05-07 02:10:00 | ES | Futures | 1364.34 | 1364.6 | 1364.09 | 1364.34 | 417.0 |
| 2012-05-07 02:15:00 | ES | Futures | 1364.34 | 1364.85 | 1363.84 | 1364.34 | 1871.0 |
| 2012-05-07 02:20:00 | ES | Futures | 1364.6 | 1365.1 | 1364.34 | 1365.1 | 1382.0 |
| 2012-05-07 02:25:00 | ES | Futures | 1365.1 | 1365.36 | 1364.85 | 1365.1 | 870.0 |
| 2012-05-07 02:30:00 | ES | Futures | 1365.1 | 1365.36 | 1364.6 | 1365.1 | 1038.0 |
| 2012-05-07 02:35:00 | ES | Futures | 1364.85 | 1365.86 | 1364.85 | 1365.61 | 1691.0 |
| 2012-05-07 02:40:00 | ES | Futures | 1365.86 | 1365.86 | 1365.1 | 1365.36 | 929.0 |
| 2012-05-07 02:45:00 | ES | Futures | 1365.36 | 1365.86 | 1365.1 | 1365.86 | 620.0 |
| 2012-05-07 02:50:00 | ES | Futures | 1365.86 | 1366.12 | 1365.61 | 1365.86 | 1173.0 |
| 2012-05-07 02:55:00 | ES | Futures | 1365.86 | 1366.37 | 1365.61 | 1365.86 | 1057.0 |
| 2012-05-07 03:00:00 | ES | Futures | 1366.12 | 1368.14 | 1365.1 | 1367.13 | 5297.0 |
| 2012-05-07 03:05:00 | ES | Futures | 1367.13 | 1367.38 | 1365.86 | 1365.86 | 3244.0 |
| 2012-05-07 03:10:00 | ES | Futures | 1366.12 | 1366.37 | 1365.36 | 1365.61 | 1483.0 |
| 2012-05-07 03:15:00 | ES | Futures | 1365.61 | 1366.87 | 1364.85 | 1366.87 | 5064.0 |
| 2012-05-07 03:20:00 | ES | Futures | 1366.87 | 1367.89 | 1366.62 | 1367.13 | 3624.0 |
| 2012-05-07 03:25:00 | ES | Futures | 1367.38 | 1367.63 | 1366.87 | 1366.87 | 1163.0 |
| 2012-05-07 03:30:00 | ES | Futures | 1367.13 | 1367.89 | 1366.87 | 1367.63 | 1086.0 |
| 2012-05-07 03:35:00 | ES | Futures | 1367.38 | 1368.14 | 1367.38 | 1367.63 | 912.0 |
| 2012-05-07 03:40:00 | ES | Futures | 1367.63 | 1368.65 | 1367.63 | 1367.89 | 3010.0 |
| 2012-05-07 03:45:00 | ES | Futures | 1367.89 | 1368.65 | 1367.89 | 1368.14 | 1380.0 |
| 2012-05-07 03:50:00 | ES | Futures | 1367.89 | 1368.65 | 1367.63 | 1367.89 | 1385.0 |
| 2012-05-07 03:55:00 | ES | Futures | 1367.89 | 1367.89 | 1367.13 | 1367.89 | 1499.0 |
| 2012-05-07 04:00:00 | ES | Futures | 1367.63 | 1367.89 | 1366.87 | 1367.38 | 1163.0 |
| 2012-05-07 04:05:00 | ES | Futures | 1367.63 | 1368.14 | 1367.13 | 1367.89 | 1033.0 |
> showing 50 of 12,527 rows — these rows as CSV