PREVIEW / futures_1hour / 2009-11-15
file: by_date/futures_1hour/2009/2009-11-15.parquet size: 13 KB rows: 232
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-11-15 18:00:00 | ES | Futures | 1058.02 | 1064.32 | 1057.06 | 1063.84 | 13930.0 |
| 2009-11-15 19:00:00 | ES | Futures | 1064.08 | 1064.08 | 1060.93 | 1062.14 | 9953.0 |
| 2009-11-15 20:00:00 | ES | Futures | 1062.14 | 1063.84 | 1061.17 | 1063.35 | 5728.0 |
| 2009-11-15 21:00:00 | ES | Futures | 1063.35 | 1064.56 | 1063.35 | 1064.32 | 3415.0 |
| 2009-11-15 22:00:00 | ES | Futures | 1064.08 | 1064.32 | 1063.6 | 1063.6 | 1894.0 |
| 2009-11-15 23:00:00 | ES | Futures | 1063.6 | 1064.81 | 1063.35 | 1064.08 | 2553.0 |
| 2009-11-15 18:00:00 | NQ | Futures | 2041.42 | 2051.12 | 2038.85 | 2049.98 | 1663.0 |
| 2009-11-15 19:00:00 | NQ | Futures | 2049.98 | 2051.12 | 2044.84 | 2047.41 | 719.0 |
| 2009-11-15 20:00:00 | NQ | Futures | 2046.84 | 2050.26 | 2045.41 | 2049.41 | 524.0 |
| 2009-11-15 21:00:00 | NQ | Futures | 2049.12 | 2051.12 | 2049.12 | 2050.26 | 385.0 |
| 2009-11-15 22:00:00 | NQ | Futures | 2050.26 | 2050.83 | 2049.69 | 2049.98 | 159.0 |
| 2009-11-15 23:00:00 | NQ | Futures | 2049.98 | 2051.12 | 2049.41 | 2050.55 | 304.0 |
| 2009-11-15 18:00:00 | YM | Futures | 9527.9 | 9579.0 | 9525.1 | 9576.3 | 1039.0 |
| 2009-11-15 19:00:00 | YM | Futures | 9576.3 | 9578.1 | 9552.1 | 9561.4 | 530.0 |
| 2009-11-15 20:00:00 | YM | Futures | 9560.4 | 9576.3 | 9555.8 | 9572.5 | 318.0 |
| 2009-11-15 21:00:00 | YM | Futures | 9572.5 | 9582.8 | 9571.6 | 9579.0 | 401.0 |
| 2009-11-15 22:00:00 | YM | Futures | 9579.0 | 9580.0 | 9572.5 | 9574.4 | 234.0 |
| 2009-11-15 23:00:00 | YM | Futures | 9574.4 | 9581.8 | 9570.7 | 9575.3 | 241.0 |
| 2009-11-15 18:00:00 | CL | Futures | 170.99 | 172.1 | 170.64 | 172.01 | 308.0 |
| 2009-11-15 19:00:00 | CL | Futures | 171.99 | 172.1 | 171.83 | 171.94 | 128.0 |
| 2009-11-15 20:00:00 | CL | Futures | 171.9 | 172.34 | 171.74 | 172.1 | 210.0 |
| 2009-11-15 21:00:00 | CL | Futures | 172.03 | 172.14 | 171.79 | 171.83 | 208.0 |
| 2009-11-15 22:00:00 | CL | Futures | 171.83 | 172.63 | 171.83 | 172.41 | 304.0 |
| 2009-11-15 23:00:00 | CL | Futures | 172.41 | 172.81 | 172.34 | 172.52 | 223.0 |
| 2009-11-15 18:00:00 | GC | Futures | 1580.4 | 1592.1 | 1580.2 | 1587.9 | 5423.0 |
| 2009-11-15 19:00:00 | GC | Futures | 1587.9 | 1588.6 | 1585.6 | 1586.7 | 1975.0 |
| 2009-11-15 20:00:00 | GC | Futures | 1586.5 | 1587.4 | 1585.7 | 1586.7 | 1350.0 |
| 2009-11-15 21:00:00 | GC | Futures | 1586.5 | 1587.3 | 1585.6 | 1586.7 | 1294.0 |
| 2009-11-15 22:00:00 | GC | Futures | 1586.7 | 1591.3 | 1586.6 | 1590.3 | 1626.0 |
| 2009-11-15 23:00:00 | GC | Futures | 1590.1 | 1595.9 | 1589.8 | 1594.2 | 3869.0 |
| 2009-11-15 18:00:00 | ZN | Futures | 95.549413 | 95.56196 | 95.51177 | 95.524318 | 2275.0 |
| 2009-11-15 19:00:00 | ZN | Futures | 95.524318 | 95.61215 | 95.51177 | 95.574508 | 2417.0 |
| 2009-11-15 20:00:00 | ZN | Futures | 95.587055 | 95.599603 | 95.574508 | 95.574508 | 1766.0 |
| 2009-11-15 21:00:00 | ZN | Futures | 95.574508 | 95.599603 | 95.574508 | 95.599603 | 658.0 |
| 2009-11-15 22:00:00 | ZN | Futures | 95.599603 | 95.61215 | 95.587055 | 95.587055 | 1048.0 |
| 2009-11-15 23:00:00 | ZN | Futures | 95.587055 | 95.587055 | 95.536865 | 95.549413 | 1369.0 |
> showing 36 of 232 rows — these rows as CSV