PREVIEW / futures_1hour / 2024-08-29
file: by_date/futures_1hour/2024/2024-08-29.parquet size: 66 KB rows: 2,068
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-08-29 00:00:00 | ES | Futures | 5861.46 | 5864.87 | 5860.94 | 5864.61 | 3310.0 |
| 2024-08-29 01:00:00 | ES | Futures | 5864.61 | 5870.9 | 5862.77 | 5869.85 | 6792.0 |
| 2024-08-29 02:00:00 | ES | Futures | 5869.59 | 5875.36 | 5865.92 | 5874.57 | 9970.0 |
| 2024-08-29 03:00:00 | ES | Futures | 5874.57 | 5884.01 | 5874.05 | 5880.6 | 14056.0 |
| 2024-08-29 04:00:00 | ES | Futures | 5880.6 | 5888.99 | 5877.98 | 5886.37 | 19150.0 |
| 2024-08-29 05:00:00 | ES | Futures | 5886.63 | 5901.57 | 5885.84 | 5899.21 | 16219.0 |
| 2024-08-29 06:00:00 | ES | Futures | 5899.48 | 5903.67 | 5890.3 | 5893.45 | 13984.0 |
| 2024-08-29 07:00:00 | ES | Futures | 5893.18 | 5903.41 | 5888.2 | 5897.9 | 18219.0 |
| 2024-08-29 08:00:00 | ES | Futures | 5897.9 | 5909.96 | 5894.49 | 5898.69 | 40600.0 |
| 2024-08-29 09:00:00 | ES | Futures | 5898.69 | 5914.16 | 5893.97 | 5912.58 | 183919.0 |
| 2024-08-29 10:00:00 | ES | Futures | 5912.32 | 5930.15 | 5901.83 | 5922.81 | 223905.0 |
| 2024-08-29 11:00:00 | ES | Futures | 5922.55 | 5934.61 | 5916.25 | 5926.74 | 149506.0 |
| 2024-08-29 12:00:00 | ES | Futures | 5927.0 | 5939.32 | 5926.22 | 5933.56 | 120845.0 |
| 2024-08-29 13:00:00 | ES | Futures | 5933.56 | 5933.56 | 5921.23 | 5930.67 | 98399.0 |
| 2024-08-29 14:00:00 | ES | Futures | 5930.41 | 5930.41 | 5870.38 | 5884.53 | 255967.0 |
| 2024-08-29 15:00:00 | ES | Futures | 5884.53 | 5900.26 | 5874.31 | 5883.22 | 226580.0 |
| 2024-08-29 16:00:00 | ES | Futures | 5883.48 | 5894.23 | 5882.7 | 5891.35 | 56549.0 |
| 2024-08-29 18:00:00 | ES | Futures | 5891.87 | 5895.28 | 5885.06 | 5888.99 | 6045.0 |
| 2024-08-29 19:00:00 | ES | Futures | 5888.73 | 5891.61 | 5886.89 | 5888.2 | 2193.0 |
| 2024-08-29 20:00:00 | ES | Futures | 5888.2 | 5892.92 | 5881.12 | 5891.09 | 6709.0 |
| 2024-08-29 21:00:00 | ES | Futures | 5891.35 | 5894.23 | 5887.68 | 5890.04 | 4441.0 |
| 2024-08-29 22:00:00 | ES | Futures | 5890.04 | 5897.12 | 5889.51 | 5896.59 | 3884.0 |
| 2024-08-29 23:00:00 | ES | Futures | 5896.59 | 5897.12 | 5888.99 | 5892.92 | 3394.0 |
| 2024-08-29 00:00:00 | NQ | Futures | 20353.84 | 20377.6 | 20351.99 | 20371.0 | 3285.0 |
| 2024-08-29 01:00:00 | NQ | Futures | 20370.74 | 20410.6 | 20355.69 | 20403.74 | 5562.0 |
| 2024-08-29 02:00:00 | NQ | Futures | 20403.21 | 20433.04 | 20388.69 | 20421.69 | 6921.0 |
| 2024-08-29 03:00:00 | NQ | Futures | 20422.21 | 20478.18 | 20420.89 | 20453.63 | 8222.0 |
| 2024-08-29 04:00:00 | NQ | Futures | 20453.1 | 20512.76 | 20444.12 | 20498.51 | 11943.0 |
| 2024-08-29 05:00:00 | NQ | Futures | 20499.3 | 20596.71 | 20494.55 | 20578.49 | 12823.0 |
| 2024-08-29 06:00:00 | NQ | Futures | 20578.49 | 20607.79 | 20522.53 | 20535.99 | 13285.0 |
| 2024-08-29 07:00:00 | NQ | Futures | 20535.99 | 20581.92 | 20504.58 | 20555.0 | 12842.0 |
| 2024-08-29 08:00:00 | NQ | Futures | 20554.47 | 20604.89 | 20531.24 | 20557.37 | 19372.0 |
| 2024-08-29 09:00:00 | NQ | Futures | 20557.64 | 20750.61 | 20552.36 | 20742.43 | 98527.0 |
| 2024-08-29 10:00:00 | NQ | Futures | 20742.43 | 20794.96 | 20623.1 | 20740.58 | 99752.0 |
| 2024-08-29 11:00:00 | NQ | Futures | 20739.26 | 20787.57 | 20687.25 | 20730.28 | 52546.0 |
| 2024-08-29 12:00:00 | NQ | Futures | 20730.81 | 20791.26 | 20723.68 | 20751.4 | 38408.0 |
| 2024-08-29 13:00:00 | NQ | Futures | 20751.66 | 20751.93 | 20670.62 | 20731.87 | 41664.0 |
| 2024-08-29 14:00:00 | NQ | Futures | 20731.34 | 20731.87 | 20423.8 | 20485.83 | 92055.0 |
| 2024-08-29 15:00:00 | NQ | Futures | 20486.36 | 20555.26 | 20418.52 | 20477.65 | 91577.0 |
| 2024-08-29 16:00:00 | NQ | Futures | 20477.91 | 20543.12 | 20475.54 | 20533.09 | 16098.0 |
| 2024-08-29 18:00:00 | NQ | Futures | 20533.35 | 20551.04 | 20492.96 | 20518.83 | 3637.0 |
| 2024-08-29 19:00:00 | NQ | Futures | 20518.57 | 20531.5 | 20510.38 | 20517.25 | 1580.0 |
| 2024-08-29 20:00:00 | NQ | Futures | 20516.98 | 20541.8 | 20478.71 | 20532.03 | 3911.0 |
| 2024-08-29 21:00:00 | NQ | Futures | 20532.56 | 20547.08 | 20510.38 | 20527.28 | 2606.0 |
| 2024-08-29 22:00:00 | NQ | Futures | 20528.6 | 20564.24 | 20525.7 | 20558.96 | 2638.0 |
| 2024-08-29 23:00:00 | NQ | Futures | 20559.75 | 20563.97 | 20519.89 | 20541.27 | 2657.0 |
| 2024-08-29 00:00:00 | YM | Futures | 43368.8 | 43382.4 | 43367.7 | 43382.4 | 295.0 |
| 2024-08-29 01:00:00 | YM | Futures | 43381.4 | 43408.7 | 43377.2 | 43398.2 | 686.0 |
| 2024-08-29 02:00:00 | YM | Futures | 43396.1 | 43426.6 | 43380.3 | 43424.5 | 1248.0 |
| 2024-08-29 03:00:00 | YM | Futures | 43424.5 | 43467.6 | 43416.1 | 43456.0 | 1964.0 |
> showing 50 of 2,068 rows — these rows as CSV