PREVIEW / futures_1hour / 2022-08-14
file: by_date/futures_1hour/2022/2022-08-14.parquet size: 19 KB rows: 411
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-08-14 18:00:00 | ES | Futures | 4846.21 | 4847.91 | 4840.54 | 4841.96 | 7177.0 |
| 2022-08-14 19:00:00 | ES | Futures | 4841.96 | 4845.08 | 4836.58 | 4837.14 | 5399.0 |
| 2022-08-14 20:00:00 | ES | Futures | 4837.14 | 4843.38 | 4837.14 | 4839.98 | 6432.0 |
| 2022-08-14 21:00:00 | ES | Futures | 4839.98 | 4845.08 | 4836.01 | 4844.79 | 9613.0 |
| 2022-08-14 22:00:00 | ES | Futures | 4844.79 | 4845.08 | 4836.29 | 4837.14 | 6363.0 |
| 2022-08-14 23:00:00 | ES | Futures | 4837.14 | 4841.11 | 4836.58 | 4839.98 | 4153.0 |
| 2022-08-14 18:00:00 | NQ | Futures | 15701.63 | 15705.1 | 15670.97 | 15681.38 | 3496.0 |
| 2022-08-14 19:00:00 | NQ | Futures | 15680.52 | 15694.98 | 15663.45 | 15665.48 | 2716.0 |
| 2022-08-14 20:00:00 | NQ | Futures | 15666.34 | 15686.01 | 15665.19 | 15674.73 | 3298.0 |
| 2022-08-14 21:00:00 | NQ | Futures | 15674.15 | 15688.33 | 15652.75 | 15685.72 | 4230.0 |
| 2022-08-14 22:00:00 | NQ | Futures | 15685.72 | 15688.62 | 15659.11 | 15664.32 | 3337.0 |
| 2022-08-14 23:00:00 | NQ | Futures | 15664.32 | 15677.05 | 15659.11 | 15670.68 | 1851.0 |
| 2022-08-14 18:00:00 | YM | Futures | 38034.2 | 38038.7 | 37969.9 | 37982.3 | 1442.0 |
| 2022-08-14 19:00:00 | YM | Futures | 37978.9 | 37994.7 | 37942.8 | 37943.9 | 766.0 |
| 2022-08-14 20:00:00 | YM | Futures | 37946.2 | 37993.6 | 37946.2 | 37966.5 | 1050.0 |
| 2022-08-14 21:00:00 | YM | Futures | 37967.6 | 38006.0 | 37945.1 | 37999.2 | 1175.0 |
| 2022-08-14 22:00:00 | YM | Futures | 38000.4 | 38001.5 | 37941.7 | 37949.6 | 1034.0 |
| 2022-08-14 23:00:00 | YM | Futures | 37949.6 | 37974.4 | 37947.3 | 37971.0 | 724.0 |
| 2022-08-14 18:00:00 | CL | Futures | 72.98 | 73.12 | 72.76 | 72.77 | 248.0 |
| 2022-08-14 19:00:00 | CL | Futures | 72.77 | 72.89 | 72.69 | 72.7 | 192.0 |
| 2022-08-14 20:00:00 | CL | Futures | 72.71 | 73.01 | 72.65 | 72.93 | 358.0 |
| 2022-08-14 21:00:00 | CL | Futures | 72.91 | 73.02 | 72.42 | 72.7 | 674.0 |
| 2022-08-14 22:00:00 | CL | Futures | 72.73 | 72.73 | 72.31 | 72.39 | 514.0 |
| 2022-08-14 23:00:00 | CL | Futures | 72.38 | 72.5 | 72.35 | 72.5 | 184.0 |
| 2022-08-14 18:00:00 | GC | Futures | 2148.4 | 2148.4 | 2144.6 | 2145.4 | 1442.0 |
| 2022-08-14 19:00:00 | GC | Futures | 2145.3 | 2145.7 | 2143.9 | 2143.9 | 1297.0 |
| 2022-08-14 20:00:00 | GC | Futures | 2143.9 | 2146.8 | 2143.4 | 2146.4 | 1791.0 |
| 2022-08-14 21:00:00 | GC | Futures | 2146.3 | 2147.1 | 2140.9 | 2141.8 | 3438.0 |
| 2022-08-14 22:00:00 | GC | Futures | 2141.6 | 2141.6 | 2138.6 | 2140.2 | 2791.0 |
| 2022-08-14 23:00:00 | GC | Futures | 2140.2 | 2140.9 | 2137.4 | 2139.2 | 1984.0 |
| 2022-08-14 18:00:00 | ZN | Futures | 123.107565 | 123.172036 | 123.043094 | 123.139801 | 6041.0 |
| 2022-08-14 19:00:00 | ZN | Futures | 123.123683 | 123.123683 | 123.07533 | 123.107565 | 4313.0 |
| 2022-08-14 20:00:00 | ZN | Futures | 123.123683 | 123.139801 | 123.07533 | 123.091448 | 3922.0 |
| 2022-08-14 21:00:00 | ZN | Futures | 123.091448 | 123.123683 | 123.010859 | 123.010859 | 6526.0 |
| 2022-08-14 22:00:00 | ZN | Futures | 123.010859 | 123.123683 | 123.010859 | 123.091448 | 6749.0 |
| 2022-08-14 23:00:00 | ZN | Futures | 123.091448 | 123.172036 | 123.07533 | 123.155919 | 6929.0 |
> showing 36 of 411 rows — these rows as CSV