PREVIEW / futures_1hour / 2013-12-29
file: by_date/futures_1hour/2013/2013-12-29.parquet size: 13 KB rows: 257
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-29 18:00:00 | ES | Futures | 1899.55 | 1900.33 | 1898.52 | 1899.81 | 2840.0 |
| 2013-12-29 19:00:00 | ES | Futures | 1900.07 | 1900.07 | 1898.77 | 1898.77 | 1849.0 |
| 2013-12-29 20:00:00 | ES | Futures | 1899.03 | 1899.55 | 1898.77 | 1899.03 | 1728.0 |
| 2013-12-29 21:00:00 | ES | Futures | 1899.03 | 1899.29 | 1898.52 | 1899.29 | 1119.0 |
| 2013-12-29 22:00:00 | ES | Futures | 1899.03 | 1899.55 | 1899.03 | 1899.55 | 777.0 |
| 2013-12-29 23:00:00 | ES | Futures | 1899.55 | 1899.81 | 1899.29 | 1899.55 | 832.0 |
| 2013-12-29 18:00:00 | NQ | Futures | 4150.69 | 4152.43 | 4148.65 | 4151.27 | 337.0 |
| 2013-12-29 19:00:00 | NQ | Futures | 4151.27 | 4151.56 | 4149.82 | 4150.69 | 196.0 |
| 2013-12-29 20:00:00 | NQ | Futures | 4150.69 | 4152.14 | 4149.82 | 4151.85 | 354.0 |
| 2013-12-29 21:00:00 | NQ | Futures | 4151.56 | 4152.43 | 4150.98 | 4152.43 | 205.0 |
| 2013-12-29 22:00:00 | NQ | Futures | 4152.14 | 4153.59 | 4151.56 | 4153.01 | 276.0 |
| 2013-12-29 23:00:00 | NQ | Futures | 4153.01 | 4153.59 | 4152.43 | 4153.3 | 134.0 |
| 2013-12-29 18:00:00 | YM | Futures | 16834.0 | 16838.1 | 16822.8 | 16836.1 | 293.0 |
| 2013-12-29 19:00:00 | YM | Futures | 16837.1 | 16837.1 | 16828.9 | 16829.9 | 249.0 |
| 2013-12-29 20:00:00 | YM | Futures | 16831.0 | 16837.1 | 16829.9 | 16835.1 | 261.0 |
| 2013-12-29 21:00:00 | YM | Futures | 16834.0 | 16836.1 | 16832.0 | 16835.1 | 206.0 |
| 2013-12-29 22:00:00 | YM | Futures | 16834.0 | 16836.1 | 16829.9 | 16833.0 | 241.0 |
| 2013-12-29 23:00:00 | YM | Futures | 16833.0 | 16836.1 | 16832.0 | 16834.0 | 140.0 |
| 2013-12-29 18:00:00 | CL | Futures | 157.71 | 157.86 | 157.68 | 157.85 | 407.0 |
| 2013-12-29 19:00:00 | CL | Futures | 157.86 | 157.97 | 157.75 | 157.85 | 580.0 |
| 2013-12-29 20:00:00 | CL | Futures | 157.86 | 157.96 | 157.8 | 157.88 | 421.0 |
| 2013-12-29 21:00:00 | CL | Futures | 157.88 | 157.91 | 157.79 | 157.8 | 320.0 |
| 2013-12-29 22:00:00 | CL | Futures | 157.82 | 157.88 | 157.69 | 157.71 | 242.0 |
| 2013-12-29 23:00:00 | CL | Futures | 157.71 | 158.08 | 157.69 | 158.08 | 410.0 |
| 2013-12-29 18:00:00 | GC | Futures | 1663.8 | 1666.6 | 1662.5 | 1662.5 | 1105.0 |
| 2013-12-29 19:00:00 | GC | Futures | 1662.5 | 1663.4 | 1661.6 | 1661.9 | 855.0 |
| 2013-12-29 20:00:00 | GC | Futures | 1661.8 | 1663.4 | 1657.4 | 1659.5 | 4033.0 |
| 2013-12-29 21:00:00 | GC | Futures | 1659.5 | 1659.7 | 1657.5 | 1658.8 | 2250.0 |
| 2013-12-29 22:00:00 | GC | Futures | 1658.8 | 1658.9 | 1657.5 | 1658.4 | 694.0 |
| 2013-12-29 23:00:00 | GC | Futures | 1658.1 | 1658.6 | 1657.3 | 1657.7 | 737.0 |
| 2013-12-29 18:00:00 | ZN | Futures | 113.758884 | 113.773332 | 113.701095 | 113.72999 | 2336.0 |
| 2013-12-29 19:00:00 | ZN | Futures | 113.72999 | 113.802227 | 113.72999 | 113.787779 | 3760.0 |
| 2013-12-29 20:00:00 | ZN | Futures | 113.787779 | 113.787779 | 113.758884 | 113.773332 | 1705.0 |
| 2013-12-29 21:00:00 | ZN | Futures | 113.787779 | 113.831122 | 113.787779 | 113.816674 | 3421.0 |
| 2013-12-29 22:00:00 | ZN | Futures | 113.831122 | 113.831122 | 113.802227 | 113.802227 | 1844.0 |
| 2013-12-29 23:00:00 | ZN | Futures | 113.802227 | 113.802227 | 113.773332 | 113.787779 | 1071.0 |
> showing 36 of 257 rows — these rows as CSV