PREVIEW / futures_30min / 2024-04-28
file: by_date/futures_30min/2024/2024-04-28.parquet size: 29 KB rows: 817
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-04-28 18:00:00 | ES | Futures | 5454.75 | 5455.54 | 5449.17 | 5452.62 | 5613.0 |
| 2024-04-28 18:30:00 | ES | Futures | 5452.62 | 5452.89 | 5449.97 | 5451.03 | 2092.0 |
| 2024-04-28 19:00:00 | ES | Futures | 5451.3 | 5452.36 | 5450.24 | 5451.83 | 1361.0 |
| 2024-04-28 19:30:00 | ES | Futures | 5451.83 | 5456.34 | 5451.56 | 5456.34 | 3225.0 |
| 2024-04-28 20:00:00 | ES | Futures | 5456.34 | 5457.66 | 5453.15 | 5454.21 | 4754.0 |
| 2024-04-28 20:30:00 | ES | Futures | 5454.48 | 5457.66 | 5454.21 | 5456.6 | 2058.0 |
| 2024-04-28 21:00:00 | ES | Futures | 5456.6 | 5459.26 | 5455.81 | 5458.19 | 2682.0 |
| 2024-04-28 21:30:00 | ES | Futures | 5458.19 | 5461.91 | 5457.13 | 5460.85 | 3793.0 |
| 2024-04-28 22:00:00 | ES | Futures | 5460.85 | 5461.38 | 5457.4 | 5457.93 | 3189.0 |
| 2024-04-28 22:30:00 | ES | Futures | 5458.19 | 5460.58 | 5457.93 | 5459.26 | 2096.0 |
| 2024-04-28 23:00:00 | ES | Futures | 5459.26 | 5460.32 | 5458.46 | 5459.26 | 1546.0 |
| 2024-04-28 23:30:00 | ES | Futures | 5458.99 | 5459.79 | 5458.19 | 5458.46 | 1353.0 |
| 2024-04-28 18:00:00 | NQ | Futures | 19115.57 | 19131.89 | 19103.27 | 19114.23 | 2865.0 |
| 2024-04-28 18:30:00 | NQ | Futures | 19114.77 | 19115.84 | 19103.27 | 19109.42 | 1131.0 |
| 2024-04-28 19:00:00 | NQ | Futures | 19110.22 | 19119.05 | 19103.53 | 19116.64 | 1494.0 |
| 2024-04-28 19:30:00 | NQ | Futures | 19116.11 | 19142.59 | 19113.16 | 19138.84 | 2740.0 |
| 2024-04-28 20:00:00 | NQ | Futures | 19138.84 | 19147.94 | 19126.0 | 19130.28 | 2368.0 |
| 2024-04-28 20:30:00 | NQ | Futures | 19130.82 | 19141.52 | 19129.48 | 19136.7 | 1408.0 |
| 2024-04-28 21:00:00 | NQ | Futures | 19136.7 | 19142.86 | 19129.21 | 19142.05 | 1926.0 |
| 2024-04-28 21:30:00 | NQ | Futures | 19141.52 | 19167.2 | 19138.58 | 19160.51 | 2807.0 |
| 2024-04-28 22:00:00 | NQ | Futures | 19160.78 | 19163.99 | 19146.6 | 19150.88 | 2367.0 |
| 2024-04-28 22:30:00 | NQ | Futures | 19151.42 | 19161.58 | 19149.28 | 19155.43 | 1316.0 |
| 2024-04-28 23:00:00 | NQ | Futures | 19155.43 | 19161.58 | 19151.95 | 19157.57 | 818.0 |
| 2024-04-28 23:30:00 | NQ | Futures | 19157.3 | 19160.78 | 19152.49 | 19154.09 | 799.0 |
| 2024-04-28 18:00:00 | YM | Futures | 40864.9 | 40876.6 | 40847.9 | 40873.4 | 596.0 |
| 2024-04-28 18:30:00 | YM | Futures | 40874.5 | 40875.5 | 40855.4 | 40862.8 | 167.0 |
| 2024-04-28 19:00:00 | YM | Futures | 40863.9 | 40868.1 | 40855.4 | 40866.0 | 173.0 |
| 2024-04-28 19:30:00 | YM | Futures | 40867.0 | 40905.3 | 40864.9 | 40905.3 | 519.0 |
| 2024-04-28 20:00:00 | YM | Futures | 40906.3 | 40919.1 | 40887.2 | 40895.7 | 646.0 |
| 2024-04-28 20:30:00 | YM | Futures | 40896.8 | 40926.5 | 40895.7 | 40921.2 | 200.0 |
| 2024-04-28 21:00:00 | YM | Futures | 40921.2 | 40936.1 | 40915.9 | 40924.4 | 499.0 |
| 2024-04-28 21:30:00 | YM | Futures | 40926.5 | 40946.7 | 40922.3 | 40945.6 | 555.0 |
| 2024-04-28 22:00:00 | YM | Futures | 40944.6 | 40944.6 | 40923.3 | 40925.4 | 427.0 |
| 2024-04-28 22:30:00 | YM | Futures | 40927.6 | 40938.2 | 40925.4 | 40928.6 | 304.0 |
| 2024-04-28 23:00:00 | YM | Futures | 40929.7 | 40932.9 | 40923.3 | 40924.4 | 211.0 |
| 2024-04-28 23:30:00 | YM | Futures | 40925.4 | 40927.6 | 40918.0 | 40920.1 | 148.0 |
| 2024-04-28 18:00:00 | CL | Futures | 70.8 | 70.8 | 70.55 | 70.62 | 1558.0 |
| 2024-04-28 18:30:00 | CL | Futures | 70.63 | 70.65 | 70.58 | 70.6 | 678.0 |
| 2024-04-28 19:00:00 | CL | Futures | 70.61 | 70.64 | 70.49 | 70.51 | 973.0 |
| 2024-04-28 19:30:00 | CL | Futures | 70.51 | 70.53 | 70.38 | 70.39 | 983.0 |
| 2024-04-28 20:00:00 | CL | Futures | 70.41 | 70.48 | 70.36 | 70.37 | 1522.0 |
| 2024-04-28 20:30:00 | CL | Futures | 70.37 | 70.45 | 70.36 | 70.45 | 1138.0 |
| 2024-04-28 21:00:00 | CL | Futures | 70.45 | 70.45 | 70.18 | 70.26 | 4110.0 |
| 2024-04-28 21:30:00 | CL | Futures | 70.26 | 70.28 | 70.18 | 70.27 | 1532.0 |
| 2024-04-28 22:00:00 | CL | Futures | 70.27 | 70.35 | 70.24 | 70.34 | 1382.0 |
| 2024-04-28 22:30:00 | CL | Futures | 70.35 | 70.39 | 70.29 | 70.33 | 954.0 |
| 2024-04-28 23:00:00 | CL | Futures | 70.33 | 70.37 | 70.32 | 70.32 | 637.0 |
| 2024-04-28 23:30:00 | CL | Futures | 70.33 | 70.37 | 70.32 | 70.37 | 549.0 |
| 2024-04-28 18:00:00 | GC | Futures | 2547.5 | 2549.0 | 2543.6 | 2546.4 | 1610.0 |
| 2024-04-28 18:30:00 | GC | Futures | 2546.4 | 2547.5 | 2545.1 | 2545.9 | 3278.0 |
> showing 50 of 817 rows — these rows as CSV