PREVIEW / futures_1hour / 2014-04-06
file: by_date/futures_1hour/2014/2014-04-06.parquet size: 13 KB rows: 263
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-06 18:00:00 | ES | Futures | 1932.99 | 1933.77 | 1929.88 | 1931.95 | 10022.0 |
| 2014-04-06 19:00:00 | ES | Futures | 1931.69 | 1932.73 | 1929.36 | 1930.14 | 4652.0 |
| 2014-04-06 20:00:00 | ES | Futures | 1930.14 | 1931.43 | 1927.8 | 1929.88 | 8317.0 |
| 2014-04-06 21:00:00 | ES | Futures | 1929.88 | 1931.69 | 1929.62 | 1931.43 | 5857.0 |
| 2014-04-06 22:00:00 | ES | Futures | 1931.17 | 1932.21 | 1930.4 | 1930.91 | 4763.0 |
| 2014-04-06 23:00:00 | ES | Futures | 1930.91 | 1931.17 | 1929.88 | 1930.4 | 2245.0 |
| 2014-04-06 18:00:00 | NQ | Futures | 4123.12 | 4125.45 | 4114.1 | 4119.63 | 2715.0 |
| 2014-04-06 19:00:00 | NQ | Futures | 4119.05 | 4121.96 | 4112.35 | 4114.39 | 1168.0 |
| 2014-04-06 20:00:00 | NQ | Futures | 4113.81 | 4117.88 | 4109.44 | 4114.97 | 1392.0 |
| 2014-04-06 21:00:00 | NQ | Futures | 4114.97 | 4117.59 | 4113.22 | 4117.3 | 935.0 |
| 2014-04-06 22:00:00 | NQ | Futures | 4117.3 | 4119.92 | 4114.39 | 4116.72 | 591.0 |
| 2014-04-06 23:00:00 | NQ | Futures | 4116.72 | 4116.72 | 4113.51 | 4113.81 | 216.0 |
| 2014-04-06 18:00:00 | YM | Futures | 16842.3 | 16851.6 | 16815.5 | 16838.2 | 1121.0 |
| 2014-04-06 19:00:00 | YM | Futures | 16838.2 | 16845.4 | 16821.7 | 16826.9 | 475.0 |
| 2014-04-06 20:00:00 | YM | Futures | 16825.8 | 16839.2 | 16811.4 | 16824.8 | 1101.0 |
| 2014-04-06 21:00:00 | YM | Futures | 16823.8 | 16838.2 | 16822.8 | 16835.1 | 521.0 |
| 2014-04-06 22:00:00 | YM | Futures | 16837.2 | 16843.4 | 16828.9 | 16832.0 | 726.0 |
| 2014-04-06 23:00:00 | YM | Futures | 16832.0 | 16833.1 | 16828.9 | 16832.0 | 705.0 |
| 2014-04-06 18:00:00 | CL | Futures | 160.1 | 160.27 | 160.07 | 160.19 | 800.0 |
| 2014-04-06 19:00:00 | CL | Futures | 160.18 | 160.37 | 160.15 | 160.31 | 436.0 |
| 2014-04-06 20:00:00 | CL | Futures | 160.32 | 160.34 | 160.02 | 160.12 | 716.0 |
| 2014-04-06 21:00:00 | CL | Futures | 160.1 | 160.13 | 159.92 | 160.02 | 573.0 |
| 2014-04-06 22:00:00 | CL | Futures | 160.04 | 160.05 | 159.99 | 160.02 | 238.0 |
| 2014-04-06 23:00:00 | CL | Futures | 160.0 | 160.05 | 159.96 | 160.05 | 194.0 |
| 2014-04-06 18:00:00 | GC | Futures | 1786.3 | 1787.4 | 1782.9 | 1783.1 | 944.0 |
| 2014-04-06 19:00:00 | GC | Futures | 1782.9 | 1786.8 | 1782.2 | 1786.6 | 785.0 |
| 2014-04-06 20:00:00 | GC | Futures | 1786.8 | 1786.9 | 1784.6 | 1785.9 | 914.0 |
| 2014-04-06 21:00:00 | GC | Futures | 1785.9 | 1786.9 | 1785.8 | 1786.5 | 643.0 |
| 2014-04-06 22:00:00 | GC | Futures | 1786.6 | 1786.8 | 1783.9 | 1784.3 | 935.0 |
| 2014-04-06 23:00:00 | GC | Futures | 1784.3 | 1785.4 | 1783.6 | 1784.8 | 770.0 |
| 2014-04-06 18:00:00 | ZN | Futures | 115.767798 | 115.855567 | 115.767798 | 115.826311 | 6908.0 |
| 2014-04-06 19:00:00 | ZN | Futures | 115.811683 | 115.840939 | 115.811683 | 115.826311 | 3285.0 |
| 2014-04-06 20:00:00 | ZN | Futures | 115.811683 | 115.884824 | 115.811683 | 115.840939 | 9373.0 |
| 2014-04-06 21:00:00 | ZN | Futures | 115.855567 | 115.855567 | 115.811683 | 115.826311 | 4678.0 |
| 2014-04-06 22:00:00 | ZN | Futures | 115.826311 | 115.826311 | 115.811683 | 115.811683 | 4046.0 |
| 2014-04-06 23:00:00 | ZN | Futures | 115.811683 | 115.855567 | 115.811683 | 115.826311 | 5052.0 |
> showing 36 of 263 rows — these rows as CSV