PREVIEW / futures_1hour / 2023-10-29
file: by_date/futures_1hour/2023/2023-10-29.parquet size: 19 KB rows: 423
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-29 18:00:00 | ES | Futures | 4505.7 | 4511.4 | 4500.81 | 4508.68 | 18663.0 |
| 2023-10-29 19:00:00 | ES | Futures | 4508.41 | 4508.96 | 4504.07 | 4507.33 | 7142.0 |
| 2023-10-29 20:00:00 | ES | Futures | 4507.33 | 4511.94 | 4505.97 | 4511.94 | 9351.0 |
| 2023-10-29 21:00:00 | ES | Futures | 4511.94 | 4512.76 | 4507.05 | 4511.94 | 10704.0 |
| 2023-10-29 22:00:00 | ES | Futures | 4511.67 | 4511.94 | 4507.33 | 4509.5 | 5299.0 |
| 2023-10-29 23:00:00 | ES | Futures | 4509.5 | 4511.67 | 4507.87 | 4510.58 | 3818.0 |
| 2023-10-29 18:00:00 | NQ | Futures | 15750.34 | 15760.78 | 15714.09 | 15742.1 | 7918.0 |
| 2023-10-29 19:00:00 | NQ | Futures | 15741.55 | 15747.32 | 15729.74 | 15745.95 | 2970.0 |
| 2023-10-29 20:00:00 | NQ | Futures | 15745.95 | 15756.11 | 15739.08 | 15754.19 | 4572.0 |
| 2023-10-29 21:00:00 | NQ | Futures | 15753.64 | 15767.65 | 15739.08 | 15760.23 | 5541.0 |
| 2023-10-29 22:00:00 | NQ | Futures | 15759.68 | 15761.88 | 15741.0 | 15749.24 | 3108.0 |
| 2023-10-29 23:00:00 | NQ | Futures | 15748.7 | 15758.58 | 15743.2 | 15755.84 | 2279.0 |
| 2023-10-29 18:00:00 | YM | Futures | 35301.4 | 35337.1 | 35262.3 | 35317.6 | 3341.0 |
| 2023-10-29 19:00:00 | YM | Futures | 35317.6 | 35322.0 | 35289.4 | 35311.1 | 985.0 |
| 2023-10-29 20:00:00 | YM | Futures | 35311.1 | 35361.0 | 35308.9 | 35361.0 | 1911.0 |
| 2023-10-29 21:00:00 | YM | Futures | 35358.8 | 35362.1 | 35326.3 | 35354.5 | 1533.0 |
| 2023-10-29 22:00:00 | YM | Futures | 35353.4 | 35354.5 | 35323.0 | 35332.8 | 746.0 |
| 2023-10-29 23:00:00 | YM | Futures | 35332.8 | 35346.9 | 35324.1 | 35340.4 | 701.0 |
| 2023-10-29 18:00:00 | CL | Futures | 71.33 | 71.59 | 70.25 | 70.79 | 6442.0 |
| 2023-10-29 19:00:00 | CL | Futures | 70.77 | 71.05 | 70.72 | 70.95 | 1741.0 |
| 2023-10-29 20:00:00 | CL | Futures | 70.96 | 71.26 | 70.94 | 71.13 | 1986.0 |
| 2023-10-29 21:00:00 | CL | Futures | 71.13 | 71.32 | 71.03 | 71.05 | 2556.0 |
| 2023-10-29 22:00:00 | CL | Futures | 71.04 | 71.07 | 70.84 | 70.96 | 2151.0 |
| 2023-10-29 23:00:00 | CL | Futures | 70.95 | 70.96 | 70.64 | 70.69 | 2208.0 |
| 2023-10-29 18:00:00 | GC | Futures | 2249.0 | 2252.6 | 2241.9 | 2246.7 | 8881.0 |
| 2023-10-29 19:00:00 | GC | Futures | 2246.8 | 2249.3 | 2245.8 | 2248.2 | 3018.0 |
| 2023-10-29 20:00:00 | GC | Futures | 2248.2 | 2252.7 | 2247.7 | 2250.2 | 4005.0 |
| 2023-10-29 21:00:00 | GC | Futures | 2250.3 | 2251.7 | 2247.8 | 2250.0 | 3678.0 |
| 2023-10-29 22:00:00 | GC | Futures | 2250.0 | 2250.5 | 2247.1 | 2247.9 | 2705.0 |
| 2023-10-29 23:00:00 | GC | Futures | 2247.9 | 2248.7 | 2246.3 | 2247.0 | 2012.0 |
| 2023-10-29 18:00:00 | ZN | Futures | 108.101413 | 108.101413 | 107.895113 | 107.910982 | 23166.0 |
| 2023-10-29 19:00:00 | ZN | Futures | 107.910982 | 107.926851 | 107.847505 | 107.863374 | 10496.0 |
| 2023-10-29 20:00:00 | ZN | Futures | 107.863374 | 107.95859 | 107.831636 | 107.94272 | 16210.0 |
| 2023-10-29 21:00:00 | ZN | Futures | 107.926851 | 107.95859 | 107.910982 | 107.926851 | 10841.0 |
| 2023-10-29 22:00:00 | ZN | Futures | 107.926851 | 107.95859 | 107.895113 | 107.895113 | 5120.0 |
| 2023-10-29 23:00:00 | ZN | Futures | 107.895113 | 107.926851 | 107.879243 | 107.895113 | 6260.0 |
> showing 36 of 423 rows — these rows as CSV