PREVIEW / futures_1hour / 2024-11-04
file: by_date/futures_1hour/2024/2024-11-04.parquet size: 68 KB rows: 2,144
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-04 00:00:00 | ES | Futures | 5992.65 | 5992.65 | 5988.5 | 5991.88 | 4622.0 |
| 2024-11-04 01:00:00 | ES | Futures | 5991.88 | 5996.55 | 5991.36 | 5994.21 | 5612.0 |
| 2024-11-04 02:00:00 | ES | Futures | 5993.95 | 5995.51 | 5980.72 | 5980.98 | 9833.0 |
| 2024-11-04 03:00:00 | ES | Futures | 5981.24 | 5990.06 | 5977.34 | 5983.31 | 18779.0 |
| 2024-11-04 04:00:00 | ES | Futures | 5983.57 | 5986.17 | 5978.12 | 5984.87 | 15854.0 |
| 2024-11-04 05:00:00 | ES | Futures | 5984.87 | 5994.47 | 5984.09 | 5992.91 | 10270.0 |
| 2024-11-04 06:00:00 | ES | Futures | 5992.91 | 5993.69 | 5985.91 | 5989.02 | 8960.0 |
| 2024-11-04 07:00:00 | ES | Futures | 5989.02 | 5991.88 | 5974.75 | 5985.91 | 19755.0 |
| 2024-11-04 08:00:00 | ES | Futures | 5985.91 | 5988.76 | 5980.2 | 5981.75 | 25055.0 |
| 2024-11-04 09:00:00 | ES | Futures | 5981.75 | 5982.01 | 5957.1 | 5980.2 | 169847.0 |
| 2024-11-04 10:00:00 | ES | Futures | 5980.2 | 5991.36 | 5977.34 | 5982.01 | 166069.0 |
| 2024-11-04 11:00:00 | ES | Futures | 5982.01 | 5987.98 | 5946.46 | 5952.43 | 174971.0 |
| 2024-11-04 12:00:00 | ES | Futures | 5952.69 | 5973.97 | 5942.31 | 5969.82 | 154017.0 |
| 2024-11-04 13:00:00 | ES | Futures | 5969.82 | 5978.12 | 5956.32 | 5972.15 | 119034.0 |
| 2024-11-04 14:00:00 | ES | Futures | 5972.15 | 5977.6 | 5965.92 | 5970.08 | 76056.0 |
| 2024-11-04 15:00:00 | ES | Futures | 5970.34 | 5972.15 | 5956.06 | 5963.07 | 191733.0 |
| 2024-11-04 16:00:00 | ES | Futures | 5962.81 | 5968.78 | 5959.7 | 5968.0 | 41943.0 |
| 2024-11-04 18:00:00 | ES | Futures | 5971.37 | 5972.41 | 5961.25 | 5961.77 | 7875.0 |
| 2024-11-04 19:00:00 | ES | Futures | 5961.51 | 5962.03 | 5958.4 | 5959.44 | 5853.0 |
| 2024-11-04 20:00:00 | ES | Futures | 5959.44 | 5968.0 | 5953.47 | 5965.92 | 11028.0 |
| 2024-11-04 21:00:00 | ES | Futures | 5965.92 | 5969.3 | 5960.73 | 5966.7 | 6992.0 |
| 2024-11-04 22:00:00 | ES | Futures | 5966.7 | 5968.52 | 5964.37 | 5964.63 | 3475.0 |
| 2024-11-04 23:00:00 | ES | Futures | 5964.63 | 5966.18 | 5961.25 | 5961.77 | 3115.0 |
| 2024-11-04 00:00:00 | NQ | Futures | 21116.94 | 21116.94 | 21100.76 | 21113.55 | 1767.0 |
| 2024-11-04 01:00:00 | NQ | Futures | 21113.81 | 21131.55 | 21110.15 | 21120.85 | 2682.0 |
| 2024-11-04 02:00:00 | NQ | Futures | 21120.33 | 21127.38 | 21054.32 | 21060.84 | 6808.0 |
| 2024-11-04 03:00:00 | NQ | Futures | 21060.84 | 21086.41 | 21014.14 | 21047.8 | 9271.0 |
| 2024-11-04 04:00:00 | NQ | Futures | 21049.1 | 21053.8 | 21014.66 | 21046.23 | 7043.0 |
| 2024-11-04 05:00:00 | NQ | Futures | 21045.97 | 21093.98 | 21044.14 | 21080.41 | 6302.0 |
| 2024-11-04 06:00:00 | NQ | Futures | 21080.15 | 21085.11 | 21047.54 | 21063.19 | 6389.0 |
| 2024-11-04 07:00:00 | NQ | Futures | 21062.41 | 21075.71 | 20978.13 | 21046.49 | 12419.0 |
| 2024-11-04 08:00:00 | NQ | Futures | 21046.75 | 21060.06 | 21016.23 | 21026.4 | 12185.0 |
| 2024-11-04 09:00:00 | NQ | Futures | 21026.66 | 21027.45 | 20886.55 | 21009.96 | 82733.0 |
| 2024-11-04 10:00:00 | NQ | Futures | 21009.96 | 21091.89 | 20997.7 | 21067.1 | 68709.0 |
| 2024-11-04 11:00:00 | NQ | Futures | 21067.1 | 21109.63 | 20928.04 | 20953.35 | 65652.0 |
| 2024-11-04 12:00:00 | NQ | Futures | 20953.87 | 21026.14 | 20902.99 | 21006.83 | 53095.0 |
| 2024-11-04 13:00:00 | NQ | Futures | 21007.09 | 21056.41 | 20960.91 | 21027.97 | 45976.0 |
| 2024-11-04 14:00:00 | NQ | Futures | 21028.23 | 21049.36 | 21000.83 | 21014.66 | 26856.0 |
| 2024-11-04 15:00:00 | NQ | Futures | 21015.18 | 21020.92 | 20946.04 | 20961.96 | 54693.0 |
| 2024-11-04 16:00:00 | NQ | Futures | 20962.22 | 20994.31 | 20949.43 | 20992.48 | 11387.0 |
| 2024-11-04 18:00:00 | NQ | Futures | 21009.44 | 21010.75 | 20961.43 | 20964.83 | 3539.0 |
| 2024-11-04 19:00:00 | NQ | Futures | 20964.3 | 20966.65 | 20947.61 | 20952.3 | 2977.0 |
| 2024-11-04 20:00:00 | NQ | Futures | 20952.3 | 20986.74 | 20916.56 | 20977.35 | 6121.0 |
| 2024-11-04 21:00:00 | NQ | Futures | 20976.31 | 20990.4 | 20957.0 | 20980.48 | 3470.0 |
| 2024-11-04 22:00:00 | NQ | Futures | 20979.18 | 20993.79 | 20973.18 | 20980.22 | 2241.0 |
| 2024-11-04 23:00:00 | NQ | Futures | 20979.96 | 20983.09 | 20958.83 | 20961.96 | 1780.0 |
| 2024-11-04 00:00:00 | YM | Futures | 43908.3 | 43909.3 | 43881.2 | 43893.7 | 637.0 |
| 2024-11-04 01:00:00 | YM | Futures | 43892.7 | 43927.0 | 43890.6 | 43905.2 | 840.0 |
| 2024-11-04 02:00:00 | YM | Futures | 43905.2 | 43918.7 | 43826.1 | 43831.3 | 1555.0 |
| 2024-11-04 03:00:00 | YM | Futures | 43831.3 | 43913.5 | 43825.0 | 43876.0 | 2495.0 |
> showing 50 of 2,144 rows — these rows as CSV