PREVIEW / futures_daily / 2011-05-10
file: by_date/futures_daily/2011/2011-05-10.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-05-10 | ES | Futures | 1329.09 | 1342.95 | 1325.62 | 1340.23 | 1571216.0 |
| 2011-05-10 | NQ | Futures | 2717.67 | 2746.99 | 2713.68 | 2743.86 | 291892.0 |
| 2011-05-10 | YM | Futures | 11874.4 | 11974.1 | 11847.2 | 11940.2 | 83459.0 |
| 2011-05-10 | CL | Futures | 197.41 | 200.32 | 192.94 | 200.19 | 439607.0 |
| 2011-05-10 | GC | Futures | 2047.2 | 2057.3 | 2037.3 | 2053.1 | 149351.0 |
| 2011-05-10 | ZN | Futures | 103.120334 | 103.173007 | 102.738455 | 102.896474 | 959921.0 |
| 2011-05-10 | A6 | Futures | 0.92114 | 0.92646 | 0.91668 | 0.92457 | 82549.0 |
| 2011-05-10 | AD | Futures | 1.03287 | 1.03974 | 1.03058 | 1.03765 | 72796.0 |
| 2011-05-10 | B | Futures | 97.26 | 99.62 | 96.0 | 99.37 | 190718.0 |
| 2011-05-10 | B6 | Futures | 1.7021 | 1.7053 | 1.6942 | 1.6978 | 77266.0 |
| 2011-05-10 | BR | Futures | 0.27207 | 0.27278 | 0.27207 | 0.27243 | 475.0 |
| 2011-05-10 | BZ | Futures | 101.55 | 104.71 | 101.55 | 104.71 | 1014.0 |
| 2011-05-10 | C | Futures | 2062.0 | 2088.0 | 2049.0 | 2076.0 | 13831.0 |
| 2011-05-10 | CC | Futures | 2453.0 | 2488.0 | 2445.0 | 2472.0 | 6632.0 |
| 2011-05-10 | CT | Futures | 143.09 | 149.85 | 141.54 | 149.85 | 12242.0 |
| 2011-05-10 | DC | Futures | 29.74 | 30.07 | 29.74 | 30.0 | 319.0 |
| 2011-05-10 | DX | Futures | 74.402 | 74.8 | 74.312 | 74.409 | 32103.0 |
| 2011-05-10 | E1 | Futures | 1.50096 | 1.50423 | 1.48407 | 1.48655 | 47553.0 |
| 2011-05-10 | E6 | Futures | 1.69844 | 1.70591 | 1.68885 | 1.70366 | 320311.0 |
| 2011-05-10 | E7 | Futures | 1.6863 | 1.693 | 1.6763 | 1.691 | 6047.0 |
| 2011-05-10 | ED | Futures | 94.9502 | 94.9597 | 94.9454 | 94.9549 | 114127.0 |
| 2011-05-10 | ER | Futures | 97.286 | 97.291 | 97.267 | 97.286 | 116806.0 |
| 2011-05-10 | EW | Futures | 991.1 | 1003.7 | 989.2 | 1001.6 | 19587.0 |
| 2011-05-10 | FBTP | Futures | 64.79 | 65.06 | 64.79 | 65.04 | 5458.0 |
| 2011-05-10 | FCE | Futures | 2702.5 | 2750.8 | 2699.4 | 2737.2 | 153525.0 |
| 2011-05-10 | FDAX | Futures | 7933.5 | 8058.9 | 7929.7 | 8016.2 | 134840.0 |
| 2011-05-10 | FESX | Futures | 1834.4 | 1870.9 | 1833.7 | 1861.9 | 1228194.0 |
| 2011-05-10 | FEU3 | Futures | 97.82 | 97.83 | 97.82 | 97.83 | 185.0 |
| 2011-05-10 | FGBL | Futures | 99.36 | 99.4 | 99.11 | 99.23 | 1046423.0 |
| 2011-05-10 | FGBM | Futures | 103.78 | 103.81 | 103.57 | 103.74 | 540207.0 |
| 2011-05-10 | FGBS | Futures | 106.518 | 106.528 | 106.429 | 106.503 | 648519.0 |
| 2011-05-10 | FGBX | Futures | 96.28 | 96.54 | 95.79 | 96.15 | 4989.0 |
| 2011-05-10 | FTDX | Futures | 833.3 | 835.1 | 829.7 | 832.4 | 215.0 |
| 2011-05-10 | FTI | Futures | 291.85 | 296.07 | 291.6 | 295.33 | 73.0 |
| 2011-05-10 | FTUK | Futures | 4148.3 | 4211.7 | 4138.9 | 4193.1 | 88682.0 |
| 2011-05-10 | FXXP | Futures | 186.1 | 188.3 | 186.1 | 187.9 | 1245.0 |
| 2011-05-10 | G | Futures | 83.62 | 83.69 | 83.5 | 83.58 | 124694.0 |
| 2011-05-10 | GF | Futures | 308.05 | 309.27 | 307.294 | 307.643 | 2088.0 |
| 2011-05-10 | GSCI | Futures | 1092.69 | 1110.3 | 1089.16 | 1110.06 | 1890.0 |
| 2011-05-10 | HE | Futures | 98.19 | 99.435 | 98.005 | 98.985 | 25509.0 |
| 2011-05-10 | HG | Futures | 5.3873 | 5.4258 | 5.3195 | 5.37 | 27824.0 |
| 2011-05-10 | HO | Futures | 2.461 | 2.5033 | 2.4279 | 2.4938 | 59458.0 |
| 2011-05-10 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-10 | J1 | Futures | 0.0156486 | 0.0156775 | 0.0155104 | 0.0155531 | 83973.0 |
| 2011-05-10 | J7 | Futures | 0.015558 | 0.015579 | 0.015428 | 0.015458 | 466.0 |
| 2011-05-10 | JB | Futures | 122.55 | 122.61 | 122.35 | 122.4 | 24.0 |
| 2011-05-10 | KC | Futures | 692.78 | 696.49 | 675.39 | 677.67 | 11424.0 |
| 2011-05-10 | KE | Futures | 3614.93 | 3734.41 | 3613.95 | 3667.27 | 16337.0 |
| 2011-05-10 | L | Futures | 98.423 | 98.443 | 98.423 | 98.443 | 24771.0 |
| 2011-05-10 | LBS | Futures | 545.1 | 546.0 | 536.1 | 539.3 | 440.0 |
> showing 50 of 91 rows — these rows as CSV