PREVIEW / futures_1hour / 2015-06-14
file: by_date/futures_1hour/2015/2015-06-14.parquet size: 14 KB rows: 263
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-14 18:00:00 | ES | Futures | 2211.46 | 2213.32 | 2206.67 | 2210.93 | 15269.0 |
| 2015-06-14 19:00:00 | ES | Futures | 2210.93 | 2212.26 | 2209.86 | 2211.72 | 3449.0 |
| 2015-06-14 20:00:00 | ES | Futures | 2211.99 | 2214.39 | 2210.13 | 2213.32 | 6194.0 |
| 2015-06-14 21:00:00 | ES | Futures | 2213.06 | 2213.85 | 2211.72 | 2212.52 | 2606.0 |
| 2015-06-14 22:00:00 | ES | Futures | 2212.26 | 2212.52 | 2210.66 | 2210.93 | 2180.0 |
| 2015-06-14 23:00:00 | ES | Futures | 2210.66 | 2211.19 | 2209.06 | 2210.13 | 3332.0 |
| 2015-06-14 18:00:00 | NQ | Futures | 5241.39 | 5244.05 | 5226.01 | 5237.25 | 1694.0 |
| 2015-06-14 19:00:00 | NQ | Futures | 5237.54 | 5240.5 | 5235.77 | 5240.21 | 365.0 |
| 2015-06-14 20:00:00 | NQ | Futures | 5240.21 | 5244.64 | 5235.77 | 5242.87 | 893.0 |
| 2015-06-14 21:00:00 | NQ | Futures | 5242.57 | 5244.94 | 5239.91 | 5241.39 | 502.0 |
| 2015-06-14 22:00:00 | NQ | Futures | 5241.39 | 5241.98 | 5236.95 | 5237.54 | 395.0 |
| 2015-06-14 23:00:00 | NQ | Futures | 5237.25 | 5238.13 | 5233.11 | 5234.88 | 619.0 |
| 2015-06-14 18:00:00 | YM | Futures | 18703.1 | 18709.5 | 18658.9 | 18688.4 | 1448.0 |
| 2015-06-14 19:00:00 | YM | Futures | 18688.4 | 18698.9 | 18681.0 | 18696.8 | 277.0 |
| 2015-06-14 20:00:00 | YM | Futures | 18697.9 | 18718.9 | 18686.3 | 18713.7 | 659.0 |
| 2015-06-14 21:00:00 | YM | Futures | 18712.6 | 18714.7 | 18702.1 | 18705.2 | 593.0 |
| 2015-06-14 22:00:00 | YM | Futures | 18704.2 | 18705.2 | 18691.5 | 18692.6 | 418.0 |
| 2015-06-14 23:00:00 | YM | Futures | 18692.6 | 18694.7 | 18678.9 | 18686.3 | 587.0 |
| 2015-06-14 18:00:00 | CL | Futures | 89.88 | 89.88 | 89.53 | 89.58 | 370.0 |
| 2015-06-14 19:00:00 | CL | Futures | 89.56 | 89.76 | 89.55 | 89.74 | 154.0 |
| 2015-06-14 20:00:00 | CL | Futures | 89.74 | 89.85 | 89.67 | 89.71 | 146.0 |
| 2015-06-14 21:00:00 | CL | Futures | 89.7 | 89.77 | 89.48 | 89.56 | 171.0 |
| 2015-06-14 22:00:00 | CL | Futures | 89.58 | 89.73 | 89.56 | 89.67 | 196.0 |
| 2015-06-14 23:00:00 | CL | Futures | 89.65 | 89.67 | 89.59 | 89.67 | 99.0 |
| 2015-06-14 18:00:00 | GC | Futures | 1610.6 | 1618.7 | 1610.6 | 1618.0 | 3075.0 |
| 2015-06-14 19:00:00 | GC | Futures | 1618.0 | 1618.2 | 1614.6 | 1615.3 | 1083.0 |
| 2015-06-14 20:00:00 | GC | Futures | 1615.2 | 1615.2 | 1611.9 | 1612.3 | 1477.0 |
| 2015-06-14 21:00:00 | GC | Futures | 1612.6 | 1612.6 | 1610.1 | 1611.5 | 2164.0 |
| 2015-06-14 22:00:00 | GC | Futures | 1611.5 | 1612.7 | 1611.2 | 1611.7 | 1140.0 |
| 2015-06-14 23:00:00 | GC | Futures | 1611.9 | 1612.6 | 1611.5 | 1611.9 | 821.0 |
| 2015-06-14 18:00:00 | ZN | Futures | 120.679681 | 121.025382 | 120.604528 | 120.950229 | 25039.0 |
| 2015-06-14 19:00:00 | ZN | Futures | 120.950229 | 120.995321 | 120.784894 | 120.814955 | 10018.0 |
| 2015-06-14 20:00:00 | ZN | Futures | 120.829985 | 120.845016 | 120.754833 | 120.799924 | 7309.0 |
| 2015-06-14 21:00:00 | ZN | Futures | 120.799924 | 120.875077 | 120.799924 | 120.845016 | 6728.0 |
| 2015-06-14 22:00:00 | ZN | Futures | 120.845016 | 120.890107 | 120.829985 | 120.875077 | 5018.0 |
| 2015-06-14 23:00:00 | ZN | Futures | 120.860046 | 120.920168 | 120.860046 | 120.905138 | 3626.0 |
> showing 36 of 263 rows — these rows as CSV