PREVIEW / futures_1hour / 2021-12-08
file: by_date/futures_1hour/2021/2021-12-08.parquet size: 66 KB rows: 2,012
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-08 00:00:00 | ES | Futures | 5307.85 | 5309.83 | 5302.77 | 5309.26 | 6007.0 |
| 2021-12-08 01:00:00 | ES | Futures | 5309.26 | 5310.11 | 5303.34 | 5303.9 | 4709.0 |
| 2021-12-08 02:00:00 | ES | Futures | 5304.18 | 5306.72 | 5295.15 | 5301.08 | 8923.0 |
| 2021-12-08 03:00:00 | ES | Futures | 5301.36 | 5307.57 | 5296.84 | 5307.0 | 19660.0 |
| 2021-12-08 04:00:00 | ES | Futures | 5307.0 | 5307.29 | 5297.13 | 5300.51 | 12015.0 |
| 2021-12-08 05:00:00 | ES | Futures | 5300.51 | 5301.08 | 5288.66 | 5288.94 | 17876.0 |
| 2021-12-08 06:00:00 | ES | Futures | 5288.66 | 5319.14 | 5284.43 | 5308.7 | 62213.0 |
| 2021-12-08 07:00:00 | ES | Futures | 5308.7 | 5316.6 | 5294.3 | 5300.51 | 35767.0 |
| 2021-12-08 08:00:00 | ES | Futures | 5300.51 | 5302.49 | 5294.87 | 5296.84 | 23321.0 |
| 2021-12-08 09:00:00 | ES | Futures | 5296.84 | 5301.64 | 5281.61 | 5288.66 | 213374.0 |
| 2021-12-08 10:00:00 | ES | Futures | 5288.38 | 5296.0 | 5275.4 | 5276.53 | 228372.0 |
| 2021-12-08 11:00:00 | ES | Futures | 5276.24 | 5290.35 | 5273.7 | 5288.38 | 131985.0 |
| 2021-12-08 12:00:00 | ES | Futures | 5288.1 | 5292.61 | 5280.76 | 5289.51 | 78955.0 |
| 2021-12-08 13:00:00 | ES | Futures | 5289.79 | 5298.26 | 5288.38 | 5294.02 | 63515.0 |
| 2021-12-08 14:00:00 | ES | Futures | 5294.02 | 5299.95 | 5289.22 | 5299.38 | 90065.0 |
| 2021-12-08 15:00:00 | ES | Futures | 5299.1 | 5309.26 | 5296.84 | 5303.9 | 167757.0 |
| 2021-12-08 16:00:00 | ES | Futures | 5304.18 | 5305.59 | 5301.64 | 5303.05 | 45142.0 |
| 2021-12-08 18:00:00 | ES | Futures | 5302.49 | 5305.31 | 5299.38 | 5301.92 | 6213.0 |
| 2021-12-08 19:00:00 | ES | Futures | 5301.64 | 5303.05 | 5298.54 | 5300.23 | 5044.0 |
| 2021-12-08 20:00:00 | ES | Futures | 5300.23 | 5304.46 | 5299.38 | 5303.9 | 6151.0 |
| 2021-12-08 21:00:00 | ES | Futures | 5303.9 | 5309.83 | 5302.49 | 5309.26 | 6837.0 |
| 2021-12-08 22:00:00 | ES | Futures | 5308.98 | 5312.37 | 5294.3 | 5296.28 | 9494.0 |
| 2021-12-08 23:00:00 | ES | Futures | 5296.0 | 5300.23 | 5291.76 | 5295.72 | 8884.0 |
| 2021-12-08 00:00:00 | NQ | Futures | 19007.08 | 19018.09 | 18990.56 | 19016.93 | 3983.0 |
| 2021-12-08 01:00:00 | NQ | Futures | 19016.35 | 19021.86 | 18992.88 | 18998.96 | 3232.0 |
| 2021-12-08 02:00:00 | NQ | Futures | 18998.67 | 19006.21 | 18968.82 | 18985.05 | 5104.0 |
| 2021-12-08 03:00:00 | NQ | Futures | 18985.63 | 19024.76 | 18967.95 | 19021.57 | 9856.0 |
| 2021-12-08 04:00:00 | NQ | Futures | 19021.57 | 19021.57 | 18961.29 | 18981.57 | 7116.0 |
| 2021-12-08 05:00:00 | NQ | Futures | 18981.57 | 18987.66 | 18950.56 | 18961.29 | 6501.0 |
| 2021-12-08 06:00:00 | NQ | Futures | 18961.29 | 19054.61 | 18948.83 | 18980.71 | 17049.0 |
| 2021-12-08 07:00:00 | NQ | Futures | 18979.84 | 19005.92 | 18940.42 | 18968.53 | 12005.0 |
| 2021-12-08 08:00:00 | NQ | Futures | 18969.69 | 18973.46 | 18916.37 | 18934.04 | 12052.0 |
| 2021-12-08 09:00:00 | NQ | Futures | 18933.75 | 18961.87 | 18839.85 | 18878.69 | 90334.0 |
| 2021-12-08 10:00:00 | NQ | Futures | 18876.95 | 18932.02 | 18843.62 | 18874.63 | 82701.0 |
| 2021-12-08 11:00:00 | NQ | Futures | 18875.21 | 18943.32 | 18844.78 | 18927.09 | 45999.0 |
| 2021-12-08 12:00:00 | NQ | Futures | 18926.51 | 18941.87 | 18883.04 | 18918.68 | 30178.0 |
| 2021-12-08 13:00:00 | NQ | Futures | 18918.97 | 18987.66 | 18910.28 | 18961.0 | 29648.0 |
| 2021-12-08 14:00:00 | NQ | Futures | 18961.29 | 18977.81 | 18917.52 | 18974.91 | 36256.0 |
| 2021-12-08 15:00:00 | NQ | Futures | 18974.62 | 19009.4 | 18949.4 | 18999.25 | 48350.0 |
| 2021-12-08 16:00:00 | NQ | Futures | 18998.38 | 18999.83 | 18979.84 | 18991.72 | 10019.0 |
| 2021-12-08 18:00:00 | NQ | Futures | 18989.4 | 19005.63 | 18979.55 | 18984.76 | 3465.0 |
| 2021-12-08 19:00:00 | NQ | Futures | 18986.21 | 18992.88 | 18979.55 | 18988.24 | 2445.0 |
| 2021-12-08 20:00:00 | NQ | Futures | 18987.37 | 19002.73 | 18984.18 | 18995.2 | 2733.0 |
| 2021-12-08 21:00:00 | NQ | Futures | 18995.49 | 19024.18 | 18990.56 | 19022.44 | 2551.0 |
| 2021-12-08 22:00:00 | NQ | Futures | 19021.57 | 19035.19 | 18971.72 | 18978.39 | 3441.0 |
| 2021-12-08 23:00:00 | NQ | Futures | 18978.68 | 18985.05 | 18962.45 | 18966.79 | 3984.0 |
| 2021-12-08 00:00:00 | YM | Futures | 40134.1 | 40143.1 | 40093.7 | 40138.6 | 1180.0 |
| 2021-12-08 01:00:00 | YM | Futures | 40137.5 | 40147.5 | 40091.5 | 40099.3 | 1175.0 |
| 2021-12-08 02:00:00 | YM | Futures | 40099.3 | 40119.5 | 40033.2 | 40089.3 | 3148.0 |
| 2021-12-08 03:00:00 | YM | Futures | 40090.4 | 40129.6 | 40048.9 | 40116.2 | 5914.0 |
> showing 50 of 2,012 rows — these rows as CSV