PREVIEW / futures_30min / 2025-07-01
file: by_date/futures_30min/2025/2025-07-01.parquet size: 107 KB rows: 3,874
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-01 00:00:00 | ES | Futures | 6293.84 | 6295.61 | 6292.33 | 6293.59 | 2457.0 |
| 2025-07-01 00:30:00 | ES | Futures | 6293.59 | 6294.35 | 6290.32 | 6291.07 | 2004.0 |
| 2025-07-01 01:00:00 | ES | Futures | 6291.07 | 6291.83 | 6289.56 | 6290.57 | 2433.0 |
| 2025-07-01 01:30:00 | ES | Futures | 6290.57 | 6293.09 | 6288.3 | 6290.32 | 2793.0 |
| 2025-07-01 02:00:00 | ES | Futures | 6290.07 | 6291.33 | 6287.04 | 6289.06 | 3962.0 |
| 2025-07-01 02:30:00 | ES | Futures | 6289.31 | 6291.33 | 6287.04 | 6290.32 | 3662.0 |
| 2025-07-01 03:00:00 | ES | Futures | 6290.32 | 6297.37 | 6288.56 | 6289.06 | 8197.0 |
| 2025-07-01 03:30:00 | ES | Futures | 6289.31 | 6292.08 | 6284.78 | 6290.57 | 6113.0 |
| 2025-07-01 04:00:00 | ES | Futures | 6290.57 | 6291.58 | 6285.28 | 6291.58 | 6863.0 |
| 2025-07-01 04:30:00 | ES | Futures | 6291.58 | 6293.84 | 6287.3 | 6290.82 | 6194.0 |
| 2025-07-01 05:00:00 | ES | Futures | 6290.57 | 6291.33 | 6285.53 | 6287.3 | 5416.0 |
| 2025-07-01 05:30:00 | ES | Futures | 6287.04 | 6288.56 | 6283.01 | 6287.8 | 5232.0 |
| 2025-07-01 06:00:00 | ES | Futures | 6288.05 | 6290.07 | 6286.79 | 6286.79 | 2978.0 |
| 2025-07-01 06:30:00 | ES | Futures | 6286.79 | 6288.81 | 6285.28 | 6288.3 | 3628.0 |
| 2025-07-01 07:00:00 | ES | Futures | 6288.3 | 6290.32 | 6286.79 | 6289.06 | 5285.0 |
| 2025-07-01 07:30:00 | ES | Futures | 6289.06 | 6290.32 | 6284.02 | 6287.55 | 6627.0 |
| 2025-07-01 08:00:00 | ES | Futures | 6287.55 | 6289.06 | 6273.95 | 6277.72 | 14438.0 |
| 2025-07-01 08:30:00 | ES | Futures | 6277.47 | 6283.52 | 6276.72 | 6281.0 | 15841.0 |
| 2025-07-01 09:00:00 | ES | Futures | 6281.0 | 6285.03 | 6278.48 | 6282.01 | 16791.0 |
| 2025-07-01 09:30:00 | ES | Futures | 6282.01 | 6296.36 | 6280.75 | 6290.82 | 99383.0 |
| 2025-07-01 10:00:00 | ES | Futures | 6290.82 | 6299.89 | 6286.54 | 6290.32 | 99160.0 |
| 2025-07-01 10:30:00 | ES | Futures | 6290.32 | 6295.36 | 6279.99 | 6284.27 | 103191.0 |
| 2025-07-01 11:00:00 | ES | Futures | 6284.02 | 6294.6 | 6274.2 | 6292.33 | 118367.0 |
| 2025-07-01 11:30:00 | ES | Futures | 6292.08 | 6294.6 | 6279.99 | 6288.81 | 70848.0 |
| 2025-07-01 12:00:00 | ES | Futures | 6288.81 | 6300.65 | 6286.54 | 6292.59 | 75403.0 |
| 2025-07-01 12:30:00 | ES | Futures | 6292.59 | 6301.15 | 6289.81 | 6290.32 | 61170.0 |
| 2025-07-01 13:00:00 | ES | Futures | 6290.32 | 6302.41 | 6289.31 | 6300.65 | 55179.0 |
| 2025-07-01 13:30:00 | ES | Futures | 6300.39 | 6308.45 | 6297.37 | 6305.68 | 48302.0 |
| 2025-07-01 14:00:00 | ES | Futures | 6305.93 | 6307.19 | 6299.13 | 6300.39 | 39467.0 |
| 2025-07-01 14:30:00 | ES | Futures | 6300.14 | 6305.18 | 6299.39 | 6299.89 | 38702.0 |
| 2025-07-01 15:00:00 | ES | Futures | 6299.64 | 6303.92 | 6286.79 | 6303.92 | 102921.0 |
| 2025-07-01 15:30:00 | ES | Futures | 6303.92 | 6307.7 | 6294.1 | 6295.86 | 153674.0 |
| 2025-07-01 16:00:00 | ES | Futures | 6295.86 | 6296.87 | 6290.82 | 6293.84 | 37617.0 |
| 2025-07-01 16:30:00 | ES | Futures | 6294.1 | 6295.61 | 6293.34 | 6295.1 | 6680.0 |
| 2025-07-01 18:00:00 | ES | Futures | 6294.6 | 6298.63 | 6291.83 | 6295.61 | 3031.0 |
| 2025-07-01 18:30:00 | ES | Futures | 6295.61 | 6300.9 | 6295.36 | 6300.65 | 1934.0 |
| 2025-07-01 19:00:00 | ES | Futures | 6300.9 | 6301.9 | 6297.87 | 6299.13 | 1427.0 |
| 2025-07-01 19:30:00 | ES | Futures | 6298.88 | 6299.89 | 6297.37 | 6298.88 | 1155.0 |
| 2025-07-01 20:00:00 | ES | Futures | 6298.88 | 6301.9 | 6298.38 | 6300.14 | 2227.0 |
| 2025-07-01 20:30:00 | ES | Futures | 6300.14 | 6300.9 | 6298.88 | 6300.14 | 1272.0 |
| 2025-07-01 21:00:00 | ES | Futures | 6300.14 | 6300.65 | 6297.62 | 6298.63 | 1477.0 |
| 2025-07-01 21:30:00 | ES | Futures | 6298.63 | 6299.64 | 6294.35 | 6294.6 | 2078.0 |
| 2025-07-01 22:00:00 | ES | Futures | 6294.6 | 6299.64 | 6291.83 | 6299.39 | 2749.0 |
| 2025-07-01 22:30:00 | ES | Futures | 6299.39 | 6305.93 | 6298.63 | 6305.68 | 3079.0 |
| 2025-07-01 23:00:00 | ES | Futures | 6305.93 | 6307.7 | 6304.93 | 6305.93 | 2384.0 |
| 2025-07-01 23:30:00 | ES | Futures | 6305.68 | 6307.19 | 6304.93 | 6306.19 | 1183.0 |
| 2025-07-01 00:00:00 | NQ | Futures | 23072.22 | 23077.26 | 23064.65 | 23068.18 | 1251.0 |
| 2025-07-01 00:30:00 | NQ | Futures | 23067.93 | 23072.72 | 23053.05 | 23056.33 | 1238.0 |
| 2025-07-01 01:00:00 | NQ | Futures | 23056.58 | 23060.87 | 23039.43 | 23048.51 | 1727.0 |
| 2025-07-01 01:30:00 | NQ | Futures | 23048.01 | 23055.82 | 23036.15 | 23040.44 | 2019.0 |
> showing 50 of 3,874 rows — these rows as CSV