PREVIEW / futures_1hour / 2022-01-02
file: by_date/futures_1hour/2022/2022-01-02.parquet size: 19 KB rows: 416
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-02 18:00:00 | ES | Futures | 5397.0 | 5404.35 | 5396.71 | 5401.52 | 13421.0 |
| 2022-01-02 19:00:00 | ES | Futures | 5401.52 | 5411.7 | 5401.24 | 5410.57 | 11187.0 |
| 2022-01-02 20:00:00 | ES | Futures | 5410.57 | 5412.83 | 5403.22 | 5404.91 | 12695.0 |
| 2022-01-02 21:00:00 | ES | Futures | 5404.63 | 5407.18 | 5402.09 | 5406.61 | 5872.0 |
| 2022-01-02 22:00:00 | ES | Futures | 5406.61 | 5407.46 | 5402.65 | 5405.2 | 3503.0 |
| 2022-01-02 23:00:00 | ES | Futures | 5405.2 | 5405.48 | 5403.5 | 5405.2 | 1943.0 |
| 2022-01-02 18:00:00 | NQ | Futures | 18961.0 | 19036.64 | 18961.0 | 18993.17 | 7611.0 |
| 2022-01-02 19:00:00 | NQ | Futures | 18993.75 | 19036.35 | 18993.75 | 19030.55 | 6213.0 |
| 2022-01-02 20:00:00 | NQ | Futures | 19031.13 | 19044.17 | 19011.14 | 19015.77 | 7169.0 |
| 2022-01-02 21:00:00 | NQ | Futures | 19014.9 | 19031.71 | 19004.18 | 19030.84 | 4753.0 |
| 2022-01-02 22:00:00 | NQ | Futures | 19030.55 | 19033.16 | 19012.58 | 19020.12 | 3042.0 |
| 2022-01-02 23:00:00 | NQ | Futures | 19020.41 | 19023.89 | 19014.9 | 19023.89 | 1335.0 |
| 2022-01-02 18:00:00 | YM | Futures | 40798.4 | 40855.8 | 40793.9 | 40827.7 | 2583.0 |
| 2022-01-02 19:00:00 | YM | Futures | 40831.0 | 40913.1 | 40825.4 | 40905.2 | 2547.0 |
| 2022-01-02 20:00:00 | YM | Futures | 40907.5 | 40924.3 | 40840.0 | 40855.8 | 2257.0 |
| 2022-01-02 21:00:00 | YM | Futures | 40854.6 | 40869.2 | 40833.3 | 40855.8 | 1263.0 |
| 2022-01-02 22:00:00 | YM | Futures | 40858.0 | 40865.9 | 40828.8 | 40850.1 | 729.0 |
| 2022-01-02 23:00:00 | YM | Futures | 40851.3 | 40852.4 | 40833.3 | 40845.6 | 509.0 |
| 2022-01-02 18:00:00 | CL | Futures | 53.81 | 53.98 | 53.73 | 53.9 | 3720.0 |
| 2022-01-02 19:00:00 | CL | Futures | 53.91 | 54.08 | 53.88 | 53.96 | 3389.0 |
| 2022-01-02 20:00:00 | CL | Futures | 53.96 | 54.01 | 53.7 | 53.78 | 3630.0 |
| 2022-01-02 21:00:00 | CL | Futures | 53.78 | 53.78 | 53.64 | 53.67 | 2374.0 |
| 2022-01-02 22:00:00 | CL | Futures | 53.67 | 53.95 | 53.66 | 53.88 | 2526.0 |
| 2022-01-02 23:00:00 | CL | Futures | 53.9 | 53.92 | 53.83 | 53.86 | 1244.0 |
| 2022-01-02 18:00:00 | GC | Futures | 2200.0 | 2203.5 | 2198.5 | 2199.3 | 2596.0 |
| 2022-01-02 19:00:00 | GC | Futures | 2199.1 | 2201.9 | 2197.2 | 2201.2 | 2453.0 |
| 2022-01-02 20:00:00 | GC | Futures | 2201.1 | 2203.0 | 2198.3 | 2199.7 | 2979.0 |
| 2022-01-02 21:00:00 | GC | Futures | 2199.7 | 2199.9 | 2195.7 | 2196.3 | 2628.0 |
| 2022-01-02 22:00:00 | GC | Futures | 2196.4 | 2197.3 | 2193.9 | 2195.8 | 2277.0 |
| 2022-01-02 23:00:00 | GC | Futures | 2195.8 | 2196.3 | 2194.5 | 2195.2 | 723.0 |
| 2022-01-02 18:00:00 | ZN | Futures | 133.81824 | 133.834284 | 133.72198 | 133.834284 | 15862.0 |
| 2022-01-02 19:00:00 | ZN | Futures | 133.81824 | 133.834284 | 133.77011 | 133.834284 | 6407.0 |
| 2022-01-02 20:00:00 | ZN | Futures | 133.834284 | 133.834284 | 133.786153 | 133.81824 | 4191.0 |
| 2022-01-02 21:00:00 | ZN | Futures | 133.81824 | 133.81824 | 133.786153 | 133.786153 | 4075.0 |
| 2022-01-02 22:00:00 | ZN | Futures | 133.802197 | 133.81824 | 133.77011 | 133.77011 | 2763.0 |
| 2022-01-02 23:00:00 | ZN | Futures | 133.786153 | 133.786153 | 133.754066 | 133.754066 | 2533.0 |
> showing 36 of 416 rows — these rows as CSV