PREVIEW / futures_30min / 2024-07-22
file: by_date/futures_30min/2024/2024-07-22.parquet size: 108 KB rows: 3,914
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-22 00:00:00 | ES | Futures | 5833.93 | 5834.72 | 5827.9 | 5833.93 | 2876.0 |
| 2024-07-22 00:30:00 | ES | Futures | 5833.67 | 5838.13 | 5832.89 | 5837.34 | 2343.0 |
| 2024-07-22 01:00:00 | ES | Futures | 5837.6 | 5838.65 | 5833.93 | 5835.25 | 2121.0 |
| 2024-07-22 01:30:00 | ES | Futures | 5835.25 | 5838.65 | 5834.72 | 5835.51 | 2410.0 |
| 2024-07-22 02:00:00 | ES | Futures | 5835.77 | 5841.8 | 5830.79 | 5838.92 | 6668.0 |
| 2024-07-22 02:30:00 | ES | Futures | 5839.18 | 5843.11 | 5837.34 | 5839.7 | 3723.0 |
| 2024-07-22 03:00:00 | ES | Futures | 5839.96 | 5840.75 | 5832.1 | 5836.56 | 9841.0 |
| 2024-07-22 03:30:00 | ES | Futures | 5836.56 | 5843.63 | 5834.46 | 5842.06 | 6028.0 |
| 2024-07-22 04:00:00 | ES | Futures | 5841.8 | 5844.95 | 5839.44 | 5844.16 | 7514.0 |
| 2024-07-22 04:30:00 | ES | Futures | 5844.16 | 5847.57 | 5842.32 | 5843.11 | 7863.0 |
| 2024-07-22 05:00:00 | ES | Futures | 5842.85 | 5846.52 | 5841.54 | 5846.26 | 6081.0 |
| 2024-07-22 05:30:00 | ES | Futures | 5846.26 | 5849.93 | 5844.95 | 5848.62 | 7108.0 |
| 2024-07-22 06:00:00 | ES | Futures | 5848.35 | 5852.29 | 5847.04 | 5851.5 | 9129.0 |
| 2024-07-22 06:30:00 | ES | Futures | 5851.5 | 5855.96 | 5849.66 | 5855.69 | 7557.0 |
| 2024-07-22 07:00:00 | ES | Futures | 5855.96 | 5856.22 | 5851.5 | 5852.29 | 8114.0 |
| 2024-07-22 07:30:00 | ES | Futures | 5852.29 | 5857.27 | 5852.29 | 5857.0 | 7138.0 |
| 2024-07-22 08:00:00 | ES | Futures | 5857.27 | 5863.82 | 5856.48 | 5862.51 | 16721.0 |
| 2024-07-22 08:30:00 | ES | Futures | 5862.77 | 5864.35 | 5857.0 | 5858.05 | 15507.0 |
| 2024-07-22 09:00:00 | ES | Futures | 5857.79 | 5866.97 | 5857.53 | 5865.66 | 31077.0 |
| 2024-07-22 09:30:00 | ES | Futures | 5865.66 | 5880.6 | 5857.79 | 5861.99 | 190489.0 |
| 2024-07-22 10:00:00 | ES | Futures | 5861.72 | 5867.49 | 5847.83 | 5867.49 | 165935.0 |
| 2024-07-22 10:30:00 | ES | Futures | 5867.49 | 5880.6 | 5862.77 | 5873.52 | 131510.0 |
| 2024-07-22 11:00:00 | ES | Futures | 5873.52 | 5881.12 | 5851.24 | 5851.76 | 160691.0 |
| 2024-07-22 11:30:00 | ES | Futures | 5852.02 | 5853.6 | 5843.9 | 5851.76 | 115094.0 |
| 2024-07-22 12:00:00 | ES | Futures | 5851.76 | 5858.58 | 5846.52 | 5855.17 | 65597.0 |
| 2024-07-22 12:30:00 | ES | Futures | 5854.91 | 5873.26 | 5852.02 | 5870.64 | 70810.0 |
| 2024-07-22 13:00:00 | ES | Futures | 5870.9 | 5880.08 | 5870.9 | 5877.19 | 64679.0 |
| 2024-07-22 13:30:00 | ES | Futures | 5877.19 | 5885.06 | 5876.93 | 5881.39 | 55748.0 |
| 2024-07-22 14:00:00 | ES | Futures | 5881.65 | 5887.42 | 5877.45 | 5882.17 | 52253.0 |
| 2024-07-22 14:30:00 | ES | Futures | 5881.91 | 5889.25 | 5881.91 | 5884.53 | 47952.0 |
| 2024-07-22 15:00:00 | ES | Futures | 5884.79 | 5886.89 | 5877.45 | 5881.39 | 74186.0 |
| 2024-07-22 15:30:00 | ES | Futures | 5881.65 | 5887.94 | 5879.29 | 5882.43 | 138640.0 |
| 2024-07-22 16:00:00 | ES | Futures | 5882.7 | 5886.1 | 5879.29 | 5879.55 | 50089.0 |
| 2024-07-22 16:30:00 | ES | Futures | 5879.29 | 5881.12 | 5878.5 | 5881.12 | 7319.0 |
| 2024-07-22 18:00:00 | ES | Futures | 5880.6 | 5885.32 | 5879.29 | 5885.32 | 3499.0 |
| 2024-07-22 18:30:00 | ES | Futures | 5885.06 | 5885.58 | 5882.7 | 5883.48 | 1524.0 |
| 2024-07-22 19:00:00 | ES | Futures | 5883.48 | 5883.48 | 5880.6 | 5881.65 | 3697.0 |
| 2024-07-22 19:30:00 | ES | Futures | 5881.91 | 5882.17 | 5877.45 | 5878.24 | 2363.0 |
| 2024-07-22 20:00:00 | ES | Futures | 5878.24 | 5879.03 | 5875.88 | 5876.67 | 3328.0 |
| 2024-07-22 20:30:00 | ES | Futures | 5876.93 | 5878.24 | 5872.47 | 5874.31 | 3010.0 |
| 2024-07-22 21:00:00 | ES | Futures | 5874.57 | 5879.81 | 5873.52 | 5879.03 | 3389.0 |
| 2024-07-22 21:30:00 | ES | Futures | 5879.29 | 5879.29 | 5874.05 | 5876.93 | 2372.0 |
| 2024-07-22 22:00:00 | ES | Futures | 5876.93 | 5877.45 | 5873.0 | 5875.88 | 2376.0 |
| 2024-07-22 22:30:00 | ES | Futures | 5875.88 | 5877.19 | 5875.36 | 5875.88 | 1061.0 |
| 2024-07-22 23:00:00 | ES | Futures | 5875.88 | 5876.4 | 5868.54 | 5871.69 | 4495.0 |
| 2024-07-22 23:30:00 | ES | Futures | 5871.69 | 5872.47 | 5869.85 | 5872.21 | 1627.0 |
| 2024-07-22 00:00:00 | NQ | Futures | 20884.18 | 20886.82 | 20844.85 | 20882.86 | 2398.0 |
| 2024-07-22 00:30:00 | NQ | Futures | 20882.86 | 20911.9 | 20875.74 | 20908.73 | 1992.0 |
| 2024-07-22 01:00:00 | NQ | Futures | 20907.68 | 20916.13 | 20884.18 | 20893.69 | 1920.0 |
| 2024-07-22 01:30:00 | NQ | Futures | 20893.42 | 20908.73 | 20892.1 | 20895.01 | 1437.0 |
> showing 50 of 3,914 rows — these rows as CSV