PREVIEW / futures_1hour / 2012-06-03
file: by_date/futures_1hour/2012/2012-06-03.parquet size: 14 KB rows: 270
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-06-03 18:00:00 | ES | Futures | 1290.22 | 1292.75 | 1280.1 | 1280.35 | 38771.0 |
| 2012-06-03 19:00:00 | ES | Futures | 1280.35 | 1281.62 | 1277.07 | 1278.84 | 27095.0 |
| 2012-06-03 20:00:00 | ES | Futures | 1279.09 | 1281.11 | 1278.58 | 1280.1 | 18410.0 |
| 2012-06-03 21:00:00 | ES | Futures | 1280.1 | 1280.86 | 1278.84 | 1279.85 | 9424.0 |
| 2012-06-03 22:00:00 | ES | Futures | 1279.85 | 1283.14 | 1279.09 | 1281.62 | 11734.0 |
| 2012-06-03 23:00:00 | ES | Futures | 1281.62 | 1281.87 | 1279.59 | 1281.11 | 8380.0 |
| 2012-06-03 18:00:00 | NQ | Futures | 2845.73 | 2846.89 | 2820.86 | 2821.73 | 3361.0 |
| 2012-06-03 19:00:00 | NQ | Futures | 2820.28 | 2823.18 | 2815.66 | 2818.26 | 1471.0 |
| 2012-06-03 20:00:00 | NQ | Futures | 2818.55 | 2822.6 | 2816.23 | 2818.84 | 2035.0 |
| 2012-06-03 21:00:00 | NQ | Futures | 2818.84 | 2819.99 | 2815.37 | 2817.97 | 1120.0 |
| 2012-06-03 22:00:00 | NQ | Futures | 2818.26 | 2824.62 | 2816.52 | 2821.15 | 1273.0 |
| 2012-06-03 23:00:00 | NQ | Futures | 2821.15 | 2822.02 | 2817.1 | 2820.57 | 953.0 |
| 2012-06-03 18:00:00 | YM | Futures | 12059.2 | 12081.1 | 11964.6 | 11964.6 | 4218.0 |
| 2012-06-03 19:00:00 | YM | Futures | 11963.6 | 11974.5 | 11940.7 | 11952.6 | 1488.0 |
| 2012-06-03 20:00:00 | YM | Futures | 11953.6 | 11971.5 | 11953.6 | 11963.6 | 777.0 |
| 2012-06-03 21:00:00 | YM | Futures | 11963.6 | 11969.5 | 11956.6 | 11963.6 | 757.0 |
| 2012-06-03 22:00:00 | YM | Futures | 11964.6 | 11987.5 | 11954.6 | 11972.5 | 889.0 |
| 2012-06-03 23:00:00 | YM | Futures | 11972.5 | 11979.5 | 11960.6 | 11976.5 | 698.0 |
| 2012-06-03 18:00:00 | CL | Futures | 137.37 | 138.06 | 137.05 | 137.3 | 2737.0 |
| 2012-06-03 19:00:00 | CL | Futures | 137.3 | 137.44 | 136.51 | 136.52 | 1566.0 |
| 2012-06-03 20:00:00 | CL | Futures | 136.54 | 137.1 | 135.6 | 136.18 | 3648.0 |
| 2012-06-03 21:00:00 | CL | Futures | 136.19 | 136.56 | 136.01 | 136.31 | 2417.0 |
| 2012-06-03 22:00:00 | CL | Futures | 136.34 | 136.56 | 135.98 | 136.26 | 2076.0 |
| 2012-06-03 23:00:00 | CL | Futures | 136.26 | 136.43 | 135.7 | 135.95 | 2045.0 |
| 2012-06-03 18:00:00 | GC | Futures | 2251.1 | 2254.4 | 2243.8 | 2248.9 | 2778.0 |
| 2012-06-03 19:00:00 | GC | Futures | 2248.7 | 2248.7 | 2237.7 | 2239.2 | 3346.0 |
| 2012-06-03 20:00:00 | GC | Futures | 2238.9 | 2247.6 | 2238.5 | 2239.7 | 3739.0 |
| 2012-06-03 21:00:00 | GC | Futures | 2239.9 | 2240.6 | 2236.3 | 2238.1 | 4284.0 |
| 2012-06-03 22:00:00 | GC | Futures | 2238.4 | 2241.4 | 2237.4 | 2241.4 | 2172.0 |
| 2012-06-03 23:00:00 | GC | Futures | 2241.3 | 2246.9 | 2241.0 | 2243.1 | 3570.0 |
| 2012-06-03 18:00:00 | ZN | Futures | 118.688815 | 118.825521 | 118.688815 | 118.825521 | 171.0 |
| 2012-06-03 19:00:00 | ZN | Futures | 118.825521 | 118.852863 | 118.79818 | 118.811851 | 289.0 |
| 2012-06-03 20:00:00 | ZN | Futures | 118.784509 | 118.79818 | 118.757168 | 118.79818 | 286.0 |
| 2012-06-03 21:00:00 | ZN | Futures | 118.784509 | 118.811851 | 118.675144 | 118.688815 | 826.0 |
| 2012-06-03 22:00:00 | ZN | Futures | 118.702485 | 118.702485 | 118.59312 | 118.606791 | 590.0 |
| 2012-06-03 23:00:00 | ZN | Futures | 118.634132 | 118.661473 | 118.634132 | 118.647803 | 86.0 |
> showing 36 of 270 rows — these rows as CSV