PREVIEW / futures_1hour / 2015-09-20
file: by_date/futures_1hour/2015/2015-09-20.parquet size: 14 KB rows: 266
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-09-20 18:00:00 | ES | Futures | 2086.3 | 2089.51 | 2083.08 | 2084.96 | 6430.0 |
| 2015-09-20 19:00:00 | ES | Futures | 2084.96 | 2087.63 | 2084.69 | 2085.22 | 3436.0 |
| 2015-09-20 20:00:00 | ES | Futures | 2085.22 | 2087.1 | 2078.54 | 2078.8 | 8767.0 |
| 2015-09-20 21:00:00 | ES | Futures | 2079.07 | 2082.55 | 2074.79 | 2077.73 | 13803.0 |
| 2015-09-20 22:00:00 | ES | Futures | 2077.73 | 2080.94 | 2074.79 | 2075.32 | 6625.0 |
| 2015-09-20 23:00:00 | ES | Futures | 2075.32 | 2078.27 | 2074.79 | 2077.2 | 2682.0 |
| 2015-09-20 18:00:00 | NQ | Futures | 5129.0 | 5137.89 | 5119.81 | 5123.36 | 1135.0 |
| 2015-09-20 19:00:00 | NQ | Futures | 5123.66 | 5129.89 | 5123.07 | 5125.14 | 521.0 |
| 2015-09-20 20:00:00 | NQ | Futures | 5123.36 | 5128.7 | 5107.35 | 5107.35 | 1359.0 |
| 2015-09-20 21:00:00 | NQ | Futures | 5107.06 | 5116.55 | 5098.16 | 5103.2 | 2311.0 |
| 2015-09-20 22:00:00 | NQ | Futures | 5103.5 | 5110.32 | 5096.98 | 5097.87 | 1391.0 |
| 2015-09-20 23:00:00 | NQ | Futures | 5097.57 | 5106.76 | 5097.27 | 5103.8 | 557.0 |
| 2015-09-20 18:00:00 | YM | Futures | 17281.7 | 17301.8 | 17249.9 | 17263.7 | 754.0 |
| 2015-09-20 19:00:00 | YM | Futures | 17263.7 | 17284.9 | 17261.6 | 17265.8 | 663.0 |
| 2015-09-20 20:00:00 | YM | Futures | 17262.7 | 17278.5 | 17215.0 | 17215.0 | 1723.0 |
| 2015-09-20 21:00:00 | YM | Futures | 17217.1 | 17243.6 | 17188.5 | 17205.5 | 2363.0 |
| 2015-09-20 22:00:00 | YM | Futures | 17205.5 | 17230.9 | 17189.6 | 17192.7 | 1235.0 |
| 2015-09-20 23:00:00 | YM | Futures | 17192.7 | 17213.9 | 17190.6 | 17209.7 | 833.0 |
| 2015-09-20 18:00:00 | CL | Futures | 64.82 | 64.83 | 64.42 | 64.59 | 944.0 |
| 2015-09-20 19:00:00 | CL | Futures | 64.58 | 64.89 | 64.46 | 64.72 | 933.0 |
| 2015-09-20 20:00:00 | CL | Futures | 64.71 | 64.78 | 64.52 | 64.53 | 674.0 |
| 2015-09-20 21:00:00 | CL | Futures | 64.53 | 64.68 | 64.52 | 64.62 | 899.0 |
| 2015-09-20 22:00:00 | CL | Futures | 64.61 | 64.76 | 64.56 | 64.73 | 1492.0 |
| 2015-09-20 23:00:00 | CL | Futures | 64.75 | 64.95 | 64.72 | 64.92 | 874.0 |
| 2015-09-20 18:00:00 | GC | Futures | 1554.7 | 1555.5 | 1551.8 | 1552.5 | 1217.0 |
| 2015-09-20 19:00:00 | GC | Futures | 1552.5 | 1552.9 | 1552.0 | 1552.0 | 435.0 |
| 2015-09-20 20:00:00 | GC | Futures | 1552.2 | 1552.9 | 1550.2 | 1552.8 | 1486.0 |
| 2015-09-20 21:00:00 | GC | Futures | 1552.7 | 1554.0 | 1551.6 | 1552.2 | 1888.0 |
| 2015-09-20 22:00:00 | GC | Futures | 1552.2 | 1553.1 | 1551.8 | 1552.8 | 1373.0 |
| 2015-09-20 23:00:00 | GC | Futures | 1552.9 | 1553.5 | 1551.7 | 1552.2 | 904.0 |
| 2015-09-20 18:00:00 | ZN | Futures | 123.506096 | 123.506096 | 123.430658 | 123.475921 | 4108.0 |
| 2015-09-20 19:00:00 | ZN | Futures | 123.475921 | 123.475921 | 123.400484 | 123.430658 | 2154.0 |
| 2015-09-20 20:00:00 | ZN | Futures | 123.415571 | 123.415571 | 123.370309 | 123.400484 | 6155.0 |
| 2015-09-20 21:00:00 | ZN | Futures | 123.400484 | 123.415571 | 123.385396 | 123.400484 | 2729.0 |
| 2015-09-20 22:00:00 | ZN | Futures | 123.400484 | 123.445746 | 123.385396 | 123.445746 | 2536.0 |
| 2015-09-20 23:00:00 | ZN | Futures | 123.445746 | 123.460833 | 123.415571 | 123.460833 | 1020.0 |
> showing 36 of 266 rows — these rows as CSV