PREVIEW / futures_5min / 2015-05-31
file: by_date/futures_5min/2015/2015-05-31.parquet size: 41 KB rows: 2,273
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-31 18:00:00 | ES | Futures | 2225.98 | 2226.25 | 2224.4 | 2224.93 | 2037.0 |
| 2015-05-31 18:05:00 | ES | Futures | 2224.66 | 2224.93 | 2224.66 | 2224.93 | 153.0 |
| 2015-05-31 18:10:00 | ES | Futures | 2224.93 | 2224.93 | 2224.66 | 2224.66 | 107.0 |
| 2015-05-31 18:15:00 | ES | Futures | 2224.66 | 2224.93 | 2224.66 | 2224.93 | 184.0 |
| 2015-05-31 18:20:00 | ES | Futures | 2224.93 | 2225.72 | 2224.66 | 2225.72 | 285.0 |
| 2015-05-31 18:25:00 | ES | Futures | 2225.72 | 2227.83 | 2225.72 | 2227.57 | 766.0 |
| 2015-05-31 18:30:00 | ES | Futures | 2227.83 | 2229.42 | 2226.25 | 2226.78 | 1777.0 |
| 2015-05-31 18:35:00 | ES | Futures | 2227.04 | 2227.04 | 2226.51 | 2226.78 | 421.0 |
| 2015-05-31 18:40:00 | ES | Futures | 2226.51 | 2227.04 | 2225.98 | 2226.25 | 417.0 |
| 2015-05-31 18:45:00 | ES | Futures | 2226.25 | 2226.78 | 2225.98 | 2225.98 | 345.0 |
| 2015-05-31 18:50:00 | ES | Futures | 2225.98 | 2226.51 | 2225.72 | 2226.51 | 454.0 |
| 2015-05-31 18:55:00 | ES | Futures | 2226.51 | 2226.78 | 2225.72 | 2226.51 | 128.0 |
| 2015-05-31 19:00:00 | ES | Futures | 2226.51 | 2226.51 | 2225.72 | 2225.98 | 146.0 |
| 2015-05-31 19:05:00 | ES | Futures | 2225.98 | 2226.51 | 2225.98 | 2226.51 | 41.0 |
| 2015-05-31 19:10:00 | ES | Futures | 2226.51 | 2226.51 | 2226.25 | 2226.51 | 182.0 |
| 2015-05-31 19:15:00 | ES | Futures | 2226.51 | 2226.51 | 2226.25 | 2226.51 | 85.0 |
| 2015-05-31 19:20:00 | ES | Futures | 2226.51 | 2226.51 | 2225.98 | 2225.98 | 61.0 |
| 2015-05-31 19:25:00 | ES | Futures | 2225.98 | 2226.51 | 2225.98 | 2226.51 | 47.0 |
| 2015-05-31 19:30:00 | ES | Futures | 2226.51 | 2226.51 | 2226.25 | 2226.51 | 92.0 |
| 2015-05-31 19:35:00 | ES | Futures | 2226.51 | 2226.78 | 2226.25 | 2226.78 | 58.0 |
| 2015-05-31 19:40:00 | ES | Futures | 2226.51 | 2226.51 | 2224.93 | 2225.19 | 837.0 |
| 2015-05-31 19:45:00 | ES | Futures | 2225.46 | 2225.98 | 2225.46 | 2225.98 | 165.0 |
| 2015-05-31 19:50:00 | ES | Futures | 2226.25 | 2226.25 | 2225.72 | 2225.98 | 216.0 |
| 2015-05-31 19:55:00 | ES | Futures | 2226.25 | 2226.78 | 2225.98 | 2225.98 | 265.0 |
| 2015-05-31 20:00:00 | ES | Futures | 2226.25 | 2227.04 | 2225.98 | 2226.78 | 551.0 |
| 2015-05-31 20:05:00 | ES | Futures | 2226.78 | 2227.04 | 2226.25 | 2226.78 | 996.0 |
| 2015-05-31 20:10:00 | ES | Futures | 2227.04 | 2227.31 | 2226.78 | 2227.04 | 362.0 |
| 2015-05-31 20:15:00 | ES | Futures | 2227.04 | 2227.57 | 2226.78 | 2227.31 | 667.0 |
| 2015-05-31 20:20:00 | ES | Futures | 2227.57 | 2227.57 | 2227.04 | 2227.04 | 416.0 |
| 2015-05-31 20:25:00 | ES | Futures | 2227.31 | 2227.31 | 2226.51 | 2226.78 | 601.0 |
| 2015-05-31 20:30:00 | ES | Futures | 2226.78 | 2227.04 | 2225.98 | 2226.51 | 527.0 |
| 2015-05-31 20:35:00 | ES | Futures | 2226.51 | 2226.78 | 2226.25 | 2226.51 | 315.0 |
| 2015-05-31 20:40:00 | ES | Futures | 2226.51 | 2226.51 | 2225.98 | 2226.25 | 193.0 |
| 2015-05-31 20:45:00 | ES | Futures | 2226.51 | 2226.78 | 2225.72 | 2226.51 | 400.0 |
| 2015-05-31 20:50:00 | ES | Futures | 2226.78 | 2227.04 | 2226.51 | 2226.78 | 358.0 |
| 2015-05-31 20:55:00 | ES | Futures | 2227.04 | 2227.31 | 2226.78 | 2227.31 | 265.0 |
| 2015-05-31 21:00:00 | ES | Futures | 2227.31 | 2227.57 | 2226.78 | 2227.31 | 241.0 |
| 2015-05-31 21:05:00 | ES | Futures | 2227.57 | 2228.63 | 2227.31 | 2227.83 | 900.0 |
| 2015-05-31 21:10:00 | ES | Futures | 2227.83 | 2228.1 | 2227.04 | 2227.31 | 307.0 |
| 2015-05-31 21:15:00 | ES | Futures | 2227.31 | 2227.31 | 2226.51 | 2226.78 | 772.0 |
| 2015-05-31 21:20:00 | ES | Futures | 2227.04 | 2227.04 | 2226.51 | 2226.78 | 250.0 |
| 2015-05-31 21:25:00 | ES | Futures | 2226.78 | 2227.57 | 2226.78 | 2227.57 | 199.0 |
| 2015-05-31 21:30:00 | ES | Futures | 2227.57 | 2227.57 | 2227.31 | 2227.31 | 116.0 |
| 2015-05-31 21:35:00 | ES | Futures | 2227.31 | 2227.31 | 2226.51 | 2227.04 | 258.0 |
| 2015-05-31 21:40:00 | ES | Futures | 2227.04 | 2227.31 | 2226.78 | 2227.31 | 177.0 |
| 2015-05-31 21:45:00 | ES | Futures | 2227.31 | 2228.1 | 2227.31 | 2227.83 | 302.0 |
| 2015-05-31 21:50:00 | ES | Futures | 2227.83 | 2228.1 | 2227.83 | 2228.1 | 108.0 |
| 2015-05-31 21:55:00 | ES | Futures | 2228.1 | 2228.1 | 2227.83 | 2228.1 | 163.0 |
| 2015-05-31 22:00:00 | ES | Futures | 2228.1 | 2228.1 | 2227.57 | 2227.83 | 172.0 |
| 2015-05-31 22:05:00 | ES | Futures | 2228.1 | 2228.36 | 2227.83 | 2228.1 | 90.0 |
> showing 50 of 2,273 rows — these rows as CSV