PREVIEW / futures_daily / 2010-09-27
file: by_date/futures_daily/2010/2010-09-27.parquet size: 9 KB rows: 90
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-27 | ES | Futures | 1121.3 | 1126.94 | 1114.44 | 1115.18 | 1343049.0 |
| 2010-09-27 | NQ | Futures | 2289.05 | 2304.07 | 2276.01 | 2276.01 | 233636.0 |
| 2010-09-27 | YM | Futures | 10045.6 | 10096.8 | 9994.4 | 10002.8 | 101800.0 |
| 2010-09-27 | CL | Futures | 159.33 | 160.79 | 157.35 | 159.43 | 289641.0 |
| 2010-09-27 | GC | Futures | 1765.9 | 1768.8 | 1760.5 | 1765.1 | 76830.0 |
| 2010-09-27 | ZN | Futures | 103.425668 | 104.083772 | 103.412764 | 104.019252 | 843789.0 |
| 2010-09-27 | A6 | Futures | 0.79842 | 0.80177 | 0.79581 | 0.8011 | 59802.0 |
| 2010-09-27 | AD | Futures | 0.96518 | 0.96746 | 0.96023 | 0.96409 | 61497.0 |
| 2010-09-27 | B | Futures | 68.01 | 68.14 | 66.77 | 67.57 | 88072.0 |
| 2010-09-27 | B6 | Futures | 1.6417 | 1.6464 | 1.638 | 1.645 | 65723.0 |
| 2010-09-27 | BFX | Futures | 2988.9 | 2990.7 | 2958.5 | 2968.3 | 259.0 |
| 2010-09-27 | BR | Futures | 0.24687 | 0.24687 | 0.24644 | 0.24663 | 27.0 |
| 2010-09-27 | BZ | Futures | 72.18 | 72.18 | 71.04 | 71.85 | 461.0 |
| 2010-09-27 | C | Futures | 2067.0 | 2083.0 | 2053.0 | 2074.0 | 4220.0 |
| 2010-09-27 | CB | Futures | 99.284 | 99.978 | 99.284 | 99.978 | 18.0 |
| 2010-09-27 | CC | Futures | 2342.0 | 2360.0 | 2311.0 | 2350.0 | 6162.0 |
| 2010-09-27 | CT | Futures | 85.77 | 87.97 | 85.28 | 87.97 | 14703.0 |
| 2010-09-27 | DC | Futures | 25.4 | 25.52 | 25.22 | 25.34 | 50.0 |
| 2010-09-27 | DX | Futures | 79.783 | 80.009 | 79.648 | 79.807 | 12890.0 |
| 2010-09-27 | E1 | Futures | 1.33551 | 1.33853 | 1.33104 | 1.33459 | 24204.0 |
| 2010-09-27 | E6 | Futures | 1.59498 | 1.59746 | 1.58764 | 1.59344 | 209068.0 |
| 2010-09-27 | E7 | Futures | 1.5838 | 1.5851 | 1.5757 | 1.5813 | 2706.0 |
| 2010-09-27 | ED | Futures | 94.6936 | 94.7031 | 94.6888 | 94.6983 | 72668.0 |
| 2010-09-27 | ER | Futures | 97.326 | 97.33 | 97.301 | 97.311 | 92634.0 |
| 2010-09-27 | EW | Futures | 779.7 | 785.1 | 775.1 | 777.9 | 28225.0 |
| 2010-09-27 | FBTP | Futures | 66.8 | 67.0 | 66.77 | 66.99 | 2024.0 |
| 2010-09-27 | FCE | Futures | 2490.8 | 2505.9 | 2468.8 | 2471.8 | 96142.0 |
| 2010-09-27 | FDAX | Futures | 6811.1 | 6819.2 | 6755.2 | 6760.6 | 100420.0 |
| 2010-09-27 | FESX | Futures | 1744.4 | 1748.8 | 1721.3 | 1726.3 | 791751.0 |
| 2010-09-27 | FEU3 | Futures | 97.889 | 97.889 | 97.874 | 97.874 | 644.0 |
| 2010-09-27 | FGBL | Futures | 103.46 | 104.12 | 103.43 | 104.0 | 796231.0 |
| 2010-09-27 | FGBM | Futures | 106.45 | 106.75 | 106.44 | 106.68 | 415736.0 |
| 2010-09-27 | FGBS | Futures | 107.662 | 107.696 | 107.652 | 107.657 | 357676.0 |
| 2010-09-27 | FGBX | Futures | 106.25 | 107.86 | 106.16 | 107.52 | 3256.0 |
| 2010-09-27 | FTDX | Futures | 684.9 | 689.3 | 684.9 | 686.2 | 652.0 |
| 2010-09-27 | FTI | Futures | 272.42 | 272.78 | 269.93 | 270.53 | 25223.0 |
| 2010-09-27 | FTUK | Futures | 3861.3 | 3867.2 | 3832.3 | 3839.2 | 77445.0 |
| 2010-09-27 | G | Futures | 84.04 | 84.38 | 83.99 | 84.34 | 69004.0 |
| 2010-09-27 | GF | Futures | 273.554 | 276.886 | 271.668 | 275.126 | 2058.0 |
| 2010-09-27 | GSCI | Futures | 893.29 | 894.38 | 880.94 | 887.7 | 184.0 |
| 2010-09-27 | HE | Futures | 103.117 | 103.996 | 103.049 | 103.895 | 10083.0 |
| 2010-09-27 | HG | Futures | 4.8529 | 4.8636 | 4.7822 | 4.8009 | 20039.0 |
| 2010-09-27 | HO | Futures | 1.8289 | 1.834 | 1.7954 | 1.8183 | 13816.0 |
| 2010-09-27 | HRC | Futures | 2685.2 | 2685.2 | 2685.2 | 2685.2 | 0.0 |
| 2010-09-27 | J1 | Futures | 0.0149087 | 0.0149464 | 0.0148949 | 0.0149238 | 63793.0 |
| 2010-09-27 | J7 | Futures | 0.014814 | 0.014841 | 0.014794 | 0.014821 | 73.0 |
| 2010-09-27 | JB | Futures | 121.77 | 121.77 | 121.58 | 121.76 | 1513.0 |
| 2010-09-27 | KC | Futures | 448.12 | 458.78 | 445.27 | 451.96 | 8163.0 |
| 2010-09-27 | KE | Futures | 3158.25 | 3195.8 | 3074.81 | 3086.28 | 10446.0 |
| 2010-09-27 | L | Futures | 98.135 | 98.145 | 98.125 | 98.145 | 13375.0 |
> showing 50 of 90 rows — these rows as CSV