PREVIEW / futures_30min / 2023-07-30
file: by_date/futures_30min/2023/2023-07-30.parquet size: 29 KB rows: 787
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-07-30 18:00:00 | ES | Futures | 5060.62 | 5066.93 | 5059.79 | 5066.66 | 6399.0 |
| 2023-07-30 18:30:00 | ES | Futures | 5066.93 | 5070.77 | 5065.83 | 5067.75 | 5215.0 |
| 2023-07-30 19:00:00 | ES | Futures | 5068.03 | 5069.13 | 5066.38 | 5067.21 | 2256.0 |
| 2023-07-30 19:30:00 | ES | Futures | 5067.48 | 5068.58 | 5063.91 | 5064.46 | 3249.0 |
| 2023-07-30 20:00:00 | ES | Futures | 5064.46 | 5064.74 | 5061.17 | 5061.44 | 4893.0 |
| 2023-07-30 20:30:00 | ES | Futures | 5061.72 | 5063.09 | 5059.79 | 5060.62 | 3499.0 |
| 2023-07-30 21:00:00 | ES | Futures | 5060.62 | 5061.44 | 5055.95 | 5059.52 | 6041.0 |
| 2023-07-30 21:30:00 | ES | Futures | 5059.52 | 5063.64 | 5052.93 | 5053.75 | 7788.0 |
| 2023-07-30 22:00:00 | ES | Futures | 5053.75 | 5056.23 | 5049.91 | 5050.74 | 7720.0 |
| 2023-07-30 22:30:00 | ES | Futures | 5050.74 | 5054.3 | 5049.64 | 5051.56 | 3287.0 |
| 2023-07-30 23:00:00 | ES | Futures | 5051.56 | 5051.83 | 5047.72 | 5049.64 | 5107.0 |
| 2023-07-30 23:30:00 | ES | Futures | 5049.36 | 5049.91 | 5047.17 | 5048.81 | 3487.0 |
| 2023-07-30 18:00:00 | NQ | Futures | 17633.51 | 17680.8 | 17623.5 | 17678.02 | 5510.0 |
| 2023-07-30 18:30:00 | NQ | Futures | 17678.29 | 17708.05 | 17673.29 | 17690.81 | 3992.0 |
| 2023-07-30 19:00:00 | NQ | Futures | 17691.37 | 17693.03 | 17679.96 | 17682.47 | 2068.0 |
| 2023-07-30 19:30:00 | NQ | Futures | 17683.86 | 17694.15 | 17671.06 | 17675.23 | 2176.0 |
| 2023-07-30 20:00:00 | NQ | Futures | 17674.68 | 17676.35 | 17647.14 | 17650.2 | 4396.0 |
| 2023-07-30 20:30:00 | NQ | Futures | 17650.2 | 17655.76 | 17632.68 | 17638.52 | 3771.0 |
| 2023-07-30 21:00:00 | NQ | Futures | 17637.96 | 17640.47 | 17602.09 | 17624.61 | 5185.0 |
| 2023-07-30 21:30:00 | NQ | Futures | 17624.89 | 17647.7 | 17600.69 | 17605.42 | 5623.0 |
| 2023-07-30 22:00:00 | NQ | Futures | 17604.31 | 17614.6 | 17588.74 | 17594.3 | 4392.0 |
| 2023-07-30 22:30:00 | NQ | Futures | 17594.3 | 17608.2 | 17590.13 | 17598.19 | 2241.0 |
| 2023-07-30 23:00:00 | NQ | Futures | 17598.75 | 17598.75 | 17573.16 | 17584.56 | 3313.0 |
| 2023-07-30 23:30:00 | NQ | Futures | 17583.73 | 17591.24 | 17576.22 | 17585.95 | 2148.0 |
| 2023-07-30 18:00:00 | YM | Futures | 38999.2 | 39033.2 | 38999.2 | 39020.0 | 1078.0 |
| 2023-07-30 18:30:00 | YM | Futures | 39020.0 | 39038.7 | 39016.7 | 39021.1 | 575.0 |
| 2023-07-30 19:00:00 | YM | Futures | 39023.3 | 39029.9 | 39014.6 | 39023.3 | 225.0 |
| 2023-07-30 19:30:00 | YM | Futures | 39024.4 | 39027.7 | 39002.5 | 39003.6 | 464.0 |
| 2023-07-30 20:00:00 | YM | Futures | 39002.5 | 39002.5 | 38986.1 | 38997.0 | 674.0 |
| 2023-07-30 20:30:00 | YM | Futures | 38998.1 | 39004.7 | 38989.4 | 38995.9 | 354.0 |
| 2023-07-30 21:00:00 | YM | Futures | 38994.8 | 38998.1 | 38981.7 | 38993.7 | 585.0 |
| 2023-07-30 21:30:00 | YM | Futures | 38994.8 | 39016.7 | 38947.7 | 38952.1 | 710.0 |
| 2023-07-30 22:00:00 | YM | Futures | 38952.1 | 38971.8 | 38930.2 | 38934.6 | 676.0 |
| 2023-07-30 22:30:00 | YM | Futures | 38934.6 | 38957.6 | 38929.1 | 38942.3 | 409.0 |
| 2023-07-30 23:00:00 | YM | Futures | 38942.3 | 38947.7 | 38918.1 | 38930.2 | 568.0 |
| 2023-07-30 23:30:00 | YM | Futures | 38930.2 | 38931.3 | 38913.8 | 38922.5 | 618.0 |
| 2023-07-30 18:00:00 | CL | Futures | 65.59 | 65.59 | 65.4 | 65.44 | 1336.0 |
| 2023-07-30 18:30:00 | CL | Futures | 65.43 | 65.51 | 65.41 | 65.42 | 488.0 |
| 2023-07-30 19:00:00 | CL | Futures | 65.42 | 65.46 | 65.39 | 65.43 | 298.0 |
| 2023-07-30 19:30:00 | CL | Futures | 65.44 | 65.5 | 65.39 | 65.4 | 738.0 |
| 2023-07-30 20:00:00 | CL | Futures | 65.39 | 65.44 | 65.36 | 65.4 | 676.0 |
| 2023-07-30 20:30:00 | CL | Futures | 65.4 | 65.42 | 65.32 | 65.33 | 666.0 |
| 2023-07-30 21:00:00 | CL | Futures | 65.33 | 65.35 | 65.26 | 65.34 | 1545.0 |
| 2023-07-30 21:30:00 | CL | Futures | 65.34 | 65.53 | 65.34 | 65.4 | 1511.0 |
| 2023-07-30 22:00:00 | CL | Futures | 65.4 | 65.43 | 65.32 | 65.35 | 799.0 |
| 2023-07-30 22:30:00 | CL | Futures | 65.34 | 65.41 | 65.31 | 65.37 | 865.0 |
| 2023-07-30 23:00:00 | CL | Futures | 65.37 | 65.37 | 65.27 | 65.28 | 908.0 |
| 2023-07-30 23:30:00 | CL | Futures | 65.27 | 65.29 | 65.18 | 65.21 | 1008.0 |
| 2023-07-30 18:00:00 | GC | Futures | 2231.6 | 2232.5 | 2230.6 | 2232.2 | 680.0 |
| 2023-07-30 18:30:00 | GC | Futures | 2232.1 | 2232.6 | 2231.8 | 2232.0 | 288.0 |
> showing 50 of 787 rows — these rows as CSV