PREVIEW / futures_1hour / 2012-01-08
file: by_date/futures_1hour/2012/2012-01-08.parquet size: 13 KB rows: 264
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-08 18:00:00 | ES | Futures | 1284.89 | 1284.89 | 1277.58 | 1279.6 | 12602.0 |
| 2012-01-08 19:00:00 | ES | Futures | 1279.6 | 1279.85 | 1277.58 | 1278.84 | 7263.0 |
| 2012-01-08 20:00:00 | ES | Futures | 1279.09 | 1280.1 | 1278.08 | 1278.59 | 5171.0 |
| 2012-01-08 21:00:00 | ES | Futures | 1278.59 | 1280.35 | 1277.33 | 1279.6 | 6493.0 |
| 2012-01-08 22:00:00 | ES | Futures | 1279.6 | 1280.6 | 1278.08 | 1278.34 | 4673.0 |
| 2012-01-08 23:00:00 | ES | Futures | 1278.59 | 1280.35 | 1278.34 | 1278.59 | 3296.0 |
| 2012-01-08 18:00:00 | NQ | Futures | 2718.46 | 2721.06 | 2707.48 | 2709.79 | 1062.0 |
| 2012-01-08 19:00:00 | NQ | Futures | 2710.08 | 2710.37 | 2706.04 | 2707.48 | 319.0 |
| 2012-01-08 20:00:00 | NQ | Futures | 2707.77 | 2710.08 | 2706.91 | 2707.2 | 259.0 |
| 2012-01-08 21:00:00 | NQ | Futures | 2707.48 | 2711.53 | 2705.46 | 2710.37 | 398.0 |
| 2012-01-08 22:00:00 | NQ | Futures | 2710.66 | 2712.11 | 2707.2 | 2707.48 | 163.0 |
| 2012-01-08 23:00:00 | NQ | Futures | 2708.06 | 2711.24 | 2707.48 | 2708.35 | 205.0 |
| 2012-01-08 18:00:00 | YM | Futures | 12202.9 | 12207.8 | 12145.4 | 12160.2 | 739.0 |
| 2012-01-08 19:00:00 | YM | Futures | 12161.2 | 12162.2 | 12144.4 | 12158.3 | 586.0 |
| 2012-01-08 20:00:00 | YM | Futures | 12158.3 | 12168.2 | 12147.4 | 12153.3 | 1140.0 |
| 2012-01-08 21:00:00 | YM | Futures | 12152.3 | 12170.2 | 12143.4 | 12163.2 | 1941.0 |
| 2012-01-08 22:00:00 | YM | Futures | 12164.2 | 12176.1 | 12153.3 | 12154.3 | 1248.0 |
| 2012-01-08 23:00:00 | YM | Futures | 12156.3 | 12169.2 | 12155.3 | 12158.3 | 269.0 |
| 2012-01-08 18:00:00 | CL | Futures | 171.88 | 172.27 | 170.82 | 171.13 | 2117.0 |
| 2012-01-08 19:00:00 | CL | Futures | 171.16 | 171.18 | 170.5 | 170.91 | 823.0 |
| 2012-01-08 20:00:00 | CL | Futures | 170.86 | 171.02 | 170.43 | 170.48 | 732.0 |
| 2012-01-08 21:00:00 | CL | Futures | 170.45 | 170.59 | 170.16 | 170.48 | 1231.0 |
| 2012-01-08 22:00:00 | CL | Futures | 170.45 | 170.59 | 170.18 | 170.33 | 757.0 |
| 2012-01-08 23:00:00 | CL | Futures | 170.35 | 170.62 | 170.25 | 170.25 | 661.0 |
| 2012-01-08 18:00:00 | GC | Futures | 2249.3 | 2249.6 | 2237.4 | 2243.5 | 2005.0 |
| 2012-01-08 19:00:00 | GC | Futures | 2244.1 | 2244.5 | 2238.4 | 2240.4 | 1597.0 |
| 2012-01-08 20:00:00 | GC | Futures | 2240.3 | 2244.2 | 2234.6 | 2236.4 | 2149.0 |
| 2012-01-08 21:00:00 | GC | Futures | 2236.4 | 2237.8 | 2232.7 | 2237.4 | 2307.0 |
| 2012-01-08 22:00:00 | GC | Futures | 2237.5 | 2238.5 | 2234.7 | 2237.3 | 1228.0 |
| 2012-01-08 23:00:00 | GC | Futures | 2236.6 | 2239.8 | 2236.4 | 2237.7 | 992.0 |
| 2012-01-08 18:00:00 | ZN | Futures | 114.137835 | 114.274233 | 114.137835 | 114.206034 | 2850.0 |
| 2012-01-08 19:00:00 | ZN | Futures | 114.206034 | 114.246954 | 114.178755 | 114.246954 | 2066.0 |
| 2012-01-08 20:00:00 | ZN | Futures | 114.233314 | 114.274233 | 114.206034 | 114.260594 | 1980.0 |
| 2012-01-08 21:00:00 | ZN | Futures | 114.260594 | 114.274233 | 114.206034 | 114.219674 | 1956.0 |
| 2012-01-08 22:00:00 | ZN | Futures | 114.219674 | 114.233314 | 114.192395 | 114.233314 | 924.0 |
| 2012-01-08 23:00:00 | ZN | Futures | 114.246954 | 114.246954 | 114.219674 | 114.233314 | 649.0 |
> showing 36 of 264 rows — these rows as CSV