PREVIEW / futures_1hour / 2022-11-20
file: by_date/futures_1hour/2022/2022-11-20.parquet size: 20 KB rows: 433
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-20 18:00:00 | ES | Futures | 4479.29 | 4490.0 | 4473.93 | 4475.62 | 9505.0 |
| 2022-11-20 19:00:00 | ES | Futures | 4475.62 | 4477.32 | 4467.73 | 4469.14 | 8131.0 |
| 2022-11-20 20:00:00 | ES | Futures | 4469.14 | 4470.27 | 4462.66 | 4464.63 | 13208.0 |
| 2022-11-20 21:00:00 | ES | Futures | 4464.91 | 4466.6 | 4460.68 | 4465.76 | 8129.0 |
| 2022-11-20 22:00:00 | ES | Futures | 4465.76 | 4468.3 | 4463.79 | 4467.73 | 5311.0 |
| 2022-11-20 23:00:00 | ES | Futures | 4467.73 | 4470.27 | 4465.76 | 4468.01 | 5259.0 |
| 2022-11-20 18:00:00 | NQ | Futures | 13473.29 | 13511.21 | 13448.86 | 13456.05 | 5270.0 |
| 2022-11-20 19:00:00 | NQ | Futures | 13457.48 | 13463.52 | 13424.44 | 13429.04 | 4077.0 |
| 2022-11-20 20:00:00 | NQ | Futures | 13429.61 | 13433.92 | 13404.9 | 13411.8 | 5183.0 |
| 2022-11-20 21:00:00 | NQ | Futures | 13409.79 | 13421.28 | 13398.87 | 13418.69 | 3401.0 |
| 2022-11-20 22:00:00 | NQ | Futures | 13418.69 | 13427.89 | 13413.81 | 13425.88 | 2817.0 |
| 2022-11-20 23:00:00 | NQ | Futures | 13425.01 | 13433.35 | 13414.96 | 13423.0 | 2418.0 |
| 2022-11-20 18:00:00 | YM | Futures | 37888.9 | 37951.7 | 37832.7 | 37859.7 | 1397.0 |
| 2022-11-20 19:00:00 | YM | Futures | 37861.9 | 37872.0 | 37803.6 | 37810.3 | 1059.0 |
| 2022-11-20 20:00:00 | YM | Futures | 37809.2 | 37820.4 | 37776.6 | 37798.0 | 1723.0 |
| 2022-11-20 21:00:00 | YM | Futures | 37790.1 | 37804.7 | 37764.3 | 37800.2 | 1126.0 |
| 2022-11-20 22:00:00 | YM | Futures | 37801.3 | 37820.4 | 37769.9 | 37810.3 | 1011.0 |
| 2022-11-20 23:00:00 | YM | Futures | 37811.4 | 37828.3 | 37787.9 | 37815.9 | 979.0 |
| 2022-11-20 18:00:00 | CL | Futures | 65.75 | 65.95 | 65.66 | 65.7 | 2460.0 |
| 2022-11-20 19:00:00 | CL | Futures | 65.71 | 65.74 | 65.46 | 65.49 | 2066.0 |
| 2022-11-20 20:00:00 | CL | Futures | 65.5 | 65.62 | 64.88 | 65.12 | 6274.0 |
| 2022-11-20 21:00:00 | CL | Futures | 65.12 | 65.21 | 64.89 | 65.06 | 2619.0 |
| 2022-11-20 22:00:00 | CL | Futures | 65.04 | 65.15 | 64.82 | 65.07 | 2177.0 |
| 2022-11-20 23:00:00 | CL | Futures | 65.05 | 65.15 | 64.98 | 65.07 | 1297.0 |
| 2022-11-20 18:00:00 | GC | Futures | 2069.4 | 2072.7 | 2068.7 | 2072.3 | 1671.0 |
| 2022-11-20 19:00:00 | GC | Futures | 2072.0 | 2072.9 | 2068.9 | 2069.7 | 1819.0 |
| 2022-11-20 20:00:00 | GC | Futures | 2069.7 | 2069.7 | 2062.2 | 2064.3 | 4828.0 |
| 2022-11-20 21:00:00 | GC | Futures | 2064.4 | 2064.4 | 2061.3 | 2061.9 | 2091.0 |
| 2022-11-20 22:00:00 | GC | Futures | 2061.8 | 2065.0 | 2061.8 | 2064.9 | 2157.0 |
| 2022-11-20 23:00:00 | GC | Futures | 2064.6 | 2065.7 | 2062.5 | 2063.8 | 1447.0 |
| 2022-11-20 18:00:00 | ZN | Futures | 115.806213 | 115.90292 | 115.773978 | 115.886802 | 11667.0 |
| 2022-11-20 19:00:00 | ZN | Futures | 115.886802 | 115.919038 | 115.822331 | 115.90292 | 7868.0 |
| 2022-11-20 20:00:00 | ZN | Futures | 115.90292 | 116.015744 | 115.90292 | 115.999627 | 9049.0 |
| 2022-11-20 21:00:00 | ZN | Futures | 115.999627 | 116.080215 | 115.983509 | 116.04798 | 16675.0 |
| 2022-11-20 22:00:00 | ZN | Futures | 116.031862 | 116.096333 | 115.999627 | 116.015744 | 7399.0 |
| 2022-11-20 23:00:00 | ZN | Futures | 116.015744 | 116.04798 | 115.967391 | 115.983509 | 7219.0 |
> showing 36 of 433 rows — these rows as CSV