PREVIEW / futures_daily / 2010-02-09
file: by_date/futures_daily/2010/2010-02-09.parquet size: 9 KB rows: 92
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-09 | ES | Futures | 1023.14 | 1043.98 | 1021.69 | 1033.56 | 3014475.0 |
| 2010-02-09 | NQ | Futures | 1961.24 | 1998.84 | 1958.97 | 1981.6 | 380797.0 |
| 2010-02-09 | YM | Futures | 9037.5 | 9229.4 | 9022.9 | 9138.0 | 184076.0 |
| 2010-02-09 | CL | Futures | 169.31 | 175.14 | 168.46 | 174.2 | 429845.0 |
| 2010-02-09 | GC | Futures | 1457.6 | 1487.0 | 1457.2 | 1478.0 | 184386.0 |
| 2010-02-09 | ZN | Futures | 95.688286 | 95.70088 | 95.209719 | 95.297876 | 1183893.0 |
| 2010-02-09 | A6 | Futures | 0.69918 | 0.7125 | 0.69869 | 0.70901 | 131847.0 |
| 2010-02-09 | AD | Futures | 0.91716 | 0.92743 | 0.91716 | 0.92358 | 95581.0 |
| 2010-02-09 | B | Futures | 62.95 | 65.53 | 62.95 | 65.21 | 129581.0 |
| 2010-02-09 | B6 | Futures | 1.6189 | 1.6353 | 1.6159 | 1.6288 | 151950.0 |
| 2010-02-09 | BFX | Futures | 2705.0 | 2727.2 | 2704.7 | 2712.1 | 24.0 |
| 2010-02-09 | BR | Futures | 0.21643 | 0.21784 | 0.21643 | 0.2178 | 321.0 |
| 2010-02-09 | BZ | Futures | 67.95 | 68.53 | 67.95 | 68.39 | 3.0 |
| 2010-02-09 | C | Futures | 2263.0 | 2282.0 | 2259.0 | 2270.0 | 4382.0 |
| 2010-02-09 | CB | Futures | 70.816 | 71.557 | 70.816 | 71.557 | 9.0 |
| 2010-02-09 | CC | Futures | 2585.0 | 2588.0 | 2558.0 | 2572.0 | 12866.0 |
| 2010-02-09 | CT | Futures | 56.34 | 58.83 | 56.25 | 58.83 | 21875.0 |
| 2010-02-09 | DC | Futures | 22.45 | 22.68 | 22.45 | 22.58 | 169.0 |
| 2010-02-09 | DX | Futures | 81.895 | 81.895 | 81.0 | 81.345 | 41765.0 |
| 2010-02-09 | E1 | Futures | 1.2288 | 1.24317 | 1.22709 | 1.23764 | 62951.0 |
| 2010-02-09 | E6 | Futures | 1.61691 | 1.63846 | 1.61573 | 1.63053 | 431230.0 |
| 2010-02-09 | E7 | Futures | 1.6048 | 1.6269 | 1.6046 | 1.6192 | 4377.0 |
| 2010-02-09 | EBM | Futures | 212.5 | 214.2 | 212.08 | 212.5 | 5869.0 |
| 2010-02-09 | ED | Futures | 94.3631 | 94.3773 | 94.3583 | 94.3678 | 122777.0 |
| 2010-02-09 | ER | Futures | 97.281 | 97.311 | 97.281 | 97.306 | 124250.0 |
| 2010-02-09 | EW | Futures | 673.1 | 684.5 | 672.3 | 678.5 | 35079.0 |
| 2010-02-09 | FBTP | Futures | 63.15 | 63.59 | 63.15 | 63.49 | 12190.0 |
| 2010-02-09 | FCE | Futures | 2330.3 | 2391.9 | 2329.0 | 2354.1 | 150475.0 |
| 2010-02-09 | FDAX | Futures | 5969.7 | 6086.1 | 5966.4 | 5983.9 | 215324.0 |
| 2010-02-09 | FESX | Futures | 1583.2 | 1632.3 | 1580.9 | 1592.8 | 2118756.0 |
| 2010-02-09 | FEU3 | Futures | 97.85 | 97.869 | 97.85 | 97.869 | 385.0 |
| 2010-02-09 | FGBL | Futures | 95.56 | 95.66 | 95.01 | 95.6 | 1251304.0 |
| 2010-02-09 | FGBM | Futures | 101.3 | 101.37 | 100.9 | 101.31 | 737987.0 |
| 2010-02-09 | FGBS | Futures | 105.961 | 105.971 | 105.791 | 105.937 | 964566.0 |
| 2010-02-09 | FGBX | Futures | 90.63 | 90.73 | 89.52 | 90.34 | 3336.0 |
| 2010-02-09 | FTDX | Futures | 676.6 | 700.4 | 676.6 | 689.8 | 1183.0 |
| 2010-02-09 | FTI | Futures | 254.86 | 261.0 | 254.45 | 256.73 | 37426.0 |
| 2010-02-09 | FTUK | Futures | 3386.4 | 3450.7 | 3378.0 | 3390.0 | 127778.0 |
| 2010-02-09 | G | Futures | 75.8 | 75.84 | 75.59 | 75.78 | 108927.0 |
| 2010-02-09 | GF | Futures | 268.634 | 270.727 | 268.161 | 270.052 | 3502.0 |
| 2010-02-09 | GSCI | Futures | 901.69 | 915.71 | 897.39 | 910.1 | 2168.0 |
| 2010-02-09 | HE | Futures | 92.464 | 93.133 | 90.691 | 90.791 | 19254.0 |
| 2010-02-09 | HG | Futures | 3.9745 | 4.1441 | 3.9683 | 4.1207 | 46974.0 |
| 2010-02-09 | HO | Futures | 1.7529 | 1.8152 | 1.7452 | 1.8035 | 47978.0 |
| 2010-02-09 | HRC | Futures | 2848.9 | 2848.9 | 2848.9 | 2848.9 | 0.0 |
| 2010-02-09 | J1 | Futures | 0.0141033 | 0.0141096 | 0.0140139 | 0.0140404 | 123266.0 |
| 2010-02-09 | J7 | Futures | 0.013924 | 0.013932 | 0.013842 | 0.013864 | 91.0 |
| 2010-02-09 | JB | Futures | 117.44 | 117.7 | 117.41 | 117.64 | 2639.0 |
| 2010-02-09 | KC | Futures | 339.55 | 344.11 | 336.95 | 339.42 | 16039.0 |
| 2010-02-09 | KE | Futures | 2239.73 | 2260.08 | 2206.95 | 2215.99 | 12460.0 |
> showing 50 of 92 rows — these rows as CSV