PREVIEW / futures_1hour / 2012-09-16
file: by_date/futures_1hour/2012/2012-09-16.parquet size: 14 KB rows: 264
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-16 18:00:00 | ES | Futures | 1490.63 | 1490.89 | 1489.1 | 1489.1 | 3095.0 |
| 2012-09-16 19:00:00 | ES | Futures | 1489.1 | 1489.35 | 1487.05 | 1487.57 | 2888.0 |
| 2012-09-16 20:00:00 | ES | Futures | 1487.57 | 1488.08 | 1486.29 | 1487.82 | 4703.0 |
| 2012-09-16 21:00:00 | ES | Futures | 1487.57 | 1487.82 | 1485.78 | 1486.54 | 5221.0 |
| 2012-09-16 22:00:00 | ES | Futures | 1486.29 | 1487.31 | 1485.78 | 1486.29 | 2724.0 |
| 2012-09-16 23:00:00 | ES | Futures | 1486.03 | 1487.05 | 1485.78 | 1486.8 | 2880.0 |
| 2012-09-16 18:00:00 | NQ | Futures | 3315.19 | 3315.19 | 3309.08 | 3310.25 | 588.0 |
| 2012-09-16 19:00:00 | NQ | Futures | 3309.67 | 3310.25 | 3305.6 | 3306.47 | 309.0 |
| 2012-09-16 20:00:00 | NQ | Futures | 3306.76 | 3308.21 | 3304.14 | 3305.89 | 384.0 |
| 2012-09-16 21:00:00 | NQ | Futures | 3305.89 | 3306.47 | 3303.27 | 3303.85 | 573.0 |
| 2012-09-16 22:00:00 | NQ | Futures | 3303.85 | 3305.89 | 3302.69 | 3302.98 | 588.0 |
| 2012-09-16 23:00:00 | NQ | Futures | 3302.98 | 3304.73 | 3302.4 | 3304.73 | 248.0 |
| 2012-09-16 18:00:00 | YM | Futures | 13517.0 | 13525.0 | 13506.0 | 13507.0 | 257.0 |
| 2012-09-16 19:00:00 | YM | Futures | 13506.0 | 13509.0 | 13489.9 | 13495.9 | 262.0 |
| 2012-09-16 20:00:00 | YM | Futures | 13496.9 | 13500.9 | 13486.9 | 13497.9 | 253.0 |
| 2012-09-16 21:00:00 | YM | Futures | 13497.9 | 13500.9 | 13483.9 | 13488.9 | 528.0 |
| 2012-09-16 22:00:00 | YM | Futures | 13487.9 | 13493.9 | 13484.9 | 13488.9 | 188.0 |
| 2012-09-16 23:00:00 | YM | Futures | 13485.9 | 13495.9 | 13484.9 | 13493.9 | 150.0 |
| 2012-09-16 18:00:00 | CL | Futures | 162.3 | 162.35 | 162.1 | 162.19 | 381.0 |
| 2012-09-16 19:00:00 | CL | Futures | 162.15 | 162.17 | 161.73 | 161.97 | 166.0 |
| 2012-09-16 20:00:00 | CL | Futures | 161.97 | 162.07 | 161.84 | 161.96 | 187.0 |
| 2012-09-16 21:00:00 | CL | Futures | 161.96 | 162.12 | 161.89 | 162.09 | 119.0 |
| 2012-09-16 22:00:00 | CL | Futures | 162.07 | 162.46 | 162.02 | 162.3 | 296.0 |
| 2012-09-16 23:00:00 | CL | Futures | 162.24 | 162.32 | 162.07 | 162.22 | 137.0 |
| 2012-09-16 18:00:00 | GC | Futures | 2446.6 | 2454.1 | 2446.5 | 2451.4 | 4021.0 |
| 2012-09-16 19:00:00 | GC | Futures | 2450.9 | 2453.1 | 2449.9 | 2451.2 | 1113.0 |
| 2012-09-16 20:00:00 | GC | Futures | 2451.0 | 2452.9 | 2449.8 | 2451.0 | 1126.0 |
| 2012-09-16 21:00:00 | GC | Futures | 2450.9 | 2453.9 | 2450.5 | 2452.7 | 1563.0 |
| 2012-09-16 22:00:00 | GC | Futures | 2452.7 | 2453.4 | 2450.5 | 2450.7 | 1170.0 |
| 2012-09-16 23:00:00 | GC | Futures | 2450.7 | 2451.0 | 2448.3 | 2451.0 | 1781.0 |
| 2012-09-16 18:00:00 | ZN | Futures | 116.967337 | 116.981201 | 116.884156 | 116.953474 | 2937.0 |
| 2012-09-16 19:00:00 | ZN | Futures | 116.967337 | 116.981201 | 116.925746 | 116.981201 | 1132.0 |
| 2012-09-16 20:00:00 | ZN | Futures | 116.967337 | 117.09211 | 116.93961 | 117.036655 | 5720.0 |
| 2012-09-16 21:00:00 | ZN | Futures | 117.022792 | 117.119837 | 116.995064 | 117.105973 | 5945.0 |
| 2012-09-16 22:00:00 | ZN | Futures | 117.09211 | 117.203019 | 117.064383 | 117.189155 | 5919.0 |
| 2012-09-16 23:00:00 | ZN | Futures | 117.189155 | 117.203019 | 117.161428 | 117.175292 | 2119.0 |
> showing 36 of 264 rows — these rows as CSV