PREVIEW / futures_30min / 2022-11-06
file: by_date/futures_30min/2022/2022-11-06.parquet size: 30 KB rows: 845
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-06 18:00:00 | ES | Futures | 4228.4 | 4235.73 | 4215.15 | 4232.35 | 12447.0 |
| 2022-11-06 18:30:00 | ES | Futures | 4232.07 | 4233.2 | 4229.53 | 4230.38 | 4332.0 |
| 2022-11-06 19:00:00 | ES | Futures | 4230.1 | 4240.81 | 4230.1 | 4236.58 | 6537.0 |
| 2022-11-06 19:30:00 | ES | Futures | 4236.58 | 4243.91 | 4234.61 | 4240.24 | 5549.0 |
| 2022-11-06 20:00:00 | ES | Futures | 4239.96 | 4240.24 | 4228.97 | 4232.35 | 6846.0 |
| 2022-11-06 20:30:00 | ES | Futures | 4232.07 | 4250.96 | 4231.22 | 4247.29 | 14997.0 |
| 2022-11-06 21:00:00 | ES | Futures | 4247.57 | 4250.39 | 4245.88 | 4247.85 | 5861.0 |
| 2022-11-06 21:30:00 | ES | Futures | 4247.85 | 4254.62 | 4246.73 | 4253.21 | 6789.0 |
| 2022-11-06 22:00:00 | ES | Futures | 4253.21 | 4258.57 | 4248.7 | 4254.06 | 6479.0 |
| 2022-11-06 22:30:00 | ES | Futures | 4254.06 | 4257.16 | 4251.8 | 4253.21 | 4157.0 |
| 2022-11-06 23:00:00 | ES | Futures | 4253.21 | 4258.0 | 4251.52 | 4255.75 | 4354.0 |
| 2022-11-06 23:30:00 | ES | Futures | 4255.75 | 4257.72 | 4253.77 | 4254.62 | 2661.0 |
| 2022-11-06 18:00:00 | NQ | Futures | 12396.96 | 12432.59 | 12356.16 | 12412.77 | 6523.0 |
| 2022-11-06 18:30:00 | NQ | Futures | 12412.48 | 12415.06 | 12397.25 | 12408.17 | 2400.0 |
| 2022-11-06 19:00:00 | NQ | Futures | 12408.46 | 12445.81 | 12401.56 | 12429.43 | 3177.0 |
| 2022-11-06 19:30:00 | NQ | Futures | 12430.01 | 12452.7 | 12421.96 | 12437.76 | 2509.0 |
| 2022-11-06 20:00:00 | NQ | Futures | 12437.19 | 12437.76 | 12395.24 | 12403.86 | 3348.0 |
| 2022-11-06 20:30:00 | NQ | Futures | 12403.0 | 12473.1 | 12400.12 | 12463.05 | 5755.0 |
| 2022-11-06 21:00:00 | NQ | Futures | 12462.47 | 12469.94 | 12449.83 | 12465.92 | 2552.0 |
| 2022-11-06 21:30:00 | NQ | Futures | 12464.48 | 12492.07 | 12460.75 | 12487.76 | 2851.0 |
| 2022-11-06 22:00:00 | NQ | Futures | 12488.05 | 12506.72 | 12471.09 | 12490.06 | 3220.0 |
| 2022-11-06 22:30:00 | NQ | Futures | 12490.92 | 12502.12 | 12483.45 | 12486.61 | 1779.0 |
| 2022-11-06 23:00:00 | NQ | Futures | 12485.75 | 12498.68 | 12475.4 | 12489.48 | 2510.0 |
| 2022-11-06 23:30:00 | NQ | Futures | 12490.92 | 12498.1 | 12484.02 | 12486.03 | 1171.0 |
| 2022-11-06 18:00:00 | YM | Futures | 36216.7 | 36217.8 | 36038.3 | 36179.7 | 1994.0 |
| 2022-11-06 18:30:00 | YM | Futures | 36179.7 | 36186.4 | 36162.9 | 36168.5 | 706.0 |
| 2022-11-06 19:00:00 | YM | Futures | 36168.5 | 36244.8 | 36168.5 | 36203.3 | 994.0 |
| 2022-11-06 19:30:00 | YM | Futures | 36206.6 | 36266.1 | 36189.8 | 36239.2 | 787.0 |
| 2022-11-06 20:00:00 | YM | Futures | 36235.8 | 36238.0 | 36176.3 | 36203.3 | 1021.0 |
| 2022-11-06 20:30:00 | YM | Futures | 36199.9 | 36335.7 | 36197.6 | 36307.6 | 1651.0 |
| 2022-11-06 21:00:00 | YM | Futures | 36304.3 | 36322.2 | 36291.9 | 36311.0 | 547.0 |
| 2022-11-06 21:30:00 | YM | Futures | 36304.3 | 36352.5 | 36299.8 | 36344.7 | 734.0 |
| 2022-11-06 22:00:00 | YM | Futures | 36343.5 | 36377.2 | 36311.0 | 36348.0 | 737.0 |
| 2022-11-06 22:30:00 | YM | Futures | 36351.4 | 36366.0 | 36334.6 | 36339.0 | 414.0 |
| 2022-11-06 23:00:00 | YM | Futures | 36335.7 | 36371.6 | 36326.7 | 36354.8 | 385.0 |
| 2022-11-06 23:30:00 | YM | Futures | 36354.8 | 36367.1 | 36344.7 | 36348.0 | 260.0 |
| 2022-11-06 18:00:00 | CL | Futures | 74.03 | 74.24 | 73.54 | 73.89 | 7405.0 |
| 2022-11-06 18:30:00 | CL | Futures | 73.88 | 73.93 | 73.76 | 73.78 | 1292.0 |
| 2022-11-06 19:00:00 | CL | Futures | 73.78 | 73.98 | 73.76 | 73.97 | 1473.0 |
| 2022-11-06 19:30:00 | CL | Futures | 73.97 | 74.35 | 73.89 | 74.28 | 1540.0 |
| 2022-11-06 20:00:00 | CL | Futures | 74.29 | 74.39 | 74.01 | 74.16 | 2660.0 |
| 2022-11-06 20:30:00 | CL | Futures | 74.16 | 74.56 | 74.11 | 74.51 | 3104.0 |
| 2022-11-06 21:00:00 | CL | Futures | 74.5 | 74.51 | 74.16 | 74.25 | 1979.0 |
| 2022-11-06 21:30:00 | CL | Futures | 74.24 | 74.35 | 74.17 | 74.32 | 1019.0 |
| 2022-11-06 22:00:00 | CL | Futures | 74.33 | 74.34 | 74.14 | 74.34 | 992.0 |
| 2022-11-06 22:30:00 | CL | Futures | 74.33 | 74.46 | 74.3 | 74.37 | 1167.0 |
| 2022-11-06 23:00:00 | CL | Futures | 74.37 | 74.51 | 74.35 | 74.42 | 779.0 |
| 2022-11-06 23:30:00 | CL | Futures | 74.42 | 74.45 | 74.33 | 74.35 | 457.0 |
| 2022-11-06 18:00:00 | GC | Futures | 1982.7 | 1988.3 | 1980.4 | 1984.1 | 5756.0 |
| 2022-11-06 18:30:00 | GC | Futures | 1983.5 | 1983.5 | 1978.9 | 1979.5 | 2662.0 |
> showing 50 of 845 rows — these rows as CSV