PREVIEW / futures_1hour / 2015-06-07
file: by_date/futures_1hour/2015/2015-06-07.parquet size: 14 KB rows: 258
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-06-07 18:00:00 | ES | Futures | 2210.14 | 2211.19 | 2208.02 | 2209.87 | 4706.0 |
| 2015-06-07 19:00:00 | ES | Futures | 2209.87 | 2210.4 | 2209.61 | 2209.61 | 894.0 |
| 2015-06-07 20:00:00 | ES | Futures | 2209.87 | 2209.87 | 2206.44 | 2207.5 | 4281.0 |
| 2015-06-07 21:00:00 | ES | Futures | 2207.76 | 2207.76 | 2204.33 | 2206.97 | 6747.0 |
| 2015-06-07 22:00:00 | ES | Futures | 2206.97 | 2207.23 | 2205.38 | 2206.18 | 2816.0 |
| 2015-06-07 23:00:00 | ES | Futures | 2206.18 | 2208.82 | 2205.91 | 2208.82 | 2689.0 |
| 2015-06-07 18:00:00 | NQ | Futures | 5269.03 | 5273.44 | 5266.38 | 5270.21 | 852.0 |
| 2015-06-07 19:00:00 | NQ | Futures | 5269.91 | 5271.09 | 5268.74 | 5269.62 | 193.0 |
| 2015-06-07 20:00:00 | NQ | Futures | 5269.62 | 5270.79 | 5260.5 | 5263.44 | 740.0 |
| 2015-06-07 21:00:00 | NQ | Futures | 5263.44 | 5264.62 | 5256.39 | 5261.97 | 977.0 |
| 2015-06-07 22:00:00 | NQ | Futures | 5261.68 | 5261.68 | 5258.44 | 5261.09 | 430.0 |
| 2015-06-07 23:00:00 | NQ | Futures | 5261.09 | 5266.09 | 5259.91 | 5265.8 | 505.0 |
| 2015-06-07 18:00:00 | YM | Futures | 18708.2 | 18727.1 | 18701.9 | 18716.6 | 864.0 |
| 2015-06-07 19:00:00 | YM | Futures | 18716.6 | 18720.8 | 18715.6 | 18715.6 | 129.0 |
| 2015-06-07 20:00:00 | YM | Futures | 18716.6 | 18717.6 | 18687.2 | 18699.8 | 679.0 |
| 2015-06-07 21:00:00 | YM | Futures | 18699.8 | 18700.9 | 18674.7 | 18695.6 | 1317.0 |
| 2015-06-07 22:00:00 | YM | Futures | 18694.6 | 18694.6 | 18680.9 | 18689.3 | 593.0 |
| 2015-06-07 23:00:00 | YM | Futures | 18689.3 | 18710.3 | 18687.2 | 18708.2 | 579.0 |
| 2015-06-07 18:00:00 | CL | Futures | 88.41 | 88.42 | 88.05 | 88.12 | 1082.0 |
| 2015-06-07 19:00:00 | CL | Futures | 88.14 | 88.27 | 88.02 | 88.02 | 501.0 |
| 2015-06-07 20:00:00 | CL | Futures | 88.03 | 88.05 | 87.78 | 87.85 | 1160.0 |
| 2015-06-07 21:00:00 | CL | Futures | 87.85 | 87.99 | 87.78 | 87.99 | 652.0 |
| 2015-06-07 22:00:00 | CL | Futures | 87.99 | 87.99 | 87.7 | 87.75 | 876.0 |
| 2015-06-07 23:00:00 | CL | Futures | 87.73 | 87.87 | 87.7 | 87.78 | 1009.0 |
| 2015-06-07 18:00:00 | GC | Futures | 1598.1 | 1598.1 | 1595.0 | 1596.9 | 1646.0 |
| 2015-06-07 19:00:00 | GC | Futures | 1596.9 | 1598.1 | 1595.8 | 1598.1 | 757.0 |
| 2015-06-07 20:00:00 | GC | Futures | 1598.1 | 1603.6 | 1598.0 | 1603.6 | 2893.0 |
| 2015-06-07 21:00:00 | GC | Futures | 1603.6 | 1606.7 | 1601.8 | 1602.9 | 6897.0 |
| 2015-06-07 22:00:00 | GC | Futures | 1602.7 | 1605.2 | 1601.4 | 1601.8 | 5053.0 |
| 2015-06-07 23:00:00 | GC | Futures | 1601.8 | 1603.6 | 1600.7 | 1601.8 | 2431.0 |
| 2015-06-07 19:00:00 | ZN | Futures | 120.304018 | 120.304018 | 120.259217 | 120.259217 | 6.0 |
| 2015-06-07 20:00:00 | ZN | Futures | 120.304018 | 120.363751 | 120.304018 | 120.318951 | 156.0 |
| 2015-06-07 21:00:00 | ZN | Futures | 120.304018 | 120.304018 | 120.304018 | 120.304018 | 21.0 |
| 2015-06-07 22:00:00 | ZN | Futures | 120.318951 | 120.318951 | 120.318951 | 120.318951 | 1.0 |
> showing 34 of 258 rows — these rows as CSV