PREVIEW / futures_1hour / 2015-06-28
file: by_date/futures_1hour/2015/2015-06-28.parquet size: 15 KB rows: 287
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-06-28 18:00:00 | ES | Futures | 2198.15 | 2198.68 | 2187.5 | 2198.15 | 70613.0 |
| 2015-06-28 19:00:00 | ES | Futures | 2198.15 | 2202.41 | 2192.82 | 2194.95 | 23147.0 |
| 2015-06-28 20:00:00 | ES | Futures | 2195.22 | 2200.01 | 2194.68 | 2197.08 | 17828.0 |
| 2015-06-28 21:00:00 | ES | Futures | 2197.08 | 2202.94 | 2196.81 | 2201.87 | 19029.0 |
| 2015-06-28 22:00:00 | ES | Futures | 2201.87 | 2202.41 | 2199.74 | 2201.61 | 11498.0 |
| 2015-06-28 23:00:00 | ES | Futures | 2201.61 | 2205.6 | 2199.21 | 2199.74 | 14659.0 |
| 2015-06-28 18:00:00 | NQ | Futures | 5241.09 | 5241.09 | 5205.89 | 5223.35 | 5912.0 |
| 2015-06-28 19:00:00 | NQ | Futures | 5223.94 | 5232.51 | 5215.36 | 5219.2 | 1587.0 |
| 2015-06-28 20:00:00 | NQ | Futures | 5219.5 | 5230.15 | 5218.91 | 5222.16 | 1439.0 |
| 2015-06-28 21:00:00 | NQ | Futures | 5223.05 | 5233.4 | 5220.98 | 5231.04 | 2515.0 |
| 2015-06-28 22:00:00 | NQ | Futures | 5231.33 | 5233.11 | 5227.19 | 5228.97 | 1191.0 |
| 2015-06-28 23:00:00 | NQ | Futures | 5228.97 | 5235.77 | 5222.46 | 5223.64 | 1199.0 |
| 2015-06-28 18:00:00 | YM | Futures | 18634.7 | 18634.7 | 18464.0 | 18571.4 | 5460.0 |
| 2015-06-28 19:00:00 | YM | Futures | 18571.4 | 18603.1 | 18537.7 | 18550.4 | 2579.0 |
| 2015-06-28 20:00:00 | YM | Futures | 18551.4 | 18587.3 | 18546.2 | 18569.3 | 2406.0 |
| 2015-06-28 21:00:00 | YM | Futures | 18570.4 | 18605.2 | 18565.1 | 18597.8 | 2108.0 |
| 2015-06-28 22:00:00 | YM | Futures | 18599.9 | 18600.9 | 18583.0 | 18590.4 | 1150.0 |
| 2015-06-28 23:00:00 | YM | Futures | 18589.4 | 18616.7 | 18569.3 | 18571.4 | 2109.0 |
| 2015-06-28 18:00:00 | CL | Futures | 87.66 | 88.07 | 87.34 | 87.6 | 4951.0 |
| 2015-06-28 19:00:00 | CL | Futures | 87.61 | 87.67 | 87.49 | 87.57 | 858.0 |
| 2015-06-28 20:00:00 | CL | Futures | 87.55 | 87.66 | 87.55 | 87.6 | 1367.0 |
| 2015-06-28 21:00:00 | CL | Futures | 87.6 | 87.67 | 87.54 | 87.61 | 1234.0 |
| 2015-06-28 22:00:00 | CL | Futures | 87.6 | 87.63 | 87.48 | 87.54 | 774.0 |
| 2015-06-28 23:00:00 | CL | Futures | 87.54 | 87.58 | 87.49 | 87.54 | 701.0 |
| 2015-06-28 18:00:00 | GC | Futures | 1614.1 | 1621.0 | 1612.4 | 1616.8 | 9596.0 |
| 2015-06-28 19:00:00 | GC | Futures | 1617.1 | 1620.2 | 1614.2 | 1617.5 | 3982.0 |
| 2015-06-28 20:00:00 | GC | Futures | 1617.7 | 1619.8 | 1616.0 | 1617.3 | 4686.0 |
| 2015-06-28 21:00:00 | GC | Futures | 1617.3 | 1618.0 | 1609.3 | 1611.6 | 6267.0 |
| 2015-06-28 22:00:00 | GC | Futures | 1611.6 | 1613.5 | 1611.5 | 1613.1 | 1817.0 |
| 2015-06-28 23:00:00 | GC | Futures | 1613.0 | 1613.7 | 1611.7 | 1612.6 | 1570.0 |
| 2015-06-28 18:00:00 | ZN | Futures | 121.506357 | 122.077515 | 121.506357 | 121.821997 | 96387.0 |
| 2015-06-28 19:00:00 | ZN | Futures | 121.821997 | 121.837027 | 121.61157 | 121.641631 | 41559.0 |
| 2015-06-28 20:00:00 | ZN | Futures | 121.656661 | 121.701753 | 121.461265 | 121.506357 | 51962.0 |
| 2015-06-28 21:00:00 | ZN | Futures | 121.506357 | 121.536418 | 121.446235 | 121.506357 | 16587.0 |
| 2015-06-28 22:00:00 | ZN | Futures | 121.506357 | 121.521387 | 121.461265 | 121.491326 | 6637.0 |
| 2015-06-28 23:00:00 | ZN | Futures | 121.491326 | 121.551448 | 121.446235 | 121.536418 | 14462.0 |
> showing 36 of 287 rows — these rows as CSV