PREVIEW / futures_daily / 2011-10-31
file: by_date/futures_daily/2011/2011-10-31.parquet size: 9 KB rows: 96
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-10-31 | ES | Futures | 1277.76 | 1278.5 | 1243.07 | 1247.06 | 2239270.0 |
| 2011-10-31 | NQ | Futures | 2736.93 | 2737.21 | 2682.99 | 2689.27 | 243862.0 |
| 2011-10-31 | YM | Futures | 11673.9 | 11681.6 | 11415.5 | 11429.0 | 104723.0 |
| 2011-10-31 | CL | Futures | 175.46 | 175.97 | 171.39 | 174.83 | 228561.0 |
| 2011-10-31 | GC | Futures | 2353.5 | 2358.0 | 2302.7 | 2329.3 | 122243.0 |
| 2011-10-31 | ZN | Futures | 109.833458 | 111.160791 | 109.806643 | 110.745161 | 1084251.0 |
| 2011-10-31 | A6 | Futures | 0.93637 | 0.93672 | 0.9186 | 0.92617 | 129017.0 |
| 2011-10-31 | AD | Futures | 1.00756 | 1.00816 | 0.99655 | 1.00556 | 76359.0 |
| 2011-10-31 | B | Futures | 96.79 | 97.02 | 95.15 | 96.34 | 83123.0 |
| 2011-10-31 | B6 | Futures | 1.6823 | 1.6864 | 1.6655 | 1.6831 | 130996.0 |
| 2011-10-31 | BFX | Futures | 2608.0 | 2608.0 | 2567.2 | 2570.3 | 197.0 |
| 2011-10-31 | BR | Futures | 0.26605 | 0.26605 | 0.26366 | 0.26481 | 231.0 |
| 2011-10-31 | BZ | Futures | 101.97 | 101.97 | 100.71 | 101.73 | 526.0 |
| 2011-10-31 | C | Futures | 1786.0 | 1792.0 | 1759.0 | 1771.0 | 5452.0 |
| 2011-10-31 | CC | Futures | 2136.0 | 2144.0 | 2094.0 | 2114.0 | 9869.0 |
| 2011-10-31 | CT | Futures | 134.08 | 134.9 | 130.39 | 131.87 | 13253.0 |
| 2011-10-31 | DC | Futures | 29.62 | 29.71 | 29.07 | 29.47 | 172.0 |
| 2011-10-31 | DX | Futures | 73.84 | 75.317 | 73.737 | 74.911 | 33645.0 |
| 2011-10-31 | E1 | Futures | 1.52235 | 1.52484 | 1.4944 | 1.50372 | 24131.0 |
| 2011-10-31 | E6 | Futures | 1.69075 | 1.69314 | 1.65202 | 1.66373 | 342132.0 |
| 2011-10-31 | E7 | Futures | 1.6761 | 1.6785 | 1.638 | 1.6495 | 7437.0 |
| 2011-10-31 | ED | Futures | 94.9984 | 95.0127 | 94.9793 | 94.9889 | 224882.0 |
| 2011-10-31 | ER | Futures | 97.179 | 97.238 | 97.179 | 97.218 | 140322.0 |
| 2011-10-31 | EW | Futures | 912.2 | 912.2 | 882.8 | 889.3 | 33722.0 |
| 2011-10-31 | FBTP | Futures | 60.59 | 60.68 | 60.01 | 60.36 | 10274.0 |
| 2011-10-31 | FBTS | Futures | 81.173 | 81.173 | 80.675 | 80.812 | 1941.0 |
| 2011-10-31 | FCE | Futures | 2382.7 | 2385.6 | 2314.2 | 2322.8 | 93326.0 |
| 2011-10-31 | FDAX | Futures | 6840.6 | 6856.4 | 6621.3 | 6701.7 | 150184.0 |
| 2011-10-31 | FESX | Futures | 1620.9 | 1621.6 | 1567.0 | 1587.6 | 1295748.0 |
| 2011-10-31 | FEU3 | Futures | 97.742 | 97.776 | 97.742 | 97.776 | 9.0 |
| 2011-10-31 | FGBL | Futures | 108.49 | 110.58 | 108.4 | 109.61 | 833065.0 |
| 2011-10-31 | FGBM | Futures | 110.26 | 111.41 | 110.19 | 110.86 | 442754.0 |
| 2011-10-31 | FGBS | Futures | 108.94 | 109.188 | 108.905 | 109.044 | 439047.0 |
| 2011-10-31 | FGBX | Futures | 108.37 | 111.54 | 108.0 | 110.31 | 6608.0 |
| 2011-10-31 | FTDX | Futures | 656.0 | 656.4 | 641.2 | 648.6 | 128.0 |
| 2011-10-31 | FTI | Futures | 256.2 | 257.31 | 252.47 | 253.3 | 37222.0 |
| 2011-10-31 | FTUK | Futures | 4065.0 | 4065.7 | 3938.7 | 3974.9 | 143280.0 |
| 2011-10-31 | FVSA | Futures | 13022.0 | 14272.12 | 13022.0 | 14230.45 | 3941.0 |
| 2011-10-31 | FXXP | Futures | 171.9 | 172.3 | 169.4 | 170.1 | 4478.0 |
| 2011-10-31 | G | Futures | 89.92 | 91.02 | 89.89 | 90.85 | 107792.0 |
| 2011-10-31 | GF | Futures | 312.095 | 312.26 | 309.273 | 309.937 | 1836.0 |
| 2011-10-31 | GSCI | Futures | 1011.34 | 1018.39 | 1005.39 | 1013.85 | 248.0 |
| 2011-10-31 | HE | Futures | 111.411 | 113.693 | 111.25 | 112.439 | 17106.0 |
| 2011-10-31 | HG | Futures | 4.9497 | 4.9524 | 4.7208 | 4.8062 | 45399.0 |
| 2011-10-31 | HO | Futures | 2.4728 | 2.4728 | 2.4314 | 2.4565 | 51345.0 |
| 2011-10-31 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 25.0 |
| 2011-10-31 | J1 | Futures | 0.0166062 | 0.0166652 | 0.0158084 | 0.0161087 | 364863.0 |
| 2011-10-31 | J7 | Futures | 0.016492 | 0.016572 | 0.015711 | 0.016011 | 3527.0 |
| 2011-10-31 | JB | Futures | 124.02 | 124.12 | 123.92 | 124.12 | 3637.0 |
| 2011-10-31 | KC | Futures | 549.05 | 550.11 | 531.03 | 534.8 | 12922.0 |
> showing 50 of 96 rows — these rows as CSV