PREVIEW / futures_1hour / 2023-04-09
file: by_date/futures_1hour/2023/2023-04-09.parquet size: 17 KB rows: 360
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-04-09 18:00:00 | ES | Futures | 4591.86 | 4596.3 | 4589.64 | 4593.53 | 8316.0 |
| 2023-04-09 19:00:00 | ES | Futures | 4593.53 | 4593.53 | 4586.32 | 4587.43 | 7267.0 |
| 2023-04-09 20:00:00 | ES | Futures | 4587.7 | 4590.48 | 4583.26 | 4584.37 | 10304.0 |
| 2023-04-09 21:00:00 | ES | Futures | 4584.1 | 4586.32 | 4583.26 | 4585.76 | 3993.0 |
| 2023-04-09 22:00:00 | ES | Futures | 4585.76 | 4586.59 | 4581.32 | 4583.82 | 6376.0 |
| 2023-04-09 23:00:00 | ES | Futures | 4583.82 | 4584.37 | 4582.16 | 4582.99 | 2883.0 |
| 2023-04-09 18:00:00 | NQ | Futures | 14843.19 | 14869.66 | 14825.17 | 14845.16 | 5008.0 |
| 2023-04-09 19:00:00 | NQ | Futures | 14845.73 | 14845.73 | 14811.38 | 14817.01 | 4191.0 |
| 2023-04-09 20:00:00 | NQ | Futures | 14817.29 | 14824.61 | 14798.99 | 14802.65 | 4590.0 |
| 2023-04-09 21:00:00 | NQ | Futures | 14802.93 | 14808.84 | 14794.48 | 14801.52 | 3408.0 |
| 2023-04-09 22:00:00 | NQ | Futures | 14801.52 | 14808.28 | 14788.29 | 14798.99 | 3623.0 |
| 2023-04-09 23:00:00 | NQ | Futures | 14799.27 | 14806.87 | 14796.46 | 14799.55 | 2085.0 |
| 2023-04-09 18:00:00 | YM | Futures | 37247.8 | 37275.4 | 37241.2 | 37274.3 | 1456.0 |
| 2023-04-09 19:00:00 | YM | Futures | 37275.4 | 37275.4 | 37242.3 | 37252.2 | 1266.0 |
| 2023-04-09 20:00:00 | YM | Futures | 37252.2 | 37275.4 | 37226.8 | 37232.3 | 1263.0 |
| 2023-04-09 21:00:00 | YM | Futures | 37231.2 | 37250.0 | 37225.7 | 37248.9 | 796.0 |
| 2023-04-09 22:00:00 | YM | Futures | 37248.9 | 37248.9 | 37222.4 | 37229.0 | 770.0 |
| 2023-04-09 23:00:00 | YM | Futures | 37229.0 | 37233.4 | 37216.8 | 37224.6 | 457.0 |
| 2023-04-09 18:00:00 | CL | Futures | 65.29 | 65.87 | 65.29 | 65.71 | 3324.0 |
| 2023-04-09 19:00:00 | CL | Futures | 65.71 | 65.74 | 65.52 | 65.55 | 1300.0 |
| 2023-04-09 20:00:00 | CL | Futures | 65.56 | 65.71 | 65.55 | 65.61 | 1304.0 |
| 2023-04-09 21:00:00 | CL | Futures | 65.61 | 65.74 | 65.38 | 65.52 | 3829.0 |
| 2023-04-09 22:00:00 | CL | Futures | 65.52 | 65.6 | 65.41 | 65.41 | 1563.0 |
| 2023-04-09 23:00:00 | CL | Futures | 65.4 | 65.43 | 65.31 | 65.38 | 1110.0 |
| 2023-04-09 18:00:00 | GC | Futures | 2309.9 | 2324.7 | 2305.9 | 2323.8 | 6304.0 |
| 2023-04-09 19:00:00 | GC | Futures | 2323.8 | 2324.3 | 2322.9 | 2323.8 | 1492.0 |
| 2023-04-09 20:00:00 | GC | Futures | 2323.9 | 2324.2 | 2315.0 | 2315.8 | 3760.0 |
| 2023-04-09 21:00:00 | GC | Futures | 2315.9 | 2318.7 | 2312.5 | 2314.1 | 4611.0 |
| 2023-04-09 22:00:00 | GC | Futures | 2314.3 | 2314.6 | 2304.8 | 2307.4 | 6531.0 |
| 2023-04-09 23:00:00 | GC | Futures | 2307.5 | 2309.3 | 2306.4 | 2307.1 | 2606.0 |
| 2023-04-09 18:00:00 | ZN | Futures | 118.749201 | 118.861395 | 118.733173 | 118.813312 | 6865.0 |
| 2023-04-09 19:00:00 | ZN | Futures | 118.829339 | 118.877422 | 118.813312 | 118.861395 | 5219.0 |
| 2023-04-09 20:00:00 | ZN | Futures | 118.877422 | 118.877422 | 118.765229 | 118.765229 | 13205.0 |
| 2023-04-09 21:00:00 | ZN | Futures | 118.765229 | 118.845367 | 118.733173 | 118.813312 | 10085.0 |
| 2023-04-09 22:00:00 | ZN | Futures | 118.829339 | 118.861395 | 118.797284 | 118.829339 | 5826.0 |
| 2023-04-09 23:00:00 | ZN | Futures | 118.829339 | 118.845367 | 118.813312 | 118.813312 | 2297.0 |
> showing 36 of 360 rows — these rows as CSV