PREVIEW / futures_1hour / 2018-10-28
file: by_date/futures_1hour/2018/2018-10-28.parquet size: 16 KB rows: 314
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-10-28 18:00:00 | ES | Futures | 2901.68 | 2918.27 | 2900.59 | 2912.83 | 18000.0 |
| 2018-10-28 19:00:00 | ES | Futures | 2912.83 | 2916.36 | 2907.93 | 2909.29 | 11777.0 |
| 2018-10-28 20:00:00 | ES | Futures | 2909.29 | 2914.73 | 2908.2 | 2910.65 | 14928.0 |
| 2018-10-28 21:00:00 | ES | Futures | 2910.38 | 2910.92 | 2900.86 | 2903.85 | 18532.0 |
| 2018-10-28 22:00:00 | ES | Futures | 2903.85 | 2905.48 | 2896.51 | 2902.22 | 20746.0 |
| 2018-10-28 23:00:00 | ES | Futures | 2902.22 | 2906.57 | 2900.59 | 2901.13 | 8370.0 |
| 2018-10-28 18:00:00 | NQ | Futures | 8093.12 | 8153.25 | 8072.01 | 8131.25 | 8058.0 |
| 2018-10-28 19:00:00 | NQ | Futures | 8131.25 | 8143.87 | 8112.19 | 8120.11 | 4089.0 |
| 2018-10-28 20:00:00 | NQ | Futures | 8119.23 | 8142.69 | 8116.59 | 8132.13 | 5372.0 |
| 2018-10-28 21:00:00 | NQ | Futures | 8131.55 | 8133.01 | 8100.46 | 8107.79 | 6763.0 |
| 2018-10-28 22:00:00 | NQ | Futures | 8106.91 | 8116.59 | 8088.43 | 8109.84 | 7662.0 |
| 2018-10-28 23:00:00 | NQ | Futures | 8109.55 | 8124.8 | 8100.16 | 8102.22 | 3611.0 |
| 2018-10-28 18:00:00 | YM | Futures | 26853.2 | 27002.0 | 26853.2 | 26956.4 | 2446.0 |
| 2018-10-28 19:00:00 | YM | Futures | 26955.3 | 26991.1 | 26920.5 | 26935.7 | 1733.0 |
| 2018-10-28 20:00:00 | YM | Futures | 26934.6 | 26992.2 | 26928.1 | 26952.0 | 4530.0 |
| 2018-10-28 21:00:00 | YM | Futures | 26949.9 | 26958.5 | 26866.2 | 26893.4 | 6318.0 |
| 2018-10-28 22:00:00 | YM | Futures | 26893.4 | 26903.1 | 26824.9 | 26874.9 | 6244.0 |
| 2018-10-28 23:00:00 | YM | Futures | 26873.8 | 26907.5 | 26855.3 | 26860.8 | 3351.0 |
| 2018-10-28 18:00:00 | CL | Futures | 62.1 | 62.17 | 62.02 | 62.1 | 2479.0 |
| 2018-10-28 19:00:00 | CL | Futures | 62.1 | 62.29 | 62.07 | 62.22 | 2710.0 |
| 2018-10-28 20:00:00 | CL | Futures | 62.22 | 62.44 | 62.22 | 62.41 | 4349.0 |
| 2018-10-28 21:00:00 | CL | Futures | 62.42 | 62.46 | 62.21 | 62.23 | 5552.0 |
| 2018-10-28 22:00:00 | CL | Futures | 62.23 | 62.24 | 62.09 | 62.15 | 7103.0 |
| 2018-10-28 23:00:00 | CL | Futures | 62.15 | 62.2 | 62.1 | 62.14 | 2556.0 |
| 2018-10-28 18:00:00 | GC | Futures | 1610.8 | 1611.8 | 1609.4 | 1609.7 | 1817.0 |
| 2018-10-28 19:00:00 | GC | Futures | 1609.7 | 1610.7 | 1609.0 | 1609.2 | 1988.0 |
| 2018-10-28 20:00:00 | GC | Futures | 1609.0 | 1609.7 | 1607.7 | 1608.9 | 4702.0 |
| 2018-10-28 21:00:00 | GC | Futures | 1608.8 | 1612.4 | 1608.5 | 1611.9 | 6618.0 |
| 2018-10-28 22:00:00 | GC | Futures | 1611.9 | 1612.4 | 1610.1 | 1611.2 | 4977.0 |
| 2018-10-28 23:00:00 | GC | Futures | 1611.1 | 1611.5 | 1609.4 | 1610.1 | 3764.0 |
| 2018-10-28 18:00:00 | ZN | Futures | 119.881415 | 119.928631 | 119.834199 | 119.849937 | 11280.0 |
| 2018-10-28 19:00:00 | ZN | Futures | 119.834199 | 119.865676 | 119.834199 | 119.849937 | 7136.0 |
| 2018-10-28 20:00:00 | ZN | Futures | 119.849937 | 119.865676 | 119.755505 | 119.786983 | 22351.0 |
| 2018-10-28 21:00:00 | ZN | Futures | 119.786983 | 119.881415 | 119.771244 | 119.849937 | 26366.0 |
| 2018-10-28 22:00:00 | ZN | Futures | 119.865676 | 119.897153 | 119.834199 | 119.849937 | 12747.0 |
| 2018-10-28 23:00:00 | ZN | Futures | 119.849937 | 119.865676 | 119.81846 | 119.849937 | 9416.0 |
> showing 36 of 314 rows — these rows as CSV