PREVIEW / futures_30min / 2024-01-25
file: by_date/futures_30min/2024/2024-01-25.parquet size: 109 KB rows: 3,953
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-25 00:00:00 | ES | Futures | 5261.69 | 5263.3 | 5260.88 | 5262.5 | 1647.0 |
| 2024-01-25 00:30:00 | ES | Futures | 5262.5 | 5265.99 | 5261.96 | 5265.45 | 2362.0 |
| 2024-01-25 01:00:00 | ES | Futures | 5265.72 | 5265.99 | 5263.03 | 5264.38 | 2295.0 |
| 2024-01-25 01:30:00 | ES | Futures | 5264.38 | 5266.26 | 5262.76 | 5264.64 | 2403.0 |
| 2024-01-25 02:00:00 | ES | Futures | 5264.91 | 5269.48 | 5263.84 | 5267.06 | 5254.0 |
| 2024-01-25 02:30:00 | ES | Futures | 5267.06 | 5267.6 | 5264.64 | 5264.91 | 3368.0 |
| 2024-01-25 03:00:00 | ES | Futures | 5264.91 | 5266.52 | 5261.42 | 5264.11 | 9910.0 |
| 2024-01-25 03:30:00 | ES | Futures | 5264.38 | 5267.87 | 5263.84 | 5265.99 | 6855.0 |
| 2024-01-25 04:00:00 | ES | Futures | 5265.99 | 5266.79 | 5263.03 | 5265.99 | 6518.0 |
| 2024-01-25 04:30:00 | ES | Futures | 5265.99 | 5269.21 | 5265.45 | 5266.52 | 5537.0 |
| 2024-01-25 05:00:00 | ES | Futures | 5266.26 | 5266.79 | 5263.03 | 5263.84 | 4511.0 |
| 2024-01-25 05:30:00 | ES | Futures | 5263.84 | 5266.26 | 5263.03 | 5264.91 | 3851.0 |
| 2024-01-25 06:00:00 | ES | Futures | 5264.91 | 5267.06 | 5263.84 | 5266.26 | 5182.0 |
| 2024-01-25 06:30:00 | ES | Futures | 5265.99 | 5267.6 | 5263.03 | 5267.33 | 13104.0 |
| 2024-01-25 07:00:00 | ES | Futures | 5267.33 | 5268.94 | 5263.84 | 5265.99 | 9589.0 |
| 2024-01-25 07:30:00 | ES | Futures | 5265.72 | 5267.6 | 5260.62 | 5261.15 | 7449.0 |
| 2024-01-25 08:00:00 | ES | Futures | 5261.15 | 5267.87 | 5260.62 | 5266.26 | 14478.0 |
| 2024-01-25 08:30:00 | ES | Futures | 5265.99 | 5283.71 | 5259.54 | 5281.3 | 59054.0 |
| 2024-01-25 09:00:00 | ES | Futures | 5281.3 | 5286.4 | 5279.69 | 5284.79 | 31690.0 |
| 2024-01-25 09:30:00 | ES | Futures | 5284.79 | 5286.13 | 5275.93 | 5282.1 | 137680.0 |
| 2024-01-25 10:00:00 | ES | Futures | 5282.1 | 5292.85 | 5277.27 | 5290.43 | 108461.0 |
| 2024-01-25 10:30:00 | ES | Futures | 5290.43 | 5291.23 | 5277.0 | 5280.22 | 98930.0 |
| 2024-01-25 11:00:00 | ES | Futures | 5280.22 | 5287.74 | 5276.46 | 5286.94 | 71927.0 |
| 2024-01-25 11:30:00 | ES | Futures | 5286.94 | 5290.43 | 5281.03 | 5285.06 | 74697.0 |
| 2024-01-25 12:00:00 | ES | Futures | 5285.06 | 5286.4 | 5271.63 | 5274.31 | 96807.0 |
| 2024-01-25 12:30:00 | ES | Futures | 5274.31 | 5275.93 | 5269.21 | 5273.78 | 61555.0 |
| 2024-01-25 13:00:00 | ES | Futures | 5273.51 | 5281.83 | 5268.4 | 5270.55 | 78718.0 |
| 2024-01-25 13:30:00 | ES | Futures | 5270.55 | 5276.46 | 5265.18 | 5267.33 | 72964.0 |
| 2024-01-25 14:00:00 | ES | Futures | 5267.06 | 5270.82 | 5260.88 | 5269.21 | 87210.0 |
| 2024-01-25 14:30:00 | ES | Futures | 5269.48 | 5274.85 | 5265.45 | 5274.85 | 58011.0 |
| 2024-01-25 15:00:00 | ES | Futures | 5274.58 | 5277.54 | 5270.82 | 5273.51 | 59464.0 |
| 2024-01-25 15:30:00 | ES | Futures | 5273.78 | 5290.7 | 5272.16 | 5290.16 | 144389.0 |
| 2024-01-25 16:00:00 | ES | Futures | 5290.16 | 5291.5 | 5286.4 | 5289.35 | 54319.0 |
| 2024-01-25 16:30:00 | ES | Futures | 5289.35 | 5291.77 | 5284.52 | 5284.79 | 21167.0 |
| 2024-01-25 18:00:00 | ES | Futures | 5285.06 | 5285.33 | 5277.81 | 5278.34 | 7397.0 |
| 2024-01-25 18:30:00 | ES | Futures | 5278.34 | 5281.03 | 5277.54 | 5279.15 | 3341.0 |
| 2024-01-25 19:00:00 | ES | Futures | 5279.15 | 5280.49 | 5276.73 | 5277.81 | 3776.0 |
| 2024-01-25 19:30:00 | ES | Futures | 5278.07 | 5280.49 | 5277.81 | 5277.81 | 2984.0 |
| 2024-01-25 20:00:00 | ES | Futures | 5278.07 | 5278.07 | 5274.85 | 5276.73 | 5677.0 |
| 2024-01-25 20:30:00 | ES | Futures | 5276.73 | 5277.27 | 5275.66 | 5277.0 | 3322.0 |
| 2024-01-25 21:00:00 | ES | Futures | 5277.0 | 5280.22 | 5276.73 | 5279.69 | 2696.0 |
| 2024-01-25 21:30:00 | ES | Futures | 5279.69 | 5281.03 | 5275.39 | 5275.39 | 2808.0 |
| 2024-01-25 22:00:00 | ES | Futures | 5275.66 | 5277.0 | 5274.85 | 5275.39 | 2334.0 |
| 2024-01-25 22:30:00 | ES | Futures | 5275.39 | 5276.46 | 5274.31 | 5274.85 | 1618.0 |
| 2024-01-25 23:00:00 | ES | Futures | 5274.85 | 5275.39 | 5269.48 | 5270.55 | 4615.0 |
| 2024-01-25 23:30:00 | ES | Futures | 5270.28 | 5272.16 | 5265.72 | 5267.06 | 5044.0 |
| 2024-01-25 00:00:00 | NQ | Futures | 19103.18 | 19111.59 | 19097.49 | 19108.88 | 1420.0 |
| 2024-01-25 00:30:00 | NQ | Futures | 19108.06 | 19122.44 | 19106.16 | 19121.08 | 1340.0 |
| 2024-01-25 01:00:00 | NQ | Futures | 19120.81 | 19121.35 | 19107.79 | 19116.2 | 1555.0 |
| 2024-01-25 01:30:00 | NQ | Futures | 19116.47 | 19125.96 | 19109.15 | 19118.37 | 1690.0 |
> showing 50 of 3,953 rows — these rows as CSV