PREVIEW / futures_1hour / 2016-12-11
file: by_date/futures_1hour/2016/2016-12-11.parquet size: 14 KB rows: 280
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-11 18:00:00 | ES | Futures | 2460.41 | 2470.75 | 2459.59 | 2465.31 | 14449.0 |
| 2016-12-11 19:00:00 | ES | Futures | 2465.31 | 2466.12 | 2463.95 | 2464.76 | 3322.0 |
| 2016-12-11 20:00:00 | ES | Futures | 2464.49 | 2464.49 | 2460.68 | 2461.23 | 3234.0 |
| 2016-12-11 21:00:00 | ES | Futures | 2460.95 | 2461.23 | 2457.42 | 2457.42 | 5329.0 |
| 2016-12-11 22:00:00 | ES | Futures | 2457.69 | 2459.05 | 2456.06 | 2458.51 | 4318.0 |
| 2016-12-11 23:00:00 | ES | Futures | 2458.78 | 2460.95 | 2457.96 | 2460.95 | 2880.0 |
| 2016-12-11 18:00:00 | NQ | Futures | 5846.17 | 5867.65 | 5839.91 | 5849.15 | 1233.0 |
| 2016-12-11 19:00:00 | NQ | Futures | 5849.15 | 5851.84 | 5845.28 | 5847.66 | 499.0 |
| 2016-12-11 20:00:00 | NQ | Futures | 5847.66 | 5847.66 | 5837.22 | 5837.22 | 379.0 |
| 2016-12-11 21:00:00 | NQ | Futures | 5838.12 | 5838.12 | 5820.22 | 5821.41 | 1257.0 |
| 2016-12-11 22:00:00 | NQ | Futures | 5821.11 | 5821.11 | 5810.67 | 5817.23 | 897.0 |
| 2016-12-11 23:00:00 | NQ | Futures | 5817.83 | 5823.8 | 5817.23 | 5823.8 | 277.0 |
| 2016-12-11 18:00:00 | YM | Futures | 21378.6 | 21488.1 | 21377.5 | 21448.0 | 5162.0 |
| 2016-12-11 19:00:00 | YM | Futures | 21446.9 | 21455.6 | 21436.1 | 21443.7 | 1447.0 |
| 2016-12-11 20:00:00 | YM | Futures | 21443.7 | 21444.7 | 21413.3 | 21415.4 | 2138.0 |
| 2016-12-11 21:00:00 | YM | Futures | 21415.4 | 21415.4 | 21386.2 | 21386.2 | 2162.0 |
| 2016-12-11 22:00:00 | YM | Futures | 21385.1 | 21397.0 | 21371.0 | 21394.8 | 1822.0 |
| 2016-12-11 23:00:00 | YM | Futures | 21395.9 | 21413.3 | 21391.6 | 21413.3 | 1151.0 |
| 2016-12-11 18:00:00 | CL | Futures | 51.49 | 53.38 | 51.47 | 52.79 | 46970.0 |
| 2016-12-11 19:00:00 | CL | Futures | 52.8 | 52.91 | 52.54 | 52.64 | 18028.0 |
| 2016-12-11 20:00:00 | CL | Futures | 52.65 | 52.82 | 52.59 | 52.72 | 7591.0 |
| 2016-12-11 21:00:00 | CL | Futures | 52.72 | 52.88 | 52.7 | 52.83 | 6613.0 |
| 2016-12-11 22:00:00 | CL | Futures | 52.83 | 52.86 | 52.8 | 52.83 | 3004.0 |
| 2016-12-11 23:00:00 | CL | Futures | 52.83 | 52.86 | 52.79 | 52.82 | 2544.0 |
| 2016-12-11 18:00:00 | GC | Futures | 1567.6 | 1568.3 | 1563.5 | 1566.0 | 2848.0 |
| 2016-12-11 19:00:00 | GC | Futures | 1565.8 | 1566.0 | 1560.4 | 1560.7 | 7232.0 |
| 2016-12-11 20:00:00 | GC | Futures | 1560.8 | 1563.9 | 1560.4 | 1563.3 | 5258.0 |
| 2016-12-11 21:00:00 | GC | Futures | 1563.1 | 1568.1 | 1563.1 | 1567.3 | 6131.0 |
| 2016-12-11 22:00:00 | GC | Futures | 1567.3 | 1568.1 | 1566.1 | 1566.1 | 2424.0 |
| 2016-12-11 23:00:00 | GC | Futures | 1566.1 | 1566.2 | 1563.1 | 1563.7 | 2573.0 |
| 2016-12-11 18:00:00 | ZN | Futures | 122.277328 | 122.277328 | 122.123112 | 122.184799 | 25513.0 |
| 2016-12-11 19:00:00 | ZN | Futures | 122.184799 | 122.215642 | 122.138534 | 122.169377 | 20996.0 |
| 2016-12-11 20:00:00 | ZN | Futures | 122.169377 | 122.215642 | 122.153955 | 122.169377 | 10293.0 |
| 2016-12-11 21:00:00 | ZN | Futures | 122.184799 | 122.231063 | 122.169377 | 122.215642 | 11478.0 |
| 2016-12-11 22:00:00 | ZN | Futures | 122.231063 | 122.261906 | 122.169377 | 122.20022 | 10468.0 |
| 2016-12-11 23:00:00 | ZN | Futures | 122.20022 | 122.20022 | 122.138534 | 122.184799 | 11649.0 |
> showing 36 of 280 rows — these rows as CSV