PREVIEW / futures_30min / 2023-07-16
file: by_date/futures_30min/2023/2023-07-16.parquet size: 27 KB rows: 763
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-16 18:00:00 | ES | Futures | 4980.73 | 4981.01 | 4975.24 | 4976.89 | 4882.0 |
| 2023-07-16 18:30:00 | ES | Futures | 4976.89 | 4977.72 | 4973.87 | 4974.42 | 2079.0 |
| 2023-07-16 19:00:00 | ES | Futures | 4974.7 | 4974.97 | 4971.95 | 4973.05 | 2631.0 |
| 2023-07-16 19:30:00 | ES | Futures | 4972.77 | 4974.97 | 4972.22 | 4973.32 | 1908.0 |
| 2023-07-16 20:00:00 | ES | Futures | 4973.32 | 4974.15 | 4972.22 | 4973.32 | 2715.0 |
| 2023-07-16 20:30:00 | ES | Futures | 4973.32 | 4976.34 | 4973.05 | 4974.97 | 2350.0 |
| 2023-07-16 21:00:00 | ES | Futures | 4975.24 | 4979.09 | 4974.42 | 4979.09 | 3525.0 |
| 2023-07-16 21:30:00 | ES | Futures | 4979.09 | 4979.36 | 4976.34 | 4976.34 | 2053.0 |
| 2023-07-16 22:00:00 | ES | Futures | 4976.07 | 4978.54 | 4974.15 | 4977.72 | 2808.0 |
| 2023-07-16 22:30:00 | ES | Futures | 4977.72 | 4977.72 | 4975.79 | 4976.89 | 999.0 |
| 2023-07-16 23:00:00 | ES | Futures | 4976.89 | 4977.72 | 4976.62 | 4977.44 | 1199.0 |
| 2023-07-16 23:30:00 | ES | Futures | 4977.44 | 4977.99 | 4976.34 | 4976.89 | 1127.0 |
| 2023-07-16 18:00:00 | NQ | Futures | 17455.51 | 17455.79 | 17441.05 | 17451.34 | 3295.0 |
| 2023-07-16 18:30:00 | NQ | Futures | 17452.45 | 17455.51 | 17438.82 | 17442.44 | 1042.0 |
| 2023-07-16 19:00:00 | NQ | Futures | 17442.16 | 17446.61 | 17424.64 | 17430.48 | 1751.0 |
| 2023-07-16 19:30:00 | NQ | Futures | 17430.48 | 17440.77 | 17423.8 | 17429.64 | 1539.0 |
| 2023-07-16 20:00:00 | NQ | Futures | 17429.64 | 17433.26 | 17424.92 | 17426.58 | 1404.0 |
| 2023-07-16 20:30:00 | NQ | Futures | 17426.58 | 17445.78 | 17425.47 | 17439.66 | 1884.0 |
| 2023-07-16 21:00:00 | NQ | Futures | 17439.94 | 17453.01 | 17433.26 | 17452.73 | 2290.0 |
| 2023-07-16 21:30:00 | NQ | Futures | 17452.45 | 17454.68 | 17441.05 | 17441.88 | 1499.0 |
| 2023-07-16 22:00:00 | NQ | Futures | 17441.33 | 17451.62 | 17430.2 | 17447.44 | 1927.0 |
| 2023-07-16 22:30:00 | NQ | Futures | 17447.72 | 17447.72 | 17442.72 | 17443.83 | 832.0 |
| 2023-07-16 23:00:00 | NQ | Futures | 17444.11 | 17449.39 | 17443.55 | 17445.5 | 799.0 |
| 2023-07-16 23:30:00 | NQ | Futures | 17445.78 | 17448.28 | 17437.15 | 17441.6 | 1108.0 |
| 2023-07-16 18:00:00 | YM | Futures | 37957.4 | 37996.8 | 37938.7 | 37948.6 | 681.0 |
| 2023-07-16 18:30:00 | YM | Futures | 37949.7 | 37953.0 | 37922.3 | 37924.5 | 458.0 |
| 2023-07-16 19:00:00 | YM | Futures | 37926.7 | 37931.1 | 37912.4 | 37921.2 | 294.0 |
| 2023-07-16 19:30:00 | YM | Futures | 37920.1 | 37933.3 | 37917.9 | 37928.9 | 280.0 |
| 2023-07-16 20:00:00 | YM | Futures | 37928.9 | 37932.2 | 37910.2 | 37930.0 | 651.0 |
| 2023-07-16 20:30:00 | YM | Futures | 37930.0 | 37948.6 | 37928.9 | 37944.2 | 551.0 |
| 2023-07-16 21:00:00 | YM | Futures | 37944.2 | 37974.9 | 37940.9 | 37974.9 | 581.0 |
| 2023-07-16 21:30:00 | YM | Futures | 37974.9 | 37977.1 | 37955.2 | 37955.2 | 356.0 |
| 2023-07-16 22:00:00 | YM | Futures | 37955.2 | 37968.3 | 37940.9 | 37963.9 | 436.0 |
| 2023-07-16 22:30:00 | YM | Futures | 37963.9 | 37963.9 | 37950.8 | 37957.4 | 241.0 |
| 2023-07-16 23:00:00 | YM | Futures | 37958.5 | 37963.9 | 37953.0 | 37960.6 | 201.0 |
| 2023-07-16 23:30:00 | YM | Futures | 37961.7 | 37967.2 | 37957.4 | 37962.8 | 213.0 |
| 2023-07-16 18:00:00 | CL | Futures | 60.9 | 61.04 | 60.61 | 60.78 | 2018.0 |
| 2023-07-16 18:30:00 | CL | Futures | 60.78 | 60.88 | 60.78 | 60.82 | 450.0 |
| 2023-07-16 19:00:00 | CL | Futures | 60.82 | 60.82 | 60.74 | 60.79 | 281.0 |
| 2023-07-16 19:30:00 | CL | Futures | 60.79 | 60.86 | 60.78 | 60.84 | 211.0 |
| 2023-07-16 20:00:00 | CL | Futures | 60.84 | 60.88 | 60.81 | 60.86 | 465.0 |
| 2023-07-16 20:30:00 | CL | Futures | 60.86 | 60.89 | 60.81 | 60.85 | 330.0 |
| 2023-07-16 21:00:00 | CL | Futures | 60.87 | 60.99 | 60.76 | 60.92 | 1336.0 |
| 2023-07-16 21:30:00 | CL | Futures | 60.91 | 60.91 | 60.64 | 60.7 | 939.0 |
| 2023-07-16 22:00:00 | CL | Futures | 60.69 | 60.77 | 60.66 | 60.69 | 526.0 |
| 2023-07-16 22:30:00 | CL | Futures | 60.69 | 60.75 | 60.69 | 60.69 | 240.0 |
| 2023-07-16 23:00:00 | CL | Futures | 60.7 | 60.76 | 60.69 | 60.7 | 257.0 |
| 2023-07-16 23:30:00 | CL | Futures | 60.7 | 60.74 | 60.69 | 60.74 | 327.0 |
| 2023-07-16 18:00:00 | GC | Futures | 2231.1 | 2232.8 | 2229.8 | 2230.5 | 1007.0 |
| 2023-07-16 18:30:00 | GC | Futures | 2230.6 | 2231.1 | 2229.4 | 2229.5 | 515.0 |
> showing 50 of 763 rows — these rows as CSV