PREVIEW / futures_1hour / 2015-04-12
file: by_date/futures_1hour/2015/2015-04-12.parquet size: 14 KB rows: 274
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 |
|---|---|---|---|---|---|---|---|
| 2015-04-12 18:00:00 | ES | Futures | 2213.57 | 2216.21 | 2213.04 | 2215.16 | 4702.0 |
| 2015-04-12 19:00:00 | ES | Futures | 2215.16 | 2215.42 | 2214.36 | 2214.36 | 989.0 |
| 2015-04-12 20:00:00 | ES | Futures | 2214.36 | 2214.36 | 2212.51 | 2213.84 | 4890.0 |
| 2015-04-12 21:00:00 | ES | Futures | 2213.84 | 2214.89 | 2213.31 | 2214.1 | 2162.0 |
| 2015-04-12 22:00:00 | ES | Futures | 2213.84 | 2214.1 | 2211.46 | 2212.25 | 3480.0 |
| 2015-04-12 23:00:00 | ES | Futures | 2212.25 | 2213.31 | 2211.19 | 2211.46 | 2674.0 |
| 2015-04-12 18:00:00 | NQ | Futures | 5193.16 | 5197.28 | 5192.87 | 5195.22 | 726.0 |
| 2015-04-12 19:00:00 | NQ | Futures | 5195.22 | 5195.51 | 5194.34 | 5194.63 | 200.0 |
| 2015-04-12 20:00:00 | NQ | Futures | 5194.34 | 5194.34 | 5189.05 | 5193.46 | 653.0 |
| 2015-04-12 21:00:00 | NQ | Futures | 5193.16 | 5196.4 | 5192.28 | 5192.28 | 505.0 |
| 2015-04-12 22:00:00 | NQ | Futures | 5192.28 | 5192.57 | 5188.46 | 5189.93 | 435.0 |
| 2015-04-12 23:00:00 | NQ | Futures | 5190.22 | 5193.16 | 5189.05 | 5189.63 | 257.0 |
| 2015-04-12 18:00:00 | YM | Futures | 18843.5 | 18868.7 | 18842.4 | 18860.3 | 737.0 |
| 2015-04-12 19:00:00 | YM | Futures | 18861.3 | 18864.5 | 18852.9 | 18852.9 | 274.0 |
| 2015-04-12 20:00:00 | YM | Futures | 18851.9 | 18851.9 | 18836.1 | 18847.7 | 575.0 |
| 2015-04-12 21:00:00 | YM | Futures | 18848.7 | 18859.2 | 18844.5 | 18850.8 | 581.0 |
| 2015-04-12 22:00:00 | YM | Futures | 18849.8 | 18849.8 | 18828.8 | 18837.2 | 466.0 |
| 2015-04-12 23:00:00 | YM | Futures | 18837.2 | 18846.6 | 18829.9 | 18830.9 | 301.0 |
| 2015-04-12 18:00:00 | CL | Futures | 81.75 | 81.83 | 81.21 | 81.37 | 1522.0 |
| 2015-04-12 19:00:00 | CL | Futures | 81.37 | 81.42 | 81.28 | 81.29 | 370.0 |
| 2015-04-12 20:00:00 | CL | Futures | 81.31 | 81.67 | 81.26 | 81.59 | 1522.0 |
| 2015-04-12 21:00:00 | CL | Futures | 81.58 | 82.03 | 81.58 | 81.89 | 2141.0 |
| 2015-04-12 22:00:00 | CL | Futures | 81.89 | 81.94 | 81.59 | 81.81 | 1607.0 |
| 2015-04-12 23:00:00 | CL | Futures | 81.83 | 81.86 | 81.59 | 81.75 | 1214.0 |
| 2015-04-12 18:00:00 | GC | Futures | 1648.7 | 1649.0 | 1647.9 | 1648.6 | 461.0 |
| 2015-04-12 19:00:00 | GC | Futures | 1648.6 | 1650.6 | 1648.6 | 1649.7 | 412.0 |
| 2015-04-12 20:00:00 | GC | Futures | 1649.6 | 1650.2 | 1648.6 | 1648.9 | 825.0 |
| 2015-04-12 21:00:00 | GC | Futures | 1648.9 | 1651.6 | 1648.9 | 1649.8 | 2307.0 |
| 2015-04-12 22:00:00 | GC | Futures | 1649.7 | 1649.8 | 1646.7 | 1647.1 | 3289.0 |
| 2015-04-12 23:00:00 | GC | Futures | 1647.1 | 1647.2 | 1643.8 | 1643.8 | 3756.0 |
| 2015-04-12 18:00:00 | ZN | Futures | 123.141377 | 123.171243 | 123.11151 | 123.171243 | 2421.0 |
| 2015-04-12 19:00:00 | ZN | Futures | 123.171243 | 123.171243 | 123.141377 | 123.15631 | 758.0 |
| 2015-04-12 20:00:00 | ZN | Futures | 123.15631 | 123.186177 | 123.141377 | 123.15631 | 2068.0 |
| 2015-04-12 21:00:00 | ZN | Futures | 123.15631 | 123.186177 | 123.141377 | 123.15631 | 3525.0 |
| 2015-04-12 22:00:00 | ZN | Futures | 123.15631 | 123.230977 | 123.15631 | 123.216044 | 7465.0 |
| 2015-04-12 23:00:00 | ZN | Futures | 123.216044 | 123.216044 | 123.186177 | 123.216044 | 3320.0 |
> showing 36 of 274 rows — these rows as CSV