PREVIEW / futures_daily / 2011-07-14
file: by_date/futures_daily/2011/2011-07-14.parquet size: 9 KB rows: 95
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-07-14 | ES | Futures | 1303.24 | 1314.16 | 1293.06 | 1297.78 | 2877782.0 |
| 2011-07-14 | NQ | Futures | 2671.24 | 2696.86 | 2635.66 | 2657.86 | 344083.0 |
| 2011-07-14 | YM | Futures | 11751.4 | 11844.0 | 11662.5 | 11706.0 | 144650.0 |
| 2011-07-14 | CL | Futures | 188.14 | 190.3 | 182.02 | 184.19 | 184909.0 |
| 2011-07-14 | GC | Futures | 2144.1 | 2158.6 | 2137.6 | 2151.0 | 189976.0 |
| 2011-07-14 | ZN | Futures | 106.17368 | 106.373254 | 105.85436 | 105.9608 | 1378918.0 |
| 2011-07-14 | A6 | Futures | 0.92892 | 0.93066 | 0.92248 | 0.92405 | 122081.0 |
| 2011-07-14 | AD | Futures | 1.04048 | 1.04357 | 1.03608 | 1.03788 | 82157.0 |
| 2011-07-14 | B | Futures | 100.22 | 100.89 | 98.39 | 99.12 | 196402.0 |
| 2011-07-14 | B6 | Futures | 1.6801 | 1.6836 | 1.6732 | 1.6766 | 104614.0 |
| 2011-07-14 | BFX | Futures | 2951.0 | 2963.4 | 2939.2 | 2942.9 | 462.0 |
| 2011-07-14 | BR | Futures | 0.28018 | 0.28063 | 0.27931 | 0.27985 | 603.0 |
| 2011-07-14 | BZ | Futures | 103.64 | 104.43 | 102.26 | 102.94 | 610.0 |
| 2011-07-14 | C | Futures | 2165.0 | 2175.0 | 2120.0 | 2139.0 | 3820.0 |
| 2011-07-14 | CB | Futures | 110.696 | 110.82 | 110.696 | 110.82 | 5.0 |
| 2011-07-14 | CC | Futures | 2519.0 | 2553.0 | 2478.0 | 2502.0 | 7953.0 |
| 2011-07-14 | CSC | Futures | 4.595 | 4.632 | 4.595 | 4.632 | 7.0 |
| 2011-07-14 | CT | Futures | 144.02 | 144.81 | 138.01 | 138.01 | 54.0 |
| 2011-07-14 | DC | Futures | 31.47 | 31.71 | 31.33 | 31.43 | 192.0 |
| 2011-07-14 | DX | Futures | 74.336 | 74.915 | 74.266 | 74.833 | 37619.0 |
| 2011-07-14 | E1 | Futures | 1.61363 | 1.61807 | 1.59584 | 1.60068 | 60238.0 |
| 2011-07-14 | E6 | Futures | 1.68521 | 1.69316 | 1.67309 | 1.67559 | 371851.0 |
| 2011-07-14 | E7 | Futures | 1.6712 | 1.6807 | 1.661 | 1.6633 | 7680.0 |
| 2011-07-14 | ED | Futures | 94.9001 | 94.9334 | 94.8763 | 94.9096 | 301080.0 |
| 2011-07-14 | ER | Futures | 97.351 | 97.361 | 97.336 | 97.351 | 89948.0 |
| 2011-07-14 | EW | Futures | 972.0 | 980.4 | 957.5 | 960.0 | 29937.0 |
| 2011-07-14 | FBTP | Futures | 61.17 | 61.32 | 60.46 | 60.97 | 14521.0 |
| 2011-07-14 | FCE | Futures | 2646.1 | 2670.4 | 2626.3 | 2647.1 | 92915.0 |
| 2011-07-14 | FDAX | Futures | 7714.6 | 7789.4 | 7667.6 | 7740.3 | 152590.0 |
| 2011-07-14 | FESX | Futures | 1722.8 | 1742.1 | 1713.2 | 1732.4 | 1452222.0 |
| 2011-07-14 | FGBL | Futures | 103.16 | 103.38 | 102.83 | 103.02 | 865220.0 |
| 2011-07-14 | FGBM | Futures | 106.71 | 106.97 | 106.57 | 106.68 | 506486.0 |
| 2011-07-14 | FGBS | Futures | 107.661 | 107.791 | 107.632 | 107.676 | 496176.0 |
| 2011-07-14 | FGBX | Futures | 99.35 | 99.83 | 98.46 | 98.93 | 6884.0 |
| 2011-07-14 | FTDX | Futures | 771.2 | 771.2 | 741.7 | 760.0 | 988.0 |
| 2011-07-14 | FTI | Futures | 273.12 | 274.15 | 270.88 | 272.7 | 21067.0 |
| 2011-07-14 | FTUK | Futures | 4095.5 | 4133.2 | 4068.3 | 4102.9 | 111193.0 |
| 2011-07-14 | FXXP | Futures | 181.0 | 182.0 | 179.6 | 181.0 | 1963.0 |
| 2011-07-14 | G | Futures | 85.9 | 86.03 | 85.58 | 85.81 | 123386.0 |
| 2011-07-14 | GF | Futures | 324.899 | 325.305 | 318.159 | 318.217 | 4557.0 |
| 2011-07-14 | GSCI | Futures | 1117.83 | 1122.0 | 1094.53 | 1103.5 | 2063.0 |
| 2011-07-14 | HE | Futures | 108.87 | 109.807 | 107.3 | 108.154 | 18397.0 |
| 2011-07-14 | HG | Futures | 5.8053 | 5.8397 | 5.7736 | 5.7901 | 32767.0 |
| 2011-07-14 | HO | Futures | 2.5157 | 2.5487 | 2.4862 | 2.5067 | 26492.0 |
| 2011-07-14 | HRC | Futures | 2989.2 | 2989.2 | 2989.2 | 2989.2 | 0.0 |
| 2011-07-14 | J1 | Futures | 0.0159364 | 0.0160244 | 0.0157956 | 0.0158899 | 131057.0 |
| 2011-07-14 | J7 | Futures | 0.015817 | 0.015915 | 0.015679 | 0.015784 | 444.0 |
| 2011-07-14 | JB | Futures | 123.13 | 123.42 | 123.1 | 123.4 | 1.0 |
| 2011-07-14 | KC | Futures | 624.44 | 628.46 | 607.05 | 611.19 | 9203.0 |
| 2011-07-14 | KE | Futures | 2926.85 | 2953.74 | 2882.68 | 2939.33 | 11542.0 |
> showing 50 of 95 rows — these rows as CSV