PREVIEW / futures_1hour / 2024-04-28
file: by_date/futures_1hour/2024/2024-04-28.parquet size: 20 KB rows: 431
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 | 5451.03 | 7705.0 |
| 2024-04-28 19:00:00 | ES | Futures | 5451.3 | 5456.34 | 5450.24 | 5456.34 | 4586.0 |
| 2024-04-28 20:00:00 | ES | Futures | 5456.34 | 5457.66 | 5453.15 | 5456.6 | 6812.0 |
| 2024-04-28 21:00:00 | ES | Futures | 5456.6 | 5461.91 | 5455.81 | 5460.85 | 6475.0 |
| 2024-04-28 22:00:00 | ES | Futures | 5460.85 | 5461.38 | 5457.4 | 5459.26 | 5285.0 |
| 2024-04-28 23:00:00 | ES | Futures | 5459.26 | 5460.32 | 5458.19 | 5458.46 | 2899.0 |
| 2024-04-28 18:00:00 | NQ | Futures | 19115.57 | 19131.89 | 19103.27 | 19109.42 | 3996.0 |
| 2024-04-28 19:00:00 | NQ | Futures | 19110.22 | 19142.59 | 19103.53 | 19138.84 | 4234.0 |
| 2024-04-28 20:00:00 | NQ | Futures | 19138.84 | 19147.94 | 19126.0 | 19136.7 | 3776.0 |
| 2024-04-28 21:00:00 | NQ | Futures | 19136.7 | 19167.2 | 19129.21 | 19160.51 | 4733.0 |
| 2024-04-28 22:00:00 | NQ | Futures | 19160.78 | 19163.99 | 19146.6 | 19155.43 | 3683.0 |
| 2024-04-28 23:00:00 | NQ | Futures | 19155.43 | 19161.58 | 19151.95 | 19154.09 | 1617.0 |
| 2024-04-28 18:00:00 | YM | Futures | 40864.9 | 40876.6 | 40847.9 | 40862.8 | 763.0 |
| 2024-04-28 19:00:00 | YM | Futures | 40863.9 | 40905.3 | 40855.4 | 40905.3 | 692.0 |
| 2024-04-28 20:00:00 | YM | Futures | 40906.3 | 40926.5 | 40887.2 | 40921.2 | 846.0 |
| 2024-04-28 21:00:00 | YM | Futures | 40921.2 | 40946.7 | 40915.9 | 40945.6 | 1054.0 |
| 2024-04-28 22:00:00 | YM | Futures | 40944.6 | 40944.6 | 40923.3 | 40928.6 | 731.0 |
| 2024-04-28 23:00:00 | YM | Futures | 40929.7 | 40932.9 | 40918.0 | 40920.1 | 359.0 |
| 2024-04-28 18:00:00 | CL | Futures | 70.8 | 70.8 | 70.55 | 70.6 | 2236.0 |
| 2024-04-28 19:00:00 | CL | Futures | 70.61 | 70.64 | 70.38 | 70.39 | 1956.0 |
| 2024-04-28 20:00:00 | CL | Futures | 70.41 | 70.48 | 70.36 | 70.45 | 2660.0 |
| 2024-04-28 21:00:00 | CL | Futures | 70.45 | 70.45 | 70.18 | 70.27 | 5642.0 |
| 2024-04-28 22:00:00 | CL | Futures | 70.27 | 70.39 | 70.24 | 70.33 | 2336.0 |
| 2024-04-28 23:00:00 | CL | Futures | 70.33 | 70.37 | 70.32 | 70.37 | 1186.0 |
| 2024-04-28 18:00:00 | GC | Futures | 2547.5 | 2549.0 | 2543.6 | 2545.9 | 4888.0 |
| 2024-04-28 19:00:00 | GC | Futures | 2545.9 | 2548.4 | 2545.6 | 2547.3 | 1147.0 |
| 2024-04-28 20:00:00 | GC | Futures | 2547.4 | 2547.7 | 2541.7 | 2543.3 | 5169.0 |
| 2024-04-28 21:00:00 | GC | Futures | 2543.1 | 2543.1 | 2529.5 | 2541.9 | 10787.0 |
| 2024-04-28 22:00:00 | GC | Futures | 2541.7 | 2542.4 | 2534.2 | 2534.4 | 3507.0 |
| 2024-04-28 23:00:00 | GC | Futures | 2534.3 | 2539.7 | 2533.7 | 2538.7 | 2541.0 |
| 2024-04-28 18:00:00 | ZN | Futures | 108.419161 | 108.545138 | 108.419161 | 108.529391 | 6419.0 |
| 2024-04-28 19:00:00 | ZN | Futures | 108.513644 | 108.576633 | 108.497897 | 108.560885 | 7472.0 |
| 2024-04-28 20:00:00 | ZN | Futures | 108.545138 | 108.576633 | 108.513644 | 108.513644 | 8633.0 |
| 2024-04-28 21:00:00 | ZN | Futures | 108.513644 | 108.513644 | 108.419161 | 108.450655 | 15208.0 |
| 2024-04-28 22:00:00 | ZN | Futures | 108.450655 | 108.497897 | 108.450655 | 108.48215 | 6374.0 |
| 2024-04-28 23:00:00 | ZN | Futures | 108.466402 | 108.497897 | 108.466402 | 108.48215 | 3228.0 |
> showing 36 of 431 rows — these rows as CSV