PREVIEW / futures_1hour / 2025-06-23
file: by_date/futures_1hour/2025/2025-06-23.parquet size: 70 KB rows: 2,088
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-06-23 00:00:00 | ES | Futures | 6047.01 | 6048.77 | 6045.5 | 6046.76 | 2887.0 |
| 2025-06-23 01:00:00 | ES | Futures | 6046.76 | 6057.33 | 6046.5 | 6054.06 | 5956.0 |
| 2025-06-23 02:00:00 | ES | Futures | 6054.06 | 6060.86 | 6051.29 | 6056.33 | 7244.0 |
| 2025-06-23 03:00:00 | ES | Futures | 6056.33 | 6075.22 | 6056.07 | 6073.45 | 16146.0 |
| 2025-06-23 04:00:00 | ES | Futures | 6073.45 | 6084.54 | 6070.94 | 6078.24 | 14487.0 |
| 2025-06-23 05:00:00 | ES | Futures | 6078.24 | 6083.28 | 6072.19 | 6074.46 | 9958.0 |
| 2025-06-23 06:00:00 | ES | Futures | 6074.46 | 6083.28 | 6065.65 | 6066.65 | 17028.0 |
| 2025-06-23 07:00:00 | ES | Futures | 6067.16 | 6068.67 | 6047.51 | 6057.84 | 18134.0 |
| 2025-06-23 08:00:00 | ES | Futures | 6058.09 | 6072.95 | 6056.33 | 6071.94 | 16750.0 |
| 2025-06-23 09:00:00 | ES | Futures | 6071.94 | 6087.06 | 6055.57 | 6086.8 | 123442.0 |
| 2025-06-23 10:00:00 | ES | Futures | 6086.8 | 6103.68 | 6084.54 | 6085.04 | 156978.0 |
| 2025-06-23 11:00:00 | ES | Futures | 6085.29 | 6097.38 | 6077.74 | 6078.74 | 111750.0 |
| 2025-06-23 12:00:00 | ES | Futures | 6079.0 | 6081.26 | 6038.19 | 6055.82 | 235323.0 |
| 2025-06-23 13:00:00 | ES | Futures | 6055.82 | 6115.27 | 6051.54 | 6106.95 | 194216.0 |
| 2025-06-23 14:00:00 | ES | Futures | 6106.95 | 6113.0 | 6101.16 | 6106.7 | 85893.0 |
| 2025-06-23 15:00:00 | ES | Futures | 6106.45 | 6127.1 | 6105.69 | 6122.32 | 173748.0 |
| 2025-06-23 16:00:00 | ES | Futures | 6122.57 | 6124.58 | 6117.78 | 6123.07 | 45396.0 |
| 2025-06-23 18:00:00 | ES | Futures | 6123.58 | 6151.28 | 6120.81 | 6147.25 | 24275.0 |
| 2025-06-23 19:00:00 | ES | Futures | 6147.25 | 6158.84 | 6146.5 | 6154.31 | 12114.0 |
| 2025-06-23 20:00:00 | ES | Futures | 6154.81 | 6157.08 | 6144.99 | 6152.79 | 12571.0 |
| 2025-06-23 21:00:00 | ES | Futures | 6152.54 | 6162.37 | 6149.02 | 6160.85 | 7752.0 |
| 2025-06-23 22:00:00 | ES | Futures | 6160.6 | 6161.11 | 6149.77 | 6153.3 | 8456.0 |
| 2025-06-23 23:00:00 | ES | Futures | 6153.05 | 6158.59 | 6152.54 | 6157.58 | 4460.0 |
| 2025-06-23 00:00:00 | NQ | Futures | 21956.33 | 21963.64 | 21947.0 | 21954.57 | 1849.0 |
| 2025-06-23 01:00:00 | NQ | Futures | 21954.57 | 22006.01 | 21953.3 | 21999.71 | 4828.0 |
| 2025-06-23 02:00:00 | NQ | Futures | 21999.45 | 22025.93 | 21987.6 | 22009.29 | 5080.0 |
| 2025-06-23 03:00:00 | NQ | Futures | 22009.79 | 22095.53 | 22009.04 | 22086.2 | 10136.0 |
| 2025-06-23 04:00:00 | NQ | Futures | 22086.71 | 22135.38 | 22069.56 | 22096.54 | 8402.0 |
| 2025-06-23 05:00:00 | NQ | Futures | 22097.3 | 22125.29 | 22071.83 | 22074.1 | 5909.0 |
| 2025-06-23 06:00:00 | NQ | Futures | 22074.35 | 22115.71 | 22036.52 | 22048.12 | 8209.0 |
| 2025-06-23 07:00:00 | NQ | Futures | 22048.63 | 22054.68 | 21964.65 | 22014.84 | 11085.0 |
| 2025-06-23 08:00:00 | NQ | Futures | 22015.34 | 22077.12 | 22007.27 | 22074.1 | 9685.0 |
| 2025-06-23 09:00:00 | NQ | Futures | 22073.85 | 22119.49 | 21948.01 | 22116.21 | 62615.0 |
| 2025-06-23 10:00:00 | NQ | Futures | 22116.21 | 22209.77 | 22116.21 | 22145.21 | 67330.0 |
| 2025-06-23 11:00:00 | NQ | Futures | 22146.47 | 22197.92 | 22113.18 | 22129.58 | 43220.0 |
| 2025-06-23 12:00:00 | NQ | Futures | 22129.83 | 22136.39 | 21927.58 | 22030.98 | 89971.0 |
| 2025-06-23 13:00:00 | NQ | Futures | 22031.48 | 22280.38 | 22011.56 | 22244.07 | 78380.0 |
| 2025-06-23 14:00:00 | NQ | Futures | 22244.07 | 22277.86 | 22213.05 | 22227.93 | 34276.0 |
| 2025-06-23 15:00:00 | NQ | Futures | 22227.93 | 22285.42 | 22215.82 | 22265.0 | 49795.0 |
| 2025-06-23 16:00:00 | NQ | Futures | 22265.0 | 22278.36 | 22244.82 | 22264.49 | 14846.0 |
| 2025-06-23 18:00:00 | NQ | Futures | 22271.3 | 22410.5 | 22257.93 | 22396.88 | 12562.0 |
| 2025-06-23 19:00:00 | NQ | Futures | 22397.89 | 22448.83 | 22393.86 | 22430.93 | 8017.0 |
| 2025-06-23 20:00:00 | NQ | Futures | 22430.93 | 22442.53 | 22387.3 | 22420.34 | 7073.0 |
| 2025-06-23 21:00:00 | NQ | Futures | 22420.59 | 22465.48 | 22407.98 | 22459.68 | 5763.0 |
| 2025-06-23 22:00:00 | NQ | Futures | 22459.42 | 22462.96 | 22408.74 | 22428.66 | 7007.0 |
| 2025-06-23 23:00:00 | NQ | Futures | 22427.9 | 22445.81 | 22422.61 | 22440.26 | 2633.0 |
| 2025-06-23 00:00:00 | YM | Futures | 43297.3 | 43310.6 | 43285.0 | 43292.2 | 391.0 |
| 2025-06-23 01:00:00 | YM | Futures | 43293.2 | 43356.5 | 43291.2 | 43338.1 | 872.0 |
| 2025-06-23 02:00:00 | YM | Futures | 43339.2 | 43363.7 | 43304.4 | 43330.0 | 1520.0 |
| 2025-06-23 03:00:00 | YM | Futures | 43332.0 | 43473.0 | 43327.9 | 43461.8 | 3024.0 |
> showing 50 of 2,088 rows — these rows as CSV