PREVIEW / futures_1hour / 2021-10-31
file: by_date/futures_1hour/2021/2021-10-31.parquet size: 18 KB rows: 406
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-31 18:00:00 | ES | Futures | 5201.74 | 5207.67 | 5199.48 | 5200.61 | 16083.0 |
| 2021-10-31 19:00:00 | ES | Futures | 5200.89 | 5206.25 | 5195.81 | 5204.28 | 11082.0 |
| 2021-10-31 20:00:00 | ES | Futures | 5204.28 | 5210.21 | 5203.43 | 5206.25 | 12614.0 |
| 2021-10-31 21:00:00 | ES | Futures | 5205.97 | 5205.97 | 5198.07 | 5202.02 | 10745.0 |
| 2021-10-31 22:00:00 | ES | Futures | 5202.02 | 5202.59 | 5199.2 | 5201.74 | 4534.0 |
| 2021-10-31 23:00:00 | ES | Futures | 5201.74 | 5202.3 | 5199.2 | 5199.76 | 3505.0 |
| 2021-10-31 18:00:00 | NQ | Futures | 18415.27 | 18430.34 | 18398.75 | 18401.94 | 6029.0 |
| 2021-10-31 19:00:00 | NQ | Futures | 18401.65 | 18419.04 | 18380.2 | 18408.9 | 3767.0 |
| 2021-10-31 20:00:00 | NQ | Futures | 18411.79 | 18442.8 | 18405.71 | 18430.63 | 5038.0 |
| 2021-10-31 21:00:00 | NQ | Futures | 18430.05 | 18430.63 | 18394.98 | 18406.0 | 3703.0 |
| 2021-10-31 22:00:00 | NQ | Futures | 18406.0 | 18408.9 | 18397.3 | 18408.03 | 1857.0 |
| 2021-10-31 23:00:00 | NQ | Futures | 18407.74 | 18408.32 | 18398.17 | 18399.91 | 1223.0 |
| 2021-10-31 18:00:00 | YM | Futures | 40124.0 | 40158.7 | 40071.3 | 40107.2 | 3020.0 |
| 2021-10-31 19:00:00 | YM | Futures | 40107.2 | 40144.2 | 40074.7 | 40134.1 | 2390.0 |
| 2021-10-31 20:00:00 | YM | Futures | 40135.2 | 40182.3 | 40125.1 | 40139.7 | 2276.0 |
| 2021-10-31 21:00:00 | YM | Futures | 40137.5 | 40146.4 | 40096.0 | 40124.0 | 1986.0 |
| 2021-10-31 22:00:00 | YM | Futures | 40125.1 | 40134.1 | 40108.3 | 40124.0 | 779.0 |
| 2021-10-31 23:00:00 | YM | Futures | 40125.1 | 40131.8 | 40106.1 | 40109.4 | 531.0 |
| 2021-10-31 18:00:00 | CL | Futures | 58.26 | 58.27 | 57.95 | 58.02 | 4215.0 |
| 2021-10-31 19:00:00 | CL | Futures | 58.0 | 58.03 | 57.83 | 57.99 | 3038.0 |
| 2021-10-31 20:00:00 | CL | Futures | 58.0 | 58.18 | 57.98 | 58.06 | 3202.0 |
| 2021-10-31 21:00:00 | CL | Futures | 58.06 | 58.32 | 57.92 | 58.26 | 8708.0 |
| 2021-10-31 22:00:00 | CL | Futures | 58.27 | 58.3 | 58.06 | 58.09 | 4221.0 |
| 2021-10-31 23:00:00 | CL | Futures | 58.1 | 58.18 | 58.06 | 58.1 | 2205.0 |
| 2021-10-31 18:00:00 | GC | Futures | 2149.1 | 2149.1 | 2144.7 | 2145.3 | 1928.0 |
| 2021-10-31 19:00:00 | GC | Futures | 2145.4 | 2146.0 | 2143.0 | 2144.1 | 1109.0 |
| 2021-10-31 20:00:00 | GC | Futures | 2144.3 | 2147.2 | 2144.1 | 2146.0 | 1784.0 |
| 2021-10-31 21:00:00 | GC | Futures | 2145.8 | 2149.6 | 2144.2 | 2149.1 | 3741.0 |
| 2021-10-31 22:00:00 | GC | Futures | 2149.2 | 2153.0 | 2149.2 | 2151.3 | 3796.0 |
| 2021-10-31 23:00:00 | GC | Futures | 2151.3 | 2152.0 | 2148.9 | 2149.6 | 1743.0 |
| 2021-10-31 18:00:00 | ZN | Futures | 133.46793 | 133.483893 | 133.324262 | 133.388114 | 18776.0 |
| 2021-10-31 19:00:00 | ZN | Futures | 133.388114 | 133.420041 | 133.356188 | 133.372151 | 13447.0 |
| 2021-10-31 20:00:00 | ZN | Futures | 133.356188 | 133.404078 | 133.324262 | 133.372151 | 20883.0 |
| 2021-10-31 21:00:00 | ZN | Futures | 133.372151 | 133.388114 | 133.324262 | 133.340225 | 17970.0 |
| 2021-10-31 22:00:00 | ZN | Futures | 133.340225 | 133.388114 | 133.324262 | 133.356188 | 11297.0 |
| 2021-10-31 23:00:00 | ZN | Futures | 133.372151 | 133.372151 | 133.276372 | 133.324262 | 10758.0 |
> showing 36 of 406 rows — these rows as CSV