PREVIEW / futures_daily / 2008-06-27
file: by_date/futures_daily/2008/2008-06-27.parquet size: 8 KB rows: 82
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2008-06-27 | ES | Futures | 1188.57 | 1194.82 | 1177.24 | 1183.95 | 2338736.0 |
| 2008-06-27 | NQ | Futures | 2082.24 | 2088.91 | 2042.47 | 2075.56 | 434636.0 |
| 2008-06-27 | YM | Futures | 10182.2 | 10223.9 | 10021.5 | 10086.3 | 216427.0 |
| 2008-06-27 | CL | Futures | 606.38 | 621.82 | 602.77 | 609.73 | 277517.0 |
| 2008-06-27 | GC | Futures | 1301.4 | 1321.3 | 1291.8 | 1318.8 | 128283.0 |
| 2008-06-27 | ZN | Futures | 83.687011 | 84.101246 | 83.594959 | 83.825089 | 963868.0 |
| 2008-06-27 | A6 | Futures | 0.73044 | 0.7367 | 0.72959 | 0.73438 | 36562.0 |
| 2008-06-27 | AD | Futures | 0.96834 | 0.97649 | 0.96775 | 0.97099 | 42287.0 |
| 2008-06-27 | B | Futures | 167.4 | 171.99 | 167.34 | 168.86 | 50852.0 |
| 2008-06-27 | B6 | Futures | 2.0358 | 2.0423 | 2.027 | 2.04 | 76956.0 |
| 2008-06-27 | BFX | Futures | 3652.5 | 3652.5 | 3590.3 | 3606.8 | 211.0 |
| 2008-06-27 | BR | Futures | 0.22583 | 0.22583 | 0.22546 | 0.22546 | 3.0 |
| 2008-06-27 | BZ | Futures | 166.52 | 168.21 | 165.8 | 166.37 | 987.0 |
| 2008-06-27 | C | Futures | 1496.0 | 1512.0 | 1496.0 | 1497.0 | 1222.0 |
| 2008-06-27 | CB | Futures | 94.703 | 94.703 | 94.09 | 94.397 | 12.0 |
| 2008-06-27 | CC | Futures | 2844.0 | 2864.0 | 2835.0 | 2850.0 | 4603.0 |
| 2008-06-27 | CT | Futures | 82.06 | 82.65 | 81.02 | 81.65 | 188.0 |
| 2008-06-27 | DC | Futures | 53.61 | 53.8 | 53.13 | 53.21 | 129.0 |
| 2008-06-27 | DX | Futures | 77.178 | 77.204 | 76.791 | 76.913 | 5689.0 |
| 2008-06-27 | E1 | Futures | 1.30258 | 1.3119 | 1.29884 | 1.30871 | 74600.0 |
| 2008-06-27 | E6 | Futures | 1.83726 | 1.84206 | 1.83316 | 1.83948 | 164514.0 |
| 2008-06-27 | E7 | Futures | 1.8191 | 1.8238 | 1.8155 | 1.8217 | 1761.0 |
| 2008-06-27 | ED | Futures | 91.5747 | 91.6596 | 91.5275 | 91.6502 | 315088.0 |
| 2008-06-27 | ER | Futures | 93.576 | 93.61 | 93.561 | 93.576 | 136337.0 |
| 2008-06-27 | EW | Futures | 820.0 | 822.3 | 811.5 | 814.2 | 31697.0 |
| 2008-06-27 | FCE | Futures | 2911.4 | 2924.9 | 2866.3 | 2899.5 | 149632.0 |
| 2008-06-27 | FDAX | Futures | 7287.9 | 7313.7 | 7177.6 | 7273.3 | 211989.0 |
| 2008-06-27 | FESX | Futures | 1982.6 | 1990.2 | 1952.7 | 1977.3 | 1804635.0 |
| 2008-06-27 | FEU3 | Futures | 94.122 | 94.132 | 94.117 | 94.122 | 640.0 |
| 2008-06-27 | FGBL | Futures | 83.84 | 83.95 | 83.59 | 83.82 | 935228.0 |
| 2008-06-27 | FGBM | Futures | 89.97 | 90.18 | 89.84 | 89.94 | 540798.0 |
| 2008-06-27 | FGBS | Futures | 99.294 | 99.386 | 99.226 | 99.279 | 597943.0 |
| 2008-06-27 | FGBX | Futures | 75.26 | 75.33 | 74.15 | 74.5 | 2309.0 |
| 2008-06-27 | FTDX | Futures | 712.2 | 714.9 | 694.1 | 706.8 | 901.0 |
| 2008-06-27 | FTI | Futures | 320.72 | 323.81 | 316.76 | 321.81 | 41052.0 |
| 2008-06-27 | FTUK | Futures | 3584.7 | 3614.5 | 3556.2 | 3593.8 | 130901.0 |
| 2008-06-27 | G | Futures | 66.89 | 66.98 | 66.51 | 66.77 | 90711.0 |
| 2008-06-27 | GF | Futures | 302.392 | 304.833 | 302.392 | 303.002 | 253.0 |
| 2008-06-27 | GSCI | Futures | 2250.65 | 2289.57 | 2250.65 | 2254.55 | 156.0 |
| 2008-06-27 | HE | Futures | 144.134 | 144.626 | 143.2 | 143.938 | 1406.0 |
| 2008-06-27 | HG | Futures | 5.3309 | 5.4145 | 5.3058 | 5.4048 | 13133.0 |
| 2008-06-27 | HO | Futures | 4.5902 | 4.698 | 4.5654 | 4.6108 | 10357.0 |
| 2008-06-27 | J1 | Futures | 0.0119558 | 0.0120741 | 0.0119151 | 0.0120232 | 153995.0 |
| 2008-06-27 | J7 | Futures | 0.011765 | 0.011861 | 0.011711 | 0.011816 | 91.0 |
| 2008-06-27 | JB | Futures | 112.79 | 113.17 | 112.7 | 112.71 | 4711.0 |
| 2008-06-27 | KC | Futures | 467.88 | 470.31 | 458.93 | 462.87 | 8558.0 |
| 2008-06-27 | KE | Futures | 5146.85 | 5231.72 | 4985.06 | 5012.91 | 14901.0 |
| 2008-06-27 | L | Futures | 93.2 | 93.234 | 93.16 | 93.19 | 58447.0 |
| 2008-06-27 | LE | Futures | 208.02 | 209.71 | 207.225 | 209.014 | 5141.0 |
| 2008-06-27 | MP | Futures | 0.04625 | 0.04631 | 0.04613 | 0.04628 | 11135.0 |
> showing 50 of 82 rows — these rows as CSV