PREVIEW / futures_30min / 2023-04-20
file: by_date/futures_30min/2023/2023-04-20.parquet size: 105 KB rows: 3,786
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-20 00:00:00 | ES | Futures | 4627.36 | 4628.2 | 4626.25 | 4626.25 | 1791.0 |
| 2023-04-20 00:30:00 | ES | Futures | 4626.53 | 4626.81 | 4624.04 | 4624.59 | 1409.0 |
| 2023-04-20 01:00:00 | ES | Futures | 4624.87 | 4624.87 | 4620.71 | 4620.98 | 3432.0 |
| 2023-04-20 01:30:00 | ES | Futures | 4620.98 | 4623.48 | 4620.71 | 4622.65 | 3435.0 |
| 2023-04-20 02:00:00 | ES | Futures | 4622.65 | 4626.25 | 4620.71 | 4624.04 | 5423.0 |
| 2023-04-20 02:30:00 | ES | Futures | 4623.76 | 4624.59 | 4621.54 | 4622.37 | 3154.0 |
| 2023-04-20 03:00:00 | ES | Futures | 4622.65 | 4622.93 | 4614.33 | 4614.61 | 14718.0 |
| 2023-04-20 03:30:00 | ES | Futures | 4614.61 | 4615.16 | 4600.74 | 4603.51 | 27157.0 |
| 2023-04-20 04:00:00 | ES | Futures | 4603.51 | 4605.18 | 4600.18 | 4602.12 | 15117.0 |
| 2023-04-20 04:30:00 | ES | Futures | 4601.85 | 4602.96 | 4597.69 | 4600.18 | 11818.0 |
| 2023-04-20 05:00:00 | ES | Futures | 4600.18 | 4602.96 | 4598.8 | 4602.96 | 8552.0 |
| 2023-04-20 05:30:00 | ES | Futures | 4602.68 | 4604.34 | 4601.02 | 4603.23 | 7200.0 |
| 2023-04-20 06:00:00 | ES | Futures | 4602.96 | 4605.45 | 4600.46 | 4601.57 | 7768.0 |
| 2023-04-20 06:30:00 | ES | Futures | 4601.57 | 4606.29 | 4600.18 | 4606.01 | 7342.0 |
| 2023-04-20 07:00:00 | ES | Futures | 4606.01 | 4608.23 | 4603.79 | 4607.12 | 9517.0 |
| 2023-04-20 07:30:00 | ES | Futures | 4606.84 | 4607.12 | 4600.74 | 4600.74 | 10537.0 |
| 2023-04-20 08:00:00 | ES | Futures | 4601.02 | 4601.57 | 4596.3 | 4601.02 | 23837.0 |
| 2023-04-20 08:30:00 | ES | Futures | 4601.29 | 4605.18 | 4597.96 | 4604.34 | 24677.0 |
| 2023-04-20 09:00:00 | ES | Futures | 4604.07 | 4604.9 | 4599.07 | 4599.91 | 23845.0 |
| 2023-04-20 09:30:00 | ES | Futures | 4599.91 | 4612.11 | 4598.52 | 4604.62 | 159847.0 |
| 2023-04-20 10:00:00 | ES | Futures | 4604.62 | 4614.61 | 4601.29 | 4611.28 | 116866.0 |
| 2023-04-20 10:30:00 | ES | Futures | 4611.28 | 4618.49 | 4610.72 | 4616.82 | 94200.0 |
| 2023-04-20 11:00:00 | ES | Futures | 4616.82 | 4618.21 | 4607.39 | 4611.0 | 93007.0 |
| 2023-04-20 11:30:00 | ES | Futures | 4611.0 | 4615.72 | 4606.56 | 4612.66 | 74301.0 |
| 2023-04-20 12:00:00 | ES | Futures | 4612.66 | 4616.82 | 4606.84 | 4615.99 | 63571.0 |
| 2023-04-20 12:30:00 | ES | Futures | 4615.99 | 4623.76 | 4614.88 | 4622.65 | 76381.0 |
| 2023-04-20 13:00:00 | ES | Futures | 4622.93 | 4626.81 | 4621.26 | 4626.25 | 74547.0 |
| 2023-04-20 13:30:00 | ES | Futures | 4626.25 | 4628.2 | 4621.82 | 4622.65 | 67506.0 |
| 2023-04-20 14:00:00 | ES | Futures | 4622.65 | 4622.93 | 4613.22 | 4613.77 | 89157.0 |
| 2023-04-20 14:30:00 | ES | Futures | 4613.77 | 4614.33 | 4599.07 | 4604.62 | 144462.0 |
| 2023-04-20 15:00:00 | ES | Futures | 4604.62 | 4607.12 | 4589.64 | 4590.75 | 144503.0 |
| 2023-04-20 15:30:00 | ES | Futures | 4590.75 | 4608.78 | 4590.75 | 4607.95 | 198306.0 |
| 2023-04-20 16:00:00 | ES | Futures | 4607.95 | 4613.22 | 4606.56 | 4609.61 | 61587.0 |
| 2023-04-20 16:30:00 | ES | Futures | 4609.61 | 4610.17 | 4607.95 | 4608.23 | 9202.0 |
| 2023-04-20 18:00:00 | ES | Futures | 4608.23 | 4608.5 | 4605.45 | 4607.67 | 3072.0 |
| 2023-04-20 18:30:00 | ES | Futures | 4607.39 | 4607.67 | 4605.73 | 4606.84 | 1908.0 |
| 2023-04-20 19:00:00 | ES | Futures | 4606.84 | 4609.34 | 4606.56 | 4607.12 | 2775.0 |
| 2023-04-20 19:30:00 | ES | Futures | 4607.39 | 4607.95 | 4604.34 | 4605.73 | 2944.0 |
| 2023-04-20 20:00:00 | ES | Futures | 4605.45 | 4606.84 | 4604.34 | 4605.73 | 3023.0 |
| 2023-04-20 20:30:00 | ES | Futures | 4605.45 | 4612.11 | 4605.18 | 4612.11 | 4155.0 |
| 2023-04-20 21:00:00 | ES | Futures | 4611.83 | 4612.39 | 4608.23 | 4609.06 | 3175.0 |
| 2023-04-20 21:30:00 | ES | Futures | 4609.06 | 4610.72 | 4607.39 | 4609.34 | 2964.0 |
| 2023-04-20 22:00:00 | ES | Futures | 4609.06 | 4609.89 | 4607.39 | 4607.67 | 2264.0 |
| 2023-04-20 22:30:00 | ES | Futures | 4607.67 | 4608.5 | 4606.84 | 4608.23 | 1746.0 |
| 2023-04-20 23:00:00 | ES | Futures | 4608.5 | 4611.0 | 4608.23 | 4609.06 | 2766.0 |
| 2023-04-20 23:30:00 | ES | Futures | 4609.06 | 4609.89 | 4607.95 | 4609.61 | 2103.0 |
| 2023-04-20 00:00:00 | NQ | Futures | 14799.27 | 14800.12 | 14792.8 | 14793.36 | 915.0 |
| 2023-04-20 00:30:00 | NQ | Futures | 14793.92 | 14795.89 | 14787.45 | 14791.11 | 749.0 |
| 2023-04-20 01:00:00 | NQ | Futures | 14791.67 | 14791.95 | 14770.83 | 14771.96 | 1958.0 |
| 2023-04-20 01:30:00 | NQ | Futures | 14771.4 | 14777.59 | 14766.89 | 14771.4 | 2132.0 |
> showing 50 of 3,786 rows — these rows as CSV