PREVIEW / futures_daily / 2010-09-21
file: by_date/futures_daily/2010/2010-09-21.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-09-21 | ES | Futures | 1113.95 | 1121.3 | 1107.83 | 1112.24 | 2098867.0 |
| 2010-09-21 | NQ | Futures | 2247.38 | 2268.07 | 2241.71 | 2251.34 | 319921.0 |
| 2010-09-21 | YM | Futures | 9930.2 | 10016.7 | 9897.6 | 9950.7 | 140828.0 |
| 2010-09-21 | CL | Futures | 158.77 | 159.12 | 155.58 | 156.2 | 311954.0 |
| 2010-09-21 | GC | Futures | 1740.4 | 1756.7 | 1729.0 | 1732.1 | 147878.0 |
| 2010-09-21 | ZN | Futures | 102.754659 | 103.619228 | 102.638523 | 103.541804 | 1455712.0 |
| 2010-09-21 | A6 | Futures | 0.78583 | 0.79464 | 0.7844 | 0.79229 | 73402.0 |
| 2010-09-21 | AD | Futures | 0.96013 | 0.96805 | 0.95666 | 0.96498 | 77407.0 |
| 2010-09-21 | B | Futures | 68.34 | 68.99 | 67.26 | 67.62 | 156070.0 |
| 2010-09-21 | B6 | Futures | 1.613 | 1.6232 | 1.6085 | 1.6206 | 93130.0 |
| 2010-09-21 | BFX | Futures | 2972.9 | 2998.9 | 2971.8 | 2977.3 | 293.0 |
| 2010-09-21 | BR | Futures | 0.24476 | 0.24516 | 0.24473 | 0.24495 | 69.0 |
| 2010-09-21 | BZ | Futures | 72.82 | 73.19 | 71.44 | 71.77 | 364.0 |
| 2010-09-21 | C | Futures | 2036.0 | 2093.0 | 2020.0 | 2079.0 | 6686.0 |
| 2010-09-21 | CB | Futures | 96.09 | 96.645 | 96.09 | 96.368 | 53.0 |
| 2010-09-21 | CC | Futures | 2249.0 | 2315.0 | 2220.0 | 2301.0 | 9226.0 |
| 2010-09-21 | CT | Futures | 85.53 | 87.07 | 85.53 | 85.55 | 67.0 |
| 2010-09-21 | DC | Futures | 25.78 | 25.78 | 25.37 | 25.52 | 140.0 |
| 2010-09-21 | DX | Futures | 81.825 | 81.83 | 80.681 | 80.93 | 23964.0 |
| 2010-09-21 | E1 | Futures | 1.30728 | 1.3191 | 1.304 | 1.31608 | 34491.0 |
| 2010-09-21 | E6 | Futures | 1.5447 | 1.57132 | 1.54411 | 1.56623 | 327891.0 |
| 2010-09-21 | E7 | Futures | 1.5326 | 1.5595 | 1.5323 | 1.5543 | 4502.0 |
| 2010-09-21 | ED | Futures | 94.6746 | 94.7078 | 94.6698 | 94.7031 | 237269.0 |
| 2010-09-21 | ER | Futures | 97.296 | 97.311 | 97.286 | 97.306 | 164568.0 |
| 2010-09-21 | EW | Futures | 775.4 | 779.6 | 771.3 | 772.9 | 29280.0 |
| 2010-09-21 | FBTP | Futures | 66.45 | 66.73 | 66.42 | 66.57 | 5324.0 |
| 2010-09-21 | FCE | Futures | 2490.5 | 2511.1 | 2472.4 | 2482.9 | 132420.0 |
| 2010-09-21 | FDAX | Futures | 6779.9 | 6829.4 | 6749.3 | 6771.3 | 144344.0 |
| 2010-09-21 | FESX | Futures | 1740.6 | 1758.1 | 1728.8 | 1738.1 | 1243772.0 |
| 2010-09-21 | FEU3 | Futures | 97.869 | 97.869 | 97.859 | 97.869 | 1133.0 |
| 2010-09-21 | FGBL | Futures | 102.47 | 103.0 | 102.2 | 102.52 | 866372.0 |
| 2010-09-21 | FGBM | Futures | 105.83 | 106.15 | 105.68 | 105.87 | 403658.0 |
| 2010-09-21 | FGBS | Futures | 107.489 | 107.583 | 107.43 | 107.489 | 328833.0 |
| 2010-09-21 | FGBX | Futures | 104.78 | 106.07 | 104.25 | 105.12 | 3368.0 |
| 2010-09-21 | FTDX | Futures | 687.5 | 695.0 | 684.4 | 685.3 | 306.0 |
| 2010-09-21 | FTI | Futures | 272.86 | 274.66 | 270.81 | 271.93 | 29956.0 |
| 2010-09-21 | FTUK | Futures | 3850.6 | 3881.4 | 3831.2 | 3842.6 | 96689.0 |
| 2010-09-21 | G | Futures | 83.24 | 83.34 | 83.0 | 83.3 | 87232.0 |
| 2010-09-21 | GF | Futures | 278.898 | 280.344 | 276.949 | 278.269 | 1741.0 |
| 2010-09-21 | GSCI | Futures | 888.2 | 889.95 | 877.77 | 879.36 | 214.0 |
| 2010-09-21 | HE | Futures | 104.064 | 105.553 | 103.76 | 104.301 | 20321.0 |
| 2010-09-21 | HG | Futures | 4.6808 | 4.7088 | 4.6347 | 4.646 | 24213.0 |
| 2010-09-21 | HO | Futures | 1.8252 | 1.8496 | 1.808 | 1.8154 | 22024.0 |
| 2010-09-21 | HRC | Futures | 2707.8 | 2707.8 | 2707.8 | 2707.8 | 0.0 |
| 2010-09-21 | J1 | Futures | 0.0146738 | 0.0147931 | 0.0146612 | 0.014773 | 127697.0 |
| 2010-09-21 | J7 | Futures | 0.014582 | 0.014689 | 0.014582 | 0.014672 | 121.0 |
| 2010-09-21 | JB | Futures | 121.13 | 121.43 | 121.07 | 121.36 | 1776.0 |
| 2010-09-21 | KC | Futures | 453.45 | 461.01 | 449.36 | 453.57 | 10340.0 |
| 2010-09-21 | KE | Futures | 3156.17 | 3179.11 | 3120.7 | 3129.05 | 13922.0 |
| 2010-09-21 | L | Futures | 98.096 | 98.125 | 98.096 | 98.125 | 37508.0 |
> showing 50 of 90 rows — these rows as CSV