PREVIEW / futures_daily / 2010-11-01
file: by_date/futures_daily/2010/2010-11-01.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 |
|---|---|---|---|---|---|---|---|
| 2010-11-01 | ES | Futures | 1157.08 | 1169.09 | 1150.46 | 1159.53 | 2032082.0 |
| 2010-11-01 | NQ | Futures | 2409.52 | 2433.9 | 2398.18 | 2414.06 | 286483.0 |
| 2010-11-01 | YM | Futures | 10298.7 | 10417.8 | 10243.8 | 10319.2 | 145917.0 |
| 2010-11-01 | CL | Futures | 167.92 | 172.89 | 167.66 | 171.02 | 358535.0 |
| 2010-11-01 | GC | Futures | 1848.2 | 1857.3 | 1833.8 | 1835.8 | 126687.0 |
| 2010-11-01 | ZN | Futures | 104.290237 | 104.612837 | 104.122484 | 104.316045 | 989795.0 |
| 2010-11-01 | A6 | Futures | 0.82259 | 0.82804 | 0.81948 | 0.82275 | 74107.0 |
| 2010-11-01 | AD | Futures | 0.97142 | 0.97727 | 0.96994 | 0.97271 | 70952.0 |
| 2010-11-01 | B | Futures | 70.9 | 72.92 | 70.9 | 72.18 | 115007.0 |
| 2010-11-01 | B6 | Futures | 1.6653 | 1.6698 | 1.6594 | 1.6639 | 78309.0 |
| 2010-11-01 | BFX | Futures | 3080.3 | 3091.2 | 3057.9 | 3073.3 | 23.0 |
| 2010-11-01 | BR | Futures | 0.25007 | 0.25007 | 0.24879 | 0.24888 | 255.0 |
| 2010-11-01 | BZ | Futures | 75.3 | 76.94 | 75.18 | 76.35 | 365.0 |
| 2010-11-01 | C | Futures | 2016.0 | 2033.0 | 2006.0 | 2011.0 | 3055.0 |
| 2010-11-01 | CC | Futures | 2322.0 | 2329.0 | 2282.0 | 2284.0 | 8892.0 |
| 2010-11-01 | CT | Futures | 106.48 | 109.41 | 106.48 | 109.41 | 10340.0 |
| 2010-11-01 | DC | Futures | 23.73 | 23.81 | 23.35 | 23.44 | 654.0 |
| 2010-11-01 | DX | Futures | 77.351 | 77.872 | 77.21 | 77.728 | 21537.0 |
| 2010-11-01 | E1 | Futures | 1.33656 | 1.33866 | 1.317 | 1.32382 | 44983.0 |
| 2010-11-01 | E6 | Futures | 1.6514 | 1.6566 | 1.63898 | 1.64194 | 289250.0 |
| 2010-11-01 | E7 | Futures | 1.6398 | 1.644 | 1.6267 | 1.6295 | 4219.0 |
| 2010-11-01 | ED | Futures | 94.7411 | 94.7458 | 94.7316 | 94.7411 | 153844.0 |
| 2010-11-01 | ER | Futures | 97.173 | 97.193 | 97.168 | 97.183 | 86232.0 |
| 2010-11-01 | EW | Futures | 814.2 | 822.5 | 807.2 | 813.5 | 29025.0 |
| 2010-11-01 | FBTP | Futures | 67.06 | 67.2 | 67.06 | 67.09 | 1167.0 |
| 2010-11-01 | FCE | Futures | 2559.6 | 2564.6 | 2515.3 | 2543.9 | 146193.0 |
| 2010-11-01 | FDAX | Futures | 7170.4 | 7184.9 | 7061.7 | 7112.3 | 143846.0 |
| 2010-11-01 | FESX | Futures | 1785.6 | 1789.3 | 1745.6 | 1764.4 | 1216538.0 |
| 2010-11-01 | FEU3 | Futures | 97.736 | 97.746 | 97.736 | 97.746 | 322.0 |
| 2010-11-01 | FGBL | Futures | 102.19 | 102.82 | 102.14 | 102.55 | 839951.0 |
| 2010-11-01 | FGBM | Futures | 105.55 | 105.9 | 105.51 | 105.76 | 380097.0 |
| 2010-11-01 | FGBS | Futures | 107.194 | 107.263 | 107.164 | 107.223 | 330987.0 |
| 2010-11-01 | FGBX | Futures | 105.27 | 107.1 | 105.09 | 106.45 | 3256.0 |
| 2010-11-01 | FTDX | Futures | 730.2 | 732.4 | 721.4 | 723.1 | 338.0 |
| 2010-11-01 | FTI | Futures | 271.81 | 272.29 | 268.65 | 270.93 | 33841.0 |
| 2010-11-01 | FTUK | Futures | 3929.0 | 3952.5 | 3895.2 | 3922.8 | 112813.0 |
| 2010-11-01 | G | Futures | 83.73 | 84.38 | 83.73 | 84.04 | 128339.0 |
| 2010-11-01 | GF | Futures | 277.837 | 278.719 | 276.516 | 277.837 | 1320.0 |
| 2010-11-01 | GSCI | Futures | 939.5 | 951.55 | 937.6 | 941.98 | 475.0 |
| 2010-11-01 | HE | Futures | 89.923 | 90.024 | 88.164 | 88.231 | 16505.0 |
| 2010-11-01 | HG | Futures | 5.0024 | 5.0932 | 5.0017 | 5.0518 | 26915.0 |
| 2010-11-01 | HH | Futures | 35.823 | 35.833 | 35.823 | 35.833 | 1.0 |
| 2010-11-01 | HO | Futures | 1.8878 | 1.9434 | 1.8867 | 1.9215 | 48301.0 |
| 2010-11-01 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-11-01 | J1 | Futures | 0.015641 | 0.0156586 | 0.0153973 | 0.015597 | 99514.0 |
| 2010-11-01 | J7 | Futures | 0.015531 | 0.015547 | 0.015332 | 0.01549 | 756.0 |
| 2010-11-01 | JB | Futures | 122.03 | 122.15 | 121.84 | 121.87 | 2021.0 |
| 2010-11-01 | KC | Futures | 502.92 | 504.04 | 490.15 | 490.28 | 10982.0 |
| 2010-11-01 | KE | Futures | 3231.26 | 3254.21 | 3144.69 | 3146.78 | 11554.0 |
| 2010-11-01 | L | Futures | 98.155 | 98.175 | 98.155 | 98.165 | 29897.0 |
> showing 50 of 91 rows — these rows as CSV