PREVIEW / futures_30min / 2023-11-12
file: by_date/futures_30min/2023/2023-11-12.parquet size: 28 KB rows: 811
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-11-12 18:00:00 | ES | Futures | 4807.4 | 4810.93 | 4804.41 | 4806.31 | 8608.0 |
| 2023-11-12 18:30:00 | ES | Futures | 4806.31 | 4807.67 | 4800.88 | 4802.24 | 6948.0 |
| 2023-11-12 19:00:00 | ES | Futures | 4802.24 | 4803.32 | 4799.52 | 4800.34 | 5448.0 |
| 2023-11-12 19:30:00 | ES | Futures | 4800.34 | 4801.15 | 4796.54 | 4798.16 | 4781.0 |
| 2023-11-12 20:00:00 | ES | Futures | 4798.44 | 4798.98 | 4796.54 | 4798.44 | 3889.0 |
| 2023-11-12 20:30:00 | ES | Futures | 4798.16 | 4799.52 | 4796.81 | 4798.44 | 3413.0 |
| 2023-11-12 21:00:00 | ES | Futures | 4798.16 | 4799.52 | 4797.62 | 4798.16 | 2410.0 |
| 2023-11-12 21:30:00 | ES | Futures | 4797.89 | 4798.98 | 4793.01 | 4793.28 | 6842.0 |
| 2023-11-12 22:00:00 | ES | Futures | 4793.28 | 4793.55 | 4789.2 | 4791.1 | 6754.0 |
| 2023-11-12 22:30:00 | ES | Futures | 4791.38 | 4791.92 | 4789.75 | 4791.1 | 2663.0 |
| 2023-11-12 23:00:00 | ES | Futures | 4791.1 | 4791.38 | 4789.75 | 4790.56 | 1708.0 |
| 2023-11-12 23:30:00 | ES | Futures | 4790.29 | 4791.38 | 4789.2 | 4790.02 | 1882.0 |
| 2023-11-12 18:00:00 | NQ | Futures | 17123.94 | 17140.42 | 17108.01 | 17119.54 | 5132.0 |
| 2023-11-12 18:30:00 | NQ | Futures | 17119.0 | 17124.49 | 17081.92 | 17096.2 | 4734.0 |
| 2023-11-12 19:00:00 | NQ | Futures | 17095.92 | 17102.79 | 17084.11 | 17090.7 | 2933.0 |
| 2023-11-12 19:30:00 | NQ | Futures | 17090.43 | 17092.63 | 17073.95 | 17082.46 | 2652.0 |
| 2023-11-12 20:00:00 | NQ | Futures | 17082.46 | 17085.21 | 17073.68 | 17082.46 | 2156.0 |
| 2023-11-12 20:30:00 | NQ | Futures | 17081.92 | 17085.76 | 17073.68 | 17076.15 | 2659.0 |
| 2023-11-12 21:00:00 | NQ | Futures | 17075.6 | 17079.44 | 17069.56 | 17072.03 | 1888.0 |
| 2023-11-12 21:30:00 | NQ | Futures | 17071.75 | 17078.07 | 17048.68 | 17054.17 | 4899.0 |
| 2023-11-12 22:00:00 | NQ | Futures | 17054.17 | 17054.72 | 17042.91 | 17049.51 | 2663.0 |
| 2023-11-12 22:30:00 | NQ | Futures | 17050.05 | 17051.15 | 17044.01 | 17048.96 | 1215.0 |
| 2023-11-12 23:00:00 | NQ | Futures | 17048.68 | 17049.78 | 17042.91 | 17045.11 | 888.0 |
| 2023-11-12 23:30:00 | NQ | Futures | 17044.84 | 17049.23 | 17039.62 | 17044.29 | 1370.0 |
| 2023-11-12 18:00:00 | YM | Futures | 37207.3 | 37222.5 | 37190.0 | 37200.8 | 1021.0 |
| 2023-11-12 18:30:00 | YM | Futures | 37203.0 | 37208.4 | 37183.5 | 37186.7 | 757.0 |
| 2023-11-12 19:00:00 | YM | Futures | 37190.0 | 37193.2 | 37171.5 | 37182.4 | 540.0 |
| 2023-11-12 19:30:00 | YM | Futures | 37180.2 | 37183.5 | 37156.3 | 37158.5 | 456.0 |
| 2023-11-12 20:00:00 | YM | Futures | 37158.5 | 37166.1 | 37148.8 | 37163.9 | 563.0 |
| 2023-11-12 20:30:00 | YM | Futures | 37163.9 | 37172.6 | 37155.3 | 37168.3 | 413.0 |
| 2023-11-12 21:00:00 | YM | Futures | 37169.4 | 37173.7 | 37161.8 | 37163.9 | 296.0 |
| 2023-11-12 21:30:00 | YM | Futures | 37165.0 | 37170.4 | 37137.9 | 37139.0 | 479.0 |
| 2023-11-12 22:00:00 | YM | Futures | 37140.1 | 37143.3 | 37107.5 | 37124.9 | 812.0 |
| 2023-11-12 22:30:00 | YM | Futures | 37124.9 | 37126.0 | 37117.3 | 37120.5 | 271.0 |
| 2023-11-12 23:00:00 | YM | Futures | 37120.5 | 37121.6 | 37110.8 | 37118.4 | 147.0 |
| 2023-11-12 23:30:00 | YM | Futures | 37117.3 | 37122.7 | 37108.6 | 37113.0 | 167.0 |
| 2023-11-12 18:00:00 | CL | Futures | 64.75 | 64.86 | 64.48 | 64.65 | 1691.0 |
| 2023-11-12 18:30:00 | CL | Futures | 64.65 | 64.65 | 64.52 | 64.55 | 688.0 |
| 2023-11-12 19:00:00 | CL | Futures | 64.55 | 64.55 | 64.49 | 64.53 | 527.0 |
| 2023-11-12 19:30:00 | CL | Futures | 64.53 | 64.54 | 64.39 | 64.42 | 873.0 |
| 2023-11-12 20:00:00 | CL | Futures | 64.43 | 64.44 | 64.23 | 64.39 | 2375.0 |
| 2023-11-12 20:30:00 | CL | Futures | 64.39 | 64.44 | 64.26 | 64.37 | 1104.0 |
| 2023-11-12 21:00:00 | CL | Futures | 64.37 | 64.42 | 64.25 | 64.3 | 1386.0 |
| 2023-11-12 21:30:00 | CL | Futures | 64.31 | 64.33 | 64.16 | 64.17 | 1233.0 |
| 2023-11-12 22:00:00 | CL | Futures | 64.16 | 64.19 | 64.12 | 64.14 | 657.0 |
| 2023-11-12 22:30:00 | CL | Futures | 64.14 | 64.23 | 64.13 | 64.18 | 744.0 |
| 2023-11-12 23:00:00 | CL | Futures | 64.19 | 64.2 | 64.12 | 64.16 | 323.0 |
| 2023-11-12 23:30:00 | CL | Futures | 64.15 | 64.15 | 64.08 | 64.1 | 580.0 |
| 2023-11-12 18:00:00 | GC | Futures | 2170.7 | 2172.5 | 2169.7 | 2171.9 | 1353.0 |
| 2023-11-12 18:30:00 | GC | Futures | 2171.9 | 2172.2 | 2168.4 | 2171.9 | 1807.0 |
> showing 50 of 811 rows — these rows as CSV