PREVIEW / futures_daily / 2011-07-25
file: by_date/futures_daily/2011/2011-07-25.parquet size: 9 KB rows: 96
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-07-25 | ES | Futures | 1320.87 | 1331.05 | 1312.92 | 1324.34 | 1640963.0 |
| 2011-07-25 | NQ | Futures | 2753.23 | 2772.31 | 2710.24 | 2759.78 | 195167.0 |
| 2011-07-25 | YM | Futures | 11851.6 | 11915.9 | 11754.2 | 11864.8 | 94227.0 |
| 2011-07-25 | CL | Futures | 191.18 | 191.4 | 188.81 | 190.11 | 205209.0 |
| 2011-07-25 | GC | Futures | 2176.2 | 2198.4 | 2170.6 | 2182.0 | 209057.0 |
| 2011-07-25 | ZN | Futures | 105.694701 | 106.12046 | 105.468516 | 105.694701 | 1215790.0 |
| 2011-07-25 | A6 | Futures | 0.93727 | 0.93944 | 0.93222 | 0.93788 | 81025.0 |
| 2011-07-25 | AD | Futures | 1.05086 | 1.05644 | 1.04636 | 1.05445 | 56361.0 |
| 2011-07-25 | B | Futures | 100.91 | 100.99 | 99.68 | 100.55 | 124494.0 |
| 2011-07-25 | B6 | Futures | 1.6976 | 1.6985 | 1.6905 | 1.6943 | 63262.0 |
| 2011-07-25 | BFX | Futures | 3002.1 | 3032.1 | 3002.1 | 3022.2 | 847.0 |
| 2011-07-25 | BR | Futures | 0.28771 | 0.28771 | 0.2872 | 0.2872 | 54.0 |
| 2011-07-25 | BZ | Futures | 104.47 | 104.78 | 103.6 | 104.43 | 419.0 |
| 2011-07-25 | C | Futures | 2053.0 | 2064.0 | 2021.0 | 2024.0 | 6775.0 |
| 2011-07-25 | CB | Futures | 113.422 | 113.422 | 113.422 | 113.422 | 41.0 |
| 2011-07-25 | CC | Futures | 2430.0 | 2430.0 | 2357.0 | 2375.0 | 16757.0 |
| 2011-07-25 | CSC | Futures | 4.929 | 4.929 | 4.929 | 4.929 | 1.0 |
| 2011-07-25 | CT | Futures | 128.36 | 128.42 | 123.56 | 126.0 | 67.0 |
| 2011-07-25 | DC | Futures | 33.79 | 33.89 | 33.54 | 33.82 | 412.0 |
| 2011-07-25 | DX | Futures | 73.464 | 73.791 | 73.459 | 73.538 | 17298.0 |
| 2011-07-25 | E1 | Futures | 1.60918 | 1.63115 | 1.60421 | 1.62317 | 40740.0 |
| 2011-07-25 | E6 | Futures | 1.70789 | 1.70837 | 1.69851 | 1.70575 | 235496.0 |
| 2011-07-25 | E7 | Futures | 1.6948 | 1.6958 | 1.6862 | 1.6933 | 4020.0 |
| 2011-07-25 | ED | Futures | 94.9477 | 94.9525 | 94.9382 | 94.9477 | 127272.0 |
| 2011-07-25 | ER | Futures | 97.326 | 97.356 | 97.321 | 97.346 | 65388.0 |
| 2011-07-25 | EW | Futures | 973.9 | 980.3 | 967.0 | 974.4 | 17380.0 |
| 2011-07-25 | FBTP | Futures | 62.41 | 62.41 | 60.87 | 61.09 | 9104.0 |
| 2011-07-25 | FCE | Futures | 2688.4 | 2713.7 | 2685.5 | 2689.8 | 109863.0 |
| 2011-07-25 | FDAX | Futures | 7787.3 | 7890.4 | 7772.9 | 7875.4 | 121696.0 |
| 2011-07-25 | FESX | Futures | 1762.6 | 1774.8 | 1755.5 | 1762.6 | 1002680.0 |
| 2011-07-25 | FEU3 | Futures | 97.86 | 97.885 | 97.86 | 97.885 | 21.0 |
| 2011-07-25 | FGBL | Futures | 102.38 | 103.04 | 102.33 | 102.89 | 681037.0 |
| 2011-07-25 | FGBM | Futures | 106.15 | 106.66 | 106.15 | 106.52 | 378654.0 |
| 2011-07-25 | FGBS | Futures | 107.408 | 107.622 | 107.408 | 107.552 | 399190.0 |
| 2011-07-25 | FGBX | Futures | 97.42 | 98.26 | 97.18 | 97.98 | 4412.0 |
| 2011-07-25 | FTDX | Futures | 754.7 | 759.6 | 750.2 | 759.6 | 401.0 |
| 2011-07-25 | FTI | Futures | 277.22 | 279.46 | 276.72 | 278.13 | 30763.0 |
| 2011-07-25 | FTUK | Futures | 4143.8 | 4163.6 | 4122.6 | 4155.1 | 80070.0 |
| 2011-07-25 | FXXP | Futures | 182.5 | 183.8 | 182.5 | 183.1 | 1149.0 |
| 2011-07-25 | G | Futures | 85.91 | 86.38 | 85.84 | 86.17 | 84069.0 |
| 2011-07-25 | GF | Futures | 314.905 | 317.346 | 313.511 | 316.184 | 2084.0 |
| 2011-07-25 | GSCI | Futures | 1122.8 | 1122.8 | 1111.91 | 1117.99 | 111.0 |
| 2011-07-25 | HE | Futures | 110.963 | 111.872 | 110.33 | 111.184 | 8819.0 |
| 2011-07-25 | HG | Futures | 5.8133 | 5.843 | 5.7776 | 5.8252 | 27020.0 |
| 2011-07-25 | HO | Futures | 2.5442 | 2.5442 | 2.5121 | 2.5266 | 39156.0 |
| 2011-07-25 | HRC | Futures | 3010.8 | 3010.8 | 3010.8 | 3010.8 | 0.0 |
| 2011-07-25 | J1 | Futures | 0.0160634 | 0.0161099 | 0.0160055 | 0.0160659 | 82199.0 |
| 2011-07-25 | J7 | Futures | 0.015956 | 0.016001 | 0.015901 | 0.015958 | 335.0 |
| 2011-07-25 | JB | Futures | 123.21 | 123.33 | 123.13 | 123.28 | 35.0 |
| 2011-07-25 | KC | Futures | 571.33 | 579.61 | 570.26 | 574.64 | 8376.0 |
> showing 50 of 96 rows — these rows as CSV