PREVIEW / futures_1hour / 2014-12-14
file: by_date/futures_1hour/2014/2014-12-14.parquet size: 15 KB rows: 284
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-12-14 18:00:00 | ES | Futures | 2095.22 | 2098.37 | 2092.32 | 2095.22 | 18641.0 |
| 2014-12-14 19:00:00 | ES | Futures | 2095.22 | 2100.74 | 2094.69 | 2099.69 | 12862.0 |
| 2014-12-14 20:00:00 | ES | Futures | 2099.69 | 2101.79 | 2098.9 | 2100.21 | 8152.0 |
| 2014-12-14 21:00:00 | ES | Futures | 2100.21 | 2101.79 | 2099.69 | 2101.79 | 4974.0 |
| 2014-12-14 22:00:00 | ES | Futures | 2101.53 | 2105.21 | 2101.53 | 2104.16 | 10378.0 |
| 2014-12-14 23:00:00 | ES | Futures | 2104.16 | 2105.48 | 2103.37 | 2103.64 | 3469.0 |
| 2014-12-14 18:00:00 | NQ | Futures | 4916.05 | 4923.98 | 4910.76 | 4914.29 | 2354.0 |
| 2014-12-14 19:00:00 | NQ | Futures | 4914.29 | 4929.85 | 4913.7 | 4926.62 | 3595.0 |
| 2014-12-14 20:00:00 | NQ | Futures | 4926.62 | 4930.44 | 4924.57 | 4927.5 | 1862.0 |
| 2014-12-14 21:00:00 | NQ | Futures | 4927.5 | 4933.67 | 4926.33 | 4933.38 | 1098.0 |
| 2014-12-14 22:00:00 | NQ | Futures | 4933.38 | 4938.96 | 4933.08 | 4935.43 | 1708.0 |
| 2014-12-14 23:00:00 | NQ | Futures | 4935.43 | 4941.01 | 4935.14 | 4936.31 | 688.0 |
| 2014-12-14 18:00:00 | YM | Futures | 17941.1 | 17970.3 | 17919.2 | 17942.2 | 2922.0 |
| 2014-12-14 19:00:00 | YM | Futures | 17940.1 | 17989.1 | 17939.0 | 17980.8 | 2090.0 |
| 2014-12-14 20:00:00 | YM | Futures | 17978.7 | 17996.4 | 17973.5 | 17985.0 | 1504.0 |
| 2014-12-14 21:00:00 | YM | Futures | 17982.9 | 17999.6 | 17979.7 | 17998.5 | 1346.0 |
| 2014-12-14 22:00:00 | YM | Futures | 17998.5 | 18024.6 | 17998.5 | 18012.1 | 1531.0 |
| 2014-12-14 23:00:00 | YM | Futures | 18013.1 | 18029.8 | 18004.8 | 18009.0 | 1737.0 |
| 2014-12-14 18:00:00 | CL | Futures | 96.84 | 97.45 | 96.11 | 96.75 | 3803.0 |
| 2014-12-14 19:00:00 | CL | Futures | 96.75 | 97.4 | 96.3 | 97.32 | 1091.0 |
| 2014-12-14 20:00:00 | CL | Futures | 97.3 | 97.72 | 96.99 | 97.67 | 825.0 |
| 2014-12-14 21:00:00 | CL | Futures | 97.69 | 99.44 | 97.45 | 99.41 | 1847.0 |
| 2014-12-14 22:00:00 | CL | Futures | 99.46 | 100.38 | 99.31 | 99.46 | 1690.0 |
| 2014-12-14 23:00:00 | CL | Futures | 99.48 | 99.65 | 98.86 | 99.46 | 508.0 |
| 2014-12-14 18:00:00 | GC | Futures | 1671.7 | 1675.8 | 1671.1 | 1672.4 | 1230.0 |
| 2014-12-14 19:00:00 | GC | Futures | 1672.6 | 1675.6 | 1671.9 | 1672.7 | 2066.0 |
| 2014-12-14 20:00:00 | GC | Futures | 1672.7 | 1673.1 | 1660.8 | 1665.3 | 9588.0 |
| 2014-12-14 21:00:00 | GC | Futures | 1665.3 | 1667.2 | 1664.8 | 1666.0 | 2353.0 |
| 2014-12-14 22:00:00 | GC | Futures | 1665.9 | 1666.7 | 1665.0 | 1666.0 | 1315.0 |
| 2014-12-14 23:00:00 | GC | Futures | 1666.0 | 1666.4 | 1664.4 | 1665.7 | 1286.0 |
| 2014-12-14 18:00:00 | ZN | Futures | 121.359913 | 121.597641 | 121.345056 | 121.478777 | 17367.0 |
| 2014-12-14 19:00:00 | ZN | Futures | 121.478777 | 121.567925 | 121.404487 | 121.419345 | 12783.0 |
| 2014-12-14 20:00:00 | ZN | Futures | 121.434203 | 121.434203 | 121.374771 | 121.419345 | 8109.0 |
| 2014-12-14 21:00:00 | ZN | Futures | 121.419345 | 121.478777 | 121.389629 | 121.419345 | 6325.0 |
| 2014-12-14 22:00:00 | ZN | Futures | 121.404487 | 121.404487 | 121.300482 | 121.330198 | 7720.0 |
| 2014-12-14 23:00:00 | ZN | Futures | 121.330198 | 121.345056 | 121.300482 | 121.300482 | 2399.0 |
> showing 36 of 284 rows — these rows as CSV