PREVIEW / futures_1hour / 2011-12-11
file: by_date/futures_1hour/2011/2011-12-11.parquet size: 13 KB rows: 237
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-11 18:00:00 | ES | Futures | 1259.81 | 1261.81 | 1259.06 | 1260.56 | 2453.0 |
| 2011-12-11 19:00:00 | ES | Futures | 1260.56 | 1261.31 | 1258.55 | 1261.06 | 1634.0 |
| 2011-12-11 20:00:00 | ES | Futures | 1261.06 | 1263.82 | 1260.31 | 1263.82 | 3167.0 |
| 2011-12-11 21:00:00 | ES | Futures | 1263.82 | 1264.32 | 1261.81 | 1262.82 | 1460.0 |
| 2011-12-11 22:00:00 | ES | Futures | 1262.57 | 1262.82 | 1260.06 | 1260.81 | 1361.0 |
| 2011-12-11 23:00:00 | ES | Futures | 1260.81 | 1261.31 | 1258.05 | 1258.3 | 1487.0 |
| 2011-12-11 18:00:00 | NQ | Futures | 2677.36 | 2679.67 | 2675.63 | 2677.94 | 70.0 |
| 2011-12-11 19:00:00 | NQ | Futures | 2677.94 | 2678.23 | 2673.61 | 2675.92 | 90.0 |
| 2011-12-11 20:00:00 | NQ | Futures | 2675.92 | 2681.69 | 2674.77 | 2681.4 | 80.0 |
| 2011-12-11 21:00:00 | NQ | Futures | 2681.69 | 2681.98 | 2678.52 | 2679.38 | 34.0 |
| 2011-12-11 22:00:00 | NQ | Futures | 2679.96 | 2680.53 | 2676.5 | 2676.79 | 42.0 |
| 2011-12-11 23:00:00 | NQ | Futures | 2675.92 | 2677.07 | 2670.73 | 2670.73 | 58.0 |
| 2011-12-11 18:00:00 | YM | Futures | 12021.5 | 12033.4 | 12002.6 | 12020.5 | 271.0 |
| 2011-12-11 19:00:00 | YM | Futures | 12020.5 | 12026.4 | 12003.6 | 12023.5 | 533.0 |
| 2011-12-11 20:00:00 | YM | Futures | 12022.5 | 12045.3 | 12018.5 | 12043.3 | 535.0 |
| 2011-12-11 21:00:00 | YM | Futures | 12045.3 | 12045.3 | 12026.4 | 12033.4 | 280.0 |
| 2011-12-11 22:00:00 | YM | Futures | 12032.4 | 12034.4 | 12011.6 | 12015.5 | 368.0 |
| 2011-12-11 23:00:00 | YM | Futures | 12014.5 | 12019.5 | 11994.7 | 11997.7 | 294.0 |
| 2011-12-11 18:00:00 | CL | Futures | 168.26 | 168.43 | 167.9 | 168.36 | 732.0 |
| 2011-12-11 19:00:00 | CL | Futures | 168.36 | 168.36 | 167.95 | 168.07 | 597.0 |
| 2011-12-11 20:00:00 | CL | Futures | 168.05 | 168.05 | 167.43 | 167.83 | 1035.0 |
| 2011-12-11 21:00:00 | CL | Futures | 167.82 | 167.97 | 167.65 | 167.85 | 380.0 |
| 2011-12-11 22:00:00 | CL | Futures | 167.85 | 167.99 | 167.75 | 167.78 | 1039.0 |
| 2011-12-11 23:00:00 | CL | Futures | 167.8 | 167.85 | 167.45 | 167.48 | 928.0 |
| 2011-12-11 18:00:00 | GC | Futures | 2387.1 | 2389.0 | 2383.5 | 2386.6 | 583.0 |
| 2011-12-11 19:00:00 | GC | Futures | 2386.4 | 2389.6 | 2385.3 | 2388.4 | 833.0 |
| 2011-12-11 20:00:00 | GC | Futures | 2388.1 | 2388.1 | 2379.4 | 2382.1 | 3042.0 |
| 2011-12-11 21:00:00 | GC | Futures | 2382.1 | 2383.5 | 2381.2 | 2382.7 | 787.0 |
| 2011-12-11 22:00:00 | GC | Futures | 2382.7 | 2382.7 | 2347.1 | 2366.6 | 10201.0 |
| 2011-12-11 23:00:00 | GC | Futures | 2366.3 | 2369.3 | 2354.7 | 2358.4 | 4653.0 |
| 2011-12-11 18:00:00 | ZN | Futures | 113.292168 | 113.292168 | 113.183049 | 113.264888 | 4463.0 |
| 2011-12-11 19:00:00 | ZN | Futures | 113.264888 | 113.360367 | 113.237609 | 113.305808 | 3718.0 |
| 2011-12-11 20:00:00 | ZN | Futures | 113.305808 | 113.346727 | 113.278528 | 113.292168 | 3588.0 |
| 2011-12-11 21:00:00 | ZN | Futures | 113.292168 | 113.319447 | 113.278528 | 113.305808 | 1160.0 |
| 2011-12-11 22:00:00 | ZN | Futures | 113.305808 | 113.346727 | 113.292168 | 113.292168 | 3270.0 |
| 2011-12-11 23:00:00 | ZN | Futures | 113.292168 | 113.346727 | 113.292168 | 113.346727 | 1741.0 |
> showing 36 of 237 rows — these rows as CSV