PREVIEW / futures_1hour / 2011-09-11
file: by_date/futures_1hour/2011/2011-09-11.parquet size: 13 KB rows: 252
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-11 18:00:00 | ES | Futures | 1140.78 | 1145.52 | 1138.29 | 1144.02 | 9695.0 |
| 2011-09-11 19:00:00 | ES | Futures | 1143.77 | 1146.77 | 1143.77 | 1145.27 | 4596.0 |
| 2011-09-11 20:00:00 | ES | Futures | 1145.27 | 1148.01 | 1144.52 | 1145.27 | 4265.0 |
| 2011-09-11 21:00:00 | ES | Futures | 1145.27 | 1145.77 | 1142.78 | 1145.02 | 3813.0 |
| 2011-09-11 22:00:00 | ES | Futures | 1145.02 | 1146.02 | 1141.03 | 1145.52 | 3036.0 |
| 2011-09-11 23:00:00 | ES | Futures | 1145.52 | 1146.27 | 1143.52 | 1145.02 | 2259.0 |
| 2011-09-11 18:00:00 | NQ | Futures | 2486.0 | 2486.0 | 2463.85 | 2477.37 | 548.0 |
| 2011-09-11 19:00:00 | NQ | Futures | 2479.1 | 2484.28 | 2478.23 | 2481.69 | 76.0 |
| 2011-09-11 20:00:00 | NQ | Futures | 2482.84 | 2487.44 | 2480.54 | 2481.98 | 455.0 |
| 2011-09-11 21:00:00 | NQ | Futures | 2482.26 | 2483.7 | 2477.08 | 2481.69 | 247.0 |
| 2011-09-11 22:00:00 | NQ | Futures | 2481.4 | 2483.7 | 2475.07 | 2483.41 | 193.0 |
| 2011-09-11 23:00:00 | NQ | Futures | 2482.26 | 2485.43 | 2479.1 | 2482.84 | 143.0 |
| 2011-09-11 18:00:00 | YM | Futures | 10678.5 | 10697.2 | 10638.2 | 10684.4 | 788.0 |
| 2011-09-11 19:00:00 | YM | Futures | 10686.4 | 10708.1 | 10686.4 | 10694.3 | 300.0 |
| 2011-09-11 20:00:00 | YM | Futures | 10699.2 | 10716.9 | 10690.4 | 10692.3 | 371.0 |
| 2011-09-11 21:00:00 | YM | Futures | 10695.3 | 10695.3 | 10673.6 | 10691.3 | 237.0 |
| 2011-09-11 22:00:00 | YM | Futures | 10690.4 | 10694.3 | 10658.8 | 10692.3 | 400.0 |
| 2011-09-11 23:00:00 | YM | Futures | 10691.3 | 10702.2 | 10677.6 | 10691.3 | 235.0 |
| 2011-09-11 18:00:00 | CL | Futures | 146.89 | 146.99 | 146.0 | 146.5 | 1389.0 |
| 2011-09-11 19:00:00 | CL | Futures | 146.5 | 146.74 | 146.13 | 146.23 | 633.0 |
| 2011-09-11 20:00:00 | CL | Futures | 146.25 | 146.61 | 145.96 | 146.0 | 754.0 |
| 2011-09-11 21:00:00 | CL | Futures | 146.0 | 146.05 | 145.55 | 145.71 | 812.0 |
| 2011-09-11 22:00:00 | CL | Futures | 145.78 | 146.08 | 145.62 | 146.01 | 480.0 |
| 2011-09-11 23:00:00 | CL | Futures | 146.03 | 146.11 | 145.79 | 145.96 | 408.0 |
| 2011-09-11 18:00:00 | GC | Futures | 2593.3 | 2597.5 | 2579.9 | 2587.6 | 2399.0 |
| 2011-09-11 19:00:00 | GC | Futures | 2587.4 | 2595.4 | 2585.4 | 2591.8 | 1861.0 |
| 2011-09-11 20:00:00 | GC | Futures | 2591.8 | 2593.0 | 2568.8 | 2573.4 | 6078.0 |
| 2011-09-11 21:00:00 | GC | Futures | 2573.5 | 2581.7 | 2571.6 | 2580.5 | 2822.0 |
| 2011-09-11 22:00:00 | GC | Futures | 2580.3 | 2584.4 | 2578.0 | 2582.8 | 1832.0 |
| 2011-09-11 23:00:00 | GC | Futures | 2582.8 | 2584.1 | 2573.7 | 2576.9 | 1550.0 |
| 2011-09-11 18:00:00 | ZN | Futures | 113.644551 | 113.685211 | 113.468358 | 113.509018 | 4911.0 |
| 2011-09-11 19:00:00 | ZN | Futures | 113.509018 | 113.590338 | 113.468358 | 113.576784 | 4394.0 |
| 2011-09-11 20:00:00 | ZN | Futures | 113.590338 | 113.590338 | 113.454804 | 113.495464 | 5250.0 |
| 2011-09-11 21:00:00 | ZN | Futures | 113.509018 | 113.509018 | 113.427698 | 113.468358 | 4190.0 |
| 2011-09-11 22:00:00 | ZN | Futures | 113.468358 | 113.509018 | 113.454804 | 113.468358 | 3586.0 |
| 2011-09-11 23:00:00 | ZN | Futures | 113.481911 | 113.481911 | 113.400591 | 113.454804 | 5327.0 |
> showing 36 of 252 rows — these rows as CSV