PREVIEW / futures_5min / 2016-05-29
file: by_date/futures_5min/2016/2016-05-29.parquet size: 42 KB rows: 2,202
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-29 18:00:00 | ES | Futures | 2267.83 | 2268.1 | 2266.48 | 2267.29 | 2443.0 |
| 2016-05-29 18:05:00 | ES | Futures | 2267.56 | 2267.56 | 2267.02 | 2267.29 | 454.0 |
| 2016-05-29 18:10:00 | ES | Futures | 2267.29 | 2268.37 | 2267.29 | 2268.1 | 389.0 |
| 2016-05-29 18:15:00 | ES | Futures | 2268.1 | 2269.45 | 2268.1 | 2268.1 | 761.0 |
| 2016-05-29 18:20:00 | ES | Futures | 2268.37 | 2268.64 | 2268.1 | 2268.37 | 140.0 |
| 2016-05-29 18:25:00 | ES | Futures | 2268.37 | 2268.37 | 2268.1 | 2268.1 | 26.0 |
| 2016-05-29 18:30:00 | ES | Futures | 2268.1 | 2268.91 | 2268.1 | 2268.64 | 140.0 |
| 2016-05-29 18:35:00 | ES | Futures | 2268.64 | 2268.91 | 2268.37 | 2268.37 | 195.0 |
| 2016-05-29 18:40:00 | ES | Futures | 2268.37 | 2268.91 | 2268.1 | 2268.37 | 218.0 |
| 2016-05-29 18:45:00 | ES | Futures | 2268.1 | 2268.64 | 2268.1 | 2268.37 | 39.0 |
| 2016-05-29 18:50:00 | ES | Futures | 2268.37 | 2268.64 | 2268.1 | 2268.64 | 98.0 |
| 2016-05-29 18:55:00 | ES | Futures | 2268.37 | 2268.64 | 2268.1 | 2268.37 | 85.0 |
| 2016-05-29 19:00:00 | ES | Futures | 2268.64 | 2268.64 | 2268.1 | 2268.37 | 237.0 |
| 2016-05-29 19:05:00 | ES | Futures | 2268.37 | 2268.64 | 2268.37 | 2268.64 | 67.0 |
| 2016-05-29 19:10:00 | ES | Futures | 2268.64 | 2268.64 | 2268.37 | 2268.37 | 75.0 |
| 2016-05-29 19:15:00 | ES | Futures | 2268.37 | 2268.64 | 2268.1 | 2268.1 | 90.0 |
| 2016-05-29 19:20:00 | ES | Futures | 2268.37 | 2268.64 | 2268.1 | 2268.37 | 49.0 |
| 2016-05-29 19:25:00 | ES | Futures | 2268.37 | 2268.91 | 2268.37 | 2268.37 | 326.0 |
| 2016-05-29 19:30:00 | ES | Futures | 2268.37 | 2268.64 | 2268.37 | 2268.64 | 15.0 |
| 2016-05-29 19:35:00 | ES | Futures | 2268.64 | 2268.64 | 2268.37 | 2268.64 | 62.0 |
| 2016-05-29 19:40:00 | ES | Futures | 2268.64 | 2269.45 | 2268.37 | 2269.45 | 706.0 |
| 2016-05-29 19:45:00 | ES | Futures | 2269.45 | 2271.07 | 2268.1 | 2270.26 | 3905.0 |
| 2016-05-29 19:50:00 | ES | Futures | 2270.26 | 2271.34 | 2269.72 | 2271.07 | 2151.0 |
| 2016-05-29 19:55:00 | ES | Futures | 2270.8 | 2271.07 | 2269.18 | 2269.18 | 568.0 |
| 2016-05-29 20:00:00 | ES | Futures | 2269.18 | 2270.26 | 2268.91 | 2269.45 | 982.0 |
| 2016-05-29 20:05:00 | ES | Futures | 2269.45 | 2269.99 | 2269.45 | 2269.72 | 364.0 |
| 2016-05-29 20:10:00 | ES | Futures | 2269.72 | 2269.99 | 2269.45 | 2269.99 | 278.0 |
| 2016-05-29 20:15:00 | ES | Futures | 2269.72 | 2269.99 | 2269.72 | 2269.72 | 205.0 |
| 2016-05-29 20:20:00 | ES | Futures | 2269.72 | 2269.99 | 2269.18 | 2269.45 | 596.0 |
| 2016-05-29 20:25:00 | ES | Futures | 2269.18 | 2269.45 | 2268.91 | 2269.18 | 371.0 |
| 2016-05-29 20:30:00 | ES | Futures | 2269.18 | 2269.45 | 2269.18 | 2269.18 | 399.0 |
| 2016-05-29 20:35:00 | ES | Futures | 2269.18 | 2269.45 | 2268.91 | 2269.18 | 341.0 |
| 2016-05-29 20:40:00 | ES | Futures | 2269.18 | 2269.18 | 2268.91 | 2269.18 | 94.0 |
| 2016-05-29 20:45:00 | ES | Futures | 2269.18 | 2269.18 | 2268.64 | 2268.91 | 255.0 |
| 2016-05-29 20:50:00 | ES | Futures | 2269.18 | 2269.18 | 2268.91 | 2269.18 | 96.0 |
| 2016-05-29 20:55:00 | ES | Futures | 2268.91 | 2269.18 | 2268.64 | 2268.91 | 169.0 |
| 2016-05-29 21:00:00 | ES | Futures | 2268.91 | 2269.18 | 2268.37 | 2268.64 | 400.0 |
| 2016-05-29 21:05:00 | ES | Futures | 2268.64 | 2268.91 | 2268.64 | 2268.64 | 174.0 |
| 2016-05-29 21:10:00 | ES | Futures | 2268.64 | 2268.91 | 2268.37 | 2268.91 | 95.0 |
| 2016-05-29 21:15:00 | ES | Futures | 2268.64 | 2268.64 | 2268.1 | 2268.37 | 846.0 |
| 2016-05-29 21:20:00 | ES | Futures | 2268.1 | 2268.37 | 2267.83 | 2268.1 | 344.0 |
| 2016-05-29 21:25:00 | ES | Futures | 2268.1 | 2268.1 | 2267.56 | 2267.83 | 530.0 |
| 2016-05-29 21:30:00 | ES | Futures | 2267.83 | 2269.72 | 2267.83 | 2269.45 | 923.0 |
| 2016-05-29 21:35:00 | ES | Futures | 2269.45 | 2269.99 | 2269.18 | 2269.72 | 728.0 |
| 2016-05-29 21:40:00 | ES | Futures | 2269.72 | 2270.53 | 2269.45 | 2270.26 | 876.0 |
| 2016-05-29 21:45:00 | ES | Futures | 2270.26 | 2270.53 | 2269.45 | 2269.45 | 357.0 |
| 2016-05-29 21:50:00 | ES | Futures | 2269.45 | 2269.45 | 2268.91 | 2268.91 | 108.0 |
| 2016-05-29 21:55:00 | ES | Futures | 2268.91 | 2269.72 | 2268.91 | 2268.91 | 283.0 |
| 2016-05-29 22:00:00 | ES | Futures | 2269.18 | 2269.45 | 2268.91 | 2269.18 | 52.0 |
| 2016-05-29 22:05:00 | ES | Futures | 2269.18 | 2269.72 | 2269.18 | 2269.45 | 91.0 |
> showing 50 of 2,202 rows — these rows as CSV