PREVIEW / futures_1hour / 2023-01-22
file: by_date/futures_1hour/2023/2023-01-22.parquet size: 19 KB rows: 420
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-01-22 18:00:00 | ES | Futures | 4459.17 | 4462.52 | 4452.73 | 4454.97 | 9105.0 |
| 2023-01-22 19:00:00 | ES | Futures | 4454.97 | 4457.77 | 4452.18 | 4454.97 | 10843.0 |
| 2023-01-22 20:00:00 | ES | Futures | 4454.97 | 4458.61 | 4454.13 | 4456.93 | 5682.0 |
| 2023-01-22 21:00:00 | ES | Futures | 4456.93 | 4459.44 | 4454.69 | 4456.09 | 3810.0 |
| 2023-01-22 22:00:00 | ES | Futures | 4455.81 | 4458.05 | 4455.81 | 4456.65 | 2469.0 |
| 2023-01-22 23:00:00 | ES | Futures | 4456.65 | 4458.05 | 4454.69 | 4457.49 | 3708.0 |
| 2023-01-22 18:00:00 | NQ | Futures | 13287.86 | 13297.54 | 13257.99 | 13266.53 | 5175.0 |
| 2023-01-22 19:00:00 | NQ | Futures | 13266.53 | 13277.91 | 13258.28 | 13266.81 | 3319.0 |
| 2023-01-22 20:00:00 | NQ | Futures | 13266.53 | 13277.62 | 13263.97 | 13271.93 | 1602.0 |
| 2023-01-22 21:00:00 | NQ | Futures | 13272.5 | 13283.6 | 13269.94 | 13273.92 | 1401.0 |
| 2023-01-22 22:00:00 | NQ | Futures | 13273.92 | 13280.75 | 13271.65 | 13275.92 | 1041.0 |
| 2023-01-22 23:00:00 | NQ | Futures | 13275.92 | 13279.61 | 13267.38 | 13276.77 | 1849.0 |
| 2023-01-22 18:00:00 | YM | Futures | 37292.8 | 37309.5 | 37243.8 | 37260.5 | 1403.0 |
| 2023-01-22 19:00:00 | YM | Futures | 37261.6 | 37268.3 | 37225.9 | 37257.1 | 1283.0 |
| 2023-01-22 20:00:00 | YM | Futures | 37256.0 | 37281.6 | 37253.8 | 37267.2 | 799.0 |
| 2023-01-22 21:00:00 | YM | Futures | 37267.2 | 37282.8 | 37259.4 | 37268.3 | 684.0 |
| 2023-01-22 22:00:00 | YM | Futures | 37268.3 | 37281.6 | 37267.2 | 37273.8 | 556.0 |
| 2023-01-22 23:00:00 | YM | Futures | 37272.7 | 37285.0 | 37261.6 | 37283.9 | 721.0 |
| 2023-01-22 18:00:00 | CL | Futures | 66.71 | 66.79 | 66.19 | 66.26 | 3501.0 |
| 2023-01-22 19:00:00 | CL | Futures | 66.26 | 66.39 | 66.17 | 66.39 | 1786.0 |
| 2023-01-22 20:00:00 | CL | Futures | 66.39 | 66.48 | 66.25 | 66.3 | 1372.0 |
| 2023-01-22 21:00:00 | CL | Futures | 66.3 | 66.36 | 66.18 | 66.28 | 885.0 |
| 2023-01-22 22:00:00 | CL | Futures | 66.29 | 66.38 | 66.25 | 66.34 | 736.0 |
| 2023-01-22 23:00:00 | CL | Futures | 66.34 | 66.43 | 66.3 | 66.41 | 822.0 |
| 2023-01-22 18:00:00 | GC | Futures | 2258.7 | 2259.9 | 2255.1 | 2258.8 | 1796.0 |
| 2023-01-22 19:00:00 | GC | Futures | 2258.9 | 2264.8 | 2258.8 | 2264.7 | 3217.0 |
| 2023-01-22 20:00:00 | GC | Futures | 2264.3 | 2266.3 | 2262.3 | 2264.7 | 3904.0 |
| 2023-01-22 21:00:00 | GC | Futures | 2264.7 | 2268.4 | 2264.1 | 2264.1 | 3147.0 |
| 2023-01-22 22:00:00 | GC | Futures | 2264.2 | 2265.7 | 2262.8 | 2262.9 | 1666.0 |
| 2023-01-22 23:00:00 | GC | Futures | 2262.8 | 2263.6 | 2260.6 | 2261.6 | 1716.0 |
| 2023-01-22 18:00:00 | ZN | Futures | 118.497441 | 118.561824 | 118.481345 | 118.497441 | 10050.0 |
| 2023-01-22 19:00:00 | ZN | Futures | 118.513537 | 118.57792 | 118.513537 | 118.57792 | 5344.0 |
| 2023-01-22 20:00:00 | ZN | Futures | 118.57792 | 118.674495 | 118.561824 | 118.626207 | 12268.0 |
| 2023-01-22 21:00:00 | ZN | Futures | 118.626207 | 118.642303 | 118.610111 | 118.626207 | 2572.0 |
| 2023-01-22 22:00:00 | ZN | Futures | 118.626207 | 118.658399 | 118.626207 | 118.626207 | 3489.0 |
| 2023-01-22 23:00:00 | ZN | Futures | 118.642303 | 118.658399 | 118.626207 | 118.658399 | 4387.0 |
> showing 36 of 420 rows — these rows as CSV