PREVIEW / futures_1hour / 2015-11-15
file: by_date/futures_1hour/2015/2015-11-15.parquet size: 14 KB rows: 284
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-11-15 18:00:00 | ES | Futures | 2147.57 | 2148.91 | 2139.01 | 2146.23 | 35387.0 |
| 2015-11-15 19:00:00 | ES | Futures | 2145.96 | 2150.25 | 2145.96 | 2149.98 | 12833.0 |
| 2015-11-15 20:00:00 | ES | Futures | 2149.98 | 2153.99 | 2149.18 | 2152.65 | 12814.0 |
| 2015-11-15 21:00:00 | ES | Futures | 2152.65 | 2153.46 | 2148.91 | 2149.44 | 5709.0 |
| 2015-11-15 22:00:00 | ES | Futures | 2149.44 | 2150.51 | 2148.64 | 2149.18 | 5892.0 |
| 2015-11-15 23:00:00 | ES | Futures | 2149.18 | 2152.65 | 2149.18 | 2151.58 | 3883.0 |
| 2015-11-15 18:00:00 | NQ | Futures | 5311.04 | 5311.04 | 5283.47 | 5301.85 | 4699.0 |
| 2015-11-15 19:00:00 | NQ | Futures | 5301.26 | 5310.75 | 5301.26 | 5309.56 | 2295.0 |
| 2015-11-15 20:00:00 | NQ | Futures | 5309.56 | 5322.61 | 5308.67 | 5319.35 | 2216.0 |
| 2015-11-15 21:00:00 | NQ | Futures | 5319.35 | 5321.42 | 5311.93 | 5312.53 | 1040.0 |
| 2015-11-15 22:00:00 | NQ | Futures | 5312.53 | 5315.19 | 5309.56 | 5310.15 | 1092.0 |
| 2015-11-15 23:00:00 | NQ | Futures | 5311.04 | 5318.46 | 5310.45 | 5316.97 | 719.0 |
| 2015-11-15 18:00:00 | YM | Futures | 18121.7 | 18136.5 | 18062.4 | 18114.3 | 4902.0 |
| 2015-11-15 19:00:00 | YM | Futures | 18113.2 | 18148.2 | 18112.2 | 18146.1 | 1993.0 |
| 2015-11-15 20:00:00 | YM | Futures | 18144.0 | 18175.7 | 18141.8 | 18167.3 | 1482.0 |
| 2015-11-15 21:00:00 | YM | Futures | 18168.3 | 18174.7 | 18142.9 | 18145.0 | 798.0 |
| 2015-11-15 22:00:00 | YM | Futures | 18144.0 | 18151.4 | 18138.7 | 18142.9 | 794.0 |
| 2015-11-15 23:00:00 | YM | Futures | 18141.8 | 18169.4 | 18141.8 | 18160.9 | 547.0 |
| 2015-11-15 18:00:00 | CL | Futures | 57.73 | 57.92 | 57.37 | 57.77 | 564.0 |
| 2015-11-15 19:00:00 | CL | Futures | 57.79 | 57.8 | 57.61 | 57.77 | 335.0 |
| 2015-11-15 20:00:00 | CL | Futures | 57.77 | 57.94 | 57.73 | 57.94 | 887.0 |
| 2015-11-15 21:00:00 | CL | Futures | 57.94 | 58.06 | 57.85 | 58.0 | 644.0 |
| 2015-11-15 22:00:00 | CL | Futures | 58.0 | 58.07 | 57.95 | 58.06 | 449.0 |
| 2015-11-15 23:00:00 | CL | Futures | 58.05 | 58.1 | 58.02 | 58.07 | 310.0 |
| 2015-11-15 18:00:00 | GC | Futures | 1485.3 | 1487.5 | 1481.7 | 1486.3 | 5372.0 |
| 2015-11-15 19:00:00 | GC | Futures | 1486.2 | 1490.5 | 1485.9 | 1486.7 | 5339.0 |
| 2015-11-15 20:00:00 | GC | Futures | 1486.6 | 1492.3 | 1485.5 | 1490.1 | 7596.0 |
| 2015-11-15 21:00:00 | GC | Futures | 1490.3 | 1492.0 | 1489.8 | 1490.3 | 2661.0 |
| 2015-11-15 22:00:00 | GC | Futures | 1490.1 | 1491.9 | 1490.1 | 1491.5 | 1502.0 |
| 2015-11-15 23:00:00 | GC | Futures | 1491.3 | 1491.8 | 1490.8 | 1491.6 | 1712.0 |
| 2015-11-15 18:00:00 | ZN | Futures | 122.570672 | 122.570672 | 122.449972 | 122.495235 | 30902.0 |
| 2015-11-15 19:00:00 | ZN | Futures | 122.495235 | 122.555585 | 122.46506 | 122.480147 | 19259.0 |
| 2015-11-15 20:00:00 | ZN | Futures | 122.480147 | 122.510322 | 122.449972 | 122.46506 | 7587.0 |
| 2015-11-15 21:00:00 | ZN | Futures | 122.46506 | 122.495235 | 122.449972 | 122.480147 | 4657.0 |
| 2015-11-15 22:00:00 | ZN | Futures | 122.495235 | 122.540497 | 122.480147 | 122.52541 | 5992.0 |
| 2015-11-15 23:00:00 | ZN | Futures | 122.540497 | 122.540497 | 122.510322 | 122.52541 | 4270.0 |
> showing 36 of 284 rows — these rows as CSV