PREVIEW / futures_1hour / 2022-04-17
file: by_date/futures_1hour/2022/2022-04-17.parquet size: 18 KB rows: 370
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-04-17 18:00:00 | ES | Futures | 4977.21 | 4977.21 | 4953.4 | 4957.09 | 16958.0 |
| 2022-04-17 19:00:00 | ES | Futures | 4957.09 | 4957.94 | 4939.23 | 4940.36 | 14495.0 |
| 2022-04-17 20:00:00 | ES | Futures | 4940.65 | 4947.17 | 4938.1 | 4942.06 | 11212.0 |
| 2022-04-17 21:00:00 | ES | Futures | 4942.06 | 4949.43 | 4940.08 | 4946.88 | 8552.0 |
| 2022-04-17 22:00:00 | ES | Futures | 4946.6 | 4948.87 | 4944.05 | 4947.45 | 3849.0 |
| 2022-04-17 23:00:00 | ES | Futures | 4947.73 | 4951.42 | 4944.9 | 4950.28 | 4119.0 |
| 2022-04-17 18:00:00 | NQ | Futures | 16113.33 | 16126.96 | 15998.21 | 16028.66 | 9291.0 |
| 2022-04-17 19:00:00 | NQ | Futures | 16028.66 | 16031.85 | 15924.85 | 15932.1 | 8344.0 |
| 2022-04-17 20:00:00 | NQ | Futures | 15933.26 | 15957.91 | 15928.33 | 15940.8 | 5515.0 |
| 2022-04-17 21:00:00 | NQ | Futures | 15940.8 | 15975.31 | 15939.06 | 15963.42 | 4845.0 |
| 2022-04-17 22:00:00 | NQ | Futures | 15963.71 | 15975.89 | 15950.08 | 15971.83 | 2939.0 |
| 2022-04-17 23:00:00 | NQ | Futures | 15972.7 | 15975.02 | 15948.63 | 15968.93 | 2921.0 |
| 2022-04-17 18:00:00 | YM | Futures | 38745.2 | 38776.8 | 38628.0 | 38638.1 | 3634.0 |
| 2022-04-17 19:00:00 | YM | Futures | 38637.0 | 38640.4 | 38538.9 | 38562.6 | 3051.0 |
| 2022-04-17 20:00:00 | YM | Futures | 38563.7 | 38610.0 | 38536.7 | 38579.5 | 2153.0 |
| 2022-04-17 21:00:00 | YM | Futures | 38579.5 | 38648.3 | 38546.8 | 38626.9 | 3029.0 |
| 2022-04-17 22:00:00 | YM | Futures | 38626.9 | 38647.2 | 38605.4 | 38630.2 | 1382.0 |
| 2022-04-17 23:00:00 | YM | Futures | 38630.2 | 38664.1 | 38606.6 | 38653.9 | 1088.0 |
| 2022-04-17 18:00:00 | CL | Futures | 79.8 | 80.77 | 79.78 | 80.57 | 3461.0 |
| 2022-04-17 19:00:00 | CL | Futures | 80.57 | 80.85 | 80.37 | 80.53 | 1543.0 |
| 2022-04-17 20:00:00 | CL | Futures | 80.51 | 80.71 | 80.29 | 80.66 | 1902.0 |
| 2022-04-17 21:00:00 | CL | Futures | 80.67 | 80.96 | 80.38 | 80.71 | 5194.0 |
| 2022-04-17 22:00:00 | CL | Futures | 80.71 | 80.77 | 80.12 | 80.21 | 3972.0 |
| 2022-04-17 23:00:00 | CL | Futures | 80.22 | 80.53 | 80.14 | 80.51 | 2686.0 |
| 2022-04-17 18:00:00 | GC | Futures | 2369.1 | 2376.9 | 2364.2 | 2373.8 | 3377.0 |
| 2022-04-17 19:00:00 | GC | Futures | 2374.1 | 2386.0 | 2373.3 | 2384.3 | 5002.0 |
| 2022-04-17 20:00:00 | GC | Futures | 2384.4 | 2386.1 | 2380.8 | 2384.7 | 4352.0 |
| 2022-04-17 21:00:00 | GC | Futures | 2384.8 | 2385.9 | 2379.4 | 2382.0 | 4309.0 |
| 2022-04-17 22:00:00 | GC | Futures | 2382.0 | 2382.8 | 2378.6 | 2378.6 | 1904.0 |
| 2022-04-17 23:00:00 | GC | Futures | 2378.6 | 2381.7 | 2378.3 | 2381.2 | 1683.0 |
| 2022-04-17 18:00:00 | ZN | Futures | 122.989927 | 123.02201 | 122.829513 | 122.925762 | 11929.0 |
| 2022-04-17 19:00:00 | ZN | Futures | 122.941803 | 122.957844 | 122.813471 | 122.829513 | 7053.0 |
| 2022-04-17 20:00:00 | ZN | Futures | 122.829513 | 122.877637 | 122.604932 | 122.637015 | 23703.0 |
| 2022-04-17 21:00:00 | ZN | Futures | 122.653057 | 122.877637 | 122.637015 | 122.733264 | 17074.0 |
| 2022-04-17 22:00:00 | ZN | Futures | 122.733264 | 122.765347 | 122.653057 | 122.701181 | 10848.0 |
| 2022-04-17 23:00:00 | ZN | Futures | 122.701181 | 122.765347 | 122.637015 | 122.637015 | 13443.0 |
> showing 36 of 370 rows — these rows as CSV