PREVIEW / futures_1hour / 2013-06-02
file: by_date/futures_1hour/2013/2013-06-02.parquet size: 14 KB rows: 265
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-02 18:00:00 | ES | Futures | 1678.93 | 1681.0 | 1675.84 | 1680.22 | 25990.0 |
| 2013-06-02 19:00:00 | ES | Futures | 1680.22 | 1682.28 | 1679.71 | 1680.22 | 9925.0 |
| 2013-06-02 20:00:00 | ES | Futures | 1680.48 | 1680.48 | 1677.65 | 1678.68 | 12760.0 |
| 2013-06-02 21:00:00 | ES | Futures | 1678.42 | 1684.34 | 1678.16 | 1682.03 | 19088.0 |
| 2013-06-02 22:00:00 | ES | Futures | 1682.28 | 1684.6 | 1681.77 | 1683.06 | 6650.0 |
| 2013-06-02 23:00:00 | ES | Futures | 1683.06 | 1683.31 | 1681.51 | 1682.54 | 4337.0 |
| 2013-06-02 18:00:00 | NQ | Futures | 3477.85 | 3482.52 | 3473.77 | 3482.22 | 1532.0 |
| 2013-06-02 19:00:00 | NQ | Futures | 3481.93 | 3484.27 | 3479.89 | 3480.18 | 669.0 |
| 2013-06-02 20:00:00 | NQ | Futures | 3480.18 | 3481.64 | 3476.68 | 3480.47 | 1166.0 |
| 2013-06-02 21:00:00 | NQ | Futures | 3480.18 | 3487.77 | 3479.6 | 3485.72 | 2633.0 |
| 2013-06-02 22:00:00 | NQ | Futures | 3485.72 | 3488.35 | 3483.97 | 3486.89 | 755.0 |
| 2013-06-02 23:00:00 | NQ | Futures | 3487.18 | 3487.77 | 3483.97 | 3484.56 | 554.0 |
| 2013-06-02 18:00:00 | YM | Futures | 15283.5 | 15298.6 | 15264.3 | 15294.6 | 1890.0 |
| 2013-06-02 19:00:00 | YM | Futures | 15294.6 | 15309.8 | 15292.6 | 15293.6 | 1048.0 |
| 2013-06-02 20:00:00 | YM | Futures | 15293.6 | 15296.6 | 15275.4 | 15285.5 | 1966.0 |
| 2013-06-02 21:00:00 | YM | Futures | 15285.5 | 15330.0 | 15285.5 | 15307.7 | 3036.0 |
| 2013-06-02 22:00:00 | YM | Futures | 15307.7 | 15327.9 | 15304.7 | 15318.9 | 1250.0 |
| 2013-06-02 23:00:00 | YM | Futures | 15319.9 | 15322.9 | 15308.7 | 15312.8 | 642.0 |
| 2013-06-02 18:00:00 | CL | Futures | 143.72 | 143.83 | 142.98 | 143.14 | 2204.0 |
| 2013-06-02 19:00:00 | CL | Futures | 143.15 | 143.28 | 143.08 | 143.23 | 716.0 |
| 2013-06-02 20:00:00 | CL | Futures | 143.26 | 143.7 | 143.23 | 143.64 | 1710.0 |
| 2013-06-02 21:00:00 | CL | Futures | 143.64 | 143.91 | 143.59 | 143.62 | 1501.0 |
| 2013-06-02 22:00:00 | CL | Futures | 143.64 | 143.86 | 143.56 | 143.7 | 937.0 |
| 2013-06-02 23:00:00 | CL | Futures | 143.7 | 144.08 | 143.7 | 143.98 | 1230.0 |
| 2013-06-02 18:00:00 | GC | Futures | 1904.7 | 1908.0 | 1904.0 | 1905.7 | 1008.0 |
| 2013-06-02 19:00:00 | GC | Futures | 1905.1 | 1912.5 | 1905.0 | 1911.8 | 1620.0 |
| 2013-06-02 20:00:00 | GC | Futures | 1911.8 | 1915.6 | 1908.8 | 1915.0 | 2318.0 |
| 2013-06-02 21:00:00 | GC | Futures | 1915.0 | 1916.9 | 1910.1 | 1911.8 | 2985.0 |
| 2013-06-02 22:00:00 | GC | Futures | 1912.0 | 1913.2 | 1909.7 | 1912.0 | 1641.0 |
| 2013-06-02 23:00:00 | GC | Futures | 1912.3 | 1913.6 | 1910.9 | 1912.1 | 1163.0 |
| 2013-06-02 18:00:00 | ZN | Futures | 117.083326 | 117.209705 | 117.069284 | 117.11141 | 1045.0 |
| 2013-06-02 19:00:00 | ZN | Futures | 117.097368 | 117.097368 | 117.013115 | 117.069284 | 1016.0 |
| 2013-06-02 20:00:00 | ZN | Futures | 117.083326 | 117.223747 | 117.083326 | 117.195663 | 555.0 |
| 2013-06-02 21:00:00 | ZN | Futures | 117.167579 | 117.181621 | 117.11141 | 117.167579 | 1684.0 |
| 2013-06-02 22:00:00 | ZN | Futures | 117.167579 | 117.167579 | 117.097368 | 117.097368 | 306.0 |
| 2013-06-02 23:00:00 | ZN | Futures | 117.097368 | 117.11141 | 117.069284 | 117.083326 | 159.0 |
> showing 36 of 265 rows — these rows as CSV