PREVIEW / futures_1hour / 2012-05-06
file: by_date/futures_1hour/2012/2012-05-06.parquet size: 14 KB rows: 273
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-05-06 18:00:00 | ES | Futures | 1370.16 | 1370.92 | 1358.53 | 1365.1 | 55137.0 |
| 2012-05-06 19:00:00 | ES | Futures | 1364.85 | 1366.87 | 1363.59 | 1365.1 | 11524.0 |
| 2012-05-06 20:00:00 | ES | Futures | 1365.1 | 1367.63 | 1362.83 | 1365.1 | 17083.0 |
| 2012-05-06 21:00:00 | ES | Futures | 1365.1 | 1365.61 | 1363.33 | 1363.59 | 11313.0 |
| 2012-05-06 22:00:00 | ES | Futures | 1363.59 | 1364.09 | 1361.81 | 1364.09 | 10705.0 |
| 2012-05-06 23:00:00 | ES | Futures | 1364.09 | 1365.36 | 1363.33 | 1364.85 | 4576.0 |
| 2012-05-06 18:00:00 | NQ | Futures | 3019.54 | 3021.57 | 2992.07 | 3007.11 | 5233.0 |
| 2012-05-06 19:00:00 | NQ | Futures | 3007.4 | 3011.16 | 3003.35 | 3006.24 | 1240.0 |
| 2012-05-06 20:00:00 | NQ | Futures | 3006.53 | 3014.34 | 3003.06 | 3007.69 | 1677.0 |
| 2012-05-06 21:00:00 | NQ | Futures | 3007.69 | 3008.26 | 3003.06 | 3003.93 | 966.0 |
| 2012-05-06 22:00:00 | NQ | Futures | 3003.64 | 3006.24 | 2999.88 | 3005.37 | 706.0 |
| 2012-05-06 23:00:00 | NQ | Futures | 3005.37 | 3008.26 | 3004.79 | 3007.11 | 282.0 |
| 2012-05-06 18:00:00 | YM | Futures | 12822.4 | 12841.3 | 12731.7 | 12784.5 | 4072.0 |
| 2012-05-06 19:00:00 | YM | Futures | 12787.5 | 12800.5 | 12775.5 | 12785.5 | 612.0 |
| 2012-05-06 20:00:00 | YM | Futures | 12784.5 | 12808.4 | 12770.6 | 12789.5 | 1130.0 |
| 2012-05-06 21:00:00 | YM | Futures | 12789.5 | 12793.5 | 12775.5 | 12776.5 | 932.0 |
| 2012-05-06 22:00:00 | YM | Futures | 12775.5 | 12784.5 | 12764.6 | 12783.5 | 1261.0 |
| 2012-05-06 23:00:00 | YM | Futures | 12783.5 | 12793.5 | 12779.5 | 12788.5 | 405.0 |
| 2012-05-06 18:00:00 | CL | Futures | 163.0 | 163.32 | 158.5 | 159.81 | 12669.0 |
| 2012-05-06 19:00:00 | CL | Futures | 159.83 | 160.21 | 159.56 | 160.03 | 2978.0 |
| 2012-05-06 20:00:00 | CL | Futures | 160.03 | 160.66 | 160.01 | 160.16 | 2223.0 |
| 2012-05-06 21:00:00 | CL | Futures | 160.14 | 160.16 | 159.79 | 160.06 | 2007.0 |
| 2012-05-06 22:00:00 | CL | Futures | 160.04 | 160.81 | 160.03 | 160.76 | 1738.0 |
| 2012-05-06 23:00:00 | CL | Futures | 160.76 | 161.59 | 160.74 | 161.36 | 2362.0 |
| 2012-05-06 18:00:00 | GC | Futures | 2277.4 | 2278.4 | 2267.5 | 2273.8 | 2954.0 |
| 2012-05-06 19:00:00 | GC | Futures | 2273.9 | 2273.9 | 2269.9 | 2272.0 | 990.0 |
| 2012-05-06 20:00:00 | GC | Futures | 2271.7 | 2275.7 | 2271.7 | 2273.6 | 2025.0 |
| 2012-05-06 21:00:00 | GC | Futures | 2273.5 | 2273.9 | 2265.6 | 2270.0 | 3875.0 |
| 2012-05-06 22:00:00 | GC | Futures | 2269.9 | 2270.7 | 2268.8 | 2270.5 | 935.0 |
| 2012-05-06 23:00:00 | GC | Futures | 2270.5 | 2272.7 | 2270.3 | 2271.6 | 1275.0 |
| 2012-05-06 18:00:00 | ZN | Futures | 116.17341 | 116.351129 | 116.146069 | 116.323788 | 21985.0 |
| 2012-05-06 19:00:00 | ZN | Futures | 116.310117 | 116.351129 | 116.282775 | 116.323788 | 10540.0 |
| 2012-05-06 20:00:00 | ZN | Futures | 116.310117 | 116.337458 | 116.269105 | 116.296446 | 12093.0 |
| 2012-05-06 21:00:00 | ZN | Futures | 116.310117 | 116.323788 | 116.269105 | 116.310117 | 7861.0 |
| 2012-05-06 22:00:00 | ZN | Futures | 116.323788 | 116.392141 | 116.310117 | 116.3648 | 14478.0 |
| 2012-05-06 23:00:00 | ZN | Futures | 116.3648 | 116.3648 | 116.323788 | 116.337458 | 3462.0 |
> showing 36 of 273 rows — these rows as CSV