PREVIEW / futures_daily / 2011-06-13
file: by_date/futures_daily/2011/2011-06-13.parquet size: 9 KB rows: 91
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-13 | ES | Futures | 1257.31 | 1264.49 | 1252.36 | 1258.8 | 798749.0 |
| 2011-06-13 | NQ | Futures | 2524.91 | 2544.27 | 2522.06 | 2532.03 | 91589.0 |
| 2011-06-13 | YM | Futures | 11234.3 | 11290.0 | 11201.2 | 11236.1 | 120331.0 |
| 2011-06-13 | CL | Futures | 190.75 | 191.65 | 185.53 | 187.73 | 140488.0 |
| 2011-06-13 | GC | Futures | 2071.7 | 2076.0 | 2045.6 | 2051.2 | 117009.0 |
| 2011-06-13 | ZN | Futures | 105.202417 | 105.348771 | 104.843183 | 105.029452 | 995275.0 |
| 2011-06-13 | A6 | Futures | 0.90526 | 0.91387 | 0.90421 | 0.91265 | 86967.0 |
| 2011-06-13 | AD | Futures | 1.01672 | 1.02101 | 1.01562 | 1.01962 | 61898.0 |
| 2011-06-13 | B | Futures | 100.92 | 102.44 | 99.68 | 101.32 | 227324.0 |
| 2011-06-13 | B6 | Futures | 1.6878 | 1.7028 | 1.6848 | 1.7013 | 108546.0 |
| 2011-06-13 | BFX | Futures | 3052.3 | 3053.0 | 3050.5 | 3050.5 | 59.0 |
| 2011-06-13 | BR | Futures | 0.27528 | 0.27626 | 0.27528 | 0.2759 | 79.0 |
| 2011-06-13 | BZ | Futures | 105.52 | 106.51 | 104.08 | 105.65 | 932.0 |
| 2011-06-13 | C | Futures | 2011.0 | 2022.0 | 1994.0 | 1999.0 | 3028.0 |
| 2011-06-13 | CC | Futures | 2372.0 | 2385.0 | 2319.0 | 2353.0 | 8389.0 |
| 2011-06-13 | CT | Futures | 148.56 | 151.24 | 145.34 | 149.4 | 11596.0 |
| 2011-06-13 | DC | Futures | 30.57 | 30.77 | 30.35 | 30.77 | 47.0 |
| 2011-06-13 | DX | Futures | 74.524 | 74.643 | 74.093 | 74.152 | 25288.0 |
| 2011-06-13 | E1 | Futures | 1.55242 | 1.56654 | 1.54523 | 1.56171 | 33886.0 |
| 2011-06-13 | E6 | Futures | 1.69744 | 1.70908 | 1.69602 | 1.70694 | 210274.0 |
| 2011-06-13 | E7 | Futures | 1.6866 | 1.6967 | 1.6837 | 1.6945 | 3806.0 |
| 2011-06-13 | ED | Futures | 94.9763 | 94.9811 | 94.9716 | 94.9763 | 207513.0 |
| 2011-06-13 | ER | Futures | 97.336 | 97.346 | 97.321 | 97.321 | 131821.0 |
| 2011-06-13 | EW | Futures | 921.3 | 926.8 | 914.4 | 919.5 | 52763.0 |
| 2011-06-13 | FBTP | Futures | 64.99 | 65.2 | 64.82 | 65.13 | 5648.0 |
| 2011-06-13 | FCE | Futures | 2640.2 | 2659.3 | 2627.0 | 2643.7 | 36555.0 |
| 2011-06-13 | FDAX | Futures | 7545.3 | 7608.8 | 7519.7 | 7573.6 | 108331.0 |
| 2011-06-13 | FESX | Futures | 1749.8 | 1763.2 | 1742.1 | 1755.5 | 404792.0 |
| 2011-06-13 | FEU3 | Futures | 97.875 | 97.875 | 97.86 | 97.86 | 4.0 |
| 2011-06-13 | FGBL | Futures | 100.98 | 101.17 | 100.89 | 101.03 | 599469.0 |
| 2011-06-13 | FGBM | Futures | 105.32 | 105.48 | 105.23 | 105.32 | 377480.0 |
| 2011-06-13 | FGBS | Futures | 107.075 | 107.134 | 107.035 | 107.065 | 326887.0 |
| 2011-06-13 | FGBX | Futures | 96.7 | 97.05 | 96.54 | 96.96 | 3818.0 |
| 2011-06-13 | FTDX | Futures | 787.3 | 787.3 | 784.6 | 785.5 | 226.0 |
| 2011-06-13 | FTI | Futures | 274.47 | 275.61 | 273.19 | 274.42 | 3338.0 |
| 2011-06-13 | FTUK | Futures | 4045.0 | 4062.7 | 4024.9 | 4051.4 | 67964.0 |
| 2011-06-13 | FXXP | Futures | 181.5 | 181.7 | 181.4 | 181.7 | 16730.0 |
| 2011-06-13 | G | Futures | 84.71 | 84.77 | 84.43 | 84.51 | 74350.0 |
| 2011-06-13 | GF | Futures | 286.494 | 290.271 | 286.494 | 289.98 | 1650.0 |
| 2011-06-13 | GSCI | Futures | 1104.51 | 1107.98 | 1085.9 | 1094.97 | 2539.0 |
| 2011-06-13 | HE | Futures | 99.784 | 100.265 | 98.744 | 99.784 | 19278.0 |
| 2011-06-13 | HG | Futures | 5.3753 | 5.3926 | 5.3308 | 5.3601 | 31910.0 |
| 2011-06-13 | HO | Futures | 2.5457 | 2.564 | 2.5054 | 2.5402 | 9735.0 |
| 2011-06-13 | HRC | Futures | 3068.8 | 3068.8 | 3068.8 | 3068.8 | 0.0 |
| 2011-06-13 | J1 | Futures | 0.0156687 | 0.0156963 | 0.0155593 | 0.01568 | 82965.0 |
| 2011-06-13 | J7 | Futures | 0.015553 | 0.01559 | 0.015463 | 0.015575 | 355.0 |
| 2011-06-13 | JB | Futures | 122.69 | 122.81 | 122.68 | 122.72 | 1183.0 |
| 2011-06-13 | KC | Futures | 647.22 | 649.01 | 625.99 | 641.34 | 13113.0 |
| 2011-06-13 | KE | Futures | 3430.29 | 3445.1 | 3330.56 | 3361.17 | 15836.0 |
| 2011-06-13 | L | Futures | 98.473 | 98.483 | 98.453 | 98.463 | 63518.0 |
> showing 50 of 91 rows — these rows as CSV