PREVIEW / futures_1hour / 2023-11-30
file: by_date/futures_1hour/2023/2023-11-30.parquet size: 67 KB rows: 2,088
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-30 00:00:00 | ES | Futures | 4959.2 | 4961.37 | 4958.38 | 4961.1 | 5444.0 |
| 2023-11-30 01:00:00 | ES | Futures | 4961.1 | 4962.19 | 4959.74 | 4960.01 | 5484.0 |
| 2023-11-30 02:00:00 | ES | Futures | 4960.01 | 4961.37 | 4957.3 | 4961.1 | 8606.0 |
| 2023-11-30 03:00:00 | ES | Futures | 4960.83 | 4962.19 | 4951.6 | 4954.31 | 19362.0 |
| 2023-11-30 04:00:00 | ES | Futures | 4954.04 | 4961.37 | 4954.04 | 4960.01 | 16276.0 |
| 2023-11-30 05:00:00 | ES | Futures | 4960.29 | 4964.63 | 4958.66 | 4962.46 | 14108.0 |
| 2023-11-30 06:00:00 | ES | Futures | 4962.73 | 4963.54 | 4960.01 | 4960.56 | 10205.0 |
| 2023-11-30 07:00:00 | ES | Futures | 4960.56 | 4967.62 | 4960.56 | 4966.53 | 21352.0 |
| 2023-11-30 08:00:00 | ES | Futures | 4966.8 | 4973.05 | 4963.27 | 4964.36 | 70882.0 |
| 2023-11-30 09:00:00 | ES | Futures | 4964.09 | 4964.36 | 4945.08 | 4957.03 | 291931.0 |
| 2023-11-30 10:00:00 | ES | Futures | 4957.03 | 4961.1 | 4943.72 | 4954.04 | 322553.0 |
| 2023-11-30 11:00:00 | ES | Futures | 4953.77 | 4956.75 | 4941.28 | 4941.82 | 212052.0 |
| 2023-11-30 12:00:00 | ES | Futures | 4942.09 | 4948.34 | 4938.02 | 4945.08 | 148290.0 |
| 2023-11-30 13:00:00 | ES | Futures | 4945.08 | 4945.62 | 4936.66 | 4943.18 | 113937.0 |
| 2023-11-30 14:00:00 | ES | Futures | 4942.91 | 4956.75 | 4942.63 | 4955.94 | 136813.0 |
| 2023-11-30 15:00:00 | ES | Futures | 4956.21 | 4974.41 | 4942.36 | 4969.25 | 399815.0 |
| 2023-11-30 16:00:00 | ES | Futures | 4969.25 | 4971.42 | 4965.72 | 4965.99 | 109741.0 |
| 2023-11-30 18:00:00 | ES | Futures | 4965.99 | 4967.89 | 4965.17 | 4967.35 | 9257.0 |
| 2023-11-30 19:00:00 | ES | Futures | 4967.07 | 4968.16 | 4965.72 | 4967.62 | 5352.0 |
| 2023-11-30 20:00:00 | ES | Futures | 4967.35 | 4968.7 | 4965.44 | 4967.07 | 7555.0 |
| 2023-11-30 21:00:00 | ES | Futures | 4967.07 | 4971.42 | 4966.8 | 4969.79 | 7902.0 |
| 2023-11-30 22:00:00 | ES | Futures | 4969.79 | 4970.06 | 4965.72 | 4967.35 | 5619.0 |
| 2023-11-30 23:00:00 | ES | Futures | 4967.35 | 4968.97 | 4966.8 | 4968.43 | 3597.0 |
| 2023-11-30 00:00:00 | NQ | Futures | 17639.21 | 17649.1 | 17637.29 | 17648.27 | 3053.0 |
| 2023-11-30 01:00:00 | NQ | Futures | 17648.0 | 17653.77 | 17641.41 | 17643.05 | 3131.0 |
| 2023-11-30 02:00:00 | NQ | Futures | 17643.33 | 17653.77 | 17638.11 | 17652.94 | 4395.0 |
| 2023-11-30 03:00:00 | NQ | Futures | 17653.49 | 17656.51 | 17612.84 | 17618.61 | 10191.0 |
| 2023-11-30 04:00:00 | NQ | Futures | 17618.33 | 17645.25 | 17618.06 | 17636.74 | 8858.0 |
| 2023-11-30 05:00:00 | NQ | Futures | 17637.29 | 17653.22 | 17629.6 | 17646.35 | 5996.0 |
| 2023-11-30 06:00:00 | NQ | Futures | 17646.63 | 17649.92 | 17633.44 | 17634.81 | 5135.0 |
| 2023-11-30 07:00:00 | NQ | Futures | 17635.36 | 17665.03 | 17635.09 | 17659.53 | 8471.0 |
| 2023-11-30 08:00:00 | NQ | Futures | 17660.08 | 17686.73 | 17632.34 | 17633.99 | 29384.0 |
| 2023-11-30 09:00:00 | NQ | Futures | 17633.99 | 17635.09 | 17519.73 | 17553.24 | 121850.0 |
| 2023-11-30 10:00:00 | NQ | Futures | 17552.42 | 17577.41 | 17448.32 | 17490.07 | 130964.0 |
| 2023-11-30 11:00:00 | NQ | Futures | 17489.79 | 17502.7 | 17430.74 | 17431.84 | 69703.0 |
| 2023-11-30 12:00:00 | NQ | Futures | 17432.39 | 17481.83 | 17425.52 | 17473.31 | 46204.0 |
| 2023-11-30 13:00:00 | NQ | Futures | 17473.04 | 17473.86 | 17420.3 | 17441.73 | 42418.0 |
| 2023-11-30 14:00:00 | NQ | Futures | 17442.27 | 17500.78 | 17440.08 | 17495.83 | 47599.0 |
| 2023-11-30 15:00:00 | NQ | Futures | 17496.11 | 17568.9 | 17436.51 | 17557.63 | 93660.0 |
| 2023-11-30 16:00:00 | NQ | Futures | 17557.36 | 17562.3 | 17530.44 | 17531.27 | 22588.0 |
| 2023-11-30 18:00:00 | NQ | Futures | 17529.07 | 17541.98 | 17523.58 | 17538.96 | 3344.0 |
| 2023-11-30 19:00:00 | NQ | Futures | 17539.23 | 17539.23 | 17529.07 | 17533.19 | 2587.0 |
| 2023-11-30 20:00:00 | NQ | Futures | 17533.19 | 17537.58 | 17524.95 | 17527.42 | 3735.0 |
| 2023-11-30 21:00:00 | NQ | Futures | 17527.42 | 17545.82 | 17525.77 | 17537.86 | 3193.0 |
| 2023-11-30 22:00:00 | NQ | Futures | 17538.13 | 17539.51 | 17520.55 | 17526.32 | 2806.0 |
| 2023-11-30 23:00:00 | NQ | Futures | 17526.6 | 17530.72 | 17524.4 | 17529.62 | 1592.0 |
| 2023-11-30 00:00:00 | YM | Futures | 38639.3 | 38655.5 | 38636.0 | 38645.8 | 788.0 |
| 2023-11-30 01:00:00 | YM | Futures | 38645.8 | 38657.7 | 38632.8 | 38637.1 | 810.0 |
| 2023-11-30 02:00:00 | YM | Futures | 38637.1 | 38641.4 | 38610.0 | 38640.3 | 2413.0 |
| 2023-11-30 03:00:00 | YM | Futures | 38641.4 | 38657.7 | 38589.4 | 38614.3 | 4055.0 |
> showing 50 of 2,088 rows — these rows as CSV