PREVIEW / futures_1hour / 2021-08-15
file: by_date/futures_1hour/2021/2021-08-15.parquet size: 18 KB rows: 386
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-08-15 18:00:00 | ES | Futures | 5019.2 | 5022.3 | 5017.8 | 5021.46 | 6383.0 |
| 2021-08-15 19:00:00 | ES | Futures | 5021.46 | 5022.02 | 5019.2 | 5020.61 | 5124.0 |
| 2021-08-15 20:00:00 | ES | Futures | 5020.61 | 5021.17 | 5012.16 | 5014.42 | 12555.0 |
| 2021-08-15 21:00:00 | ES | Futures | 5014.42 | 5016.67 | 5012.73 | 5013.57 | 6975.0 |
| 2021-08-15 22:00:00 | ES | Futures | 5013.57 | 5013.57 | 5009.91 | 5012.73 | 7120.0 |
| 2021-08-15 23:00:00 | ES | Futures | 5012.73 | 5014.42 | 5011.04 | 5013.57 | 4700.0 |
| 2021-08-15 18:00:00 | NQ | Futures | 17519.05 | 17523.4 | 17503.7 | 17519.34 | 3835.0 |
| 2021-08-15 19:00:00 | NQ | Futures | 17519.34 | 17521.37 | 17510.07 | 17512.68 | 2254.0 |
| 2021-08-15 20:00:00 | NQ | Futures | 17512.97 | 17514.71 | 17488.93 | 17503.7 | 4869.0 |
| 2021-08-15 21:00:00 | NQ | Futures | 17503.41 | 17514.42 | 17499.64 | 17504.57 | 4056.0 |
| 2021-08-15 22:00:00 | NQ | Futures | 17504.57 | 17508.34 | 17492.4 | 17499.93 | 3350.0 |
| 2021-08-15 23:00:00 | NQ | Futures | 17500.51 | 17506.6 | 17495.3 | 17505.73 | 2098.0 |
| 2021-08-15 18:00:00 | YM | Futures | 39531.7 | 39532.8 | 39503.8 | 39520.6 | 1819.0 |
| 2021-08-15 19:00:00 | YM | Futures | 39521.7 | 39526.1 | 39508.3 | 39523.9 | 1116.0 |
| 2021-08-15 20:00:00 | YM | Futures | 39523.9 | 39530.6 | 39430.1 | 39454.6 | 3619.0 |
| 2021-08-15 21:00:00 | YM | Futures | 39454.6 | 39466.9 | 39430.1 | 39443.5 | 1652.0 |
| 2021-08-15 22:00:00 | YM | Futures | 39442.3 | 39442.3 | 39404.4 | 39433.4 | 2084.0 |
| 2021-08-15 23:00:00 | YM | Futures | 39433.4 | 39445.7 | 39417.8 | 39428.9 | 1149.0 |
| 2021-08-15 18:00:00 | CL | Futures | 46.72 | 46.99 | 46.64 | 46.93 | 843.0 |
| 2021-08-15 19:00:00 | CL | Futures | 46.93 | 46.95 | 46.84 | 46.86 | 257.0 |
| 2021-08-15 20:00:00 | CL | Futures | 46.86 | 46.86 | 46.5 | 46.57 | 1089.0 |
| 2021-08-15 21:00:00 | CL | Futures | 46.56 | 46.63 | 46.41 | 46.6 | 1966.0 |
| 2021-08-15 22:00:00 | CL | Futures | 46.59 | 46.61 | 46.48 | 46.58 | 779.0 |
| 2021-08-15 23:00:00 | CL | Futures | 46.59 | 46.6 | 46.51 | 46.57 | 505.0 |
| 2021-08-15 18:00:00 | GC | Futures | 2143.8 | 2144.8 | 2142.6 | 2143.6 | 2257.0 |
| 2021-08-15 19:00:00 | GC | Futures | 2143.5 | 2144.5 | 2142.5 | 2143.0 | 1287.0 |
| 2021-08-15 20:00:00 | GC | Futures | 2143.0 | 2145.5 | 2142.0 | 2145.5 | 3550.0 |
| 2021-08-15 21:00:00 | GC | Futures | 2145.5 | 2148.0 | 2141.3 | 2141.5 | 6095.0 |
| 2021-08-15 22:00:00 | GC | Futures | 2141.4 | 2144.8 | 2141.2 | 2143.3 | 3712.0 |
| 2021-08-15 23:00:00 | GC | Futures | 2143.5 | 2143.5 | 2140.3 | 2140.6 | 2385.0 |
| 2021-08-15 18:00:00 | ZN | Futures | 136.387178 | 136.387178 | 136.323623 | 136.339512 | 18697.0 |
| 2021-08-15 19:00:00 | ZN | Futures | 136.339512 | 136.371289 | 136.323623 | 136.323623 | 10965.0 |
| 2021-08-15 20:00:00 | ZN | Futures | 136.323623 | 136.482509 | 136.323623 | 136.418955 | 34683.0 |
| 2021-08-15 21:00:00 | ZN | Futures | 136.418955 | 136.46662 | 136.387178 | 136.434843 | 14851.0 |
| 2021-08-15 22:00:00 | ZN | Futures | 136.434843 | 136.561951 | 136.434843 | 136.530174 | 32742.0 |
| 2021-08-15 23:00:00 | ZN | Futures | 136.546063 | 136.641394 | 136.530174 | 136.625506 | 32972.0 |
> showing 36 of 386 rows — these rows as CSV