PREVIEW / futures_1hour / 2022-05-15
file: by_date/futures_1hour/2022/2022-05-15.parquet size: 20 KB rows: 425
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-05-15 18:00:00 | ES | Futures | 4563.39 | 4579.83 | 4556.3 | 4574.44 | 15559.0 |
| 2022-05-15 19:00:00 | ES | Futures | 4574.44 | 4582.66 | 4567.92 | 4575.29 | 12731.0 |
| 2022-05-15 20:00:00 | ES | Futures | 4575.29 | 4576.14 | 4563.1 | 4569.62 | 16775.0 |
| 2022-05-15 21:00:00 | ES | Futures | 4569.62 | 4574.44 | 4545.81 | 4547.8 | 16622.0 |
| 2022-05-15 22:00:00 | ES | Futures | 4548.08 | 4548.08 | 4520.02 | 4531.08 | 27257.0 |
| 2022-05-15 23:00:00 | ES | Futures | 4531.08 | 4533.34 | 4514.35 | 4525.69 | 14199.0 |
| 2022-05-15 18:00:00 | NQ | Futures | 14393.2 | 14485.41 | 14370.58 | 14446.85 | 9256.0 |
| 2022-05-15 19:00:00 | NQ | Futures | 14447.43 | 14497.3 | 14420.17 | 14462.51 | 6766.0 |
| 2022-05-15 20:00:00 | NQ | Futures | 14461.64 | 14465.99 | 14417.85 | 14450.91 | 6201.0 |
| 2022-05-15 21:00:00 | NQ | Futures | 14450.62 | 14464.83 | 14355.21 | 14362.75 | 7000.0 |
| 2022-05-15 22:00:00 | NQ | Futures | 14361.88 | 14362.75 | 14258.94 | 14283.3 | 12504.0 |
| 2022-05-15 23:00:00 | NQ | Futures | 14284.75 | 14292.87 | 14192.83 | 14254.3 | 7957.0 |
| 2022-05-15 18:00:00 | YM | Futures | 36241.4 | 36349.7 | 36194.1 | 36314.7 | 1973.0 |
| 2022-05-15 19:00:00 | YM | Futures | 36315.8 | 36366.6 | 36284.3 | 36330.5 | 1782.0 |
| 2022-05-15 20:00:00 | YM | Futures | 36328.2 | 36336.1 | 36236.9 | 36274.1 | 2513.0 |
| 2022-05-15 21:00:00 | YM | Futures | 36278.6 | 36311.3 | 36116.3 | 36132.1 | 2391.0 |
| 2022-05-15 22:00:00 | YM | Futures | 36135.5 | 36135.5 | 35943.8 | 36039.6 | 4310.0 |
| 2022-05-15 23:00:00 | YM | Futures | 36038.5 | 36052.0 | 35942.7 | 36010.3 | 1967.0 |
| 2022-05-15 18:00:00 | CL | Futures | 82.57 | 83.07 | 82.32 | 82.87 | 1613.0 |
| 2022-05-15 19:00:00 | CL | Futures | 82.87 | 83.03 | 82.67 | 82.95 | 332.0 |
| 2022-05-15 20:00:00 | CL | Futures | 82.94 | 83.19 | 82.35 | 82.57 | 1029.0 |
| 2022-05-15 21:00:00 | CL | Futures | 82.58 | 82.95 | 81.56 | 81.62 | 1920.0 |
| 2022-05-15 22:00:00 | CL | Futures | 81.6 | 81.62 | 81.04 | 81.28 | 1392.0 |
| 2022-05-15 23:00:00 | CL | Futures | 81.28 | 81.39 | 80.84 | 81.12 | 647.0 |
| 2022-05-15 18:00:00 | GC | Futures | 2166.6 | 2170.2 | 2165.4 | 2167.0 | 2725.0 |
| 2022-05-15 19:00:00 | GC | Futures | 2166.9 | 2170.2 | 2165.1 | 2169.4 | 3229.0 |
| 2022-05-15 20:00:00 | GC | Futures | 2169.3 | 2172.8 | 2167.2 | 2172.4 | 2561.0 |
| 2022-05-15 21:00:00 | GC | Futures | 2172.4 | 2174.2 | 2170.1 | 2170.5 | 4315.0 |
| 2022-05-15 22:00:00 | GC | Futures | 2170.3 | 2170.3 | 2165.2 | 2167.5 | 4212.0 |
| 2022-05-15 23:00:00 | GC | Futures | 2167.3 | 2168.7 | 2164.2 | 2165.7 | 2222.0 |
| 2022-05-15 18:00:00 | ZN | Futures | 122.380352 | 122.412435 | 122.300144 | 122.316186 | 6960.0 |
| 2022-05-15 19:00:00 | ZN | Futures | 122.332227 | 122.332227 | 122.268061 | 122.316186 | 6399.0 |
| 2022-05-15 20:00:00 | ZN | Futures | 122.316186 | 122.332227 | 122.219937 | 122.268061 | 17052.0 |
| 2022-05-15 21:00:00 | ZN | Futures | 122.25202 | 122.412435 | 122.219937 | 122.380352 | 15702.0 |
| 2022-05-15 22:00:00 | ZN | Futures | 122.396393 | 122.749305 | 122.396393 | 122.524725 | 36559.0 |
| 2022-05-15 23:00:00 | ZN | Futures | 122.524725 | 122.701181 | 122.524725 | 122.637015 | 15363.0 |
> showing 36 of 425 rows — these rows as CSV