PREVIEW / futures_30min / 2024-07-21
file: by_date/futures_30min/2024/2024-07-21.parquet size: 30 KB rows: 820
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-21 18:00:00 | ES | Futures | 5835.25 | 5836.29 | 5827.64 | 5834.98 | 10510.0 |
| 2024-07-21 18:30:00 | ES | Futures | 5835.25 | 5836.03 | 5833.15 | 5835.25 | 3708.0 |
| 2024-07-21 19:00:00 | ES | Futures | 5835.25 | 5845.21 | 5835.25 | 5843.9 | 6867.0 |
| 2024-07-21 19:30:00 | ES | Futures | 5843.9 | 5844.16 | 5841.54 | 5843.11 | 3763.0 |
| 2024-07-21 20:00:00 | ES | Futures | 5843.37 | 5844.16 | 5835.51 | 5840.75 | 6460.0 |
| 2024-07-21 20:30:00 | ES | Futures | 5841.01 | 5842.85 | 5837.34 | 5842.32 | 3553.0 |
| 2024-07-21 21:00:00 | ES | Futures | 5842.32 | 5842.85 | 5831.84 | 5835.25 | 5465.0 |
| 2024-07-21 21:30:00 | ES | Futures | 5834.98 | 5836.03 | 5826.07 | 5827.12 | 5844.0 |
| 2024-07-21 22:00:00 | ES | Futures | 5827.38 | 5828.69 | 5823.71 | 5826.07 | 4866.0 |
| 2024-07-21 22:30:00 | ES | Futures | 5826.33 | 5831.05 | 5825.81 | 5829.22 | 4096.0 |
| 2024-07-21 23:00:00 | ES | Futures | 5829.48 | 5838.65 | 5829.22 | 5836.56 | 5180.0 |
| 2024-07-21 23:30:00 | ES | Futures | 5836.56 | 5836.82 | 5832.36 | 5833.93 | 2381.0 |
| 2024-07-21 18:00:00 | NQ | Futures | 20853.56 | 20891.58 | 20830.6 | 20886.03 | 7582.0 |
| 2024-07-21 18:30:00 | NQ | Futures | 20886.82 | 20901.87 | 20880.75 | 20897.65 | 2913.0 |
| 2024-07-21 19:00:00 | NQ | Futures | 20897.65 | 20951.76 | 20896.33 | 20943.84 | 7046.0 |
| 2024-07-21 19:30:00 | NQ | Futures | 20943.05 | 20946.48 | 20916.13 | 20925.36 | 3003.0 |
| 2024-07-21 20:00:00 | NQ | Futures | 20925.1 | 20932.76 | 20872.04 | 20905.04 | 4307.0 |
| 2024-07-21 20:30:00 | NQ | Futures | 20905.3 | 20919.82 | 20888.94 | 20919.03 | 2867.0 |
| 2024-07-21 21:00:00 | NQ | Futures | 20918.24 | 20921.41 | 20861.75 | 20883.39 | 3550.0 |
| 2024-07-21 21:30:00 | NQ | Futures | 20882.34 | 20896.06 | 20837.46 | 20850.13 | 5033.0 |
| 2024-07-21 22:00:00 | NQ | Futures | 20850.39 | 20858.05 | 20821.62 | 20846.7 | 3982.0 |
| 2024-07-21 22:30:00 | NQ | Futures | 20847.75 | 20873.1 | 20839.04 | 20858.05 | 2731.0 |
| 2024-07-21 23:00:00 | NQ | Futures | 20858.31 | 20906.89 | 20855.94 | 20891.58 | 3750.0 |
| 2024-07-21 23:30:00 | NQ | Futures | 20891.31 | 20893.16 | 20870.46 | 20883.39 | 1883.0 |
| 2024-07-21 18:00:00 | YM | Futures | 42661.7 | 42675.3 | 42621.7 | 42665.9 | 1030.0 |
| 2024-07-21 18:30:00 | YM | Futures | 42668.0 | 42672.2 | 42657.4 | 42668.0 | 269.0 |
| 2024-07-21 19:00:00 | YM | Futures | 42668.0 | 42715.2 | 42668.0 | 42702.6 | 724.0 |
| 2024-07-21 19:30:00 | YM | Futures | 42701.6 | 42719.4 | 42693.2 | 42718.4 | 337.0 |
| 2024-07-21 20:00:00 | YM | Futures | 42718.4 | 42722.6 | 42680.6 | 42698.4 | 574.0 |
| 2024-07-21 20:30:00 | YM | Futures | 42698.4 | 42698.4 | 42675.3 | 42695.3 | 445.0 |
| 2024-07-21 21:00:00 | YM | Futures | 42696.3 | 42698.4 | 42646.9 | 42662.7 | 550.0 |
| 2024-07-21 21:30:00 | YM | Futures | 42661.7 | 42661.7 | 42604.9 | 42609.1 | 654.0 |
| 2024-07-21 22:00:00 | YM | Futures | 42609.1 | 42615.4 | 42594.4 | 42602.8 | 562.0 |
| 2024-07-21 22:30:00 | YM | Futures | 42601.8 | 42641.7 | 42601.8 | 42634.3 | 467.0 |
| 2024-07-21 23:00:00 | YM | Futures | 42634.3 | 42674.3 | 42634.3 | 42664.8 | 479.0 |
| 2024-07-21 23:30:00 | YM | Futures | 42664.8 | 42664.8 | 42634.3 | 42639.6 | 287.0 |
| 2024-07-21 18:00:00 | CL | Futures | 68.54 | 68.6 | 68.37 | 68.52 | 2335.0 |
| 2024-07-21 18:30:00 | CL | Futures | 68.51 | 68.61 | 68.45 | 68.61 | 1334.0 |
| 2024-07-21 19:00:00 | CL | Futures | 68.6 | 68.64 | 68.51 | 68.62 | 985.0 |
| 2024-07-21 19:30:00 | CL | Futures | 68.62 | 68.65 | 68.6 | 68.61 | 284.0 |
| 2024-07-21 20:00:00 | CL | Futures | 68.61 | 68.7 | 68.57 | 68.68 | 1136.0 |
| 2024-07-21 20:30:00 | CL | Futures | 68.68 | 68.7 | 68.59 | 68.64 | 740.0 |
| 2024-07-21 21:00:00 | CL | Futures | 68.64 | 68.69 | 68.45 | 68.53 | 2079.0 |
| 2024-07-21 21:30:00 | CL | Futures | 68.54 | 68.57 | 68.42 | 68.43 | 1345.0 |
| 2024-07-21 22:00:00 | CL | Futures | 68.41 | 68.46 | 68.38 | 68.44 | 1072.0 |
| 2024-07-21 22:30:00 | CL | Futures | 68.45 | 68.62 | 68.45 | 68.61 | 1338.0 |
| 2024-07-21 23:00:00 | CL | Futures | 68.61 | 68.69 | 68.58 | 68.67 | 1353.0 |
| 2024-07-21 23:30:00 | CL | Futures | 68.66 | 68.7 | 68.64 | 68.67 | 517.0 |
| 2024-07-21 18:00:00 | GC | Futures | 2581.2 | 2591.4 | 2579.9 | 2590.0 | 3211.0 |
| 2024-07-21 18:30:00 | GC | Futures | 2589.9 | 2591.4 | 2588.4 | 2591.0 | 1419.0 |
> showing 50 of 820 rows — these rows as CSV