PREVIEW / futures_1hour / 2017-12-03
file: by_date/futures_1hour/2017/2017-12-03.parquet size: 15 KB rows: 299
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-12-03 18:00:00 | ES | Futures | 2904.65 | 2914.22 | 2904.1 | 2909.57 | 37328.0 |
| 2017-12-03 19:00:00 | ES | Futures | 2909.3 | 2911.76 | 2908.75 | 2911.48 | 15902.0 |
| 2017-12-03 20:00:00 | ES | Futures | 2911.48 | 2912.03 | 2909.3 | 2910.39 | 11866.0 |
| 2017-12-03 21:00:00 | ES | Futures | 2910.66 | 2911.48 | 2910.12 | 2910.66 | 7668.0 |
| 2017-12-03 22:00:00 | ES | Futures | 2910.66 | 2912.3 | 2910.12 | 2912.3 | 5628.0 |
| 2017-12-03 23:00:00 | ES | Futures | 2912.3 | 2913.13 | 2910.94 | 2911.21 | 3693.0 |
| 2017-12-03 18:00:00 | NQ | Futures | 7579.36 | 7604.05 | 7576.39 | 7590.66 | 7451.0 |
| 2017-12-03 19:00:00 | NQ | Futures | 7590.66 | 7595.12 | 7586.8 | 7593.64 | 2816.0 |
| 2017-12-03 20:00:00 | NQ | Futures | 7593.93 | 7595.12 | 7578.47 | 7587.09 | 3584.0 |
| 2017-12-03 21:00:00 | NQ | Futures | 7587.39 | 7589.18 | 7577.87 | 7585.61 | 2111.0 |
| 2017-12-03 22:00:00 | NQ | Futures | 7585.31 | 7591.55 | 7585.01 | 7590.66 | 1195.0 |
| 2017-12-03 23:00:00 | NQ | Futures | 7590.66 | 7591.85 | 7587.69 | 7590.07 | 1204.0 |
| 2017-12-03 18:00:00 | YM | Futures | 26480.8 | 26608.0 | 26478.6 | 26564.5 | 7041.0 |
| 2017-12-03 19:00:00 | YM | Futures | 26564.5 | 26591.7 | 26556.9 | 26590.6 | 3260.0 |
| 2017-12-03 20:00:00 | YM | Futures | 26590.6 | 26602.6 | 26576.5 | 26601.5 | 2918.0 |
| 2017-12-03 21:00:00 | YM | Futures | 26602.6 | 26615.6 | 26595.0 | 26604.8 | 2124.0 |
| 2017-12-03 22:00:00 | YM | Futures | 26605.8 | 26614.5 | 26595.0 | 26610.2 | 1457.0 |
| 2017-12-03 23:00:00 | YM | Futures | 26610.2 | 26624.3 | 26610.2 | 26615.6 | 806.0 |
| 2017-12-03 18:00:00 | CL | Futures | 51.72 | 51.74 | 51.58 | 51.61 | 2524.0 |
| 2017-12-03 19:00:00 | CL | Futures | 51.62 | 51.65 | 51.58 | 51.58 | 1994.0 |
| 2017-12-03 20:00:00 | CL | Futures | 51.58 | 51.61 | 51.31 | 51.42 | 7436.0 |
| 2017-12-03 21:00:00 | CL | Futures | 51.42 | 51.5 | 51.37 | 51.42 | 6173.0 |
| 2017-12-03 22:00:00 | CL | Futures | 51.41 | 51.44 | 51.36 | 51.37 | 2719.0 |
| 2017-12-03 23:00:00 | CL | Futures | 51.36 | 51.37 | 51.28 | 51.36 | 3199.0 |
| 2017-12-03 18:00:00 | GC | Futures | 1696.7 | 1697.7 | 1693.6 | 1695.5 | 9021.0 |
| 2017-12-03 19:00:00 | GC | Futures | 1695.4 | 1698.0 | 1695.4 | 1697.7 | 4597.0 |
| 2017-12-03 20:00:00 | GC | Futures | 1697.9 | 1698.0 | 1696.4 | 1697.5 | 5215.0 |
| 2017-12-03 21:00:00 | GC | Futures | 1697.5 | 1697.6 | 1695.6 | 1696.1 | 4078.0 |
| 2017-12-03 22:00:00 | GC | Futures | 1696.1 | 1696.7 | 1695.4 | 1696.0 | 2648.0 |
| 2017-12-03 23:00:00 | GC | Futures | 1696.0 | 1696.5 | 1695.6 | 1696.1 | 1942.0 |
| 2017-12-03 18:00:00 | ZN | Futures | 123.691621 | 123.831667 | 123.691621 | 123.722743 | 2284.0 |
| 2017-12-03 19:00:00 | ZN | Futures | 123.722743 | 123.831667 | 123.722743 | 123.800546 | 510.0 |
| 2017-12-03 20:00:00 | ZN | Futures | 123.816106 | 123.831667 | 123.816106 | 123.831667 | 253.0 |
| 2017-12-03 21:00:00 | ZN | Futures | 123.831667 | 123.862788 | 123.816106 | 123.816106 | 356.0 |
| 2017-12-03 22:00:00 | ZN | Futures | 123.831667 | 123.831667 | 123.816106 | 123.816106 | 200.0 |
| 2017-12-03 23:00:00 | ZN | Futures | 123.816106 | 123.816106 | 123.784985 | 123.784985 | 113.0 |
> showing 36 of 299 rows — these rows as CSV