PREVIEW / futures_5min / 2012-06-28
file: by_date/futures_5min/2012/2012-06-28.parquet size: 241 KB rows: 13,917
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-28 00:00:00 | ES | Futures | 1349.23 | 1349.48 | 1348.72 | 1348.72 | 125.0 |
| 2012-06-28 00:05:00 | ES | Futures | 1348.72 | 1348.97 | 1348.47 | 1348.72 | 190.0 |
| 2012-06-28 00:10:00 | ES | Futures | 1348.72 | 1348.72 | 1348.47 | 1348.72 | 116.0 |
| 2012-06-28 00:15:00 | ES | Futures | 1348.47 | 1348.97 | 1348.47 | 1348.97 | 97.0 |
| 2012-06-28 00:20:00 | ES | Futures | 1348.72 | 1348.97 | 1348.47 | 1348.47 | 215.0 |
| 2012-06-28 00:25:00 | ES | Futures | 1348.47 | 1348.72 | 1348.21 | 1348.72 | 320.0 |
| 2012-06-28 00:30:00 | ES | Futures | 1348.97 | 1349.48 | 1348.97 | 1348.97 | 248.0 |
| 2012-06-28 00:35:00 | ES | Futures | 1348.97 | 1349.48 | 1348.97 | 1349.48 | 124.0 |
| 2012-06-28 00:40:00 | ES | Futures | 1349.48 | 1349.48 | 1348.97 | 1349.23 | 164.0 |
| 2012-06-28 00:45:00 | ES | Futures | 1349.23 | 1349.48 | 1348.72 | 1348.72 | 213.0 |
| 2012-06-28 00:50:00 | ES | Futures | 1348.97 | 1349.23 | 1348.72 | 1349.23 | 164.0 |
| 2012-06-28 00:55:00 | ES | Futures | 1349.23 | 1349.23 | 1349.23 | 1349.23 | 49.0 |
| 2012-06-28 01:00:00 | ES | Futures | 1349.23 | 1349.48 | 1348.97 | 1348.97 | 219.0 |
| 2012-06-28 01:05:00 | ES | Futures | 1348.97 | 1349.48 | 1348.97 | 1349.23 | 165.0 |
| 2012-06-28 01:10:00 | ES | Futures | 1349.23 | 1349.48 | 1348.97 | 1348.97 | 211.0 |
| 2012-06-28 01:15:00 | ES | Futures | 1348.97 | 1349.23 | 1348.97 | 1349.23 | 225.0 |
| 2012-06-28 01:20:00 | ES | Futures | 1349.23 | 1349.23 | 1348.97 | 1349.23 | 247.0 |
| 2012-06-28 01:25:00 | ES | Futures | 1349.48 | 1349.48 | 1348.97 | 1349.23 | 124.0 |
| 2012-06-28 01:30:00 | ES | Futures | 1349.23 | 1349.48 | 1348.97 | 1348.97 | 393.0 |
| 2012-06-28 01:35:00 | ES | Futures | 1348.97 | 1349.23 | 1348.97 | 1348.97 | 359.0 |
| 2012-06-28 01:40:00 | ES | Futures | 1348.97 | 1349.48 | 1348.97 | 1349.48 | 322.0 |
| 2012-06-28 01:45:00 | ES | Futures | 1349.48 | 1349.74 | 1348.97 | 1349.23 | 227.0 |
| 2012-06-28 01:50:00 | ES | Futures | 1349.23 | 1349.23 | 1348.47 | 1348.72 | 371.0 |
| 2012-06-28 01:55:00 | ES | Futures | 1348.72 | 1349.74 | 1348.47 | 1349.48 | 364.0 |
| 2012-06-28 02:00:00 | ES | Futures | 1349.48 | 1349.48 | 1348.97 | 1349.23 | 983.0 |
| 2012-06-28 02:05:00 | ES | Futures | 1349.23 | 1349.23 | 1348.72 | 1348.72 | 521.0 |
| 2012-06-28 02:10:00 | ES | Futures | 1348.72 | 1349.23 | 1348.47 | 1348.97 | 414.0 |
| 2012-06-28 02:15:00 | ES | Futures | 1348.97 | 1349.74 | 1348.97 | 1349.48 | 605.0 |
| 2012-06-28 02:20:00 | ES | Futures | 1349.23 | 1349.74 | 1348.97 | 1348.97 | 425.0 |
| 2012-06-28 02:25:00 | ES | Futures | 1349.23 | 1350.25 | 1349.23 | 1350.25 | 1234.0 |
| 2012-06-28 02:30:00 | ES | Futures | 1350.25 | 1350.25 | 1349.74 | 1349.99 | 817.0 |
| 2012-06-28 02:35:00 | ES | Futures | 1349.99 | 1349.99 | 1349.48 | 1349.74 | 429.0 |
| 2012-06-28 02:40:00 | ES | Futures | 1349.99 | 1350.25 | 1349.74 | 1349.99 | 813.0 |
| 2012-06-28 02:45:00 | ES | Futures | 1349.99 | 1349.99 | 1348.97 | 1349.23 | 440.0 |
| 2012-06-28 02:50:00 | ES | Futures | 1348.97 | 1349.23 | 1348.72 | 1348.97 | 689.0 |
| 2012-06-28 02:55:00 | ES | Futures | 1348.97 | 1348.97 | 1348.72 | 1348.97 | 179.0 |
| 2012-06-28 03:00:00 | ES | Futures | 1348.97 | 1349.74 | 1348.72 | 1349.48 | 1485.0 |
| 2012-06-28 03:05:00 | ES | Futures | 1349.48 | 1349.48 | 1347.96 | 1348.47 | 3194.0 |
| 2012-06-28 03:10:00 | ES | Futures | 1348.47 | 1348.47 | 1347.19 | 1347.7 | 5403.0 |
| 2012-06-28 03:15:00 | ES | Futures | 1347.96 | 1347.96 | 1347.19 | 1347.45 | 2458.0 |
| 2012-06-28 03:20:00 | ES | Futures | 1347.45 | 1347.7 | 1346.43 | 1347.19 | 3030.0 |
| 2012-06-28 03:25:00 | ES | Futures | 1347.19 | 1347.96 | 1346.69 | 1346.94 | 2562.0 |
| 2012-06-28 03:30:00 | ES | Futures | 1347.19 | 1347.7 | 1346.43 | 1346.43 | 3139.0 |
| 2012-06-28 03:35:00 | ES | Futures | 1346.69 | 1347.19 | 1345.41 | 1345.41 | 3866.0 |
| 2012-06-28 03:40:00 | ES | Futures | 1345.67 | 1346.18 | 1345.16 | 1345.41 | 2416.0 |
| 2012-06-28 03:45:00 | ES | Futures | 1345.67 | 1345.67 | 1343.89 | 1344.14 | 6553.0 |
| 2012-06-28 03:50:00 | ES | Futures | 1344.4 | 1344.4 | 1343.13 | 1343.38 | 9076.0 |
| 2012-06-28 03:55:00 | ES | Futures | 1343.38 | 1343.38 | 1341.85 | 1343.13 | 9042.0 |
| 2012-06-28 04:00:00 | ES | Futures | 1342.87 | 1343.13 | 1340.84 | 1341.85 | 6417.0 |
| 2012-06-28 04:05:00 | ES | Futures | 1341.85 | 1342.11 | 1341.09 | 1341.85 | 5524.0 |
> showing 50 of 13,917 rows — these rows as CSV