PREVIEW / futures_30min / 2014-07-06
file: by_date/futures_30min/2014/2014-07-06.parquet size: 17 KB rows: 424
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-06 18:00:00 | ES | Futures | 2059.63 | 2060.94 | 2059.37 | 2060.41 | 1575.0 |
| 2014-07-06 18:30:00 | ES | Futures | 2060.67 | 2060.67 | 2060.15 | 2060.41 | 227.0 |
| 2014-07-06 19:00:00 | ES | Futures | 2060.15 | 2060.67 | 2059.89 | 2060.67 | 532.0 |
| 2014-07-06 19:30:00 | ES | Futures | 2060.67 | 2060.94 | 2060.15 | 2060.94 | 1107.0 |
| 2014-07-06 20:00:00 | ES | Futures | 2060.67 | 2060.94 | 2060.41 | 2060.94 | 567.0 |
| 2014-07-06 20:30:00 | ES | Futures | 2060.67 | 2061.46 | 2060.67 | 2061.2 | 2138.0 |
| 2014-07-06 21:00:00 | ES | Futures | 2061.2 | 2061.46 | 2060.67 | 2060.67 | 862.0 |
| 2014-07-06 21:30:00 | ES | Futures | 2060.67 | 2061.2 | 2060.67 | 2060.94 | 560.0 |
| 2014-07-06 22:00:00 | ES | Futures | 2060.94 | 2060.94 | 2059.37 | 2059.37 | 1187.0 |
| 2014-07-06 22:30:00 | ES | Futures | 2059.63 | 2060.15 | 2059.37 | 2059.63 | 559.0 |
| 2014-07-06 23:00:00 | ES | Futures | 2059.63 | 2059.89 | 2059.37 | 2059.37 | 369.0 |
| 2014-07-06 23:30:00 | ES | Futures | 2059.37 | 2059.89 | 2059.11 | 2059.89 | 1015.0 |
| 2014-07-06 18:00:00 | NQ | Futures | 4570.32 | 4572.95 | 4570.32 | 4572.07 | 321.0 |
| 2014-07-06 18:30:00 | NQ | Futures | 4572.37 | 4572.37 | 4571.49 | 4571.49 | 51.0 |
| 2014-07-06 19:00:00 | NQ | Futures | 4571.78 | 4572.07 | 4571.49 | 4572.07 | 69.0 |
| 2014-07-06 19:30:00 | NQ | Futures | 4572.07 | 4572.66 | 4571.49 | 4572.37 | 78.0 |
| 2014-07-06 20:00:00 | NQ | Futures | 4572.37 | 4572.37 | 4571.78 | 4572.07 | 52.0 |
| 2014-07-06 20:30:00 | NQ | Futures | 4572.37 | 4573.24 | 4572.37 | 4573.24 | 183.0 |
| 2014-07-06 21:00:00 | NQ | Futures | 4573.24 | 4573.24 | 4572.66 | 4572.66 | 55.0 |
| 2014-07-06 21:30:00 | NQ | Futures | 4572.66 | 4573.24 | 4572.37 | 4572.66 | 133.0 |
| 2014-07-06 22:00:00 | NQ | Futures | 4572.37 | 4572.37 | 4570.32 | 4570.32 | 281.0 |
| 2014-07-06 22:30:00 | NQ | Futures | 4570.32 | 4571.2 | 4570.32 | 4570.61 | 138.0 |
| 2014-07-06 23:00:00 | NQ | Futures | 4570.32 | 4571.2 | 4570.03 | 4570.32 | 75.0 |
| 2014-07-06 23:30:00 | NQ | Futures | 4570.61 | 4571.2 | 4569.74 | 4571.2 | 213.0 |
| 2014-07-06 18:00:00 | YM | Futures | 17553.5 | 17563.8 | 17552.5 | 17560.7 | 268.0 |
| 2014-07-06 18:30:00 | YM | Futures | 17560.7 | 17562.8 | 17560.7 | 17560.7 | 30.0 |
| 2014-07-06 19:00:00 | YM | Futures | 17560.7 | 17560.7 | 17558.7 | 17560.7 | 34.0 |
| 2014-07-06 19:30:00 | YM | Futures | 17560.7 | 17562.8 | 17559.7 | 17561.8 | 43.0 |
| 2014-07-06 20:00:00 | YM | Futures | 17561.8 | 17561.8 | 17559.7 | 17560.7 | 29.0 |
| 2014-07-06 20:30:00 | YM | Futures | 17561.8 | 17563.8 | 17560.7 | 17561.8 | 365.0 |
| 2014-07-06 21:00:00 | YM | Futures | 17561.8 | 17561.8 | 17555.6 | 17556.6 | 175.0 |
| 2014-07-06 21:30:00 | YM | Futures | 17557.6 | 17559.7 | 17556.6 | 17557.6 | 95.0 |
| 2014-07-06 22:00:00 | YM | Futures | 17558.7 | 17558.7 | 17551.4 | 17551.4 | 290.0 |
| 2014-07-06 22:30:00 | YM | Futures | 17551.4 | 17554.5 | 17550.4 | 17550.4 | 154.0 |
| 2014-07-06 23:00:00 | YM | Futures | 17550.4 | 17553.5 | 17550.4 | 17552.5 | 30.0 |
| 2014-07-06 23:30:00 | YM | Futures | 17551.4 | 17553.5 | 17547.3 | 17553.5 | 150.0 |
| 2014-07-06 18:00:00 | CL | Futures | 168.76 | 168.95 | 168.67 | 168.74 | 299.0 |
| 2014-07-06 18:30:00 | CL | Futures | 168.72 | 168.85 | 168.72 | 168.82 | 124.0 |
| 2014-07-06 19:00:00 | CL | Futures | 168.82 | 168.9 | 168.8 | 168.9 | 188.0 |
| 2014-07-06 19:30:00 | CL | Futures | 168.9 | 168.9 | 168.74 | 168.77 | 199.0 |
| 2014-07-06 20:00:00 | CL | Futures | 168.79 | 168.8 | 168.76 | 168.8 | 50.0 |
| 2014-07-06 20:30:00 | CL | Futures | 168.79 | 168.82 | 168.79 | 168.8 | 47.0 |
| 2014-07-06 21:00:00 | CL | Futures | 168.8 | 168.87 | 168.77 | 168.87 | 111.0 |
| 2014-07-06 21:30:00 | CL | Futures | 168.85 | 169.23 | 168.85 | 169.21 | 915.0 |
| 2014-07-06 22:00:00 | CL | Futures | 169.19 | 169.31 | 169.16 | 169.23 | 708.0 |
| 2014-07-06 22:30:00 | CL | Futures | 169.23 | 169.24 | 169.08 | 169.1 | 274.0 |
| 2014-07-06 23:00:00 | CL | Futures | 169.1 | 169.24 | 169.06 | 169.23 | 407.0 |
| 2014-07-06 23:30:00 | CL | Futures | 169.21 | 169.21 | 169.1 | 169.11 | 115.0 |
| 2014-07-06 18:00:00 | GC | Futures | 1809.9 | 1810.3 | 1805.5 | 1807.7 | 999.0 |
| 2014-07-06 18:30:00 | GC | Futures | 1807.6 | 1807.8 | 1803.6 | 1806.6 | 808.0 |
> showing 50 of 424 rows — these rows as CSV