PREVIEW / futures_1hour / 2025-01-13
file: by_date/futures_1hour/2025/2025-01-13.parquet size: 68 KB rows: 2,104
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-13 00:00:00 | ES | Futures | 5990.26 | 5990.52 | 5983.6 | 5987.96 | 4683.0 |
| 2025-01-13 01:00:00 | ES | Futures | 5988.21 | 5997.95 | 5988.21 | 5992.83 | 5978.0 |
| 2025-01-13 02:00:00 | ES | Futures | 5992.83 | 5995.13 | 5985.39 | 5988.98 | 9721.0 |
| 2025-01-13 03:00:00 | ES | Futures | 5988.98 | 5995.65 | 5972.06 | 5973.6 | 26329.0 |
| 2025-01-13 04:00:00 | ES | Futures | 5973.85 | 5974.88 | 5957.19 | 5961.04 | 35199.0 |
| 2025-01-13 05:00:00 | ES | Futures | 5961.04 | 5971.29 | 5958.22 | 5965.91 | 12832.0 |
| 2025-01-13 06:00:00 | ES | Futures | 5965.91 | 5970.78 | 5961.55 | 5967.7 | 12684.0 |
| 2025-01-13 07:00:00 | ES | Futures | 5967.44 | 5983.6 | 5960.01 | 5977.19 | 30302.0 |
| 2025-01-13 08:00:00 | ES | Futures | 5977.19 | 5983.85 | 5969.75 | 5976.16 | 32609.0 |
| 2025-01-13 09:00:00 | ES | Futures | 5976.16 | 5991.8 | 5961.29 | 5987.44 | 236375.0 |
| 2025-01-13 10:00:00 | ES | Futures | 5987.19 | 6001.03 | 5967.19 | 5987.96 | 291259.0 |
| 2025-01-13 11:00:00 | ES | Futures | 5987.7 | 5991.29 | 5967.19 | 5968.47 | 190926.0 |
| 2025-01-13 12:00:00 | ES | Futures | 5968.21 | 6005.65 | 5964.88 | 6004.88 | 183568.0 |
| 2025-01-13 13:00:00 | ES | Futures | 6004.62 | 6013.34 | 5998.47 | 6010.26 | 147874.0 |
| 2025-01-13 14:00:00 | ES | Futures | 6010.26 | 6020.77 | 5999.49 | 6015.39 | 143893.0 |
| 2025-01-13 15:00:00 | ES | Futures | 6015.13 | 6028.21 | 6008.98 | 6025.13 | 215317.0 |
| 2025-01-13 16:00:00 | ES | Futures | 6025.13 | 6033.33 | 6021.8 | 6031.8 | 50942.0 |
| 2025-01-13 18:00:00 | ES | Futures | 6037.44 | 6051.79 | 6036.92 | 6042.82 | 15649.0 |
| 2025-01-13 19:00:00 | ES | Futures | 6042.56 | 6044.1 | 6037.95 | 6042.82 | 8414.0 |
| 2025-01-13 20:00:00 | ES | Futures | 6043.08 | 6043.08 | 6037.95 | 6039.23 | 5446.0 |
| 2025-01-13 21:00:00 | ES | Futures | 6039.23 | 6040.77 | 6033.08 | 6040.26 | 6218.0 |
| 2025-01-13 22:00:00 | ES | Futures | 6040.26 | 6041.28 | 6037.44 | 6037.69 | 4724.0 |
| 2025-01-13 23:00:00 | ES | Futures | 6037.69 | 6043.08 | 6036.41 | 6042.31 | 2534.0 |
| 2025-01-13 00:00:00 | NQ | Futures | 21511.61 | 21514.18 | 21478.41 | 21501.06 | 2860.0 |
| 2025-01-13 01:00:00 | NQ | Futures | 21500.29 | 21544.81 | 21499.51 | 21520.1 | 4073.0 |
| 2025-01-13 02:00:00 | NQ | Futures | 21520.62 | 21530.91 | 21480.47 | 21493.85 | 5191.0 |
| 2025-01-13 03:00:00 | NQ | Futures | 21496.43 | 21526.79 | 21406.61 | 21414.07 | 13563.0 |
| 2025-01-13 04:00:00 | NQ | Futures | 21415.62 | 21423.6 | 21302.13 | 21330.18 | 20949.0 |
| 2025-01-13 05:00:00 | NQ | Futures | 21329.92 | 21386.28 | 21317.83 | 21360.03 | 8807.0 |
| 2025-01-13 06:00:00 | NQ | Futures | 21361.06 | 21387.31 | 21341.25 | 21374.96 | 8717.0 |
| 2025-01-13 07:00:00 | NQ | Futures | 21375.22 | 21458.6 | 21334.55 | 21428.74 | 18906.0 |
| 2025-01-13 08:00:00 | NQ | Futures | 21430.29 | 21454.74 | 21390.91 | 21421.54 | 17167.0 |
| 2025-01-13 09:00:00 | NQ | Futures | 21421.54 | 21453.96 | 21310.36 | 21413.05 | 91928.0 |
| 2025-01-13 10:00:00 | NQ | Futures | 21413.3 | 21493.85 | 21322.97 | 21409.44 | 91124.0 |
| 2025-01-13 11:00:00 | NQ | Futures | 21409.96 | 21438.52 | 21336.1 | 21346.91 | 64758.0 |
| 2025-01-13 12:00:00 | NQ | Futures | 21346.91 | 21509.04 | 21327.09 | 21503.89 | 62655.0 |
| 2025-01-13 13:00:00 | NQ | Futures | 21503.89 | 21528.34 | 21469.15 | 21506.46 | 45278.0 |
| 2025-01-13 14:00:00 | NQ | Futures | 21505.69 | 21541.46 | 21447.53 | 21520.62 | 44666.0 |
| 2025-01-13 15:00:00 | NQ | Futures | 21519.84 | 21580.58 | 21487.16 | 21563.85 | 51908.0 |
| 2025-01-13 16:00:00 | NQ | Futures | 21563.85 | 21613.52 | 21552.78 | 21609.14 | 15547.0 |
| 2025-01-13 18:00:00 | NQ | Futures | 21637.71 | 21708.22 | 21628.44 | 21664.47 | 8024.0 |
| 2025-01-13 19:00:00 | NQ | Futures | 21664.73 | 21674.77 | 21645.94 | 21671.68 | 4818.0 |
| 2025-01-13 20:00:00 | NQ | Futures | 21670.65 | 21670.65 | 21639.0 | 21644.4 | 3130.0 |
| 2025-01-13 21:00:00 | NQ | Futures | 21645.43 | 21662.93 | 21614.03 | 21661.64 | 4357.0 |
| 2025-01-13 22:00:00 | NQ | Futures | 21660.61 | 21666.53 | 21634.62 | 21635.65 | 3513.0 |
| 2025-01-13 23:00:00 | NQ | Futures | 21635.65 | 21665.5 | 21629.73 | 21661.38 | 2471.0 |
| 2025-01-13 00:00:00 | YM | Futures | 43312.5 | 43316.7 | 43280.6 | 43302.3 | 356.0 |
| 2025-01-13 01:00:00 | YM | Futures | 43302.3 | 43355.8 | 43302.3 | 43332.1 | 548.0 |
| 2025-01-13 02:00:00 | YM | Futures | 43330.0 | 43344.5 | 43293.0 | 43318.7 | 1102.0 |
| 2025-01-13 03:00:00 | YM | Futures | 43315.6 | 43350.6 | 43231.2 | 43239.5 | 2932.0 |
> showing 50 of 2,104 rows — these rows as CSV