PREVIEW / futures_daily / 2010-01-29
file: by_date/futures_daily/2010/2010-01-29.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-01-29 | ES | Futures | 1047.86 | 1059.74 | 1033.81 | 1037.68 | 3068079.0 |
| 2010-01-29 | NQ | Futures | 2010.72 | 2023.73 | 1958.69 | 1967.18 | 538161.0 |
| 2010-01-29 | YM | Futures | 9198.3 | 9309.8 | 9128.9 | 9149.9 | 189885.0 |
| 2010-01-29 | CL | Futures | 174.53 | 176.72 | 171.08 | 172.17 | 335270.0 |
| 2010-01-29 | GC | Futures | 1491.4 | 1497.4 | 1474.9 | 1487.0 | 182586.0 |
| 2010-01-29 | ZN | Futures | 94.983029 | 95.461596 | 94.580025 | 95.234906 | 1211739.0 |
| 2010-01-29 | A6 | Futures | 0.72347 | 0.72502 | 0.71453 | 0.71632 | 142139.0 |
| 2010-01-29 | AD | Futures | 0.92555 | 0.92921 | 0.9219 | 0.92308 | 84803.0 |
| 2010-01-29 | B | Futures | 65.33 | 66.34 | 64.3 | 64.68 | 62977.0 |
| 2010-01-29 | B6 | Futures | 1.6745 | 1.6799 | 1.6592 | 1.6604 | 147214.0 |
| 2010-01-29 | BFX | Futures | 2829.2 | 2833.3 | 2797.6 | 2831.5 | 210.0 |
| 2010-01-29 | BR | Futures | 0.21175 | 0.21175 | 0.21175 | 0.21175 | 38.0 |
| 2010-01-29 | BZ | Futures | 67.84 | 67.84 | 67.84 | 67.84 | 260.0 |
| 2010-01-29 | C | Futures | 2273.0 | 2297.0 | 2254.0 | 2265.0 | 7526.0 |
| 2010-01-29 | CC | Futures | 2822.0 | 2824.0 | 2728.0 | 2735.0 | 11614.0 |
| 2010-01-29 | CT | Futures | 56.37 | 56.84 | 56.19 | 56.28 | 10434.0 |
| 2010-01-29 | DC | Futures | 22.66 | 22.66 | 22.46 | 22.5 | 118.0 |
| 2010-01-29 | DX | Futures | 80.583 | 81.03 | 80.41 | 81.0 | 23437.0 |
| 2010-01-29 | E1 | Futures | 1.25333 | 1.25821 | 1.23909 | 1.24331 | 71688.0 |
| 2010-01-29 | E6 | Futures | 1.65302 | 1.65586 | 1.64059 | 1.64142 | 356293.0 |
| 2010-01-29 | E7 | Futures | 1.6414 | 1.6441 | 1.6291 | 1.63 | 4230.0 |
| 2010-01-29 | EBM | Futures | 212.93 | 214.62 | 212.08 | 212.5 | 6007.0 |
| 2010-01-29 | ED | Futures | 94.3773 | 94.3773 | 94.3631 | 94.3725 | 135456.0 |
| 2010-01-29 | ER | Futures | 97.306 | 97.316 | 97.301 | 97.311 | 91412.0 |
| 2010-01-29 | EW | Futures | 691.5 | 699.2 | 678.5 | 681.5 | 44464.0 |
| 2010-01-29 | FBTP | Futures | 62.94 | 63.18 | 62.91 | 63.12 | 8193.0 |
| 2010-01-29 | FCE | Futures | 2407.5 | 2454.4 | 2398.0 | 2434.5 | 159480.0 |
| 2010-01-29 | FDAX | Futures | 6073.5 | 6182.7 | 6055.5 | 6125.4 | 191262.0 |
| 2010-01-29 | FESX | Futures | 1638.3 | 1676.0 | 1635.9 | 1659.9 | 1832554.0 |
| 2010-01-29 | FEU3 | Futures | 97.874 | 97.874 | 97.869 | 97.874 | 254.0 |
| 2010-01-29 | FGBL | Futures | 95.2 | 95.38 | 94.8 | 95.13 | 923100.0 |
| 2010-01-29 | FGBM | Futures | 100.82 | 100.93 | 100.56 | 100.78 | 503070.0 |
| 2010-01-29 | FGBS | Futures | 105.703 | 105.737 | 105.606 | 105.683 | 598245.0 |
| 2010-01-29 | FGBX | Futures | 89.43 | 89.75 | 89.0 | 89.64 | 6623.0 |
| 2010-01-29 | FTDX | Futures | 711.9 | 716.8 | 704.4 | 711.1 | 1479.0 |
| 2010-01-29 | FTI | Futures | 262.01 | 267.25 | 262.01 | 265.79 | 39083.0 |
| 2010-01-29 | FTUK | Futures | 3429.6 | 3475.8 | 3402.4 | 3448.3 | 161918.0 |
| 2010-01-29 | G | Futures | 75.65 | 76.15 | 75.61 | 75.95 | 84268.0 |
| 2010-01-29 | GF | Futures | 266.068 | 269.377 | 266.068 | 267.08 | 2963.0 |
| 2010-01-29 | GSCI | Futures | 926.36 | 926.36 | 903.56 | 908.98 | 2384.0 |
| 2010-01-29 | HE | Futures | 92.665 | 93.501 | 91.694 | 91.795 | 13454.0 |
| 2010-01-29 | HG | Futures | 4.3021 | 4.3511 | 4.1862 | 4.2111 | 42980.0 |
| 2010-01-29 | HO | Futures | 1.7988 | 1.8173 | 1.7692 | 1.7809 | 45017.0 |
| 2010-01-29 | HRC | Futures | 2729.2 | 2729.2 | 2729.2 | 2729.2 | 0.0 |
| 2010-01-29 | J1 | Futures | 0.0139976 | 0.0140492 | 0.0138415 | 0.0139409 | 155952.0 |
| 2010-01-29 | J7 | Futures | 0.013843 | 0.013904 | 0.013641 | 0.013766 | 163.0 |
| 2010-01-29 | JB | Futures | 117.79 | 117.96 | 117.75 | 117.78 | 3235.0 |
| 2010-01-29 | KC | Futures | 345.15 | 348.53 | 342.55 | 342.81 | 10265.0 |
| 2010-01-29 | KE | Futures | 2237.47 | 2241.99 | 2193.38 | 2202.42 | 10432.0 |
| 2010-01-29 | L | Futures | 97.829 | 97.838 | 97.819 | 97.829 | 34565.0 |
> showing 50 of 90 rows — these rows as CSV