PREVIEW / futures_1hour / 2021-05-02
file: by_date/futures_1hour/2021/2021-05-02.parquet size: 19 KB rows: 404
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 |
|---|---|---|---|---|---|---|---|
| 2021-05-02 18:00:00 | ES | Futures | 4699.49 | 4706.8 | 4699.49 | 4705.39 | 8395.0 |
| 2021-05-02 19:00:00 | ES | Futures | 4705.39 | 4707.36 | 4704.83 | 4706.8 | 4595.0 |
| 2021-05-02 20:00:00 | ES | Futures | 4706.8 | 4713.82 | 4705.96 | 4712.7 | 8772.0 |
| 2021-05-02 21:00:00 | ES | Futures | 4712.98 | 4713.54 | 4706.24 | 4707.36 | 9507.0 |
| 2021-05-02 22:00:00 | ES | Futures | 4707.36 | 4707.36 | 4703.43 | 4705.39 | 6314.0 |
| 2021-05-02 23:00:00 | ES | Futures | 4705.67 | 4707.92 | 4705.39 | 4707.36 | 2547.0 |
| 2021-05-02 18:00:00 | NQ | Futures | 16073.07 | 16082.91 | 16061.2 | 16075.38 | 4822.0 |
| 2021-05-02 19:00:00 | NQ | Futures | 16074.8 | 16079.44 | 16069.59 | 16072.49 | 1324.0 |
| 2021-05-02 20:00:00 | NQ | Futures | 16073.07 | 16095.07 | 16069.59 | 16092.75 | 3150.0 |
| 2021-05-02 21:00:00 | NQ | Futures | 16092.17 | 16099.99 | 16066.99 | 16071.33 | 3551.0 |
| 2021-05-02 22:00:00 | NQ | Futures | 16071.04 | 16074.52 | 16058.88 | 16065.25 | 2614.0 |
| 2021-05-02 23:00:00 | NQ | Futures | 16066.12 | 16070.46 | 16062.65 | 16069.01 | 1179.0 |
| 2021-05-02 18:00:00 | YM | Futures | 37678.2 | 37719.5 | 37672.7 | 37708.3 | 1933.0 |
| 2021-05-02 19:00:00 | YM | Futures | 37708.3 | 37731.7 | 37703.9 | 37729.5 | 1005.0 |
| 2021-05-02 20:00:00 | YM | Futures | 37729.5 | 37782.9 | 37723.9 | 37780.7 | 2179.0 |
| 2021-05-02 21:00:00 | YM | Futures | 37779.6 | 37781.8 | 37733.9 | 37738.4 | 1537.0 |
| 2021-05-02 22:00:00 | YM | Futures | 37738.4 | 37739.5 | 37709.4 | 37726.1 | 1327.0 |
| 2021-05-02 23:00:00 | YM | Futures | 37726.1 | 37758.4 | 37726.1 | 37754.0 | 937.0 |
| 2021-05-02 18:00:00 | CL | Futures | 43.14 | 43.19 | 43.05 | 43.13 | 2305.0 |
| 2021-05-02 19:00:00 | CL | Futures | 43.13 | 43.23 | 43.09 | 43.21 | 1341.0 |
| 2021-05-02 20:00:00 | CL | Futures | 43.21 | 43.36 | 43.2 | 43.33 | 3779.0 |
| 2021-05-02 21:00:00 | CL | Futures | 43.32 | 43.33 | 43.11 | 43.14 | 2760.0 |
| 2021-05-02 22:00:00 | CL | Futures | 43.15 | 43.15 | 42.98 | 43.04 | 3184.0 |
| 2021-05-02 23:00:00 | CL | Futures | 43.04 | 43.06 | 42.99 | 43.0 | 1131.0 |
| 2021-05-02 18:00:00 | GC | Futures | 2135.9 | 2136.8 | 2132.9 | 2135.1 | 1332.0 |
| 2021-05-02 19:00:00 | GC | Futures | 2135.1 | 2136.4 | 2134.5 | 2136.4 | 1106.0 |
| 2021-05-02 20:00:00 | GC | Futures | 2136.3 | 2138.5 | 2134.2 | 2138.5 | 1953.0 |
| 2021-05-02 21:00:00 | GC | Futures | 2138.5 | 2140.4 | 2137.5 | 2139.8 | 2982.0 |
| 2021-05-02 22:00:00 | GC | Futures | 2139.9 | 2142.6 | 2139.9 | 2140.2 | 3170.0 |
| 2021-05-02 23:00:00 | GC | Futures | 2140.3 | 2144.8 | 2140.2 | 2144.0 | 3082.0 |
| 2021-05-02 18:00:00 | ZN | Futures | 133.390721 | 133.406505 | 133.311801 | 133.390721 | 21380.0 |
| 2021-05-02 19:00:00 | ZN | Futures | 133.374937 | 133.406505 | 133.374937 | 133.390721 | 3215.0 |
| 2021-05-02 20:00:00 | ZN | Futures | 133.374937 | 133.390721 | 133.296017 | 133.296017 | 10787.0 |
| 2021-05-02 21:00:00 | ZN | Futures | 133.296017 | 133.343369 | 133.296017 | 133.343369 | 5718.0 |
| 2021-05-02 22:00:00 | ZN | Futures | 133.343369 | 133.390721 | 133.343369 | 133.374937 | 6005.0 |
| 2021-05-02 23:00:00 | ZN | Futures | 133.374937 | 133.374937 | 133.359153 | 133.374937 | 2617.0 |
> showing 36 of 404 rows — these rows as CSV