PREVIEW / futures_30min / 2023-04-02
file: by_date/futures_30min/2023/2023-04-02.parquet size: 30 KB rows: 820
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-04-02 18:00:00 | ES | Futures | 4578.55 | 4586.04 | 4576.61 | 4579.94 | 12938.0 |
| 2023-04-02 18:30:00 | ES | Futures | 4579.94 | 4587.43 | 4578.27 | 4586.32 | 6361.0 |
| 2023-04-02 19:00:00 | ES | Futures | 4586.32 | 4587.43 | 4583.54 | 4585.76 | 3022.0 |
| 2023-04-02 19:30:00 | ES | Futures | 4585.76 | 4587.43 | 4581.05 | 4583.26 | 5966.0 |
| 2023-04-02 20:00:00 | ES | Futures | 4582.99 | 4583.26 | 4573.83 | 4579.66 | 12732.0 |
| 2023-04-02 20:30:00 | ES | Futures | 4579.66 | 4582.99 | 4578.83 | 4581.32 | 6314.0 |
| 2023-04-02 21:00:00 | ES | Futures | 4581.32 | 4583.82 | 4577.44 | 4581.32 | 5672.0 |
| 2023-04-02 21:30:00 | ES | Futures | 4581.32 | 4582.71 | 4574.39 | 4576.33 | 6831.0 |
| 2023-04-02 22:00:00 | ES | Futures | 4576.05 | 4578.0 | 4574.67 | 4576.61 | 3893.0 |
| 2023-04-02 22:30:00 | ES | Futures | 4576.61 | 4577.72 | 4574.94 | 4576.33 | 3029.0 |
| 2023-04-02 23:00:00 | ES | Futures | 4576.33 | 4579.94 | 4576.33 | 4578.55 | 2578.0 |
| 2023-04-02 23:30:00 | ES | Futures | 4578.27 | 4578.27 | 4574.67 | 4575.78 | 3233.0 |
| 2023-04-02 18:00:00 | NQ | Futures | 14935.82 | 14951.03 | 14905.42 | 14917.81 | 7999.0 |
| 2023-04-02 18:30:00 | NQ | Futures | 14918.09 | 14939.2 | 14909.64 | 14931.88 | 3168.0 |
| 2023-04-02 19:00:00 | NQ | Futures | 14931.32 | 14936.95 | 14922.87 | 14924.56 | 1694.0 |
| 2023-04-02 19:30:00 | NQ | Futures | 14925.13 | 14931.6 | 14907.39 | 14910.77 | 2194.0 |
| 2023-04-02 20:00:00 | NQ | Futures | 14910.77 | 14911.33 | 14866.0 | 14886.83 | 6272.0 |
| 2023-04-02 20:30:00 | NQ | Futures | 14886.55 | 14896.97 | 14882.61 | 14892.75 | 2925.0 |
| 2023-04-02 21:00:00 | NQ | Futures | 14892.47 | 14907.11 | 14884.58 | 14898.1 | 2593.0 |
| 2023-04-02 21:30:00 | NQ | Futures | 14897.81 | 14903.45 | 14866.56 | 14880.64 | 3878.0 |
| 2023-04-02 22:00:00 | NQ | Futures | 14880.36 | 14888.24 | 14872.19 | 14882.89 | 1668.0 |
| 2023-04-02 22:30:00 | NQ | Futures | 14882.61 | 14885.71 | 14876.98 | 14881.2 | 1179.0 |
| 2023-04-02 23:00:00 | NQ | Futures | 14881.2 | 14899.22 | 14880.36 | 14895.28 | 1729.0 |
| 2023-04-02 23:30:00 | NQ | Futures | 14894.72 | 14894.72 | 14880.36 | 14884.02 | 1482.0 |
| 2023-04-02 18:00:00 | YM | Futures | 36962.6 | 37026.7 | 36957.1 | 36975.9 | 2241.0 |
| 2023-04-02 18:30:00 | YM | Futures | 36977.0 | 37042.2 | 36969.2 | 37032.3 | 849.0 |
| 2023-04-02 19:00:00 | YM | Futures | 37032.3 | 37038.9 | 37016.8 | 37033.4 | 341.0 |
| 2023-04-02 19:30:00 | YM | Futures | 37033.4 | 37042.2 | 37005.7 | 37019.0 | 827.0 |
| 2023-04-02 20:00:00 | YM | Futures | 37017.9 | 37020.1 | 36963.7 | 37005.7 | 1466.0 |
| 2023-04-02 20:30:00 | YM | Futures | 37003.5 | 37033.4 | 37003.5 | 37028.9 | 1105.0 |
| 2023-04-02 21:00:00 | YM | Futures | 37028.9 | 37041.1 | 36993.6 | 37021.2 | 702.0 |
| 2023-04-02 21:30:00 | YM | Futures | 37020.1 | 37032.3 | 36980.3 | 36986.9 | 646.0 |
| 2023-04-02 22:00:00 | YM | Futures | 36985.8 | 37000.2 | 36978.1 | 36992.5 | 470.0 |
| 2023-04-02 22:30:00 | YM | Futures | 36991.4 | 36999.1 | 36980.3 | 36989.1 | 348.0 |
| 2023-04-02 23:00:00 | YM | Futures | 36990.3 | 37006.8 | 36988.0 | 36996.9 | 448.0 |
| 2023-04-02 23:30:00 | YM | Futures | 36995.8 | 36995.8 | 36973.7 | 36978.1 | 441.0 |
| 2023-04-02 18:00:00 | CL | Futures | 64.96 | 66.25 | 64.72 | 65.75 | 27258.0 |
| 2023-04-02 18:30:00 | CL | Futures | 65.76 | 66.12 | 65.6 | 65.67 | 7061.0 |
| 2023-04-02 19:00:00 | CL | Futures | 65.67 | 65.71 | 65.34 | 65.57 | 6186.0 |
| 2023-04-02 19:30:00 | CL | Futures | 65.57 | 65.65 | 65.26 | 65.29 | 2690.0 |
| 2023-04-02 20:00:00 | CL | Futures | 65.3 | 65.32 | 64.97 | 65.12 | 4775.0 |
| 2023-04-02 20:30:00 | CL | Futures | 65.1 | 65.33 | 64.94 | 65.02 | 3881.0 |
| 2023-04-02 21:00:00 | CL | Futures | 65.02 | 65.02 | 64.48 | 64.53 | 10610.0 |
| 2023-04-02 21:30:00 | CL | Futures | 64.54 | 64.81 | 64.49 | 64.77 | 4029.0 |
| 2023-04-02 22:00:00 | CL | Futures | 64.78 | 64.86 | 64.72 | 64.81 | 2260.0 |
| 2023-04-02 22:30:00 | CL | Futures | 64.81 | 64.86 | 64.53 | 64.61 | 2442.0 |
| 2023-04-02 23:00:00 | CL | Futures | 64.61 | 64.81 | 64.61 | 64.75 | 1838.0 |
| 2023-04-02 23:30:00 | CL | Futures | 64.75 | 64.84 | 64.72 | 64.79 | 1071.0 |
| 2023-04-02 18:00:00 | GC | Futures | 2288.5 | 2290.8 | 2273.6 | 2278.0 | 4443.0 |
| 2023-04-02 18:30:00 | GC | Futures | 2278.0 | 2278.8 | 2274.7 | 2276.4 | 1391.0 |
> showing 50 of 820 rows — these rows as CSV