PREVIEW / futures_30min / 2024-07-25
file: by_date/futures_30min/2024/2024-07-25.parquet size: 117 KB rows: 4,061
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-07-25 00:00:00 | ES | Futures | 5750.83 | 5752.4 | 5748.99 | 5750.57 | 2762.0 |
| 2024-07-25 00:30:00 | ES | Futures | 5750.57 | 5751.88 | 5747.94 | 5749.52 | 2835.0 |
| 2024-07-25 01:00:00 | ES | Futures | 5749.52 | 5751.88 | 5748.47 | 5749.78 | 2737.0 |
| 2024-07-25 01:30:00 | ES | Futures | 5749.52 | 5750.04 | 5744.27 | 5744.8 | 3870.0 |
| 2024-07-25 02:00:00 | ES | Futures | 5744.8 | 5745.32 | 5727.23 | 5743.75 | 24311.0 |
| 2024-07-25 02:30:00 | ES | Futures | 5743.49 | 5749.78 | 5742.18 | 5746.37 | 9844.0 |
| 2024-07-25 03:00:00 | ES | Futures | 5746.37 | 5749.26 | 5728.28 | 5737.72 | 25899.0 |
| 2024-07-25 03:30:00 | ES | Futures | 5737.46 | 5742.18 | 5728.02 | 5732.74 | 20360.0 |
| 2024-07-25 04:00:00 | ES | Futures | 5732.74 | 5734.31 | 5716.22 | 5730.64 | 40226.0 |
| 2024-07-25 04:30:00 | ES | Futures | 5730.64 | 5743.49 | 5729.59 | 5741.65 | 20826.0 |
| 2024-07-25 05:00:00 | ES | Futures | 5741.91 | 5747.94 | 5731.69 | 5735.1 | 16740.0 |
| 2024-07-25 05:30:00 | ES | Futures | 5735.1 | 5739.03 | 5726.97 | 5728.81 | 14855.0 |
| 2024-07-25 06:00:00 | ES | Futures | 5728.81 | 5731.43 | 5719.89 | 5721.47 | 15419.0 |
| 2024-07-25 06:30:00 | ES | Futures | 5721.47 | 5731.69 | 5720.68 | 5729.59 | 14534.0 |
| 2024-07-25 07:00:00 | ES | Futures | 5729.59 | 5737.46 | 5728.02 | 5728.54 | 16628.0 |
| 2024-07-25 07:30:00 | ES | Futures | 5728.54 | 5734.31 | 5723.04 | 5723.83 | 15008.0 |
| 2024-07-25 08:00:00 | ES | Futures | 5723.83 | 5731.17 | 5722.78 | 5724.87 | 18610.0 |
| 2024-07-25 08:30:00 | ES | Futures | 5724.61 | 5741.91 | 5717.53 | 5741.91 | 62602.0 |
| 2024-07-25 09:00:00 | ES | Futures | 5741.91 | 5741.91 | 5730.12 | 5737.98 | 53001.0 |
| 2024-07-25 09:30:00 | ES | Futures | 5737.98 | 5740.6 | 5719.37 | 5722.25 | 239718.0 |
| 2024-07-25 10:00:00 | ES | Futures | 5722.51 | 5731.69 | 5696.82 | 5729.86 | 315673.0 |
| 2024-07-25 10:30:00 | ES | Futures | 5730.12 | 5753.45 | 5723.83 | 5752.93 | 232681.0 |
| 2024-07-25 11:00:00 | ES | Futures | 5752.93 | 5772.33 | 5745.06 | 5756.86 | 192430.0 |
| 2024-07-25 11:30:00 | ES | Futures | 5757.12 | 5766.03 | 5748.47 | 5765.25 | 130666.0 |
| 2024-07-25 12:00:00 | ES | Futures | 5765.25 | 5790.94 | 5758.17 | 5788.06 | 156532.0 |
| 2024-07-25 12:30:00 | ES | Futures | 5788.32 | 5793.56 | 5780.98 | 5788.06 | 110457.0 |
| 2024-07-25 13:00:00 | ES | Futures | 5788.06 | 5802.47 | 5770.49 | 5773.11 | 130641.0 |
| 2024-07-25 13:30:00 | ES | Futures | 5773.37 | 5777.31 | 5766.82 | 5772.33 | 84100.0 |
| 2024-07-25 14:00:00 | ES | Futures | 5772.33 | 5772.85 | 5749.78 | 5754.76 | 106015.0 |
| 2024-07-25 14:30:00 | ES | Futures | 5754.76 | 5760.27 | 5729.07 | 5732.21 | 131037.0 |
| 2024-07-25 15:00:00 | ES | Futures | 5731.95 | 5762.63 | 5731.69 | 5756.6 | 137329.0 |
| 2024-07-25 15:30:00 | ES | Futures | 5756.86 | 5758.43 | 5703.64 | 5706.0 | 263364.0 |
| 2024-07-25 16:00:00 | ES | Futures | 5706.0 | 5709.93 | 5697.61 | 5706.52 | 103005.0 |
| 2024-07-25 16:30:00 | ES | Futures | 5706.52 | 5710.19 | 5701.8 | 5709.67 | 23755.0 |
| 2024-07-25 18:00:00 | ES | Futures | 5710.98 | 5718.06 | 5710.19 | 5712.29 | 7587.0 |
| 2024-07-25 18:30:00 | ES | Futures | 5712.29 | 5716.22 | 5710.46 | 5711.5 | 2860.0 |
| 2024-07-25 19:00:00 | ES | Futures | 5711.5 | 5715.7 | 5710.46 | 5714.65 | 4084.0 |
| 2024-07-25 19:30:00 | ES | Futures | 5714.65 | 5717.01 | 5714.13 | 5716.75 | 1628.0 |
| 2024-07-25 20:00:00 | ES | Futures | 5716.48 | 5724.35 | 5715.7 | 5720.68 | 5283.0 |
| 2024-07-25 20:30:00 | ES | Futures | 5720.68 | 5722.25 | 5718.32 | 5720.16 | 2310.0 |
| 2024-07-25 21:00:00 | ES | Futures | 5720.16 | 5725.14 | 5719.63 | 5723.3 | 3011.0 |
| 2024-07-25 21:30:00 | ES | Futures | 5723.56 | 5729.33 | 5723.04 | 5728.02 | 4220.0 |
| 2024-07-25 22:00:00 | ES | Futures | 5728.02 | 5730.64 | 5725.92 | 5730.38 | 2938.0 |
| 2024-07-25 22:30:00 | ES | Futures | 5730.12 | 5730.38 | 5725.66 | 5726.18 | 2051.0 |
| 2024-07-25 23:00:00 | ES | Futures | 5726.18 | 5729.59 | 5724.09 | 5729.33 | 2869.0 |
| 2024-07-25 23:30:00 | ES | Futures | 5729.33 | 5729.33 | 5726.71 | 5727.5 | 1549.0 |
| 2024-07-25 00:00:00 | NQ | Futures | 20345.4 | 20351.99 | 20329.82 | 20343.81 | 1831.0 |
| 2024-07-25 00:30:00 | NQ | Futures | 20344.34 | 20352.52 | 20323.48 | 20331.14 | 1823.0 |
| 2024-07-25 01:00:00 | NQ | Futures | 20331.14 | 20346.72 | 20323.75 | 20331.14 | 1483.0 |
| 2024-07-25 01:30:00 | NQ | Futures | 20330.88 | 20332.2 | 20308.17 | 20311.08 | 1996.0 |
> showing 50 of 4,061 rows — these rows as CSV