PREVIEW / futures_30min / 2024-06-02
file: by_date/futures_30min/2024/2024-06-02.parquet size: 30 KB rows: 822
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-06-02 18:00:00 | ES | Futures | 5623.74 | 5628.78 | 5613.92 | 5622.68 | 11456.0 |
| 2024-06-02 18:30:00 | ES | Futures | 5622.68 | 5623.47 | 5619.23 | 5620.82 | 3222.0 |
| 2024-06-02 19:00:00 | ES | Futures | 5620.55 | 5626.39 | 5619.76 | 5625.33 | 4321.0 |
| 2024-06-02 19:30:00 | ES | Futures | 5625.6 | 5628.51 | 5623.21 | 5626.66 | 5571.0 |
| 2024-06-02 20:00:00 | ES | Futures | 5626.39 | 5635.94 | 5626.13 | 5635.68 | 10969.0 |
| 2024-06-02 20:30:00 | ES | Futures | 5635.41 | 5635.68 | 5631.7 | 5631.96 | 3940.0 |
| 2024-06-02 21:00:00 | ES | Futures | 5631.96 | 5634.35 | 5627.98 | 5629.04 | 4629.0 |
| 2024-06-02 21:30:00 | ES | Futures | 5629.31 | 5631.17 | 5626.92 | 5629.31 | 4611.0 |
| 2024-06-02 22:00:00 | ES | Futures | 5629.31 | 5633.02 | 5629.31 | 5632.49 | 3395.0 |
| 2024-06-02 22:30:00 | ES | Futures | 5632.76 | 5633.55 | 5630.9 | 5633.02 | 1946.0 |
| 2024-06-02 23:00:00 | ES | Futures | 5633.02 | 5634.62 | 5631.43 | 5631.96 | 2887.0 |
| 2024-06-02 23:30:00 | ES | Futures | 5631.96 | 5633.29 | 5630.64 | 5632.49 | 2682.0 |
| 2024-06-02 18:00:00 | NQ | Futures | 19891.87 | 19900.69 | 19837.3 | 19873.68 | 6078.0 |
| 2024-06-02 18:30:00 | NQ | Futures | 19872.87 | 19876.35 | 19859.5 | 19867.52 | 1689.0 |
| 2024-06-02 19:00:00 | NQ | Futures | 19866.99 | 19901.23 | 19862.44 | 19897.22 | 2365.0 |
| 2024-06-02 19:30:00 | NQ | Futures | 19897.22 | 19900.43 | 19881.17 | 19893.74 | 1791.0 |
| 2024-06-02 20:00:00 | NQ | Futures | 19893.47 | 19950.45 | 19892.67 | 19948.31 | 5339.0 |
| 2024-06-02 20:30:00 | NQ | Futures | 19948.58 | 19949.38 | 19934.94 | 19937.34 | 2453.0 |
| 2024-06-02 21:00:00 | NQ | Futures | 19937.61 | 19948.31 | 19920.76 | 19926.11 | 2586.0 |
| 2024-06-02 21:30:00 | NQ | Futures | 19927.18 | 19938.15 | 19920.22 | 19932.26 | 1827.0 |
| 2024-06-02 22:00:00 | NQ | Futures | 19932.53 | 19952.32 | 19931.73 | 19948.58 | 1972.0 |
| 2024-06-02 22:30:00 | NQ | Futures | 19948.31 | 19954.2 | 19942.16 | 19950.18 | 1440.0 |
| 2024-06-02 23:00:00 | NQ | Futures | 19950.45 | 19959.55 | 19944.57 | 19944.83 | 1744.0 |
| 2024-06-02 23:30:00 | NQ | Futures | 19945.1 | 19951.52 | 19940.82 | 19947.51 | 1091.0 |
| 2024-06-02 18:00:00 | YM | Futures | 41219.5 | 41251.4 | 41161.1 | 41217.4 | 1710.0 |
| 2024-06-02 18:30:00 | YM | Futures | 41216.3 | 41225.9 | 41202.5 | 41211.0 | 553.0 |
| 2024-06-02 19:00:00 | YM | Futures | 41210.0 | 41233.3 | 41204.7 | 41228.0 | 685.0 |
| 2024-06-02 19:30:00 | YM | Futures | 41228.0 | 41254.6 | 41216.3 | 41240.8 | 525.0 |
| 2024-06-02 20:00:00 | YM | Futures | 41240.8 | 41300.2 | 41239.7 | 41299.2 | 1468.0 |
| 2024-06-02 20:30:00 | YM | Futures | 41298.1 | 41298.1 | 41273.7 | 41285.4 | 553.0 |
| 2024-06-02 21:00:00 | YM | Futures | 41285.4 | 41298.1 | 41266.2 | 41272.6 | 767.0 |
| 2024-06-02 21:30:00 | YM | Futures | 41272.6 | 41274.7 | 41254.6 | 41265.2 | 643.0 |
| 2024-06-02 22:00:00 | YM | Futures | 41266.2 | 41291.7 | 41263.1 | 41283.2 | 574.0 |
| 2024-06-02 22:30:00 | YM | Futures | 41283.2 | 41287.5 | 41274.7 | 41287.5 | 437.0 |
| 2024-06-02 23:00:00 | YM | Futures | 41287.5 | 41298.1 | 41280.0 | 41282.2 | 419.0 |
| 2024-06-02 23:30:00 | YM | Futures | 41282.2 | 41286.4 | 41273.7 | 41282.2 | 362.0 |
| 2024-06-02 18:00:00 | CL | Futures | 65.53 | 65.66 | 65.04 | 65.35 | 5009.0 |
| 2024-06-02 18:30:00 | CL | Futures | 65.36 | 65.43 | 65.25 | 65.3 | 1423.0 |
| 2024-06-02 19:00:00 | CL | Futures | 65.3 | 65.37 | 65.21 | 65.24 | 728.0 |
| 2024-06-02 19:30:00 | CL | Futures | 65.24 | 65.38 | 65.24 | 65.36 | 634.0 |
| 2024-06-02 20:00:00 | CL | Futures | 65.37 | 65.42 | 65.3 | 65.39 | 1123.0 |
| 2024-06-02 20:30:00 | CL | Futures | 65.39 | 65.59 | 65.37 | 65.58 | 1081.0 |
| 2024-06-02 21:00:00 | CL | Futures | 65.59 | 65.95 | 65.57 | 65.9 | 4128.0 |
| 2024-06-02 21:30:00 | CL | Futures | 65.9 | 65.99 | 65.79 | 65.86 | 1248.0 |
| 2024-06-02 22:00:00 | CL | Futures | 65.87 | 65.99 | 65.85 | 65.96 | 911.0 |
| 2024-06-02 22:30:00 | CL | Futures | 65.96 | 66.0 | 65.85 | 65.86 | 771.0 |
| 2024-06-02 23:00:00 | CL | Futures | 65.86 | 65.86 | 65.5 | 65.5 | 1415.0 |
| 2024-06-02 23:30:00 | CL | Futures | 65.51 | 65.59 | 65.51 | 65.52 | 790.0 |
| 2024-06-02 18:00:00 | GC | Futures | 2521.4 | 2523.3 | 2516.6 | 2516.6 | 3106.0 |
| 2024-06-02 18:30:00 | GC | Futures | 2516.7 | 2520.4 | 2516.7 | 2519.9 | 899.0 |
> showing 50 of 822 rows — these rows as CSV