PREVIEW / futures_1hour / 2014-01-05
file: by_date/futures_1hour/2014/2014-01-05.parquet size: 14 KB rows: 274
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-01-05 18:00:00 | ES | Futures | 1887.13 | 1891.27 | 1886.88 | 1890.24 | 9365.0 |
| 2014-01-05 19:00:00 | ES | Futures | 1890.5 | 1891.01 | 1889.72 | 1890.24 | 4168.0 |
| 2014-01-05 20:00:00 | ES | Futures | 1890.24 | 1890.24 | 1887.13 | 1888.17 | 7718.0 |
| 2014-01-05 21:00:00 | ES | Futures | 1888.17 | 1888.69 | 1886.1 | 1886.62 | 5625.0 |
| 2014-01-05 22:00:00 | ES | Futures | 1886.62 | 1887.91 | 1886.1 | 1887.65 | 3914.0 |
| 2014-01-05 23:00:00 | ES | Futures | 1887.65 | 1888.69 | 1887.13 | 1888.43 | 2341.0 |
| 2014-01-05 18:00:00 | NQ | Futures | 4105.05 | 4116.39 | 4105.05 | 4114.06 | 1387.0 |
| 2014-01-05 19:00:00 | NQ | Futures | 4114.06 | 4115.81 | 4112.32 | 4113.48 | 575.0 |
| 2014-01-05 20:00:00 | NQ | Futures | 4113.48 | 4113.77 | 4106.5 | 4107.96 | 1231.0 |
| 2014-01-05 21:00:00 | NQ | Futures | 4108.25 | 4109.12 | 4103.02 | 4104.76 | 887.0 |
| 2014-01-05 22:00:00 | NQ | Futures | 4104.76 | 4107.38 | 4103.31 | 4106.79 | 508.0 |
| 2014-01-05 23:00:00 | NQ | Futures | 4106.5 | 4108.83 | 4106.21 | 4107.96 | 225.0 |
| 2014-01-05 18:00:00 | YM | Futures | 16815.6 | 16844.3 | 16808.4 | 16837.1 | 620.0 |
| 2014-01-05 19:00:00 | YM | Futures | 16838.1 | 16843.3 | 16835.1 | 16837.1 | 566.0 |
| 2014-01-05 20:00:00 | YM | Futures | 16838.1 | 16838.1 | 16812.5 | 16818.7 | 943.0 |
| 2014-01-05 21:00:00 | YM | Futures | 16818.7 | 16823.8 | 16803.3 | 16809.4 | 764.0 |
| 2014-01-05 22:00:00 | YM | Futures | 16809.4 | 16818.7 | 16804.3 | 16816.6 | 702.0 |
| 2014-01-05 23:00:00 | YM | Futures | 16815.6 | 16821.7 | 16813.5 | 16820.7 | 405.0 |
| 2014-01-05 18:00:00 | CL | Futures | 148.31 | 148.48 | 148.1 | 148.31 | 1050.0 |
| 2014-01-05 19:00:00 | CL | Futures | 148.32 | 148.37 | 148.13 | 148.23 | 773.0 |
| 2014-01-05 20:00:00 | CL | Futures | 148.23 | 148.42 | 148.16 | 148.32 | 811.0 |
| 2014-01-05 21:00:00 | CL | Futures | 148.34 | 148.35 | 148.23 | 148.23 | 497.0 |
| 2014-01-05 22:00:00 | CL | Futures | 148.23 | 148.23 | 147.96 | 147.99 | 835.0 |
| 2014-01-05 23:00:00 | CL | Futures | 147.98 | 148.1 | 147.88 | 148.09 | 939.0 |
| 2014-01-05 18:00:00 | GC | Futures | 1695.6 | 1696.7 | 1690.6 | 1690.7 | 1606.0 |
| 2014-01-05 19:00:00 | GC | Futures | 1690.7 | 1693.4 | 1689.1 | 1692.3 | 2544.0 |
| 2014-01-05 20:00:00 | GC | Futures | 1692.2 | 1705.1 | 1691.4 | 1701.9 | 8114.0 |
| 2014-01-05 21:00:00 | GC | Futures | 1701.8 | 1707.6 | 1701.3 | 1705.5 | 4425.0 |
| 2014-01-05 22:00:00 | GC | Futures | 1705.5 | 1705.8 | 1699.8 | 1700.0 | 3217.0 |
| 2014-01-05 23:00:00 | GC | Futures | 1700.3 | 1700.4 | 1696.7 | 1698.0 | 2829.0 |
| 2014-01-05 18:00:00 | ZN | Futures | 113.816674 | 113.831122 | 113.6722 | 113.72999 | 10631.0 |
| 2014-01-05 19:00:00 | ZN | Futures | 113.744437 | 113.802227 | 113.701095 | 113.744437 | 5540.0 |
| 2014-01-05 20:00:00 | ZN | Futures | 113.744437 | 113.816674 | 113.72999 | 113.802227 | 5363.0 |
| 2014-01-05 21:00:00 | ZN | Futures | 113.787779 | 113.860016 | 113.787779 | 113.845569 | 4805.0 |
| 2014-01-05 22:00:00 | ZN | Futures | 113.845569 | 113.932253 | 113.845569 | 113.845569 | 10386.0 |
| 2014-01-05 23:00:00 | ZN | Futures | 113.845569 | 113.888911 | 113.831122 | 113.874464 | 3023.0 |
> showing 36 of 274 rows — these rows as CSV