PREVIEW / futures_1hour / 2017-11-19
file: by_date/futures_1hour/2017/2017-11-19.parquet size: 15 KB rows: 295
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-19 18:00:00 | ES | Futures | 2818.75 | 2821.76 | 2816.01 | 2819.02 | 12553.0 |
| 2017-11-19 19:00:00 | ES | Futures | 2819.02 | 2819.84 | 2817.11 | 2818.2 | 8202.0 |
| 2017-11-19 20:00:00 | ES | Futures | 2818.2 | 2819.84 | 2810.81 | 2812.73 | 17700.0 |
| 2017-11-19 21:00:00 | ES | Futures | 2812.73 | 2813.55 | 2810.81 | 2811.91 | 12174.0 |
| 2017-11-19 22:00:00 | ES | Futures | 2812.18 | 2812.73 | 2809.72 | 2811.91 | 10023.0 |
| 2017-11-19 23:00:00 | ES | Futures | 2811.91 | 2813.28 | 2811.36 | 2812.73 | 2496.0 |
| 2017-11-19 18:00:00 | NQ | Futures | 7509.17 | 7518.09 | 7501.44 | 7510.66 | 2969.0 |
| 2017-11-19 19:00:00 | NQ | Futures | 7510.66 | 7513.33 | 7504.41 | 7508.28 | 1925.0 |
| 2017-11-19 20:00:00 | NQ | Futures | 7508.28 | 7514.23 | 7489.24 | 7493.41 | 3951.0 |
| 2017-11-19 21:00:00 | NQ | Futures | 7493.7 | 7495.19 | 7484.48 | 7490.73 | 3554.0 |
| 2017-11-19 22:00:00 | NQ | Futures | 7491.03 | 7494.3 | 7485.38 | 7491.92 | 1746.0 |
| 2017-11-19 23:00:00 | NQ | Futures | 7492.22 | 7494.89 | 7489.54 | 7493.7 | 694.0 |
| 2017-11-19 18:00:00 | YM | Futures | 25362.6 | 25380.0 | 25324.6 | 25351.7 | 2334.0 |
| 2017-11-19 19:00:00 | YM | Futures | 25350.7 | 25363.7 | 25335.4 | 25348.5 | 2021.0 |
| 2017-11-19 20:00:00 | YM | Futures | 25348.5 | 25362.6 | 25282.1 | 25301.7 | 3540.0 |
| 2017-11-19 21:00:00 | YM | Futures | 25301.7 | 25309.3 | 25280.0 | 25295.2 | 2780.0 |
| 2017-11-19 22:00:00 | YM | Futures | 25295.2 | 25301.7 | 25278.9 | 25296.3 | 1496.0 |
| 2017-11-19 23:00:00 | YM | Futures | 25296.3 | 25303.9 | 25288.7 | 25300.6 | 477.0 |
| 2017-11-19 18:00:00 | CL | Futures | 50.37 | 50.37 | 50.25 | 50.31 | 2883.0 |
| 2017-11-19 19:00:00 | CL | Futures | 50.3 | 50.33 | 50.26 | 50.3 | 2093.0 |
| 2017-11-19 20:00:00 | CL | Futures | 50.3 | 50.44 | 50.27 | 50.35 | 5198.0 |
| 2017-11-19 21:00:00 | CL | Futures | 50.35 | 50.41 | 50.27 | 50.31 | 4283.0 |
| 2017-11-19 22:00:00 | CL | Futures | 50.32 | 50.35 | 50.29 | 50.34 | 2885.0 |
| 2017-11-19 23:00:00 | CL | Futures | 50.34 | 50.34 | 50.31 | 50.33 | 965.0 |
| 2017-11-19 18:00:00 | GC | Futures | 1723.9 | 1725.3 | 1721.4 | 1723.5 | 5743.0 |
| 2017-11-19 19:00:00 | GC | Futures | 1723.5 | 1724.5 | 1721.9 | 1723.7 | 5551.0 |
| 2017-11-19 20:00:00 | GC | Futures | 1723.7 | 1723.8 | 1720.5 | 1721.8 | 10744.0 |
| 2017-11-19 21:00:00 | GC | Futures | 1721.8 | 1722.2 | 1720.3 | 1721.0 | 7694.0 |
| 2017-11-19 22:00:00 | GC | Futures | 1721.0 | 1721.4 | 1720.3 | 1721.0 | 4450.0 |
| 2017-11-19 23:00:00 | GC | Futures | 1720.9 | 1722.1 | 1720.9 | 1721.5 | 3031.0 |
| 2017-11-19 18:00:00 | ZN | Futures | 124.454093 | 124.578578 | 124.438533 | 124.500775 | 17541.0 |
| 2017-11-19 19:00:00 | ZN | Futures | 124.500775 | 124.531896 | 124.485214 | 124.516336 | 11851.0 |
| 2017-11-19 20:00:00 | ZN | Futures | 124.531896 | 124.578578 | 124.500775 | 124.563018 | 15657.0 |
| 2017-11-19 21:00:00 | ZN | Futures | 124.547457 | 124.62526 | 124.547457 | 124.594139 | 21249.0 |
| 2017-11-19 22:00:00 | ZN | Futures | 124.594139 | 124.62526 | 124.594139 | 124.6097 | 10902.0 |
| 2017-11-19 23:00:00 | ZN | Futures | 124.6097 | 124.62526 | 124.594139 | 124.594139 | 2425.0 |
> showing 36 of 295 rows — these rows as CSV