PREVIEW / futures_1hour / 2018-01-14
file: by_date/futures_1hour/2018/2018-01-14.parquet size: 14 KB rows: 274
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-14 18:00:00 | ES | Futures | 3050.07 | 3056.63 | 3050.07 | 3056.35 | 12591.0 |
| 2018-01-14 19:00:00 | ES | Futures | 3056.35 | 3058.54 | 3054.44 | 3055.53 | 10650.0 |
| 2018-01-14 20:00:00 | ES | Futures | 3055.26 | 3055.81 | 3054.17 | 3054.17 | 5919.0 |
| 2018-01-14 21:00:00 | ES | Futures | 3054.44 | 3055.26 | 3053.89 | 3054.71 | 4487.0 |
| 2018-01-14 22:00:00 | ES | Futures | 3054.71 | 3055.81 | 3054.17 | 3055.53 | 3383.0 |
| 2018-01-14 23:00:00 | ES | Futures | 3055.53 | 3056.08 | 3055.26 | 3056.08 | 2661.0 |
| 2018-01-14 18:00:00 | NQ | Futures | 8045.42 | 8054.31 | 8038.89 | 8052.24 | 2261.0 |
| 2018-01-14 19:00:00 | NQ | Futures | 8051.64 | 8057.87 | 8046.31 | 8051.94 | 2625.0 |
| 2018-01-14 20:00:00 | NQ | Futures | 8051.64 | 8052.53 | 8046.31 | 8048.97 | 1538.0 |
| 2018-01-14 21:00:00 | NQ | Futures | 8049.27 | 8054.61 | 8047.79 | 8054.61 | 1085.0 |
| 2018-01-14 22:00:00 | NQ | Futures | 8054.02 | 8058.76 | 8053.72 | 8057.58 | 924.0 |
| 2018-01-14 23:00:00 | NQ | Futures | 8057.28 | 8062.03 | 8055.8 | 8061.43 | 1061.0 |
| 2018-01-14 18:00:00 | YM | Futures | 28055.6 | 28150.2 | 28050.2 | 28146.9 | 3516.0 |
| 2018-01-14 19:00:00 | YM | Futures | 28145.8 | 28169.8 | 28143.7 | 28153.5 | 2920.0 |
| 2018-01-14 20:00:00 | YM | Futures | 28152.4 | 28160.0 | 28141.5 | 28143.7 | 1197.0 |
| 2018-01-14 21:00:00 | YM | Futures | 28142.6 | 28153.5 | 28136.1 | 28142.6 | 1002.0 |
| 2018-01-14 22:00:00 | YM | Futures | 28141.5 | 28153.5 | 28141.5 | 28149.1 | 446.0 |
| 2018-01-14 23:00:00 | YM | Futures | 28148.0 | 28158.9 | 28148.0 | 28156.7 | 743.0 |
| 2018-01-14 18:00:00 | CL | Futures | 57.13 | 57.18 | 56.94 | 57.02 | 906.0 |
| 2018-01-14 19:00:00 | CL | Futures | 57.04 | 57.06 | 56.99 | 57.01 | 608.0 |
| 2018-01-14 20:00:00 | CL | Futures | 57.01 | 57.13 | 57.01 | 57.11 | 1146.0 |
| 2018-01-14 21:00:00 | CL | Futures | 57.1 | 57.17 | 57.07 | 57.15 | 1319.0 |
| 2018-01-14 22:00:00 | CL | Futures | 57.15 | 57.16 | 57.1 | 57.1 | 345.0 |
| 2018-01-14 23:00:00 | CL | Futures | 57.11 | 57.3 | 57.11 | 57.19 | 1533.0 |
| 2018-01-14 18:00:00 | GC | Futures | 1776.0 | 1777.7 | 1774.6 | 1776.1 | 4005.0 |
| 2018-01-14 19:00:00 | GC | Futures | 1776.0 | 1778.2 | 1775.4 | 1778.0 | 7237.0 |
| 2018-01-14 20:00:00 | GC | Futures | 1777.8 | 1780.1 | 1776.4 | 1779.0 | 14368.0 |
| 2018-01-14 21:00:00 | GC | Futures | 1779.2 | 1782.7 | 1778.9 | 1780.9 | 12002.0 |
| 2018-01-14 22:00:00 | GC | Futures | 1780.9 | 1781.7 | 1780.1 | 1781.4 | 3920.0 |
| 2018-01-14 23:00:00 | GC | Futures | 1781.3 | 1783.9 | 1781.0 | 1783.4 | 5068.0 |
| 2018-01-14 18:00:00 | ZN | Futures | 122.661805 | 122.708581 | 122.661805 | 122.692989 | 9736.0 |
| 2018-01-14 19:00:00 | ZN | Futures | 122.692989 | 122.724173 | 122.692989 | 122.692989 | 9774.0 |
| 2018-01-14 20:00:00 | ZN | Futures | 122.708581 | 122.724173 | 122.692989 | 122.708581 | 7639.0 |
| 2018-01-14 21:00:00 | ZN | Futures | 122.692989 | 122.708581 | 122.692989 | 122.692989 | 3721.0 |
| 2018-01-14 22:00:00 | ZN | Futures | 122.708581 | 122.708581 | 122.692989 | 122.708581 | 1324.0 |
| 2018-01-14 23:00:00 | ZN | Futures | 122.708581 | 122.708581 | 122.692989 | 122.692989 | 3060.0 |
> showing 36 of 274 rows — these rows as CSV