PREVIEW / futures_1hour / 2025-07-27
file: by_date/futures_1hour/2025/2025-07-27.parquet size: 19 KB rows: 430
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-27 18:00:00 | ES | Futures | 6498.37 | 6503.4 | 6491.06 | 6493.33 | 14827.0 |
| 2025-07-27 19:00:00 | ES | Futures | 6493.33 | 6500.89 | 6492.07 | 6496.1 | 6127.0 |
| 2025-07-27 20:00:00 | ES | Futures | 6496.1 | 6499.63 | 6494.08 | 6499.12 | 5043.0 |
| 2025-07-27 21:00:00 | ES | Futures | 6499.37 | 6499.37 | 6496.35 | 6498.37 | 3911.0 |
| 2025-07-27 22:00:00 | ES | Futures | 6498.11 | 6502.14 | 6497.11 | 6500.13 | 3928.0 |
| 2025-07-27 23:00:00 | ES | Futures | 6500.13 | 6500.38 | 6498.37 | 6499.63 | 2710.0 |
| 2025-07-27 18:00:00 | NQ | Futures | 23724.85 | 23763.43 | 23708.71 | 23720.06 | 7521.0 |
| 2025-07-27 19:00:00 | NQ | Futures | 23720.82 | 23761.16 | 23717.79 | 23738.72 | 4960.0 |
| 2025-07-27 20:00:00 | NQ | Futures | 23738.97 | 23751.08 | 23730.15 | 23748.81 | 3040.0 |
| 2025-07-27 21:00:00 | NQ | Futures | 23748.56 | 23749.56 | 23735.95 | 23747.8 | 2587.0 |
| 2025-07-27 22:00:00 | NQ | Futures | 23746.79 | 23771.76 | 23742.25 | 23756.88 | 3180.0 |
| 2025-07-27 23:00:00 | NQ | Futures | 23756.63 | 23757.89 | 23746.79 | 23753.6 | 1623.0 |
| 2025-07-27 18:00:00 | YM | Futures | 46221.0 | 46276.2 | 46188.3 | 46207.7 | 870.0 |
| 2025-07-27 19:00:00 | YM | Futures | 46200.6 | 46236.3 | 46190.4 | 46203.7 | 705.0 |
| 2025-07-27 20:00:00 | YM | Futures | 46201.6 | 46235.3 | 46189.4 | 46232.3 | 574.0 |
| 2025-07-27 21:00:00 | YM | Futures | 46231.2 | 46234.3 | 46202.6 | 46218.0 | 332.0 |
| 2025-07-27 22:00:00 | YM | Futures | 46216.9 | 46237.4 | 46204.7 | 46231.2 | 358.0 |
| 2025-07-27 23:00:00 | YM | Futures | 46230.2 | 46235.3 | 46221.0 | 46231.2 | 134.0 |
| 2025-07-27 18:00:00 | CL | Futures | 62.47 | 62.67 | 62.38 | 62.45 | 1523.0 |
| 2025-07-27 19:00:00 | CL | Futures | 62.46 | 62.62 | 62.44 | 62.61 | 475.0 |
| 2025-07-27 20:00:00 | CL | Futures | 62.62 | 62.72 | 62.58 | 62.72 | 992.0 |
| 2025-07-27 21:00:00 | CL | Futures | 62.71 | 62.88 | 62.65 | 62.7 | 2694.0 |
| 2025-07-27 22:00:00 | CL | Futures | 62.7 | 62.81 | 62.65 | 62.79 | 877.0 |
| 2025-07-27 23:00:00 | CL | Futures | 62.78 | 62.79 | 62.6 | 62.67 | 1298.0 |
| 2025-07-27 18:00:00 | GC | Futures | 3432.7 | 3444.7 | 3412.7 | 3440.2 | 1087.0 |
| 2025-07-27 19:00:00 | GC | Futures | 3439.4 | 3447.4 | 3439.0 | 3444.1 | 685.0 |
| 2025-07-27 20:00:00 | GC | Futures | 3444.2 | 3445.7 | 3437.8 | 3443.8 | 760.0 |
| 2025-07-27 21:00:00 | GC | Futures | 3443.7 | 3449.5 | 3440.2 | 3441.9 | 1290.0 |
| 2025-07-27 22:00:00 | GC | Futures | 3441.9 | 3447.0 | 3440.4 | 3446.1 | 359.0 |
| 2025-07-27 23:00:00 | GC | Futures | 3445.3 | 3453.6 | 3445.3 | 3453.6 | 532.0 |
| 2025-07-27 18:00:00 | ZN | Futures | 110.905928 | 110.921555 | 110.843419 | 110.890301 | 17091.0 |
| 2025-07-27 19:00:00 | ZN | Futures | 110.890301 | 110.905928 | 110.827792 | 110.859046 | 7785.0 |
| 2025-07-27 20:00:00 | ZN | Futures | 110.859046 | 110.905928 | 110.827792 | 110.890301 | 11098.0 |
| 2025-07-27 21:00:00 | ZN | Futures | 110.905928 | 110.968437 | 110.905928 | 110.937182 | 10837.0 |
| 2025-07-27 22:00:00 | ZN | Futures | 110.937182 | 110.952809 | 110.921555 | 110.921555 | 4276.0 |
| 2025-07-27 23:00:00 | ZN | Futures | 110.937182 | 110.968437 | 110.905928 | 110.952809 | 10537.0 |
> showing 36 of 430 rows — these rows as CSV