PREVIEW / futures_5min / 2012-07-25
file: by_date/futures_5min/2012/2012-07-25.parquet size: 231 KB rows: 13,828
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-07-25 00:00:00 | ES | Futures | 1349.48 | 1350.25 | 1349.48 | 1349.99 | 457.0 |
| 2012-07-25 00:05:00 | ES | Futures | 1350.25 | 1350.5 | 1349.99 | 1350.25 | 578.0 |
| 2012-07-25 00:10:00 | ES | Futures | 1350.25 | 1350.5 | 1349.99 | 1349.99 | 176.0 |
| 2012-07-25 00:15:00 | ES | Futures | 1349.99 | 1350.25 | 1349.74 | 1349.99 | 251.0 |
| 2012-07-25 00:20:00 | ES | Futures | 1350.25 | 1350.25 | 1349.74 | 1349.99 | 369.0 |
| 2012-07-25 00:25:00 | ES | Futures | 1350.25 | 1350.5 | 1349.99 | 1350.25 | 254.0 |
| 2012-07-25 00:30:00 | ES | Futures | 1350.25 | 1350.25 | 1349.99 | 1349.99 | 329.0 |
| 2012-07-25 00:35:00 | ES | Futures | 1350.25 | 1350.25 | 1349.74 | 1350.25 | 397.0 |
| 2012-07-25 00:40:00 | ES | Futures | 1349.99 | 1350.5 | 1349.99 | 1350.25 | 461.0 |
| 2012-07-25 00:45:00 | ES | Futures | 1350.25 | 1350.25 | 1349.99 | 1350.25 | 218.0 |
| 2012-07-25 00:50:00 | ES | Futures | 1349.99 | 1350.5 | 1349.99 | 1349.99 | 216.0 |
| 2012-07-25 00:55:00 | ES | Futures | 1350.25 | 1350.25 | 1349.99 | 1350.25 | 163.0 |
| 2012-07-25 01:00:00 | ES | Futures | 1349.99 | 1350.5 | 1349.74 | 1349.74 | 510.0 |
| 2012-07-25 01:05:00 | ES | Futures | 1349.74 | 1349.99 | 1348.97 | 1349.23 | 988.0 |
| 2012-07-25 01:10:00 | ES | Futures | 1349.48 | 1349.74 | 1348.97 | 1349.23 | 360.0 |
| 2012-07-25 01:15:00 | ES | Futures | 1349.23 | 1349.23 | 1348.21 | 1348.47 | 1331.0 |
| 2012-07-25 01:20:00 | ES | Futures | 1348.47 | 1349.48 | 1348.47 | 1349.48 | 658.0 |
| 2012-07-25 01:25:00 | ES | Futures | 1349.48 | 1349.74 | 1348.97 | 1348.97 | 374.0 |
| 2012-07-25 01:30:00 | ES | Futures | 1349.23 | 1349.23 | 1348.21 | 1348.47 | 537.0 |
| 2012-07-25 01:35:00 | ES | Futures | 1348.47 | 1348.72 | 1347.96 | 1348.21 | 703.0 |
| 2012-07-25 01:40:00 | ES | Futures | 1348.21 | 1348.47 | 1347.96 | 1348.21 | 657.0 |
| 2012-07-25 01:45:00 | ES | Futures | 1348.21 | 1348.21 | 1347.7 | 1347.7 | 577.0 |
| 2012-07-25 01:50:00 | ES | Futures | 1347.7 | 1347.7 | 1347.45 | 1347.7 | 457.0 |
| 2012-07-25 01:55:00 | ES | Futures | 1347.96 | 1348.72 | 1347.96 | 1348.21 | 878.0 |
| 2012-07-25 02:00:00 | ES | Futures | 1348.21 | 1349.74 | 1348.21 | 1349.74 | 1677.0 |
| 2012-07-25 02:05:00 | ES | Futures | 1349.74 | 1349.74 | 1348.97 | 1349.23 | 532.0 |
| 2012-07-25 02:10:00 | ES | Futures | 1349.48 | 1349.99 | 1349.23 | 1349.48 | 499.0 |
| 2012-07-25 02:15:00 | ES | Futures | 1349.74 | 1349.99 | 1349.23 | 1349.48 | 464.0 |
| 2012-07-25 02:20:00 | ES | Futures | 1349.48 | 1349.48 | 1348.72 | 1349.23 | 1039.0 |
| 2012-07-25 02:25:00 | ES | Futures | 1349.48 | 1349.48 | 1349.23 | 1349.23 | 439.0 |
| 2012-07-25 02:30:00 | ES | Futures | 1349.48 | 1349.48 | 1348.47 | 1348.72 | 463.0 |
| 2012-07-25 02:35:00 | ES | Futures | 1348.47 | 1349.48 | 1348.47 | 1349.23 | 597.0 |
| 2012-07-25 02:40:00 | ES | Futures | 1349.48 | 1350.25 | 1348.97 | 1349.23 | 917.0 |
| 2012-07-25 02:45:00 | ES | Futures | 1349.23 | 1349.23 | 1348.47 | 1348.97 | 679.0 |
| 2012-07-25 02:50:00 | ES | Futures | 1348.72 | 1348.97 | 1347.96 | 1347.96 | 1181.0 |
| 2012-07-25 02:55:00 | ES | Futures | 1347.96 | 1348.21 | 1347.7 | 1348.21 | 647.0 |
| 2012-07-25 03:00:00 | ES | Futures | 1348.21 | 1351.77 | 1347.96 | 1351.52 | 11292.0 |
| 2012-07-25 03:05:00 | ES | Futures | 1351.26 | 1351.52 | 1349.48 | 1349.99 | 6721.0 |
| 2012-07-25 03:10:00 | ES | Futures | 1349.99 | 1352.28 | 1349.74 | 1352.03 | 7778.0 |
| 2012-07-25 03:15:00 | ES | Futures | 1352.03 | 1354.31 | 1351.77 | 1354.06 | 8381.0 |
| 2012-07-25 03:20:00 | ES | Futures | 1353.81 | 1354.57 | 1352.03 | 1352.03 | 7740.0 |
| 2012-07-25 03:25:00 | ES | Futures | 1352.03 | 1352.53 | 1351.01 | 1351.52 | 6018.0 |
| 2012-07-25 03:30:00 | ES | Futures | 1351.52 | 1352.53 | 1351.26 | 1352.03 | 3560.0 |
| 2012-07-25 03:35:00 | ES | Futures | 1351.77 | 1352.53 | 1351.26 | 1351.77 | 3705.0 |
| 2012-07-25 03:40:00 | ES | Futures | 1351.77 | 1352.28 | 1351.52 | 1351.52 | 2352.0 |
| 2012-07-25 03:45:00 | ES | Futures | 1351.77 | 1352.28 | 1351.52 | 1352.28 | 2041.0 |
| 2012-07-25 03:50:00 | ES | Futures | 1352.28 | 1352.79 | 1351.26 | 1351.26 | 2473.0 |
| 2012-07-25 03:55:00 | ES | Futures | 1351.26 | 1352.03 | 1350.25 | 1351.52 | 4269.0 |
| 2012-07-25 04:00:00 | ES | Futures | 1351.52 | 1352.79 | 1350.5 | 1352.53 | 4807.0 |
| 2012-07-25 04:05:00 | ES | Futures | 1352.53 | 1353.04 | 1351.77 | 1351.77 | 2769.0 |
> showing 50 of 13,828 rows — these rows as CSV