PREVIEW / futures_daily / 2011-06-07
file: by_date/futures_daily/2011/2011-06-07.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-06-07 | ES | Futures | 1272.41 | 1282.56 | 1269.69 | 1271.91 | 2069553.0 |
| 2011-06-07 | NQ | Futures | 2589.83 | 2606.06 | 2582.99 | 2589.54 | 226064.0 |
| 2011-06-07 | YM | Futures | 11363.0 | 11437.2 | 11326.3 | 11349.8 | 109590.0 |
| 2011-06-07 | CL | Futures | 189.84 | 191.63 | 187.77 | 190.36 | 415373.0 |
| 2011-06-07 | GC | Futures | 2091.0 | 2099.7 | 2080.2 | 2089.7 | 113974.0 |
| 2011-06-07 | ZN | Futures | 105.135071 | 105.266754 | 104.766361 | 105.056062 | 52194.0 |
| 2011-06-07 | A6 | Futures | 0.91943 | 0.92166 | 0.91454 | 0.91994 | 109867.0 |
| 2011-06-07 | AD | Futures | 1.01534 | 1.02301 | 1.01484 | 1.02241 | 87998.0 |
| 2011-06-07 | B | Futures | 97.6 | 100.09 | 97.06 | 99.54 | 133948.0 |
| 2011-06-07 | B6 | Futures | 1.6987 | 1.7113 | 1.6958 | 1.7089 | 114179.0 |
| 2011-06-07 | BFX | Futures | 3097.8 | 3106.0 | 3089.7 | 3089.7 | 229.0 |
| 2011-06-07 | BR | Futures | 0.27773 | 0.27827 | 0.27773 | 0.278 | 155.0 |
| 2011-06-07 | BZ | Futures | 101.61 | 103.8 | 101.61 | 103.8 | 686.0 |
| 2011-06-07 | C | Futures | 1924.0 | 1966.0 | 1923.0 | 1937.0 | 4665.0 |
| 2011-06-07 | CB | Futures | 115.614 | 115.614 | 115.614 | 115.614 | 15.0 |
| 2011-06-07 | CC | Futures | 2284.0 | 2350.0 | 2282.0 | 2300.0 | 15275.0 |
| 2011-06-07 | CSC | Futures | 4.496 | 4.496 | 4.433 | 4.433 | 12.0 |
| 2011-06-07 | CT | Futures | 153.41 | 154.4 | 147.11 | 147.11 | 13731.0 |
| 2011-06-07 | DC | Futures | 31.3 | 31.33 | 30.05 | 30.1 | 191.0 |
| 2011-06-07 | DX | Futures | 73.586 | 73.695 | 73.148 | 73.161 | 32271.0 |
| 2011-06-07 | E1 | Futures | 1.56813 | 1.57258 | 1.5604 | 1.56355 | 43573.0 |
| 2011-06-07 | E6 | Futures | 1.72687 | 1.74061 | 1.72486 | 1.74026 | 281977.0 |
| 2011-06-07 | E7 | Futures | 1.7139 | 1.7275 | 1.712 | 1.7273 | 4219.0 |
| 2011-06-07 | ED | Futures | 94.9668 | 94.9692 | 94.9668 | 94.9668 | 133434.0 |
| 2011-06-07 | ER | Futures | 97.326 | 97.326 | 97.301 | 97.311 | 149594.0 |
| 2011-06-07 | EW | Futures | 942.5 | 951.4 | 941.0 | 944.5 | 23653.0 |
| 2011-06-07 | FBTP | Futures | 65.66 | 65.66 | 65.24 | 65.32 | 8038.0 |
| 2011-06-07 | FCE | Futures | 2668.0 | 2694.3 | 2667.6 | 2682.9 | 112909.0 |
| 2011-06-07 | FDAX | Futures | 7545.3 | 7637.1 | 7545.3 | 7592.3 | 150039.0 |
| 2011-06-07 | FESX | Futures | 1763.9 | 1785.0 | 1762.6 | 1777.3 | 1092434.0 |
| 2011-06-07 | FEU3 | Futures | 97.87 | 97.87 | 97.855 | 97.855 | 322.0 |
| 2011-06-07 | FGBL | Futures | 100.44 | 100.48 | 99.77 | 99.86 | 1398874.0 |
| 2011-06-07 | FGBM | Futures | 104.63 | 104.71 | 104.24 | 104.32 | 903688.0 |
| 2011-06-07 | FGBS | Futures | 106.786 | 106.831 | 106.652 | 106.677 | 1043066.0 |
| 2011-06-07 | FGBX | Futures | 96.78 | 96.78 | 95.35 | 95.46 | 11942.0 |
| 2011-06-07 | FTDX | Futures | 790.8 | 806.5 | 786.4 | 798.4 | 284.0 |
| 2011-06-07 | FTI | Futures | 277.54 | 279.84 | 276.76 | 277.91 | 27963.0 |
| 2011-06-07 | FTUK | Futures | 4080.8 | 4124.2 | 4080.8 | 4108.8 | 98413.0 |
| 2011-06-07 | FXXP | Futures | 181.9 | 182.9 | 181.9 | 182.1 | 2097.0 |
| 2011-06-07 | G | Futures | 84.21 | 84.26 | 83.77 | 83.83 | 109636.0 |
| 2011-06-07 | GF | Futures | 289.109 | 291.142 | 288.47 | 290.794 | 1493.0 |
| 2011-06-07 | GSCI | Futures | 1081.73 | 1094.57 | 1080.16 | 1092.69 | 1826.0 |
| 2011-06-07 | HE | Futures | 92.556 | 95.863 | 92.449 | 95.49 | 23658.0 |
| 2011-06-07 | HG | Futures | 5.4737 | 5.5308 | 5.4597 | 5.5128 | 34914.0 |
| 2011-06-07 | HO | Futures | 2.4703 | 2.5293 | 2.4631 | 2.5173 | 15863.0 |
| 2011-06-07 | HRC | Futures | 3118.0 | 3118.0 | 3118.0 | 3118.0 | 0.0 |
| 2011-06-07 | J1 | Futures | 0.0156863 | 0.0157189 | 0.0156385 | 0.0156825 | 82077.0 |
| 2011-06-07 | J7 | Futures | 0.015579 | 0.015625 | 0.015545 | 0.015586 | 336.0 |
| 2011-06-07 | JB | Futures | 122.72 | 122.79 | 122.51 | 122.51 | 11810.0 |
| 2011-06-07 | KC | Futures | 623.48 | 636.66 | 623.48 | 630.67 | 13082.0 |
> showing 50 of 95 rows — these rows as CSV