PREVIEW / futures_1hour / 2016-02-19
file: by_date/futures_1hour/2016/2016-02-19.parquet size: 44 KB rows: 1,294
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-19 00:00:00 | ES | Futures | 2058.85 | 2063.95 | 2058.31 | 2062.88 | 8050.0 |
| 2016-02-19 01:00:00 | ES | Futures | 2062.88 | 2066.64 | 2062.07 | 2064.49 | 7370.0 |
| 2016-02-19 02:00:00 | ES | Futures | 2064.49 | 2065.3 | 2060.46 | 2060.73 | 14037.0 |
| 2016-02-19 03:00:00 | ES | Futures | 2060.46 | 2066.64 | 2058.31 | 2066.1 | 50625.0 |
| 2016-02-19 04:00:00 | ES | Futures | 2065.84 | 2066.37 | 2060.46 | 2063.95 | 17885.0 |
| 2016-02-19 05:00:00 | ES | Futures | 2063.69 | 2064.22 | 2057.24 | 2058.31 | 19120.0 |
| 2016-02-19 06:00:00 | ES | Futures | 2058.04 | 2058.85 | 2049.18 | 2051.06 | 43652.0 |
| 2016-02-19 07:00:00 | ES | Futures | 2051.06 | 2056.43 | 2049.71 | 2055.62 | 38404.0 |
| 2016-02-19 08:00:00 | ES | Futures | 2055.89 | 2056.16 | 2046.49 | 2047.83 | 74839.0 |
| 2016-02-19 09:00:00 | ES | Futures | 2047.83 | 2051.86 | 2040.85 | 2046.49 | 307061.0 |
| 2016-02-19 10:00:00 | ES | Futures | 2046.49 | 2055.09 | 2040.58 | 2050.52 | 263738.0 |
| 2016-02-19 11:00:00 | ES | Futures | 2050.25 | 2059.39 | 2046.76 | 2054.28 | 225361.0 |
| 2016-02-19 12:00:00 | ES | Futures | 2054.01 | 2056.7 | 2052.13 | 2054.28 | 88284.0 |
| 2016-02-19 13:00:00 | ES | Futures | 2054.01 | 2056.16 | 2052.4 | 2055.36 | 66986.0 |
| 2016-02-19 14:00:00 | ES | Futures | 2055.09 | 2058.04 | 2050.79 | 2051.59 | 114046.0 |
| 2016-02-19 15:00:00 | ES | Futures | 2051.59 | 2058.58 | 2051.06 | 2057.77 | 142673.0 |
| 2016-02-19 16:00:00 | ES | Futures | 2057.77 | 2058.31 | 2056.43 | 2057.51 | 63977.0 |
| 2016-02-19 00:00:00 | NQ | Futures | 4930.25 | 4947.77 | 4929.36 | 4943.61 | 1479.0 |
| 2016-02-19 01:00:00 | NQ | Futures | 4943.31 | 4951.92 | 4942.13 | 4946.58 | 818.0 |
| 2016-02-19 02:00:00 | NQ | Futures | 4946.28 | 4948.06 | 4935.3 | 4935.3 | 1449.0 |
| 2016-02-19 03:00:00 | NQ | Futures | 4935.59 | 4952.52 | 4929.36 | 4950.74 | 5565.0 |
| 2016-02-19 04:00:00 | NQ | Futures | 4950.74 | 4951.63 | 4935.3 | 4944.2 | 2347.0 |
| 2016-02-19 05:00:00 | NQ | Futures | 4942.42 | 4944.2 | 4924.01 | 4926.98 | 2385.0 |
| 2016-02-19 06:00:00 | NQ | Futures | 4927.28 | 4928.76 | 4905.01 | 4910.06 | 4633.0 |
| 2016-02-19 07:00:00 | NQ | Futures | 4909.46 | 4925.2 | 4907.98 | 4924.01 | 3117.0 |
| 2016-02-19 08:00:00 | NQ | Futures | 4923.42 | 4926.68 | 4903.52 | 4904.71 | 8089.0 |
| 2016-02-19 09:00:00 | NQ | Futures | 4904.41 | 4927.28 | 4893.73 | 4916.59 | 44427.0 |
| 2016-02-19 10:00:00 | NQ | Futures | 4916.29 | 4948.66 | 4900.26 | 4931.44 | 42789.0 |
| 2016-02-19 11:00:00 | NQ | Futures | 4931.14 | 4958.75 | 4920.45 | 4940.94 | 34316.0 |
| 2016-02-19 12:00:00 | NQ | Futures | 4940.94 | 4951.63 | 4939.16 | 4943.31 | 14434.0 |
| 2016-02-19 13:00:00 | NQ | Futures | 4943.31 | 4948.66 | 4935.89 | 4943.61 | 10452.0 |
| 2016-02-19 14:00:00 | NQ | Futures | 4943.31 | 4948.36 | 4924.01 | 4925.2 | 18298.0 |
| 2016-02-19 15:00:00 | NQ | Futures | 4925.2 | 4949.55 | 4924.61 | 4944.5 | 21888.0 |
| 2016-02-19 16:00:00 | NQ | Futures | 4944.2 | 4944.5 | 4938.56 | 4942.42 | 7588.0 |
| 2016-02-19 00:00:00 | YM | Futures | 17431.9 | 17477.7 | 17427.6 | 17470.2 | 1770.0 |
| 2016-02-19 01:00:00 | YM | Futures | 17468.1 | 17493.6 | 17466.0 | 17483.0 | 1128.0 |
| 2016-02-19 02:00:00 | YM | Futures | 17481.9 | 17487.2 | 17451.1 | 17452.1 | 1373.0 |
| 2016-02-19 03:00:00 | YM | Futures | 17452.1 | 17502.2 | 17438.3 | 17494.7 | 8024.0 |
| 2016-02-19 04:00:00 | YM | Futures | 17496.8 | 17496.8 | 17455.3 | 17476.6 | 2943.0 |
| 2016-02-19 05:00:00 | YM | Futures | 17476.6 | 17479.8 | 17423.4 | 17429.8 | 2712.0 |
| 2016-02-19 06:00:00 | YM | Futures | 17428.7 | 17435.1 | 17361.6 | 17373.4 | 4348.0 |
| 2016-02-19 07:00:00 | YM | Futures | 17373.4 | 17419.1 | 17363.8 | 17412.7 | 3618.0 |
| 2016-02-19 08:00:00 | YM | Futures | 17413.8 | 17418.1 | 17342.5 | 17357.4 | 7896.0 |
| 2016-02-19 09:00:00 | YM | Futures | 17356.3 | 17403.2 | 17303.1 | 17341.4 | 30790.0 |
| 2016-02-19 10:00:00 | YM | Futures | 17341.4 | 17396.8 | 17292.4 | 17361.6 | 23241.0 |
| 2016-02-19 11:00:00 | YM | Futures | 17360.6 | 17422.3 | 17332.9 | 17389.3 | 19164.0 |
| 2016-02-19 12:00:00 | YM | Futures | 17389.3 | 17398.9 | 17367.0 | 17377.6 | 6682.0 |
| 2016-02-19 13:00:00 | YM | Futures | 17375.5 | 17397.8 | 17367.0 | 17392.5 | 4930.0 |
| 2016-02-19 14:00:00 | YM | Futures | 17391.4 | 17413.8 | 17363.8 | 17373.4 | 7088.0 |
| 2016-02-19 15:00:00 | YM | Futures | 17373.4 | 17414.9 | 17369.1 | 17413.8 | 7736.0 |
> showing 50 of 1,294 rows — these rows as CSV