PREVIEW / futures_daily / 2010-07-02
file: by_date/futures_daily/2010/2010-07-02.parquet size: 9 KB rows: 89
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-07-02 | ES | Futures | 997.05 | 1007.05 | 985.84 | 989.25 | 2135335.0 |
| 2010-07-02 | NQ | Futures | 1956.64 | 1975.88 | 1935.7 | 1948.15 | 317947.0 |
| 2010-07-02 | YM | Futures | 8931.5 | 9017.5 | 8831.7 | 8872.4 | 152916.0 |
| 2010-07-02 | CL | Futures | 155.21 | 156.72 | 152.97 | 154.08 | 256171.0 |
| 2010-07-02 | GC | Futures | 1635.5 | 1656.0 | 1635.2 | 1647.4 | 119623.0 |
| 2010-07-02 | ZN | Futures | 100.388334 | 100.631653 | 100.09379 | 100.247465 | 1157389.0 |
| 2010-07-02 | A6 | Futures | 0.69681 | 0.69963 | 0.69059 | 0.69225 | 105527.0 |
| 2010-07-02 | AD | Futures | 0.93285 | 0.93513 | 0.92525 | 0.92772 | 88916.0 |
| 2010-07-02 | B | Futures | 63.33 | 63.87 | 62.41 | 62.81 | 72136.0 |
| 2010-07-02 | B6 | Futures | 1.5752 | 1.5804 | 1.5721 | 1.5768 | 87913.0 |
| 2010-07-02 | BFX | Futures | 2677.0 | 2687.6 | 2633.6 | 2639.9 | 129.0 |
| 2010-07-02 | BZ | Futures | 67.16 | 67.18 | 67.12 | 67.12 | 44.0 |
| 2010-07-02 | C | Futures | 2578.0 | 2593.0 | 2526.0 | 2538.0 | 2280.0 |
| 2010-07-02 | CB | Futures | 83.053 | 83.294 | 83.053 | 83.294 | 9.0 |
| 2010-07-02 | CC | Futures | 2527.0 | 2538.0 | 2469.0 | 2478.0 | 7261.0 |
| 2010-07-02 | CT | Futures | 66.26 | 66.9 | 65.31 | 65.47 | 154.0 |
| 2010-07-02 | DC | Futures | 22.79 | 22.91 | 22.76 | 22.79 | 155.0 |
| 2010-07-02 | DX | Futures | 85.527 | 85.683 | 85.028 | 85.34 | 20500.0 |
| 2010-07-02 | E1 | Futures | 1.24122 | 1.24227 | 1.22967 | 1.23676 | 37681.0 |
| 2010-07-02 | E6 | Futures | 1.48036 | 1.49195 | 1.47646 | 1.48486 | 279628.0 |
| 2010-07-02 | E7 | Futures | 1.4699 | 1.4812 | 1.4659 | 1.4742 | 4795.0 |
| 2010-07-02 | ED | Futures | 94.2948 | 94.3186 | 94.2854 | 94.3138 | 130589.0 |
| 2010-07-02 | ER | Futures | 97.232 | 97.276 | 97.222 | 97.242 | 131800.0 |
| 2010-07-02 | EW | Futures | 691.4 | 699.6 | 682.5 | 683.8 | 24874.0 |
| 2010-07-02 | FBTP | Futures | 64.88 | 65.21 | 64.88 | 65.15 | 2098.0 |
| 2010-07-02 | FCE | Futures | 2211.5 | 2234.2 | 2184.2 | 2204.3 | 151746.0 |
| 2010-07-02 | FDAX | Futures | 6408.2 | 6469.7 | 6315.2 | 6354.9 | 142850.0 |
| 2010-07-02 | FESX | Futures | 1565.9 | 1588.8 | 1542.4 | 1559.1 | 1258095.0 |
| 2010-07-02 | FEU3 | Futures | 97.81 | 97.81 | 97.8 | 97.8 | 99.0 |
| 2010-07-02 | FGBL | Futures | 101.08 | 101.23 | 100.79 | 100.99 | 604098.0 |
| 2010-07-02 | FGBM | Futures | 105.4 | 105.52 | 105.21 | 105.39 | 384847.0 |
| 2010-07-02 | FGBS | Futures | 107.431 | 107.529 | 107.431 | 107.485 | 435047.0 |
| 2010-07-02 | FGBX | Futures | 100.91 | 101.18 | 100.26 | 100.75 | 2921.0 |
| 2010-07-02 | FTDX | Futures | 639.5 | 643.9 | 633.7 | 639.5 | 412.0 |
| 2010-07-02 | FTI | Futures | 245.66 | 248.04 | 242.25 | 244.12 | 35703.0 |
| 2010-07-02 | FTUK | Futures | 3302.5 | 3339.3 | 3280.5 | 3302.1 | 108693.0 |
| 2010-07-02 | G | Futures | 81.53 | 81.53 | 81.11 | 81.24 | 81287.0 |
| 2010-07-02 | GF | Futures | 284.824 | 287.16 | 284.445 | 284.634 | 2018.0 |
| 2010-07-02 | GSCI | Futures | 824.51 | 829.88 | 816.48 | 819.64 | 271.0 |
| 2010-07-02 | HE | Futures | 99.496 | 99.618 | 97.129 | 97.189 | 12997.0 |
| 2010-07-02 | HG | Futures | 3.8779 | 3.9616 | 3.8765 | 3.9053 | 23925.0 |
| 2010-07-02 | HO | Futures | 1.7242 | 1.7356 | 1.6929 | 1.7019 | 14412.0 |
| 2010-07-02 | HRC | Futures | 2899.3 | 2899.3 | 2899.3 | 2899.3 | 0.0 |
| 2010-07-02 | J1 | Futures | 0.0143563 | 0.0144242 | 0.0142795 | 0.014355 | 141663.0 |
| 2010-07-02 | J7 | Futures | 0.014253 | 0.014313 | 0.014175 | 0.014247 | 169.0 |
| 2010-07-02 | JB | Futures | 120.74 | 120.9 | 120.5 | 120.54 | 2331.0 |
| 2010-07-02 | KC | Futures | 421.41 | 422.41 | 411.24 | 412.62 | 9399.0 |
| 2010-07-02 | KE | Futures | 2169.04 | 2221.24 | 2155.19 | 2198.87 | 16988.0 |
| 2010-07-02 | L | Futures | 98.017 | 98.036 | 98.017 | 98.036 | 22444.0 |
| 2010-07-02 | LBS | Futures | 646.2 | 652.1 | 632.3 | 637.6 | 305.0 |
> showing 50 of 89 rows — these rows as CSV