PREVIEW / futures_1hour / 2014-02-09
file: by_date/futures_1hour/2014/2014-02-09.parquet size: 14 KB rows: 273
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-02-09 18:00:00 | ES | Futures | 1855.06 | 1856.61 | 1853.51 | 1853.77 | 8835.0 |
| 2014-02-09 19:00:00 | ES | Futures | 1853.77 | 1854.8 | 1852.99 | 1853.77 | 7022.0 |
| 2014-02-09 20:00:00 | ES | Futures | 1853.77 | 1855.06 | 1852.99 | 1854.54 | 6121.0 |
| 2014-02-09 21:00:00 | ES | Futures | 1854.8 | 1855.06 | 1852.99 | 1853.25 | 3164.0 |
| 2014-02-09 22:00:00 | ES | Futures | 1853.25 | 1854.29 | 1852.99 | 1854.03 | 3004.0 |
| 2014-02-09 23:00:00 | ES | Futures | 1854.03 | 1854.29 | 1852.99 | 1854.29 | 2450.0 |
| 2014-02-09 18:00:00 | NQ | Futures | 4139.64 | 4143.71 | 4137.61 | 4138.19 | 1605.0 |
| 2014-02-09 19:00:00 | NQ | Futures | 4138.19 | 4139.93 | 4134.99 | 4137.32 | 907.0 |
| 2014-02-09 20:00:00 | NQ | Futures | 4137.32 | 4139.64 | 4134.99 | 4139.06 | 915.0 |
| 2014-02-09 21:00:00 | NQ | Futures | 4139.06 | 4139.06 | 4136.44 | 4137.32 | 405.0 |
| 2014-02-09 22:00:00 | NQ | Futures | 4137.9 | 4138.48 | 4136.44 | 4137.9 | 225.0 |
| 2014-02-09 23:00:00 | NQ | Futures | 4137.61 | 4139.35 | 4137.03 | 4139.35 | 181.0 |
| 2014-02-09 18:00:00 | YM | Futures | 16148.0 | 16158.3 | 16136.8 | 16138.8 | 1132.0 |
| 2014-02-09 19:00:00 | YM | Futures | 16138.8 | 16145.0 | 16129.6 | 16137.8 | 683.0 |
| 2014-02-09 20:00:00 | YM | Futures | 16136.8 | 16146.0 | 16131.6 | 16141.9 | 1251.0 |
| 2014-02-09 21:00:00 | YM | Futures | 16141.9 | 16145.0 | 16131.6 | 16132.7 | 626.0 |
| 2014-02-09 22:00:00 | YM | Futures | 16133.7 | 16138.8 | 16131.6 | 16136.8 | 277.0 |
| 2014-02-09 23:00:00 | YM | Futures | 16135.7 | 16140.9 | 16131.6 | 16139.8 | 232.0 |
| 2014-02-09 18:00:00 | CL | Futures | 157.17 | 157.82 | 157.16 | 157.55 | 1787.0 |
| 2014-02-09 19:00:00 | CL | Futures | 157.53 | 157.63 | 157.42 | 157.46 | 907.0 |
| 2014-02-09 20:00:00 | CL | Futures | 157.46 | 157.47 | 157.09 | 157.19 | 1471.0 |
| 2014-02-09 21:00:00 | CL | Futures | 157.19 | 157.24 | 156.91 | 156.98 | 922.0 |
| 2014-02-09 22:00:00 | CL | Futures | 156.97 | 157.0 | 156.81 | 156.89 | 775.0 |
| 2014-02-09 23:00:00 | CL | Futures | 156.87 | 156.95 | 156.73 | 156.75 | 440.0 |
| 2014-02-09 18:00:00 | GC | Futures | 1733.1 | 1739.1 | 1732.8 | 1735.4 | 1985.0 |
| 2014-02-09 19:00:00 | GC | Futures | 1735.4 | 1736.1 | 1732.9 | 1733.5 | 1887.0 |
| 2014-02-09 20:00:00 | GC | Futures | 1733.3 | 1737.3 | 1732.1 | 1737.0 | 2664.0 |
| 2014-02-09 21:00:00 | GC | Futures | 1737.0 | 1738.5 | 1736.8 | 1738.0 | 1934.0 |
| 2014-02-09 22:00:00 | GC | Futures | 1738.0 | 1739.4 | 1737.3 | 1737.4 | 1560.0 |
| 2014-02-09 23:00:00 | GC | Futures | 1737.7 | 1737.9 | 1736.9 | 1736.9 | 467.0 |
| 2014-02-09 18:00:00 | ZN | Futures | 116.373865 | 116.431655 | 116.34497 | 116.417207 | 7931.0 |
| 2014-02-09 19:00:00 | ZN | Futures | 116.417207 | 116.489444 | 116.417207 | 116.474997 | 10026.0 |
| 2014-02-09 20:00:00 | ZN | Futures | 116.474997 | 116.489444 | 116.417207 | 116.431655 | 4414.0 |
| 2014-02-09 21:00:00 | ZN | Futures | 116.431655 | 116.489444 | 116.431655 | 116.474997 | 3431.0 |
| 2014-02-09 22:00:00 | ZN | Futures | 116.474997 | 116.503892 | 116.446102 | 116.46055 | 4558.0 |
| 2014-02-09 23:00:00 | ZN | Futures | 116.46055 | 116.474997 | 116.446102 | 116.474997 | 1622.0 |
> showing 36 of 273 rows — these rows as CSV