PREVIEW / futures_1hour / 2013-12-01
file: by_date/futures_1hour/2013/2013-12-01.parquet size: 14 KB rows: 268
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-01 18:00:00 | ES | Futures | 1863.76 | 1865.31 | 1862.99 | 1863.25 | 11353.0 |
| 2013-12-01 19:00:00 | ES | Futures | 1862.99 | 1864.54 | 1862.73 | 1863.25 | 4459.0 |
| 2013-12-01 20:00:00 | ES | Futures | 1863.51 | 1863.76 | 1862.47 | 1863.25 | 4482.0 |
| 2013-12-01 21:00:00 | ES | Futures | 1863.51 | 1864.28 | 1862.99 | 1864.02 | 3609.0 |
| 2013-12-01 22:00:00 | ES | Futures | 1864.02 | 1864.02 | 1862.47 | 1862.99 | 2643.0 |
| 2013-12-01 23:00:00 | ES | Futures | 1862.99 | 1862.99 | 1862.22 | 1862.22 | 2326.0 |
| 2013-12-01 18:00:00 | NQ | Futures | 4057.92 | 4061.12 | 4056.76 | 4056.76 | 1387.0 |
| 2013-12-01 19:00:00 | NQ | Futures | 4056.76 | 4059.67 | 4055.6 | 4057.63 | 1014.0 |
| 2013-12-01 20:00:00 | NQ | Futures | 4057.63 | 4059.67 | 4056.18 | 4058.79 | 961.0 |
| 2013-12-01 21:00:00 | NQ | Futures | 4058.79 | 4060.54 | 4058.5 | 4060.25 | 1145.0 |
| 2013-12-01 22:00:00 | NQ | Futures | 4060.25 | 4060.83 | 4057.63 | 4058.79 | 808.0 |
| 2013-12-01 23:00:00 | NQ | Futures | 4059.08 | 4059.38 | 4057.34 | 4057.63 | 310.0 |
| 2013-12-01 18:00:00 | YM | Futures | 16438.0 | 16448.2 | 16431.9 | 16433.9 | 917.0 |
| 2013-12-01 19:00:00 | YM | Futures | 16434.9 | 16447.2 | 16432.9 | 16438.0 | 752.0 |
| 2013-12-01 20:00:00 | YM | Futures | 16437.0 | 16441.1 | 16431.9 | 16440.0 | 865.0 |
| 2013-12-01 21:00:00 | YM | Futures | 16439.0 | 16445.1 | 16434.9 | 16441.1 | 741.0 |
| 2013-12-01 22:00:00 | YM | Futures | 16441.1 | 16442.1 | 16428.8 | 16432.9 | 503.0 |
| 2013-12-01 23:00:00 | YM | Futures | 16433.9 | 16433.9 | 16426.8 | 16427.8 | 276.0 |
| 2013-12-01 18:00:00 | CL | Futures | 146.51 | 146.7 | 146.39 | 146.65 | 1141.0 |
| 2013-12-01 19:00:00 | CL | Futures | 146.63 | 147.28 | 146.63 | 147.07 | 1606.0 |
| 2013-12-01 20:00:00 | CL | Futures | 147.07 | 147.22 | 146.95 | 147.15 | 781.0 |
| 2013-12-01 21:00:00 | CL | Futures | 147.19 | 147.45 | 147.15 | 147.25 | 848.0 |
| 2013-12-01 22:00:00 | CL | Futures | 147.25 | 147.39 | 147.15 | 147.28 | 493.0 |
| 2013-12-01 23:00:00 | CL | Futures | 147.28 | 147.44 | 147.22 | 147.22 | 384.0 |
| 2013-12-01 18:00:00 | GC | Futures | 1714.3 | 1715.1 | 1709.6 | 1710.2 | 1484.0 |
| 2013-12-01 19:00:00 | GC | Futures | 1710.3 | 1711.5 | 1709.2 | 1709.9 | 1818.0 |
| 2013-12-01 20:00:00 | GC | Futures | 1710.0 | 1710.9 | 1706.9 | 1709.6 | 2707.0 |
| 2013-12-01 21:00:00 | GC | Futures | 1709.6 | 1710.7 | 1708.8 | 1709.6 | 1519.0 |
| 2013-12-01 22:00:00 | GC | Futures | 1709.6 | 1709.6 | 1707.3 | 1708.3 | 1041.0 |
| 2013-12-01 23:00:00 | GC | Futures | 1708.0 | 1708.8 | 1707.6 | 1708.0 | 505.0 |
| 2013-12-01 18:00:00 | ZN | Futures | 115.628958 | 115.714651 | 115.628958 | 115.714651 | 115.0 |
| 2013-12-01 19:00:00 | ZN | Futures | 115.700369 | 115.700369 | 115.671804 | 115.686087 | 63.0 |
| 2013-12-01 20:00:00 | ZN | Futures | 115.686087 | 115.700369 | 115.671804 | 115.686087 | 558.0 |
| 2013-12-01 21:00:00 | ZN | Futures | 115.671804 | 115.671804 | 115.614675 | 115.614675 | 520.0 |
| 2013-12-01 22:00:00 | ZN | Futures | 115.628958 | 115.657522 | 115.628958 | 115.657522 | 239.0 |
| 2013-12-01 23:00:00 | ZN | Futures | 115.64324 | 115.64324 | 115.600393 | 115.614675 | 515.0 |
> showing 36 of 268 rows — these rows as CSV