PREVIEW / futures_30min / 2024-04-25
file: by_date/futures_30min/2024/2024-04-25.parquet size: 112 KB rows: 4,042
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-04-25 00:00:00 | ES | Futures | 5384.71 | 5384.97 | 5383.65 | 5383.91 | 688.0 |
| 2024-04-25 00:30:00 | ES | Futures | 5383.91 | 5386.56 | 5383.65 | 5384.71 | 1434.0 |
| 2024-04-25 01:00:00 | ES | Futures | 5384.71 | 5385.24 | 5378.07 | 5379.67 | 4279.0 |
| 2024-04-25 01:30:00 | ES | Futures | 5379.4 | 5382.05 | 5377.28 | 5379.14 | 3394.0 |
| 2024-04-25 02:00:00 | ES | Futures | 5379.14 | 5381.79 | 5377.01 | 5377.81 | 3405.0 |
| 2024-04-25 02:30:00 | ES | Futures | 5377.81 | 5387.36 | 5376.48 | 5386.3 | 6342.0 |
| 2024-04-25 03:00:00 | ES | Futures | 5386.3 | 5388.95 | 5379.14 | 5380.2 | 11538.0 |
| 2024-04-25 03:30:00 | ES | Futures | 5380.2 | 5386.03 | 5380.2 | 5383.12 | 7110.0 |
| 2024-04-25 04:00:00 | ES | Futures | 5382.85 | 5391.6 | 5382.05 | 5388.16 | 9259.0 |
| 2024-04-25 04:30:00 | ES | Futures | 5387.89 | 5392.67 | 5387.36 | 5390.01 | 6215.0 |
| 2024-04-25 05:00:00 | ES | Futures | 5389.75 | 5391.34 | 5388.16 | 5390.28 | 4385.0 |
| 2024-04-25 05:30:00 | ES | Futures | 5390.28 | 5393.46 | 5389.22 | 5390.81 | 7487.0 |
| 2024-04-25 06:00:00 | ES | Futures | 5390.81 | 5392.4 | 5386.3 | 5388.42 | 6436.0 |
| 2024-04-25 06:30:00 | ES | Futures | 5388.69 | 5390.28 | 5382.32 | 5383.12 | 10254.0 |
| 2024-04-25 07:00:00 | ES | Futures | 5383.38 | 5387.09 | 5378.87 | 5382.05 | 9187.0 |
| 2024-04-25 07:30:00 | ES | Futures | 5382.32 | 5387.63 | 5378.61 | 5387.09 | 10314.0 |
| 2024-04-25 08:00:00 | ES | Futures | 5386.83 | 5386.83 | 5377.54 | 5381.26 | 13759.0 |
| 2024-04-25 08:30:00 | ES | Futures | 5381.52 | 5391.34 | 5351.28 | 5353.4 | 99733.0 |
| 2024-04-25 09:00:00 | ES | Futures | 5353.4 | 5356.32 | 5342.26 | 5347.83 | 78984.0 |
| 2024-04-25 09:30:00 | ES | Futures | 5347.83 | 5349.69 | 5333.5 | 5337.22 | 214339.0 |
| 2024-04-25 10:00:00 | ES | Futures | 5337.22 | 5353.67 | 5329.53 | 5352.08 | 153622.0 |
| 2024-04-25 10:30:00 | ES | Futures | 5352.08 | 5354.73 | 5336.16 | 5339.34 | 125005.0 |
| 2024-04-25 11:00:00 | ES | Futures | 5339.34 | 5353.93 | 5338.55 | 5353.14 | 86607.0 |
| 2024-04-25 11:30:00 | ES | Futures | 5353.14 | 5360.83 | 5344.91 | 5358.97 | 77075.0 |
| 2024-04-25 12:00:00 | ES | Futures | 5359.24 | 5372.5 | 5355.26 | 5370.91 | 93728.0 |
| 2024-04-25 12:30:00 | ES | Futures | 5371.18 | 5378.34 | 5365.87 | 5375.42 | 76049.0 |
| 2024-04-25 13:00:00 | ES | Futures | 5375.42 | 5381.79 | 5366.67 | 5374.63 | 76445.0 |
| 2024-04-25 13:30:00 | ES | Futures | 5374.36 | 5397.71 | 5373.03 | 5393.99 | 90437.0 |
| 2024-04-25 14:00:00 | ES | Futures | 5394.26 | 5396.38 | 5377.54 | 5377.54 | 67564.0 |
| 2024-04-25 14:30:00 | ES | Futures | 5377.54 | 5386.3 | 5374.36 | 5383.12 | 88243.0 |
| 2024-04-25 15:00:00 | ES | Futures | 5382.85 | 5402.22 | 5382.32 | 5400.89 | 86959.0 |
| 2024-04-25 15:30:00 | ES | Futures | 5400.89 | 5401.16 | 5384.97 | 5393.73 | 132189.0 |
| 2024-04-25 16:00:00 | ES | Futures | 5393.73 | 5445.72 | 5389.75 | 5437.5 | 115066.0 |
| 2024-04-25 16:30:00 | ES | Futures | 5437.5 | 5446.79 | 5435.91 | 5445.72 | 15546.0 |
| 2024-04-25 18:00:00 | ES | Futures | 5445.99 | 5448.91 | 5432.46 | 5434.58 | 8608.0 |
| 2024-04-25 18:30:00 | ES | Futures | 5434.58 | 5438.03 | 5434.32 | 5436.7 | 2774.0 |
| 2024-04-25 19:00:00 | ES | Futures | 5436.44 | 5437.24 | 5431.13 | 5432.19 | 3286.0 |
| 2024-04-25 19:30:00 | ES | Futures | 5432.46 | 5434.85 | 5429.81 | 5432.73 | 2909.0 |
| 2024-04-25 20:00:00 | ES | Futures | 5432.73 | 5434.32 | 5429.81 | 5432.73 | 4759.0 |
| 2024-04-25 20:30:00 | ES | Futures | 5433.26 | 5434.85 | 5432.73 | 5433.52 | 1874.0 |
| 2024-04-25 21:00:00 | ES | Futures | 5433.52 | 5435.38 | 5430.87 | 5434.85 | 2783.0 |
| 2024-04-25 21:30:00 | ES | Futures | 5435.11 | 5438.56 | 5434.85 | 5436.7 | 3742.0 |
| 2024-04-25 22:00:00 | ES | Futures | 5436.7 | 5438.3 | 5436.17 | 5437.77 | 2291.0 |
| 2024-04-25 22:30:00 | ES | Futures | 5437.77 | 5438.3 | 5432.73 | 5435.38 | 3465.0 |
| 2024-04-25 23:00:00 | ES | Futures | 5434.85 | 5440.42 | 5434.85 | 5439.36 | 2365.0 |
| 2024-04-25 23:30:00 | ES | Futures | 5439.36 | 5440.95 | 5435.64 | 5438.03 | 1994.0 |
| 2024-04-25 00:00:00 | NQ | Futures | 18682.48 | 18683.02 | 18676.33 | 18676.33 | 730.0 |
| 2024-04-25 00:30:00 | NQ | Futures | 18676.86 | 18684.62 | 18669.91 | 18675.79 | 1348.0 |
| 2024-04-25 01:00:00 | NQ | Futures | 18676.06 | 18677.4 | 18642.09 | 18648.78 | 3327.0 |
| 2024-04-25 01:30:00 | NQ | Futures | 18649.31 | 18660.55 | 18634.33 | 18642.36 | 2815.0 |
> showing 50 of 4,042 rows — these rows as CSV