PREVIEW / futures_1hour / 2012-04-08
file: by_date/futures_1hour/2012/2012-04-08.parquet size: 14 KB rows: 263
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-04-08 18:00:00 | ES | Futures | 1391.41 | 1392.43 | 1388.38 | 1389.9 | 10904.0 |
| 2012-04-08 19:00:00 | ES | Futures | 1390.15 | 1391.67 | 1388.88 | 1390.66 | 5323.0 |
| 2012-04-08 20:00:00 | ES | Futures | 1390.91 | 1391.16 | 1389.64 | 1390.15 | 6027.0 |
| 2012-04-08 21:00:00 | ES | Futures | 1389.9 | 1390.91 | 1388.13 | 1390.66 | 8989.0 |
| 2012-04-08 22:00:00 | ES | Futures | 1390.66 | 1391.67 | 1390.4 | 1391.67 | 1654.0 |
| 2012-04-08 23:00:00 | ES | Futures | 1391.41 | 1391.67 | 1390.66 | 1391.67 | 1495.0 |
| 2012-04-08 18:00:00 | NQ | Futures | 3153.15 | 3155.47 | 3146.5 | 3150.55 | 1196.0 |
| 2012-04-08 19:00:00 | NQ | Futures | 3150.55 | 3153.15 | 3147.66 | 3151.13 | 348.0 |
| 2012-04-08 20:00:00 | NQ | Futures | 3151.13 | 3151.42 | 3148.53 | 3149.68 | 768.0 |
| 2012-04-08 21:00:00 | NQ | Futures | 3149.68 | 3149.97 | 3145.35 | 3149.68 | 797.0 |
| 2012-04-08 22:00:00 | NQ | Futures | 3149.68 | 3152.0 | 3149.39 | 3151.71 | 174.0 |
| 2012-04-08 23:00:00 | NQ | Futures | 3151.42 | 3152.0 | 3150.26 | 3151.71 | 166.0 |
| 2012-04-08 18:00:00 | YM | Futures | 12812.4 | 12812.4 | 12782.5 | 12797.5 | 788.0 |
| 2012-04-08 19:00:00 | YM | Futures | 12796.5 | 12808.4 | 12789.5 | 12803.4 | 166.0 |
| 2012-04-08 20:00:00 | YM | Futures | 12803.4 | 12806.4 | 12796.5 | 12799.5 | 303.0 |
| 2012-04-08 21:00:00 | YM | Futures | 12800.5 | 12802.4 | 12777.5 | 12801.5 | 588.0 |
| 2012-04-08 22:00:00 | YM | Futures | 12801.5 | 12809.4 | 12800.5 | 12808.4 | 201.0 |
| 2012-04-08 23:00:00 | YM | Futures | 12807.4 | 12811.4 | 12804.4 | 12811.4 | 108.0 |
| 2012-04-08 18:00:00 | CL | Futures | 171.23 | 171.26 | 170.39 | 170.76 | 2087.0 |
| 2012-04-08 19:00:00 | CL | Futures | 170.76 | 170.91 | 170.56 | 170.67 | 542.0 |
| 2012-04-08 20:00:00 | CL | Futures | 170.67 | 170.76 | 170.46 | 170.47 | 338.0 |
| 2012-04-08 21:00:00 | CL | Futures | 170.49 | 170.59 | 170.12 | 170.49 | 960.0 |
| 2012-04-08 22:00:00 | CL | Futures | 170.49 | 170.59 | 170.32 | 170.56 | 295.0 |
| 2012-04-08 23:00:00 | CL | Futures | 170.57 | 170.57 | 170.34 | 170.49 | 244.0 |
| 2012-04-08 18:00:00 | GC | Futures | 2274.2 | 2284.2 | 2274.2 | 2281.1 | 4948.0 |
| 2012-04-08 19:00:00 | GC | Futures | 2281.0 | 2282.1 | 2276.0 | 2277.8 | 1506.0 |
| 2012-04-08 20:00:00 | GC | Futures | 2278.1 | 2280.4 | 2273.6 | 2273.8 | 1409.0 |
| 2012-04-08 21:00:00 | GC | Futures | 2273.6 | 2274.6 | 2268.2 | 2270.7 | 3218.0 |
| 2012-04-08 22:00:00 | GC | Futures | 2271.0 | 2275.9 | 2270.5 | 2274.2 | 1958.0 |
| 2012-04-08 23:00:00 | GC | Futures | 2274.6 | 2275.2 | 2273.9 | 2274.9 | 909.0 |
| 2012-04-08 18:00:00 | ZN | Futures | 114.888366 | 114.888366 | 114.710648 | 114.724318 | 9109.0 |
| 2012-04-08 19:00:00 | ZN | Futures | 114.710648 | 114.779001 | 114.710648 | 114.76533 | 2570.0 |
| 2012-04-08 20:00:00 | ZN | Futures | 114.76533 | 114.779001 | 114.573941 | 114.628624 | 9659.0 |
| 2012-04-08 21:00:00 | ZN | Futures | 114.628624 | 114.628624 | 114.56027 | 114.573941 | 5384.0 |
| 2012-04-08 22:00:00 | ZN | Futures | 114.56027 | 114.587612 | 114.519258 | 114.56027 | 5677.0 |
| 2012-04-08 23:00:00 | ZN | Futures | 114.56027 | 114.628624 | 114.56027 | 114.573941 | 3060.0 |
> showing 36 of 263 rows — these rows as CSV