PREVIEW / futures_daily / 2010-07-07
file: by_date/futures_daily/2010/2010-07-07.parquet size: 9 KB rows: 90
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-07 | ES | Futures | 998.76 | 1033.63 | 991.2 | 1033.14 | 2556140.0 |
| 2010-07-07 | NQ | Futures | 1963.43 | 2025.4 | 1948.72 | 2025.4 | 304126.0 |
| 2010-07-07 | YM | Futures | 8948.2 | 9230.2 | 8888.1 | 9227.4 | 164837.0 |
| 2010-07-07 | CL | Futures | 153.93 | 160.01 | 152.58 | 158.2 | 288660.0 |
| 2010-07-07 | GC | Futures | 1628.7 | 1642.9 | 1616.4 | 1635.4 | 126917.0 |
| 2010-07-07 | ZN | Futures | 100.593234 | 100.695684 | 100.273078 | 100.349915 | 870461.0 |
| 2010-07-07 | A6 | Futures | 0.70038 | 0.71239 | 0.69474 | 0.7114 | 117313.0 |
| 2010-07-07 | AD | Futures | 0.93641 | 0.94323 | 0.93068 | 0.94115 | 81210.0 |
| 2010-07-07 | B | Futures | 62.85 | 65.19 | 62.26 | 64.5 | 99220.0 |
| 2010-07-07 | B6 | Futures | 1.5721 | 1.5793 | 1.565 | 1.5778 | 90300.0 |
| 2010-07-07 | BFX | Futures | 2708.0 | 2757.4 | 2695.5 | 2756.8 | 225.0 |
| 2010-07-07 | BZ | Futures | 68.93 | 68.93 | 68.93 | 68.93 | 65.0 |
| 2010-07-07 | C | Futures | 2563.0 | 2615.0 | 2548.0 | 2601.0 | 3952.0 |
| 2010-07-07 | CB | Futures | 83.294 | 83.294 | 83.294 | 83.294 | 8.0 |
| 2010-07-07 | CC | Futures | 2462.0 | 2505.0 | 2452.0 | 2486.0 | 4932.0 |
| 2010-07-07 | CSC | Futures | 3.791 | 3.814 | 3.76 | 3.791 | 8.0 |
| 2010-07-07 | CT | Futures | 64.93 | 65.58 | 64.37 | 65.58 | 211.0 |
| 2010-07-07 | DC | Futures | 23.03 | 23.16 | 22.88 | 23.06 | 174.0 |
| 2010-07-07 | DX | Futures | 84.947 | 85.265 | 84.63 | 84.703 | 19011.0 |
| 2010-07-07 | E1 | Futures | 1.24096 | 1.25134 | 1.23623 | 1.25094 | 29613.0 |
| 2010-07-07 | E6 | Futures | 1.49313 | 1.49798 | 1.48474 | 1.49633 | 288348.0 |
| 2010-07-07 | E7 | Futures | 1.4826 | 1.4871 | 1.4742 | 1.4856 | 3310.0 |
| 2010-07-07 | ED | Futures | 94.3376 | 94.3613 | 94.3281 | 94.347 | 207908.0 |
| 2010-07-07 | ER | Futures | 97.237 | 97.252 | 97.213 | 97.227 | 111951.0 |
| 2010-07-07 | EW | Futures | 684.6 | 710.9 | 679.1 | 710.7 | 29267.0 |
| 2010-07-07 | FBTP | Futures | 65.05 | 65.05 | 64.84 | 64.92 | 2780.0 |
| 2010-07-07 | FCE | Futures | 2228.0 | 2323.7 | 2211.8 | 2291.1 | 158189.0 |
| 2010-07-07 | FDAX | Futures | 6421.2 | 6585.5 | 6367.4 | 6514.3 | 157501.0 |
| 2010-07-07 | FESX | Futures | 1577.7 | 1649.5 | 1564.7 | 1625.3 | 1594029.0 |
| 2010-07-07 | FEU3 | Futures | 97.785 | 97.79 | 97.78 | 97.785 | 56.0 |
| 2010-07-07 | FGBL | Futures | 101.06 | 101.2 | 100.81 | 100.92 | 544192.0 |
| 2010-07-07 | FGBM | Futures | 105.42 | 105.56 | 105.21 | 105.28 | 381314.0 |
| 2010-07-07 | FGBS | Futures | 107.544 | 107.569 | 107.446 | 107.475 | 382105.0 |
| 2010-07-07 | FGBX | Futures | 100.68 | 101.11 | 100.52 | 100.64 | 3267.0 |
| 2010-07-07 | FTDX | Futures | 655.8 | 670.3 | 653.6 | 662.4 | 438.0 |
| 2010-07-07 | FTI | Futures | 246.06 | 254.65 | 244.43 | 251.4 | 37372.0 |
| 2010-07-07 | FTUK | Futures | 3354.4 | 3475.2 | 3342.8 | 3421.5 | 106442.0 |
| 2010-07-07 | G | Futures | 81.44 | 81.54 | 81.2 | 81.25 | 61576.0 |
| 2010-07-07 | GF | Futures | 286.971 | 287.665 | 285.518 | 286.844 | 2424.0 |
| 2010-07-07 | GSCI | Futures | 823.4 | 841.07 | 823.4 | 839.28 | 342.0 |
| 2010-07-07 | HE | Futures | 97.554 | 98.707 | 97.189 | 98.13 | 15163.0 |
| 2010-07-07 | HG | Futures | 3.9703 | 4.0808 | 3.9421 | 4.0379 | 21804.0 |
| 2010-07-07 | HO | Futures | 1.7045 | 1.769 | 1.6966 | 1.7535 | 17925.0 |
| 2010-07-07 | HRC | Futures | 2875.5 | 2875.5 | 2875.5 | 2875.5 | 100.0 |
| 2010-07-07 | J1 | Futures | 0.0143852 | 0.0144707 | 0.0143449 | 0.0144028 | 126508.0 |
| 2010-07-07 | J7 | Futures | 0.014264 | 0.014361 | 0.014239 | 0.014294 | 202.0 |
| 2010-07-07 | JB | Futures | 120.35 | 120.63 | 120.29 | 120.63 | 703.0 |
| 2010-07-07 | KC | Futures | 395.92 | 411.74 | 394.41 | 409.48 | 13666.0 |
| 2010-07-07 | KE | Futures | 2214.85 | 2333.1 | 2211.65 | 2324.58 | 20121.0 |
| 2010-07-07 | L | Futures | 98.056 | 98.056 | 98.036 | 98.046 | 18763.0 |
> showing 50 of 90 rows — these rows as CSV