PREVIEW / futures_1hour / 2009-12-20
file: by_date/futures_1hour/2009/2009-12-20.parquet size: 12 KB rows: 220
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-20 18:00:00 | ES | Futures | 1069.12 | 1070.1 | 1066.93 | 1068.88 | 9440.0 |
| 2009-12-20 19:00:00 | ES | Futures | 1069.12 | 1069.37 | 1067.66 | 1068.88 | 3786.0 |
| 2009-12-20 20:00:00 | ES | Futures | 1068.88 | 1069.85 | 1068.64 | 1068.88 | 2876.0 |
| 2009-12-20 21:00:00 | ES | Futures | 1069.12 | 1071.31 | 1068.88 | 1071.31 | 4405.0 |
| 2009-12-20 22:00:00 | ES | Futures | 1071.31 | 1072.28 | 1070.83 | 1070.83 | 4577.0 |
| 2009-12-20 23:00:00 | ES | Futures | 1070.83 | 1071.8 | 1070.1 | 1070.58 | 3415.0 |
| 2009-12-20 18:00:00 | NQ | Futures | 2063.38 | 2065.96 | 2059.96 | 2064.53 | 639.0 |
| 2009-12-20 19:00:00 | NQ | Futures | 2064.53 | 2067.1 | 2063.96 | 2066.53 | 542.0 |
| 2009-12-20 20:00:00 | NQ | Futures | 2066.53 | 2067.95 | 2065.96 | 2067.38 | 198.0 |
| 2009-12-20 21:00:00 | NQ | Futures | 2067.67 | 2073.95 | 2067.1 | 2073.67 | 1776.0 |
| 2009-12-20 22:00:00 | NQ | Futures | 2073.67 | 2074.81 | 2072.53 | 2072.81 | 260.0 |
| 2009-12-20 23:00:00 | NQ | Futures | 2073.1 | 2074.52 | 2070.81 | 2070.81 | 495.0 |
| 2009-12-20 18:00:00 | YM | Futures | 9616.4 | 9623.0 | 9602.4 | 9618.3 | 293.0 |
| 2009-12-20 19:00:00 | YM | Futures | 9619.2 | 9623.0 | 9611.7 | 9619.2 | 161.0 |
| 2009-12-20 20:00:00 | YM | Futures | 9620.1 | 9623.9 | 9617.3 | 9623.0 | 72.0 |
| 2009-12-20 21:00:00 | YM | Futures | 9622.0 | 9637.9 | 9618.3 | 9637.9 | 317.0 |
| 2009-12-20 22:00:00 | YM | Futures | 9638.9 | 9642.6 | 9629.5 | 9635.1 | 274.0 |
| 2009-12-20 23:00:00 | YM | Futures | 9633.2 | 9638.9 | 9626.7 | 9629.5 | 122.0 |
| 2009-12-20 18:00:00 | CL | Futures | 159.74 | 160.11 | 158.95 | 159.94 | 578.0 |
| 2009-12-20 19:00:00 | CL | Futures | 159.96 | 160.77 | 159.94 | 160.43 | 712.0 |
| 2009-12-20 20:00:00 | CL | Futures | 160.41 | 160.56 | 160.04 | 160.09 | 569.0 |
| 2009-12-20 21:00:00 | CL | Futures | 160.07 | 160.39 | 160.04 | 160.37 | 483.0 |
| 2009-12-20 22:00:00 | CL | Futures | 160.3 | 160.39 | 160.19 | 160.26 | 213.0 |
| 2009-12-20 23:00:00 | CL | Futures | 160.24 | 160.45 | 160.11 | 160.22 | 350.0 |
| 2009-12-20 18:00:00 | GC | Futures | 1567.0 | 1579.5 | 1565.6 | 1571.6 | 3673.0 |
| 2009-12-20 19:00:00 | GC | Futures | 1571.5 | 1574.6 | 1569.5 | 1572.0 | 2916.0 |
| 2009-12-20 20:00:00 | GC | Futures | 1572.2 | 1574.2 | 1570.5 | 1572.3 | 1828.0 |
| 2009-12-20 21:00:00 | GC | Futures | 1572.2 | 1573.7 | 1571.6 | 1573.6 | 807.0 |
| 2009-12-20 22:00:00 | GC | Futures | 1573.7 | 1576.6 | 1571.9 | 1574.4 | 1555.0 |
| 2009-12-20 23:00:00 | GC | Futures | 1574.3 | 1575.0 | 1572.0 | 1572.3 | 1229.0 |
| 2009-12-20 18:00:00 | ZN | Futures | 95.555327 | 95.580711 | 95.542636 | 95.555327 | 698.0 |
| 2009-12-20 19:00:00 | ZN | Futures | 95.555327 | 95.631477 | 95.555327 | 95.606094 | 2093.0 |
| 2009-12-20 20:00:00 | ZN | Futures | 95.606094 | 95.618786 | 95.580711 | 95.580711 | 981.0 |
| 2009-12-20 21:00:00 | ZN | Futures | 95.580711 | 95.580711 | 95.542636 | 95.542636 | 783.0 |
| 2009-12-20 22:00:00 | ZN | Futures | 95.542636 | 95.580711 | 95.529944 | 95.542636 | 1297.0 |
| 2009-12-20 23:00:00 | ZN | Futures | 95.555327 | 95.580711 | 95.542636 | 95.542636 | 347.0 |
> showing 36 of 220 rows — these rows as CSV