PREVIEW / futures_1hour / 2024-10-31
file: by_date/futures_1hour/2024/2024-10-31.parquet size: 69 KB rows: 2,140
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-10-31 00:00:00 | ES | Futures | 6050.27 | 6050.53 | 6046.9 | 6047.93 | 5553.0 |
| 2024-10-31 01:00:00 | ES | Futures | 6047.93 | 6048.45 | 6044.82 | 6044.82 | 7740.0 |
| 2024-10-31 02:00:00 | ES | Futures | 6044.82 | 6045.86 | 6035.74 | 6036.0 | 10829.0 |
| 2024-10-31 03:00:00 | ES | Futures | 6036.0 | 6036.0 | 6027.43 | 6028.73 | 20903.0 |
| 2024-10-31 04:00:00 | ES | Futures | 6028.73 | 6030.03 | 6021.98 | 6026.39 | 33385.0 |
| 2024-10-31 05:00:00 | ES | Futures | 6026.39 | 6028.47 | 6022.5 | 6027.69 | 17696.0 |
| 2024-10-31 06:00:00 | ES | Futures | 6027.95 | 6031.06 | 6023.8 | 6030.29 | 14567.0 |
| 2024-10-31 07:00:00 | ES | Futures | 6030.55 | 6038.59 | 6028.99 | 6038.07 | 23378.0 |
| 2024-10-31 08:00:00 | ES | Futures | 6038.07 | 6041.7 | 6033.4 | 6034.7 | 44112.0 |
| 2024-10-31 09:00:00 | ES | Futures | 6034.7 | 6037.03 | 6002.0 | 6008.75 | 240627.0 |
| 2024-10-31 10:00:00 | ES | Futures | 6008.49 | 6009.26 | 5979.42 | 5980.72 | 274530.0 |
| 2024-10-31 11:00:00 | ES | Futures | 5980.72 | 5986.95 | 5969.56 | 5978.64 | 197003.0 |
| 2024-10-31 12:00:00 | ES | Futures | 5978.38 | 5988.76 | 5974.49 | 5982.79 | 126013.0 |
| 2024-10-31 13:00:00 | ES | Futures | 5982.79 | 5989.8 | 5970.08 | 5973.19 | 103412.0 |
| 2024-10-31 14:00:00 | ES | Futures | 5972.93 | 5978.12 | 5965.92 | 5975.79 | 142858.0 |
| 2024-10-31 15:00:00 | ES | Futures | 5976.05 | 5990.32 | 5952.95 | 5953.99 | 388898.0 |
| 2024-10-31 16:00:00 | ES | Futures | 5953.99 | 5974.75 | 5951.65 | 5957.1 | 150157.0 |
| 2024-10-31 18:00:00 | ES | Futures | 5960.73 | 5970.6 | 5957.62 | 5964.89 | 10270.0 |
| 2024-10-31 19:00:00 | ES | Futures | 5964.89 | 5966.44 | 5958.66 | 5961.25 | 7544.0 |
| 2024-10-31 20:00:00 | ES | Futures | 5961.51 | 5964.63 | 5955.54 | 5962.55 | 8610.0 |
| 2024-10-31 21:00:00 | ES | Futures | 5962.29 | 5964.63 | 5958.14 | 5959.7 | 6710.0 |
| 2024-10-31 22:00:00 | ES | Futures | 5959.7 | 5962.81 | 5950.87 | 5962.55 | 8504.0 |
| 2024-10-31 23:00:00 | ES | Futures | 5962.55 | 5968.78 | 5961.77 | 5966.96 | 6387.0 |
| 2024-10-31 00:00:00 | NQ | Futures | 21313.67 | 21316.28 | 21293.58 | 21299.58 | 2688.0 |
| 2024-10-31 01:00:00 | NQ | Futures | 21299.58 | 21302.19 | 21273.75 | 21282.1 | 4370.0 |
| 2024-10-31 02:00:00 | NQ | Futures | 21282.62 | 21287.05 | 21241.92 | 21247.39 | 5785.0 |
| 2024-10-31 03:00:00 | NQ | Futures | 21247.92 | 21247.92 | 21193.65 | 21208.0 | 10484.0 |
| 2024-10-31 04:00:00 | NQ | Futures | 21206.69 | 21221.56 | 21172.51 | 21204.87 | 12482.0 |
| 2024-10-31 05:00:00 | NQ | Futures | 21204.34 | 21219.48 | 21192.08 | 21207.74 | 6148.0 |
| 2024-10-31 06:00:00 | NQ | Futures | 21208.26 | 21231.74 | 21178.51 | 21228.61 | 6983.0 |
| 2024-10-31 07:00:00 | NQ | Futures | 21228.87 | 21283.66 | 21228.61 | 21283.14 | 12461.0 |
| 2024-10-31 08:00:00 | NQ | Futures | 21283.14 | 21308.19 | 21260.18 | 21272.44 | 20224.0 |
| 2024-10-31 09:00:00 | NQ | Futures | 21270.88 | 21285.75 | 21030.32 | 21046.23 | 105490.0 |
| 2024-10-31 10:00:00 | NQ | Futures | 21046.23 | 21083.02 | 20946.3 | 20965.09 | 108253.0 |
| 2024-10-31 11:00:00 | NQ | Futures | 20964.57 | 20995.88 | 20897.25 | 20945.26 | 84427.0 |
| 2024-10-31 12:00:00 | NQ | Futures | 20945.26 | 20983.35 | 20924.65 | 20963.26 | 45465.0 |
| 2024-10-31 13:00:00 | NQ | Futures | 20963.52 | 20993.01 | 20899.6 | 20910.04 | 46074.0 |
| 2024-10-31 14:00:00 | NQ | Futures | 20910.82 | 20931.17 | 20882.64 | 20923.08 | 50331.0 |
| 2024-10-31 15:00:00 | NQ | Futures | 20923.6 | 21010.75 | 20882.64 | 20884.73 | 87000.0 |
| 2024-10-31 16:00:00 | NQ | Futures | 20885.77 | 20977.87 | 20881.86 | 20917.86 | 36841.0 |
| 2024-10-31 18:00:00 | NQ | Futures | 20947.08 | 20990.4 | 20939.78 | 20968.22 | 5396.0 |
| 2024-10-31 19:00:00 | NQ | Futures | 20967.96 | 20977.09 | 20941.34 | 20949.95 | 3678.0 |
| 2024-10-31 20:00:00 | NQ | Futures | 20950.22 | 20961.43 | 20925.17 | 20949.95 | 3998.0 |
| 2024-10-31 21:00:00 | NQ | Futures | 20948.65 | 20958.56 | 20928.3 | 20933.0 | 3125.0 |
| 2024-10-31 22:00:00 | NQ | Futures | 20933.78 | 20951.26 | 20890.73 | 20950.48 | 4814.0 |
| 2024-10-31 23:00:00 | NQ | Futures | 20951.78 | 20979.18 | 20948.39 | 20963.78 | 4247.0 |
| 2024-10-31 00:00:00 | YM | Futures | 44025.9 | 44026.9 | 44009.3 | 44017.6 | 419.0 |
| 2024-10-31 01:00:00 | YM | Futures | 44018.6 | 44020.7 | 43998.8 | 43998.8 | 776.0 |
| 2024-10-31 02:00:00 | YM | Futures | 43999.9 | 44008.2 | 43920.8 | 43925.0 | 1519.0 |
| 2024-10-31 03:00:00 | YM | Futures | 43925.0 | 43940.6 | 43882.3 | 43898.9 | 2967.0 |
> showing 50 of 2,140 rows — these rows as CSV