PREVIEW / futures_1hour / 2023-12-04
file: by_date/futures_1hour/2023/2023-12-04.parquet size: 66 KB rows: 2,062
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-04 00:00:00 | ES | Futures | 4991.79 | 4991.79 | 4988.53 | 4988.8 | 4727.0 |
| 2023-12-04 01:00:00 | ES | Futures | 4989.07 | 4990.43 | 4986.35 | 4987.71 | 7628.0 |
| 2023-12-04 02:00:00 | ES | Futures | 4987.98 | 4989.61 | 4981.74 | 4982.55 | 14459.0 |
| 2023-12-04 03:00:00 | ES | Futures | 4982.55 | 4990.7 | 4980.65 | 4987.44 | 22576.0 |
| 2023-12-04 04:00:00 | ES | Futures | 4987.44 | 4988.26 | 4981.2 | 4985.54 | 16964.0 |
| 2023-12-04 05:00:00 | ES | Futures | 4985.81 | 4986.9 | 4981.74 | 4985.0 | 14094.0 |
| 2023-12-04 06:00:00 | ES | Futures | 4985.0 | 4985.81 | 4979.57 | 4980.65 | 13360.0 |
| 2023-12-04 07:00:00 | ES | Futures | 4980.38 | 4984.45 | 4976.58 | 4983.1 | 24036.0 |
| 2023-12-04 08:00:00 | ES | Futures | 4983.1 | 4983.91 | 4968.16 | 4968.7 | 47741.0 |
| 2023-12-04 09:00:00 | ES | Futures | 4968.7 | 4973.32 | 4956.48 | 4963.82 | 266067.0 |
| 2023-12-04 10:00:00 | ES | Futures | 4963.82 | 4967.89 | 4946.16 | 4948.34 | 318006.0 |
| 2023-12-04 11:00:00 | ES | Futures | 4948.06 | 4964.63 | 4946.71 | 4963.54 | 181903.0 |
| 2023-12-04 12:00:00 | ES | Futures | 4963.54 | 4972.51 | 4961.64 | 4971.69 | 142435.0 |
| 2023-12-04 13:00:00 | ES | Futures | 4971.69 | 4971.96 | 4961.64 | 4963.27 | 118655.0 |
| 2023-12-04 14:00:00 | ES | Futures | 4963.0 | 4966.26 | 4958.66 | 4964.09 | 125341.0 |
| 2023-12-04 15:00:00 | ES | Futures | 4964.09 | 4974.68 | 4960.56 | 4971.42 | 288979.0 |
| 2023-12-04 16:00:00 | ES | Futures | 4971.42 | 4972.51 | 4966.26 | 4966.8 | 58995.0 |
| 2023-12-04 18:00:00 | ES | Futures | 4967.35 | 4967.62 | 4962.46 | 4963.82 | 6624.0 |
| 2023-12-04 19:00:00 | ES | Futures | 4963.82 | 4964.63 | 4961.91 | 4962.19 | 5972.0 |
| 2023-12-04 20:00:00 | ES | Futures | 4962.46 | 4963.54 | 4959.47 | 4962.46 | 9969.0 |
| 2023-12-04 21:00:00 | ES | Futures | 4962.19 | 4962.46 | 4959.74 | 4961.91 | 7088.0 |
| 2023-12-04 22:00:00 | ES | Futures | 4961.64 | 4963.27 | 4960.56 | 4963.0 | 5835.0 |
| 2023-12-04 23:00:00 | ES | Futures | 4963.0 | 4963.54 | 4960.01 | 4960.56 | 3818.0 |
| 2023-12-04 00:00:00 | NQ | Futures | 17557.63 | 17557.91 | 17538.41 | 17539.23 | 2817.0 |
| 2023-12-04 01:00:00 | NQ | Futures | 17539.23 | 17551.04 | 17535.94 | 17542.53 | 3797.0 |
| 2023-12-04 02:00:00 | NQ | Futures | 17543.35 | 17551.87 | 17521.38 | 17524.12 | 5132.0 |
| 2023-12-04 03:00:00 | NQ | Futures | 17523.58 | 17582.35 | 17516.43 | 17564.5 | 12591.0 |
| 2023-12-04 04:00:00 | NQ | Futures | 17564.78 | 17570.54 | 17531.54 | 17545.0 | 9095.0 |
| 2023-12-04 05:00:00 | NQ | Futures | 17545.27 | 17552.42 | 17531.27 | 17541.98 | 5146.0 |
| 2023-12-04 06:00:00 | NQ | Futures | 17541.7 | 17548.3 | 17513.69 | 17520.55 | 6983.0 |
| 2023-12-04 07:00:00 | NQ | Futures | 17519.73 | 17542.8 | 17501.05 | 17538.13 | 11679.0 |
| 2023-12-04 08:00:00 | NQ | Futures | 17537.86 | 17543.35 | 17471.94 | 17475.23 | 19820.0 |
| 2023-12-04 09:00:00 | NQ | Futures | 17475.51 | 17477.43 | 17384.05 | 17402.45 | 113108.0 |
| 2023-12-04 10:00:00 | NQ | Futures | 17402.17 | 17436.78 | 17272.26 | 17290.11 | 136496.0 |
| 2023-12-04 11:00:00 | NQ | Futures | 17290.11 | 17392.29 | 17279.95 | 17387.89 | 81639.0 |
| 2023-12-04 12:00:00 | NQ | Futures | 17387.89 | 17434.58 | 17377.73 | 17428.54 | 68502.0 |
| 2023-12-04 13:00:00 | NQ | Futures | 17428.54 | 17429.64 | 17377.45 | 17384.05 | 51109.0 |
| 2023-12-04 14:00:00 | NQ | Futures | 17384.05 | 17405.2 | 17354.38 | 17387.62 | 55352.0 |
| 2023-12-04 15:00:00 | NQ | Futures | 17387.62 | 17452.99 | 17367.29 | 17437.33 | 81414.0 |
| 2023-12-04 16:00:00 | NQ | Futures | 17437.06 | 17440.08 | 17416.73 | 17421.95 | 14347.0 |
| 2023-12-04 18:00:00 | NQ | Futures | 17428.27 | 17428.27 | 17408.22 | 17413.44 | 3045.0 |
| 2023-12-04 19:00:00 | NQ | Futures | 17413.44 | 17417.56 | 17404.1 | 17407.39 | 3552.0 |
| 2023-12-04 20:00:00 | NQ | Futures | 17407.94 | 17413.44 | 17394.21 | 17405.2 | 4321.0 |
| 2023-12-04 21:00:00 | NQ | Futures | 17405.2 | 17405.74 | 17390.36 | 17396.13 | 3574.0 |
| 2023-12-04 22:00:00 | NQ | Futures | 17396.41 | 17401.08 | 17388.99 | 17399.15 | 2870.0 |
| 2023-12-04 23:00:00 | NQ | Futures | 17398.88 | 17404.92 | 17388.72 | 17389.26 | 2416.0 |
| 2023-12-04 00:00:00 | YM | Futures | 39384.5 | 39384.5 | 39369.3 | 39374.8 | 631.0 |
| 2023-12-04 01:00:00 | YM | Futures | 39374.8 | 39376.9 | 39345.5 | 39349.8 | 981.0 |
| 2023-12-04 02:00:00 | YM | Futures | 39352.0 | 39362.8 | 39308.6 | 39318.3 | 3106.0 |
| 2023-12-04 03:00:00 | YM | Futures | 39318.3 | 39353.1 | 39305.3 | 39332.4 | 3259.0 |
> showing 50 of 2,062 rows — these rows as CSV