PREVIEW / futures_daily / 2011-06-16
file: by_date/futures_daily/2011/2011-06-16.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-16 | ES | Futures | 1252.34 | 1260.29 | 1243.65 | 1254.82 | 3263670.0 |
| 2011-06-16 | NQ | Futures | 2512.67 | 2521.21 | 2478.51 | 2500.14 | 360888.0 |
| 2011-06-16 | YM | Futures | 11194.5 | 11270.2 | 11124.6 | 11249.4 | 167367.0 |
| 2011-06-16 | CL | Futures | 183.7 | 184.59 | 181.81 | 182.98 | 154315.0 |
| 2011-06-16 | GC | Futures | 2072.1 | 2076.1 | 2059.9 | 2070.6 | 113355.0 |
| 2011-06-16 | ZN | Futures | 105.322162 | 106.01402 | 105.202417 | 105.708006 | 1861388.0 |
| 2011-06-16 | A6 | Futures | 0.90813 | 0.91039 | 0.90073 | 0.90308 | 164181.0 |
| 2011-06-16 | AD | Futures | 1.01702 | 1.01892 | 1.00614 | 1.00924 | 114441.0 |
| 2011-06-16 | B | Futures | 97.3 | 98.34 | 96.29 | 97.55 | 222201.0 |
| 2011-06-16 | B6 | Futures | 1.6827 | 1.686 | 1.6707 | 1.6735 | 134526.0 |
| 2011-06-16 | BFX | Futures | 3005.8 | 3029.0 | 2990.6 | 3025.1 | 944.0 |
| 2011-06-16 | BR | Futures | 0.27216 | 0.27216 | 0.27127 | 0.27176 | 61.0 |
| 2011-06-16 | BZ | Futures | 101.47 | 102.1 | 100.92 | 101.73 | 665.0 |
| 2011-06-16 | C | Futures | 1991.0 | 1991.0 | 1950.0 | 1957.0 | 2808.0 |
| 2011-06-16 | CB | Futures | 115.614 | 116.6 | 115.614 | 116.6 | 4.0 |
| 2011-06-16 | CC | Futures | 2331.0 | 2343.0 | 2285.0 | 2288.0 | 11132.0 |
| 2011-06-16 | CT | Futures | 149.45 | 151.19 | 144.47 | 144.47 | 5906.0 |
| 2011-06-16 | DC | Futures | 30.55 | 30.95 | 30.4 | 30.92 | 133.0 |
| 2011-06-16 | DX | Futures | 75.242 | 75.767 | 75.123 | 75.489 | 35159.0 |
| 2011-06-16 | E1 | Futures | 1.53372 | 1.54418 | 1.53084 | 1.53947 | 48098.0 |
| 2011-06-16 | E6 | Futures | 1.6782 | 1.68485 | 1.66739 | 1.67499 | 415302.0 |
| 2011-06-16 | E7 | Futures | 1.6648 | 1.6727 | 1.6553 | 1.6628 | 5969.0 |
| 2011-06-16 | ED | Futures | 94.9191 | 94.9287 | 94.862 | 94.8763 | 759856.0 |
| 2011-06-16 | ER | Futures | 97.276 | 97.286 | 97.257 | 97.281 | 265265.0 |
| 2011-06-16 | EW | Futures | 920.8 | 926.5 | 911.5 | 922.1 | 28324.0 |
| 2011-06-16 | FBTP | Futures | 64.95 | 64.99 | 64.43 | 64.8 | 12212.0 |
| 2011-06-16 | FCE | Futures | 2623.2 | 2637.4 | 2599.2 | 2633.6 | 110871.0 |
| 2011-06-16 | FDAX | Futures | 7544.2 | 7601.4 | 7492.4 | 7589.1 | 194085.0 |
| 2011-06-16 | FESX | Futures | 1736.3 | 1754.9 | 1727.3 | 1751.0 | 1546060.0 |
| 2011-06-16 | FEU3 | Futures | 97.82 | 97.825 | 97.81 | 97.82 | 34.0 |
| 2011-06-16 | FGBL | Futures | 101.43 | 101.58 | 101.18 | 101.46 | 1502411.0 |
| 2011-06-16 | FGBM | Futures | 105.63 | 105.81 | 105.5 | 105.75 | 934010.0 |
| 2011-06-16 | FGBS | Futures | 107.229 | 107.328 | 107.169 | 107.308 | 1060525.0 |
| 2011-06-16 | FGBX | Futures | 97.11 | 97.29 | 96.27 | 96.7 | 7382.0 |
| 2011-06-16 | FTDX | Futures | 778.8 | 781.9 | 769.9 | 780.6 | 4071.0 |
| 2011-06-16 | FTI | Futures | 272.04 | 273.6 | 270.53 | 273.11 | 18279.0 |
| 2011-06-16 | FTUK | Futures | 4010.5 | 4017.9 | 3954.4 | 3996.0 | 154865.0 |
| 2011-06-16 | FXXP | Futures | 179.6 | 180.4 | 178.7 | 180.0 | 13169.0 |
| 2011-06-16 | G | Futures | 84.75 | 85.15 | 84.69 | 85.03 | 154724.0 |
| 2011-06-16 | GF | Futures | 295.442 | 302.065 | 295.384 | 302.065 | 2032.0 |
| 2011-06-16 | GSCI | Futures | 1064.92 | 1069.42 | 1058.37 | 1062.4 | 231.0 |
| 2011-06-16 | HE | Futures | 102.078 | 102.212 | 101.118 | 101.892 | 8139.0 |
| 2011-06-16 | HG | Futures | 5.481 | 5.4903 | 5.376 | 5.4703 | 41857.0 |
| 2011-06-16 | HO | Futures | 2.459 | 2.4794 | 2.4364 | 2.4577 | 11062.0 |
| 2011-06-16 | HRC | Futures | 3068.8 | 3068.8 | 3068.8 | 3068.8 | 0.0 |
| 2011-06-16 | J1 | Futures | 0.0155355 | 0.0156272 | 0.0155204 | 0.0155857 | 120505.0 |
| 2011-06-16 | J7 | Futures | 0.015444 | 0.015523 | 0.015419 | 0.015482 | 249.0 |
| 2011-06-16 | JB | Futures | 122.48 | 122.84 | 122.48 | 122.79 | 2508.0 |
| 2011-06-16 | KC | Futures | 630.67 | 633.79 | 617.48 | 618.44 | 5974.0 |
| 2011-06-16 | KE | Futures | 3239.72 | 3261.44 | 3148.87 | 3151.84 | 22361.0 |
> showing 50 of 95 rows — these rows as CSV