PREVIEW / futures_1hour / 2024-02-18
file: by_date/futures_1hour/2024/2024-02-18.parquet size: 17 KB rows: 374
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-18 18:00:00 | ES | Futures | 5389.54 | 5399.21 | 5389.27 | 5398.13 | 8461.0 |
| 2024-02-18 19:00:00 | ES | Futures | 5398.13 | 5401.63 | 5396.25 | 5401.09 | 6101.0 |
| 2024-02-18 20:00:00 | ES | Futures | 5401.36 | 5403.51 | 5392.22 | 5395.72 | 9692.0 |
| 2024-02-18 21:00:00 | ES | Futures | 5395.72 | 5397.33 | 5394.11 | 5395.99 | 3946.0 |
| 2024-02-18 22:00:00 | ES | Futures | 5395.72 | 5397.6 | 5394.37 | 5395.72 | 2348.0 |
| 2024-02-18 23:00:00 | ES | Futures | 5395.72 | 5398.13 | 5395.18 | 5397.6 | 1927.0 |
| 2024-02-18 18:00:00 | NQ | Futures | 19233.09 | 19301.97 | 19229.83 | 19284.89 | 6486.0 |
| 2024-02-18 19:00:00 | NQ | Futures | 19285.7 | 19305.5 | 19280.55 | 19303.33 | 3340.0 |
| 2024-02-18 20:00:00 | NQ | Futures | 19303.33 | 19313.64 | 19252.07 | 19275.94 | 6217.0 |
| 2024-02-18 21:00:00 | NQ | Futures | 19274.31 | 19284.89 | 19266.18 | 19272.96 | 2714.0 |
| 2024-02-18 22:00:00 | NQ | Futures | 19273.23 | 19283.53 | 19271.33 | 19275.4 | 1883.0 |
| 2024-02-18 23:00:00 | NQ | Futures | 19275.13 | 19291.67 | 19272.96 | 19286.52 | 1618.0 |
| 2024-02-18 18:00:00 | YM | Futures | 41521.7 | 41588.3 | 41521.7 | 41580.8 | 1096.0 |
| 2024-02-18 19:00:00 | YM | Futures | 41580.8 | 41602.2 | 41572.2 | 41601.2 | 663.0 |
| 2024-02-18 20:00:00 | YM | Futures | 41602.2 | 41613.0 | 41565.7 | 41587.2 | 1137.0 |
| 2024-02-18 21:00:00 | YM | Futures | 41586.1 | 41589.4 | 41576.5 | 41580.8 | 412.0 |
| 2024-02-18 22:00:00 | YM | Futures | 41582.9 | 41590.4 | 41572.2 | 41574.3 | 384.0 |
| 2024-02-18 23:00:00 | YM | Futures | 41574.3 | 41589.4 | 41574.3 | 41587.2 | 260.0 |
| 2024-02-18 18:00:00 | CL | Futures | 65.57 | 65.57 | 65.29 | 65.42 | 2070.0 |
| 2024-02-18 19:00:00 | CL | Futures | 65.41 | 65.47 | 65.33 | 65.34 | 1477.0 |
| 2024-02-18 20:00:00 | CL | Futures | 65.35 | 65.35 | 65.0 | 65.23 | 5758.0 |
| 2024-02-18 21:00:00 | CL | Futures | 65.24 | 65.24 | 65.12 | 65.17 | 1732.0 |
| 2024-02-18 22:00:00 | CL | Futures | 65.18 | 65.27 | 65.16 | 65.17 | 1059.0 |
| 2024-02-18 23:00:00 | CL | Futures | 65.18 | 65.2 | 65.15 | 65.16 | 603.0 |
| 2024-02-18 18:00:00 | GC | Futures | 2222.5 | 2222.8 | 2218.3 | 2220.3 | 4279.0 |
| 2024-02-18 19:00:00 | GC | Futures | 2220.3 | 2228.1 | 2220.3 | 2225.6 | 4776.0 |
| 2024-02-18 20:00:00 | GC | Futures | 2225.8 | 2227.8 | 2222.9 | 2226.3 | 9551.0 |
| 2024-02-18 21:00:00 | GC | Futures | 2226.3 | 2229.7 | 2225.0 | 2229.0 | 3454.0 |
| 2024-02-18 22:00:00 | GC | Futures | 2229.0 | 2229.0 | 2225.5 | 2226.3 | 1966.0 |
| 2024-02-18 23:00:00 | GC | Futures | 2226.3 | 2226.3 | 2224.6 | 2225.4 | 1632.0 |
| 2024-02-18 18:00:00 | ZN | Futures | 111.309097 | 111.340777 | 111.229896 | 111.277416 | 14508.0 |
| 2024-02-18 19:00:00 | ZN | Futures | 111.261576 | 111.340777 | 111.261576 | 111.324937 | 8915.0 |
| 2024-02-18 20:00:00 | ZN | Futures | 111.324937 | 111.356617 | 111.309097 | 111.309097 | 11859.0 |
| 2024-02-18 21:00:00 | ZN | Futures | 111.309097 | 111.324937 | 111.309097 | 111.309097 | 2384.0 |
| 2024-02-18 22:00:00 | ZN | Futures | 111.309097 | 111.324937 | 111.293257 | 111.293257 | 2700.0 |
| 2024-02-18 23:00:00 | ZN | Futures | 111.293257 | 111.309097 | 111.277416 | 111.293257 | 5597.0 |
> showing 36 of 374 rows — these rows as CSV