PREVIEW / futures_1hour / 2021-10-10
file: by_date/futures_1hour/2021/2021-10-10.parquet size: 19 KB rows: 396
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-10-10 18:00:00 | ES | Futures | 4945.49 | 4953.39 | 4930.53 | 4931.94 | 15294.0 |
| 2021-10-10 19:00:00 | ES | Futures | 4932.23 | 4934.77 | 4913.04 | 4919.81 | 20678.0 |
| 2021-10-10 20:00:00 | ES | Futures | 4919.81 | 4933.64 | 4916.7 | 4930.82 | 14134.0 |
| 2021-10-10 21:00:00 | ES | Futures | 4930.82 | 4942.67 | 4930.82 | 4935.89 | 14849.0 |
| 2021-10-10 22:00:00 | ES | Futures | 4935.61 | 4940.41 | 4932.79 | 4933.35 | 7619.0 |
| 2021-10-10 23:00:00 | ES | Futures | 4933.35 | 4938.15 | 4928.84 | 4935.61 | 7962.0 |
| 2021-10-10 18:00:00 | NQ | Futures | 17169.06 | 17190.79 | 17100.66 | 17106.75 | 8855.0 |
| 2021-10-10 19:00:00 | NQ | Futures | 17107.33 | 17119.21 | 17045.89 | 17060.67 | 8645.0 |
| 2021-10-10 20:00:00 | NQ | Futures | 17060.38 | 17105.88 | 17048.2 | 17092.26 | 6806.0 |
| 2021-10-10 21:00:00 | NQ | Futures | 17091.97 | 17131.67 | 17089.36 | 17105.3 | 8163.0 |
| 2021-10-10 22:00:00 | NQ | Futures | 17105.88 | 17119.5 | 17080.95 | 17085.59 | 4719.0 |
| 2021-10-10 23:00:00 | NQ | Futures | 17085.59 | 17102.98 | 17070.23 | 17098.92 | 4810.0 |
| 2021-10-10 18:00:00 | YM | Futures | 38799.1 | 38878.7 | 38717.3 | 38722.9 | 2255.0 |
| 2021-10-10 19:00:00 | YM | Futures | 38722.9 | 38746.4 | 38554.7 | 38613.0 | 4285.0 |
| 2021-10-10 20:00:00 | YM | Futures | 38618.6 | 38736.3 | 38590.6 | 38716.1 | 2622.0 |
| 2021-10-10 21:00:00 | YM | Futures | 38717.3 | 38824.9 | 38717.3 | 38764.3 | 3053.0 |
| 2021-10-10 22:00:00 | YM | Futures | 38764.3 | 38805.8 | 38752.0 | 38756.5 | 1421.0 |
| 2021-10-10 23:00:00 | YM | Futures | 38756.5 | 38791.2 | 38720.6 | 38775.5 | 1223.0 |
| 2021-10-10 18:00:00 | CL | Futures | 55.19 | 55.68 | 55.16 | 55.39 | 6568.0 |
| 2021-10-10 19:00:00 | CL | Futures | 55.39 | 55.5 | 55.25 | 55.25 | 2928.0 |
| 2021-10-10 20:00:00 | CL | Futures | 55.25 | 55.62 | 55.21 | 55.59 | 4392.0 |
| 2021-10-10 21:00:00 | CL | Futures | 55.6 | 55.93 | 55.49 | 55.8 | 11884.0 |
| 2021-10-10 22:00:00 | CL | Futures | 55.79 | 56.07 | 55.71 | 56.02 | 7111.0 |
| 2021-10-10 23:00:00 | CL | Futures | 56.02 | 56.18 | 55.99 | 56.09 | 6522.0 |
| 2021-10-10 18:00:00 | GC | Futures | 2115.5 | 2116.7 | 2107.8 | 2112.9 | 5346.0 |
| 2021-10-10 19:00:00 | GC | Futures | 2112.8 | 2113.4 | 2110.6 | 2111.7 | 1843.0 |
| 2021-10-10 20:00:00 | GC | Futures | 2111.6 | 2116.5 | 2111.6 | 2115.1 | 2844.0 |
| 2021-10-10 21:00:00 | GC | Futures | 2115.1 | 2120.0 | 2113.0 | 2118.9 | 5380.0 |
| 2021-10-10 22:00:00 | GC | Futures | 2118.9 | 2119.3 | 2117.1 | 2117.7 | 2951.0 |
| 2021-10-10 23:00:00 | GC | Futures | 2117.7 | 2118.7 | 2112.2 | 2113.1 | 3708.0 |
| 2021-10-10 18:00:00 | ZN | Futures | 133.867009 | 133.882972 | 133.77123 | 133.81912 | 32664.0 |
| 2021-10-10 19:00:00 | ZN | Futures | 133.81912 | 133.882972 | 133.803156 | 133.851046 | 13667.0 |
| 2021-10-10 20:00:00 | ZN | Futures | 133.867009 | 133.882972 | 133.787193 | 133.803156 | 10638.0 |
| 2021-10-10 21:00:00 | ZN | Futures | 133.787193 | 133.803156 | 133.77123 | 133.787193 | 10582.0 |
| 2021-10-10 22:00:00 | ZN | Futures | 133.77123 | 133.787193 | 133.691414 | 133.707378 | 14854.0 |
| 2021-10-10 23:00:00 | ZN | Futures | 133.691414 | 133.707378 | 133.627562 | 133.675451 | 18975.0 |
> showing 36 of 396 rows — these rows as CSV