PREVIEW / futures_1hour / 2009-10-11
file: by_date/futures_1hour/2009/2009-10-11.parquet size: 13 KB rows: 227
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-10-11 18:00:00 | ES | Futures | 1034.53 | 1035.74 | 1034.29 | 1035.5 | 4000.0 |
| 2009-10-11 19:00:00 | ES | Futures | 1035.74 | 1037.68 | 1035.26 | 1036.95 | 3993.0 |
| 2009-10-11 20:00:00 | ES | Futures | 1037.19 | 1037.19 | 1033.8 | 1034.29 | 4167.0 |
| 2009-10-11 21:00:00 | ES | Futures | 1034.53 | 1035.26 | 1034.29 | 1035.01 | 1750.0 |
| 2009-10-11 22:00:00 | ES | Futures | 1034.77 | 1035.01 | 1034.29 | 1034.53 | 1513.0 |
| 2009-10-11 23:00:00 | ES | Futures | 1034.53 | 1035.01 | 1034.29 | 1035.01 | 546.0 |
| 2009-10-11 18:00:00 | NQ | Futures | 1967.84 | 1970.41 | 1967.84 | 1970.41 | 177.0 |
| 2009-10-11 19:00:00 | NQ | Futures | 1970.12 | 1973.83 | 1969.84 | 1972.69 | 373.0 |
| 2009-10-11 20:00:00 | NQ | Futures | 1972.4 | 1972.69 | 1966.7 | 1967.84 | 432.0 |
| 2009-10-11 21:00:00 | NQ | Futures | 1968.12 | 1969.27 | 1967.55 | 1968.7 | 133.0 |
| 2009-10-11 22:00:00 | NQ | Futures | 1968.41 | 1968.7 | 1966.98 | 1967.84 | 182.0 |
| 2009-10-11 23:00:00 | NQ | Futures | 1967.84 | 1968.12 | 1966.98 | 1967.84 | 129.0 |
| 2009-10-11 18:00:00 | YM | Futures | 9124.2 | 9132.6 | 9120.5 | 9130.7 | 253.0 |
| 2009-10-11 19:00:00 | YM | Futures | 9131.6 | 9152.1 | 9129.8 | 9144.6 | 410.0 |
| 2009-10-11 20:00:00 | YM | Futures | 9144.6 | 9144.6 | 9115.8 | 9116.7 | 878.0 |
| 2009-10-11 21:00:00 | YM | Futures | 9117.7 | 9126.0 | 9115.8 | 9125.1 | 218.0 |
| 2009-10-11 22:00:00 | YM | Futures | 9123.3 | 9124.2 | 9115.8 | 9120.5 | 173.0 |
| 2009-10-11 23:00:00 | YM | Futures | 9120.5 | 9124.2 | 9118.6 | 9122.3 | 104.0 |
| 2009-10-11 18:00:00 | CL | Futures | 162.47 | 163.19 | 162.27 | 162.97 | 874.0 |
| 2009-10-11 19:00:00 | CL | Futures | 163.03 | 163.17 | 162.7 | 163.03 | 390.0 |
| 2009-10-11 20:00:00 | CL | Futures | 163.03 | 163.15 | 162.05 | 162.11 | 853.0 |
| 2009-10-11 21:00:00 | CL | Futures | 162.11 | 162.56 | 162.11 | 162.38 | 553.0 |
| 2009-10-11 22:00:00 | CL | Futures | 162.38 | 162.47 | 162.16 | 162.34 | 398.0 |
| 2009-10-11 23:00:00 | CL | Futures | 162.38 | 162.5 | 162.16 | 162.47 | 182.0 |
| 2009-10-11 18:00:00 | GC | Futures | 1482.1 | 1488.4 | 1480.9 | 1487.9 | 1399.0 |
| 2009-10-11 19:00:00 | GC | Futures | 1487.8 | 1488.1 | 1486.2 | 1486.4 | 360.0 |
| 2009-10-11 20:00:00 | GC | Futures | 1486.4 | 1486.7 | 1483.4 | 1483.4 | 717.0 |
| 2009-10-11 21:00:00 | GC | Futures | 1483.4 | 1484.1 | 1479.3 | 1481.6 | 922.0 |
| 2009-10-11 22:00:00 | GC | Futures | 1481.7 | 1482.1 | 1480.4 | 1481.6 | 374.0 |
| 2009-10-11 23:00:00 | GC | Futures | 1481.6 | 1483.6 | 1480.4 | 1482.6 | 512.0 |
| 2009-10-11 18:00:00 | ZN | Futures | 94.934584 | 94.947131 | 94.884394 | 94.934584 | 1606.0 |
| 2009-10-11 19:00:00 | ZN | Futures | 94.947131 | 94.947131 | 94.896941 | 94.896941 | 895.0 |
| 2009-10-11 20:00:00 | ZN | Futures | 94.909489 | 94.984774 | 94.896941 | 94.947131 | 1177.0 |
| 2009-10-11 21:00:00 | ZN | Futures | 94.959679 | 94.972226 | 94.922036 | 94.947131 | 1121.0 |
| 2009-10-11 22:00:00 | ZN | Futures | 94.947131 | 94.959679 | 94.896941 | 94.947131 | 1247.0 |
| 2009-10-11 23:00:00 | ZN | Futures | 94.947131 | 94.972226 | 94.947131 | 94.959679 | 492.0 |
> showing 36 of 227 rows — these rows as CSV