PREVIEW / futures_daily / 2011-06-02
file: by_date/futures_daily/2011/2011-06-02.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-02 | ES | Futures | 1300.13 | 1304.59 | 1291.22 | 1299.39 | 2433178.0 |
| 2011-06-02 | NQ | Futures | 2642.78 | 2659.87 | 2635.1 | 2649.05 | 278595.0 |
| 2011-06-02 | YM | Futures | 11545.4 | 11576.4 | 11449.5 | 11505.9 | 134562.0 |
| 2011-06-02 | CL | Futures | 191.71 | 193.9 | 189.15 | 192.88 | 389637.0 |
| 2011-06-02 | GC | Futures | 2087.2 | 2091.7 | 2057.7 | 2074.4 | 151694.0 |
| 2011-06-02 | ZN | Futures | 105.266754 | 105.279922 | 104.766361 | 104.832202 | 137451.0 |
| 2011-06-02 | A6 | Futures | 0.90862 | 0.91565 | 0.90691 | 0.91411 | 128483.0 |
| 2011-06-02 | AD | Futures | 1.01873 | 1.02152 | 1.01464 | 1.01992 | 100404.0 |
| 2011-06-02 | B | Futures | 97.67 | 98.82 | 97.02 | 98.53 | 102238.0 |
| 2011-06-02 | B6 | Futures | 1.6963 | 1.7055 | 1.6934 | 1.6995 | 104774.0 |
| 2011-06-02 | BFX | Futures | 3129.9 | 3134.6 | 3103.2 | 3103.2 | 68.0 |
| 2011-06-02 | BR | Futures | 0.27617 | 0.27751 | 0.27617 | 0.27724 | 175.0 |
| 2011-06-02 | BZ | Futures | 101.52 | 102.74 | 101.38 | 102.74 | 355.0 |
| 2011-06-02 | C | Futures | 1973.0 | 1984.0 | 1952.0 | 1953.0 | 4112.0 |
| 2011-06-02 | CB | Futures | 119.724 | 120.272 | 119.313 | 119.313 | 25.0 |
| 2011-06-02 | CC | Futures | 2351.0 | 2356.0 | 2297.0 | 2312.0 | 10565.0 |
| 2011-06-02 | CSC | Futures | 4.536 | 4.536 | 4.536 | 4.536 | 8.0 |
| 2011-06-02 | CT | Futures | 161.94 | 164.53 | 157.52 | 162.56 | 16048.0 |
| 2011-06-02 | DC | Futures | 31.9 | 31.98 | 31.65 | 31.78 | 305.0 |
| 2011-06-02 | DX | Futures | 74.491 | 74.581 | 73.889 | 74.004 | 29786.0 |
| 2011-06-02 | E1 | Futures | 1.55504 | 1.55857 | 1.54705 | 1.55464 | 36849.0 |
| 2011-06-02 | E6 | Futures | 1.69738 | 1.71894 | 1.69643 | 1.71515 | 339442.0 |
| 2011-06-02 | E7 | Futures | 1.6845 | 1.7063 | 1.6838 | 1.7024 | 6211.0 |
| 2011-06-02 | ED | Futures | 94.9644 | 94.9668 | 94.9621 | 94.9621 | 104716.0 |
| 2011-06-02 | ER | Futures | 97.326 | 97.331 | 97.321 | 97.326 | 48758.0 |
| 2011-06-02 | EW | Futures | 969.1 | 974.8 | 963.4 | 967.3 | 25684.0 |
| 2011-06-02 | FBTP | Futures | 65.34 | 65.6 | 65.19 | 65.51 | 6096.0 |
| 2011-06-02 | FCE | Futures | 2712.7 | 2718.3 | 2688.1 | 2691.2 | 159159.0 |
| 2011-06-02 | FDAX | Futures | 7629.7 | 7646.7 | 7549.0 | 7568.8 | 155017.0 |
| 2011-06-02 | FESX | Futures | 1791.4 | 1800.4 | 1777.3 | 1783.1 | 1204302.0 |
| 2011-06-02 | FEU3 | Futures | 97.88 | 97.88 | 97.87 | 97.87 | 129.0 |
| 2011-06-02 | FGBL | Futures | 100.63 | 100.8 | 100.27 | 100.6 | 1000350.0 |
| 2011-06-02 | FGBM | Futures | 104.87 | 104.93 | 104.5 | 104.75 | 579234.0 |
| 2011-06-02 | FGBS | Futures | 106.895 | 106.905 | 106.746 | 106.821 | 691516.0 |
| 2011-06-02 | FGBX | Futures | 98.06 | 98.24 | 97.16 | 97.82 | 9496.0 |
| 2011-06-02 | FTDX | Futures | 808.3 | 808.7 | 802.9 | 804.7 | 177.0 |
| 2011-06-02 | FTI | Futures | 281.4 | 282.18 | 279.18 | 279.35 | 27274.0 |
| 2011-06-02 | FTUK | Futures | 4111.2 | 4125.6 | 4090.3 | 4098.0 | 100511.0 |
| 2011-06-02 | FXXP | Futures | 183.9 | 184.7 | 183.2 | 183.7 | 1223.0 |
| 2011-06-02 | G | Futures | 84.31 | 84.42 | 84.19 | 84.27 | 169144.0 |
| 2011-06-02 | GF | Futures | 285.274 | 289.341 | 285.274 | 287.889 | 1826.0 |
| 2011-06-02 | GSCI | Futures | 1089.56 | 1097.46 | 1081.26 | 1095.03 | 138.0 |
| 2011-06-02 | HE | Futures | 95.117 | 95.917 | 93.303 | 93.863 | 13751.0 |
| 2011-06-02 | HG | Futures | 5.4325 | 5.4783 | 5.3574 | 5.4265 | 38221.0 |
| 2011-06-02 | HO | Futures | 2.4661 | 2.4968 | 2.4522 | 2.4909 | 16754.0 |
| 2011-06-02 | HRC | Futures | 3097.5 | 3097.5 | 3097.5 | 3097.5 | 0.0 |
| 2011-06-02 | J1 | Futures | 0.015528 | 0.0156121 | 0.0154476 | 0.015538 | 105782.0 |
| 2011-06-02 | J7 | Futures | 0.015429 | 0.015494 | 0.015357 | 0.015443 | 292.0 |
| 2011-06-02 | JB | Futures | 122.41 | 122.91 | 122.35 | 122.79 | 5345.0 |
| 2011-06-02 | KC | Futures | 613.76 | 629.83 | 607.41 | 626.47 | 15091.0 |
> showing 50 of 94 rows — these rows as CSV