PREVIEW / futures_1hour / 2021-09-05
file: by_date/futures_1hour/2021/2021-09-05.parquet size: 16 KB rows: 341
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-09-05 18:00:00 | ES | Futures | 5105.65 | 5108.18 | 5102.83 | 5103.96 | 3436.0 |
| 2021-09-05 19:00:00 | ES | Futures | 5103.96 | 5104.52 | 5099.74 | 5100.3 | 3887.0 |
| 2021-09-05 20:00:00 | ES | Futures | 5100.02 | 5100.58 | 5095.23 | 5098.33 | 9129.0 |
| 2021-09-05 21:00:00 | ES | Futures | 5098.05 | 5104.24 | 5098.05 | 5101.71 | 6514.0 |
| 2021-09-05 22:00:00 | ES | Futures | 5101.71 | 5103.68 | 5099.17 | 5101.71 | 4273.0 |
| 2021-09-05 23:00:00 | ES | Futures | 5101.99 | 5105.93 | 5100.86 | 5105.93 | 3813.0 |
| 2021-09-05 18:00:00 | NQ | Futures | 18141.0 | 18149.98 | 18139.84 | 18145.34 | 1661.0 |
| 2021-09-05 19:00:00 | NQ | Futures | 18145.05 | 18146.79 | 18132.89 | 18134.63 | 1564.0 |
| 2021-09-05 20:00:00 | NQ | Futures | 18134.63 | 18140.42 | 18125.36 | 18132.6 | 3020.0 |
| 2021-09-05 21:00:00 | NQ | Futures | 18132.31 | 18147.66 | 18125.94 | 18139.55 | 3176.0 |
| 2021-09-05 22:00:00 | NQ | Futures | 18139.26 | 18145.92 | 18134.34 | 18142.74 | 2152.0 |
| 2021-09-05 23:00:00 | NQ | Futures | 18142.74 | 18149.4 | 18141.0 | 18145.63 | 1637.0 |
| 2021-09-05 18:00:00 | YM | Futures | 39497.1 | 39498.2 | 39451.3 | 39462.5 | 921.0 |
| 2021-09-05 19:00:00 | YM | Futures | 39461.3 | 39464.7 | 39432.3 | 39440.1 | 1185.0 |
| 2021-09-05 20:00:00 | YM | Futures | 39437.9 | 39439.0 | 39397.7 | 39426.7 | 1721.0 |
| 2021-09-05 21:00:00 | YM | Futures | 39426.7 | 39487.0 | 39424.5 | 39463.6 | 1323.0 |
| 2021-09-05 22:00:00 | YM | Futures | 39465.8 | 39482.6 | 39437.9 | 39460.2 | 1033.0 |
| 2021-09-05 23:00:00 | YM | Futures | 39460.2 | 39499.3 | 39451.3 | 39494.9 | 950.0 |
| 2021-09-05 18:00:00 | CL | Futures | 47.74 | 47.84 | 47.62 | 47.64 | 2584.0 |
| 2021-09-05 19:00:00 | CL | Futures | 47.64 | 47.66 | 47.47 | 47.49 | 2179.0 |
| 2021-09-05 20:00:00 | CL | Futures | 47.49 | 47.51 | 47.41 | 47.44 | 3063.0 |
| 2021-09-05 21:00:00 | CL | Futures | 47.44 | 47.55 | 47.26 | 47.37 | 7944.0 |
| 2021-09-05 22:00:00 | CL | Futures | 47.36 | 47.43 | 47.2 | 47.35 | 4424.0 |
| 2021-09-05 23:00:00 | CL | Futures | 47.35 | 47.4 | 47.31 | 47.35 | 1831.0 |
| 2021-09-05 18:00:00 | GC | Futures | 2207.1 | 2207.1 | 2202.9 | 2203.9 | 1570.0 |
| 2021-09-05 19:00:00 | GC | Futures | 2203.9 | 2204.3 | 2202.5 | 2202.7 | 933.0 |
| 2021-09-05 20:00:00 | GC | Futures | 2202.7 | 2203.1 | 2200.0 | 2200.4 | 2423.0 |
| 2021-09-05 21:00:00 | GC | Futures | 2200.5 | 2203.7 | 2199.8 | 2202.2 | 4870.0 |
| 2021-09-05 22:00:00 | GC | Futures | 2202.3 | 2203.3 | 2201.2 | 2202.6 | 1714.0 |
| 2021-09-05 23:00:00 | GC | Futures | 2202.6 | 2202.9 | 2200.3 | 2200.6 | 1434.0 |
| 2021-09-05 18:00:00 | ZN | Futures | 136.228292 | 136.228292 | 136.228292 | 136.228292 | 1.0 |
| 2021-09-05 19:00:00 | ZN | Futures | 136.228292 | 136.228292 | 136.228292 | 136.228292 | 5.0 |
| 2021-09-05 20:00:00 | ZN | Futures | 136.196515 | 136.196515 | 136.196515 | 136.196515 | 31.0 |
| 2021-09-05 23:00:00 | ZN | Futures | 136.228292 | 136.228292 | 136.228292 | 136.228292 | 2.0 |
> showing 34 of 341 rows — these rows as CSV