PREVIEW / futures_1hour / 2016-12-04
file: by_date/futures_1hour/2016/2016-12-04.parquet size: 15 KB rows: 288
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-04 18:00:00 | ES | Futures | 2376.88 | 2378.51 | 2371.44 | 2376.07 | 29376.0 |
| 2016-12-04 19:00:00 | ES | Futures | 2376.34 | 2378.51 | 2375.25 | 2377.43 | 8392.0 |
| 2016-12-04 20:00:00 | ES | Futures | 2377.43 | 2381.78 | 2376.88 | 2380.96 | 14845.0 |
| 2016-12-04 21:00:00 | ES | Futures | 2380.96 | 2382.32 | 2379.06 | 2379.6 | 7478.0 |
| 2016-12-04 22:00:00 | ES | Futures | 2379.6 | 2379.87 | 2377.97 | 2378.51 | 4665.0 |
| 2016-12-04 23:00:00 | ES | Futures | 2378.24 | 2379.87 | 2378.24 | 2379.6 | 2505.0 |
| 2016-12-04 18:00:00 | NQ | Futures | 5631.37 | 5631.67 | 5610.49 | 5626.0 | 4979.0 |
| 2016-12-04 19:00:00 | NQ | Futures | 5625.7 | 5634.05 | 5622.42 | 5629.88 | 1885.0 |
| 2016-12-04 20:00:00 | NQ | Futures | 5629.88 | 5642.41 | 5628.09 | 5639.72 | 2971.0 |
| 2016-12-04 21:00:00 | NQ | Futures | 5639.43 | 5646.59 | 5637.04 | 5639.43 | 1527.0 |
| 2016-12-04 22:00:00 | NQ | Futures | 5640.02 | 5640.32 | 5635.55 | 5636.14 | 561.0 |
| 2016-12-04 23:00:00 | NQ | Futures | 5636.14 | 5640.92 | 5636.14 | 5640.62 | 397.0 |
| 2016-12-04 18:00:00 | YM | Futures | 20653.4 | 20678.2 | 20624.2 | 20663.1 | 5667.0 |
| 2016-12-04 19:00:00 | YM | Futures | 20665.3 | 20677.2 | 20654.5 | 20671.7 | 1719.0 |
| 2016-12-04 20:00:00 | YM | Futures | 20671.7 | 20698.8 | 20666.3 | 20688.0 | 3098.0 |
| 2016-12-04 21:00:00 | YM | Futures | 20688.0 | 20699.8 | 20675.0 | 20679.3 | 1334.0 |
| 2016-12-04 22:00:00 | YM | Futures | 20680.4 | 20683.6 | 20667.4 | 20667.4 | 868.0 |
| 2016-12-04 23:00:00 | YM | Futures | 20668.5 | 20679.3 | 20667.4 | 20678.2 | 698.0 |
| 2016-12-04 18:00:00 | CL | Futures | 50.4 | 50.57 | 50.09 | 50.33 | 7564.0 |
| 2016-12-04 19:00:00 | CL | Futures | 50.32 | 50.34 | 50.15 | 50.21 | 3542.0 |
| 2016-12-04 20:00:00 | CL | Futures | 50.21 | 50.21 | 49.99 | 50.1 | 5544.0 |
| 2016-12-04 21:00:00 | CL | Futures | 50.1 | 50.21 | 50.06 | 50.13 | 3800.0 |
| 2016-12-04 22:00:00 | CL | Futures | 50.14 | 50.2 | 50.1 | 50.14 | 2038.0 |
| 2016-12-04 23:00:00 | CL | Futures | 50.14 | 50.27 | 50.03 | 50.25 | 4343.0 |
| 2016-12-04 18:00:00 | GC | Futures | 1596.2 | 1606.5 | 1592.4 | 1595.8 | 13000.0 |
| 2016-12-04 19:00:00 | GC | Futures | 1595.7 | 1597.4 | 1592.4 | 1594.2 | 5801.0 |
| 2016-12-04 20:00:00 | GC | Futures | 1594.5 | 1594.6 | 1584.7 | 1585.7 | 10450.0 |
| 2016-12-04 21:00:00 | GC | Futures | 1585.7 | 1590.0 | 1583.9 | 1589.3 | 5736.0 |
| 2016-12-04 22:00:00 | GC | Futures | 1589.3 | 1592.4 | 1588.0 | 1590.9 | 3143.0 |
| 2016-12-04 23:00:00 | GC | Futures | 1590.9 | 1591.1 | 1588.4 | 1589.5 | 1630.0 |
| 2016-12-04 18:00:00 | ZN | Futures | 123.202431 | 123.355687 | 123.03385 | 123.095152 | 1560.0 |
| 2016-12-04 19:00:00 | ZN | Futures | 123.110478 | 123.217757 | 123.049175 | 123.079826 | 157.0 |
| 2016-12-04 20:00:00 | ZN | Futures | 123.03385 | 123.03385 | 122.92657 | 123.003198 | 128.0 |
| 2016-12-04 21:00:00 | ZN | Futures | 123.018524 | 123.141129 | 123.003198 | 123.125803 | 108.0 |
| 2016-12-04 22:00:00 | ZN | Futures | 123.125803 | 123.17178 | 123.095152 | 123.156454 | 72.0 |
| 2016-12-04 23:00:00 | ZN | Futures | 123.141129 | 123.17178 | 123.141129 | 123.156454 | 53.0 |
> showing 36 of 288 rows — these rows as CSV