PREVIEW / futures_1hour / 2012-06-17
file: by_date/futures_1hour/2012/2012-06-17.parquet size: 14 KB rows: 276
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-17 18:00:00 | ES | Futures | 1368.3 | 1370.59 | 1362.7 | 1364.23 | 40749.0 |
| 2012-06-17 19:00:00 | ES | Futures | 1364.48 | 1367.79 | 1364.23 | 1367.03 | 8350.0 |
| 2012-06-17 20:00:00 | ES | Futures | 1366.77 | 1370.08 | 1366.77 | 1369.32 | 11666.0 |
| 2012-06-17 21:00:00 | ES | Futures | 1369.32 | 1369.57 | 1363.98 | 1364.74 | 13598.0 |
| 2012-06-17 22:00:00 | ES | Futures | 1364.74 | 1367.03 | 1364.74 | 1366.01 | 5766.0 |
| 2012-06-17 23:00:00 | ES | Futures | 1366.01 | 1368.55 | 1365.76 | 1367.28 | 4927.0 |
| 2012-06-17 18:00:00 | NQ | Futures | 2991.9 | 2998.57 | 2981.76 | 2985.82 | 3539.0 |
| 2012-06-17 19:00:00 | NQ | Futures | 2985.82 | 2990.74 | 2984.95 | 2988.71 | 744.0 |
| 2012-06-17 20:00:00 | NQ | Futures | 2989.29 | 2995.96 | 2989.0 | 2995.09 | 648.0 |
| 2012-06-17 21:00:00 | NQ | Futures | 2994.8 | 2995.09 | 2984.66 | 2986.68 | 819.0 |
| 2012-06-17 22:00:00 | NQ | Futures | 2986.39 | 2989.29 | 2985.24 | 2986.39 | 645.0 |
| 2012-06-17 23:00:00 | NQ | Futures | 2986.1 | 2991.9 | 2985.82 | 2989.87 | 501.0 |
| 2012-06-17 18:00:00 | YM | Futures | 12706.5 | 12731.3 | 12671.7 | 12679.6 | 2940.0 |
| 2012-06-17 19:00:00 | YM | Futures | 12679.6 | 12710.5 | 12679.6 | 12702.5 | 526.0 |
| 2012-06-17 20:00:00 | YM | Futures | 12702.5 | 12726.4 | 12702.5 | 12718.4 | 501.0 |
| 2012-06-17 21:00:00 | YM | Futures | 12720.4 | 12720.4 | 12682.6 | 12689.6 | 745.0 |
| 2012-06-17 22:00:00 | YM | Futures | 12689.6 | 12701.5 | 12687.6 | 12694.5 | 401.0 |
| 2012-06-17 23:00:00 | YM | Futures | 12692.6 | 12710.5 | 12690.6 | 12701.5 | 473.0 |
| 2012-06-17 18:00:00 | CL | Futures | 141.12 | 141.76 | 139.86 | 140.24 | 2256.0 |
| 2012-06-17 19:00:00 | CL | Futures | 140.21 | 140.62 | 140.21 | 140.46 | 767.0 |
| 2012-06-17 20:00:00 | CL | Futures | 140.46 | 141.13 | 140.46 | 141.05 | 1154.0 |
| 2012-06-17 21:00:00 | CL | Futures | 141.05 | 141.05 | 140.54 | 140.57 | 1020.0 |
| 2012-06-17 22:00:00 | CL | Futures | 140.59 | 140.77 | 140.46 | 140.62 | 578.0 |
| 2012-06-17 23:00:00 | CL | Futures | 140.54 | 140.74 | 140.47 | 140.47 | 303.0 |
| 2012-06-17 18:00:00 | GC | Futures | 2255.5 | 2257.3 | 2223.6 | 2237.5 | 6748.0 |
| 2012-06-17 19:00:00 | GC | Futures | 2237.5 | 2241.3 | 2234.8 | 2241.3 | 1468.0 |
| 2012-06-17 20:00:00 | GC | Futures | 2241.0 | 2256.5 | 2240.2 | 2253.9 | 4405.0 |
| 2012-06-17 21:00:00 | GC | Futures | 2254.3 | 2255.4 | 2244.7 | 2245.4 | 3277.0 |
| 2012-06-17 22:00:00 | GC | Futures | 2245.4 | 2248.7 | 2244.9 | 2246.8 | 1139.0 |
| 2012-06-17 23:00:00 | GC | Futures | 2246.9 | 2249.0 | 2244.9 | 2245.8 | 1267.0 |
| 2012-06-17 18:00:00 | ZN | Futures | 117.319422 | 117.45696 | 117.264407 | 117.429452 | 21555.0 |
| 2012-06-17 19:00:00 | ZN | Futures | 117.429452 | 117.443206 | 117.374437 | 117.429452 | 5667.0 |
| 2012-06-17 20:00:00 | ZN | Futures | 117.429452 | 117.429452 | 117.34693 | 117.415699 | 9728.0 |
| 2012-06-17 21:00:00 | ZN | Futures | 117.415699 | 117.539482 | 117.415699 | 117.525729 | 9454.0 |
| 2012-06-17 22:00:00 | ZN | Futures | 117.525729 | 117.525729 | 117.484467 | 117.498221 | 3003.0 |
| 2012-06-17 23:00:00 | ZN | Futures | 117.498221 | 117.498221 | 117.470714 | 117.484467 | 1899.0 |
> showing 36 of 276 rows — these rows as CSV