PREVIEW / futures_1hour / 2013-04-21
file: by_date/futures_1hour/2013/2013-04-21.parquet size: 14 KB rows: 276
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-04-21 18:00:00 | ES | Futures | 1595.48 | 1599.08 | 1595.22 | 1597.54 | 8621.0 |
| 2013-04-21 19:00:00 | ES | Futures | 1597.54 | 1598.57 | 1597.02 | 1597.8 | 4433.0 |
| 2013-04-21 20:00:00 | ES | Futures | 1597.8 | 1599.86 | 1597.28 | 1599.6 | 6690.0 |
| 2013-04-21 21:00:00 | ES | Futures | 1599.34 | 1604.75 | 1598.83 | 1601.66 | 16818.0 |
| 2013-04-21 22:00:00 | ES | Futures | 1601.66 | 1602.17 | 1600.63 | 1601.66 | 3792.0 |
| 2013-04-21 23:00:00 | ES | Futures | 1601.66 | 1603.98 | 1601.14 | 1603.72 | 4438.0 |
| 2013-04-21 18:00:00 | NQ | Futures | 3234.6 | 3241.01 | 3232.56 | 3239.56 | 992.0 |
| 2013-04-21 19:00:00 | NQ | Futures | 3239.26 | 3240.72 | 3237.81 | 3238.68 | 241.0 |
| 2013-04-21 20:00:00 | NQ | Futures | 3238.97 | 3244.22 | 3238.1 | 3243.93 | 785.0 |
| 2013-04-21 21:00:00 | NQ | Futures | 3243.93 | 3251.51 | 3242.18 | 3246.56 | 1548.0 |
| 2013-04-21 22:00:00 | NQ | Futures | 3246.26 | 3248.6 | 3244.81 | 3246.56 | 388.0 |
| 2013-04-21 23:00:00 | NQ | Futures | 3246.85 | 3250.64 | 3245.97 | 3250.06 | 265.0 |
| 2013-04-21 18:00:00 | YM | Futures | 14633.4 | 14660.7 | 14633.4 | 14654.7 | 476.0 |
| 2013-04-21 19:00:00 | YM | Futures | 14654.7 | 14660.7 | 14648.6 | 14656.7 | 231.0 |
| 2013-04-21 20:00:00 | YM | Futures | 14657.7 | 14672.9 | 14651.6 | 14669.8 | 805.0 |
| 2013-04-21 21:00:00 | YM | Futures | 14669.8 | 14709.3 | 14665.8 | 14688.0 | 1757.0 |
| 2013-04-21 22:00:00 | YM | Futures | 14687.0 | 14692.1 | 14680.9 | 14687.0 | 550.0 |
| 2013-04-21 23:00:00 | YM | Futures | 14686.0 | 14704.2 | 14685.0 | 14702.2 | 394.0 |
| 2013-04-21 18:00:00 | CL | Futures | 138.51 | 138.84 | 138.43 | 138.74 | 459.0 |
| 2013-04-21 19:00:00 | CL | Futures | 138.73 | 138.82 | 138.52 | 138.55 | 258.0 |
| 2013-04-21 20:00:00 | CL | Futures | 138.55 | 138.84 | 138.44 | 138.77 | 755.0 |
| 2013-04-21 21:00:00 | CL | Futures | 138.79 | 139.18 | 138.62 | 139.01 | 1367.0 |
| 2013-04-21 22:00:00 | CL | Futures | 139.02 | 139.45 | 139.02 | 139.37 | 1107.0 |
| 2013-04-21 23:00:00 | CL | Futures | 139.39 | 139.39 | 139.2 | 139.34 | 377.0 |
| 2013-04-21 18:00:00 | GC | Futures | 1934.2 | 1934.8 | 1928.3 | 1932.2 | 2642.0 |
| 2013-04-21 19:00:00 | GC | Futures | 1932.2 | 1934.5 | 1929.0 | 1934.0 | 2677.0 |
| 2013-04-21 20:00:00 | GC | Futures | 1933.8 | 1945.2 | 1927.7 | 1942.1 | 5755.0 |
| 2013-04-21 21:00:00 | GC | Futures | 1942.4 | 1952.1 | 1941.4 | 1948.3 | 11217.0 |
| 2013-04-21 22:00:00 | GC | Futures | 1948.3 | 1953.5 | 1945.2 | 1952.5 | 4432.0 |
| 2013-04-21 23:00:00 | GC | Futures | 1952.2 | 1953.5 | 1950.3 | 1952.5 | 3010.0 |
| 2013-04-21 18:00:00 | ZN | Futures | 119.484531 | 119.512616 | 119.484531 | 119.498573 | 3115.0 |
| 2013-04-21 19:00:00 | ZN | Futures | 119.498573 | 119.512616 | 119.470489 | 119.470489 | 1545.0 |
| 2013-04-21 20:00:00 | ZN | Futures | 119.470489 | 119.470489 | 119.414321 | 119.414321 | 9333.0 |
| 2013-04-21 21:00:00 | ZN | Futures | 119.428363 | 119.428363 | 119.358152 | 119.386236 | 12098.0 |
| 2013-04-21 22:00:00 | ZN | Futures | 119.386236 | 119.414321 | 119.372194 | 119.400278 | 3843.0 |
| 2013-04-21 23:00:00 | ZN | Futures | 119.400278 | 119.400278 | 119.372194 | 119.386236 | 2022.0 |
> showing 36 of 276 rows — these rows as CSV