PREVIEW / futures_1hour / 2020-12-13
file: by_date/futures_1hour/2020/2020-12-13.parquet size: 17 KB rows: 367
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-13 18:00:00 | ES | Futures | 4120.47 | 4129.15 | 4118.23 | 4121.59 | 10419.0 |
| 2020-12-13 19:00:00 | ES | Futures | 4121.87 | 4124.11 | 4120.47 | 4122.15 | 4137.0 |
| 2020-12-13 20:00:00 | ES | Futures | 4122.15 | 4125.51 | 4121.87 | 4123.55 | 3432.0 |
| 2020-12-13 21:00:00 | ES | Futures | 4123.27 | 4124.39 | 4121.87 | 4122.71 | 1830.0 |
| 2020-12-13 22:00:00 | ES | Futures | 4122.71 | 4125.23 | 4121.59 | 4124.39 | 1897.0 |
| 2020-12-13 23:00:00 | ES | Futures | 4124.39 | 4125.23 | 4122.15 | 4123.83 | 1184.0 |
| 2020-12-13 18:00:00 | NQ | Futures | 14364.02 | 14404.54 | 14360.25 | 14376.75 | 4027.0 |
| 2020-12-13 19:00:00 | NQ | Futures | 14377.62 | 14381.96 | 14365.46 | 14372.7 | 2599.0 |
| 2020-12-13 20:00:00 | NQ | Futures | 14372.12 | 14386.02 | 14371.25 | 14375.31 | 2677.0 |
| 2020-12-13 21:00:00 | NQ | Futures | 14375.31 | 14379.36 | 14372.12 | 14376.17 | 1366.0 |
| 2020-12-13 22:00:00 | NQ | Futures | 14376.75 | 14381.09 | 14371.83 | 14379.65 | 1005.0 |
| 2020-12-13 23:00:00 | NQ | Futures | 14379.07 | 14381.38 | 14376.75 | 14379.94 | 772.0 |
| 2020-12-13 18:00:00 | YM | Futures | 33333.5 | 33438.9 | 33326.9 | 33377.9 | 2315.0 |
| 2020-12-13 19:00:00 | YM | Futures | 33380.1 | 33410.1 | 33371.2 | 33386.8 | 1410.0 |
| 2020-12-13 20:00:00 | YM | Futures | 33385.7 | 33421.2 | 33384.6 | 33404.5 | 1491.0 |
| 2020-12-13 21:00:00 | YM | Futures | 33404.5 | 33413.4 | 33396.8 | 33404.5 | 741.0 |
| 2020-12-13 22:00:00 | YM | Futures | 33404.5 | 33424.5 | 33394.5 | 33417.8 | 684.0 |
| 2020-12-13 23:00:00 | YM | Futures | 33417.8 | 33424.5 | 33396.8 | 33411.2 | 468.0 |
| 2020-12-13 18:00:00 | CL | Futures | 31.76 | 31.82 | 31.64 | 31.72 | 2858.0 |
| 2020-12-13 19:00:00 | CL | Futures | 31.72 | 31.75 | 31.62 | 31.66 | 1514.0 |
| 2020-12-13 20:00:00 | CL | Futures | 31.66 | 31.74 | 31.58 | 31.67 | 2744.0 |
| 2020-12-13 21:00:00 | CL | Futures | 31.67 | 31.72 | 31.64 | 31.7 | 1488.0 |
| 2020-12-13 22:00:00 | CL | Futures | 31.71 | 31.82 | 31.67 | 31.81 | 2386.0 |
| 2020-12-13 23:00:00 | CL | Futures | 31.8 | 31.89 | 31.78 | 31.88 | 2955.0 |
| 2020-12-13 18:00:00 | GC | Futures | 2236.1 | 2236.9 | 2228.9 | 2232.4 | 2860.0 |
| 2020-12-13 19:00:00 | GC | Futures | 2232.4 | 2232.4 | 2228.9 | 2229.3 | 2016.0 |
| 2020-12-13 20:00:00 | GC | Futures | 2229.2 | 2231.8 | 2227.2 | 2228.2 | 4642.0 |
| 2020-12-13 21:00:00 | GC | Futures | 2228.4 | 2231.2 | 2227.8 | 2230.4 | 1876.0 |
| 2020-12-13 22:00:00 | GC | Futures | 2230.4 | 2230.8 | 2228.0 | 2229.7 | 1686.0 |
| 2020-12-13 23:00:00 | GC | Futures | 2229.6 | 2229.9 | 2227.9 | 2229.0 | 751.0 |
| 2020-12-13 18:00:00 | ZN | Futures | 138.22818 | 138.243834 | 138.165563 | 138.22818 | 19531.0 |
| 2020-12-13 19:00:00 | ZN | Futures | 138.212526 | 138.243834 | 138.196871 | 138.22818 | 6827.0 |
| 2020-12-13 20:00:00 | ZN | Futures | 138.22818 | 138.243834 | 138.196871 | 138.22818 | 6718.0 |
| 2020-12-13 21:00:00 | ZN | Futures | 138.212526 | 138.243834 | 138.196871 | 138.22818 | 6638.0 |
| 2020-12-13 22:00:00 | ZN | Futures | 138.22818 | 138.259489 | 138.22818 | 138.243834 | 3314.0 |
| 2020-12-13 23:00:00 | ZN | Futures | 138.243834 | 138.243834 | 138.22818 | 138.243834 | 4124.0 |
> showing 36 of 367 rows — these rows as CSV