PREVIEW / futures_1hour / 2025-07-30
file: by_date/futures_1hour/2025/2025-07-30.parquet size: 68 KB rows: 2,075
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-07-30 00:00:00 | ES | Futures | 6462.1 | 6464.11 | 6462.1 | 6463.61 | 1618.0 |
| 2025-07-30 01:00:00 | ES | Futures | 6463.61 | 6464.62 | 6460.59 | 6463.1 | 2824.0 |
| 2025-07-30 02:00:00 | ES | Futures | 6463.1 | 6464.87 | 6460.84 | 6461.34 | 3689.0 |
| 2025-07-30 03:00:00 | ES | Futures | 6461.34 | 6462.6 | 6454.79 | 6461.84 | 8602.0 |
| 2025-07-30 04:00:00 | ES | Futures | 6461.84 | 6464.11 | 6453.03 | 6458.07 | 8203.0 |
| 2025-07-30 05:00:00 | ES | Futures | 6458.07 | 6461.09 | 6456.3 | 6460.33 | 5110.0 |
| 2025-07-30 06:00:00 | ES | Futures | 6460.59 | 6462.35 | 6459.33 | 6462.35 | 5142.0 |
| 2025-07-30 07:00:00 | ES | Futures | 6462.35 | 6465.62 | 6460.84 | 6462.85 | 9542.0 |
| 2025-07-30 08:00:00 | ES | Futures | 6462.85 | 6464.62 | 6454.54 | 6458.82 | 26950.0 |
| 2025-07-30 09:00:00 | ES | Futures | 6458.82 | 6462.6 | 6453.03 | 6457.81 | 95518.0 |
| 2025-07-30 10:00:00 | ES | Futures | 6457.56 | 6469.15 | 6454.29 | 6462.85 | 105495.0 |
| 2025-07-30 11:00:00 | ES | Futures | 6462.85 | 6464.36 | 6450.26 | 6462.1 | 106862.0 |
| 2025-07-30 12:00:00 | ES | Futures | 6461.84 | 6467.89 | 6460.08 | 6465.12 | 63935.0 |
| 2025-07-30 13:00:00 | ES | Futures | 6465.12 | 6470.41 | 6461.59 | 6467.64 | 50497.0 |
| 2025-07-30 14:00:00 | ES | Futures | 6467.39 | 6477.96 | 6425.83 | 6428.09 | 238766.0 |
| 2025-07-30 15:00:00 | ES | Futures | 6428.09 | 6446.98 | 6414.49 | 6445.47 | 371892.0 |
| 2025-07-30 16:00:00 | ES | Futures | 6445.72 | 6483.51 | 6441.44 | 6473.68 | 108052.0 |
| 2025-07-30 18:00:00 | ES | Futures | 6483.76 | 6493.08 | 6479.22 | 6491.31 | 13739.0 |
| 2025-07-30 19:00:00 | ES | Futures | 6491.06 | 6495.09 | 6490.56 | 6490.81 | 5875.0 |
| 2025-07-30 20:00:00 | ES | Futures | 6490.56 | 6496.6 | 6487.54 | 6495.85 | 8569.0 |
| 2025-07-30 21:00:00 | ES | Futures | 6495.85 | 6500.63 | 6493.83 | 6498.11 | 6578.0 |
| 2025-07-30 22:00:00 | ES | Futures | 6498.37 | 6503.4 | 6497.61 | 6502.14 | 4496.0 |
| 2025-07-30 23:00:00 | ES | Futures | 6502.14 | 6504.66 | 6500.38 | 6503.91 | 3674.0 |
| 2025-07-30 00:00:00 | NQ | Futures | 23703.67 | 23712.49 | 23703.42 | 23708.46 | 1238.0 |
| 2025-07-30 01:00:00 | NQ | Futures | 23707.7 | 23714.51 | 23692.57 | 23708.21 | 2111.0 |
| 2025-07-30 02:00:00 | NQ | Futures | 23707.7 | 23715.27 | 23700.89 | 23703.92 | 2246.0 |
| 2025-07-30 03:00:00 | NQ | Futures | 23703.67 | 23713.0 | 23678.45 | 23704.68 | 5211.0 |
| 2025-07-30 04:00:00 | NQ | Futures | 23703.92 | 23717.29 | 23666.6 | 23687.02 | 5428.0 |
| 2025-07-30 05:00:00 | NQ | Futures | 23687.02 | 23702.66 | 23679.21 | 23696.86 | 3989.0 |
| 2025-07-30 06:00:00 | NQ | Futures | 23697.62 | 23713.25 | 23693.33 | 23713.25 | 4260.0 |
| 2025-07-30 07:00:00 | NQ | Futures | 23712.75 | 23726.87 | 23702.41 | 23712.49 | 5813.0 |
| 2025-07-30 08:00:00 | NQ | Futures | 23712.49 | 23712.75 | 23675.93 | 23695.6 | 13872.0 |
| 2025-07-30 09:00:00 | NQ | Futures | 23694.34 | 23731.16 | 23655.0 | 23688.29 | 59050.0 |
| 2025-07-30 10:00:00 | NQ | Futures | 23688.03 | 23746.29 | 23671.39 | 23720.31 | 56192.0 |
| 2025-07-30 11:00:00 | NQ | Futures | 23719.81 | 23735.44 | 23679.96 | 23734.69 | 43218.0 |
| 2025-07-30 12:00:00 | NQ | Futures | 23734.69 | 23752.09 | 23721.57 | 23738.97 | 30147.0 |
| 2025-07-30 13:00:00 | NQ | Futures | 23738.97 | 23756.12 | 23727.88 | 23749.82 | 22274.0 |
| 2025-07-30 14:00:00 | NQ | Futures | 23747.04 | 23794.96 | 23604.06 | 23616.67 | 87806.0 |
| 2025-07-30 15:00:00 | NQ | Futures | 23616.16 | 23694.84 | 23559.93 | 23688.54 | 117640.0 |
| 2025-07-30 16:00:00 | NQ | Futures | 23688.54 | 23895.32 | 23674.92 | 23867.84 | 50877.0 |
| 2025-07-30 18:00:00 | NQ | Futures | 23911.46 | 23951.05 | 23892.3 | 23935.42 | 8618.0 |
| 2025-07-30 19:00:00 | NQ | Futures | 23934.66 | 23946.77 | 23929.37 | 23931.64 | 4133.0 |
| 2025-07-30 20:00:00 | NQ | Futures | 23932.14 | 23965.43 | 23918.52 | 23960.64 | 5994.0 |
| 2025-07-30 21:00:00 | NQ | Futures | 23960.64 | 23987.12 | 23952.82 | 23976.78 | 4924.0 |
| 2025-07-30 22:00:00 | NQ | Futures | 23976.27 | 24000.23 | 23974.51 | 23994.18 | 3973.0 |
| 2025-07-30 23:00:00 | NQ | Futures | 23993.67 | 24008.05 | 23985.6 | 24005.02 | 3154.0 |
| 2025-07-30 00:00:00 | YM | Futures | 45816.5 | 45834.9 | 45816.5 | 45830.8 | 198.0 |
| 2025-07-30 01:00:00 | YM | Futures | 45828.7 | 45840.0 | 45810.3 | 45826.7 | 342.0 |
| 2025-07-30 02:00:00 | YM | Futures | 45825.7 | 45836.9 | 45797.1 | 45798.1 | 617.0 |
| 2025-07-30 03:00:00 | YM | Futures | 45799.1 | 45809.3 | 45753.1 | 45803.2 | 1081.0 |
> showing 50 of 2,075 rows — these rows as CSV