PREVIEW / futures_1hour / 2018-12-09
file: by_date/futures_1hour/2018/2018-12-09.parquet size: 16 KB rows: 337
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-12-09 18:00:00 | ES | Futures | 2855.98 | 2861.15 | 2839.93 | 2844.83 | 38930.0 |
| 2018-12-09 19:00:00 | ES | Futures | 2844.83 | 2851.9 | 2840.21 | 2845.1 | 26507.0 |
| 2018-12-09 20:00:00 | ES | Futures | 2845.1 | 2852.17 | 2844.56 | 2850.0 | 16879.0 |
| 2018-12-09 21:00:00 | ES | Futures | 2849.73 | 2851.09 | 2840.75 | 2845.92 | 11382.0 |
| 2018-12-09 22:00:00 | ES | Futures | 2845.92 | 2848.37 | 2841.84 | 2846.19 | 6954.0 |
| 2018-12-09 23:00:00 | ES | Futures | 2846.19 | 2848.64 | 2844.83 | 2848.37 | 4175.0 |
| 2018-12-09 18:00:00 | NQ | Futures | 7739.09 | 7754.93 | 7693.92 | 7709.76 | 11056.0 |
| 2018-12-09 19:00:00 | NQ | Futures | 7710.35 | 7729.41 | 7693.92 | 7708.3 | 8405.0 |
| 2018-12-09 20:00:00 | NQ | Futures | 7708.3 | 7728.83 | 7705.36 | 7721.49 | 5849.0 |
| 2018-12-09 21:00:00 | NQ | Futures | 7721.49 | 7725.01 | 7689.52 | 7705.36 | 6584.0 |
| 2018-12-09 22:00:00 | NQ | Futures | 7704.48 | 7710.35 | 7694.22 | 7707.12 | 3465.0 |
| 2018-12-09 23:00:00 | NQ | Futures | 7707.42 | 7713.28 | 7702.43 | 7712.7 | 4013.0 |
| 2018-12-09 18:00:00 | YM | Futures | 26416.4 | 26484.8 | 26249.1 | 26294.7 | 6283.0 |
| 2018-12-09 19:00:00 | YM | Futures | 26295.8 | 26370.7 | 26264.3 | 26309.9 | 5226.0 |
| 2018-12-09 20:00:00 | YM | Futures | 26309.9 | 26381.6 | 26306.6 | 26363.1 | 3377.0 |
| 2018-12-09 21:00:00 | YM | Futures | 26361.0 | 26370.7 | 26280.6 | 26328.4 | 2579.0 |
| 2018-12-09 22:00:00 | YM | Futures | 26328.4 | 26353.4 | 26295.8 | 26337.1 | 1628.0 |
| 2018-12-09 23:00:00 | YM | Futures | 26336.0 | 26359.9 | 26321.8 | 26356.6 | 1171.0 |
| 2018-12-09 18:00:00 | CL | Futures | 47.7 | 48.21 | 47.7 | 48.04 | 7525.0 |
| 2018-12-09 19:00:00 | CL | Futures | 48.03 | 48.16 | 47.9 | 48.11 | 8113.0 |
| 2018-12-09 20:00:00 | CL | Futures | 48.1 | 48.35 | 48.1 | 48.3 | 11457.0 |
| 2018-12-09 21:00:00 | CL | Futures | 48.3 | 48.41 | 48.15 | 48.18 | 7017.0 |
| 2018-12-09 22:00:00 | CL | Futures | 48.19 | 48.32 | 48.05 | 48.18 | 6834.0 |
| 2018-12-09 23:00:00 | CL | Futures | 48.18 | 48.21 | 48.1 | 48.19 | 3588.0 |
| 2018-12-09 18:00:00 | GC | Futures | 1626.6 | 1627.9 | 1625.0 | 1625.4 | 6605.0 |
| 2018-12-09 19:00:00 | GC | Futures | 1625.3 | 1625.6 | 1624.1 | 1625.0 | 2664.0 |
| 2018-12-09 20:00:00 | GC | Futures | 1625.0 | 1626.9 | 1623.4 | 1625.9 | 7501.0 |
| 2018-12-09 21:00:00 | GC | Futures | 1625.9 | 1626.8 | 1625.8 | 1625.9 | 4232.0 |
| 2018-12-09 22:00:00 | GC | Futures | 1625.8 | 1625.9 | 1624.5 | 1625.3 | 3295.0 |
| 2018-12-09 23:00:00 | GC | Futures | 1625.1 | 1625.6 | 1624.6 | 1625.5 | 1721.0 |
| 2018-12-09 18:00:00 | ZN | Futures | 121.675617 | 121.833024 | 121.659876 | 121.770061 | 26471.0 |
| 2018-12-09 19:00:00 | ZN | Futures | 121.770061 | 121.770061 | 121.644135 | 121.675617 | 32224.0 |
| 2018-12-09 20:00:00 | ZN | Futures | 121.691357 | 121.75432 | 121.675617 | 121.722839 | 14596.0 |
| 2018-12-09 21:00:00 | ZN | Futures | 121.707098 | 121.770061 | 121.707098 | 121.738579 | 9036.0 |
| 2018-12-09 22:00:00 | ZN | Futures | 121.738579 | 121.770061 | 121.722839 | 121.75432 | 4041.0 |
| 2018-12-09 23:00:00 | ZN | Futures | 121.75432 | 121.75432 | 121.691357 | 121.691357 | 3427.0 |
> showing 36 of 337 rows — these rows as CSV