PREVIEW / futures_30min / 2024-07-30
file: by_date/futures_30min/2024/2024-07-30.parquet size: 110 KB rows: 3,984
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-30 00:00:00 | ES | Futures | 5756.86 | 5763.94 | 5756.86 | 5763.67 | 2984.0 |
| 2024-07-30 00:30:00 | ES | Futures | 5763.67 | 5767.08 | 5763.41 | 5766.56 | 2470.0 |
| 2024-07-30 01:00:00 | ES | Futures | 5766.82 | 5768.66 | 5765.77 | 5767.87 | 2665.0 |
| 2024-07-30 01:30:00 | ES | Futures | 5767.61 | 5771.8 | 5764.72 | 5771.02 | 3288.0 |
| 2024-07-30 02:00:00 | ES | Futures | 5770.75 | 5772.06 | 5766.3 | 5771.8 | 4079.0 |
| 2024-07-30 02:30:00 | ES | Futures | 5771.8 | 5772.06 | 5765.77 | 5772.06 | 3785.0 |
| 2024-07-30 03:00:00 | ES | Futures | 5772.06 | 5777.83 | 5772.06 | 5777.04 | 7619.0 |
| 2024-07-30 03:30:00 | ES | Futures | 5776.78 | 5784.12 | 5775.73 | 5779.93 | 6596.0 |
| 2024-07-30 04:00:00 | ES | Futures | 5780.19 | 5783.07 | 5772.33 | 5773.9 | 7638.0 |
| 2024-07-30 04:30:00 | ES | Futures | 5773.9 | 5781.76 | 5773.64 | 5779.14 | 4634.0 |
| 2024-07-30 05:00:00 | ES | Futures | 5779.4 | 5782.29 | 5777.57 | 5777.57 | 3074.0 |
| 2024-07-30 05:30:00 | ES | Futures | 5777.83 | 5779.4 | 5772.85 | 5777.83 | 5174.0 |
| 2024-07-30 06:00:00 | ES | Futures | 5777.83 | 5781.76 | 5776.26 | 5781.24 | 3540.0 |
| 2024-07-30 06:30:00 | ES | Futures | 5781.5 | 5783.6 | 5780.19 | 5781.24 | 4375.0 |
| 2024-07-30 07:00:00 | ES | Futures | 5781.24 | 5783.34 | 5779.67 | 5781.76 | 4609.0 |
| 2024-07-30 07:30:00 | ES | Futures | 5781.5 | 5784.12 | 5780.19 | 5780.45 | 4420.0 |
| 2024-07-30 08:00:00 | ES | Futures | 5780.45 | 5783.86 | 5777.83 | 5779.67 | 7155.0 |
| 2024-07-30 08:30:00 | ES | Futures | 5779.93 | 5782.81 | 5778.88 | 5780.45 | 10735.0 |
| 2024-07-30 09:00:00 | ES | Futures | 5780.72 | 5785.7 | 5780.19 | 5784.91 | 24246.0 |
| 2024-07-30 09:30:00 | ES | Futures | 5784.65 | 5796.44 | 5779.67 | 5785.43 | 156461.0 |
| 2024-07-30 10:00:00 | ES | Futures | 5785.43 | 5787.53 | 5769.44 | 5771.28 | 154440.0 |
| 2024-07-30 10:30:00 | ES | Futures | 5771.28 | 5772.85 | 5757.64 | 5759.22 | 133523.0 |
| 2024-07-30 11:00:00 | ES | Futures | 5759.48 | 5761.05 | 5731.43 | 5741.13 | 188170.0 |
| 2024-07-30 11:30:00 | ES | Futures | 5740.87 | 5743.75 | 5723.04 | 5723.83 | 133723.0 |
| 2024-07-30 12:00:00 | ES | Futures | 5724.09 | 5731.95 | 5719.37 | 5726.97 | 100902.0 |
| 2024-07-30 12:30:00 | ES | Futures | 5727.23 | 5730.9 | 5705.74 | 5706.26 | 119395.0 |
| 2024-07-30 13:00:00 | ES | Futures | 5706.26 | 5725.4 | 5702.59 | 5723.83 | 132508.0 |
| 2024-07-30 13:30:00 | ES | Futures | 5723.83 | 5734.31 | 5720.42 | 5732.21 | 93719.0 |
| 2024-07-30 14:00:00 | ES | Futures | 5732.21 | 5746.63 | 5729.33 | 5738.77 | 94110.0 |
| 2024-07-30 14:30:00 | ES | Futures | 5738.51 | 5741.91 | 5728.81 | 5733.79 | 92803.0 |
| 2024-07-30 15:00:00 | ES | Futures | 5733.79 | 5739.29 | 5726.45 | 5736.67 | 84477.0 |
| 2024-07-30 15:30:00 | ES | Futures | 5736.67 | 5758.17 | 5731.95 | 5739.03 | 214475.0 |
| 2024-07-30 16:00:00 | ES | Futures | 5739.03 | 5744.01 | 5697.35 | 5714.65 | 109203.0 |
| 2024-07-30 16:30:00 | ES | Futures | 5714.65 | 5724.61 | 5712.03 | 5717.27 | 21036.0 |
| 2024-07-30 18:00:00 | ES | Futures | 5720.16 | 5741.13 | 5716.75 | 5732.74 | 18261.0 |
| 2024-07-30 18:30:00 | ES | Futures | 5732.74 | 5737.72 | 5732.48 | 5733.53 | 3779.0 |
| 2024-07-30 19:00:00 | ES | Futures | 5733.53 | 5743.49 | 5732.48 | 5742.7 | 3828.0 |
| 2024-07-30 19:30:00 | ES | Futures | 5742.7 | 5748.73 | 5742.18 | 5747.16 | 3485.0 |
| 2024-07-30 20:00:00 | ES | Futures | 5746.9 | 5748.99 | 5741.91 | 5745.59 | 4762.0 |
| 2024-07-30 20:30:00 | ES | Futures | 5745.32 | 5753.19 | 5744.8 | 5752.14 | 4336.0 |
| 2024-07-30 21:00:00 | ES | Futures | 5752.4 | 5754.5 | 5748.73 | 5750.83 | 3350.0 |
| 2024-07-30 21:30:00 | ES | Futures | 5750.83 | 5752.93 | 5747.68 | 5751.88 | 3380.0 |
| 2024-07-30 22:00:00 | ES | Futures | 5751.88 | 5760.53 | 5751.09 | 5759.48 | 5952.0 |
| 2024-07-30 22:30:00 | ES | Futures | 5759.74 | 5760.53 | 5757.91 | 5759.74 | 2695.0 |
| 2024-07-30 23:00:00 | ES | Futures | 5759.48 | 5760.53 | 5757.64 | 5758.43 | 2861.0 |
| 2024-07-30 23:30:00 | ES | Futures | 5758.69 | 5765.51 | 5757.64 | 5764.72 | 4786.0 |
| 2024-07-30 00:00:00 | NQ | Futures | 20201.0 | 20235.31 | 20200.47 | 20235.05 | 2293.0 |
| 2024-07-30 00:30:00 | NQ | Futures | 20233.99 | 20255.91 | 20233.99 | 20253.0 | 2240.0 |
| 2024-07-30 01:00:00 | NQ | Futures | 20254.06 | 20267.52 | 20248.78 | 20256.43 | 1770.0 |
| 2024-07-30 01:30:00 | NQ | Futures | 20256.43 | 20282.3 | 20240.86 | 20277.02 | 2425.0 |
> showing 50 of 3,984 rows — these rows as CSV