PREVIEW / futures_1hour / 2024-04-07
file: by_date/futures_1hour/2024/2024-04-07.parquet size: 20 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-04-07 18:00:00 | ES | Futures | 5585.27 | 5591.64 | 5577.05 | 5578.37 | 10335.0 |
| 2024-04-07 19:00:00 | ES | Futures | 5578.11 | 5581.82 | 5577.84 | 5580.5 | 7156.0 |
| 2024-04-07 20:00:00 | ES | Futures | 5581.03 | 5581.29 | 5570.41 | 5575.99 | 11303.0 |
| 2024-04-07 21:00:00 | ES | Futures | 5575.99 | 5579.7 | 5574.39 | 5576.78 | 10070.0 |
| 2024-04-07 22:00:00 | ES | Futures | 5576.78 | 5577.58 | 5574.92 | 5576.78 | 5000.0 |
| 2024-04-07 23:00:00 | ES | Futures | 5576.78 | 5577.05 | 5564.58 | 5567.5 | 9515.0 |
| 2024-04-07 18:00:00 | NQ | Futures | 19632.92 | 19658.6 | 19587.18 | 19593.6 | 6099.0 |
| 2024-04-07 19:00:00 | NQ | Futures | 19592.8 | 19609.12 | 19591.73 | 19601.09 | 3175.0 |
| 2024-04-07 20:00:00 | NQ | Futures | 19602.16 | 19604.03 | 19563.91 | 19597.08 | 5583.0 |
| 2024-04-07 21:00:00 | NQ | Futures | 19597.35 | 19617.68 | 19589.59 | 19606.44 | 6040.0 |
| 2024-04-07 22:00:00 | NQ | Futures | 19606.71 | 19610.72 | 19598.42 | 19609.12 | 2481.0 |
| 2024-04-07 23:00:00 | NQ | Futures | 19609.38 | 19609.92 | 19549.46 | 19565.78 | 4383.0 |
| 2024-04-07 18:00:00 | YM | Futures | 41703.7 | 41771.6 | 41697.3 | 41701.5 | 2177.0 |
| 2024-04-07 19:00:00 | YM | Futures | 41700.5 | 41722.8 | 41696.2 | 41704.7 | 699.0 |
| 2024-04-07 20:00:00 | YM | Futures | 41709.0 | 41711.1 | 41637.8 | 41669.7 | 1146.0 |
| 2024-04-07 21:00:00 | YM | Futures | 41669.7 | 41689.9 | 41658.0 | 41671.8 | 1181.0 |
| 2024-04-07 22:00:00 | YM | Futures | 41673.9 | 41676.1 | 41659.1 | 41668.6 | 682.0 |
| 2024-04-07 23:00:00 | YM | Futures | 41668.6 | 41670.8 | 41597.5 | 41614.5 | 1352.0 |
| 2024-04-07 18:00:00 | CL | Futures | 72.44 | 72.58 | 72.19 | 72.38 | 5829.0 |
| 2024-04-07 19:00:00 | CL | Futures | 72.38 | 72.43 | 72.21 | 72.28 | 2290.0 |
| 2024-04-07 20:00:00 | CL | Futures | 72.27 | 72.28 | 71.71 | 71.75 | 6198.0 |
| 2024-04-07 21:00:00 | CL | Futures | 71.75 | 71.91 | 71.26 | 71.88 | 11704.0 |
| 2024-04-07 22:00:00 | CL | Futures | 71.89 | 72.18 | 71.85 | 72.08 | 5085.0 |
| 2024-04-07 23:00:00 | CL | Futures | 72.09 | 72.12 | 71.96 | 72.01 | 2582.0 |
| 2024-04-07 18:00:00 | GC | Futures | 2543.2 | 2548.1 | 2520.9 | 2524.8 | 12651.0 |
| 2024-04-07 19:00:00 | GC | Futures | 2524.6 | 2532.2 | 2523.1 | 2528.5 | 5627.0 |
| 2024-04-07 20:00:00 | GC | Futures | 2529.0 | 2529.7 | 2523.0 | 2523.1 | 9194.0 |
| 2024-04-07 21:00:00 | GC | Futures | 2523.0 | 2543.9 | 2519.4 | 2542.8 | 17035.0 |
| 2024-04-07 22:00:00 | GC | Futures | 2542.8 | 2574.5 | 2539.8 | 2568.3 | 23963.0 |
| 2024-04-07 23:00:00 | GC | Futures | 2568.5 | 2570.5 | 2560.8 | 2565.7 | 9133.0 |
| 2024-04-07 18:00:00 | ZN | Futures | 110.261578 | 110.261578 | 110.104107 | 110.245831 | 29050.0 |
| 2024-04-07 19:00:00 | ZN | Futures | 110.230084 | 110.277325 | 110.214337 | 110.245831 | 12484.0 |
| 2024-04-07 20:00:00 | ZN | Futures | 110.261578 | 110.277325 | 110.198589 | 110.198589 | 38521.0 |
| 2024-04-07 21:00:00 | ZN | Futures | 110.198589 | 110.214337 | 110.135601 | 110.167095 | 46141.0 |
| 2024-04-07 22:00:00 | ZN | Futures | 110.182842 | 110.230084 | 110.151348 | 110.198589 | 13489.0 |
| 2024-04-07 23:00:00 | ZN | Futures | 110.214337 | 110.230084 | 110.182842 | 110.198589 | 8893.0 |
> showing 36 of 433 rows — these rows as CSV