PREVIEW / futures_30min / 2024-02-25
file: by_date/futures_30min/2024/2024-02-25.parquet size: 28 KB rows: 804
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-02-25 18:00:00 | ES | Futures | 5473.88 | 5479.79 | 5471.46 | 5478.71 | 5460.0 |
| 2024-02-25 18:30:00 | ES | Futures | 5478.71 | 5480.59 | 5478.44 | 5478.44 | 3270.0 |
| 2024-02-25 19:00:00 | ES | Futures | 5478.17 | 5478.71 | 5471.73 | 5473.07 | 5538.0 |
| 2024-02-25 19:30:00 | ES | Futures | 5473.07 | 5474.15 | 5466.89 | 5467.7 | 6661.0 |
| 2024-02-25 20:00:00 | ES | Futures | 5467.97 | 5470.92 | 5465.55 | 5470.38 | 5011.0 |
| 2024-02-25 20:30:00 | ES | Futures | 5470.65 | 5473.07 | 5467.97 | 5468.77 | 4814.0 |
| 2024-02-25 21:00:00 | ES | Futures | 5468.77 | 5471.46 | 5467.7 | 5470.65 | 2580.0 |
| 2024-02-25 21:30:00 | ES | Futures | 5470.65 | 5473.34 | 5468.5 | 5470.38 | 3409.0 |
| 2024-02-25 22:00:00 | ES | Futures | 5470.12 | 5470.65 | 5468.5 | 5469.31 | 1952.0 |
| 2024-02-25 22:30:00 | ES | Futures | 5469.31 | 5470.92 | 5469.04 | 5469.58 | 1466.0 |
| 2024-02-25 23:00:00 | ES | Futures | 5469.58 | 5470.38 | 5467.97 | 5468.77 | 1626.0 |
| 2024-02-25 23:30:00 | ES | Futures | 5468.5 | 5470.38 | 5468.5 | 5470.12 | 957.0 |
| 2024-02-25 18:00:00 | NQ | Futures | 19485.04 | 19508.63 | 19464.43 | 19502.94 | 3697.0 |
| 2024-02-25 18:30:00 | NQ | Futures | 19503.21 | 19514.06 | 19502.94 | 19507.82 | 1754.0 |
| 2024-02-25 19:00:00 | NQ | Futures | 19507.55 | 19509.99 | 19476.9 | 19482.6 | 3469.0 |
| 2024-02-25 19:30:00 | NQ | Futures | 19483.14 | 19486.94 | 19442.19 | 19450.32 | 4512.0 |
| 2024-02-25 20:00:00 | NQ | Futures | 19450.32 | 19470.39 | 19442.73 | 19467.95 | 3523.0 |
| 2024-02-25 20:30:00 | NQ | Futures | 19467.95 | 19480.7 | 19458.46 | 19461.71 | 2870.0 |
| 2024-02-25 21:00:00 | NQ | Futures | 19461.17 | 19478.8 | 19456.56 | 19476.09 | 1624.0 |
| 2024-02-25 21:30:00 | NQ | Futures | 19475.55 | 19488.56 | 19468.5 | 19475.55 | 2002.0 |
| 2024-02-25 22:00:00 | NQ | Futures | 19475.28 | 19475.82 | 19465.78 | 19470.39 | 1264.0 |
| 2024-02-25 22:30:00 | NQ | Futures | 19469.58 | 19477.99 | 19469.31 | 19470.66 | 801.0 |
| 2024-02-25 23:00:00 | NQ | Futures | 19470.94 | 19476.63 | 19460.09 | 19463.88 | 1350.0 |
| 2024-02-25 23:30:00 | NQ | Futures | 19463.61 | 19474.19 | 19461.44 | 19471.75 | 782.0 |
| 2024-02-25 18:00:00 | YM | Futures | 42089.9 | 42089.9 | 42050.1 | 42073.8 | 859.0 |
| 2024-02-25 18:30:00 | YM | Futures | 42073.8 | 42087.7 | 42072.7 | 42072.7 | 337.0 |
| 2024-02-25 19:00:00 | YM | Futures | 42071.6 | 42074.8 | 42036.2 | 42044.8 | 769.0 |
| 2024-02-25 19:30:00 | YM | Futures | 42045.8 | 42053.4 | 42011.5 | 42021.1 | 805.0 |
| 2024-02-25 20:00:00 | YM | Futures | 42020.1 | 42037.3 | 42001.8 | 42037.3 | 630.0 |
| 2024-02-25 20:30:00 | YM | Futures | 42037.3 | 42050.1 | 42019.0 | 42021.1 | 427.0 |
| 2024-02-25 21:00:00 | YM | Futures | 42021.1 | 42033.0 | 42014.7 | 42029.7 | 266.0 |
| 2024-02-25 21:30:00 | YM | Futures | 42028.7 | 42043.7 | 42014.7 | 42027.6 | 386.0 |
| 2024-02-25 22:00:00 | YM | Futures | 42027.6 | 42033.0 | 42020.1 | 42025.4 | 259.0 |
| 2024-02-25 22:30:00 | YM | Futures | 42026.5 | 42038.3 | 42026.5 | 42029.7 | 212.0 |
| 2024-02-25 23:00:00 | YM | Futures | 42030.8 | 42035.1 | 42022.2 | 42026.5 | 269.0 |
| 2024-02-25 23:30:00 | YM | Futures | 42025.4 | 42039.4 | 42025.4 | 42037.3 | 178.0 |
| 2024-02-25 18:00:00 | CL | Futures | 63.94 | 64.18 | 63.93 | 63.99 | 1756.0 |
| 2024-02-25 18:30:00 | CL | Futures | 63.99 | 64.06 | 63.96 | 63.98 | 846.0 |
| 2024-02-25 19:00:00 | CL | Futures | 63.97 | 63.98 | 63.81 | 63.89 | 1675.0 |
| 2024-02-25 19:30:00 | CL | Futures | 63.9 | 63.9 | 63.78 | 63.8 | 922.0 |
| 2024-02-25 20:00:00 | CL | Futures | 63.8 | 63.8 | 63.68 | 63.74 | 1951.0 |
| 2024-02-25 20:30:00 | CL | Futures | 63.73 | 63.85 | 63.68 | 63.69 | 1187.0 |
| 2024-02-25 21:00:00 | CL | Futures | 63.69 | 63.78 | 63.68 | 63.73 | 724.0 |
| 2024-02-25 21:30:00 | CL | Futures | 63.73 | 63.77 | 63.7 | 63.74 | 411.0 |
| 2024-02-25 22:00:00 | CL | Futures | 63.73 | 63.76 | 63.66 | 63.68 | 810.0 |
| 2024-02-25 22:30:00 | CL | Futures | 63.69 | 63.69 | 63.65 | 63.66 | 427.0 |
| 2024-02-25 23:00:00 | CL | Futures | 63.66 | 63.73 | 63.66 | 63.72 | 315.0 |
| 2024-02-25 23:30:00 | CL | Futures | 63.72 | 63.77 | 63.69 | 63.74 | 372.0 |
| 2024-02-25 18:00:00 | GC | Futures | 2240.6 | 2241.3 | 2238.3 | 2240.7 | 2043.0 |
| 2024-02-25 18:30:00 | GC | Futures | 2240.6 | 2240.6 | 2239.6 | 2239.8 | 857.0 |
> showing 50 of 804 rows — these rows as CSV