PREVIEW / futures_1hour / 2017-11-26
file: by_date/futures_1hour/2017/2017-11-26.parquet size: 14 KB rows: 283
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-26 18:00:00 | ES | Futures | 2846.1 | 2848.84 | 2845.83 | 2847.47 | 9800.0 |
| 2017-11-26 19:00:00 | ES | Futures | 2847.47 | 2847.47 | 2845.56 | 2846.38 | 5962.0 |
| 2017-11-26 20:00:00 | ES | Futures | 2846.38 | 2846.65 | 2842.55 | 2843.37 | 12912.0 |
| 2017-11-26 21:00:00 | ES | Futures | 2843.37 | 2843.37 | 2841.18 | 2842.27 | 9566.0 |
| 2017-11-26 22:00:00 | ES | Futures | 2842.27 | 2843.64 | 2842.0 | 2843.37 | 2434.0 |
| 2017-11-26 23:00:00 | ES | Futures | 2843.37 | 2844.19 | 2842.55 | 2842.55 | 2576.0 |
| 2017-11-26 18:00:00 | NQ | Futures | 7630.81 | 7637.06 | 7627.54 | 7633.79 | 1983.0 |
| 2017-11-26 19:00:00 | NQ | Futures | 7633.79 | 7634.09 | 7629.33 | 7630.22 | 1307.0 |
| 2017-11-26 20:00:00 | NQ | Futures | 7630.22 | 7631.41 | 7617.13 | 7619.21 | 4076.0 |
| 2017-11-26 21:00:00 | NQ | Futures | 7619.21 | 7620.4 | 7614.75 | 7617.73 | 1960.0 |
| 2017-11-26 22:00:00 | NQ | Futures | 7617.43 | 7623.97 | 7617.43 | 7621.59 | 917.0 |
| 2017-11-26 23:00:00 | NQ | Futures | 7621.59 | 7625.16 | 7618.62 | 7619.21 | 872.0 |
| 2017-11-26 18:00:00 | YM | Futures | 25576.9 | 25606.3 | 25574.7 | 25594.3 | 1168.0 |
| 2017-11-26 19:00:00 | YM | Futures | 25593.2 | 25594.3 | 25576.9 | 25581.2 | 900.0 |
| 2017-11-26 20:00:00 | YM | Futures | 25581.2 | 25586.7 | 25541.0 | 25550.8 | 2415.0 |
| 2017-11-26 21:00:00 | YM | Futures | 25550.8 | 25551.9 | 25533.4 | 25541.0 | 1484.0 |
| 2017-11-26 22:00:00 | YM | Futures | 25542.1 | 25556.2 | 25541.0 | 25550.8 | 673.0 |
| 2017-11-26 23:00:00 | YM | Futures | 25550.8 | 25557.3 | 25543.2 | 25543.2 | 556.0 |
| 2017-11-26 18:00:00 | CL | Futures | 52.28 | 52.31 | 52.18 | 52.22 | 3231.0 |
| 2017-11-26 19:00:00 | CL | Futures | 52.21 | 52.25 | 52.14 | 52.15 | 3173.0 |
| 2017-11-26 20:00:00 | CL | Futures | 52.15 | 52.17 | 52.0 | 52.05 | 10059.0 |
| 2017-11-26 21:00:00 | CL | Futures | 52.05 | 52.07 | 51.99 | 52.0 | 4799.0 |
| 2017-11-26 22:00:00 | CL | Futures | 52.0 | 52.07 | 52.0 | 52.06 | 2250.0 |
| 2017-11-26 23:00:00 | CL | Futures | 52.06 | 52.08 | 52.03 | 52.06 | 3392.0 |
| 2017-11-26 18:00:00 | GC | Futures | 1715.8 | 1717.7 | 1714.6 | 1714.7 | 469.0 |
| 2017-11-26 19:00:00 | GC | Futures | 1714.9 | 1715.9 | 1714.1 | 1714.5 | 869.0 |
| 2017-11-26 20:00:00 | GC | Futures | 1714.6 | 1717.5 | 1714.1 | 1717.1 | 2438.0 |
| 2017-11-26 21:00:00 | GC | Futures | 1717.3 | 1718.7 | 1716.6 | 1717.7 | 2435.0 |
| 2017-11-26 22:00:00 | GC | Futures | 1717.8 | 1718.3 | 1717.1 | 1718.2 | 1024.0 |
| 2017-11-26 23:00:00 | GC | Futures | 1718.2 | 1719.3 | 1717.7 | 1718.7 | 1301.0 |
| 2017-11-26 18:00:00 | ZN | Futures | 124.469654 | 124.469654 | 124.391851 | 124.422972 | 7259.0 |
| 2017-11-26 19:00:00 | ZN | Futures | 124.422972 | 124.438533 | 124.360729 | 124.391851 | 13917.0 |
| 2017-11-26 20:00:00 | ZN | Futures | 124.37629 | 124.438533 | 124.360729 | 124.407411 | 11943.0 |
| 2017-11-26 21:00:00 | ZN | Futures | 124.407411 | 124.422972 | 124.37629 | 124.422972 | 13589.0 |
| 2017-11-26 22:00:00 | ZN | Futures | 124.422972 | 124.422972 | 124.37629 | 124.407411 | 5180.0 |
| 2017-11-26 23:00:00 | ZN | Futures | 124.407411 | 124.422972 | 124.37629 | 124.422972 | 6451.0 |
> showing 36 of 283 rows — these rows as CSV