PREVIEW / futures_30min / 2024-06-28
file: by_date/futures_30min/2024/2024-06-28.parquet size: 94 KB rows: 3,166
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-06-28 00:00:00 | ES | Futures | 5831.31 | 5831.84 | 5828.95 | 5829.48 | 2282.0 |
| 2024-06-28 00:30:00 | ES | Futures | 5829.22 | 5829.74 | 5827.64 | 5828.69 | 2290.0 |
| 2024-06-28 01:00:00 | ES | Futures | 5828.69 | 5829.22 | 5827.38 | 5827.38 | 2197.0 |
| 2024-06-28 01:30:00 | ES | Futures | 5827.64 | 5828.17 | 5826.07 | 5827.64 | 2402.0 |
| 2024-06-28 02:00:00 | ES | Futures | 5827.38 | 5833.41 | 5827.38 | 5832.36 | 5423.0 |
| 2024-06-28 02:30:00 | ES | Futures | 5832.36 | 5833.15 | 5830.26 | 5831.31 | 3538.0 |
| 2024-06-28 03:00:00 | ES | Futures | 5831.57 | 5834.46 | 5829.74 | 5831.84 | 7015.0 |
| 2024-06-28 03:30:00 | ES | Futures | 5832.1 | 5832.36 | 5829.22 | 5830.0 | 4140.0 |
| 2024-06-28 04:00:00 | ES | Futures | 5830.0 | 5832.1 | 5827.12 | 5831.57 | 6294.0 |
| 2024-06-28 04:30:00 | ES | Futures | 5831.84 | 5834.2 | 5831.05 | 5833.41 | 5483.0 |
| 2024-06-28 05:00:00 | ES | Futures | 5833.67 | 5837.08 | 5833.67 | 5836.03 | 7067.0 |
| 2024-06-28 05:30:00 | ES | Futures | 5836.03 | 5838.13 | 5834.98 | 5836.29 | 5890.0 |
| 2024-06-28 06:00:00 | ES | Futures | 5836.29 | 5836.82 | 5833.93 | 5835.77 | 4893.0 |
| 2024-06-28 06:30:00 | ES | Futures | 5835.77 | 5837.6 | 5834.98 | 5837.34 | 3733.0 |
| 2024-06-28 07:00:00 | ES | Futures | 5837.34 | 5837.34 | 5833.93 | 5834.98 | 6139.0 |
| 2024-06-28 07:30:00 | ES | Futures | 5835.25 | 5836.29 | 5834.46 | 5835.51 | 7444.0 |
| 2024-06-28 08:00:00 | ES | Futures | 5835.51 | 5839.18 | 5833.93 | 5837.6 | 15288.0 |
| 2024-06-28 08:30:00 | ES | Futures | 5838.13 | 5844.16 | 5825.28 | 5826.86 | 54213.0 |
| 2024-06-28 09:00:00 | ES | Futures | 5827.12 | 5829.48 | 5820.04 | 5823.45 | 38898.0 |
| 2024-06-28 09:30:00 | ES | Futures | 5822.92 | 5834.46 | 5817.68 | 5832.62 | 120139.0 |
| 2024-06-28 10:00:00 | ES | Futures | 5832.62 | 5856.74 | 5832.62 | 5849.14 | 162187.0 |
| 2024-06-28 10:30:00 | ES | Futures | 5848.88 | 5854.65 | 5833.93 | 5839.18 | 119117.0 |
| 2024-06-28 11:00:00 | ES | Futures | 5838.92 | 5839.18 | 5823.71 | 5829.22 | 130947.0 |
| 2024-06-28 11:30:00 | ES | Futures | 5828.95 | 5835.25 | 5826.86 | 5828.69 | 63021.0 |
| 2024-06-28 12:00:00 | ES | Futures | 5828.43 | 5830.0 | 5812.7 | 5820.56 | 85321.0 |
| 2024-06-28 12:30:00 | ES | Futures | 5820.56 | 5822.4 | 5804.83 | 5813.75 | 84882.0 |
| 2024-06-28 13:00:00 | ES | Futures | 5813.75 | 5821.09 | 5810.34 | 5813.49 | 54823.0 |
| 2024-06-28 13:30:00 | ES | Futures | 5813.75 | 5815.58 | 5809.03 | 5811.13 | 47328.0 |
| 2024-06-28 14:00:00 | ES | Futures | 5810.86 | 5817.16 | 5802.47 | 5804.31 | 71082.0 |
| 2024-06-28 14:30:00 | ES | Futures | 5804.57 | 5807.19 | 5799.85 | 5801.69 | 55235.0 |
| 2024-06-28 15:00:00 | ES | Futures | 5801.69 | 5802.21 | 5796.44 | 5798.54 | 66631.0 |
| 2024-06-28 15:30:00 | ES | Futures | 5798.54 | 5805.88 | 5778.88 | 5791.99 | 337708.0 |
| 2024-06-28 16:00:00 | ES | Futures | 5792.25 | 5803.52 | 5791.73 | 5803.0 | 89239.0 |
| 2024-06-28 16:30:00 | ES | Futures | 5803.26 | 5803.52 | 5799.59 | 5801.43 | 9961.0 |
| 2024-06-28 00:00:00 | NQ | Futures | 21256.93 | 21257.72 | 21237.13 | 21240.03 | 1768.0 |
| 2024-06-28 00:30:00 | NQ | Futures | 21241.09 | 21243.73 | 21228.68 | 21233.17 | 1616.0 |
| 2024-06-28 01:00:00 | NQ | Futures | 21232.9 | 21237.13 | 21228.42 | 21230.0 | 1238.0 |
| 2024-06-28 01:30:00 | NQ | Futures | 21230.53 | 21234.49 | 21223.4 | 21233.96 | 1207.0 |
| 2024-06-28 02:00:00 | NQ | Futures | 21233.7 | 21257.72 | 21233.43 | 21254.29 | 2775.0 |
| 2024-06-28 02:30:00 | NQ | Futures | 21254.29 | 21257.72 | 21236.86 | 21239.77 | 2425.0 |
| 2024-06-28 03:00:00 | NQ | Futures | 21238.45 | 21248.74 | 21228.68 | 21243.73 | 3342.0 |
| 2024-06-28 03:30:00 | NQ | Futures | 21243.2 | 21246.63 | 21229.21 | 21229.47 | 2105.0 |
| 2024-06-28 04:00:00 | NQ | Futures | 21230.26 | 21240.56 | 21215.48 | 21237.92 | 3890.0 |
| 2024-06-28 04:30:00 | NQ | Futures | 21238.45 | 21242.67 | 21230.26 | 21240.03 | 2300.0 |
| 2024-06-28 05:00:00 | NQ | Futures | 21240.3 | 21252.18 | 21238.98 | 21244.52 | 2674.0 |
| 2024-06-28 05:30:00 | NQ | Futures | 21243.99 | 21259.04 | 21240.03 | 21252.44 | 2690.0 |
| 2024-06-28 06:00:00 | NQ | Futures | 21251.38 | 21255.87 | 21240.82 | 21250.33 | 2497.0 |
| 2024-06-28 06:30:00 | NQ | Futures | 21250.33 | 21255.61 | 21244.26 | 21251.91 | 1428.0 |
| 2024-06-28 07:00:00 | NQ | Futures | 21251.91 | 21254.02 | 21243.99 | 21247.16 | 2345.0 |
| 2024-06-28 07:30:00 | NQ | Futures | 21247.16 | 21255.34 | 21245.58 | 21252.7 | 2430.0 |
> showing 50 of 3,166 rows — these rows as CSV