PREVIEW / futures_daily / 2011-10-25
file: by_date/futures_daily/2011/2011-10-25.parquet size: 9 KB rows: 97
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-25 | ES | Futures | 1244.81 | 1252.3 | 1220.11 | 1222.35 | 2635786.0 |
| 2011-10-25 | NQ | Futures | 2710.96 | 2724.37 | 2643.61 | 2650.18 | 325017.0 |
| 2011-10-25 | YM | Futures | 11358.8 | 11414.6 | 11165.7 | 11203.2 | 147788.0 |
| 2011-10-25 | CL | Futures | 172.01 | 177.57 | 170.91 | 174.79 | 489373.0 |
| 2011-10-25 | GC | Futures | 2233.3 | 2309.7 | 2220.5 | 2295.8 | 195637.0 |
| 2011-10-25 | ZN | Futures | 110.088199 | 110.946272 | 109.860273 | 110.798791 | 1253678.0 |
| 2011-10-25 | A6 | Futures | 0.91429 | 0.91711 | 0.90823 | 0.91394 | 164839.0 |
| 2011-10-25 | AD | Futures | 0.99545 | 1.00015 | 0.97834 | 0.98535 | 116941.0 |
| 2011-10-25 | B | Futures | 97.44 | 98.0 | 95.77 | 97.05 | 113453.0 |
| 2011-10-25 | B6 | Futures | 1.6683 | 1.6731 | 1.6645 | 1.6705 | 96243.0 |
| 2011-10-25 | BFX | Futures | 2553.4 | 2560.8 | 2553.4 | 2560.8 | 25.0 |
| 2011-10-25 | BR | Futures | 0.25431 | 0.25431 | 0.2539 | 0.2539 | 212.0 |
| 2011-10-25 | BZ | Futures | 102.98 | 103.03 | 101.18 | 102.48 | 2135.0 |
| 2011-10-25 | C | Futures | 1773.0 | 1788.0 | 1761.0 | 1772.0 | 4876.0 |
| 2011-10-25 | CC | Futures | 2064.0 | 2097.0 | 2049.0 | 2067.0 | 12508.0 |
| 2011-10-25 | CSC | Futures | 4.093 | 4.093 | 4.069 | 4.069 | 15.0 |
| 2011-10-25 | CT | Futures | 126.59 | 129.73 | 125.79 | 128.51 | 17182.0 |
| 2011-10-25 | DC | Futures | 29.03 | 29.13 | 28.6 | 28.75 | 338.0 |
| 2011-10-25 | DX | Futures | 74.939 | 75.253 | 74.743 | 74.925 | 35701.0 |
| 2011-10-25 | E1 | Futures | 1.49138 | 1.49742 | 1.48456 | 1.49571 | 32358.0 |
| 2011-10-25 | E6 | Futures | 1.66433 | 1.6678 | 1.65441 | 1.66373 | 343739.0 |
| 2011-10-25 | E7 | Futures | 1.6501 | 1.6535 | 1.6404 | 1.6495 | 5819.0 |
| 2011-10-25 | ED | Futures | 94.965 | 94.9698 | 94.9507 | 94.9602 | 118723.0 |
| 2011-10-25 | ER | Futures | 97.174 | 97.209 | 97.174 | 97.199 | 88308.0 |
| 2011-10-25 | EW | Futures | 883.6 | 891.4 | 863.9 | 866.8 | 28702.0 |
| 2011-10-25 | FBTP | Futures | 61.07 | 61.22 | 60.93 | 61.14 | 4534.0 |
| 2011-10-25 | FBTS | Futures | 81.631 | 81.719 | 81.582 | 81.639 | 375.0 |
| 2011-10-25 | FCE | Futures | 2295.5 | 2315.2 | 2255.3 | 2275.0 | 101925.0 |
| 2011-10-25 | FDAX | Futures | 6535.5 | 6698.4 | 6478.0 | 6570.3 | 202210.0 |
| 2011-10-25 | FESX | Futures | 1559.7 | 1574.3 | 1537.1 | 1551.7 | 1285041.0 |
| 2011-10-25 | FEU3 | Futures | 97.747 | 97.757 | 97.747 | 97.757 | 200.0 |
| 2011-10-25 | FGBL | Futures | 109.06 | 109.54 | 108.53 | 109.44 | 966435.0 |
| 2011-10-25 | FGBM | Futures | 110.12 | 110.62 | 109.92 | 110.52 | 499103.0 |
| 2011-10-25 | FGBS | Futures | 108.83 | 109.044 | 108.805 | 109.009 | 545435.0 |
| 2011-10-25 | FGBX | Futures | 109.96 | 110.91 | 108.97 | 110.79 | 5933.0 |
| 2011-10-25 | FTDX | Futures | 648.1 | 652.7 | 638.5 | 642.6 | 171.0 |
| 2011-10-25 | FTI | Futures | 252.47 | 255.37 | 249.29 | 251.48 | 42516.0 |
| 2011-10-25 | FTUK | Futures | 3959.5 | 3982.8 | 3903.5 | 3945.1 | 121497.0 |
| 2011-10-25 | FVSA | Futures | 15001.35 | 15501.39 | 14709.66 | 15334.71 | 2268.0 |
| 2011-10-25 | FXXP | Futures | 168.1 | 168.8 | 166.3 | 167.1 | 1303.0 |
| 2011-10-25 | G | Futures | 90.39 | 90.69 | 89.73 | 90.59 | 186894.0 |
| 2011-10-25 | GF | Futures | 315.857 | 316.41 | 313.644 | 313.81 | 1486.0 |
| 2011-10-25 | GSCI | Futures | 1020.82 | 1023.25 | 1010.17 | 1017.77 | 199.0 |
| 2011-10-25 | HE | Futures | 114.175 | 114.464 | 112.118 | 112.921 | 18341.0 |
| 2011-10-25 | HG | Futures | 4.5792 | 4.6831 | 4.4436 | 4.5263 | 59871.0 |
| 2011-10-25 | HO | Futures | 2.4459 | 2.4669 | 2.427 | 2.4508 | 60388.0 |
| 2011-10-25 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-10-25 | J1 | Futures | 0.0165195 | 0.0166024 | 0.016478 | 0.016561 | 96446.0 |
| 2011-10-25 | J7 | Futures | 0.016406 | 0.0165 | 0.016376 | 0.01646 | 567.0 |
| 2011-10-25 | JB | Futures | 124.14 | 124.25 | 124.1 | 124.21 | 818.0 |
> showing 50 of 97 rows — these rows as CSV