PREVIEW / futures_1hour / 2025-04-06
file: by_date/futures_1hour/2025/2025-04-06.parquet size: 22 KB rows: 465
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 |
|---|---|---|---|---|---|---|---|
| 2025-04-06 18:00:00 | ES | Futures | 5087.91 | 5087.91 | 4910.09 | 4972.33 | 110431.0 |
| 2025-04-06 19:00:00 | ES | Futures | 4972.07 | 5009.67 | 4930.16 | 4993.16 | 55792.0 |
| 2025-04-06 20:00:00 | ES | Futures | 4993.67 | 5014.75 | 4949.72 | 5013.73 | 55990.0 |
| 2025-04-06 21:00:00 | ES | Futures | 5013.48 | 5076.23 | 5004.84 | 5068.35 | 54275.0 |
| 2025-04-06 22:00:00 | ES | Futures | 5068.35 | 5073.69 | 5033.3 | 5044.73 | 30143.0 |
| 2025-04-06 23:00:00 | ES | Futures | 5044.47 | 5047.52 | 5002.05 | 5014.75 | 30107.0 |
| 2025-04-06 18:00:00 | NQ | Futures | 17418.25 | 17418.25 | 16858.01 | 16975.15 | 34440.0 |
| 2025-04-06 19:00:00 | NQ | Futures | 16981.52 | 17107.57 | 16766.34 | 17029.9 | 19487.0 |
| 2025-04-06 20:00:00 | NQ | Futures | 17032.45 | 17087.71 | 16812.18 | 17080.84 | 22749.0 |
| 2025-04-06 21:00:00 | NQ | Futures | 17079.31 | 17328.36 | 17040.6 | 17301.36 | 24683.0 |
| 2025-04-06 22:00:00 | NQ | Futures | 17297.54 | 17342.11 | 17172.26 | 17210.71 | 14135.0 |
| 2025-04-06 23:00:00 | NQ | Futures | 17210.71 | 17215.55 | 17050.53 | 17122.85 | 12800.0 |
| 2025-04-06 18:00:00 | YM | Futures | 38862.4 | 38892.2 | 37778.7 | 38138.9 | 5964.0 |
| 2025-04-06 19:00:00 | YM | Futures | 38148.1 | 38375.6 | 37892.9 | 38242.8 | 4593.0 |
| 2025-04-06 20:00:00 | YM | Futures | 38262.4 | 38472.3 | 38129.6 | 38460.0 | 6090.0 |
| 2025-04-06 21:00:00 | YM | Futures | 38461.0 | 38902.5 | 38428.1 | 38854.2 | 6005.0 |
| 2025-04-06 22:00:00 | YM | Futures | 38857.2 | 38889.1 | 38682.3 | 38746.1 | 3562.0 |
| 2025-04-06 23:00:00 | YM | Futures | 38755.4 | 38775.9 | 38483.7 | 38579.4 | 2786.0 |
| 2025-04-06 18:00:00 | CL | Futures | 57.08 | 57.13 | 55.61 | 55.88 | 13723.0 |
| 2025-04-06 19:00:00 | CL | Futures | 55.87 | 56.04 | 55.69 | 55.87 | 4183.0 |
| 2025-04-06 20:00:00 | CL | Futures | 55.86 | 56.17 | 55.45 | 56.11 | 7653.0 |
| 2025-04-06 21:00:00 | CL | Futures | 56.11 | 56.71 | 56.0 | 56.57 | 9412.0 |
| 2025-04-06 22:00:00 | CL | Futures | 56.57 | 56.71 | 56.14 | 56.42 | 5453.0 |
| 2025-04-06 23:00:00 | CL | Futures | 56.41 | 56.58 | 56.14 | 56.3 | 4257.0 |
| 2025-04-06 18:00:00 | GC | Futures | 3156.1 | 3156.1 | 3087.9 | 3126.9 | 11943.0 |
| 2025-04-06 19:00:00 | GC | Futures | 3126.1 | 3134.8 | 3090.1 | 3115.2 | 10905.0 |
| 2025-04-06 20:00:00 | GC | Futures | 3114.7 | 3125.2 | 3083.7 | 3093.5 | 12601.0 |
| 2025-04-06 21:00:00 | GC | Futures | 3092.8 | 3186.4 | 3085.7 | 3160.0 | 30221.0 |
| 2025-04-06 22:00:00 | GC | Futures | 3160.3 | 3179.7 | 3143.2 | 3145.6 | 12014.0 |
| 2025-04-06 23:00:00 | GC | Futures | 3145.6 | 3152.9 | 3133.3 | 3135.7 | 6139.0 |
| 2025-04-06 18:00:00 | ZN | Futures | 113.609929 | 114.34451 | 113.609929 | 114.000663 | 118701.0 |
| 2025-04-06 19:00:00 | ZN | Futures | 114.000663 | 114.09444 | 113.734964 | 113.938146 | 55394.0 |
| 2025-04-06 20:00:00 | ZN | Futures | 113.938146 | 114.063181 | 113.625558 | 113.656817 | 69117.0 |
| 2025-04-06 21:00:00 | ZN | Futures | 113.641188 | 113.734964 | 113.422377 | 113.469265 | 71110.0 |
| 2025-04-06 22:00:00 | ZN | Futures | 113.484894 | 113.656817 | 113.469265 | 113.656817 | 52893.0 |
| 2025-04-06 23:00:00 | ZN | Futures | 113.641188 | 113.703705 | 113.547412 | 113.563041 | 27476.0 |
> showing 36 of 465 rows — these rows as CSV