PREVIEW / futures_30min / 2025-04-27
file: by_date/futures_30min/2025/2025-04-27.parquet size: 30 KB rows: 856
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-04-27 18:00:00 | ES | Futures | 5633.59 | 5637.15 | 5621.4 | 5632.32 | 5996.0 |
| 2025-04-27 18:30:00 | ES | Futures | 5632.83 | 5632.83 | 5621.91 | 5622.67 | 4001.0 |
| 2025-04-27 19:00:00 | ES | Futures | 5622.67 | 5624.19 | 5616.32 | 5620.89 | 3430.0 |
| 2025-04-27 19:30:00 | ES | Futures | 5620.89 | 5623.68 | 5618.86 | 5620.13 | 1672.0 |
| 2025-04-27 20:00:00 | ES | Futures | 5620.38 | 5623.43 | 5612.51 | 5616.83 | 3680.0 |
| 2025-04-27 20:30:00 | ES | Futures | 5616.57 | 5619.37 | 5608.7 | 5610.73 | 3165.0 |
| 2025-04-27 21:00:00 | ES | Futures | 5610.98 | 5615.56 | 5609.2 | 5611.24 | 2313.0 |
| 2025-04-27 21:30:00 | ES | Futures | 5611.74 | 5614.29 | 5606.92 | 5613.52 | 3377.0 |
| 2025-04-27 22:00:00 | ES | Futures | 5613.52 | 5618.1 | 5612.25 | 5616.32 | 3706.0 |
| 2025-04-27 22:30:00 | ES | Futures | 5616.32 | 5616.83 | 5608.7 | 5611.49 | 2128.0 |
| 2025-04-27 23:00:00 | ES | Futures | 5612.0 | 5613.01 | 5605.39 | 5609.46 | 2694.0 |
| 2025-04-27 23:30:00 | ES | Futures | 5609.71 | 5610.22 | 5606.16 | 5607.43 | 1129.0 |
| 2025-04-27 18:00:00 | NQ | Futures | 19887.87 | 19887.87 | 19817.08 | 19871.32 | 4250.0 |
| 2025-04-27 18:30:00 | NQ | Futures | 19872.08 | 19874.12 | 19811.99 | 19822.68 | 2406.0 |
| 2025-04-27 19:00:00 | NQ | Futures | 19821.92 | 19830.58 | 19796.96 | 19823.19 | 2002.0 |
| 2025-04-27 19:30:00 | NQ | Futures | 19824.46 | 19837.45 | 19810.46 | 19816.82 | 1270.0 |
| 2025-04-27 20:00:00 | NQ | Futures | 19819.12 | 19833.89 | 19776.08 | 19798.49 | 2398.0 |
| 2025-04-27 20:30:00 | NQ | Futures | 19796.96 | 19807.15 | 19763.35 | 19774.81 | 2103.0 |
| 2025-04-27 21:00:00 | NQ | Futures | 19774.3 | 19794.42 | 19765.89 | 19774.55 | 1863.0 |
| 2025-04-27 21:30:00 | NQ | Futures | 19774.55 | 19792.12 | 19753.16 | 19791.11 | 1798.0 |
| 2025-04-27 22:00:00 | NQ | Futures | 19791.61 | 19814.28 | 19787.03 | 19806.64 | 2044.0 |
| 2025-04-27 22:30:00 | NQ | Futures | 19806.89 | 19809.95 | 19767.17 | 19778.88 | 1753.0 |
| 2025-04-27 23:00:00 | NQ | Futures | 19779.14 | 19783.72 | 19757.75 | 19771.5 | 1729.0 |
| 2025-04-27 23:30:00 | NQ | Futures | 19771.5 | 19775.32 | 19756.22 | 19765.39 | 893.0 |
| 2025-04-27 18:00:00 | YM | Futures | 41404.4 | 41408.5 | 41301.5 | 41373.6 | 640.0 |
| 2025-04-27 18:30:00 | YM | Futures | 41381.8 | 41384.9 | 41321.1 | 41330.3 | 137.0 |
| 2025-04-27 19:00:00 | YM | Futures | 41325.2 | 41332.4 | 41290.2 | 41310.8 | 207.0 |
| 2025-04-27 19:30:00 | YM | Futures | 41318.0 | 41323.1 | 41285.0 | 41303.6 | 97.0 |
| 2025-04-27 20:00:00 | YM | Futures | 41301.5 | 41318.0 | 41265.5 | 41282.0 | 338.0 |
| 2025-04-27 20:30:00 | YM | Futures | 41283.0 | 41310.8 | 41253.1 | 41264.5 | 396.0 |
| 2025-04-27 21:00:00 | YM | Futures | 41259.3 | 41289.2 | 41255.2 | 41277.8 | 257.0 |
| 2025-04-27 21:30:00 | YM | Futures | 41280.9 | 41280.9 | 41247.0 | 41268.6 | 190.0 |
| 2025-04-27 22:00:00 | YM | Futures | 41269.6 | 41300.5 | 41266.5 | 41288.1 | 241.0 |
| 2025-04-27 22:30:00 | YM | Futures | 41285.0 | 41296.4 | 41255.2 | 41264.5 | 173.0 |
| 2025-04-27 23:00:00 | YM | Futures | 41271.7 | 41278.9 | 41235.6 | 41254.2 | 279.0 |
| 2025-04-27 23:30:00 | YM | Futures | 41256.2 | 41261.4 | 41240.8 | 41247.0 | 108.0 |
| 2025-04-27 18:00:00 | CL | Futures | 59.29 | 59.69 | 58.88 | 59.11 | 2839.0 |
| 2025-04-27 18:30:00 | CL | Futures | 59.09 | 59.49 | 59.04 | 59.19 | 1625.0 |
| 2025-04-27 19:00:00 | CL | Futures | 59.19 | 59.24 | 59.1 | 59.22 | 595.0 |
| 2025-04-27 19:30:00 | CL | Futures | 59.21 | 59.22 | 58.9 | 58.94 | 1855.0 |
| 2025-04-27 20:00:00 | CL | Futures | 58.94 | 59.08 | 58.9 | 58.97 | 854.0 |
| 2025-04-27 20:30:00 | CL | Futures | 58.97 | 59.09 | 58.93 | 58.98 | 690.0 |
| 2025-04-27 21:00:00 | CL | Futures | 58.98 | 59.18 | 58.93 | 58.95 | 956.0 |
| 2025-04-27 21:30:00 | CL | Futures | 58.94 | 58.96 | 58.78 | 58.8 | 1251.0 |
| 2025-04-27 22:00:00 | CL | Futures | 58.79 | 58.84 | 58.72 | 58.77 | 652.0 |
| 2025-04-27 22:30:00 | CL | Futures | 58.78 | 58.83 | 58.73 | 58.74 | 360.0 |
| 2025-04-27 23:00:00 | CL | Futures | 58.74 | 59.09 | 58.74 | 59.09 | 876.0 |
| 2025-04-27 23:30:00 | CL | Futures | 59.1 | 59.11 | 58.98 | 59.0 | 539.0 |
| 2025-04-27 18:00:00 | GC | Futures | 3446.8 | 3458.9 | 3435.8 | 3437.0 | 5632.0 |
| 2025-04-27 18:30:00 | GC | Futures | 3437.0 | 3437.4 | 3428.9 | 3430.7 | 2759.0 |
> showing 50 of 856 rows — these rows as CSV