PREVIEW / futures_30min / 2024-04-19
file: by_date/futures_30min/2024/2024-04-19.parquet size: 95 KB rows: 3,172
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-19 00:00:00 | ES | Futures | 5306.98 | 5315.46 | 5306.71 | 5313.61 | 8961.0 |
| 2024-04-19 00:30:00 | ES | Futures | 5313.61 | 5316.53 | 5306.44 | 5310.16 | 7027.0 |
| 2024-04-19 01:00:00 | ES | Futures | 5310.69 | 5315.73 | 5304.06 | 5314.4 | 6930.0 |
| 2024-04-19 01:30:00 | ES | Futures | 5314.4 | 5316.53 | 5307.77 | 5313.61 | 7634.0 |
| 2024-04-19 02:00:00 | ES | Futures | 5313.61 | 5327.14 | 5308.3 | 5321.3 | 17718.0 |
| 2024-04-19 02:30:00 | ES | Futures | 5321.83 | 5331.91 | 5321.3 | 5328.46 | 16703.0 |
| 2024-04-19 03:00:00 | ES | Futures | 5328.46 | 5336.95 | 5327.93 | 5334.83 | 20549.0 |
| 2024-04-19 03:30:00 | ES | Futures | 5335.1 | 5335.1 | 5326.87 | 5334.04 | 13600.0 |
| 2024-04-19 04:00:00 | ES | Futures | 5334.04 | 5339.34 | 5325.28 | 5335.89 | 15235.0 |
| 2024-04-19 04:30:00 | ES | Futures | 5335.89 | 5337.48 | 5325.55 | 5330.59 | 9137.0 |
| 2024-04-19 05:00:00 | ES | Futures | 5330.59 | 5338.81 | 5330.06 | 5338.01 | 8533.0 |
| 2024-04-19 05:30:00 | ES | Futures | 5338.01 | 5343.32 | 5335.89 | 5336.16 | 12199.0 |
| 2024-04-19 06:00:00 | ES | Futures | 5336.42 | 5345.18 | 5331.38 | 5335.1 | 13964.0 |
| 2024-04-19 06:30:00 | ES | Futures | 5334.83 | 5339.08 | 5328.99 | 5338.28 | 10171.0 |
| 2024-04-19 07:00:00 | ES | Futures | 5338.01 | 5347.57 | 5332.71 | 5346.24 | 19699.0 |
| 2024-04-19 07:30:00 | ES | Futures | 5346.24 | 5355.79 | 5344.38 | 5352.87 | 26964.0 |
| 2024-04-19 08:00:00 | ES | Futures | 5352.61 | 5360.83 | 5345.71 | 5359.5 | 25964.0 |
| 2024-04-19 08:30:00 | ES | Futures | 5359.77 | 5365.87 | 5353.14 | 5355.79 | 30576.0 |
| 2024-04-19 09:00:00 | ES | Futures | 5355.79 | 5357.65 | 5346.5 | 5356.06 | 65003.0 |
| 2024-04-19 09:30:00 | ES | Futures | 5356.06 | 5367.46 | 5347.57 | 5358.18 | 180310.0 |
| 2024-04-19 10:00:00 | ES | Futures | 5358.18 | 5363.75 | 5336.16 | 5345.18 | 135532.0 |
| 2024-04-19 10:30:00 | ES | Futures | 5345.44 | 5354.2 | 5335.89 | 5346.24 | 121766.0 |
| 2024-04-19 11:00:00 | ES | Futures | 5346.24 | 5351.01 | 5335.1 | 5338.81 | 89939.0 |
| 2024-04-19 11:30:00 | ES | Futures | 5339.08 | 5344.12 | 5329.26 | 5330.85 | 89572.0 |
| 2024-04-19 12:00:00 | ES | Futures | 5330.59 | 5338.01 | 5310.16 | 5310.16 | 118025.0 |
| 2024-04-19 12:30:00 | ES | Futures | 5310.42 | 5332.18 | 5308.83 | 5330.85 | 97362.0 |
| 2024-04-19 13:00:00 | ES | Futures | 5330.59 | 5337.75 | 5323.95 | 5325.02 | 93273.0 |
| 2024-04-19 13:30:00 | ES | Futures | 5325.02 | 5345.71 | 5324.48 | 5333.24 | 88868.0 |
| 2024-04-19 14:00:00 | ES | Futures | 5333.24 | 5333.77 | 5313.34 | 5313.34 | 105945.0 |
| 2024-04-19 14:30:00 | ES | Futures | 5313.34 | 5319.18 | 5297.96 | 5307.77 | 129880.0 |
| 2024-04-19 15:00:00 | ES | Futures | 5307.77 | 5316.26 | 5298.49 | 5309.36 | 115990.0 |
| 2024-04-19 15:30:00 | ES | Futures | 5309.63 | 5314.4 | 5296.63 | 5309.36 | 228533.0 |
| 2024-04-19 16:00:00 | ES | Futures | 5309.36 | 5312.02 | 5305.38 | 5311.49 | 59130.0 |
| 2024-04-19 16:30:00 | ES | Futures | 5311.22 | 5312.28 | 5307.51 | 5309.63 | 20255.0 |
| 2024-04-19 00:00:00 | NQ | Futures | 18552.47 | 18596.88 | 18550.6 | 18593.13 | 5573.0 |
| 2024-04-19 00:30:00 | NQ | Futures | 18594.47 | 18609.45 | 18574.41 | 18584.04 | 4374.0 |
| 2024-04-19 01:00:00 | NQ | Futures | 18583.24 | 18605.17 | 18561.84 | 18597.15 | 4355.0 |
| 2024-04-19 01:30:00 | NQ | Futures | 18595.54 | 18601.16 | 18565.31 | 18587.78 | 3580.0 |
| 2024-04-19 02:00:00 | NQ | Futures | 18588.59 | 18632.19 | 18565.58 | 18616.68 | 8062.0 |
| 2024-04-19 02:30:00 | NQ | Futures | 18617.21 | 18657.6 | 18613.2 | 18646.1 | 7959.0 |
| 2024-04-19 03:00:00 | NQ | Futures | 18646.64 | 18682.21 | 18642.62 | 18666.7 | 8970.0 |
| 2024-04-19 03:30:00 | NQ | Futures | 18666.7 | 18666.97 | 18632.46 | 18653.06 | 7485.0 |
| 2024-04-19 04:00:00 | NQ | Futures | 18654.39 | 18669.64 | 18606.51 | 18660.28 | 8654.0 |
| 2024-04-19 04:30:00 | NQ | Futures | 18658.94 | 18665.36 | 18612.93 | 18631.39 | 5450.0 |
| 2024-04-19 05:00:00 | NQ | Futures | 18631.92 | 18662.42 | 18628.98 | 18660.28 | 4164.0 |
| 2024-04-19 05:30:00 | NQ | Futures | 18660.55 | 18687.03 | 18652.79 | 18655.73 | 6473.0 |
| 2024-04-19 06:00:00 | NQ | Futures | 18655.46 | 18688.1 | 18636.2 | 18649.31 | 6556.0 |
| 2024-04-19 06:30:00 | NQ | Futures | 18649.58 | 18667.5 | 18627.38 | 18665.9 | 4844.0 |
| 2024-04-19 07:00:00 | NQ | Futures | 18665.63 | 18712.44 | 18650.92 | 18705.22 | 8907.0 |
| 2024-04-19 07:30:00 | NQ | Futures | 18705.75 | 18733.31 | 18695.59 | 18729.03 | 10418.0 |
> showing 50 of 3,172 rows — these rows as CSV