PREVIEW / futures_1hour / 2017-02-26
file: by_date/futures_1hour/2017/2017-02-26.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-02-26 18:00:00 | ES | Futures | 2577.94 | 2584.21 | 2577.67 | 2582.85 | 11473.0 |
| 2017-02-26 19:00:00 | ES | Futures | 2582.85 | 2583.39 | 2579.58 | 2579.85 | 9132.0 |
| 2017-02-26 20:00:00 | ES | Futures | 2579.85 | 2580.94 | 2578.48 | 2580.94 | 7198.0 |
| 2017-02-26 21:00:00 | ES | Futures | 2580.94 | 2583.12 | 2580.67 | 2582.85 | 4299.0 |
| 2017-02-26 22:00:00 | ES | Futures | 2582.58 | 2583.39 | 2582.3 | 2583.39 | 3534.0 |
| 2017-02-26 23:00:00 | ES | Futures | 2583.39 | 2585.85 | 2583.12 | 2584.49 | 8234.0 |
| 2017-02-26 18:00:00 | NQ | Futures | 6372.11 | 6385.24 | 6368.83 | 6382.85 | 2010.0 |
| 2017-02-26 19:00:00 | NQ | Futures | 6383.15 | 6383.45 | 6374.8 | 6375.99 | 2202.0 |
| 2017-02-26 20:00:00 | NQ | Futures | 6376.29 | 6376.88 | 6371.22 | 6373.9 | 2173.0 |
| 2017-02-26 21:00:00 | NQ | Futures | 6374.2 | 6381.96 | 6373.3 | 6381.36 | 1196.0 |
| 2017-02-26 22:00:00 | NQ | Futures | 6381.36 | 6383.15 | 6379.57 | 6381.96 | 786.0 |
| 2017-02-26 23:00:00 | NQ | Futures | 6381.96 | 6387.03 | 6381.96 | 6383.75 | 1753.0 |
| 2017-02-26 18:00:00 | YM | Futures | 22538.2 | 22587.0 | 22506.7 | 22567.5 | 2609.0 |
| 2017-02-26 19:00:00 | YM | Futures | 22567.5 | 22575.1 | 22541.4 | 22543.6 | 2061.0 |
| 2017-02-26 20:00:00 | YM | Futures | 22543.6 | 22552.3 | 22532.8 | 22551.2 | 1691.0 |
| 2017-02-26 21:00:00 | YM | Futures | 22552.3 | 22570.7 | 22550.1 | 22569.6 | 1026.0 |
| 2017-02-26 22:00:00 | YM | Futures | 22568.6 | 22577.2 | 22564.2 | 22571.8 | 946.0 |
| 2017-02-26 23:00:00 | YM | Futures | 22571.8 | 22590.3 | 22571.8 | 22580.5 | 1751.0 |
| 2017-02-26 18:00:00 | CL | Futures | 50.76 | 50.8 | 50.73 | 50.73 | 1764.0 |
| 2017-02-26 19:00:00 | CL | Futures | 50.73 | 50.76 | 50.71 | 50.73 | 1092.0 |
| 2017-02-26 20:00:00 | CL | Futures | 50.73 | 50.74 | 50.68 | 50.72 | 1307.0 |
| 2017-02-26 21:00:00 | CL | Futures | 50.73 | 50.86 | 50.72 | 50.84 | 2281.0 |
| 2017-02-26 22:00:00 | CL | Futures | 50.84 | 50.93 | 50.82 | 50.88 | 2832.0 |
| 2017-02-26 23:00:00 | CL | Futures | 50.87 | 50.98 | 50.87 | 50.96 | 3285.0 |
| 2017-02-26 18:00:00 | GC | Futures | 1695.4 | 1695.4 | 1690.9 | 1692.5 | 3739.0 |
| 2017-02-26 19:00:00 | GC | Futures | 1692.4 | 1694.7 | 1692.3 | 1692.9 | 3311.0 |
| 2017-02-26 20:00:00 | GC | Futures | 1692.9 | 1696.9 | 1691.9 | 1695.0 | 6570.0 |
| 2017-02-26 21:00:00 | GC | Futures | 1695.0 | 1695.4 | 1692.8 | 1693.5 | 4551.0 |
| 2017-02-26 22:00:00 | GC | Futures | 1693.4 | 1694.2 | 1692.4 | 1693.6 | 3303.0 |
| 2017-02-26 23:00:00 | GC | Futures | 1693.5 | 1694.0 | 1692.7 | 1693.1 | 2201.0 |
| 2017-02-26 18:00:00 | ZN | Futures | 124.004539 | 124.004539 | 123.881167 | 123.91201 | 12837.0 |
| 2017-02-26 19:00:00 | ZN | Futures | 123.91201 | 123.958275 | 123.881167 | 123.896589 | 16846.0 |
| 2017-02-26 20:00:00 | ZN | Futures | 123.896589 | 123.942853 | 123.881167 | 123.896589 | 6533.0 |
| 2017-02-26 21:00:00 | ZN | Futures | 123.896589 | 123.91201 | 123.850324 | 123.850324 | 7666.0 |
| 2017-02-26 22:00:00 | ZN | Futures | 123.850324 | 123.881167 | 123.834902 | 123.865745 | 7391.0 |
| 2017-02-26 23:00:00 | ZN | Futures | 123.865745 | 123.865745 | 123.819481 | 123.834902 | 13485.0 |
> showing 36 of 295 rows — these rows as CSV