PREVIEW / futures_1hour / 2023-02-19
file: by_date/futures_1hour/2023/2023-02-19.parquet size: 18 KB rows: 371
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-02-19 18:00:00 | ES | Futures | 4566.53 | 4569.61 | 4558.71 | 4562.06 | 8408.0 |
| 2023-02-19 19:00:00 | ES | Futures | 4562.34 | 4562.62 | 4558.15 | 4560.66 | 5542.0 |
| 2023-02-19 20:00:00 | ES | Futures | 4560.66 | 4567.09 | 4559.82 | 4565.98 | 4913.0 |
| 2023-02-19 21:00:00 | ES | Futures | 4565.98 | 4571.01 | 4565.42 | 4570.17 | 4470.0 |
| 2023-02-19 22:00:00 | ES | Futures | 4570.17 | 4572.13 | 4568.49 | 4570.73 | 3410.0 |
| 2023-02-19 23:00:00 | ES | Futures | 4570.73 | 4573.52 | 4569.33 | 4570.17 | 3261.0 |
| 2023-02-19 18:00:00 | NQ | Futures | 14088.15 | 14091.84 | 14050.02 | 14065.1 | 4195.0 |
| 2023-02-19 19:00:00 | NQ | Futures | 14064.53 | 14065.96 | 14050.31 | 14059.7 | 2434.0 |
| 2023-02-19 20:00:00 | NQ | Futures | 14059.13 | 14083.31 | 14056.85 | 14075.91 | 2752.0 |
| 2023-02-19 21:00:00 | NQ | Futures | 14076.2 | 14101.8 | 14072.5 | 14098.1 | 2857.0 |
| 2023-02-19 22:00:00 | NQ | Futures | 14098.96 | 14109.77 | 14091.56 | 14100.66 | 2181.0 |
| 2023-02-19 23:00:00 | NQ | Futures | 14100.66 | 14118.3 | 14100.38 | 14104.93 | 1903.0 |
| 2023-02-19 18:00:00 | YM | Futures | 37708.4 | 37721.7 | 37666.0 | 37689.4 | 787.0 |
| 2023-02-19 19:00:00 | YM | Futures | 37691.7 | 37693.9 | 37663.8 | 37686.1 | 533.0 |
| 2023-02-19 20:00:00 | YM | Futures | 37687.2 | 37724.0 | 37681.6 | 37715.1 | 651.0 |
| 2023-02-19 21:00:00 | YM | Futures | 37717.3 | 37735.1 | 37708.4 | 37731.8 | 696.0 |
| 2023-02-19 22:00:00 | YM | Futures | 37732.9 | 37742.9 | 37719.5 | 37730.7 | 431.0 |
| 2023-02-19 23:00:00 | YM | Futures | 37730.7 | 37742.9 | 37710.6 | 37720.6 | 767.0 |
| 2023-02-19 18:00:00 | CL | Futures | 62.28 | 62.45 | 62.19 | 62.31 | 1401.0 |
| 2023-02-19 19:00:00 | CL | Futures | 62.32 | 62.35 | 62.12 | 62.17 | 1144.0 |
| 2023-02-19 20:00:00 | CL | Futures | 62.17 | 62.28 | 62.02 | 62.28 | 2664.0 |
| 2023-02-19 21:00:00 | CL | Futures | 62.28 | 62.57 | 62.26 | 62.47 | 2555.0 |
| 2023-02-19 22:00:00 | CL | Futures | 62.47 | 62.67 | 62.42 | 62.59 | 2021.0 |
| 2023-02-19 23:00:00 | CL | Futures | 62.59 | 62.63 | 62.48 | 62.5 | 1113.0 |
| 2023-02-19 18:00:00 | GC | Futures | 2148.8 | 2149.9 | 2145.3 | 2145.6 | 1768.0 |
| 2023-02-19 19:00:00 | GC | Futures | 2145.6 | 2146.4 | 2143.9 | 2145.7 | 1929.0 |
| 2023-02-19 20:00:00 | GC | Futures | 2145.7 | 2149.2 | 2145.0 | 2147.7 | 2984.0 |
| 2023-02-19 21:00:00 | GC | Futures | 2147.5 | 2150.7 | 2146.5 | 2149.7 | 2874.0 |
| 2023-02-19 22:00:00 | GC | Futures | 2149.9 | 2150.7 | 2148.6 | 2150.3 | 1717.0 |
| 2023-02-19 23:00:00 | GC | Futures | 2150.3 | 2152.8 | 2149.9 | 2150.1 | 2386.0 |
| 2023-02-19 18:00:00 | ZN | Futures | 115.358755 | 115.390947 | 115.310468 | 115.310468 | 5352.0 |
| 2023-02-19 19:00:00 | ZN | Futures | 115.310468 | 115.326564 | 115.213893 | 115.229989 | 12108.0 |
| 2023-02-19 20:00:00 | ZN | Futures | 115.229989 | 115.229989 | 115.181701 | 115.197797 | 8119.0 |
| 2023-02-19 21:00:00 | ZN | Futures | 115.197797 | 115.246085 | 115.197797 | 115.246085 | 4071.0 |
| 2023-02-19 22:00:00 | ZN | Futures | 115.229989 | 115.262181 | 115.213893 | 115.262181 | 6070.0 |
| 2023-02-19 23:00:00 | ZN | Futures | 115.246085 | 115.294372 | 115.246085 | 115.262181 | 5058.0 |
> showing 36 of 371 rows — these rows as CSV