PREVIEW / futures_1hour / 2014-09-21
file: by_date/futures_1hour/2014/2014-09-21.parquet size: 15 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 |
|---|---|---|---|---|---|---|---|
| 2014-09-21 18:00:00 | ES | Futures | 2097.83 | 2098.88 | 2096.0 | 2098.36 | 6480.0 |
| 2014-09-21 19:00:00 | ES | Futures | 2098.62 | 2098.88 | 2097.57 | 2098.62 | 1612.0 |
| 2014-09-21 20:00:00 | ES | Futures | 2098.62 | 2098.88 | 2096.79 | 2097.05 | 3350.0 |
| 2014-09-21 21:00:00 | ES | Futures | 2097.31 | 2097.31 | 2091.55 | 2093.38 | 13193.0 |
| 2014-09-21 22:00:00 | ES | Futures | 2093.38 | 2093.64 | 2088.93 | 2089.71 | 17356.0 |
| 2014-09-21 23:00:00 | ES | Futures | 2089.71 | 2089.71 | 2087.09 | 2087.62 | 9304.0 |
| 2014-09-21 18:00:00 | NQ | Futures | 4795.62 | 4795.92 | 4788.89 | 4794.45 | 1073.0 |
| 2014-09-21 19:00:00 | NQ | Futures | 4794.75 | 4795.33 | 4792.11 | 4795.33 | 236.0 |
| 2014-09-21 20:00:00 | NQ | Futures | 4795.04 | 4795.92 | 4792.4 | 4792.69 | 720.0 |
| 2014-09-21 21:00:00 | NQ | Futures | 4792.4 | 4792.99 | 4780.39 | 4783.03 | 2092.0 |
| 2014-09-21 22:00:00 | NQ | Futures | 4783.32 | 4783.32 | 4772.77 | 4775.11 | 2456.0 |
| 2014-09-21 23:00:00 | NQ | Futures | 4775.11 | 4775.41 | 4768.96 | 4770.13 | 1817.0 |
| 2014-09-21 18:00:00 | YM | Futures | 17883.9 | 17892.2 | 17871.4 | 17888.1 | 963.0 |
| 2014-09-21 19:00:00 | YM | Futures | 17890.2 | 17894.3 | 17883.9 | 17892.2 | 327.0 |
| 2014-09-21 20:00:00 | YM | Futures | 17891.2 | 17893.3 | 17880.8 | 17882.9 | 758.0 |
| 2014-09-21 21:00:00 | YM | Futures | 17881.8 | 17881.8 | 17841.3 | 17848.6 | 1940.0 |
| 2014-09-21 22:00:00 | YM | Futures | 17849.6 | 17850.7 | 17818.4 | 17821.5 | 2953.0 |
| 2014-09-21 23:00:00 | YM | Futures | 17821.5 | 17824.7 | 17800.7 | 17807.0 | 2591.0 |
| 2014-09-21 18:00:00 | CL | Futures | 152.74 | 152.83 | 152.44 | 152.64 | 611.0 |
| 2014-09-21 19:00:00 | CL | Futures | 152.61 | 152.68 | 152.53 | 152.53 | 284.0 |
| 2014-09-21 20:00:00 | CL | Futures | 152.53 | 152.54 | 152.34 | 152.51 | 402.0 |
| 2014-09-21 21:00:00 | CL | Futures | 152.51 | 152.56 | 152.16 | 152.31 | 1151.0 |
| 2014-09-21 22:00:00 | CL | Futures | 152.31 | 152.34 | 152.24 | 152.26 | 603.0 |
| 2014-09-21 23:00:00 | CL | Futures | 152.26 | 152.28 | 152.01 | 152.06 | 1047.0 |
| 2014-09-21 18:00:00 | GC | Futures | 1665.2 | 1666.0 | 1663.8 | 1663.8 | 1147.0 |
| 2014-09-21 19:00:00 | GC | Futures | 1664.0 | 1666.0 | 1663.7 | 1665.6 | 731.0 |
| 2014-09-21 20:00:00 | GC | Futures | 1665.5 | 1667.9 | 1665.1 | 1667.1 | 1714.0 |
| 2014-09-21 21:00:00 | GC | Futures | 1667.1 | 1667.2 | 1654.8 | 1659.9 | 13535.0 |
| 2014-09-21 22:00:00 | GC | Futures | 1660.0 | 1663.4 | 1659.9 | 1661.5 | 4695.0 |
| 2014-09-21 23:00:00 | GC | Futures | 1661.6 | 1663.1 | 1661.2 | 1661.5 | 1477.0 |
| 2014-09-21 18:00:00 | ZN | Futures | 117.37379 | 117.462508 | 117.37379 | 117.447722 | 4661.0 |
| 2014-09-21 19:00:00 | ZN | Futures | 117.462508 | 117.477294 | 117.432935 | 117.462508 | 3691.0 |
| 2014-09-21 20:00:00 | ZN | Futures | 117.462508 | 117.506867 | 117.447722 | 117.492081 | 6913.0 |
| 2014-09-21 21:00:00 | ZN | Futures | 117.492081 | 117.53644 | 117.462508 | 117.521653 | 11482.0 |
| 2014-09-21 22:00:00 | ZN | Futures | 117.53644 | 117.610371 | 117.521653 | 117.580799 | 16969.0 |
| 2014-09-21 23:00:00 | ZN | Futures | 117.580799 | 117.610371 | 117.53644 | 117.551226 | 8088.0 |
> showing 36 of 283 rows — these rows as CSV