PREVIEW / futures_30min / 2023-06-07
file: by_date/futures_30min/2023/2023-06-07.parquet size: 105 KB rows: 3,767
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-06-07 00:00:00 | ES | Futures | 4763.82 | 4764.38 | 4762.99 | 4763.54 | 1510.0 |
| 2023-06-07 00:30:00 | ES | Futures | 4763.54 | 4763.82 | 4761.05 | 4762.99 | 3269.0 |
| 2023-06-07 01:00:00 | ES | Futures | 4762.99 | 4763.27 | 4761.05 | 4761.6 | 2339.0 |
| 2023-06-07 01:30:00 | ES | Futures | 4761.88 | 4762.99 | 4760.22 | 4761.05 | 3365.0 |
| 2023-06-07 02:00:00 | ES | Futures | 4761.33 | 4761.88 | 4759.38 | 4761.33 | 3640.0 |
| 2023-06-07 02:30:00 | ES | Futures | 4761.05 | 4761.05 | 4756.89 | 4758.55 | 3770.0 |
| 2023-06-07 03:00:00 | ES | Futures | 4758.55 | 4759.11 | 4752.45 | 4753.56 | 10644.0 |
| 2023-06-07 03:30:00 | ES | Futures | 4753.56 | 4755.5 | 4750.79 | 4752.45 | 8191.0 |
| 2023-06-07 04:00:00 | ES | Futures | 4752.45 | 4754.39 | 4749.95 | 4753.28 | 7621.0 |
| 2023-06-07 04:30:00 | ES | Futures | 4753.28 | 4755.22 | 4752.17 | 4754.39 | 3569.0 |
| 2023-06-07 05:00:00 | ES | Futures | 4754.39 | 4756.33 | 4751.9 | 4756.06 | 5249.0 |
| 2023-06-07 05:30:00 | ES | Futures | 4756.06 | 4757.44 | 4754.11 | 4754.67 | 3576.0 |
| 2023-06-07 06:00:00 | ES | Futures | 4754.67 | 4760.22 | 4754.67 | 4759.11 | 5791.0 |
| 2023-06-07 06:30:00 | ES | Futures | 4759.11 | 4761.88 | 4758.27 | 4761.33 | 5321.0 |
| 2023-06-07 07:00:00 | ES | Futures | 4761.05 | 4762.99 | 4759.94 | 4760.49 | 5987.0 |
| 2023-06-07 07:30:00 | ES | Futures | 4760.49 | 4766.87 | 4760.22 | 4766.32 | 11150.0 |
| 2023-06-07 08:00:00 | ES | Futures | 4766.32 | 4766.87 | 4762.99 | 4762.99 | 13483.0 |
| 2023-06-07 08:30:00 | ES | Futures | 4763.27 | 4764.1 | 4761.05 | 4762.99 | 9497.0 |
| 2023-06-07 09:00:00 | ES | Futures | 4763.27 | 4765.76 | 4761.6 | 4762.44 | 20997.0 |
| 2023-06-07 09:30:00 | ES | Futures | 4762.44 | 4775.75 | 4761.33 | 4772.14 | 216825.0 |
| 2023-06-07 10:00:00 | ES | Futures | 4771.87 | 4773.25 | 4757.17 | 4761.6 | 185858.0 |
| 2023-06-07 10:30:00 | ES | Futures | 4761.6 | 4764.93 | 4746.63 | 4753.56 | 177329.0 |
| 2023-06-07 11:00:00 | ES | Futures | 4753.84 | 4756.89 | 4749.12 | 4754.95 | 113647.0 |
| 2023-06-07 11:30:00 | ES | Futures | 4754.95 | 4759.94 | 4744.13 | 4745.24 | 105275.0 |
| 2023-06-07 12:00:00 | ES | Futures | 4745.52 | 4751.06 | 4742.47 | 4744.68 | 75504.0 |
| 2023-06-07 12:30:00 | ES | Futures | 4744.96 | 4752.45 | 4742.47 | 4744.68 | 67377.0 |
| 2023-06-07 13:00:00 | ES | Futures | 4744.96 | 4748.57 | 4736.64 | 4741.63 | 108418.0 |
| 2023-06-07 13:30:00 | ES | Futures | 4741.36 | 4744.68 | 4736.36 | 4743.02 | 81239.0 |
| 2023-06-07 14:00:00 | ES | Futures | 4743.3 | 4750.79 | 4741.63 | 4746.63 | 73427.0 |
| 2023-06-07 14:30:00 | ES | Futures | 4746.35 | 4747.18 | 4738.31 | 4746.07 | 74824.0 |
| 2023-06-07 15:00:00 | ES | Futures | 4745.79 | 4749.4 | 4739.69 | 4745.52 | 80676.0 |
| 2023-06-07 15:30:00 | ES | Futures | 4745.24 | 4748.01 | 4736.64 | 4742.19 | 210669.0 |
| 2023-06-07 16:00:00 | ES | Futures | 4742.19 | 4743.3 | 4739.97 | 4742.74 | 55738.0 |
| 2023-06-07 16:30:00 | ES | Futures | 4742.74 | 4743.02 | 4740.52 | 4740.8 | 7106.0 |
| 2023-06-07 18:00:00 | ES | Futures | 4740.8 | 4744.41 | 4740.52 | 4743.02 | 3522.0 |
| 2023-06-07 18:30:00 | ES | Futures | 4743.02 | 4743.02 | 4739.69 | 4739.97 | 2804.0 |
| 2023-06-07 19:00:00 | ES | Futures | 4740.25 | 4741.36 | 4739.69 | 4740.52 | 1173.0 |
| 2023-06-07 19:30:00 | ES | Futures | 4740.52 | 4742.19 | 4739.97 | 4741.91 | 3016.0 |
| 2023-06-07 20:00:00 | ES | Futures | 4741.91 | 4743.58 | 4740.52 | 4741.91 | 4635.0 |
| 2023-06-07 20:30:00 | ES | Futures | 4742.19 | 4743.85 | 4741.36 | 4743.02 | 2750.0 |
| 2023-06-07 21:00:00 | ES | Futures | 4742.74 | 4744.41 | 4742.19 | 4743.3 | 2180.0 |
| 2023-06-07 21:30:00 | ES | Futures | 4743.3 | 4743.85 | 4739.14 | 4742.19 | 4301.0 |
| 2023-06-07 22:00:00 | ES | Futures | 4742.47 | 4742.74 | 4741.36 | 4741.91 | 2587.0 |
| 2023-06-07 22:30:00 | ES | Futures | 4741.91 | 4742.47 | 4740.52 | 4740.8 | 1848.0 |
| 2023-06-07 23:00:00 | ES | Futures | 4740.8 | 4741.91 | 4740.25 | 4741.08 | 1750.0 |
| 2023-06-07 23:30:00 | ES | Futures | 4740.8 | 4740.8 | 4736.36 | 4737.2 | 5776.0 |
| 2023-06-07 00:00:00 | NQ | Futures | 16427.49 | 16428.62 | 16422.42 | 16425.8 | 754.0 |
| 2023-06-07 00:30:00 | NQ | Futures | 16425.8 | 16426.37 | 16417.36 | 16420.74 | 1151.0 |
| 2023-06-07 01:00:00 | NQ | Futures | 16420.74 | 16426.93 | 16417.36 | 16421.02 | 1269.0 |
| 2023-06-07 01:30:00 | NQ | Futures | 16421.3 | 16425.24 | 16414.82 | 16418.48 | 1004.0 |
> showing 50 of 3,767 rows — these rows as CSV