PREVIEW / futures_1hour / 2012-10-21
file: by_date/futures_1hour/2012/2012-10-21.parquet size: 14 KB rows: 267
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-10-21 18:00:00 | ES | Futures | 1455.63 | 1457.16 | 1454.61 | 1455.38 | 9818.0 |
| 2012-10-21 19:00:00 | ES | Futures | 1455.12 | 1455.63 | 1451.8 | 1453.59 | 10388.0 |
| 2012-10-21 20:00:00 | ES | Futures | 1453.84 | 1456.91 | 1453.84 | 1456.4 | 9496.0 |
| 2012-10-21 21:00:00 | ES | Futures | 1456.4 | 1457.16 | 1455.63 | 1456.65 | 8033.0 |
| 2012-10-21 22:00:00 | ES | Futures | 1456.65 | 1456.91 | 1455.38 | 1456.65 | 2579.0 |
| 2012-10-21 23:00:00 | ES | Futures | 1456.4 | 1457.68 | 1455.63 | 1455.89 | 8483.0 |
| 2012-10-21 18:00:00 | NQ | Futures | 3096.96 | 3101.32 | 3095.51 | 3097.83 | 1100.0 |
| 2012-10-21 19:00:00 | NQ | Futures | 3097.54 | 3098.71 | 3088.83 | 3093.19 | 1076.0 |
| 2012-10-21 20:00:00 | NQ | Futures | 3093.48 | 3101.32 | 3093.19 | 3101.32 | 1103.0 |
| 2012-10-21 21:00:00 | NQ | Futures | 3101.32 | 3104.52 | 3101.03 | 3103.07 | 1511.0 |
| 2012-10-21 22:00:00 | NQ | Futures | 3103.07 | 3105.39 | 3101.32 | 3104.81 | 922.0 |
| 2012-10-21 23:00:00 | NQ | Futures | 3105.1 | 3107.71 | 3103.36 | 3103.36 | 1409.0 |
| 2012-10-21 18:00:00 | YM | Futures | 13257.8 | 13276.8 | 13256.8 | 13263.8 | 823.0 |
| 2012-10-21 19:00:00 | YM | Futures | 13262.8 | 13266.8 | 13238.8 | 13253.8 | 796.0 |
| 2012-10-21 20:00:00 | YM | Futures | 13253.8 | 13274.8 | 13253.8 | 13270.8 | 1150.0 |
| 2012-10-21 21:00:00 | YM | Futures | 13269.8 | 13278.8 | 13266.8 | 13271.8 | 908.0 |
| 2012-10-21 22:00:00 | YM | Futures | 13272.8 | 13275.8 | 13264.8 | 13274.8 | 317.0 |
| 2012-10-21 23:00:00 | YM | Futures | 13273.8 | 13280.8 | 13266.8 | 13268.8 | 714.0 |
| 2012-10-21 18:00:00 | CL | Futures | 146.33 | 146.85 | 146.02 | 146.13 | 2245.0 |
| 2012-10-21 19:00:00 | CL | Futures | 146.12 | 146.26 | 146.0 | 146.12 | 490.0 |
| 2012-10-21 20:00:00 | CL | Futures | 146.08 | 146.72 | 146.08 | 146.68 | 1099.0 |
| 2012-10-21 21:00:00 | CL | Futures | 146.72 | 147.03 | 146.67 | 146.93 | 1384.0 |
| 2012-10-21 22:00:00 | CL | Futures | 146.94 | 147.27 | 146.77 | 147.14 | 1093.0 |
| 2012-10-21 23:00:00 | CL | Futures | 147.12 | 147.48 | 147.12 | 147.27 | 1067.0 |
| 2012-10-21 18:00:00 | GC | Futures | 2376.5 | 2376.5 | 2365.1 | 2366.9 | 3695.0 |
| 2012-10-21 19:00:00 | GC | Futures | 2366.9 | 2371.6 | 2365.9 | 2371.6 | 1458.0 |
| 2012-10-21 20:00:00 | GC | Futures | 2371.3 | 2376.9 | 2371.0 | 2376.7 | 3221.0 |
| 2012-10-21 21:00:00 | GC | Futures | 2376.8 | 2379.4 | 2376.8 | 2377.8 | 3011.0 |
| 2012-10-21 22:00:00 | GC | Futures | 2377.6 | 2379.6 | 2376.8 | 2379.0 | 1348.0 |
| 2012-10-21 23:00:00 | GC | Futures | 2379.0 | 2381.2 | 2378.7 | 2379.6 | 1754.0 |
| 2012-10-21 18:00:00 | ZN | Futures | 117.452564 | 117.466427 | 117.410973 | 117.4387 | 2932.0 |
| 2012-10-21 19:00:00 | ZN | Futures | 117.424837 | 117.494155 | 117.424837 | 117.480291 | 5500.0 |
| 2012-10-21 20:00:00 | ZN | Futures | 117.466427 | 117.494155 | 117.369382 | 117.383246 | 7975.0 |
| 2012-10-21 21:00:00 | ZN | Futures | 117.383246 | 117.410973 | 117.341655 | 117.355519 | 8309.0 |
| 2012-10-21 22:00:00 | ZN | Futures | 117.369382 | 117.383246 | 117.355519 | 117.383246 | 2172.0 |
| 2012-10-21 23:00:00 | ZN | Futures | 117.369382 | 117.424837 | 117.355519 | 117.410973 | 5699.0 |
> showing 36 of 267 rows — these rows as CSV