PREVIEW / futures_1hour / 2011-12-18
file: by_date/futures_1hour/2011/2011-12-18.parquet size: 14 KB rows: 269
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-12-18 18:00:00 | ES | Futures | 1221.64 | 1223.65 | 1220.13 | 1220.88 | 10114.0 |
| 2011-12-18 19:00:00 | ES | Futures | 1221.13 | 1221.64 | 1214.83 | 1218.11 | 13842.0 |
| 2011-12-18 20:00:00 | ES | Futures | 1218.36 | 1220.38 | 1215.84 | 1216.09 | 9811.0 |
| 2011-12-18 21:00:00 | ES | Futures | 1216.09 | 1217.86 | 1215.34 | 1215.84 | 4366.0 |
| 2011-12-18 22:00:00 | ES | Futures | 1216.09 | 1216.85 | 1211.56 | 1213.07 | 16403.0 |
| 2011-12-18 23:00:00 | ES | Futures | 1213.32 | 1214.58 | 1212.06 | 1212.31 | 5436.0 |
| 2011-12-18 18:00:00 | NQ | Futures | 2581.86 | 2585.9 | 2578.97 | 2580.12 | 994.0 |
| 2011-12-18 19:00:00 | NQ | Futures | 2580.7 | 2581.57 | 2568.28 | 2574.06 | 1338.0 |
| 2011-12-18 20:00:00 | NQ | Futures | 2574.35 | 2577.53 | 2570.31 | 2570.88 | 726.0 |
| 2011-12-18 21:00:00 | NQ | Futures | 2570.88 | 2574.35 | 2570.02 | 2570.88 | 387.0 |
| 2011-12-18 22:00:00 | NQ | Futures | 2571.17 | 2572.04 | 2561.35 | 2564.53 | 1158.0 |
| 2011-12-18 23:00:00 | NQ | Futures | 2565.68 | 2567.13 | 2563.66 | 2563.95 | 390.0 |
| 2011-12-18 18:00:00 | YM | Futures | 11688.5 | 11700.4 | 11671.6 | 11680.5 | 411.0 |
| 2011-12-18 19:00:00 | YM | Futures | 11678.5 | 11682.5 | 11627.0 | 11652.8 | 989.0 |
| 2011-12-18 20:00:00 | YM | Futures | 11652.8 | 11670.6 | 11630.0 | 11633.9 | 688.0 |
| 2011-12-18 21:00:00 | YM | Futures | 11634.9 | 11647.8 | 11625.0 | 11630.0 | 520.0 |
| 2011-12-18 22:00:00 | YM | Futures | 11631.0 | 11635.9 | 11592.3 | 11605.2 | 1608.0 |
| 2011-12-18 23:00:00 | YM | Futures | 11607.2 | 11620.1 | 11598.3 | 11599.3 | 425.0 |
| 2011-12-18 18:00:00 | CL | Futures | 158.14 | 158.48 | 157.92 | 158.06 | 652.0 |
| 2011-12-18 19:00:00 | CL | Futures | 158.0 | 158.14 | 157.36 | 157.84 | 719.0 |
| 2011-12-18 20:00:00 | CL | Futures | 157.84 | 157.9 | 157.31 | 157.36 | 771.0 |
| 2011-12-18 21:00:00 | CL | Futures | 157.36 | 157.68 | 157.3 | 157.53 | 503.0 |
| 2011-12-18 22:00:00 | CL | Futures | 157.57 | 157.6 | 156.74 | 156.87 | 1070.0 |
| 2011-12-18 23:00:00 | CL | Futures | 156.86 | 157.28 | 156.64 | 156.71 | 887.0 |
| 2011-12-18 18:00:00 | GC | Futures | 2229.6 | 2236.1 | 2224.0 | 2232.0 | 2012.0 |
| 2011-12-18 19:00:00 | GC | Futures | 2232.0 | 2234.7 | 2220.8 | 2227.1 | 2644.0 |
| 2011-12-18 20:00:00 | GC | Futures | 2226.8 | 2227.2 | 2215.8 | 2217.6 | 3765.0 |
| 2011-12-18 21:00:00 | GC | Futures | 2217.6 | 2219.6 | 2211.0 | 2213.6 | 2605.0 |
| 2011-12-18 22:00:00 | GC | Futures | 2213.6 | 2217.8 | 2209.6 | 2215.6 | 4097.0 |
| 2011-12-18 23:00:00 | GC | Futures | 2215.4 | 2217.2 | 2204.6 | 2211.8 | 2980.0 |
| 2011-12-18 18:00:00 | ZN | Futures | 114.50611 | 114.547029 | 114.465191 | 114.49247 | 2461.0 |
| 2011-12-18 19:00:00 | ZN | Futures | 114.47883 | 114.587949 | 114.465191 | 114.547029 | 4119.0 |
| 2011-12-18 20:00:00 | ZN | Futures | 114.547029 | 114.587949 | 114.53339 | 114.587949 | 1870.0 |
| 2011-12-18 21:00:00 | ZN | Futures | 114.601589 | 114.601589 | 114.574309 | 114.587949 | 1091.0 |
| 2011-12-18 22:00:00 | ZN | Futures | 114.601589 | 114.656148 | 114.587949 | 114.628868 | 5577.0 |
| 2011-12-18 23:00:00 | ZN | Futures | 114.615228 | 114.628868 | 114.601589 | 114.601589 | 1352.0 |
> showing 36 of 269 rows — these rows as CSV