PREVIEW / futures_30min / 2024-07-05
file: by_date/futures_30min/2024/2024-07-05.parquet size: 88 KB rows: 3,021
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-05 00:00:00 | ES | Futures | 5865.13 | 5865.92 | 5864.35 | 5865.39 | 1020.0 |
| 2024-07-05 00:30:00 | ES | Futures | 5865.39 | 5867.23 | 5864.87 | 5865.66 | 1512.0 |
| 2024-07-05 01:00:00 | ES | Futures | 5865.92 | 5866.97 | 5864.87 | 5866.18 | 1635.0 |
| 2024-07-05 01:30:00 | ES | Futures | 5866.44 | 5868.54 | 5865.92 | 5868.02 | 2804.0 |
| 2024-07-05 02:00:00 | ES | Futures | 5867.75 | 5870.38 | 5867.49 | 5868.8 | 4136.0 |
| 2024-07-05 02:30:00 | ES | Futures | 5869.06 | 5871.16 | 5868.8 | 5869.06 | 3447.0 |
| 2024-07-05 03:00:00 | ES | Futures | 5869.06 | 5870.9 | 5865.66 | 5866.97 | 8267.0 |
| 2024-07-05 03:30:00 | ES | Futures | 5866.97 | 5868.28 | 5865.13 | 5867.49 | 7907.0 |
| 2024-07-05 04:00:00 | ES | Futures | 5867.23 | 5868.54 | 5865.13 | 5865.66 | 7065.0 |
| 2024-07-05 04:30:00 | ES | Futures | 5865.92 | 5866.44 | 5862.51 | 5863.3 | 4880.0 |
| 2024-07-05 05:00:00 | ES | Futures | 5863.56 | 5865.39 | 5863.3 | 5864.61 | 3128.0 |
| 2024-07-05 05:30:00 | ES | Futures | 5864.35 | 5866.18 | 5862.51 | 5863.82 | 4870.0 |
| 2024-07-05 06:00:00 | ES | Futures | 5864.08 | 5865.39 | 5863.03 | 5863.82 | 4668.0 |
| 2024-07-05 06:30:00 | ES | Futures | 5864.08 | 5866.18 | 5862.51 | 5863.03 | 5324.0 |
| 2024-07-05 07:00:00 | ES | Futures | 5863.03 | 5864.61 | 5861.72 | 5864.35 | 6664.0 |
| 2024-07-05 07:30:00 | ES | Futures | 5864.35 | 5865.13 | 5860.41 | 5861.99 | 8342.0 |
| 2024-07-05 08:00:00 | ES | Futures | 5861.99 | 5866.97 | 5860.15 | 5863.56 | 10559.0 |
| 2024-07-05 08:30:00 | ES | Futures | 5863.56 | 5877.72 | 5856.74 | 5863.03 | 50834.0 |
| 2024-07-05 09:00:00 | ES | Futures | 5863.3 | 5864.61 | 5860.15 | 5864.35 | 26046.0 |
| 2024-07-05 09:30:00 | ES | Futures | 5864.35 | 5872.73 | 5860.15 | 5872.73 | 121833.0 |
| 2024-07-05 10:00:00 | ES | Futures | 5872.73 | 5875.36 | 5857.27 | 5868.02 | 117231.0 |
| 2024-07-05 10:30:00 | ES | Futures | 5868.02 | 5875.88 | 5864.61 | 5870.9 | 72757.0 |
| 2024-07-05 11:00:00 | ES | Futures | 5870.9 | 5879.29 | 5867.75 | 5876.4 | 58954.0 |
| 2024-07-05 11:30:00 | ES | Futures | 5876.4 | 5885.58 | 5876.14 | 5883.75 | 47158.0 |
| 2024-07-05 12:00:00 | ES | Futures | 5883.75 | 5885.84 | 5879.81 | 5884.27 | 34685.0 |
| 2024-07-05 12:30:00 | ES | Futures | 5884.27 | 5884.27 | 5879.03 | 5883.48 | 39191.0 |
| 2024-07-05 13:00:00 | ES | Futures | 5883.48 | 5888.46 | 5881.12 | 5887.15 | 37956.0 |
| 2024-07-05 13:30:00 | ES | Futures | 5887.15 | 5894.49 | 5886.89 | 5891.35 | 41976.0 |
| 2024-07-05 14:00:00 | ES | Futures | 5891.61 | 5892.66 | 5887.42 | 5888.73 | 36823.0 |
| 2024-07-05 14:30:00 | ES | Futures | 5888.73 | 5892.92 | 5886.63 | 5892.13 | 29627.0 |
| 2024-07-05 15:00:00 | ES | Futures | 5891.87 | 5894.76 | 5890.82 | 5892.4 | 38788.0 |
| 2024-07-05 15:30:00 | ES | Futures | 5892.13 | 5899.74 | 5891.09 | 5895.54 | 135973.0 |
| 2024-07-05 16:00:00 | ES | Futures | 5895.54 | 5895.81 | 5890.82 | 5892.4 | 54241.0 |
| 2024-07-05 16:30:00 | ES | Futures | 5892.13 | 5892.13 | 5888.2 | 5888.2 | 17263.0 |
| 2024-07-05 00:00:00 | NQ | Futures | 21555.76 | 21564.2 | 21553.91 | 21561.56 | 978.0 |
| 2024-07-05 00:30:00 | NQ | Futures | 21561.3 | 21569.48 | 21557.08 | 21564.99 | 1109.0 |
| 2024-07-05 01:00:00 | NQ | Futures | 21564.99 | 21568.95 | 21559.45 | 21567.11 | 1114.0 |
| 2024-07-05 01:30:00 | NQ | Futures | 21567.11 | 21574.76 | 21562.88 | 21571.86 | 1388.0 |
| 2024-07-05 02:00:00 | NQ | Futures | 21571.59 | 21595.88 | 21568.95 | 21589.02 | 3564.0 |
| 2024-07-05 02:30:00 | NQ | Futures | 21589.54 | 21604.59 | 21584.79 | 21587.7 | 2703.0 |
| 2024-07-05 03:00:00 | NQ | Futures | 21588.49 | 21599.05 | 21576.61 | 21580.31 | 3276.0 |
| 2024-07-05 03:30:00 | NQ | Futures | 21581.1 | 21586.38 | 21568.43 | 21585.06 | 3543.0 |
| 2024-07-05 04:00:00 | NQ | Futures | 21584.79 | 21602.22 | 21573.71 | 21586.91 | 3987.0 |
| 2024-07-05 04:30:00 | NQ | Futures | 21587.43 | 21593.24 | 21567.9 | 21571.59 | 2671.0 |
| 2024-07-05 05:00:00 | NQ | Futures | 21571.86 | 21580.83 | 21568.69 | 21578.19 | 1628.0 |
| 2024-07-05 05:30:00 | NQ | Futures | 21577.4 | 21589.28 | 21573.18 | 21575.03 | 2197.0 |
| 2024-07-05 06:00:00 | NQ | Futures | 21574.76 | 21582.42 | 21570.01 | 21580.04 | 1714.0 |
| 2024-07-05 06:30:00 | NQ | Futures | 21580.04 | 21593.24 | 21578.99 | 21584.0 | 1938.0 |
| 2024-07-05 07:00:00 | NQ | Futures | 21584.79 | 21591.66 | 21581.1 | 21586.38 | 2594.0 |
| 2024-07-05 07:30:00 | NQ | Futures | 21586.38 | 21589.02 | 21569.48 | 21576.08 | 2773.0 |
> showing 50 of 3,021 rows — these rows as CSV