PREVIEW / futures_30min / 2025-03-09
file: by_date/futures_30min/2025/2025-03-09.parquet size: 28 KB rows: 762
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-03-09 18:00:00 | ES | Futures | 5899.76 | 5903.09 | 5868.74 | 5879.76 | 23901.0 |
| 2025-03-09 18:30:00 | ES | Futures | 5879.76 | 5887.97 | 5873.61 | 5874.12 | 7814.0 |
| 2025-03-09 19:00:00 | ES | Futures | 5874.12 | 5884.38 | 5856.18 | 5882.07 | 16496.0 |
| 2025-03-09 19:30:00 | ES | Futures | 5882.07 | 5883.61 | 5874.38 | 5879.51 | 5508.0 |
| 2025-03-09 20:00:00 | ES | Futures | 5879.76 | 5886.17 | 5872.33 | 5875.41 | 15897.0 |
| 2025-03-09 20:30:00 | ES | Futures | 5875.15 | 5885.15 | 5874.12 | 5884.64 | 11752.0 |
| 2025-03-09 21:00:00 | ES | Futures | 5885.15 | 5891.81 | 5883.87 | 5887.2 | 6877.0 |
| 2025-03-09 21:30:00 | ES | Futures | 5886.94 | 5899.25 | 5886.94 | 5898.74 | 6118.0 |
| 2025-03-09 22:00:00 | ES | Futures | 5898.48 | 5899.76 | 5894.89 | 5896.17 | 3137.0 |
| 2025-03-09 22:30:00 | ES | Futures | 5895.92 | 5902.07 | 5894.63 | 5898.99 | 4257.0 |
| 2025-03-09 23:00:00 | ES | Futures | 5898.99 | 5900.79 | 5891.04 | 5891.56 | 3998.0 |
| 2025-03-09 23:30:00 | ES | Futures | 5891.81 | 5901.56 | 5891.04 | 5897.2 | 2893.0 |
| 2025-03-09 18:00:00 | NQ | Futures | 20739.05 | 20739.05 | 20583.1 | 20634.83 | 8248.0 |
| 2025-03-09 18:30:00 | NQ | Futures | 20635.86 | 20666.23 | 20599.31 | 20600.09 | 3851.0 |
| 2025-03-09 19:00:00 | NQ | Futures | 20602.15 | 20651.04 | 20517.99 | 20635.86 | 5322.0 |
| 2025-03-09 19:30:00 | NQ | Futures | 20633.28 | 20641.78 | 20594.68 | 20623.25 | 2085.0 |
| 2025-03-09 20:00:00 | NQ | Futures | 20621.96 | 20649.24 | 20594.94 | 20609.09 | 5115.0 |
| 2025-03-09 20:30:00 | NQ | Futures | 20611.41 | 20657.22 | 20603.69 | 20656.45 | 4113.0 |
| 2025-03-09 21:00:00 | NQ | Futures | 20656.45 | 20687.07 | 20650.01 | 20669.83 | 4386.0 |
| 2025-03-09 21:30:00 | NQ | Futures | 20668.28 | 20728.25 | 20668.28 | 20724.9 | 4276.0 |
| 2025-03-09 22:00:00 | NQ | Futures | 20725.16 | 20733.39 | 20708.17 | 20713.83 | 2387.0 |
| 2025-03-09 22:30:00 | NQ | Futures | 20713.58 | 20748.83 | 20709.46 | 20728.5 | 2819.0 |
| 2025-03-09 23:00:00 | NQ | Futures | 20728.25 | 20743.94 | 20692.73 | 20697.11 | 2802.0 |
| 2025-03-09 23:30:00 | NQ | Futures | 20696.33 | 20738.28 | 20693.5 | 20717.44 | 1901.0 |
| 2025-03-09 18:00:00 | YM | Futures | 43972.3 | 43972.3 | 43756.2 | 43815.9 | 1460.0 |
| 2025-03-09 18:30:00 | YM | Futures | 43816.9 | 43881.7 | 43796.3 | 43797.3 | 730.0 |
| 2025-03-09 19:00:00 | YM | Futures | 43797.3 | 43858.1 | 43677.9 | 43852.9 | 1715.0 |
| 2025-03-09 19:30:00 | YM | Futures | 43853.9 | 43864.2 | 43815.9 | 43849.8 | 704.0 |
| 2025-03-09 20:00:00 | YM | Futures | 43849.8 | 43879.7 | 43793.2 | 43807.6 | 1465.0 |
| 2025-03-09 20:30:00 | YM | Futures | 43815.9 | 43862.2 | 43806.6 | 43861.1 | 939.0 |
| 2025-03-09 21:00:00 | YM | Futures | 43861.1 | 43902.3 | 43855.0 | 43871.4 | 715.0 |
| 2025-03-09 21:30:00 | YM | Futures | 43872.5 | 43932.2 | 43871.4 | 43928.0 | 776.0 |
| 2025-03-09 22:00:00 | YM | Futures | 43927.0 | 43934.2 | 43904.4 | 43922.9 | 362.0 |
| 2025-03-09 22:30:00 | YM | Futures | 43919.8 | 43944.5 | 43912.6 | 43932.2 | 358.0 |
| 2025-03-09 23:00:00 | YM | Futures | 43932.2 | 43939.4 | 43894.1 | 43897.2 | 413.0 |
| 2025-03-09 23:30:00 | YM | Futures | 43895.1 | 43952.8 | 43893.1 | 43937.3 | 250.0 |
| 2025-03-09 18:00:00 | CL | Futures | 62.41 | 62.62 | 62.05 | 62.09 | 1413.0 |
| 2025-03-09 18:30:00 | CL | Futures | 62.08 | 62.14 | 62.02 | 62.02 | 825.0 |
| 2025-03-09 19:00:00 | CL | Futures | 62.04 | 62.06 | 61.9 | 61.95 | 693.0 |
| 2025-03-09 19:30:00 | CL | Futures | 61.96 | 62.01 | 61.84 | 61.88 | 903.0 |
| 2025-03-09 20:00:00 | CL | Futures | 61.88 | 62.07 | 61.87 | 62.04 | 814.0 |
| 2025-03-09 20:30:00 | CL | Futures | 62.04 | 62.17 | 62.03 | 62.14 | 786.0 |
| 2025-03-09 21:00:00 | CL | Futures | 62.15 | 62.21 | 61.98 | 62.01 | 1242.0 |
| 2025-03-09 21:30:00 | CL | Futures | 62.02 | 62.1 | 61.96 | 62.04 | 787.0 |
| 2025-03-09 22:00:00 | CL | Futures | 62.04 | 62.08 | 61.94 | 61.96 | 657.0 |
| 2025-03-09 22:30:00 | CL | Futures | 61.96 | 62.12 | 61.96 | 61.96 | 755.0 |
| 2025-03-09 23:00:00 | CL | Futures | 61.97 | 62.01 | 61.92 | 61.95 | 727.0 |
| 2025-03-09 23:30:00 | CL | Futures | 61.94 | 62.02 | 61.87 | 61.96 | 485.0 |
| 2025-03-09 18:00:00 | GC | Futures | 3015.8 | 3019.6 | 3013.5 | 3015.2 | 1396.0 |
| 2025-03-09 18:30:00 | GC | Futures | 3015.5 | 3017.7 | 3014.9 | 3015.3 | 401.0 |
> showing 50 of 762 rows — these rows as CSV