PREVIEW / futures_daily / 2010-06-18
file: by_date/futures_daily/2010/2010-06-18.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-06-18 | ES | Futures | 1084.1 | 1089.23 | 1080.94 | 1082.89 | 1631682.0 |
| 2010-06-18 | NQ | Futures | 2161.79 | 2178.48 | 2156.13 | 2161.22 | 246943.0 |
| 2010-06-18 | YM | Futures | 9590.8 | 9637.0 | 9566.7 | 9590.8 | 115214.0 |
| 2010-06-18 | CL | Futures | 166.36 | 167.77 | 164.16 | 167.15 | 171766.0 |
| 2010-06-18 | GC | Futures | 1701.8 | 1723.8 | 1695.7 | 1716.4 | 115423.0 |
| 2010-06-18 | ZN | Futures | 98.954032 | 99.03087 | 98.646682 | 98.710713 | 664010.0 |
| 2010-06-18 | A6 | Futures | 0.71198 | 0.71645 | 0.70991 | 0.71405 | 57017.0 |
| 2010-06-18 | AD | Futures | 0.96081 | 0.96732 | 0.95695 | 0.96574 | 58708.0 |
| 2010-06-18 | B | Futures | 68.85 | 69.2 | 67.78 | 68.64 | 115163.0 |
| 2010-06-18 | B6 | Futures | 1.538 | 1.5453 | 1.5331 | 1.5355 | 72831.0 |
| 2010-06-18 | BFX | Futures | 2889.1 | 2892.9 | 2865.4 | 2865.4 | 885.0 |
| 2010-06-18 | BR | Futures | 0.23186 | 0.23186 | 0.23186 | 0.23186 | 343.0 |
| 2010-06-18 | BZ | Futures | 73.28 | 74.61 | 73.2 | 74.02 | 71.0 |
| 2010-06-18 | C | Futures | 2404.0 | 2449.0 | 2404.0 | 2440.0 | 1458.0 |
| 2010-06-18 | CB | Futures | 82.087 | 82.087 | 81.604 | 81.604 | 13.0 |
| 2010-06-18 | CC | Futures | 2464.0 | 2490.0 | 2436.0 | 2466.0 | 4441.0 |
| 2010-06-18 | CT | Futures | 64.24 | 65.47 | 63.46 | 65.0 | 3081.0 |
| 2010-06-18 | DC | Futures | 22.26 | 22.37 | 22.03 | 22.29 | 113.0 |
| 2010-06-18 | DX | Futures | 86.605 | 86.741 | 86.414 | 86.657 | 8424.0 |
| 2010-06-18 | E1 | Futures | 1.18317 | 1.18711 | 1.18186 | 1.18541 | 24783.0 |
| 2010-06-18 | E6 | Futures | 1.46475 | 1.46937 | 1.4618 | 1.46286 | 189830.0 |
| 2010-06-18 | E7 | Futures | 1.4543 | 1.4588 | 1.4514 | 1.4523 | 2513.0 |
| 2010-06-18 | ED | Futures | 94.2332 | 94.2569 | 94.2284 | 94.2474 | 142601.0 |
| 2010-06-18 | ER | Futures | 97.296 | 97.311 | 97.276 | 97.286 | 113185.0 |
| 2010-06-18 | EW | Futures | 758.5 | 760.8 | 752.7 | 753.0 | 20413.0 |
| 2010-06-18 | FBTP | Futures | 64.73 | 65.11 | 64.73 | 65.05 | 4211.0 |
| 2010-06-18 | FCE | Futures | 2429.6 | 2435.6 | 2407.3 | 2422.7 | 137250.0 |
| 2010-06-18 | FDAX | Futures | 6788.4 | 6814.0 | 6737.8 | 6769.4 | 138782.0 |
| 2010-06-18 | FESX | Futures | 1690.3 | 1698.4 | 1676.1 | 1691.0 | 1276057.0 |
| 2010-06-18 | FEU3 | Futures | 97.864 | 97.864 | 97.845 | 97.845 | 366.0 |
| 2010-06-18 | FGBL | Futures | 100.18 | 100.29 | 99.61 | 99.71 | 711625.0 |
| 2010-06-18 | FGBM | Futures | 105.14 | 105.17 | 104.7 | 104.75 | 417869.0 |
| 2010-06-18 | FGBS | Futures | 107.696 | 107.701 | 107.539 | 107.559 | 447906.0 |
| 2010-06-18 | FGBX | Futures | 98.38 | 98.74 | 97.87 | 98.09 | 2550.0 |
| 2010-06-18 | FTDX | Futures | 688.4 | 689.7 | 677.8 | 686.2 | 299.0 |
| 2010-06-18 | FTI | Futures | 266.46 | 267.01 | 264.83 | 266.3 | 32450.0 |
| 2010-06-18 | FTUK | Futures | 3594.3 | 3622.1 | 3579.8 | 3589.5 | 130469.0 |
| 2010-06-18 | G | Futures | 80.33 | 80.35 | 79.8 | 79.94 | 75501.0 |
| 2010-06-18 | GF | Futures | 278.192 | 279.077 | 277.75 | 278.319 | 1983.0 |
| 2010-06-18 | GSCI | Futures | 865.91 | 876.42 | 865.91 | 873.0 | 168.0 |
| 2010-06-18 | HE | Futures | 100.853 | 101.322 | 100.415 | 101.197 | 7770.0 |
| 2010-06-18 | HG | Futures | 3.9455 | 3.9462 | 3.8343 | 3.8859 | 12618.0 |
| 2010-06-18 | HO | Futures | 1.9111 | 1.9113 | 1.882 | 1.8958 | 12790.0 |
| 2010-06-18 | HRC | Futures | 2994.3 | 2994.3 | 2994.3 | 2994.3 | 0.0 |
| 2010-06-18 | J1 | Futures | 0.0138543 | 0.0139285 | 0.0138492 | 0.0138857 | 87781.0 |
| 2010-06-18 | J7 | Futures | 0.013765 | 0.013821 | 0.013765 | 0.013781 | 211.0 |
| 2010-06-18 | JB | Futures | 119.55 | 119.76 | 119.55 | 119.72 | 1773.0 |
| 2010-06-18 | KC | Futures | 394.91 | 408.36 | 391.23 | 406.84 | 2941.0 |
| 2010-06-18 | KE | Futures | 2151.99 | 2208.51 | 2146.56 | 2161.77 | 9581.0 |
| 2010-06-18 | L | Futures | 97.977 | 97.987 | 97.967 | 97.977 | 14999.0 |
> showing 50 of 90 rows — these rows as CSV