PREVIEW / futures_1hour / 2019-12-08
file: by_date/futures_1hour/2019/2019-12-08.parquet size: 16 KB rows: 347
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-08 18:00:00 | ES | Futures | 3418.75 | 3420.92 | 3418.2 | 3418.48 | 7352.0 |
| 2019-12-08 19:00:00 | ES | Futures | 3418.2 | 3418.48 | 3411.69 | 3412.77 | 17890.0 |
| 2019-12-08 20:00:00 | ES | Futures | 3412.5 | 3414.4 | 3411.14 | 3411.96 | 12522.0 |
| 2019-12-08 21:00:00 | ES | Futures | 3411.96 | 3415.22 | 3411.69 | 3414.4 | 11126.0 |
| 2019-12-08 22:00:00 | ES | Futures | 3414.4 | 3414.4 | 3412.23 | 3413.04 | 4126.0 |
| 2019-12-08 23:00:00 | ES | Futures | 3413.04 | 3413.86 | 3412.23 | 3412.77 | 2260.0 |
| 2019-12-08 18:00:00 | NQ | Futures | 9762.28 | 9777.97 | 9761.7 | 9765.48 | 2325.0 |
| 2019-12-08 19:00:00 | NQ | Futures | 9764.9 | 9764.9 | 9741.08 | 9745.73 | 6192.0 |
| 2019-12-08 20:00:00 | NQ | Futures | 9745.44 | 9750.08 | 9737.88 | 9740.5 | 6118.0 |
| 2019-12-08 21:00:00 | NQ | Futures | 9740.5 | 9752.99 | 9739.92 | 9749.79 | 4604.0 |
| 2019-12-08 22:00:00 | NQ | Futures | 9749.79 | 9750.37 | 9742.24 | 9745.15 | 1818.0 |
| 2019-12-08 23:00:00 | NQ | Futures | 9745.15 | 9747.76 | 9742.53 | 9744.56 | 1054.0 |
| 2019-12-08 18:00:00 | YM | Futures | 30495.6 | 30525.0 | 30495.6 | 30498.9 | 1371.0 |
| 2019-12-08 19:00:00 | YM | Futures | 30496.7 | 30496.7 | 30440.1 | 30451.0 | 4046.0 |
| 2019-12-08 20:00:00 | YM | Futures | 30451.0 | 30463.0 | 30432.5 | 30444.5 | 2557.0 |
| 2019-12-08 21:00:00 | YM | Futures | 30442.3 | 30473.9 | 30442.3 | 30466.2 | 1785.0 |
| 2019-12-08 22:00:00 | YM | Futures | 30465.2 | 30467.3 | 30447.7 | 30454.3 | 809.0 |
| 2019-12-08 23:00:00 | YM | Futures | 30453.2 | 30463.0 | 30447.7 | 30455.4 | 549.0 |
| 2019-12-08 18:00:00 | CL | Futures | 52.42 | 52.53 | 52.3 | 52.3 | 3806.0 |
| 2019-12-08 19:00:00 | CL | Futures | 52.3 | 52.3 | 52.17 | 52.2 | 3837.0 |
| 2019-12-08 20:00:00 | CL | Futures | 52.2 | 52.3 | 52.17 | 52.27 | 4546.0 |
| 2019-12-08 21:00:00 | CL | Futures | 52.26 | 52.32 | 52.23 | 52.28 | 2767.0 |
| 2019-12-08 22:00:00 | CL | Futures | 52.27 | 52.28 | 52.22 | 52.22 | 1943.0 |
| 2019-12-08 23:00:00 | CL | Futures | 52.22 | 52.27 | 52.22 | 52.24 | 1248.0 |
| 2019-12-08 18:00:00 | GC | Futures | 1846.0 | 1846.6 | 1844.6 | 1846.5 | 3596.0 |
| 2019-12-08 19:00:00 | GC | Futures | 1846.5 | 1848.5 | 1846.3 | 1847.7 | 3313.0 |
| 2019-12-08 20:00:00 | GC | Futures | 1847.7 | 1848.2 | 1846.1 | 1846.7 | 5996.0 |
| 2019-12-08 21:00:00 | GC | Futures | 1846.7 | 1846.7 | 1845.2 | 1845.7 | 4657.0 |
| 2019-12-08 22:00:00 | GC | Futures | 1845.6 | 1846.5 | 1845.2 | 1846.2 | 2714.0 |
| 2019-12-08 23:00:00 | GC | Futures | 1846.2 | 1846.9 | 1845.7 | 1846.9 | 1749.0 |
| 2019-12-08 18:00:00 | ZN | Futures | 129.04456 | 129.060204 | 128.997629 | 129.028916 | 9365.0 |
| 2019-12-08 19:00:00 | ZN | Futures | 129.028916 | 129.091491 | 129.013273 | 129.060204 | 13497.0 |
| 2019-12-08 20:00:00 | ZN | Futures | 129.060204 | 129.060204 | 129.013273 | 129.04456 | 6087.0 |
| 2019-12-08 21:00:00 | ZN | Futures | 129.028916 | 129.04456 | 129.013273 | 129.013273 | 9141.0 |
| 2019-12-08 22:00:00 | ZN | Futures | 129.013273 | 129.04456 | 129.013273 | 129.028916 | 5045.0 |
| 2019-12-08 23:00:00 | ZN | Futures | 129.04456 | 129.091491 | 129.028916 | 129.075847 | 6124.0 |
> showing 36 of 347 rows — these rows as CSV