PREVIEW / futures_1hour / 2016-10-02
file: by_date/futures_1hour/2016/2016-10-02.parquet size: 15 KB rows: 289
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-02 18:00:00 | ES | Futures | 2349.4 | 2351.85 | 2348.59 | 2351.58 | 8557.0 |
| 2016-10-02 19:00:00 | ES | Futures | 2351.31 | 2352.94 | 2351.31 | 2352.67 | 3933.0 |
| 2016-10-02 20:00:00 | ES | Futures | 2352.67 | 2352.94 | 2350.76 | 2352.12 | 3623.0 |
| 2016-10-02 21:00:00 | ES | Futures | 2352.12 | 2355.12 | 2352.12 | 2354.03 | 7374.0 |
| 2016-10-02 22:00:00 | ES | Futures | 2354.3 | 2354.57 | 2353.48 | 2354.3 | 2838.0 |
| 2016-10-02 23:00:00 | ES | Futures | 2354.3 | 2354.57 | 2352.67 | 2352.67 | 2936.0 |
| 2016-10-02 18:00:00 | NQ | Futures | 5808.28 | 5815.14 | 5806.49 | 5814.55 | 1205.0 |
| 2016-10-02 19:00:00 | NQ | Futures | 5814.55 | 5818.13 | 5813.95 | 5817.53 | 570.0 |
| 2016-10-02 20:00:00 | NQ | Futures | 5817.23 | 5817.23 | 5812.76 | 5815.14 | 596.0 |
| 2016-10-02 21:00:00 | NQ | Futures | 5814.85 | 5822.9 | 5814.85 | 5819.92 | 1218.0 |
| 2016-10-02 22:00:00 | NQ | Futures | 5820.51 | 5821.11 | 5817.53 | 5819.62 | 269.0 |
| 2016-10-02 23:00:00 | NQ | Futures | 5820.22 | 5820.51 | 5816.34 | 5817.53 | 297.0 |
| 2016-10-02 18:00:00 | YM | Futures | 19673.1 | 19699.1 | 19673.1 | 19695.8 | 1845.0 |
| 2016-10-02 19:00:00 | YM | Futures | 19695.8 | 19709.9 | 19694.7 | 19706.6 | 694.0 |
| 2016-10-02 20:00:00 | YM | Futures | 19706.6 | 19706.6 | 19691.5 | 19702.3 | 743.0 |
| 2016-10-02 21:00:00 | YM | Futures | 19701.2 | 19727.2 | 19701.2 | 19720.7 | 1283.0 |
| 2016-10-02 22:00:00 | YM | Futures | 19719.6 | 19721.8 | 19713.1 | 19718.5 | 449.0 |
| 2016-10-02 23:00:00 | YM | Futures | 19719.6 | 19721.8 | 19704.5 | 19707.7 | 437.0 |
| 2016-10-02 18:00:00 | CL | Futures | 48.22 | 48.22 | 48.02 | 48.05 | 2214.0 |
| 2016-10-02 19:00:00 | CL | Futures | 48.05 | 48.07 | 47.96 | 47.99 | 2096.0 |
| 2016-10-02 20:00:00 | CL | Futures | 47.98 | 48.06 | 47.97 | 48.05 | 1368.0 |
| 2016-10-02 21:00:00 | CL | Futures | 48.04 | 48.25 | 48.0 | 48.16 | 3908.0 |
| 2016-10-02 22:00:00 | CL | Futures | 48.16 | 48.18 | 48.11 | 48.15 | 1096.0 |
| 2016-10-02 23:00:00 | CL | Futures | 48.15 | 48.23 | 48.15 | 48.16 | 1747.0 |
| 2016-10-02 18:00:00 | GC | Futures | 1787.3 | 1787.9 | 1783.7 | 1784.4 | 1314.0 |
| 2016-10-02 19:00:00 | GC | Futures | 1784.3 | 1785.8 | 1783.3 | 1784.0 | 1365.0 |
| 2016-10-02 20:00:00 | GC | Futures | 1783.9 | 1789.1 | 1783.7 | 1788.2 | 3047.0 |
| 2016-10-02 21:00:00 | GC | Futures | 1788.2 | 1789.4 | 1786.2 | 1788.3 | 2977.0 |
| 2016-10-02 22:00:00 | GC | Futures | 1788.3 | 1788.9 | 1783.2 | 1784.7 | 3064.0 |
| 2016-10-02 23:00:00 | GC | Futures | 1784.5 | 1784.8 | 1783.2 | 1783.9 | 1622.0 |
| 2016-10-02 18:00:00 | ZN | Futures | 128.704318 | 128.704318 | 128.62769 | 128.643016 | 2777.0 |
| 2016-10-02 19:00:00 | ZN | Futures | 128.643016 | 128.688993 | 128.612365 | 128.658342 | 4985.0 |
| 2016-10-02 20:00:00 | ZN | Futures | 128.643016 | 128.688993 | 128.612365 | 128.658342 | 7769.0 |
| 2016-10-02 21:00:00 | ZN | Futures | 128.658342 | 128.673667 | 128.62769 | 128.643016 | 6319.0 |
| 2016-10-02 22:00:00 | ZN | Futures | 128.62769 | 128.643016 | 128.581714 | 128.612365 | 6575.0 |
| 2016-10-02 23:00:00 | ZN | Futures | 128.612365 | 128.62769 | 128.597039 | 128.597039 | 2338.0 |
> showing 36 of 289 rows — these rows as CSV