PREVIEW / futures_1hour / 2022-11-13
file: by_date/futures_1hour/2022/2022-11-13.parquet size: 20 KB rows: 442
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-11-13 18:00:00 | ES | Futures | 4492.26 | 4503.25 | 4487.18 | 4500.71 | 21841.0 |
| 2022-11-13 19:00:00 | ES | Futures | 4500.71 | 4504.38 | 4493.67 | 4496.77 | 11132.0 |
| 2022-11-13 20:00:00 | ES | Futures | 4496.77 | 4505.51 | 4495.08 | 4497.61 | 13388.0 |
| 2022-11-13 21:00:00 | ES | Futures | 4497.89 | 4500.71 | 4492.82 | 4499.87 | 7786.0 |
| 2022-11-13 22:00:00 | ES | Futures | 4499.87 | 4501.84 | 4497.05 | 4501.28 | 4947.0 |
| 2022-11-13 23:00:00 | ES | Futures | 4501.28 | 4501.28 | 4495.36 | 4497.89 | 4481.0 |
| 2022-11-13 18:00:00 | NQ | Futures | 13551.44 | 13583.04 | 13522.99 | 13573.85 | 8183.0 |
| 2022-11-13 19:00:00 | NQ | Futures | 13573.85 | 13587.07 | 13544.26 | 13555.75 | 5235.0 |
| 2022-11-13 20:00:00 | NQ | Futures | 13556.04 | 13592.24 | 13547.42 | 13555.75 | 7051.0 |
| 2022-11-13 21:00:00 | NQ | Futures | 13556.04 | 13564.08 | 13536.5 | 13560.35 | 3762.0 |
| 2022-11-13 22:00:00 | NQ | Futures | 13560.35 | 13573.27 | 13553.45 | 13567.82 | 2552.0 |
| 2022-11-13 23:00:00 | NQ | Futures | 13567.53 | 13568.68 | 13543.39 | 13548.56 | 2463.0 |
| 2022-11-13 18:00:00 | YM | Futures | 37757.6 | 37842.8 | 37749.7 | 37829.4 | 4228.0 |
| 2022-11-13 19:00:00 | YM | Futures | 37828.3 | 37850.7 | 37782.2 | 37801.3 | 2530.0 |
| 2022-11-13 20:00:00 | YM | Futures | 37802.4 | 37850.7 | 37784.5 | 37800.2 | 3405.0 |
| 2022-11-13 21:00:00 | YM | Futures | 37803.6 | 37822.6 | 37768.8 | 37821.5 | 2092.0 |
| 2022-11-13 22:00:00 | YM | Futures | 37820.4 | 37828.3 | 37793.5 | 37817.0 | 1568.0 |
| 2022-11-13 23:00:00 | YM | Futures | 37818.2 | 37820.4 | 37783.4 | 37809.2 | 1129.0 |
| 2022-11-13 18:00:00 | CL | Futures | 72.29 | 72.9 | 72.06 | 72.85 | 1108.0 |
| 2022-11-13 19:00:00 | CL | Futures | 72.83 | 72.91 | 72.64 | 72.82 | 806.0 |
| 2022-11-13 20:00:00 | CL | Futures | 72.81 | 72.94 | 72.36 | 72.43 | 762.0 |
| 2022-11-13 21:00:00 | CL | Futures | 72.45 | 72.64 | 72.28 | 72.57 | 480.0 |
| 2022-11-13 22:00:00 | CL | Futures | 72.6 | 72.65 | 72.38 | 72.42 | 405.0 |
| 2022-11-13 23:00:00 | CL | Futures | 72.41 | 72.42 | 72.37 | 72.38 | 70.0 |
| 2022-11-13 18:00:00 | GC | Futures | 2089.9 | 2090.4 | 2083.3 | 2086.1 | 5077.0 |
| 2022-11-13 19:00:00 | GC | Futures | 2086.3 | 2088.1 | 2084.4 | 2087.3 | 3002.0 |
| 2022-11-13 20:00:00 | GC | Futures | 2087.4 | 2089.8 | 2084.2 | 2085.4 | 4466.0 |
| 2022-11-13 21:00:00 | GC | Futures | 2085.7 | 2086.5 | 2083.2 | 2085.8 | 3320.0 |
| 2022-11-13 22:00:00 | GC | Futures | 2086.1 | 2090.0 | 2085.9 | 2086.6 | 2689.0 |
| 2022-11-13 23:00:00 | GC | Futures | 2086.6 | 2087.0 | 2081.8 | 2084.0 | 2753.0 |
| 2022-11-13 18:00:00 | ZN | Futures | 115.661153 | 115.693389 | 115.387151 | 115.516093 | 28804.0 |
| 2022-11-13 19:00:00 | ZN | Futures | 115.516093 | 115.628918 | 115.451622 | 115.596682 | 26228.0 |
| 2022-11-13 20:00:00 | ZN | Futures | 115.596682 | 115.645035 | 115.532211 | 115.532211 | 16463.0 |
| 2022-11-13 21:00:00 | ZN | Futures | 115.532211 | 115.580564 | 115.499976 | 115.580564 | 10852.0 |
| 2022-11-13 22:00:00 | ZN | Futures | 115.564447 | 115.628918 | 115.564447 | 115.6128 | 7787.0 |
| 2022-11-13 23:00:00 | ZN | Futures | 115.596682 | 115.6128 | 115.46774 | 115.483858 | 16412.0 |
> showing 36 of 442 rows — these rows as CSV