PREVIEW / futures_1hour / 2014-10-05
file: by_date/futures_1hour/2014/2014-10-05.parquet size: 14 KB rows: 279
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-05 18:00:00 | ES | Futures | 2054.87 | 2058.28 | 2053.82 | 2057.49 | 7126.0 |
| 2014-10-05 19:00:00 | ES | Futures | 2057.49 | 2058.54 | 2056.71 | 2057.23 | 2851.0 |
| 2014-10-05 20:00:00 | ES | Futures | 2057.23 | 2058.02 | 2056.44 | 2057.75 | 5704.0 |
| 2014-10-05 21:00:00 | ES | Futures | 2057.49 | 2059.85 | 2056.97 | 2059.06 | 5848.0 |
| 2014-10-05 22:00:00 | ES | Futures | 2059.06 | 2059.85 | 2058.8 | 2059.06 | 4150.0 |
| 2014-10-05 23:00:00 | ES | Futures | 2059.06 | 2059.85 | 2058.28 | 2059.59 | 2440.0 |
| 2014-10-05 18:00:00 | NQ | Futures | 4708.89 | 4717.1 | 4703.91 | 4716.81 | 1496.0 |
| 2014-10-05 19:00:00 | NQ | Futures | 4716.81 | 4717.98 | 4714.17 | 4716.51 | 511.0 |
| 2014-10-05 20:00:00 | NQ | Futures | 4716.51 | 4717.69 | 4714.17 | 4716.81 | 601.0 |
| 2014-10-05 21:00:00 | NQ | Futures | 4716.81 | 4722.67 | 4715.93 | 4721.49 | 894.0 |
| 2014-10-05 22:00:00 | NQ | Futures | 4721.49 | 4722.37 | 4719.44 | 4719.74 | 603.0 |
| 2014-10-05 23:00:00 | NQ | Futures | 4719.44 | 4721.79 | 4717.1 | 4720.62 | 813.0 |
| 2014-10-05 18:00:00 | YM | Futures | 17595.9 | 17626.1 | 17568.9 | 17621.9 | 1126.0 |
| 2014-10-05 19:00:00 | YM | Futures | 17620.9 | 17627.1 | 17612.5 | 17617.7 | 381.0 |
| 2014-10-05 20:00:00 | YM | Futures | 17616.7 | 17621.9 | 17611.5 | 17620.9 | 509.0 |
| 2014-10-05 21:00:00 | YM | Futures | 17620.9 | 17641.7 | 17618.8 | 17637.5 | 984.0 |
| 2014-10-05 22:00:00 | YM | Futures | 17635.4 | 17641.7 | 17634.4 | 17636.5 | 610.0 |
| 2014-10-05 23:00:00 | YM | Futures | 17636.5 | 17643.7 | 17631.3 | 17641.7 | 361.0 |
| 2014-10-05 18:00:00 | CL | Futures | 149.55 | 149.55 | 148.91 | 149.03 | 1088.0 |
| 2014-10-05 19:00:00 | CL | Futures | 149.06 | 149.31 | 149.03 | 149.28 | 456.0 |
| 2014-10-05 20:00:00 | CL | Futures | 149.28 | 149.48 | 149.13 | 149.4 | 539.0 |
| 2014-10-05 21:00:00 | CL | Futures | 149.38 | 149.76 | 149.35 | 149.58 | 1153.0 |
| 2014-10-05 22:00:00 | CL | Futures | 149.6 | 149.63 | 149.36 | 149.4 | 591.0 |
| 2014-10-05 23:00:00 | CL | Futures | 149.4 | 149.5 | 149.23 | 149.41 | 622.0 |
| 2014-10-05 18:00:00 | GC | Futures | 1631.8 | 1631.9 | 1619.9 | 1623.6 | 5506.0 |
| 2014-10-05 19:00:00 | GC | Futures | 1623.7 | 1628.2 | 1623.7 | 1624.4 | 2022.0 |
| 2014-10-05 20:00:00 | GC | Futures | 1624.5 | 1625.5 | 1620.0 | 1622.9 | 4030.0 |
| 2014-10-05 21:00:00 | GC | Futures | 1622.9 | 1626.7 | 1622.9 | 1625.5 | 1872.0 |
| 2014-10-05 22:00:00 | GC | Futures | 1625.4 | 1628.8 | 1625.1 | 1628.4 | 1580.0 |
| 2014-10-05 23:00:00 | GC | Futures | 1628.5 | 1629.7 | 1626.7 | 1627.1 | 1409.0 |
| 2014-10-05 18:00:00 | ZN | Futures | 118.467978 | 118.482764 | 118.423619 | 118.438405 | 4971.0 |
| 2014-10-05 19:00:00 | ZN | Futures | 118.438405 | 118.453191 | 118.408832 | 118.453191 | 2979.0 |
| 2014-10-05 20:00:00 | ZN | Futures | 118.467978 | 118.49755 | 118.438405 | 118.438405 | 4785.0 |
| 2014-10-05 21:00:00 | ZN | Futures | 118.453191 | 118.482764 | 118.394046 | 118.423619 | 8004.0 |
| 2014-10-05 22:00:00 | ZN | Futures | 118.423619 | 118.467978 | 118.408832 | 118.467978 | 3511.0 |
| 2014-10-05 23:00:00 | ZN | Futures | 118.453191 | 118.467978 | 118.438405 | 118.438405 | 1954.0 |
> showing 36 of 279 rows — these rows as CSV