PREVIEW / futures_1hour / 2024-10-27
file: by_date/futures_1hour/2024/2024-10-27.parquet size: 20 KB rows: 446
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-10-27 18:00:00 | ES | Futures | 6080.11 | 6098.8 | 6080.11 | 6095.95 | 16541.0 |
| 2024-10-27 19:00:00 | ES | Futures | 6095.95 | 6098.02 | 6092.05 | 6094.13 | 5816.0 |
| 2024-10-27 20:00:00 | ES | Futures | 6094.39 | 6105.29 | 6093.35 | 6098.54 | 12666.0 |
| 2024-10-27 21:00:00 | ES | Futures | 6098.28 | 6104.51 | 6097.5 | 6099.58 | 10404.0 |
| 2024-10-27 22:00:00 | ES | Futures | 6099.32 | 6101.91 | 6097.24 | 6100.36 | 6050.0 |
| 2024-10-27 23:00:00 | ES | Futures | 6100.1 | 6101.65 | 6093.61 | 6096.2 | 7258.0 |
| 2024-10-27 18:00:00 | NQ | Futures | 21421.42 | 21522.4 | 21421.16 | 21507.52 | 7169.0 |
| 2024-10-27 19:00:00 | NQ | Futures | 21507.52 | 21515.35 | 21484.83 | 21497.35 | 4010.0 |
| 2024-10-27 20:00:00 | NQ | Futures | 21496.83 | 21550.31 | 21490.83 | 21514.57 | 6419.0 |
| 2024-10-27 21:00:00 | NQ | Futures | 21514.57 | 21547.7 | 21512.22 | 21526.05 | 5353.0 |
| 2024-10-27 22:00:00 | NQ | Futures | 21526.31 | 21538.31 | 21513.79 | 21527.09 | 2969.0 |
| 2024-10-27 23:00:00 | NQ | Futures | 21527.09 | 21535.44 | 21499.96 | 21514.05 | 3006.0 |
| 2024-10-27 18:00:00 | YM | Futures | 44086.3 | 44221.6 | 44086.3 | 44198.7 | 1780.0 |
| 2024-10-27 19:00:00 | YM | Futures | 44197.6 | 44214.3 | 44164.3 | 44177.9 | 960.0 |
| 2024-10-27 20:00:00 | YM | Futures | 44176.8 | 44270.5 | 44171.6 | 44230.9 | 1800.0 |
| 2024-10-27 21:00:00 | YM | Futures | 44229.9 | 44258.0 | 44221.6 | 44227.8 | 973.0 |
| 2024-10-27 22:00:00 | YM | Futures | 44228.9 | 44242.4 | 44217.4 | 44238.2 | 578.0 |
| 2024-10-27 23:00:00 | YM | Futures | 44240.3 | 44249.7 | 44195.5 | 44212.2 | 757.0 |
| 2024-10-27 18:00:00 | CL | Futures | 62.43 | 62.45 | 61.35 | 62.06 | 24591.0 |
| 2024-10-27 19:00:00 | CL | Futures | 62.06 | 62.27 | 62.03 | 62.22 | 4061.0 |
| 2024-10-27 20:00:00 | CL | Futures | 62.23 | 62.34 | 62.12 | 62.31 | 4233.0 |
| 2024-10-27 21:00:00 | CL | Futures | 62.31 | 62.31 | 61.85 | 62.07 | 10177.0 |
| 2024-10-27 22:00:00 | CL | Futures | 62.06 | 62.11 | 61.91 | 61.98 | 2950.0 |
| 2024-10-27 23:00:00 | CL | Futures | 61.98 | 62.17 | 61.96 | 61.98 | 2823.0 |
| 2024-10-27 18:00:00 | GC | Futures | 2894.8 | 2895.7 | 2887.2 | 2892.2 | 7034.0 |
| 2024-10-27 19:00:00 | GC | Futures | 2892.4 | 2898.3 | 2892.2 | 2893.6 | 4047.0 |
| 2024-10-27 20:00:00 | GC | Futures | 2893.4 | 2894.3 | 2889.8 | 2890.2 | 3181.0 |
| 2024-10-27 21:00:00 | GC | Futures | 2890.2 | 2890.8 | 2881.9 | 2890.1 | 7963.0 |
| 2024-10-27 22:00:00 | GC | Futures | 2890.1 | 2893.9 | 2888.4 | 2892.0 | 3305.0 |
| 2024-10-27 23:00:00 | GC | Futures | 2892.1 | 2892.6 | 2886.9 | 2887.1 | 1945.0 |
| 2024-10-27 18:00:00 | ZN | Futures | 111.140118 | 111.140118 | 110.764486 | 110.999256 | 69714.0 |
| 2024-10-27 19:00:00 | ZN | Futures | 110.983604 | 111.04621 | 110.952302 | 110.999256 | 19068.0 |
| 2024-10-27 20:00:00 | ZN | Futures | 111.014907 | 111.014907 | 110.874045 | 110.93665 | 48147.0 |
| 2024-10-27 21:00:00 | ZN | Futures | 110.93665 | 110.983604 | 110.905348 | 110.920999 | 15429.0 |
| 2024-10-27 22:00:00 | ZN | Futures | 110.920999 | 110.952302 | 110.889696 | 110.93665 | 14164.0 |
| 2024-10-27 23:00:00 | ZN | Futures | 110.93665 | 110.983604 | 110.93665 | 110.967953 | 10071.0 |
> showing 36 of 446 rows — these rows as CSV