PREVIEW / futures_1hour / 2024-09-22
file: by_date/futures_1hour/2024/2024-09-22.parquet size: 19 KB rows: 433
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 | 5982.53 | 6439.0 |
| 2024-09-22 19:00:00 | ES | Futures | 5982.27 | 5987.46 | 5979.94 | 5986.95 | 3595.0 |
| 2024-09-22 20:00:00 | ES | Futures | 5986.95 | 5998.62 | 5985.39 | 5997.85 | 11482.0 |
| 2024-09-22 21:00:00 | ES | Futures | 5997.85 | 6001.22 | 5996.29 | 5998.1 | 8808.0 |
| 2024-09-22 22:00:00 | ES | Futures | 5998.1 | 6001.22 | 5996.55 | 5999.92 | 5050.0 |
| 2024-09-22 23:00:00 | ES | Futures | 5999.92 | 6002.0 | 5998.62 | 5999.4 | 4110.0 |
| 2024-09-22 18:00:00 | NQ | Futures | 20914.73 | 20924.12 | 20869.07 | 20911.6 | 4316.0 |
| 2024-09-22 19:00:00 | NQ | Futures | 20912.91 | 20942.39 | 20898.82 | 20937.95 | 2659.0 |
| 2024-09-22 20:00:00 | NQ | Futures | 20938.74 | 21014.92 | 20930.65 | 21010.75 | 7005.0 |
| 2024-09-22 21:00:00 | NQ | Futures | 21011.01 | 21028.49 | 21004.22 | 21009.7 | 4877.0 |
| 2024-09-22 22:00:00 | NQ | Futures | 21008.92 | 21040.49 | 21004.49 | 21029.27 | 4119.0 |
| 2024-09-22 23:00:00 | NQ | Futures | 21029.27 | 21044.14 | 21022.23 | 21024.84 | 3406.0 |
| 2024-09-22 18:00:00 | YM | Futures | 44206.0 | 44206.0 | 44124.8 | 44165.4 | 1046.0 |
| 2024-09-22 19:00:00 | YM | Futures | 44164.3 | 44194.5 | 44160.2 | 44192.4 | 380.0 |
| 2024-09-22 20:00:00 | YM | Futures | 44195.5 | 44242.4 | 44179.9 | 44232.0 | 1221.0 |
| 2024-09-22 21:00:00 | YM | Futures | 44230.9 | 44251.7 | 44225.7 | 44237.2 | 649.0 |
| 2024-09-22 22:00:00 | YM | Futures | 44239.3 | 44249.7 | 44228.9 | 44243.4 | 694.0 |
| 2024-09-22 23:00:00 | YM | Futures | 44242.4 | 44258.0 | 44238.2 | 44238.2 | 395.0 |
| 2024-09-22 18:00:00 | CL | Futures | 63.96 | 64.01 | 63.64 | 63.69 | 2090.0 |
| 2024-09-22 19:00:00 | CL | Futures | 63.69 | 63.72 | 63.58 | 63.7 | 1069.0 |
| 2024-09-22 20:00:00 | CL | Futures | 63.71 | 63.93 | 63.67 | 63.88 | 1576.0 |
| 2024-09-22 21:00:00 | CL | Futures | 63.89 | 64.26 | 63.87 | 64.19 | 3459.0 |
| 2024-09-22 22:00:00 | CL | Futures | 64.19 | 64.2 | 64.05 | 64.07 | 1574.0 |
| 2024-09-22 23:00:00 | CL | Futures | 64.07 | 64.24 | 64.05 | 64.17 | 1048.0 |
| 2024-09-22 18:00:00 | GC | Futures | 2786.4 | 2788.0 | 2783.1 | 2785.1 | 2100.0 |
| 2024-09-22 19:00:00 | GC | Futures | 2785.2 | 2786.1 | 2784.1 | 2784.9 | 753.0 |
| 2024-09-22 20:00:00 | GC | Futures | 2784.7 | 2785.1 | 2782.9 | 2783.2 | 1731.0 |
| 2024-09-22 21:00:00 | GC | Futures | 2783.0 | 2786.7 | 2780.6 | 2785.1 | 5534.0 |
| 2024-09-22 22:00:00 | GC | Futures | 2785.0 | 2793.0 | 2783.5 | 2790.5 | 4741.0 |
| 2024-09-22 23:00:00 | GC | Futures | 2790.5 | 2796.6 | 2789.9 | 2793.8 | 5233.0 |
| 2024-09-22 18:00:00 | ZN | Futures | 114.912089 | 114.974694 | 114.849484 | 114.912089 | 13651.0 |
| 2024-09-22 19:00:00 | ZN | Futures | 114.912089 | 114.92774 | 114.880786 | 114.896438 | 5551.0 |
| 2024-09-22 20:00:00 | ZN | Futures | 114.896438 | 114.943392 | 114.849484 | 114.849484 | 11971.0 |
| 2024-09-22 21:00:00 | ZN | Futures | 114.865135 | 114.865135 | 114.833832 | 114.833832 | 3498.0 |
| 2024-09-22 22:00:00 | ZN | Futures | 114.849484 | 114.865135 | 114.833832 | 114.865135 | 4908.0 |
| 2024-09-22 23:00:00 | ZN | Futures | 114.865135 | 114.880786 | 114.849484 | 114.865135 | 3021.0 |
> showing 36 of 433 rows — these rows as CSV