PREVIEW / futures_1hour / 2012-11-25
file: by_date/futures_1hour/2012/2012-11-25.parquet size: 14 KB rows: 266
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-11-25 18:00:00 | ES | Futures | 1433.92 | 1434.17 | 1431.36 | 1432.64 | 14476.0 |
| 2012-11-25 19:00:00 | ES | Futures | 1432.39 | 1432.64 | 1431.36 | 1431.62 | 6469.0 |
| 2012-11-25 20:00:00 | ES | Futures | 1431.62 | 1432.39 | 1430.6 | 1430.6 | 8271.0 |
| 2012-11-25 21:00:00 | ES | Futures | 1430.85 | 1432.13 | 1430.6 | 1431.87 | 5535.0 |
| 2012-11-25 22:00:00 | ES | Futures | 1431.87 | 1431.87 | 1430.6 | 1431.36 | 4251.0 |
| 2012-11-25 23:00:00 | ES | Futures | 1431.36 | 1431.62 | 1431.11 | 1431.36 | 1510.0 |
| 2012-11-25 18:00:00 | NQ | Futures | 3060.35 | 3061.22 | 3052.8 | 3053.38 | 1588.0 |
| 2012-11-25 19:00:00 | NQ | Futures | 3053.67 | 3053.96 | 3052.5 | 3053.09 | 572.0 |
| 2012-11-25 20:00:00 | NQ | Futures | 3053.38 | 3054.25 | 3051.63 | 3051.63 | 787.0 |
| 2012-11-25 21:00:00 | NQ | Futures | 3051.63 | 3054.54 | 3050.76 | 3053.67 | 597.0 |
| 2012-11-25 22:00:00 | NQ | Futures | 3053.38 | 3054.54 | 3052.21 | 3053.67 | 477.0 |
| 2012-11-25 23:00:00 | NQ | Futures | 3053.67 | 3054.25 | 3052.8 | 3053.96 | 143.0 |
| 2012-11-25 18:00:00 | YM | Futures | 12955.7 | 12955.7 | 12934.7 | 12941.7 | 765.0 |
| 2012-11-25 19:00:00 | YM | Futures | 12942.7 | 12944.7 | 12934.7 | 12937.7 | 491.0 |
| 2012-11-25 20:00:00 | YM | Futures | 12938.7 | 12942.7 | 12927.7 | 12928.7 | 838.0 |
| 2012-11-25 21:00:00 | YM | Futures | 12928.7 | 12939.7 | 12927.7 | 12935.7 | 694.0 |
| 2012-11-25 22:00:00 | YM | Futures | 12935.7 | 12938.7 | 12931.7 | 12935.7 | 362.0 |
| 2012-11-25 23:00:00 | YM | Futures | 12934.7 | 12936.7 | 12931.7 | 12935.7 | 206.0 |
| 2012-11-25 18:00:00 | CL | Futures | 142.5 | 142.63 | 142.34 | 142.39 | 672.0 |
| 2012-11-25 19:00:00 | CL | Futures | 142.4 | 142.4 | 142.08 | 142.16 | 924.0 |
| 2012-11-25 20:00:00 | CL | Futures | 142.18 | 142.19 | 142.03 | 142.03 | 518.0 |
| 2012-11-25 21:00:00 | CL | Futures | 142.03 | 142.29 | 141.98 | 142.26 | 769.0 |
| 2012-11-25 22:00:00 | CL | Futures | 142.26 | 142.26 | 142.05 | 142.14 | 512.0 |
| 2012-11-25 23:00:00 | CL | Futures | 142.14 | 142.16 | 141.85 | 141.95 | 662.0 |
| 2012-11-25 18:00:00 | GC | Futures | 2416.7 | 2416.7 | 2413.1 | 2413.9 | 322.0 |
| 2012-11-25 19:00:00 | GC | Futures | 2414.2 | 2414.9 | 2412.1 | 2412.1 | 318.0 |
| 2012-11-25 20:00:00 | GC | Futures | 2412.4 | 2413.4 | 2410.9 | 2411.4 | 319.0 |
| 2012-11-25 21:00:00 | GC | Futures | 2411.3 | 2411.8 | 2409.8 | 2411.4 | 367.0 |
| 2012-11-25 22:00:00 | GC | Futures | 2411.3 | 2412.0 | 2410.3 | 2410.9 | 117.0 |
| 2012-11-25 23:00:00 | GC | Futures | 2411.0 | 2414.5 | 2411.0 | 2413.5 | 345.0 |
| 2012-11-25 18:00:00 | ZN | Futures | 118.284381 | 118.312108 | 118.256654 | 118.298245 | 7717.0 |
| 2012-11-25 19:00:00 | ZN | Futures | 118.298245 | 118.39529 | 118.284381 | 118.39529 | 10859.0 |
| 2012-11-25 20:00:00 | ZN | Futures | 118.381426 | 118.423017 | 118.353699 | 118.423017 | 5904.0 |
| 2012-11-25 21:00:00 | ZN | Futures | 118.423017 | 118.436881 | 118.39529 | 118.423017 | 2845.0 |
| 2012-11-25 22:00:00 | ZN | Futures | 118.423017 | 118.423017 | 118.39529 | 118.409153 | 2946.0 |
| 2012-11-25 23:00:00 | ZN | Futures | 118.409153 | 118.423017 | 118.409153 | 118.409153 | 1998.0 |
> showing 36 of 266 rows — these rows as CSV