PREVIEW / futures_1hour / 2016-12-18
file: by_date/futures_1hour/2016/2016-12-18.parquet size: 15 KB rows: 297
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 |
|---|---|---|---|---|---|---|---|
| 2016-12-18 18:00:00 | ES | Futures | 2461.47 | 2465.29 | 2461.19 | 2464.47 | 6917.0 |
| 2016-12-18 19:00:00 | ES | Futures | 2464.19 | 2465.29 | 2463.38 | 2465.01 | 3647.0 |
| 2016-12-18 20:00:00 | ES | Futures | 2465.01 | 2465.83 | 2463.65 | 2464.47 | 3704.0 |
| 2016-12-18 21:00:00 | ES | Futures | 2464.19 | 2465.01 | 2463.65 | 2463.92 | 1980.0 |
| 2016-12-18 22:00:00 | ES | Futures | 2463.65 | 2465.01 | 2463.65 | 2464.19 | 1597.0 |
| 2016-12-18 23:00:00 | ES | Futures | 2464.19 | 2465.56 | 2463.38 | 2464.47 | 2244.0 |
| 2016-12-18 18:00:00 | NQ | Futures | 5865.86 | 5875.71 | 5862.88 | 5873.32 | 1484.0 |
| 2016-12-18 19:00:00 | NQ | Futures | 5873.02 | 5875.41 | 5872.72 | 5873.92 | 802.0 |
| 2016-12-18 20:00:00 | NQ | Futures | 5874.51 | 5876.01 | 5870.34 | 5871.53 | 783.0 |
| 2016-12-18 21:00:00 | NQ | Futures | 5871.53 | 5874.22 | 5870.04 | 5870.64 | 356.0 |
| 2016-12-18 22:00:00 | NQ | Futures | 5870.64 | 5873.02 | 5869.74 | 5870.64 | 289.0 |
| 2016-12-18 23:00:00 | NQ | Futures | 5870.34 | 5874.51 | 5869.14 | 5871.53 | 350.0 |
| 2016-12-18 18:00:00 | YM | Futures | 21478.4 | 21507.7 | 21474.0 | 21501.1 | 1700.0 |
| 2016-12-18 19:00:00 | YM | Futures | 21501.1 | 21506.6 | 21499.0 | 21505.5 | 892.0 |
| 2016-12-18 20:00:00 | YM | Futures | 21505.5 | 21514.2 | 21502.2 | 21507.7 | 1331.0 |
| 2016-12-18 21:00:00 | YM | Futures | 21506.6 | 21510.9 | 21502.2 | 21503.3 | 444.0 |
| 2016-12-18 22:00:00 | YM | Futures | 21502.2 | 21508.7 | 21501.1 | 21503.3 | 373.0 |
| 2016-12-18 23:00:00 | YM | Futures | 21504.4 | 21513.1 | 21500.1 | 21506.6 | 594.0 |
| 2016-12-18 18:00:00 | CL | Futures | 51.23 | 51.31 | 50.99 | 51.05 | 4649.0 |
| 2016-12-18 19:00:00 | CL | Futures | 51.04 | 51.23 | 51.0 | 51.2 | 3719.0 |
| 2016-12-18 20:00:00 | CL | Futures | 51.21 | 51.49 | 51.12 | 51.48 | 7209.0 |
| 2016-12-18 21:00:00 | CL | Futures | 51.48 | 51.56 | 51.32 | 51.32 | 6396.0 |
| 2016-12-18 22:00:00 | CL | Futures | 51.33 | 51.45 | 51.3 | 51.35 | 2972.0 |
| 2016-12-18 23:00:00 | CL | Futures | 51.35 | 51.4 | 51.34 | 51.35 | 1555.0 |
| 2016-12-18 18:00:00 | GC | Futures | 1533.4 | 1536.8 | 1532.6 | 1535.5 | 1830.0 |
| 2016-12-18 19:00:00 | GC | Futures | 1535.6 | 1538.4 | 1535.2 | 1537.5 | 1957.0 |
| 2016-12-18 20:00:00 | GC | Futures | 1537.2 | 1540.7 | 1537.0 | 1539.2 | 4452.0 |
| 2016-12-18 21:00:00 | GC | Futures | 1539.2 | 1539.7 | 1537.8 | 1538.8 | 2342.0 |
| 2016-12-18 22:00:00 | GC | Futures | 1538.8 | 1539.2 | 1538.0 | 1538.8 | 1252.0 |
| 2016-12-18 23:00:00 | GC | Futures | 1538.8 | 1540.7 | 1538.6 | 1540.3 | 1631.0 |
| 2016-12-18 18:00:00 | ZN | Futures | 121.228664 | 121.336614 | 121.213242 | 121.336614 | 5828.0 |
| 2016-12-18 19:00:00 | ZN | Futures | 121.336614 | 121.3983 | 121.321193 | 121.352036 | 13017.0 |
| 2016-12-18 20:00:00 | ZN | Futures | 121.352036 | 121.444565 | 121.259507 | 121.305771 | 16616.0 |
| 2016-12-18 21:00:00 | ZN | Futures | 121.321193 | 121.352036 | 121.29035 | 121.321193 | 4545.0 |
| 2016-12-18 22:00:00 | ZN | Futures | 121.321193 | 121.321193 | 121.259507 | 121.259507 | 5913.0 |
| 2016-12-18 23:00:00 | ZN | Futures | 121.274928 | 121.321193 | 121.244085 | 121.305771 | 8219.0 |
> showing 36 of 297 rows — these rows as CSV