PREVIEW / futures_1hour / 2019-08-11
file: by_date/futures_1hour/2019/2019-08-11.parquet size: 17 KB rows: 361
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-08-11 18:00:00 | ES | Futures | 3160.48 | 3168.87 | 3160.48 | 3162.65 | 8665.0 |
| 2019-08-11 19:00:00 | ES | Futures | 3162.65 | 3164.0 | 3154.26 | 3155.34 | 8352.0 |
| 2019-08-11 20:00:00 | ES | Futures | 3155.61 | 3162.38 | 3154.53 | 3161.29 | 16610.0 |
| 2019-08-11 21:00:00 | ES | Futures | 3161.29 | 3169.41 | 3159.4 | 3165.9 | 14725.0 |
| 2019-08-11 22:00:00 | ES | Futures | 3166.17 | 3170.23 | 3165.35 | 3168.87 | 8122.0 |
| 2019-08-11 23:00:00 | ES | Futures | 3168.87 | 3170.5 | 3166.71 | 3166.98 | 3891.0 |
| 2019-08-11 18:00:00 | NQ | Futures | 8883.58 | 8912.89 | 8883.29 | 8894.61 | 5223.0 |
| 2019-08-11 19:00:00 | NQ | Futures | 8894.32 | 8898.09 | 8865.01 | 8869.07 | 5364.0 |
| 2019-08-11 20:00:00 | NQ | Futures | 8869.36 | 8892.87 | 8865.59 | 8889.67 | 7056.0 |
| 2019-08-11 21:00:00 | NQ | Futures | 8889.96 | 8918.4 | 8882.71 | 8908.24 | 9564.0 |
| 2019-08-11 22:00:00 | NQ | Futures | 8908.82 | 8926.23 | 8905.92 | 8923.04 | 6072.0 |
| 2019-08-11 23:00:00 | NQ | Futures | 8923.62 | 8931.16 | 8917.24 | 8918.4 | 3333.0 |
| 2019-08-11 18:00:00 | YM | Futures | 28561.0 | 28626.3 | 28559.9 | 28570.8 | 2293.0 |
| 2019-08-11 19:00:00 | YM | Futures | 28567.5 | 28582.8 | 28489.2 | 28506.6 | 2424.0 |
| 2019-08-11 20:00:00 | YM | Futures | 28506.6 | 28562.1 | 28495.8 | 28554.5 | 3503.0 |
| 2019-08-11 21:00:00 | YM | Futures | 28555.6 | 28624.1 | 28542.5 | 28596.9 | 3768.0 |
| 2019-08-11 22:00:00 | YM | Futures | 28596.9 | 28631.7 | 28587.1 | 28612.1 | 2092.0 |
| 2019-08-11 23:00:00 | YM | Futures | 28614.3 | 28630.6 | 28593.6 | 28600.2 | 1061.0 |
| 2019-08-11 18:00:00 | CL | Futures | 48.22 | 48.33 | 48.14 | 48.22 | 2971.0 |
| 2019-08-11 19:00:00 | CL | Futures | 48.23 | 48.26 | 48.13 | 48.15 | 2356.0 |
| 2019-08-11 20:00:00 | CL | Futures | 48.16 | 48.24 | 48.11 | 48.2 | 4469.0 |
| 2019-08-11 21:00:00 | CL | Futures | 48.2 | 48.23 | 48.04 | 48.14 | 9756.0 |
| 2019-08-11 22:00:00 | CL | Futures | 48.14 | 48.31 | 48.14 | 48.27 | 6951.0 |
| 2019-08-11 23:00:00 | CL | Futures | 48.27 | 48.28 | 48.2 | 48.22 | 2490.0 |
| 2019-08-11 18:00:00 | GC | Futures | 1911.9 | 1912.6 | 1906.9 | 1910.3 | 3400.0 |
| 2019-08-11 19:00:00 | GC | Futures | 1910.2 | 1916.6 | 1909.9 | 1915.7 | 3966.0 |
| 2019-08-11 20:00:00 | GC | Futures | 1915.6 | 1916.1 | 1911.6 | 1912.7 | 5159.0 |
| 2019-08-11 21:00:00 | GC | Futures | 1912.7 | 1912.8 | 1908.5 | 1911.3 | 10496.0 |
| 2019-08-11 22:00:00 | GC | Futures | 1911.2 | 1911.3 | 1909.4 | 1910.0 | 3876.0 |
| 2019-08-11 23:00:00 | GC | Futures | 1909.9 | 1911.2 | 1909.5 | 1910.7 | 2646.0 |
| 2019-08-11 18:00:00 | ZN | Futures | 130.462189 | 130.509349 | 130.399308 | 130.493629 | 5756.0 |
| 2019-08-11 19:00:00 | ZN | Futures | 130.509349 | 130.587951 | 130.477909 | 130.587951 | 6839.0 |
| 2019-08-11 20:00:00 | ZN | Futures | 130.57223 | 130.603671 | 130.54079 | 130.54079 | 9242.0 |
| 2019-08-11 21:00:00 | ZN | Futures | 130.54079 | 130.54079 | 130.446468 | 130.493629 | 12870.0 |
| 2019-08-11 22:00:00 | ZN | Futures | 130.493629 | 130.52507 | 130.493629 | 130.509349 | 6663.0 |
| 2019-08-11 23:00:00 | ZN | Futures | 130.493629 | 130.52507 | 130.477909 | 130.52507 | 2763.0 |
> showing 36 of 361 rows — these rows as CSV