PREVIEW / futures_1hour / 2017-10-08
file: by_date/futures_1hour/2017/2017-10-08.parquet size: 14 KB rows: 283
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-10-08 18:00:00 | ES | Futures | 2782.91 | 2786.74 | 2782.91 | 2785.65 | 5954.0 |
| 2017-10-08 19:00:00 | ES | Futures | 2785.65 | 2786.47 | 2785.65 | 2786.19 | 2121.0 |
| 2017-10-08 20:00:00 | ES | Futures | 2786.47 | 2788.11 | 2786.19 | 2787.84 | 5555.0 |
| 2017-10-08 21:00:00 | ES | Futures | 2787.84 | 2788.93 | 2787.84 | 2788.66 | 6951.0 |
| 2017-10-08 22:00:00 | ES | Futures | 2788.66 | 2789.48 | 2787.84 | 2788.11 | 5290.0 |
| 2017-10-08 23:00:00 | ES | Futures | 2788.38 | 2788.66 | 2787.84 | 2787.84 | 1868.0 |
| 2017-10-08 18:00:00 | NQ | Futures | 7212.35 | 7221.27 | 7208.78 | 7217.11 | 1725.0 |
| 2017-10-08 19:00:00 | NQ | Futures | 7217.11 | 7220.68 | 7217.11 | 7220.38 | 629.0 |
| 2017-10-08 20:00:00 | NQ | Futures | 7220.38 | 7227.81 | 7219.78 | 7227.81 | 1753.0 |
| 2017-10-08 21:00:00 | NQ | Futures | 7227.52 | 7228.71 | 7226.03 | 7227.81 | 1338.0 |
| 2017-10-08 22:00:00 | NQ | Futures | 7228.11 | 7231.09 | 7225.14 | 7227.81 | 1589.0 |
| 2017-10-08 23:00:00 | NQ | Futures | 7227.52 | 7229.3 | 7226.33 | 7227.52 | 443.0 |
| 2017-10-08 18:00:00 | YM | Futures | 24664.3 | 24704.6 | 24664.3 | 24693.7 | 1226.0 |
| 2017-10-08 19:00:00 | YM | Futures | 24694.8 | 24701.3 | 24689.3 | 24699.1 | 463.0 |
| 2017-10-08 20:00:00 | YM | Futures | 24699.1 | 24710.0 | 24699.1 | 24710.0 | 792.0 |
| 2017-10-08 21:00:00 | YM | Futures | 24708.9 | 24713.3 | 24707.8 | 24712.2 | 975.0 |
| 2017-10-08 22:00:00 | YM | Futures | 24712.2 | 24718.7 | 24708.9 | 24712.2 | 1212.0 |
| 2017-10-08 23:00:00 | YM | Futures | 24711.1 | 24713.3 | 24708.9 | 24712.2 | 520.0 |
| 2017-10-08 18:00:00 | CL | Futures | 44.09 | 44.28 | 44.08 | 44.24 | 4083.0 |
| 2017-10-08 19:00:00 | CL | Futures | 44.25 | 44.26 | 44.19 | 44.25 | 1528.0 |
| 2017-10-08 20:00:00 | CL | Futures | 44.25 | 44.32 | 44.25 | 44.3 | 2558.0 |
| 2017-10-08 21:00:00 | CL | Futures | 44.29 | 44.33 | 44.25 | 44.27 | 3316.0 |
| 2017-10-08 22:00:00 | CL | Futures | 44.26 | 44.28 | 44.22 | 44.24 | 2696.0 |
| 2017-10-08 23:00:00 | CL | Futures | 44.23 | 44.25 | 44.2 | 44.24 | 2063.0 |
| 2017-10-08 18:00:00 | GC | Futures | 1703.3 | 1705.5 | 1702.1 | 1703.7 | 3849.0 |
| 2017-10-08 19:00:00 | GC | Futures | 1703.7 | 1704.9 | 1703.5 | 1703.8 | 1472.0 |
| 2017-10-08 20:00:00 | GC | Futures | 1703.8 | 1703.8 | 1702.1 | 1703.0 | 3365.0 |
| 2017-10-08 21:00:00 | GC | Futures | 1703.0 | 1709.0 | 1703.0 | 1708.9 | 12904.0 |
| 2017-10-08 22:00:00 | GC | Futures | 1708.9 | 1715.0 | 1708.7 | 1713.4 | 15888.0 |
| 2017-10-08 23:00:00 | GC | Futures | 1713.3 | 1713.9 | 1711.4 | 1711.5 | 3754.0 |
| 2017-10-08 18:00:00 | ZN | Futures | 124.531896 | 124.594139 | 124.469654 | 124.547457 | 8364.0 |
| 2017-10-08 19:00:00 | ZN | Futures | 124.547457 | 124.563018 | 124.531896 | 124.547457 | 1885.0 |
| 2017-10-08 20:00:00 | ZN | Futures | 124.547457 | 124.547457 | 124.485214 | 124.516336 | 5206.0 |
| 2017-10-08 21:00:00 | ZN | Futures | 124.500775 | 124.547457 | 124.500775 | 124.516336 | 5584.0 |
| 2017-10-08 22:00:00 | ZN | Futures | 124.516336 | 124.531896 | 124.516336 | 124.516336 | 420.0 |
| 2017-10-08 23:00:00 | ZN | Futures | 124.531896 | 124.531896 | 124.500775 | 124.516336 | 986.0 |
> showing 36 of 283 rows — these rows as CSV