PREVIEW / futures_1hour / 2012-08-12
file: by_date/futures_1hour/2012/2012-08-12.parquet size: 14 KB rows: 265
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-08-12 18:00:00 | ES | Futures | 1424.5 | 1426.28 | 1424.24 | 1426.02 | 3781.0 |
| 2012-08-12 19:00:00 | ES | Futures | 1425.77 | 1425.77 | 1423.99 | 1424.24 | 2019.0 |
| 2012-08-12 20:00:00 | ES | Futures | 1424.24 | 1424.24 | 1422.21 | 1422.97 | 6300.0 |
| 2012-08-12 21:00:00 | ES | Futures | 1422.97 | 1423.48 | 1421.7 | 1422.97 | 6215.0 |
| 2012-08-12 22:00:00 | ES | Futures | 1423.22 | 1423.99 | 1422.72 | 1422.97 | 2671.0 |
| 2012-08-12 23:00:00 | ES | Futures | 1423.22 | 1423.22 | 1421.95 | 1421.95 | 2100.0 |
| 2012-08-12 18:00:00 | NQ | Futures | 3153.95 | 3156.27 | 3153.08 | 3155.69 | 645.0 |
| 2012-08-12 19:00:00 | NQ | Futures | 3155.98 | 3156.27 | 3151.34 | 3151.34 | 171.0 |
| 2012-08-12 20:00:00 | NQ | Futures | 3151.63 | 3151.92 | 3146.99 | 3147.57 | 692.0 |
| 2012-08-12 21:00:00 | NQ | Futures | 3147.86 | 3150.18 | 3144.96 | 3149.02 | 838.0 |
| 2012-08-12 22:00:00 | NQ | Futures | 3149.02 | 3151.05 | 3148.15 | 3149.02 | 392.0 |
| 2012-08-12 23:00:00 | NQ | Futures | 3149.02 | 3149.31 | 3146.99 | 3147.28 | 292.0 |
| 2012-08-12 18:00:00 | YM | Futures | 13086.3 | 13094.3 | 13082.4 | 13093.3 | 591.0 |
| 2012-08-12 19:00:00 | YM | Futures | 13092.3 | 13092.3 | 13077.4 | 13078.4 | 244.0 |
| 2012-08-12 20:00:00 | YM | Futures | 13078.4 | 13078.4 | 13063.5 | 13068.4 | 661.0 |
| 2012-08-12 21:00:00 | YM | Futures | 13068.4 | 13075.4 | 13060.5 | 13070.4 | 707.0 |
| 2012-08-12 22:00:00 | YM | Futures | 13070.4 | 13077.4 | 13068.4 | 13068.4 | 553.0 |
| 2012-08-12 23:00:00 | YM | Futures | 13068.4 | 13071.4 | 13063.5 | 13064.5 | 422.0 |
| 2012-08-12 18:00:00 | CL | Futures | 153.12 | 153.35 | 152.89 | 153.16 | 727.0 |
| 2012-08-12 19:00:00 | CL | Futures | 153.18 | 153.21 | 153.08 | 153.1 | 269.0 |
| 2012-08-12 20:00:00 | CL | Futures | 153.1 | 153.3 | 153.07 | 153.21 | 843.0 |
| 2012-08-12 21:00:00 | CL | Futures | 153.21 | 153.35 | 152.95 | 153.26 | 808.0 |
| 2012-08-12 22:00:00 | CL | Futures | 153.23 | 153.92 | 153.18 | 153.67 | 1650.0 |
| 2012-08-12 23:00:00 | CL | Futures | 153.69 | 153.82 | 153.49 | 153.49 | 565.0 |
| 2012-08-12 18:00:00 | GC | Futures | 2241.3 | 2241.3 | 2237.3 | 2239.9 | 565.0 |
| 2012-08-12 19:00:00 | GC | Futures | 2240.2 | 2241.1 | 2238.8 | 2239.9 | 351.0 |
| 2012-08-12 20:00:00 | GC | Futures | 2239.9 | 2240.2 | 2237.7 | 2238.0 | 537.0 |
| 2012-08-12 21:00:00 | GC | Futures | 2238.2 | 2240.4 | 2237.1 | 2239.9 | 1277.0 |
| 2012-08-12 22:00:00 | GC | Futures | 2239.9 | 2244.1 | 2239.9 | 2242.7 | 1762.0 |
| 2012-08-12 23:00:00 | GC | Futures | 2242.7 | 2245.5 | 2242.7 | 2244.1 | 2021.0 |
| 2012-08-12 18:00:00 | ZN | Futures | 117.663266 | 117.732035 | 117.649512 | 117.718281 | 2201.0 |
| 2012-08-12 19:00:00 | ZN | Futures | 117.704527 | 117.759542 | 117.704527 | 117.732035 | 2163.0 |
| 2012-08-12 20:00:00 | ZN | Futures | 117.745788 | 117.759542 | 117.67702 | 117.718281 | 7864.0 |
| 2012-08-12 21:00:00 | ZN | Futures | 117.718281 | 117.745788 | 117.704527 | 117.718281 | 3662.0 |
| 2012-08-12 22:00:00 | ZN | Futures | 117.732035 | 117.732035 | 117.690773 | 117.704527 | 2147.0 |
| 2012-08-12 23:00:00 | ZN | Futures | 117.718281 | 117.732035 | 117.704527 | 117.732035 | 1624.0 |
> showing 36 of 265 rows — these rows as CSV