PREVIEW / futures_1hour / 2024-12-01
file: by_date/futures_1hour/2024/2024-12-01.parquet size: 20 KB rows: 457
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-12-01 18:00:00 | ES | Futures | 6282.02 | 6285.14 | 6274.24 | 6275.79 | 11860.0 |
| 2024-12-01 19:00:00 | ES | Futures | 6276.05 | 6279.95 | 6272.16 | 6275.02 | 8580.0 |
| 2024-12-01 20:00:00 | ES | Futures | 6275.28 | 6277.35 | 6272.42 | 6272.68 | 5835.0 |
| 2024-12-01 21:00:00 | ES | Futures | 6272.68 | 6273.2 | 6270.86 | 6271.9 | 5581.0 |
| 2024-12-01 22:00:00 | ES | Futures | 6271.64 | 6273.2 | 6269.05 | 6269.83 | 5307.0 |
| 2024-12-01 23:00:00 | ES | Futures | 6269.83 | 6273.2 | 6269.05 | 6270.34 | 5767.0 |
| 2024-12-01 18:00:00 | NQ | Futures | 21911.68 | 21920.81 | 21867.06 | 21879.59 | 6429.0 |
| 2024-12-01 19:00:00 | NQ | Futures | 21881.15 | 21898.89 | 21855.84 | 21871.24 | 5164.0 |
| 2024-12-01 20:00:00 | NQ | Futures | 21871.5 | 21890.02 | 21864.19 | 21872.28 | 3582.0 |
| 2024-12-01 21:00:00 | NQ | Futures | 21871.76 | 21876.72 | 21862.37 | 21868.37 | 2764.0 |
| 2024-12-01 22:00:00 | NQ | Futures | 21868.37 | 21879.85 | 21859.76 | 21864.45 | 2622.0 |
| 2024-12-01 23:00:00 | NQ | Futures | 21863.93 | 21881.67 | 21861.06 | 21871.76 | 2730.0 |
| 2024-12-01 18:00:00 | YM | Futures | 46883.8 | 46901.5 | 46833.9 | 46845.3 | 1143.0 |
| 2024-12-01 19:00:00 | YM | Futures | 46847.4 | 46872.4 | 46828.6 | 46851.5 | 879.0 |
| 2024-12-01 20:00:00 | YM | Futures | 46851.5 | 46855.7 | 46818.2 | 46818.2 | 471.0 |
| 2024-12-01 21:00:00 | YM | Futures | 46820.3 | 46823.4 | 46801.6 | 46819.3 | 483.0 |
| 2024-12-01 22:00:00 | YM | Futures | 46819.3 | 46825.5 | 46796.4 | 46801.6 | 429.0 |
| 2024-12-01 23:00:00 | YM | Futures | 46800.5 | 46825.5 | 46796.4 | 46806.8 | 435.0 |
| 2024-12-01 18:00:00 | CL | Futures | 61.69 | 62.04 | 61.61 | 61.95 | 3965.0 |
| 2024-12-01 19:00:00 | CL | Futures | 61.96 | 61.99 | 61.83 | 61.84 | 1025.0 |
| 2024-12-01 20:00:00 | CL | Futures | 61.83 | 61.94 | 61.67 | 61.93 | 3280.0 |
| 2024-12-01 21:00:00 | CL | Futures | 61.93 | 62.13 | 61.92 | 62.08 | 2926.0 |
| 2024-12-01 22:00:00 | CL | Futures | 62.08 | 62.09 | 62.0 | 62.0 | 855.0 |
| 2024-12-01 23:00:00 | CL | Futures | 62.0 | 62.04 | 61.96 | 61.99 | 977.0 |
| 2024-12-01 18:00:00 | GC | Futures | 2789.9 | 2794.8 | 2781.3 | 2784.3 | 4230.0 |
| 2024-12-01 19:00:00 | GC | Futures | 2784.6 | 2786.2 | 2767.6 | 2775.6 | 7236.0 |
| 2024-12-01 20:00:00 | GC | Futures | 2775.7 | 2777.3 | 2760.1 | 2774.0 | 11890.0 |
| 2024-12-01 21:00:00 | GC | Futures | 2773.8 | 2776.2 | 2763.1 | 2764.3 | 5607.0 |
| 2024-12-01 22:00:00 | GC | Futures | 2764.6 | 2769.1 | 2761.5 | 2767.3 | 4540.0 |
| 2024-12-01 23:00:00 | GC | Futures | 2767.4 | 2768.7 | 2764.0 | 2766.5 | 2272.0 |
| 2024-12-01 18:00:00 | ZN | Futures | 111.187072 | 111.187072 | 111.077512 | 111.124466 | 328.0 |
| 2024-12-01 19:00:00 | ZN | Futures | 111.124466 | 111.124466 | 111.077512 | 111.093164 | 21.0 |
| 2024-12-01 20:00:00 | ZN | Futures | 111.093164 | 111.108815 | 111.04621 | 111.061861 | 269.0 |
| 2024-12-01 21:00:00 | ZN | Futures | 111.061861 | 111.061861 | 111.030558 | 111.061861 | 52.0 |
| 2024-12-01 22:00:00 | ZN | Futures | 111.077512 | 111.093164 | 111.077512 | 111.077512 | 196.0 |
| 2024-12-01 23:00:00 | ZN | Futures | 111.093164 | 111.108815 | 111.04621 | 111.04621 | 72.0 |
> showing 36 of 457 rows — these rows as CSV