PREVIEW / futures_1hour / 2012-10-14
file: by_date/futures_1hour/2012/2012-10-14.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 |
|---|---|---|---|---|---|---|---|
| 2012-10-14 18:00:00 | ES | Futures | 1454.61 | 1455.12 | 1451.54 | 1452.57 | 9315.0 |
| 2012-10-14 19:00:00 | ES | Futures | 1452.31 | 1453.08 | 1451.03 | 1451.29 | 5460.0 |
| 2012-10-14 20:00:00 | ES | Futures | 1451.29 | 1452.06 | 1447.46 | 1449.5 | 23626.0 |
| 2012-10-14 21:00:00 | ES | Futures | 1449.5 | 1453.08 | 1448.48 | 1452.82 | 9111.0 |
| 2012-10-14 22:00:00 | ES | Futures | 1452.82 | 1452.82 | 1449.5 | 1450.78 | 5825.0 |
| 2012-10-14 23:00:00 | ES | Futures | 1450.78 | 1451.8 | 1450.01 | 1451.29 | 2367.0 |
| 2012-10-14 18:00:00 | NQ | Futures | 3153.33 | 3157.98 | 3149.85 | 3151.01 | 732.0 |
| 2012-10-14 19:00:00 | NQ | Futures | 3150.72 | 3153.63 | 3149.85 | 3150.14 | 733.0 |
| 2012-10-14 20:00:00 | NQ | Futures | 3150.14 | 3151.59 | 3144.04 | 3148.1 | 2927.0 |
| 2012-10-14 21:00:00 | NQ | Futures | 3147.81 | 3155.08 | 3146.36 | 3154.21 | 1548.0 |
| 2012-10-14 22:00:00 | NQ | Futures | 3153.92 | 3153.92 | 3147.23 | 3150.14 | 852.0 |
| 2012-10-14 23:00:00 | NQ | Futures | 3150.43 | 3152.17 | 3148.1 | 3151.59 | 303.0 |
| 2012-10-14 18:00:00 | YM | Futures | 13261.8 | 13275.8 | 13248.8 | 13253.8 | 396.0 |
| 2012-10-14 19:00:00 | YM | Futures | 13253.8 | 13258.8 | 13243.8 | 13244.8 | 246.0 |
| 2012-10-14 20:00:00 | YM | Futures | 13244.8 | 13251.8 | 13214.8 | 13229.8 | 1543.0 |
| 2012-10-14 21:00:00 | YM | Futures | 13228.8 | 13256.8 | 13222.8 | 13251.8 | 1234.0 |
| 2012-10-14 22:00:00 | YM | Futures | 13251.8 | 13251.8 | 13226.8 | 13237.8 | 843.0 |
| 2012-10-14 23:00:00 | YM | Futures | 13237.8 | 13245.8 | 13231.8 | 13243.8 | 291.0 |
| 2012-10-14 18:00:00 | CL | Futures | 149.48 | 149.71 | 148.68 | 148.81 | 237.0 |
| 2012-10-14 19:00:00 | CL | Futures | 148.78 | 148.94 | 148.72 | 148.88 | 108.0 |
| 2012-10-14 20:00:00 | CL | Futures | 148.73 | 148.93 | 148.6 | 148.67 | 394.0 |
| 2012-10-14 21:00:00 | CL | Futures | 148.68 | 148.99 | 148.28 | 148.94 | 283.0 |
| 2012-10-14 22:00:00 | CL | Futures | 148.85 | 148.85 | 148.57 | 148.72 | 71.0 |
| 2012-10-14 23:00:00 | CL | Futures | 148.78 | 148.83 | 148.62 | 148.63 | 83.0 |
| 2012-10-14 18:00:00 | GC | Futures | 2421.4 | 2421.8 | 2407.4 | 2410.0 | 6355.0 |
| 2012-10-14 19:00:00 | GC | Futures | 2409.8 | 2410.5 | 2404.0 | 2405.6 | 4150.0 |
| 2012-10-14 20:00:00 | GC | Futures | 2405.6 | 2409.2 | 2405.6 | 2406.7 | 3029.0 |
| 2012-10-14 21:00:00 | GC | Futures | 2406.7 | 2409.2 | 2404.7 | 2408.5 | 3845.0 |
| 2012-10-14 22:00:00 | GC | Futures | 2408.5 | 2408.7 | 2405.9 | 2407.3 | 2224.0 |
| 2012-10-14 23:00:00 | GC | Futures | 2407.3 | 2407.7 | 2406.3 | 2406.9 | 1162.0 |
| 2012-10-14 18:00:00 | ZN | Futures | 118.284381 | 118.325972 | 118.256654 | 118.284381 | 2686.0 |
| 2012-10-14 19:00:00 | ZN | Futures | 118.298245 | 118.312108 | 118.256654 | 118.270517 | 3403.0 |
| 2012-10-14 20:00:00 | ZN | Futures | 118.284381 | 118.353699 | 118.270517 | 118.339835 | 11815.0 |
| 2012-10-14 21:00:00 | ZN | Futures | 118.339835 | 118.367563 | 118.312108 | 118.325972 | 6109.0 |
| 2012-10-14 22:00:00 | ZN | Futures | 118.325972 | 118.353699 | 118.325972 | 118.325972 | 1986.0 |
| 2012-10-14 23:00:00 | ZN | Futures | 118.325972 | 118.353699 | 118.325972 | 118.325972 | 1981.0 |
> showing 36 of 273 rows — these rows as CSV