PREVIEW / futures_1hour / 2012-01-15
file: by_date/futures_1hour/2012/2012-01-15.parquet size: 12 KB rows: 202
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-01-15 18:00:00 | ES | Futures | 1295.47 | 1297.99 | 1294.97 | 1296.48 | 12837.0 |
| 2012-01-15 19:00:00 | ES | Futures | 1296.73 | 1296.73 | 1293.45 | 1293.45 | 8287.0 |
| 2012-01-15 20:00:00 | ES | Futures | 1293.45 | 1293.96 | 1291.69 | 1292.7 | 7718.0 |
| 2012-01-15 21:00:00 | ES | Futures | 1292.95 | 1293.2 | 1291.94 | 1292.45 | 3938.0 |
| 2012-01-15 22:00:00 | ES | Futures | 1292.45 | 1293.96 | 1292.19 | 1292.45 | 3044.0 |
| 2012-01-15 23:00:00 | ES | Futures | 1292.45 | 1292.7 | 1291.44 | 1291.69 | 2582.0 |
| 2012-01-15 18:00:00 | NQ | Futures | 2734.63 | 2740.12 | 2732.9 | 2738.1 | 524.0 |
| 2012-01-15 19:00:00 | NQ | Futures | 2737.52 | 2737.81 | 2729.14 | 2730.3 | 760.0 |
| 2012-01-15 20:00:00 | NQ | Futures | 2730.3 | 2732.03 | 2728.28 | 2729.43 | 529.0 |
| 2012-01-15 21:00:00 | NQ | Futures | 2729.72 | 2731.74 | 2728.57 | 2729.43 | 242.0 |
| 2012-01-15 22:00:00 | NQ | Futures | 2729.14 | 2731.74 | 2729.14 | 2730.3 | 171.0 |
| 2012-01-15 23:00:00 | NQ | Futures | 2730.01 | 2730.3 | 2728.28 | 2728.86 | 160.0 |
| 2012-01-15 18:00:00 | YM | Futures | 12240.5 | 12270.3 | 12240.5 | 12259.4 | 857.0 |
| 2012-01-15 19:00:00 | YM | Futures | 12261.3 | 12261.3 | 12234.6 | 12236.6 | 538.0 |
| 2012-01-15 20:00:00 | YM | Futures | 12234.6 | 12238.5 | 12221.7 | 12227.6 | 509.0 |
| 2012-01-15 21:00:00 | YM | Futures | 12226.6 | 12230.6 | 12222.7 | 12227.6 | 390.0 |
| 2012-01-15 22:00:00 | YM | Futures | 12226.6 | 12237.5 | 12226.6 | 12228.6 | 280.0 |
| 2012-01-15 23:00:00 | YM | Futures | 12229.6 | 12229.6 | 12219.7 | 12220.7 | 203.0 |
| 2012-01-15 18:00:00 | CL | Futures | 167.01 | 167.15 | 166.59 | 166.96 | 249.0 |
| 2012-01-15 19:00:00 | CL | Futures | 166.88 | 167.01 | 166.66 | 166.83 | 95.0 |
| 2012-01-15 20:00:00 | CL | Futures | 166.74 | 166.93 | 166.57 | 166.93 | 88.0 |
| 2012-01-15 21:00:00 | CL | Futures | 166.98 | 167.04 | 166.81 | 166.94 | 125.0 |
| 2012-01-15 22:00:00 | CL | Futures | 166.96 | 167.13 | 166.89 | 167.01 | 170.0 |
| 2012-01-15 23:00:00 | CL | Futures | 166.99 | 167.08 | 166.93 | 167.06 | 114.0 |
| 2012-01-15 18:00:00 | GC | Futures | 2274.5 | 2280.4 | 2272.0 | 2273.3 | 1018.0 |
| 2012-01-15 19:00:00 | GC | Futures | 2273.3 | 2276.5 | 2269.1 | 2274.8 | 2093.0 |
| 2012-01-15 20:00:00 | GC | Futures | 2274.9 | 2276.9 | 2270.3 | 2274.5 | 2214.0 |
| 2012-01-15 21:00:00 | GC | Futures | 2274.8 | 2283.0 | 2274.5 | 2280.8 | 2397.0 |
| 2012-01-15 22:00:00 | GC | Futures | 2280.8 | 2283.8 | 2277.9 | 2279.2 | 1804.0 |
| 2012-01-15 23:00:00 | GC | Futures | 2279.0 | 2280.5 | 2275.5 | 2279.5 | 1325.0 |
| 2012-01-15 18:00:00 | ZN | Futures | 114.847105 | 114.928944 | 114.819825 | 114.901664 | 4049.0 |
| 2012-01-15 19:00:00 | ZN | Futures | 114.901664 | 114.928944 | 114.901664 | 114.901664 | 560.0 |
| 2012-01-15 20:00:00 | ZN | Futures | 114.888024 | 114.983503 | 114.888024 | 114.942583 | 4129.0 |
| 2012-01-15 21:00:00 | ZN | Futures | 114.928944 | 114.942583 | 114.915304 | 114.928944 | 755.0 |
| 2012-01-15 22:00:00 | ZN | Futures | 114.942583 | 114.942583 | 114.928944 | 114.942583 | 553.0 |
| 2012-01-15 23:00:00 | ZN | Futures | 114.942583 | 114.942583 | 114.915304 | 114.942583 | 453.0 |
> showing 36 of 202 rows — these rows as CSV