PREVIEW / futures_1hour / 2025-09-25
file: by_date/futures_1hour/2025/2025-09-25.parquet size: 65 KB rows: 2,079
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-09-25 00:00:00 | ES | Futures | 6755.03 | 6755.53 | 6748.98 | 6750.24 | 3724.0 |
| 2025-09-25 01:00:00 | ES | Futures | 6749.99 | 6750.75 | 6746.21 | 6748.48 | 4330.0 |
| 2025-09-25 02:00:00 | ES | Futures | 6748.48 | 6749.74 | 6740.17 | 6741.68 | 6591.0 |
| 2025-09-25 03:00:00 | ES | Futures | 6741.93 | 6746.21 | 6733.87 | 6743.44 | 12662.0 |
| 2025-09-25 04:00:00 | ES | Futures | 6743.44 | 6747.72 | 6737.9 | 6740.17 | 10031.0 |
| 2025-09-25 05:00:00 | ES | Futures | 6740.17 | 6742.69 | 6734.63 | 6737.9 | 8882.0 |
| 2025-09-25 06:00:00 | ES | Futures | 6737.9 | 6739.66 | 6729.34 | 6732.86 | 12976.0 |
| 2025-09-25 07:00:00 | ES | Futures | 6732.86 | 6733.11 | 6712.46 | 6714.48 | 30236.0 |
| 2025-09-25 08:00:00 | ES | Futures | 6714.22 | 6723.04 | 6703.39 | 6708.68 | 51469.0 |
| 2025-09-25 09:00:00 | ES | Futures | 6708.43 | 6712.71 | 6680.98 | 6686.77 | 264981.0 |
| 2025-09-25 10:00:00 | ES | Futures | 6686.77 | 6722.54 | 6685.51 | 6718.76 | 256184.0 |
| 2025-09-25 11:00:00 | ES | Futures | 6718.76 | 6725.05 | 6702.13 | 6720.27 | 196629.0 |
| 2025-09-25 12:00:00 | ES | Futures | 6720.02 | 6723.04 | 6706.16 | 6708.93 | 135145.0 |
| 2025-09-25 13:00:00 | ES | Futures | 6708.93 | 6714.22 | 6685.26 | 6686.27 | 154946.0 |
| 2025-09-25 14:00:00 | ES | Futures | 6686.27 | 6712.46 | 6673.92 | 6709.69 | 217657.0 |
| 2025-09-25 15:00:00 | ES | Futures | 6709.69 | 6713.72 | 6701.38 | 6710.45 | 200946.0 |
| 2025-09-25 16:00:00 | ES | Futures | 6710.45 | 6716.49 | 6707.93 | 6711.96 | 46478.0 |
| 2025-09-25 18:00:00 | ES | Futures | 6712.71 | 6719.01 | 6709.94 | 6712.71 | 5637.0 |
| 2025-09-25 19:00:00 | ES | Futures | 6712.21 | 6713.47 | 6708.68 | 6708.93 | 5133.0 |
| 2025-09-25 20:00:00 | ES | Futures | 6708.68 | 6712.71 | 6707.17 | 6711.96 | 5853.0 |
| 2025-09-25 21:00:00 | ES | Futures | 6711.7 | 6711.7 | 6705.91 | 6708.18 | 7371.0 |
| 2025-09-25 22:00:00 | ES | Futures | 6708.18 | 6713.72 | 6707.42 | 6709.69 | 4727.0 |
| 2025-09-25 23:00:00 | ES | Futures | 6709.69 | 6710.19 | 6703.64 | 6707.93 | 5680.0 |
| 2025-09-25 00:00:00 | NQ | Futures | 25001.64 | 25005.17 | 24971.13 | 24976.68 | 3019.0 |
| 2025-09-25 01:00:00 | NQ | Futures | 24976.42 | 24979.45 | 24953.73 | 24969.62 | 3517.0 |
| 2025-09-25 02:00:00 | NQ | Futures | 24969.11 | 24974.91 | 24935.32 | 24943.39 | 4106.0 |
| 2025-09-25 03:00:00 | NQ | Futures | 24944.9 | 24964.07 | 24910.1 | 24952.97 | 7541.0 |
| 2025-09-25 04:00:00 | NQ | Futures | 24953.73 | 24980.46 | 24934.31 | 24944.65 | 6434.0 |
| 2025-09-25 05:00:00 | NQ | Futures | 24944.65 | 24953.98 | 24904.8 | 24922.21 | 6617.0 |
| 2025-09-25 06:00:00 | NQ | Futures | 24922.21 | 24929.77 | 24884.13 | 24904.8 | 8202.0 |
| 2025-09-25 07:00:00 | NQ | Futures | 24904.3 | 24907.07 | 24801.66 | 24809.98 | 16431.0 |
| 2025-09-25 08:00:00 | NQ | Futures | 24809.48 | 24846.05 | 24760.3 | 24783.0 | 25304.0 |
| 2025-09-25 09:00:00 | NQ | Futures | 24782.49 | 24801.91 | 24635.97 | 24666.49 | 119708.0 |
| 2025-09-25 10:00:00 | NQ | Futures | 24666.24 | 24872.27 | 24658.67 | 24850.58 | 118912.0 |
| 2025-09-25 11:00:00 | NQ | Futures | 24850.33 | 24912.62 | 24798.63 | 24893.46 | 82223.0 |
| 2025-09-25 12:00:00 | NQ | Futures | 24892.95 | 24907.58 | 24828.14 | 24840.24 | 49970.0 |
| 2025-09-25 13:00:00 | NQ | Futures | 24839.99 | 24860.17 | 24726.01 | 24731.55 | 58938.0 |
| 2025-09-25 14:00:00 | NQ | Futures | 24731.81 | 24855.63 | 24667.25 | 24843.27 | 84868.0 |
| 2025-09-25 15:00:00 | NQ | Futures | 24843.02 | 24861.68 | 24806.96 | 24847.56 | 60133.0 |
| 2025-09-25 16:00:00 | NQ | Futures | 24847.56 | 24863.7 | 24826.12 | 24850.84 | 15808.0 |
| 2025-09-25 18:00:00 | NQ | Futures | 24857.9 | 24880.85 | 24841.0 | 24852.6 | 4507.0 |
| 2025-09-25 19:00:00 | NQ | Futures | 24852.1 | 24857.39 | 24831.17 | 24831.92 | 3247.0 |
| 2025-09-25 20:00:00 | NQ | Futures | 24831.92 | 24848.06 | 24821.08 | 24841.76 | 4465.0 |
| 2025-09-25 21:00:00 | NQ | Futures | 24839.74 | 24840.24 | 24808.47 | 24812.5 | 4684.0 |
| 2025-09-25 22:00:00 | NQ | Futures | 24812.5 | 24838.23 | 24809.73 | 24819.31 | 2956.0 |
| 2025-09-25 23:00:00 | NQ | Futures | 24819.31 | 24821.33 | 24794.35 | 24808.97 | 3921.0 |
| 2025-09-25 00:00:00 | YM | Futures | 47188.7 | 47196.8 | 47151.1 | 47158.2 | 371.0 |
| 2025-09-25 01:00:00 | YM | Futures | 47157.2 | 47158.2 | 47129.8 | 47150.1 | 499.0 |
| 2025-09-25 02:00:00 | YM | Futures | 47149.1 | 47158.2 | 47086.2 | 47097.4 | 1002.0 |
| 2025-09-25 03:00:00 | YM | Futures | 47098.4 | 47128.8 | 47038.6 | 47107.5 | 1959.0 |
> showing 50 of 2,079 rows — these rows as CSV