PREVIEW / futures_1hour / 2015-08-30
file: by_date/futures_1hour/2015/2015-08-30.parquet size: 14 KB rows: 254
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-30 18:00:00 | ES | Futures | 2115.34 | 2116.94 | 2086.59 | 2090.32 | 38967.0 |
| 2015-08-30 19:00:00 | ES | Futures | 2090.32 | 2097.77 | 2088.19 | 2095.64 | 13881.0 |
| 2015-08-30 20:00:00 | ES | Futures | 2095.64 | 2096.97 | 2090.32 | 2092.71 | 12782.0 |
| 2015-08-30 21:00:00 | ES | Futures | 2092.71 | 2101.76 | 2092.45 | 2098.84 | 19330.0 |
| 2015-08-30 22:00:00 | ES | Futures | 2099.1 | 2100.17 | 2094.04 | 2094.04 | 8710.0 |
| 2015-08-30 23:00:00 | ES | Futures | 2094.04 | 2096.97 | 2090.58 | 2091.65 | 9797.0 |
| 2015-08-30 18:00:00 | NQ | Futures | 5115.97 | 5123.37 | 5052.38 | 5064.51 | 4105.0 |
| 2015-08-30 19:00:00 | NQ | Futures | 5063.03 | 5081.66 | 5058.59 | 5076.93 | 1898.0 |
| 2015-08-30 20:00:00 | NQ | Futures | 5077.52 | 5080.48 | 5064.21 | 5072.79 | 3797.0 |
| 2015-08-30 21:00:00 | NQ | Futures | 5072.2 | 5101.48 | 5071.9 | 5090.54 | 6230.0 |
| 2015-08-30 22:00:00 | NQ | Futures | 5091.42 | 5094.38 | 5081.96 | 5082.85 | 2933.0 |
| 2015-08-30 23:00:00 | NQ | Futures | 5082.25 | 5092.01 | 5078.11 | 5082.85 | 3204.0 |
| 2015-08-30 18:00:00 | YM | Futures | 17524.3 | 17524.3 | 17303.1 | 17329.4 | 2799.0 |
| 2015-08-30 19:00:00 | YM | Futures | 17329.4 | 17376.8 | 17312.6 | 17360.0 | 1824.0 |
| 2015-08-30 20:00:00 | YM | Futures | 17361.0 | 17372.6 | 17318.9 | 17337.8 | 1839.0 |
| 2015-08-30 21:00:00 | YM | Futures | 17341.0 | 17405.3 | 17338.9 | 17377.9 | 2936.0 |
| 2015-08-30 22:00:00 | YM | Futures | 17381.0 | 17389.5 | 17343.1 | 17345.2 | 1132.0 |
| 2015-08-30 23:00:00 | YM | Futures | 17344.2 | 17368.4 | 17324.2 | 17327.3 | 1306.0 |
| 2015-08-30 18:00:00 | CL | Futures | 65.15 | 65.54 | 64.54 | 64.75 | 4489.0 |
| 2015-08-30 19:00:00 | CL | Futures | 64.73 | 65.08 | 64.65 | 64.94 | 1695.0 |
| 2015-08-30 20:00:00 | CL | Futures | 64.92 | 65.05 | 64.3 | 64.39 | 3726.0 |
| 2015-08-30 21:00:00 | CL | Futures | 64.39 | 64.65 | 64.28 | 64.39 | 2767.0 |
| 2015-08-30 22:00:00 | CL | Futures | 64.4 | 64.47 | 64.31 | 64.39 | 1234.0 |
| 2015-08-30 23:00:00 | CL | Futures | 64.4 | 64.4 | 64.18 | 64.2 | 1115.0 |
| 2015-08-30 18:00:00 | GC | Futures | 1546.5 | 1548.0 | 1545.6 | 1545.6 | 962.0 |
| 2015-08-30 19:00:00 | GC | Futures | 1545.6 | 1546.1 | 1543.9 | 1545.3 | 781.0 |
| 2015-08-30 20:00:00 | GC | Futures | 1545.3 | 1546.0 | 1542.1 | 1543.1 | 1645.0 |
| 2015-08-30 21:00:00 | GC | Futures | 1543.1 | 1549.0 | 1540.9 | 1547.1 | 4942.0 |
| 2015-08-30 22:00:00 | GC | Futures | 1546.9 | 1549.1 | 1546.9 | 1548.8 | 2026.0 |
| 2015-08-30 23:00:00 | GC | Futures | 1549.0 | 1549.2 | 1546.9 | 1548.3 | 2421.0 |
| 2015-08-30 18:00:00 | ZN | Futures | 122.663703 | 122.87413 | 122.55849 | 122.768917 | 3131.0 |
| 2015-08-30 19:00:00 | ZN | Futures | 122.783947 | 122.859099 | 122.783947 | 122.814008 | 898.0 |
| 2015-08-30 20:00:00 | ZN | Futures | 122.814008 | 122.964313 | 122.814008 | 122.949282 | 2780.0 |
| 2015-08-30 21:00:00 | ZN | Futures | 122.949282 | 123.009404 | 122.88916 | 122.994374 | 1908.0 |
| 2015-08-30 22:00:00 | ZN | Futures | 122.994374 | 123.084557 | 122.979343 | 123.069526 | 1305.0 |
| 2015-08-30 23:00:00 | ZN | Futures | 123.069526 | 123.069526 | 123.009404 | 123.039465 | 610.0 |
> showing 36 of 254 rows — these rows as CSV