PREVIEW / futures_30min / 2023-05-21
file: by_date/futures_30min/2023/2023-05-21.parquet size: 27 KB rows: 742
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-05-21 18:00:00 | ES | Futures | 4647.33 | 4654.82 | 4644.56 | 4654.82 | 7024.0 |
| 2023-05-21 18:30:00 | ES | Futures | 4654.82 | 4656.21 | 4653.71 | 4655.65 | 2706.0 |
| 2023-05-21 19:00:00 | ES | Futures | 4655.65 | 4658.98 | 4655.38 | 4657.6 | 3210.0 |
| 2023-05-21 19:30:00 | ES | Futures | 4657.87 | 4660.92 | 4657.32 | 4659.81 | 2597.0 |
| 2023-05-21 20:00:00 | ES | Futures | 4659.81 | 4663.7 | 4658.15 | 4661.76 | 4603.0 |
| 2023-05-21 20:30:00 | ES | Futures | 4662.03 | 4662.87 | 4658.7 | 4661.48 | 2936.0 |
| 2023-05-21 21:00:00 | ES | Futures | 4661.48 | 4662.87 | 4659.26 | 4661.76 | 3656.0 |
| 2023-05-21 21:30:00 | ES | Futures | 4661.76 | 4661.76 | 4658.15 | 4659.54 | 2982.0 |
| 2023-05-21 22:00:00 | ES | Futures | 4659.54 | 4660.65 | 4657.6 | 4659.26 | 3271.0 |
| 2023-05-21 22:30:00 | ES | Futures | 4659.26 | 4660.65 | 4657.87 | 4660.09 | 2105.0 |
| 2023-05-21 23:00:00 | ES | Futures | 4660.37 | 4662.31 | 4659.54 | 4661.76 | 2211.0 |
| 2023-05-21 23:30:00 | ES | Futures | 4661.76 | 4663.97 | 4661.48 | 4663.7 | 2057.0 |
| 2023-05-21 18:00:00 | NQ | Futures | 15547.92 | 15581.14 | 15535.25 | 15580.86 | 4142.0 |
| 2023-05-21 18:30:00 | NQ | Futures | 15580.58 | 15589.87 | 15575.51 | 15583.4 | 1653.0 |
| 2023-05-21 19:00:00 | NQ | Futures | 15584.24 | 15596.35 | 15581.71 | 15593.53 | 1684.0 |
| 2023-05-21 19:30:00 | NQ | Futures | 15593.53 | 15604.79 | 15593.25 | 15601.7 | 1663.0 |
| 2023-05-21 20:00:00 | NQ | Futures | 15601.7 | 15611.83 | 15594.66 | 15608.74 | 2579.0 |
| 2023-05-21 20:30:00 | NQ | Futures | 15609.02 | 15612.11 | 15596.63 | 15606.77 | 1729.0 |
| 2023-05-21 21:00:00 | NQ | Futures | 15607.05 | 15617.18 | 15600.01 | 15613.8 | 2247.0 |
| 2023-05-21 21:30:00 | NQ | Futures | 15613.24 | 15614.37 | 15600.29 | 15607.33 | 1714.0 |
| 2023-05-21 22:00:00 | NQ | Futures | 15607.89 | 15613.8 | 15600.85 | 15610.99 | 1550.0 |
| 2023-05-21 22:30:00 | NQ | Futures | 15610.71 | 15613.24 | 15604.79 | 15611.55 | 886.0 |
| 2023-05-21 23:00:00 | NQ | Futures | 15611.55 | 15625.07 | 15610.99 | 15619.44 | 1668.0 |
| 2023-05-21 23:30:00 | NQ | Futures | 15619.15 | 15624.5 | 15617.75 | 15621.69 | 963.0 |
| 2023-05-21 18:00:00 | YM | Futures | 36930.6 | 36954.9 | 36888.6 | 36954.9 | 748.0 |
| 2023-05-21 18:30:00 | YM | Futures | 36952.7 | 36959.3 | 36946.0 | 36959.3 | 288.0 |
| 2023-05-21 19:00:00 | YM | Futures | 36959.3 | 36981.4 | 36958.2 | 36975.9 | 475.0 |
| 2023-05-21 19:30:00 | YM | Futures | 36974.8 | 36992.5 | 36972.6 | 36989.1 | 436.0 |
| 2023-05-21 20:00:00 | YM | Futures | 36988.0 | 37013.5 | 36974.8 | 37003.5 | 623.0 |
| 2023-05-21 20:30:00 | YM | Futures | 37004.6 | 37009.0 | 36985.8 | 37003.5 | 456.0 |
| 2023-05-21 21:00:00 | YM | Futures | 37003.5 | 37006.8 | 36982.5 | 36996.9 | 449.0 |
| 2023-05-21 21:30:00 | YM | Futures | 36995.8 | 36995.8 | 36971.5 | 36982.5 | 411.0 |
| 2023-05-21 22:00:00 | YM | Futures | 36979.2 | 36984.7 | 36967.0 | 36973.7 | 408.0 |
| 2023-05-21 22:30:00 | YM | Futures | 36972.6 | 36983.6 | 36962.6 | 36979.2 | 251.0 |
| 2023-05-21 23:00:00 | YM | Futures | 36980.3 | 36986.9 | 36972.6 | 36983.6 | 280.0 |
| 2023-05-21 23:30:00 | YM | Futures | 36982.5 | 36999.1 | 36980.3 | 36999.1 | 295.0 |
| 2023-05-21 18:00:00 | CL | Futures | 58.47 | 58.55 | 58.34 | 58.44 | 885.0 |
| 2023-05-21 18:30:00 | CL | Futures | 58.44 | 58.45 | 58.31 | 58.33 | 500.0 |
| 2023-05-21 19:00:00 | CL | Futures | 58.33 | 58.39 | 58.31 | 58.34 | 301.0 |
| 2023-05-21 19:30:00 | CL | Futures | 58.33 | 58.44 | 58.32 | 58.44 | 366.0 |
| 2023-05-21 20:00:00 | CL | Futures | 58.44 | 58.48 | 58.36 | 58.4 | 556.0 |
| 2023-05-21 20:30:00 | CL | Futures | 58.41 | 58.43 | 58.35 | 58.4 | 402.0 |
| 2023-05-21 21:00:00 | CL | Futures | 58.4 | 58.5 | 58.02 | 58.11 | 4083.0 |
| 2023-05-21 21:30:00 | CL | Futures | 58.11 | 58.13 | 57.83 | 57.94 | 4027.0 |
| 2023-05-21 22:00:00 | CL | Futures | 57.93 | 57.98 | 57.85 | 57.98 | 1463.0 |
| 2023-05-21 22:30:00 | CL | Futures | 57.98 | 58.03 | 57.87 | 57.88 | 1475.0 |
| 2023-05-21 23:00:00 | CL | Futures | 57.88 | 57.93 | 57.77 | 57.83 | 1619.0 |
| 2023-05-21 23:30:00 | CL | Futures | 57.83 | 57.87 | 57.68 | 57.74 | 1642.0 |
| 2023-05-21 18:00:00 | GC | Futures | 2276.3 | 2280.6 | 2276.3 | 2279.6 | 1580.0 |
| 2023-05-21 18:30:00 | GC | Futures | 2279.5 | 2280.9 | 2279.4 | 2279.5 | 350.0 |
> showing 50 of 742 rows — these rows as CSV