PREVIEW / futures_1hour / 2024-04-25
file: by_date/futures_1hour/2024/2024-04-25.parquet size: 68 KB rows: 2,130
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-04-25 00:00:00 | ES | Futures | 5384.71 | 5386.56 | 5383.65 | 5384.71 | 2122.0 |
| 2024-04-25 01:00:00 | ES | Futures | 5384.71 | 5385.24 | 5377.28 | 5379.14 | 7673.0 |
| 2024-04-25 02:00:00 | ES | Futures | 5379.14 | 5387.36 | 5376.48 | 5386.3 | 9747.0 |
| 2024-04-25 03:00:00 | ES | Futures | 5386.3 | 5388.95 | 5379.14 | 5383.12 | 18648.0 |
| 2024-04-25 04:00:00 | ES | Futures | 5382.85 | 5392.67 | 5382.05 | 5390.01 | 15474.0 |
| 2024-04-25 05:00:00 | ES | Futures | 5389.75 | 5393.46 | 5388.16 | 5390.81 | 11872.0 |
| 2024-04-25 06:00:00 | ES | Futures | 5390.81 | 5392.4 | 5382.32 | 5383.12 | 16690.0 |
| 2024-04-25 07:00:00 | ES | Futures | 5383.38 | 5387.63 | 5378.61 | 5387.09 | 19501.0 |
| 2024-04-25 08:00:00 | ES | Futures | 5386.83 | 5391.34 | 5351.28 | 5353.4 | 113492.0 |
| 2024-04-25 09:00:00 | ES | Futures | 5353.4 | 5356.32 | 5333.5 | 5337.22 | 293323.0 |
| 2024-04-25 10:00:00 | ES | Futures | 5337.22 | 5354.73 | 5329.53 | 5339.34 | 278627.0 |
| 2024-04-25 11:00:00 | ES | Futures | 5339.34 | 5360.83 | 5338.55 | 5358.97 | 163682.0 |
| 2024-04-25 12:00:00 | ES | Futures | 5359.24 | 5378.34 | 5355.26 | 5375.42 | 169777.0 |
| 2024-04-25 13:00:00 | ES | Futures | 5375.42 | 5397.71 | 5366.67 | 5393.99 | 166882.0 |
| 2024-04-25 14:00:00 | ES | Futures | 5394.26 | 5396.38 | 5374.36 | 5383.12 | 155807.0 |
| 2024-04-25 15:00:00 | ES | Futures | 5382.85 | 5402.22 | 5382.32 | 5393.73 | 219148.0 |
| 2024-04-25 16:00:00 | ES | Futures | 5393.73 | 5446.79 | 5389.75 | 5445.72 | 130612.0 |
| 2024-04-25 18:00:00 | ES | Futures | 5445.99 | 5448.91 | 5432.46 | 5436.7 | 11382.0 |
| 2024-04-25 19:00:00 | ES | Futures | 5436.44 | 5437.24 | 5429.81 | 5432.73 | 6195.0 |
| 2024-04-25 20:00:00 | ES | Futures | 5432.73 | 5434.85 | 5429.81 | 5433.52 | 6633.0 |
| 2024-04-25 21:00:00 | ES | Futures | 5433.52 | 5438.56 | 5430.87 | 5436.7 | 6525.0 |
| 2024-04-25 22:00:00 | ES | Futures | 5436.7 | 5438.3 | 5432.73 | 5435.38 | 5756.0 |
| 2024-04-25 23:00:00 | ES | Futures | 5434.85 | 5440.95 | 5434.85 | 5438.03 | 4359.0 |
| 2024-04-25 00:00:00 | NQ | Futures | 18682.48 | 18684.62 | 18669.91 | 18675.79 | 2078.0 |
| 2024-04-25 01:00:00 | NQ | Futures | 18676.06 | 18677.4 | 18634.33 | 18642.36 | 6142.0 |
| 2024-04-25 02:00:00 | NQ | Futures | 18641.82 | 18682.21 | 18626.04 | 18676.86 | 8199.0 |
| 2024-04-25 03:00:00 | NQ | Futures | 18676.06 | 18687.03 | 18653.86 | 18674.72 | 12433.0 |
| 2024-04-25 04:00:00 | NQ | Futures | 18675.26 | 18735.45 | 18673.65 | 18721.54 | 11374.0 |
| 2024-04-25 05:00:00 | NQ | Futures | 18721.0 | 18752.03 | 18715.12 | 18742.4 | 7229.0 |
| 2024-04-25 06:00:00 | NQ | Futures | 18743.2 | 18748.02 | 18697.46 | 18707.89 | 11315.0 |
| 2024-04-25 07:00:00 | NQ | Futures | 18707.36 | 18728.49 | 18684.09 | 18726.08 | 12229.0 |
| 2024-04-25 08:00:00 | NQ | Futures | 18726.89 | 18741.87 | 18584.31 | 18596.88 | 42030.0 |
| 2024-04-25 09:00:00 | NQ | Futures | 18597.15 | 18609.72 | 18520.11 | 18571.73 | 141166.0 |
| 2024-04-25 10:00:00 | NQ | Futures | 18572.54 | 18668.57 | 18542.84 | 18567.72 | 125030.0 |
| 2024-04-25 11:00:00 | NQ | Futures | 18567.99 | 18638.61 | 18564.24 | 18633.53 | 75419.0 |
| 2024-04-25 12:00:00 | NQ | Futures | 18632.73 | 18732.77 | 18615.07 | 18719.4 | 66058.0 |
| 2024-04-25 13:00:00 | NQ | Futures | 18719.66 | 18811.42 | 18686.49 | 18798.31 | 63682.0 |
| 2024-04-25 14:00:00 | NQ | Futures | 18798.85 | 18814.63 | 18717.26 | 18753.9 | 61138.0 |
| 2024-04-25 15:00:00 | NQ | Futures | 18754.17 | 18837.63 | 18750.96 | 18797.24 | 79060.0 |
| 2024-04-25 16:00:00 | NQ | Futures | 18797.24 | 19075.71 | 18776.64 | 19063.94 | 55488.0 |
| 2024-04-25 18:00:00 | NQ | Futures | 19055.11 | 19075.18 | 18998.14 | 19021.41 | 9206.0 |
| 2024-04-25 19:00:00 | NQ | Futures | 19020.87 | 19021.14 | 18988.51 | 19002.95 | 4104.0 |
| 2024-04-25 20:00:00 | NQ | Futures | 19002.68 | 19004.56 | 18984.49 | 18998.4 | 3703.0 |
| 2024-04-25 21:00:00 | NQ | Futures | 18998.94 | 19027.03 | 18990.65 | 19016.59 | 4081.0 |
| 2024-04-25 22:00:00 | NQ | Futures | 19016.33 | 19020.07 | 18993.86 | 19006.96 | 2512.0 |
| 2024-04-25 23:00:00 | NQ | Futures | 19006.96 | 19031.84 | 19004.56 | 19013.65 | 3271.0 |
| 2024-04-25 00:00:00 | YM | Futures | 40984.9 | 40992.3 | 40976.4 | 40983.8 | 310.0 |
| 2024-04-25 01:00:00 | YM | Futures | 40983.8 | 40984.9 | 40949.9 | 40964.7 | 788.0 |
| 2024-04-25 02:00:00 | YM | Futures | 40963.7 | 41004.0 | 40952.0 | 40995.5 | 1672.0 |
| 2024-04-25 03:00:00 | YM | Futures | 40994.5 | 41010.4 | 40928.6 | 40953.0 | 2640.0 |
> showing 50 of 2,130 rows — these rows as CSV