PREVIEW / futures_30min / 2025-07-27
file: by_date/futures_30min/2025/2025-07-27.parquet size: 29 KB rows: 824
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 | 6492.07 | 6492.57 | 12368.0 |
| 2025-07-27 18:30:00 | ES | Futures | 6492.57 | 6495.09 | 6491.06 | 6493.33 | 2459.0 |
| 2025-07-27 19:00:00 | ES | Futures | 6493.33 | 6499.63 | 6492.07 | 6497.86 | 3705.0 |
| 2025-07-27 19:30:00 | ES | Futures | 6497.86 | 6500.89 | 6496.1 | 6496.1 | 2422.0 |
| 2025-07-27 20:00:00 | ES | Futures | 6496.1 | 6498.62 | 6494.08 | 6497.11 | 3406.0 |
| 2025-07-27 20:30:00 | ES | Futures | 6496.86 | 6499.63 | 6496.1 | 6499.12 | 1637.0 |
| 2025-07-27 21:00:00 | ES | Futures | 6499.37 | 6499.37 | 6496.35 | 6497.61 | 2014.0 |
| 2025-07-27 21:30:00 | ES | Futures | 6497.61 | 6498.62 | 6496.35 | 6498.37 | 1897.0 |
| 2025-07-27 22:00:00 | ES | Futures | 6498.11 | 6499.63 | 6497.11 | 6499.37 | 1944.0 |
| 2025-07-27 22:30:00 | ES | Futures | 6499.63 | 6502.14 | 6499.12 | 6500.13 | 1984.0 |
| 2025-07-27 23:00:00 | ES | Futures | 6500.13 | 6500.38 | 6498.62 | 6498.87 | 1342.0 |
| 2025-07-27 23:30:00 | ES | Futures | 6498.87 | 6500.13 | 6498.37 | 6499.63 | 1368.0 |
| 2025-07-27 18:00:00 | NQ | Futures | 23724.85 | 23763.43 | 23710.73 | 23715.27 | 5516.0 |
| 2025-07-27 18:30:00 | NQ | Futures | 23715.02 | 23729.89 | 23708.71 | 23720.06 | 2005.0 |
| 2025-07-27 19:00:00 | NQ | Futures | 23720.82 | 23753.85 | 23717.79 | 23744.77 | 2963.0 |
| 2025-07-27 19:30:00 | NQ | Futures | 23745.02 | 23761.16 | 23737.96 | 23738.72 | 1997.0 |
| 2025-07-27 20:00:00 | NQ | Futures | 23738.97 | 23751.08 | 23730.15 | 23743.51 | 2023.0 |
| 2025-07-27 20:30:00 | NQ | Futures | 23743.76 | 23750.32 | 23738.72 | 23748.81 | 1017.0 |
| 2025-07-27 21:00:00 | NQ | Futures | 23748.56 | 23749.56 | 23735.95 | 23743.76 | 1450.0 |
| 2025-07-27 21:30:00 | NQ | Futures | 23743.26 | 23748.3 | 23738.47 | 23747.8 | 1137.0 |
| 2025-07-27 22:00:00 | NQ | Futures | 23746.79 | 23758.14 | 23742.25 | 23757.38 | 1092.0 |
| 2025-07-27 22:30:00 | NQ | Futures | 23757.89 | 23771.76 | 23754.1 | 23756.88 | 2088.0 |
| 2025-07-27 23:00:00 | NQ | Futures | 23756.63 | 23757.89 | 23749.31 | 23750.57 | 979.0 |
| 2025-07-27 23:30:00 | NQ | Futures | 23749.82 | 23756.88 | 23746.79 | 23753.6 | 644.0 |
| 2025-07-27 18:00:00 | YM | Futures | 46221.0 | 46276.2 | 46201.6 | 46201.6 | 770.0 |
| 2025-07-27 18:30:00 | YM | Futures | 46209.8 | 46219.0 | 46188.3 | 46207.7 | 100.0 |
| 2025-07-27 19:00:00 | YM | Futures | 46200.6 | 46232.3 | 46190.4 | 46222.0 | 457.0 |
| 2025-07-27 19:30:00 | YM | Futures | 46222.0 | 46236.3 | 46203.7 | 46203.7 | 248.0 |
| 2025-07-27 20:00:00 | YM | Futures | 46201.6 | 46216.9 | 46189.4 | 46212.8 | 398.0 |
| 2025-07-27 20:30:00 | YM | Futures | 46209.8 | 46235.3 | 46207.7 | 46232.3 | 176.0 |
| 2025-07-27 21:00:00 | YM | Futures | 46231.2 | 46234.3 | 46207.7 | 46214.9 | 148.0 |
| 2025-07-27 21:30:00 | YM | Futures | 46215.9 | 46220.0 | 46202.6 | 46218.0 | 184.0 |
| 2025-07-27 22:00:00 | YM | Futures | 46216.9 | 46220.0 | 46204.7 | 46220.0 | 176.0 |
| 2025-07-27 22:30:00 | YM | Futures | 46220.0 | 46237.4 | 46220.0 | 46231.2 | 182.0 |
| 2025-07-27 23:00:00 | YM | Futures | 46230.2 | 46230.2 | 46222.0 | 46223.1 | 65.0 |
| 2025-07-27 23:30:00 | YM | Futures | 46225.1 | 46235.3 | 46221.0 | 46231.2 | 69.0 |
| 2025-07-27 18:00:00 | CL | Futures | 62.47 | 62.67 | 62.38 | 62.52 | 1243.0 |
| 2025-07-27 18:30:00 | CL | Futures | 62.52 | 62.54 | 62.45 | 62.45 | 280.0 |
| 2025-07-27 19:00:00 | CL | Futures | 62.46 | 62.54 | 62.44 | 62.54 | 287.0 |
| 2025-07-27 19:30:00 | CL | Futures | 62.54 | 62.62 | 62.54 | 62.61 | 188.0 |
| 2025-07-27 20:00:00 | CL | Futures | 62.62 | 62.7 | 62.58 | 62.66 | 631.0 |
| 2025-07-27 20:30:00 | CL | Futures | 62.66 | 62.72 | 62.65 | 62.72 | 361.0 |
| 2025-07-27 21:00:00 | CL | Futures | 62.71 | 62.87 | 62.65 | 62.79 | 1586.0 |
| 2025-07-27 21:30:00 | CL | Futures | 62.8 | 62.88 | 62.66 | 62.7 | 1108.0 |
| 2025-07-27 22:00:00 | CL | Futures | 62.7 | 62.73 | 62.65 | 62.73 | 493.0 |
| 2025-07-27 22:30:00 | CL | Futures | 62.73 | 62.81 | 62.72 | 62.79 | 384.0 |
| 2025-07-27 23:00:00 | CL | Futures | 62.78 | 62.79 | 62.61 | 62.64 | 942.0 |
| 2025-07-27 23:30:00 | CL | Futures | 62.65 | 62.69 | 62.6 | 62.67 | 356.0 |
| 2025-07-27 18:00:00 | GC | Futures | 3432.7 | 3444.7 | 3412.7 | 3441.1 | 774.0 |
| 2025-07-27 18:30:00 | GC | Futures | 3441.4 | 3442.8 | 3433.8 | 3440.2 | 313.0 |
> showing 50 of 824 rows — these rows as CSV