PREVIEW / futures_1hour / 2016-06-12
file: by_date/futures_1hour/2016/2016-06-12.parquet size: 15 KB rows: 284
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-06-12 18:00:00 | ES | Futures | 2256.22 | 2260.27 | 2256.22 | 2258.65 | 5750.0 |
| 2016-06-12 19:00:00 | ES | Futures | 2258.65 | 2261.08 | 2258.11 | 2258.65 | 2686.0 |
| 2016-06-12 20:00:00 | ES | Futures | 2258.65 | 2258.92 | 2256.49 | 2256.49 | 3403.0 |
| 2016-06-12 21:00:00 | ES | Futures | 2256.76 | 2258.65 | 2254.87 | 2255.41 | 4398.0 |
| 2016-06-12 22:00:00 | ES | Futures | 2255.68 | 2257.03 | 2254.87 | 2254.87 | 3444.0 |
| 2016-06-12 23:00:00 | ES | Futures | 2255.14 | 2255.41 | 2254.06 | 2254.6 | 2065.0 |
| 2016-06-12 18:00:00 | NQ | Futures | 5306.44 | 5306.44 | 5297.22 | 5300.49 | 395.0 |
| 2016-06-12 19:00:00 | NQ | Futures | 5301.38 | 5307.93 | 5300.19 | 5301.68 | 239.0 |
| 2016-06-12 20:00:00 | NQ | Futures | 5301.09 | 5303.76 | 5298.41 | 5298.41 | 207.0 |
| 2016-06-12 21:00:00 | NQ | Futures | 5298.41 | 5301.68 | 5291.86 | 5293.95 | 302.0 |
| 2016-06-12 22:00:00 | NQ | Futures | 5294.54 | 5298.71 | 5293.65 | 5294.24 | 130.0 |
| 2016-06-12 23:00:00 | NQ | Futures | 5294.24 | 5295.73 | 5292.16 | 5293.05 | 83.0 |
| 2016-06-12 18:00:00 | YM | Futures | 19073.6 | 19100.5 | 19072.5 | 19086.5 | 1034.0 |
| 2016-06-12 19:00:00 | YM | Futures | 19086.5 | 19100.5 | 19084.3 | 19086.5 | 959.0 |
| 2016-06-12 20:00:00 | YM | Futures | 19086.5 | 19093.0 | 19076.8 | 19077.9 | 855.0 |
| 2016-06-12 21:00:00 | YM | Futures | 19076.8 | 19087.6 | 19058.5 | 19061.7 | 1829.0 |
| 2016-06-12 22:00:00 | YM | Futures | 19061.7 | 19072.5 | 19059.6 | 19059.6 | 1102.0 |
| 2016-06-12 23:00:00 | YM | Futures | 19059.6 | 19061.7 | 19052.1 | 19056.4 | 652.0 |
| 2016-06-12 18:00:00 | CL | Futures | 51.83 | 51.91 | 51.54 | 51.7 | 3141.0 |
| 2016-06-12 19:00:00 | CL | Futures | 51.7 | 51.71 | 51.58 | 51.63 | 1472.0 |
| 2016-06-12 20:00:00 | CL | Futures | 51.63 | 51.7 | 51.55 | 51.61 | 2436.0 |
| 2016-06-12 21:00:00 | CL | Futures | 51.59 | 51.59 | 51.15 | 51.31 | 8634.0 |
| 2016-06-12 22:00:00 | CL | Futures | 51.31 | 51.46 | 51.27 | 51.46 | 3594.0 |
| 2016-06-12 23:00:00 | CL | Futures | 51.45 | 51.56 | 51.41 | 51.44 | 3049.0 |
| 2016-06-12 18:00:00 | GC | Futures | 1739.6 | 1742.2 | 1737.8 | 1741.2 | 3238.0 |
| 2016-06-12 19:00:00 | GC | Futures | 1741.2 | 1743.6 | 1740.7 | 1742.6 | 2198.0 |
| 2016-06-12 20:00:00 | GC | Futures | 1742.5 | 1743.6 | 1740.3 | 1740.3 | 5078.0 |
| 2016-06-12 21:00:00 | GC | Futures | 1740.3 | 1741.9 | 1735.4 | 1738.2 | 15675.0 |
| 2016-06-12 22:00:00 | GC | Futures | 1738.4 | 1738.9 | 1736.7 | 1737.6 | 2776.0 |
| 2016-06-12 23:00:00 | GC | Futures | 1737.7 | 1739.3 | 1736.9 | 1738.5 | 3135.0 |
| 2016-06-12 18:00:00 | ZN | Futures | 128.173115 | 128.233976 | 128.127469 | 128.18833 | 8773.0 |
| 2016-06-12 19:00:00 | ZN | Futures | 128.173115 | 128.21876 | 128.127469 | 128.21876 | 8232.0 |
| 2016-06-12 20:00:00 | ZN | Futures | 128.21876 | 128.21876 | 128.157899 | 128.203545 | 12179.0 |
| 2016-06-12 21:00:00 | ZN | Futures | 128.203545 | 128.340482 | 128.203545 | 128.340482 | 20402.0 |
| 2016-06-12 22:00:00 | ZN | Futures | 128.340482 | 128.340482 | 128.264406 | 128.279621 | 6578.0 |
| 2016-06-12 23:00:00 | ZN | Futures | 128.264406 | 128.279621 | 128.249191 | 128.264406 | 7442.0 |
> showing 36 of 284 rows — these rows as CSV