PREVIEW / futures_1hour / 2009-11-08
file: by_date/futures_1hour/2009/2009-11-08.parquet size: 13 KB rows: 243
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-08 18:00:00 | ES | Futures | 1032.59 | 1034.29 | 1032.35 | 1033.08 | 7694.0 |
| 2009-11-08 19:00:00 | ES | Futures | 1032.83 | 1036.47 | 1031.86 | 1035.74 | 9175.0 |
| 2009-11-08 20:00:00 | ES | Futures | 1035.74 | 1037.68 | 1035.5 | 1035.5 | 8661.0 |
| 2009-11-08 21:00:00 | ES | Futures | 1035.5 | 1036.71 | 1035.5 | 1036.22 | 2257.0 |
| 2009-11-08 22:00:00 | ES | Futures | 1036.47 | 1036.95 | 1035.74 | 1036.47 | 2106.0 |
| 2009-11-08 23:00:00 | ES | Futures | 1036.22 | 1037.19 | 1035.98 | 1037.19 | 2938.0 |
| 2009-11-08 18:00:00 | NQ | Futures | 1971.26 | 1974.97 | 1971.26 | 1972.12 | 271.0 |
| 2009-11-08 19:00:00 | NQ | Futures | 1972.12 | 1978.96 | 1970.69 | 1978.68 | 975.0 |
| 2009-11-08 20:00:00 | NQ | Futures | 1978.96 | 1981.53 | 1977.54 | 1977.82 | 773.0 |
| 2009-11-08 21:00:00 | NQ | Futures | 1978.11 | 1979.53 | 1978.11 | 1978.96 | 119.0 |
| 2009-11-08 22:00:00 | NQ | Futures | 1978.68 | 1979.82 | 1977.82 | 1979.25 | 186.0 |
| 2009-11-08 23:00:00 | NQ | Futures | 1978.68 | 1980.39 | 1978.39 | 1980.39 | 144.0 |
| 2009-11-08 18:00:00 | YM | Futures | 9282.3 | 9290.7 | 9276.7 | 9280.5 | 221.0 |
| 2009-11-08 19:00:00 | YM | Futures | 9281.4 | 9312.1 | 9273.0 | 9305.6 | 801.0 |
| 2009-11-08 20:00:00 | YM | Futures | 9302.8 | 9327.0 | 9302.8 | 9302.8 | 842.0 |
| 2009-11-08 21:00:00 | YM | Futures | 9303.7 | 9311.1 | 9303.7 | 9308.4 | 98.0 |
| 2009-11-08 22:00:00 | YM | Futures | 9309.3 | 9313.9 | 9305.6 | 9309.3 | 93.0 |
| 2009-11-08 23:00:00 | YM | Futures | 9308.4 | 9315.8 | 9307.4 | 9315.8 | 165.0 |
| 2009-11-08 18:00:00 | CL | Futures | 174.0 | 174.49 | 173.78 | 174.09 | 1445.0 |
| 2009-11-08 19:00:00 | CL | Futures | 174.09 | 174.85 | 174.02 | 174.78 | 1829.0 |
| 2009-11-08 20:00:00 | CL | Futures | 174.76 | 174.96 | 174.53 | 174.65 | 1096.0 |
| 2009-11-08 21:00:00 | CL | Futures | 174.67 | 175.14 | 174.67 | 175.12 | 665.0 |
| 2009-11-08 22:00:00 | CL | Futures | 175.14 | 175.14 | 174.85 | 174.98 | 469.0 |
| 2009-11-08 23:00:00 | CL | Futures | 174.96 | 175.29 | 174.96 | 175.21 | 814.0 |
| 2009-11-08 18:00:00 | GC | Futures | 1549.9 | 1552.4 | 1547.4 | 1549.6 | 1930.0 |
| 2009-11-08 19:00:00 | GC | Futures | 1549.6 | 1553.1 | 1547.1 | 1553.1 | 2236.0 |
| 2009-11-08 20:00:00 | GC | Futures | 1553.1 | 1554.1 | 1550.9 | 1551.4 | 1841.0 |
| 2009-11-08 21:00:00 | GC | Futures | 1551.7 | 1554.3 | 1551.0 | 1553.8 | 1122.0 |
| 2009-11-08 22:00:00 | GC | Futures | 1553.8 | 1554.8 | 1553.0 | 1554.7 | 977.0 |
| 2009-11-08 23:00:00 | GC | Futures | 1554.7 | 1560.3 | 1554.4 | 1559.6 | 3834.0 |
| 2009-11-08 18:00:00 | ZN | Futures | 95.110249 | 95.110249 | 95.022417 | 95.085154 | 1967.0 |
| 2009-11-08 19:00:00 | ZN | Futures | 95.085154 | 95.085154 | 94.984774 | 94.997322 | 3064.0 |
| 2009-11-08 20:00:00 | ZN | Futures | 94.984774 | 94.997322 | 94.959679 | 94.984774 | 2890.0 |
| 2009-11-08 21:00:00 | ZN | Futures | 94.984774 | 94.997322 | 94.972226 | 94.972226 | 1597.0 |
| 2009-11-08 22:00:00 | ZN | Futures | 94.972226 | 94.997322 | 94.972226 | 94.984774 | 818.0 |
| 2009-11-08 23:00:00 | ZN | Futures | 94.984774 | 94.984774 | 94.947131 | 94.959679 | 2070.0 |
> showing 36 of 243 rows — these rows as CSV