PREVIEW / futures_30min / 2024-09-22
file: by_date/futures_30min/2024/2024-09-22.parquet size: 29 KB rows: 824
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-09-22 18:00:00 | ES | Futures | 5981.5 | 5984.09 | 5974.75 | 5980.98 | 4118.0 |
| 2024-09-22 18:30:00 | ES | Futures | 5981.24 | 5983.31 | 5979.94 | 5982.53 | 2321.0 |
| 2024-09-22 19:00:00 | ES | Futures | 5982.27 | 5983.31 | 5979.94 | 5981.24 | 1259.0 |
| 2024-09-22 19:30:00 | ES | Futures | 5981.24 | 5987.46 | 5981.24 | 5986.95 | 2336.0 |
| 2024-09-22 20:00:00 | ES | Futures | 5986.95 | 5990.58 | 5985.39 | 5990.58 | 3711.0 |
| 2024-09-22 20:30:00 | ES | Futures | 5990.58 | 5998.62 | 5990.58 | 5997.85 | 7771.0 |
| 2024-09-22 21:00:00 | ES | Futures | 5997.85 | 5999.4 | 5996.29 | 5997.85 | 4701.0 |
| 2024-09-22 21:30:00 | ES | Futures | 5998.1 | 6001.22 | 5997.33 | 5998.1 | 4107.0 |
| 2024-09-22 22:00:00 | ES | Futures | 5998.1 | 6000.96 | 5996.55 | 6000.18 | 2804.0 |
| 2024-09-22 22:30:00 | ES | Futures | 6000.18 | 6001.22 | 5998.1 | 5999.92 | 2246.0 |
| 2024-09-22 23:00:00 | ES | Futures | 5999.92 | 6002.0 | 5999.66 | 6000.7 | 1716.0 |
| 2024-09-22 23:30:00 | ES | Futures | 6000.96 | 6001.74 | 5998.62 | 5999.4 | 2394.0 |
| 2024-09-22 18:00:00 | NQ | Futures | 20914.73 | 20924.12 | 20869.07 | 20906.12 | 2830.0 |
| 2024-09-22 18:30:00 | NQ | Futures | 20905.34 | 20918.91 | 20897.51 | 20911.6 | 1486.0 |
| 2024-09-22 19:00:00 | NQ | Futures | 20912.91 | 20916.82 | 20898.82 | 20905.6 | 991.0 |
| 2024-09-22 19:30:00 | NQ | Futures | 20905.34 | 20942.39 | 20904.82 | 20937.95 | 1668.0 |
| 2024-09-22 20:00:00 | NQ | Futures | 20938.74 | 20961.96 | 20930.65 | 20959.87 | 2681.0 |
| 2024-09-22 20:30:00 | NQ | Futures | 20960.91 | 21014.92 | 20960.91 | 21010.75 | 4324.0 |
| 2024-09-22 21:00:00 | NQ | Futures | 21011.01 | 21021.71 | 21004.49 | 21013.88 | 2596.0 |
| 2024-09-22 21:30:00 | NQ | Futures | 21013.88 | 21028.49 | 21004.22 | 21009.7 | 2281.0 |
| 2024-09-22 22:00:00 | NQ | Futures | 21008.92 | 21034.75 | 21004.49 | 21030.84 | 1958.0 |
| 2024-09-22 22:30:00 | NQ | Futures | 21030.05 | 21040.49 | 21018.31 | 21029.27 | 2161.0 |
| 2024-09-22 23:00:00 | NQ | Futures | 21029.27 | 21044.14 | 21025.62 | 21037.62 | 1608.0 |
| 2024-09-22 23:30:00 | NQ | Futures | 21036.84 | 21042.06 | 21022.23 | 21024.84 | 1798.0 |
| 2024-09-22 18:00:00 | YM | Futures | 44206.0 | 44206.0 | 44124.8 | 44150.8 | 769.0 |
| 2024-09-22 18:30:00 | YM | Futures | 44151.8 | 44167.4 | 44147.7 | 44165.4 | 277.0 |
| 2024-09-22 19:00:00 | YM | Futures | 44164.3 | 44172.6 | 44160.2 | 44164.3 | 159.0 |
| 2024-09-22 19:30:00 | YM | Futures | 44167.4 | 44194.5 | 44165.4 | 44192.4 | 221.0 |
| 2024-09-22 20:00:00 | YM | Futures | 44195.5 | 44204.9 | 44179.9 | 44202.8 | 328.0 |
| 2024-09-22 20:30:00 | YM | Futures | 44204.9 | 44242.4 | 44204.9 | 44232.0 | 893.0 |
| 2024-09-22 21:00:00 | YM | Futures | 44230.9 | 44240.3 | 44225.7 | 44234.1 | 359.0 |
| 2024-09-22 21:30:00 | YM | Futures | 44233.0 | 44251.7 | 44232.0 | 44237.2 | 290.0 |
| 2024-09-22 22:00:00 | YM | Futures | 44239.3 | 44249.7 | 44228.9 | 44245.5 | 428.0 |
| 2024-09-22 22:30:00 | YM | Futures | 44245.5 | 44247.6 | 44236.1 | 44243.4 | 266.0 |
| 2024-09-22 23:00:00 | YM | Futures | 44242.4 | 44258.0 | 44241.3 | 44246.5 | 225.0 |
| 2024-09-22 23:30:00 | YM | Futures | 44247.6 | 44251.7 | 44238.2 | 44238.2 | 170.0 |
| 2024-09-22 18:00:00 | CL | Futures | 63.96 | 64.01 | 63.72 | 63.72 | 1474.0 |
| 2024-09-22 18:30:00 | CL | Futures | 63.72 | 63.72 | 63.64 | 63.69 | 616.0 |
| 2024-09-22 19:00:00 | CL | Futures | 63.69 | 63.72 | 63.58 | 63.72 | 688.0 |
| 2024-09-22 19:30:00 | CL | Futures | 63.7 | 63.71 | 63.65 | 63.7 | 381.0 |
| 2024-09-22 20:00:00 | CL | Futures | 63.71 | 63.89 | 63.67 | 63.88 | 906.0 |
| 2024-09-22 20:30:00 | CL | Futures | 63.87 | 63.93 | 63.86 | 63.88 | 670.0 |
| 2024-09-22 21:00:00 | CL | Futures | 63.89 | 64.26 | 63.87 | 63.97 | 2270.0 |
| 2024-09-22 21:30:00 | CL | Futures | 63.96 | 64.24 | 63.95 | 64.19 | 1189.0 |
| 2024-09-22 22:00:00 | CL | Futures | 64.19 | 64.2 | 64.06 | 64.11 | 1007.0 |
| 2024-09-22 22:30:00 | CL | Futures | 64.1 | 64.16 | 64.05 | 64.07 | 567.0 |
| 2024-09-22 23:00:00 | CL | Futures | 64.07 | 64.24 | 64.05 | 64.21 | 700.0 |
| 2024-09-22 23:30:00 | CL | Futures | 64.21 | 64.24 | 64.16 | 64.17 | 348.0 |
| 2024-09-22 18:00:00 | GC | Futures | 2786.4 | 2788.0 | 2783.1 | 2784.6 | 1551.0 |
| 2024-09-22 18:30:00 | GC | Futures | 2784.5 | 2786.0 | 2784.4 | 2785.1 | 549.0 |
> showing 50 of 824 rows — these rows as CSV