PREVIEW / futures_1hour / 2019-04-07
file: by_date/futures_1hour/2019/2019-04-07.parquet size: 16 KB rows: 339
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 |
|---|---|---|---|---|---|---|---|
| 2019-04-07 18:00:00 | ES | Futures | 3140.72 | 3143.16 | 3140.45 | 3141.8 | 5256.0 |
| 2019-04-07 19:00:00 | ES | Futures | 3141.53 | 3144.24 | 3140.72 | 3142.62 | 4845.0 |
| 2019-04-07 20:00:00 | ES | Futures | 3142.35 | 3142.35 | 3138.01 | 3139.36 | 9586.0 |
| 2019-04-07 21:00:00 | ES | Futures | 3139.36 | 3139.36 | 3136.92 | 3138.01 | 8640.0 |
| 2019-04-07 22:00:00 | ES | Futures | 3138.28 | 3138.55 | 3136.38 | 3137.2 | 7225.0 |
| 2019-04-07 23:00:00 | ES | Futures | 3137.47 | 3137.47 | 3133.4 | 3135.3 | 9454.0 |
| 2019-04-07 18:00:00 | NQ | Futures | 8860.17 | 8865.12 | 8856.97 | 8861.33 | 2529.0 |
| 2019-04-07 19:00:00 | NQ | Futures | 8861.33 | 8874.15 | 8859.59 | 8866.58 | 2621.0 |
| 2019-04-07 20:00:00 | NQ | Futures | 8866.58 | 8866.87 | 8850.56 | 8854.64 | 4889.0 |
| 2019-04-07 21:00:00 | NQ | Futures | 8854.64 | 8856.68 | 8847.36 | 8852.89 | 4580.0 |
| 2019-04-07 22:00:00 | NQ | Futures | 8852.6 | 8853.76 | 8845.61 | 8848.81 | 4369.0 |
| 2019-04-07 23:00:00 | NQ | Futures | 8848.81 | 8849.11 | 8837.17 | 8840.95 | 4423.0 |
| 2019-04-07 18:00:00 | YM | Futures | 28702.4 | 28712.2 | 28664.4 | 28703.5 | 1790.0 |
| 2019-04-07 19:00:00 | YM | Futures | 28703.5 | 28727.5 | 28694.8 | 28710.1 | 834.0 |
| 2019-04-07 20:00:00 | YM | Futures | 28712.2 | 28713.3 | 28672.0 | 28684.0 | 3369.0 |
| 2019-04-07 21:00:00 | YM | Futures | 28682.9 | 28688.3 | 28666.6 | 28675.3 | 2998.0 |
| 2019-04-07 22:00:00 | YM | Futures | 28675.3 | 28677.4 | 28642.6 | 28658.9 | 3857.0 |
| 2019-04-07 23:00:00 | YM | Futures | 28658.9 | 28660.0 | 28614.3 | 28633.9 | 3553.0 |
| 2019-04-07 18:00:00 | CL | Futures | 56.74 | 56.88 | 56.71 | 56.81 | 5787.0 |
| 2019-04-07 19:00:00 | CL | Futures | 56.82 | 56.87 | 56.81 | 56.81 | 2146.0 |
| 2019-04-07 20:00:00 | CL | Futures | 56.81 | 56.88 | 56.77 | 56.84 | 4525.0 |
| 2019-04-07 21:00:00 | CL | Futures | 56.85 | 56.88 | 56.77 | 56.86 | 8534.0 |
| 2019-04-07 22:00:00 | CL | Futures | 56.87 | 56.88 | 56.84 | 56.85 | 4046.0 |
| 2019-04-07 23:00:00 | CL | Futures | 56.86 | 56.87 | 56.8 | 56.82 | 3526.0 |
| 2019-04-07 18:00:00 | GC | Futures | 1662.9 | 1666.2 | 1662.7 | 1664.7 | 3851.0 |
| 2019-04-07 19:00:00 | GC | Futures | 1664.7 | 1664.9 | 1662.5 | 1663.0 | 1827.0 |
| 2019-04-07 20:00:00 | GC | Futures | 1662.9 | 1665.6 | 1662.7 | 1665.4 | 5524.0 |
| 2019-04-07 21:00:00 | GC | Futures | 1665.6 | 1668.8 | 1664.4 | 1668.5 | 10220.0 |
| 2019-04-07 22:00:00 | GC | Futures | 1668.6 | 1669.2 | 1667.8 | 1668.1 | 5778.0 |
| 2019-04-07 23:00:00 | GC | Futures | 1668.3 | 1668.9 | 1668.1 | 1668.3 | 3443.0 |
| 2019-04-07 18:00:00 | ZN | Futures | 124.286556 | 124.302265 | 124.239431 | 124.239431 | 5286.0 |
| 2019-04-07 19:00:00 | ZN | Futures | 124.255139 | 124.255139 | 124.223722 | 124.239431 | 2743.0 |
| 2019-04-07 20:00:00 | ZN | Futures | 124.239431 | 124.270848 | 124.208013 | 124.255139 | 36512.0 |
| 2019-04-07 21:00:00 | ZN | Futures | 124.255139 | 124.270848 | 124.239431 | 124.270848 | 10272.0 |
| 2019-04-07 22:00:00 | ZN | Futures | 124.286556 | 124.317974 | 124.270848 | 124.317974 | 13640.0 |
| 2019-04-07 23:00:00 | ZN | Futures | 124.317974 | 124.3651 | 124.302265 | 124.333682 | 25034.0 |
> showing 36 of 339 rows — these rows as CSV