PREVIEW / futures_1hour / 2015-09-13
file: by_date/futures_1hour/2015/2015-09-13.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 |
|---|---|---|---|---|---|---|---|
| 2015-09-13 18:00:00 | ES | Futures | 2091.38 | 2092.18 | 2087.92 | 2090.85 | 3423.0 |
| 2015-09-13 19:00:00 | ES | Futures | 2091.11 | 2102.56 | 2090.32 | 2102.3 | 6264.0 |
| 2015-09-13 20:00:00 | ES | Futures | 2102.03 | 2102.3 | 2096.97 | 2100.7 | 3480.0 |
| 2015-09-13 21:00:00 | ES | Futures | 2100.97 | 2101.76 | 2096.44 | 2098.3 | 3279.0 |
| 2015-09-13 22:00:00 | ES | Futures | 2098.04 | 2098.57 | 2091.38 | 2091.65 | 4680.0 |
| 2015-09-13 23:00:00 | ES | Futures | 2091.65 | 2094.58 | 2091.11 | 2091.65 | 2988.0 |
| 2015-09-13 18:00:00 | NQ | Futures | 5117.45 | 5128.99 | 5114.49 | 5128.4 | 287.0 |
| 2015-09-13 19:00:00 | NQ | Futures | 5126.62 | 5155.02 | 5124.85 | 5154.13 | 591.0 |
| 2015-09-13 20:00:00 | NQ | Futures | 5153.24 | 5153.54 | 5142.89 | 5149.4 | 318.0 |
| 2015-09-13 21:00:00 | NQ | Futures | 5150.58 | 5153.24 | 5138.75 | 5141.71 | 462.0 |
| 2015-09-13 22:00:00 | NQ | Futures | 5143.19 | 5143.48 | 5127.51 | 5127.51 | 419.0 |
| 2015-09-13 23:00:00 | NQ | Futures | 5127.81 | 5132.54 | 5123.37 | 5124.85 | 287.0 |
| 2015-09-13 18:00:00 | YM | Futures | 17317.7 | 17358.0 | 17306.1 | 17329.4 | 513.0 |
| 2015-09-13 19:00:00 | YM | Futures | 17329.4 | 17405.7 | 17324.1 | 17403.5 | 2591.0 |
| 2015-09-13 20:00:00 | YM | Futures | 17403.5 | 17403.5 | 17365.4 | 17395.1 | 1177.0 |
| 2015-09-13 21:00:00 | YM | Futures | 17395.1 | 17405.7 | 17360.1 | 17370.7 | 1031.0 |
| 2015-09-13 22:00:00 | YM | Futures | 17372.8 | 17376.0 | 17319.9 | 17322.0 | 1917.0 |
| 2015-09-13 23:00:00 | YM | Futures | 17323.0 | 17341.0 | 17314.6 | 17319.9 | 1158.0 |
| 2015-09-13 18:00:00 | CL | Futures | 64.83 | 65.05 | 64.76 | 64.88 | 123.0 |
| 2015-09-13 19:00:00 | CL | Futures | 64.88 | 65.03 | 64.83 | 64.93 | 104.0 |
| 2015-09-13 20:00:00 | CL | Futures | 64.91 | 64.95 | 64.85 | 64.95 | 173.0 |
| 2015-09-13 21:00:00 | CL | Futures | 64.93 | 65.05 | 64.93 | 65.05 | 37.0 |
| 2015-09-13 22:00:00 | CL | Futures | 64.99 | 65.01 | 64.48 | 64.48 | 91.0 |
| 2015-09-13 23:00:00 | CL | Futures | 64.41 | 64.51 | 64.25 | 64.42 | 321.0 |
| 2015-09-13 18:00:00 | GC | Futures | 1511.4 | 1511.7 | 1508.8 | 1509.1 | 578.0 |
| 2015-09-13 19:00:00 | GC | Futures | 1509.0 | 1509.6 | 1507.2 | 1507.2 | 766.0 |
| 2015-09-13 20:00:00 | GC | Futures | 1507.0 | 1510.2 | 1507.0 | 1508.8 | 984.0 |
| 2015-09-13 21:00:00 | GC | Futures | 1508.7 | 1512.1 | 1508.7 | 1511.4 | 1895.0 |
| 2015-09-13 22:00:00 | GC | Futures | 1511.4 | 1513.5 | 1511.0 | 1512.9 | 2220.0 |
| 2015-09-13 23:00:00 | GC | Futures | 1512.8 | 1513.9 | 1512.0 | 1513.2 | 868.0 |
| 2015-09-13 18:00:00 | ZN | Futures | 123.068559 | 123.098734 | 123.053472 | 123.053472 | 2030.0 |
| 2015-09-13 19:00:00 | ZN | Futures | 123.068559 | 123.068559 | 122.962947 | 122.978034 | 3861.0 |
| 2015-09-13 20:00:00 | ZN | Futures | 122.978034 | 123.008209 | 122.962947 | 122.993122 | 3403.0 |
| 2015-09-13 21:00:00 | ZN | Futures | 122.993122 | 123.008209 | 122.962947 | 122.993122 | 4193.0 |
| 2015-09-13 22:00:00 | ZN | Futures | 122.993122 | 123.023297 | 122.993122 | 123.023297 | 2151.0 |
| 2015-09-13 23:00:00 | ZN | Futures | 123.023297 | 123.098734 | 123.023297 | 123.083647 | 6380.0 |
> showing 36 of 273 rows — these rows as CSV