PREVIEW / futures_1hour / 2009-12-27
file: by_date/futures_1hour/2009/2009-12-27.parquet size: 13 KB rows: 228
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-27 18:00:00 | ES | Futures | 1090.29 | 1090.53 | 1087.37 | 1089.07 | 7962.0 |
| 2009-12-27 19:00:00 | ES | Futures | 1089.31 | 1089.8 | 1088.34 | 1089.56 | 2319.0 |
| 2009-12-27 20:00:00 | ES | Futures | 1089.31 | 1090.04 | 1089.07 | 1089.31 | 1182.0 |
| 2009-12-27 21:00:00 | ES | Futures | 1089.56 | 1092.72 | 1089.56 | 1091.99 | 2764.0 |
| 2009-12-27 22:00:00 | ES | Futures | 1092.23 | 1092.23 | 1090.29 | 1091.02 | 1613.0 |
| 2009-12-27 23:00:00 | ES | Futures | 1091.26 | 1092.96 | 1090.77 | 1092.23 | 2267.0 |
| 2009-12-27 18:00:00 | NQ | Futures | 2133.65 | 2133.94 | 2128.22 | 2131.36 | 572.0 |
| 2009-12-27 19:00:00 | NQ | Futures | 2131.36 | 2133.08 | 2130.22 | 2132.51 | 139.0 |
| 2009-12-27 20:00:00 | NQ | Futures | 2132.22 | 2132.79 | 2131.08 | 2131.65 | 81.0 |
| 2009-12-27 21:00:00 | NQ | Futures | 2131.94 | 2138.79 | 2131.94 | 2137.93 | 274.0 |
| 2009-12-27 22:00:00 | NQ | Futures | 2137.93 | 2138.22 | 2133.65 | 2136.51 | 237.0 |
| 2009-12-27 23:00:00 | NQ | Futures | 2136.22 | 2139.36 | 2135.65 | 2137.36 | 202.0 |
| 2009-12-27 18:00:00 | YM | Futures | 9783.9 | 9786.7 | 9759.6 | 9773.6 | 464.0 |
| 2009-12-27 19:00:00 | YM | Futures | 9773.6 | 9780.2 | 9768.9 | 9775.5 | 154.0 |
| 2009-12-27 20:00:00 | YM | Futures | 9775.5 | 9779.2 | 9770.8 | 9775.5 | 54.0 |
| 2009-12-27 21:00:00 | YM | Futures | 9773.6 | 9797.9 | 9773.6 | 9794.2 | 164.0 |
| 2009-12-27 22:00:00 | YM | Futures | 9796.1 | 9797.9 | 9783.9 | 9793.3 | 149.0 |
| 2009-12-27 23:00:00 | YM | Futures | 9791.4 | 9803.6 | 9790.5 | 9797.0 | 160.0 |
| 2009-12-27 18:00:00 | CL | Futures | 167.32 | 167.6 | 166.98 | 167.2 | 980.0 |
| 2009-12-27 19:00:00 | CL | Futures | 167.22 | 168.08 | 167.22 | 167.9 | 793.0 |
| 2009-12-27 20:00:00 | CL | Futures | 167.86 | 168.4 | 167.67 | 168.27 | 866.0 |
| 2009-12-27 21:00:00 | CL | Futures | 168.33 | 168.57 | 168.2 | 168.55 | 539.0 |
| 2009-12-27 22:00:00 | CL | Futures | 168.57 | 168.96 | 168.4 | 168.55 | 770.0 |
| 2009-12-27 23:00:00 | CL | Futures | 168.55 | 168.72 | 168.53 | 168.57 | 359.0 |
| 2009-12-27 18:00:00 | GC | Futures | 1561.5 | 1565.3 | 1557.4 | 1562.3 | 3208.0 |
| 2009-12-27 19:00:00 | GC | Futures | 1562.3 | 1563.9 | 1560.1 | 1560.5 | 1452.0 |
| 2009-12-27 20:00:00 | GC | Futures | 1560.3 | 1567.0 | 1560.1 | 1566.0 | 2622.0 |
| 2009-12-27 21:00:00 | GC | Futures | 1566.1 | 1570.4 | 1566.0 | 1569.8 | 2847.0 |
| 2009-12-27 22:00:00 | GC | Futures | 1569.8 | 1570.6 | 1568.8 | 1569.1 | 1214.0 |
| 2009-12-27 23:00:00 | GC | Futures | 1568.9 | 1569.7 | 1565.1 | 1567.7 | 1796.0 |
| 2009-12-27 18:00:00 | ZN | Futures | 94.01964 | 94.045023 | 93.994256 | 93.994256 | 2012.0 |
| 2009-12-27 19:00:00 | ZN | Futures | 93.994256 | 94.006948 | 93.956181 | 93.968873 | 1222.0 |
| 2009-12-27 20:00:00 | ZN | Futures | 93.968873 | 93.981565 | 93.956181 | 93.981565 | 627.0 |
| 2009-12-27 21:00:00 | ZN | Futures | 93.968873 | 94.006948 | 93.956181 | 93.968873 | 1085.0 |
| 2009-12-27 22:00:00 | ZN | Futures | 93.956181 | 93.968873 | 93.892723 | 93.930798 | 1699.0 |
| 2009-12-27 23:00:00 | ZN | Futures | 93.930798 | 93.930798 | 93.740424 | 93.778498 | 4642.0 |
> showing 36 of 228 rows — these rows as CSV