PREVIEW / futures_1hour / 2015-01-04
file: by_date/futures_1hour/2015/2015-01-04.parquet size: 15 KB rows: 282
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-04 18:00:00 | ES | Futures | 2153.37 | 2153.9 | 2146.27 | 2147.85 | 16891.0 |
| 2015-01-04 19:00:00 | ES | Futures | 2147.58 | 2148.9 | 2143.64 | 2146.0 | 11423.0 |
| 2015-01-04 20:00:00 | ES | Futures | 2146.27 | 2151.53 | 2145.74 | 2151.0 | 8560.0 |
| 2015-01-04 21:00:00 | ES | Futures | 2151.0 | 2151.27 | 2149.16 | 2149.69 | 3857.0 |
| 2015-01-04 22:00:00 | ES | Futures | 2149.69 | 2154.69 | 2149.69 | 2154.42 | 7879.0 |
| 2015-01-04 23:00:00 | ES | Futures | 2154.42 | 2155.48 | 2152.06 | 2155.21 | 4193.0 |
| 2015-01-04 18:00:00 | NQ | Futures | 4952.76 | 4953.35 | 4935.73 | 4939.25 | 2430.0 |
| 2015-01-04 19:00:00 | NQ | Futures | 4939.25 | 4941.89 | 4930.44 | 4933.97 | 2446.0 |
| 2015-01-04 20:00:00 | NQ | Futures | 4934.26 | 4946.89 | 4934.26 | 4945.42 | 1903.0 |
| 2015-01-04 21:00:00 | NQ | Futures | 4945.71 | 4947.18 | 4942.19 | 4943.36 | 755.0 |
| 2015-01-04 22:00:00 | NQ | Futures | 4943.07 | 4956.87 | 4943.07 | 4956.29 | 2239.0 |
| 2015-01-04 23:00:00 | NQ | Futures | 4956.29 | 4958.05 | 4949.53 | 4957.17 | 1026.0 |
| 2015-01-04 18:00:00 | YM | Futures | 18503.8 | 18507.9 | 18448.4 | 18456.8 | 2024.0 |
| 2015-01-04 19:00:00 | YM | Futures | 18456.8 | 18465.1 | 18429.7 | 18443.2 | 1638.0 |
| 2015-01-04 20:00:00 | YM | Futures | 18445.3 | 18487.1 | 18445.3 | 18481.8 | 1280.0 |
| 2015-01-04 21:00:00 | YM | Futures | 18480.8 | 18487.1 | 18471.4 | 18474.5 | 422.0 |
| 2015-01-04 22:00:00 | YM | Futures | 18475.6 | 18515.3 | 18472.5 | 18514.2 | 1434.0 |
| 2015-01-04 23:00:00 | YM | Futures | 18512.1 | 18520.5 | 18495.4 | 18518.4 | 791.0 |
| 2015-01-04 18:00:00 | CL | Futures | 89.54 | 89.74 | 88.76 | 88.87 | 2877.0 |
| 2015-01-04 19:00:00 | CL | Futures | 88.86 | 89.22 | 88.84 | 88.91 | 1753.0 |
| 2015-01-04 20:00:00 | CL | Futures | 88.89 | 89.15 | 88.62 | 88.72 | 3239.0 |
| 2015-01-04 21:00:00 | CL | Futures | 88.76 | 88.82 | 87.48 | 87.6 | 6853.0 |
| 2015-01-04 22:00:00 | CL | Futures | 87.6 | 88.09 | 87.58 | 88.04 | 3964.0 |
| 2015-01-04 23:00:00 | CL | Futures | 88.04 | 88.24 | 87.82 | 88.16 | 2645.0 |
| 2015-01-04 18:00:00 | GC | Futures | 1625.0 | 1626.3 | 1611.3 | 1619.5 | 4293.0 |
| 2015-01-04 19:00:00 | GC | Futures | 1619.6 | 1628.0 | 1618.0 | 1627.4 | 4136.0 |
| 2015-01-04 20:00:00 | GC | Futures | 1627.6 | 1631.9 | 1627.3 | 1629.9 | 5553.0 |
| 2015-01-04 21:00:00 | GC | Futures | 1629.7 | 1633.7 | 1627.8 | 1632.1 | 3556.0 |
| 2015-01-04 22:00:00 | GC | Futures | 1632.2 | 1633.2 | 1631.4 | 1631.8 | 1948.0 |
| 2015-01-04 23:00:00 | GC | Futures | 1631.7 | 1631.7 | 1629.2 | 1630.1 | 1274.0 |
| 2015-01-04 18:00:00 | ZN | Futures | 120.914174 | 121.122186 | 120.914174 | 121.09247 | 10975.0 |
| 2015-01-04 19:00:00 | ZN | Futures | 121.09247 | 121.137044 | 121.077612 | 121.107328 | 8400.0 |
| 2015-01-04 20:00:00 | ZN | Futures | 121.107328 | 121.107328 | 121.003322 | 121.01818 | 5087.0 |
| 2015-01-04 21:00:00 | ZN | Futures | 121.033038 | 121.077612 | 121.033038 | 121.062754 | 3041.0 |
| 2015-01-04 22:00:00 | ZN | Futures | 121.062754 | 121.107328 | 121.01818 | 121.01818 | 5258.0 |
| 2015-01-04 23:00:00 | ZN | Futures | 121.033038 | 121.077612 | 121.01818 | 121.01818 | 1876.0 |
> showing 36 of 282 rows — these rows as CSV