PREVIEW / futures_1hour / 2023-11-28
file: by_date/futures_1hour/2023/2023-11-28.parquet size: 68 KB rows: 2,061
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-11-28 00:00:00 | ES | Futures | 4954.31 | 4956.21 | 4953.22 | 4955.4 | 4360.0 |
| 2023-11-28 01:00:00 | ES | Futures | 4955.67 | 4957.84 | 4955.13 | 4957.03 | 4730.0 |
| 2023-11-28 02:00:00 | ES | Futures | 4957.03 | 4957.3 | 4945.62 | 4947.79 | 17060.0 |
| 2023-11-28 03:00:00 | ES | Futures | 4948.06 | 4949.42 | 4942.91 | 4947.52 | 19884.0 |
| 2023-11-28 04:00:00 | ES | Futures | 4947.52 | 4953.22 | 4945.89 | 4952.14 | 13736.0 |
| 2023-11-28 05:00:00 | ES | Futures | 4952.41 | 4953.77 | 4950.51 | 4952.41 | 9835.0 |
| 2023-11-28 06:00:00 | ES | Futures | 4952.41 | 4953.5 | 4948.61 | 4948.61 | 9288.0 |
| 2023-11-28 07:00:00 | ES | Futures | 4948.61 | 4951.05 | 4943.72 | 4944.26 | 16352.0 |
| 2023-11-28 08:00:00 | ES | Futures | 4944.53 | 4947.79 | 4939.1 | 4946.16 | 40967.0 |
| 2023-11-28 09:00:00 | ES | Futures | 4946.16 | 4949.69 | 4941.55 | 4942.91 | 149353.0 |
| 2023-11-28 10:00:00 | ES | Futures | 4942.63 | 4962.73 | 4942.36 | 4960.01 | 240782.0 |
| 2023-11-28 11:00:00 | ES | Futures | 4960.01 | 4971.96 | 4957.03 | 4969.25 | 170491.0 |
| 2023-11-28 12:00:00 | ES | Futures | 4969.25 | 4969.52 | 4953.5 | 4957.03 | 132533.0 |
| 2023-11-28 13:00:00 | ES | Futures | 4956.75 | 4957.03 | 4944.26 | 4951.05 | 167611.0 |
| 2023-11-28 14:00:00 | ES | Futures | 4951.05 | 4957.3 | 4946.44 | 4955.13 | 116377.0 |
| 2023-11-28 15:00:00 | ES | Futures | 4955.4 | 4959.2 | 4946.71 | 4956.75 | 193939.0 |
| 2023-11-28 16:00:00 | ES | Futures | 4956.48 | 4959.2 | 4956.21 | 4957.57 | 40448.0 |
| 2023-11-28 18:00:00 | ES | Futures | 4957.57 | 4958.66 | 4955.94 | 4957.84 | 5134.0 |
| 2023-11-28 19:00:00 | ES | Futures | 4957.57 | 4961.91 | 4957.3 | 4960.83 | 7764.0 |
| 2023-11-28 20:00:00 | ES | Futures | 4960.83 | 4964.63 | 4960.83 | 4962.73 | 12747.0 |
| 2023-11-28 21:00:00 | ES | Futures | 4962.73 | 4964.09 | 4961.64 | 4962.19 | 6614.0 |
| 2023-11-28 22:00:00 | ES | Futures | 4962.46 | 4964.63 | 4960.29 | 4964.09 | 5882.0 |
| 2023-11-28 23:00:00 | ES | Futures | 4963.82 | 4965.44 | 4963.54 | 4963.82 | 4096.0 |
| 2023-11-28 00:00:00 | NQ | Futures | 17575.76 | 17585.65 | 17569.99 | 17581.8 | 2501.0 |
| 2023-11-28 01:00:00 | NQ | Futures | 17581.53 | 17592.79 | 17580.71 | 17588.12 | 3114.0 |
| 2023-11-28 02:00:00 | NQ | Futures | 17588.12 | 17588.67 | 17532.91 | 17546.37 | 9742.0 |
| 2023-11-28 03:00:00 | NQ | Futures | 17546.1 | 17552.69 | 17523.3 | 17546.92 | 12218.0 |
| 2023-11-28 04:00:00 | NQ | Futures | 17547.47 | 17568.9 | 17541.7 | 17567.25 | 7297.0 |
| 2023-11-28 05:00:00 | NQ | Futures | 17567.52 | 17584.55 | 17559.56 | 17583.45 | 6344.0 |
| 2023-11-28 06:00:00 | NQ | Futures | 17583.45 | 17590.32 | 17567.25 | 17567.8 | 6401.0 |
| 2023-11-28 07:00:00 | NQ | Futures | 17568.07 | 17577.41 | 17543.35 | 17546.65 | 8360.0 |
| 2023-11-28 08:00:00 | NQ | Futures | 17546.65 | 17563.95 | 17518.36 | 17563.68 | 19526.0 |
| 2023-11-28 09:00:00 | NQ | Futures | 17563.68 | 17586.75 | 17532.91 | 17542.8 | 76764.0 |
| 2023-11-28 10:00:00 | NQ | Futures | 17543.35 | 17631.24 | 17540.33 | 17592.24 | 110762.0 |
| 2023-11-28 11:00:00 | NQ | Futures | 17592.52 | 17657.06 | 17579.61 | 17638.66 | 70834.0 |
| 2023-11-28 12:00:00 | NQ | Futures | 17639.21 | 17643.6 | 17586.47 | 17603.78 | 49346.0 |
| 2023-11-28 13:00:00 | NQ | Futures | 17604.33 | 17605.43 | 17543.63 | 17581.25 | 65558.0 |
| 2023-11-28 14:00:00 | NQ | Futures | 17581.53 | 17609.0 | 17562.3 | 17601.85 | 50073.0 |
| 2023-11-28 15:00:00 | NQ | Futures | 17602.13 | 17636.19 | 17567.25 | 17630.97 | 59053.0 |
| 2023-11-28 16:00:00 | NQ | Futures | 17630.69 | 17643.05 | 17627.95 | 17635.09 | 12934.0 |
| 2023-11-28 18:00:00 | NQ | Futures | 17639.48 | 17642.23 | 17623.0 | 17636.74 | 4687.0 |
| 2023-11-28 19:00:00 | NQ | Futures | 17636.19 | 17656.24 | 17631.79 | 17651.29 | 4885.0 |
| 2023-11-28 20:00:00 | NQ | Futures | 17651.02 | 17673.54 | 17650.2 | 17658.44 | 8276.0 |
| 2023-11-28 21:00:00 | NQ | Futures | 17658.16 | 17665.85 | 17649.92 | 17652.39 | 4217.0 |
| 2023-11-28 22:00:00 | NQ | Futures | 17652.67 | 17660.08 | 17643.6 | 17658.16 | 3161.0 |
| 2023-11-28 23:00:00 | NQ | Futures | 17658.16 | 17663.1 | 17656.51 | 17661.18 | 2032.0 |
| 2023-11-28 00:00:00 | YM | Futures | 38381.1 | 38395.2 | 38378.9 | 38389.8 | 555.0 |
| 2023-11-28 01:00:00 | YM | Futures | 38389.8 | 38406.0 | 38387.6 | 38401.7 | 694.0 |
| 2023-11-28 02:00:00 | YM | Futures | 38402.8 | 38402.8 | 38342.0 | 38355.0 | 2222.0 |
| 2023-11-28 03:00:00 | YM | Futures | 38355.0 | 38367.0 | 38324.7 | 38350.7 | 2439.0 |
> showing 50 of 2,061 rows — these rows as CSV