PREVIEW / futures_1hour / 2019-02-03
file: by_date/futures_1hour/2019/2019-02-03.parquet size: 16 KB rows: 342
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-02-03 18:00:00 | ES | Futures | 2932.3 | 2937.73 | 2930.94 | 2936.37 | 6730.0 |
| 2019-02-03 19:00:00 | ES | Futures | 2936.1 | 2942.35 | 2936.1 | 2941.53 | 7927.0 |
| 2019-02-03 20:00:00 | ES | Futures | 2941.8 | 2943.16 | 2937.46 | 2940.99 | 7481.0 |
| 2019-02-03 21:00:00 | ES | Futures | 2940.99 | 2942.62 | 2939.9 | 2940.45 | 3540.0 |
| 2019-02-03 22:00:00 | ES | Futures | 2940.45 | 2940.99 | 2938.54 | 2939.63 | 2954.0 |
| 2019-02-03 23:00:00 | ES | Futures | 2939.63 | 2939.9 | 2937.73 | 2938.82 | 3126.0 |
| 2019-02-03 18:00:00 | NQ | Futures | 8022.06 | 8041.93 | 8015.63 | 8038.42 | 2877.0 |
| 2019-02-03 19:00:00 | NQ | Futures | 8038.13 | 8058.58 | 8038.13 | 8055.66 | 3794.0 |
| 2019-02-03 20:00:00 | NQ | Futures | 8055.66 | 8060.92 | 8042.51 | 8053.91 | 3201.0 |
| 2019-02-03 21:00:00 | NQ | Futures | 8053.32 | 8059.75 | 8050.4 | 8053.03 | 1813.0 |
| 2019-02-03 22:00:00 | NQ | Futures | 8053.03 | 8054.78 | 8044.56 | 8048.06 | 1443.0 |
| 2019-02-03 23:00:00 | NQ | Futures | 8048.36 | 8050.11 | 8041.93 | 8046.31 | 1455.0 |
| 2019-02-03 18:00:00 | YM | Futures | 27076.4 | 27139.4 | 27076.4 | 27125.3 | 1453.0 |
| 2019-02-03 19:00:00 | YM | Futures | 27126.4 | 27180.7 | 27125.3 | 27169.8 | 1991.0 |
| 2019-02-03 20:00:00 | YM | Futures | 27169.8 | 27188.3 | 27135.1 | 27169.8 | 2172.0 |
| 2019-02-03 21:00:00 | YM | Futures | 27170.9 | 27185.0 | 27159.0 | 27166.6 | 1010.0 |
| 2019-02-03 22:00:00 | YM | Futures | 27166.6 | 27172.0 | 27150.3 | 27157.9 | 870.0 |
| 2019-02-03 23:00:00 | YM | Futures | 27156.8 | 27166.6 | 27147.0 | 27152.4 | 895.0 |
| 2019-02-03 18:00:00 | CL | Futures | 50.21 | 50.34 | 50.04 | 50.13 | 5578.0 |
| 2019-02-03 19:00:00 | CL | Futures | 50.13 | 50.26 | 50.1 | 50.12 | 4041.0 |
| 2019-02-03 20:00:00 | CL | Futures | 50.13 | 50.14 | 49.9 | 50.1 | 6873.0 |
| 2019-02-03 21:00:00 | CL | Futures | 50.1 | 50.33 | 50.09 | 50.25 | 7116.0 |
| 2019-02-03 22:00:00 | CL | Futures | 50.25 | 50.28 | 50.01 | 50.09 | 6298.0 |
| 2019-02-03 23:00:00 | CL | Futures | 50.1 | 50.21 | 50.06 | 50.14 | 5570.0 |
| 2019-02-03 18:00:00 | GC | Futures | 1705.5 | 1706.8 | 1703.6 | 1704.5 | 1954.0 |
| 2019-02-03 19:00:00 | GC | Futures | 1704.3 | 1704.8 | 1702.0 | 1702.3 | 3041.0 |
| 2019-02-03 20:00:00 | GC | Futures | 1702.3 | 1702.5 | 1701.1 | 1701.5 | 3140.0 |
| 2019-02-03 21:00:00 | GC | Futures | 1701.5 | 1702.3 | 1701.1 | 1701.8 | 1655.0 |
| 2019-02-03 22:00:00 | GC | Futures | 1701.9 | 1701.9 | 1699.2 | 1699.9 | 4355.0 |
| 2019-02-03 23:00:00 | GC | Futures | 1699.9 | 1700.2 | 1697.8 | 1698.1 | 3493.0 |
| 2019-02-03 18:00:00 | ZN | Futures | 122.887651 | 122.903391 | 122.808947 | 122.840428 | 14654.0 |
| 2019-02-03 19:00:00 | ZN | Futures | 122.840428 | 122.887651 | 122.777466 | 122.856169 | 18142.0 |
| 2019-02-03 20:00:00 | ZN | Futures | 122.856169 | 122.887651 | 122.840428 | 122.87191 | 9071.0 |
| 2019-02-03 21:00:00 | ZN | Futures | 122.87191 | 122.887651 | 122.856169 | 122.87191 | 6257.0 |
| 2019-02-03 22:00:00 | ZN | Futures | 122.87191 | 122.87191 | 122.840428 | 122.87191 | 5850.0 |
| 2019-02-03 23:00:00 | ZN | Futures | 122.87191 | 122.87191 | 122.808947 | 122.840428 | 11089.0 |
> showing 36 of 342 rows — these rows as CSV