PREVIEW / futures_1hour / 2012-02-12
file: by_date/futures_1hour/2012/2012-02-12.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-02-12 18:00:00 | ES | Futures | 1357.96 | 1358.47 | 1355.19 | 1356.96 | 25508.0 |
| 2012-02-12 19:00:00 | ES | Futures | 1356.96 | 1357.71 | 1353.43 | 1353.43 | 13472.0 |
| 2012-02-12 20:00:00 | ES | Futures | 1353.43 | 1356.45 | 1353.43 | 1356.2 | 9209.0 |
| 2012-02-12 21:00:00 | ES | Futures | 1356.2 | 1357.46 | 1355.7 | 1356.96 | 6009.0 |
| 2012-02-12 22:00:00 | ES | Futures | 1356.96 | 1358.47 | 1356.45 | 1357.96 | 6179.0 |
| 2012-02-12 23:00:00 | ES | Futures | 1357.96 | 1358.47 | 1357.46 | 1358.22 | 2583.0 |
| 2012-02-12 18:00:00 | NQ | Futures | 2953.54 | 2958.45 | 2952.39 | 2955.56 | 1636.0 |
| 2012-02-12 19:00:00 | NQ | Futures | 2955.85 | 2956.72 | 2949.5 | 2949.5 | 995.0 |
| 2012-02-12 20:00:00 | NQ | Futures | 2949.79 | 2954.98 | 2949.79 | 2954.98 | 559.0 |
| 2012-02-12 21:00:00 | NQ | Futures | 2954.7 | 2957.58 | 2953.83 | 2956.43 | 683.0 |
| 2012-02-12 22:00:00 | NQ | Futures | 2956.43 | 2959.32 | 2955.85 | 2959.03 | 415.0 |
| 2012-02-12 23:00:00 | NQ | Futures | 2959.03 | 2960.47 | 2958.16 | 2959.32 | 436.0 |
| 2012-02-12 18:00:00 | YM | Futures | 12707.3 | 12722.2 | 12686.5 | 12704.4 | 2716.0 |
| 2012-02-12 19:00:00 | YM | Futures | 12703.4 | 12711.3 | 12674.6 | 12674.6 | 1576.0 |
| 2012-02-12 20:00:00 | YM | Futures | 12674.6 | 12699.4 | 12674.6 | 12698.4 | 497.0 |
| 2012-02-12 21:00:00 | YM | Futures | 12697.4 | 12706.4 | 12694.5 | 12702.4 | 561.0 |
| 2012-02-12 22:00:00 | YM | Futures | 12701.4 | 12715.3 | 12700.4 | 12712.3 | 364.0 |
| 2012-02-12 23:00:00 | YM | Futures | 12713.3 | 12714.3 | 12706.4 | 12714.3 | 171.0 |
| 2012-02-12 18:00:00 | CL | Futures | 167.01 | 167.58 | 166.99 | 167.2 | 217.0 |
| 2012-02-12 19:00:00 | CL | Futures | 167.23 | 167.45 | 166.88 | 167.01 | 141.0 |
| 2012-02-12 20:00:00 | CL | Futures | 167.06 | 167.51 | 166.98 | 167.5 | 145.0 |
| 2012-02-12 21:00:00 | CL | Futures | 167.5 | 167.75 | 167.45 | 167.61 | 202.0 |
| 2012-02-12 22:00:00 | CL | Futures | 167.6 | 167.73 | 167.56 | 167.72 | 71.0 |
| 2012-02-12 23:00:00 | CL | Futures | 167.72 | 167.77 | 167.61 | 167.75 | 86.0 |
| 2012-02-12 18:00:00 | GC | Futures | 2397.5 | 2402.1 | 2397.0 | 2398.1 | 1646.0 |
| 2012-02-12 19:00:00 | GC | Futures | 2397.7 | 2400.3 | 2390.2 | 2393.7 | 2253.0 |
| 2012-02-12 20:00:00 | GC | Futures | 2393.8 | 2397.8 | 2391.8 | 2396.8 | 3042.0 |
| 2012-02-12 21:00:00 | GC | Futures | 2396.8 | 2400.3 | 2396.7 | 2398.0 | 1724.0 |
| 2012-02-12 22:00:00 | GC | Futures | 2398.1 | 2402.1 | 2397.5 | 2401.3 | 1723.0 |
| 2012-02-12 23:00:00 | GC | Futures | 2401.4 | 2403.4 | 2400.5 | 2402.8 | 1409.0 |
| 2012-02-12 18:00:00 | ZN | Futures | 114.451551 | 114.50611 | 114.410631 | 114.49247 | 12097.0 |
| 2012-02-12 19:00:00 | ZN | Futures | 114.47883 | 114.560669 | 114.451551 | 114.53339 | 7135.0 |
| 2012-02-12 20:00:00 | ZN | Futures | 114.51975 | 114.53339 | 114.49247 | 114.50611 | 3357.0 |
| 2012-02-12 21:00:00 | ZN | Futures | 114.50611 | 114.50611 | 114.451551 | 114.47883 | 3846.0 |
| 2012-02-12 22:00:00 | ZN | Futures | 114.47883 | 114.49247 | 114.451551 | 114.465191 | 2903.0 |
| 2012-02-12 23:00:00 | ZN | Futures | 114.451551 | 114.465191 | 114.437911 | 114.451551 | 2319.0 |
> showing 36 of 266 rows — these rows as CSV