PREVIEW / futures_30min / 2024-11-03
file: by_date/futures_30min/2024/2024-11-03.parquet size: 32 KB rows: 880
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-03 18:00:00 | ES | Futures | 5960.47 | 5973.45 | 5958.66 | 5972.67 | 15500.0 |
| 2024-11-03 18:30:00 | ES | Futures | 5972.67 | 5975.01 | 5968.78 | 5968.78 | 6152.0 |
| 2024-11-03 19:00:00 | ES | Futures | 5969.04 | 5969.3 | 5962.55 | 5965.92 | 5986.0 |
| 2024-11-03 19:30:00 | ES | Futures | 5966.18 | 5969.56 | 5964.37 | 5968.26 | 2590.0 |
| 2024-11-03 20:00:00 | ES | Futures | 5968.52 | 5974.23 | 5966.96 | 5972.41 | 3759.0 |
| 2024-11-03 20:30:00 | ES | Futures | 5972.67 | 5980.98 | 5972.67 | 5978.64 | 5037.0 |
| 2024-11-03 21:00:00 | ES | Futures | 5978.9 | 5987.2 | 5978.12 | 5986.69 | 6089.0 |
| 2024-11-03 21:30:00 | ES | Futures | 5986.95 | 5991.36 | 5984.35 | 5985.65 | 5438.0 |
| 2024-11-03 22:00:00 | ES | Futures | 5985.39 | 5990.32 | 5984.87 | 5990.32 | 2800.0 |
| 2024-11-03 22:30:00 | ES | Futures | 5990.32 | 5991.1 | 5987.2 | 5989.02 | 2263.0 |
| 2024-11-03 23:00:00 | ES | Futures | 5988.76 | 5992.14 | 5988.24 | 5991.88 | 2448.0 |
| 2024-11-03 23:30:00 | ES | Futures | 5991.88 | 5994.73 | 5990.06 | 5992.91 | 2692.0 |
| 2024-11-03 18:00:00 | NQ | Futures | 21017.01 | 21018.84 | 20946.56 | 21015.97 | 8190.0 |
| 2024-11-03 18:30:00 | NQ | Futures | 21017.01 | 21037.88 | 21013.36 | 21013.88 | 7800.0 |
| 2024-11-03 19:00:00 | NQ | Futures | 21013.88 | 21025.1 | 20996.92 | 21016.75 | 3574.0 |
| 2024-11-03 19:30:00 | NQ | Futures | 21015.7 | 21016.23 | 20999.27 | 21008.66 | 1754.0 |
| 2024-11-03 20:00:00 | NQ | Futures | 21008.66 | 21036.06 | 21002.66 | 21026.66 | 1856.0 |
| 2024-11-03 20:30:00 | NQ | Futures | 21027.18 | 21081.72 | 21025.62 | 21072.32 | 3739.0 |
| 2024-11-03 21:00:00 | NQ | Futures | 21072.32 | 21112.5 | 21064.76 | 21109.63 | 3338.0 |
| 2024-11-03 21:30:00 | NQ | Futures | 21110.42 | 21132.33 | 21087.19 | 21093.72 | 2717.0 |
| 2024-11-03 22:00:00 | NQ | Futures | 21093.98 | 21113.55 | 21087.98 | 21112.76 | 1643.0 |
| 2024-11-03 22:30:00 | NQ | Futures | 21112.76 | 21116.68 | 21095.8 | 21101.54 | 2103.0 |
| 2024-11-03 23:00:00 | NQ | Futures | 21101.54 | 21111.46 | 21097.89 | 21110.42 | 1012.0 |
| 2024-11-03 23:30:00 | NQ | Futures | 21110.94 | 21124.77 | 21102.59 | 21117.2 | 1536.0 |
| 2024-11-03 18:00:00 | YM | Futures | 43867.7 | 43883.3 | 43777.2 | 43834.4 | 1574.0 |
| 2024-11-03 18:30:00 | YM | Futures | 43835.4 | 43841.7 | 43798.0 | 43799.0 | 717.0 |
| 2024-11-03 19:00:00 | YM | Futures | 43800.1 | 43803.2 | 43756.3 | 43770.9 | 885.0 |
| 2024-11-03 19:30:00 | YM | Futures | 43772.0 | 43787.6 | 43758.4 | 43777.2 | 440.0 |
| 2024-11-03 20:00:00 | YM | Futures | 43778.2 | 43813.6 | 43769.9 | 43806.3 | 542.0 |
| 2024-11-03 20:30:00 | YM | Futures | 43807.3 | 43834.4 | 43802.1 | 43823.0 | 588.0 |
| 2024-11-03 21:00:00 | YM | Futures | 43825.0 | 43863.5 | 43812.5 | 43862.5 | 704.0 |
| 2024-11-03 21:30:00 | YM | Futures | 43863.5 | 43886.4 | 43851.1 | 43857.3 | 529.0 |
| 2024-11-03 22:00:00 | YM | Futures | 43857.3 | 43880.2 | 43854.2 | 43880.2 | 318.0 |
| 2024-11-03 22:30:00 | YM | Futures | 43882.3 | 43884.4 | 43868.8 | 43879.2 | 272.0 |
| 2024-11-03 23:00:00 | YM | Futures | 43878.1 | 43903.1 | 43875.0 | 43902.1 | 393.0 |
| 2024-11-03 23:30:00 | YM | Futures | 43901.0 | 43927.0 | 43894.8 | 43908.3 | 368.0 |
| 2024-11-03 18:00:00 | CL | Futures | 63.61 | 64.26 | 63.58 | 63.84 | 5880.0 |
| 2024-11-03 18:30:00 | CL | Futures | 63.84 | 63.85 | 63.73 | 63.83 | 1095.0 |
| 2024-11-03 19:00:00 | CL | Futures | 63.83 | 63.94 | 63.79 | 63.94 | 747.0 |
| 2024-11-03 19:30:00 | CL | Futures | 63.94 | 64.1 | 63.92 | 64.01 | 1542.0 |
| 2024-11-03 20:00:00 | CL | Futures | 64.0 | 64.06 | 63.87 | 63.89 | 1690.0 |
| 2024-11-03 20:30:00 | CL | Futures | 63.9 | 63.91 | 63.75 | 63.79 | 1146.0 |
| 2024-11-03 21:00:00 | CL | Futures | 63.79 | 63.9 | 63.75 | 63.89 | 879.0 |
| 2024-11-03 21:30:00 | CL | Futures | 63.9 | 63.91 | 63.68 | 63.74 | 1276.0 |
| 2024-11-03 22:00:00 | CL | Futures | 63.74 | 63.88 | 63.7 | 63.87 | 804.0 |
| 2024-11-03 22:30:00 | CL | Futures | 63.87 | 63.99 | 63.84 | 63.99 | 815.0 |
| 2024-11-03 23:00:00 | CL | Futures | 63.98 | 64.04 | 63.96 | 63.98 | 536.0 |
| 2024-11-03 23:30:00 | CL | Futures | 63.98 | 63.98 | 63.94 | 63.95 | 347.0 |
| 2024-11-03 18:00:00 | GC | Futures | 2888.8 | 2894.6 | 2884.5 | 2893.9 | 4282.0 |
| 2024-11-03 18:30:00 | GC | Futures | 2893.9 | 2895.1 | 2892.4 | 2892.9 | 815.0 |
> showing 50 of 880 rows — these rows as CSV