PREVIEW / futures_30min / 2023-04-14
file: by_date/futures_30min/2023/2023-04-14.parquet size: 92 KB rows: 3,098
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-14 00:00:00 | ES | Futures | 4627.92 | 4628.47 | 4626.53 | 4627.09 | 1790.0 |
| 2023-04-14 00:30:00 | ES | Futures | 4627.09 | 4627.92 | 4626.53 | 4626.53 | 1105.0 |
| 2023-04-14 01:00:00 | ES | Futures | 4626.53 | 4627.36 | 4625.98 | 4626.81 | 1656.0 |
| 2023-04-14 01:30:00 | ES | Futures | 4626.81 | 4627.64 | 4626.25 | 4627.36 | 1700.0 |
| 2023-04-14 02:00:00 | ES | Futures | 4627.64 | 4627.64 | 4623.76 | 4625.98 | 4214.0 |
| 2023-04-14 02:30:00 | ES | Futures | 4625.98 | 4627.09 | 4623.2 | 4624.59 | 3487.0 |
| 2023-04-14 03:00:00 | ES | Futures | 4624.31 | 4629.03 | 4622.93 | 4628.2 | 9421.0 |
| 2023-04-14 03:30:00 | ES | Futures | 4628.47 | 4629.58 | 4625.42 | 4627.36 | 5892.0 |
| 2023-04-14 04:00:00 | ES | Futures | 4627.09 | 4627.64 | 4620.71 | 4622.09 | 8266.0 |
| 2023-04-14 04:30:00 | ES | Futures | 4622.09 | 4623.2 | 4620.15 | 4621.26 | 6006.0 |
| 2023-04-14 05:00:00 | ES | Futures | 4621.26 | 4623.2 | 4619.88 | 4622.65 | 5370.0 |
| 2023-04-14 05:30:00 | ES | Futures | 4622.93 | 4623.76 | 4620.43 | 4622.09 | 7200.0 |
| 2023-04-14 06:00:00 | ES | Futures | 4622.37 | 4622.37 | 4617.1 | 4621.54 | 11610.0 |
| 2023-04-14 06:30:00 | ES | Futures | 4621.54 | 4627.09 | 4618.77 | 4624.59 | 18756.0 |
| 2023-04-14 07:00:00 | ES | Futures | 4624.59 | 4631.25 | 4623.2 | 4626.81 | 24253.0 |
| 2023-04-14 07:30:00 | ES | Futures | 4626.81 | 4627.92 | 4624.59 | 4626.53 | 10393.0 |
| 2023-04-14 08:00:00 | ES | Futures | 4626.53 | 4633.74 | 4625.98 | 4629.86 | 19622.0 |
| 2023-04-14 08:30:00 | ES | Futures | 4629.86 | 4634.58 | 4617.66 | 4622.93 | 54615.0 |
| 2023-04-14 09:00:00 | ES | Futures | 4622.65 | 4624.31 | 4618.77 | 4622.09 | 28347.0 |
| 2023-04-14 09:30:00 | ES | Futures | 4622.09 | 4647.33 | 4621.82 | 4644.01 | 196135.0 |
| 2023-04-14 10:00:00 | ES | Futures | 4644.01 | 4645.95 | 4614.33 | 4616.27 | 246630.0 |
| 2023-04-14 10:30:00 | ES | Futures | 4616.55 | 4621.26 | 4609.34 | 4615.16 | 140009.0 |
| 2023-04-14 11:00:00 | ES | Futures | 4615.44 | 4617.93 | 4606.84 | 4607.95 | 103082.0 |
| 2023-04-14 11:30:00 | ES | Futures | 4608.23 | 4611.55 | 4604.34 | 4610.17 | 76331.0 |
| 2023-04-14 12:00:00 | ES | Futures | 4610.17 | 4611.0 | 4601.29 | 4602.96 | 79215.0 |
| 2023-04-14 12:30:00 | ES | Futures | 4602.96 | 4603.23 | 4591.59 | 4594.08 | 82743.0 |
| 2023-04-14 13:00:00 | ES | Futures | 4594.08 | 4607.39 | 4593.25 | 4596.86 | 73447.0 |
| 2023-04-14 13:30:00 | ES | Futures | 4597.13 | 4602.96 | 4590.75 | 4601.29 | 78485.0 |
| 2023-04-14 14:00:00 | ES | Futures | 4601.57 | 4611.83 | 4597.69 | 4611.28 | 72058.0 |
| 2023-04-14 14:30:00 | ES | Futures | 4611.55 | 4614.88 | 4608.78 | 4613.77 | 65325.0 |
| 2023-04-14 15:00:00 | ES | Futures | 4614.05 | 4614.05 | 4597.69 | 4610.45 | 105719.0 |
| 2023-04-14 15:30:00 | ES | Futures | 4610.45 | 4621.54 | 4609.06 | 4618.77 | 153726.0 |
| 2023-04-14 16:00:00 | ES | Futures | 4618.49 | 4627.36 | 4618.49 | 4626.53 | 54262.0 |
| 2023-04-14 16:30:00 | ES | Futures | 4626.25 | 4632.08 | 4626.25 | 4628.2 | 36696.0 |
| 2023-04-14 00:00:00 | NQ | Futures | 14864.31 | 14867.41 | 14858.4 | 14864.03 | 927.0 |
| 2023-04-14 00:30:00 | NQ | Futures | 14864.03 | 14865.72 | 14859.52 | 14860.09 | 637.0 |
| 2023-04-14 01:00:00 | NQ | Futures | 14860.09 | 14863.18 | 14856.99 | 14859.81 | 922.0 |
| 2023-04-14 01:30:00 | NQ | Futures | 14858.96 | 14862.9 | 14856.71 | 14862.34 | 788.0 |
| 2023-04-14 02:00:00 | NQ | Futures | 14862.62 | 14865.44 | 14849.95 | 14862.62 | 1995.0 |
| 2023-04-14 02:30:00 | NQ | Futures | 14862.34 | 14866.56 | 14847.42 | 14851.08 | 1556.0 |
| 2023-04-14 03:00:00 | NQ | Futures | 14851.08 | 14885.43 | 14842.35 | 14876.14 | 4952.0 |
| 2023-04-14 03:30:00 | NQ | Futures | 14875.57 | 14882.89 | 14868.25 | 14875.01 | 2392.0 |
| 2023-04-14 04:00:00 | NQ | Futures | 14875.01 | 14878.95 | 14844.04 | 14847.42 | 4025.0 |
| 2023-04-14 04:30:00 | NQ | Futures | 14847.42 | 14850.8 | 14842.35 | 14845.45 | 1991.0 |
| 2023-04-14 05:00:00 | NQ | Futures | 14845.16 | 14849.39 | 14833.06 | 14840.38 | 3365.0 |
| 2023-04-14 05:30:00 | NQ | Futures | 14839.81 | 14844.04 | 14822.08 | 14829.68 | 3803.0 |
| 2023-04-14 06:00:00 | NQ | Futures | 14830.24 | 14832.78 | 14808.84 | 14827.71 | 5125.0 |
| 2023-04-14 06:30:00 | NQ | Futures | 14827.14 | 14837.28 | 14777.03 | 14795.05 | 8986.0 |
| 2023-04-14 07:00:00 | NQ | Futures | 14795.05 | 14808.56 | 14783.79 | 14808.28 | 9144.0 |
| 2023-04-14 07:30:00 | NQ | Futures | 14808.28 | 14811.94 | 14792.23 | 14804.62 | 4775.0 |
> showing 50 of 3,098 rows — these rows as CSV