PREVIEW / futures_1hour / 2010-01-24
file: by_date/futures_1hour/2010/2010-01-24.parquet size: 13 KB rows: 240
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-24 18:00:00 | ES | Futures | 1064.5 | 1067.42 | 1064.01 | 1066.93 | 31047.0 |
| 2010-01-24 19:00:00 | ES | Futures | 1066.93 | 1067.66 | 1066.2 | 1066.69 | 8462.0 |
| 2010-01-24 20:00:00 | ES | Futures | 1066.93 | 1067.66 | 1065.96 | 1067.66 | 7745.0 |
| 2010-01-24 21:00:00 | ES | Futures | 1067.42 | 1068.15 | 1067.18 | 1067.66 | 4957.0 |
| 2010-01-24 22:00:00 | ES | Futures | 1067.91 | 1067.91 | 1066.93 | 1066.93 | 4705.0 |
| 2010-01-24 23:00:00 | ES | Futures | 1066.93 | 1067.66 | 1066.69 | 1067.66 | 4959.0 |
| 2010-01-24 18:00:00 | NQ | Futures | 2050.53 | 2062.81 | 2050.53 | 2061.39 | 2044.0 |
| 2010-01-24 19:00:00 | NQ | Futures | 2061.67 | 2063.1 | 2060.53 | 2060.81 | 663.0 |
| 2010-01-24 20:00:00 | NQ | Futures | 2061.1 | 2061.96 | 2059.96 | 2061.96 | 1104.0 |
| 2010-01-24 21:00:00 | NQ | Futures | 2061.1 | 2062.53 | 2061.1 | 2061.96 | 716.0 |
| 2010-01-24 22:00:00 | NQ | Futures | 2061.67 | 2061.96 | 2060.81 | 2060.81 | 181.0 |
| 2010-01-24 23:00:00 | NQ | Futures | 2060.53 | 2061.39 | 2059.96 | 2061.1 | 461.0 |
| 2010-01-24 18:00:00 | YM | Futures | 9513.5 | 9543.4 | 9510.7 | 9537.8 | 757.0 |
| 2010-01-24 19:00:00 | YM | Futures | 9538.7 | 9545.3 | 9535.9 | 9538.7 | 349.0 |
| 2010-01-24 20:00:00 | YM | Futures | 9536.9 | 9542.5 | 9530.3 | 9542.5 | 343.0 |
| 2010-01-24 21:00:00 | YM | Futures | 9540.6 | 9548.1 | 9539.7 | 9542.5 | 307.0 |
| 2010-01-24 22:00:00 | YM | Futures | 9541.5 | 9541.5 | 9535.9 | 9537.8 | 315.0 |
| 2010-01-24 23:00:00 | YM | Futures | 9535.9 | 9544.3 | 9535.9 | 9541.5 | 232.0 |
| 2010-01-24 18:00:00 | CL | Futures | 158.71 | 159.65 | 158.43 | 159.35 | 2288.0 |
| 2010-01-24 19:00:00 | CL | Futures | 159.35 | 159.48 | 159.28 | 159.35 | 465.0 |
| 2010-01-24 20:00:00 | CL | Futures | 159.37 | 159.46 | 159.03 | 159.35 | 1044.0 |
| 2010-01-24 21:00:00 | CL | Futures | 159.39 | 159.54 | 159.13 | 159.5 | 984.0 |
| 2010-01-24 22:00:00 | CL | Futures | 159.48 | 159.5 | 159.11 | 159.28 | 389.0 |
| 2010-01-24 23:00:00 | CL | Futures | 159.31 | 159.56 | 159.26 | 159.46 | 577.0 |
| 2010-01-24 18:00:00 | GC | Futures | 1541.0 | 1547.2 | 1539.2 | 1543.2 | 2478.0 |
| 2010-01-24 19:00:00 | GC | Futures | 1543.2 | 1544.4 | 1540.9 | 1542.0 | 2911.0 |
| 2010-01-24 20:00:00 | GC | Futures | 1542.2 | 1547.9 | 1539.6 | 1547.4 | 2730.0 |
| 2010-01-24 21:00:00 | GC | Futures | 1547.2 | 1549.9 | 1546.1 | 1549.1 | 2902.0 |
| 2010-01-24 22:00:00 | GC | Futures | 1549.1 | 1549.8 | 1547.1 | 1547.8 | 1977.0 |
| 2010-01-24 23:00:00 | GC | Futures | 1547.5 | 1549.4 | 1547.2 | 1548.9 | 1076.0 |
| 2010-01-24 18:00:00 | ZN | Futures | 95.656861 | 95.669552 | 95.606094 | 95.644169 | 3986.0 |
| 2010-01-24 19:00:00 | ZN | Futures | 95.644169 | 95.694935 | 95.618786 | 95.656861 | 6199.0 |
| 2010-01-24 20:00:00 | ZN | Futures | 95.669552 | 95.669552 | 95.618786 | 95.644169 | 2016.0 |
| 2010-01-24 21:00:00 | ZN | Futures | 95.644169 | 95.644169 | 95.568019 | 95.580711 | 5291.0 |
| 2010-01-24 22:00:00 | ZN | Futures | 95.580711 | 95.618786 | 95.580711 | 95.593402 | 2743.0 |
| 2010-01-24 23:00:00 | ZN | Futures | 95.593402 | 95.606094 | 95.568019 | 95.580711 | 1960.0 |
> showing 36 of 240 rows — these rows as CSV