PREVIEW / futures_1hour / 2012-06-24
file: by_date/futures_1hour/2012/2012-06-24.parquet size: 14 KB rows: 275
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-24 18:00:00 | ES | Futures | 1348.21 | 1349.23 | 1345.41 | 1346.69 | 9400.0 |
| 2012-06-24 19:00:00 | ES | Futures | 1346.69 | 1347.19 | 1345.41 | 1345.67 | 4476.0 |
| 2012-06-24 20:00:00 | ES | Futures | 1345.92 | 1346.18 | 1342.11 | 1342.11 | 13487.0 |
| 2012-06-24 21:00:00 | ES | Futures | 1342.36 | 1343.38 | 1341.85 | 1343.38 | 12890.0 |
| 2012-06-24 22:00:00 | ES | Futures | 1343.38 | 1343.63 | 1342.11 | 1342.62 | 4589.0 |
| 2012-06-24 23:00:00 | ES | Futures | 1342.62 | 1344.65 | 1342.36 | 1344.4 | 4147.0 |
| 2012-06-24 18:00:00 | NQ | Futures | 2984.37 | 2988.42 | 2976.83 | 2981.47 | 700.0 |
| 2012-06-24 19:00:00 | NQ | Futures | 2980.89 | 2982.63 | 2978.86 | 2979.44 | 239.0 |
| 2012-06-24 20:00:00 | NQ | Futures | 2979.73 | 2980.31 | 2972.48 | 2973.06 | 684.0 |
| 2012-06-24 21:00:00 | NQ | Futures | 2973.35 | 2975.09 | 2971.9 | 2974.8 | 480.0 |
| 2012-06-24 22:00:00 | NQ | Futures | 2974.8 | 2975.38 | 2972.19 | 2972.77 | 355.0 |
| 2012-06-24 23:00:00 | NQ | Futures | 2972.48 | 2977.41 | 2972.48 | 2976.83 | 427.0 |
| 2012-06-24 18:00:00 | YM | Futures | 12495.7 | 12495.7 | 12463.8 | 12473.8 | 939.0 |
| 2012-06-24 19:00:00 | YM | Futures | 12472.8 | 12477.8 | 12465.8 | 12467.8 | 296.0 |
| 2012-06-24 20:00:00 | YM | Futures | 12466.8 | 12469.8 | 12440.0 | 12442.0 | 692.0 |
| 2012-06-24 21:00:00 | YM | Futures | 12442.0 | 12448.9 | 12436.0 | 12448.9 | 597.0 |
| 2012-06-24 22:00:00 | YM | Futures | 12448.9 | 12449.9 | 12439.0 | 12441.0 | 364.0 |
| 2012-06-24 23:00:00 | YM | Futures | 12441.0 | 12455.9 | 12439.0 | 12455.9 | 326.0 |
| 2012-06-24 18:00:00 | CL | Futures | 132.37 | 133.16 | 132.09 | 132.17 | 2007.0 |
| 2012-06-24 19:00:00 | CL | Futures | 132.15 | 132.19 | 131.92 | 132.12 | 620.0 |
| 2012-06-24 20:00:00 | CL | Futures | 132.12 | 132.15 | 131.66 | 131.68 | 1132.0 |
| 2012-06-24 21:00:00 | CL | Futures | 131.69 | 132.32 | 131.69 | 132.17 | 1020.0 |
| 2012-06-24 22:00:00 | CL | Futures | 132.17 | 132.22 | 131.86 | 131.96 | 390.0 |
| 2012-06-24 23:00:00 | CL | Futures | 131.99 | 132.52 | 131.86 | 132.43 | 633.0 |
| 2012-06-24 18:00:00 | GC | Futures | 2176.1 | 2178.0 | 2169.7 | 2169.9 | 1028.0 |
| 2012-06-24 19:00:00 | GC | Futures | 2170.3 | 2173.3 | 2169.7 | 2173.0 | 443.0 |
| 2012-06-24 20:00:00 | GC | Futures | 2172.9 | 2182.6 | 2172.8 | 2177.1 | 3438.0 |
| 2012-06-24 21:00:00 | GC | Futures | 2177.3 | 2180.8 | 2176.8 | 2179.0 | 1756.0 |
| 2012-06-24 22:00:00 | GC | Futures | 2179.0 | 2179.4 | 2176.6 | 2177.1 | 825.0 |
| 2012-06-24 23:00:00 | GC | Futures | 2177.1 | 2179.3 | 2176.0 | 2179.0 | 812.0 |
| 2012-06-24 18:00:00 | ZN | Futures | 117.085609 | 117.154377 | 117.071855 | 117.154377 | 3493.0 |
| 2012-06-24 19:00:00 | ZN | Futures | 117.154377 | 117.168131 | 117.12687 | 117.154377 | 1711.0 |
| 2012-06-24 20:00:00 | ZN | Futures | 117.168131 | 117.2369 | 117.154377 | 117.195639 | 3356.0 |
| 2012-06-24 21:00:00 | ZN | Futures | 117.181885 | 117.209392 | 117.181885 | 117.195639 | 2976.0 |
| 2012-06-24 22:00:00 | ZN | Futures | 117.195639 | 117.209392 | 117.168131 | 117.195639 | 2469.0 |
| 2012-06-24 23:00:00 | ZN | Futures | 117.195639 | 117.195639 | 117.140624 | 117.154377 | 2755.0 |
> showing 36 of 275 rows — these rows as CSV