PREVIEW / futures_daily / 2010-09-22
file: by_date/futures_daily/2010/2010-09-22.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-22 | ES | Futures | 1112.48 | 1117.63 | 1104.15 | 1107.34 | 1957234.0 |
| 2010-09-22 | NQ | Futures | 2251.34 | 2261.83 | 2234.34 | 2244.54 | 336151.0 |
| 2010-09-22 | YM | Futures | 9951.6 | 9992.6 | 9900.4 | 9931.1 | 133377.0 |
| 2010-09-22 | CL | Futures | 155.83 | 158.35 | 153.85 | 155.66 | 343846.0 |
| 2010-09-22 | GC | Futures | 1751.7 | 1764.3 | 1750.0 | 1756.3 | 124135.0 |
| 2010-09-22 | ZN | Futures | 103.59342 | 104.019252 | 103.59342 | 103.696652 | 1325882.0 |
| 2010-09-22 | A6 | Futures | 0.79237 | 0.79766 | 0.79002 | 0.79464 | 79215.0 |
| 2010-09-22 | AD | Futures | 0.9634 | 0.97033 | 0.95438 | 0.95963 | 98434.0 |
| 2010-09-22 | B | Futures | 67.44 | 67.99 | 66.83 | 67.22 | 153313.0 |
| 2010-09-22 | B6 | Futures | 1.6189 | 1.6305 | 1.6185 | 1.6257 | 114909.0 |
| 2010-09-22 | BFX | Futures | 2954.6 | 2970.2 | 2946.7 | 2946.7 | 19.0 |
| 2010-09-22 | BR | Futures | 0.24495 | 0.24495 | 0.24414 | 0.24414 | 89.0 |
| 2010-09-22 | BZ | Futures | 71.74 | 72.12 | 70.92 | 71.34 | 298.0 |
| 2010-09-22 | C | Futures | 2079.0 | 2109.0 | 2053.0 | 2059.0 | 5129.0 |
| 2010-09-22 | CB | Futures | 96.368 | 96.368 | 96.368 | 96.368 | 11.0 |
| 2010-09-22 | CC | Futures | 2298.0 | 2346.0 | 2273.0 | 2287.0 | 7878.0 |
| 2010-09-22 | CT | Futures | 85.84 | 86.59 | 84.43 | 84.43 | 56.0 |
| 2010-09-22 | DC | Futures | 25.45 | 25.47 | 25.07 | 25.2 | 103.0 |
| 2010-09-22 | DX | Futures | 80.746 | 80.761 | 80.024 | 80.319 | 22245.0 |
| 2010-09-22 | E1 | Futures | 1.31778 | 1.33551 | 1.31608 | 1.33144 | 47084.0 |
| 2010-09-22 | E6 | Futures | 1.56682 | 1.58942 | 1.56659 | 1.58315 | 427722.0 |
| 2010-09-22 | E7 | Futures | 1.5553 | 1.5774 | 1.5548 | 1.5711 | 5204.0 |
| 2010-09-22 | ED | Futures | 94.7031 | 94.7078 | 94.6888 | 94.7031 | 139415.0 |
| 2010-09-22 | ER | Futures | 97.311 | 97.335 | 97.306 | 97.326 | 127065.0 |
| 2010-09-22 | EW | Futures | 772.9 | 777.0 | 763.6 | 767.3 | 27000.0 |
| 2010-09-22 | FBTP | Futures | 66.77 | 67.11 | 66.72 | 66.91 | 4909.0 |
| 2010-09-22 | FCE | Futures | 2494.7 | 2495.4 | 2447.5 | 2451.1 | 167174.0 |
| 2010-09-22 | FDAX | Futures | 6790.2 | 6791.2 | 6670.2 | 6691.2 | 162934.0 |
| 2010-09-22 | FESX | Futures | 1744.4 | 1744.4 | 1706.9 | 1712.6 | 1444463.0 |
| 2010-09-22 | FEU3 | Futures | 97.869 | 97.889 | 97.869 | 97.889 | 45.0 |
| 2010-09-22 | FGBL | Futures | 103.06 | 103.58 | 103.03 | 103.39 | 1175589.0 |
| 2010-09-22 | FGBM | Futures | 106.16 | 106.45 | 106.1 | 106.35 | 634003.0 |
| 2010-09-22 | FGBS | Futures | 107.563 | 107.622 | 107.533 | 107.598 | 482884.0 |
| 2010-09-22 | FGBX | Futures | 106.25 | 106.99 | 106.01 | 106.52 | 3887.0 |
| 2010-09-22 | FTDX | Futures | 684.4 | 684.9 | 677.8 | 679.6 | 469.0 |
| 2010-09-22 | FTI | Futures | 272.62 | 272.62 | 267.93 | 268.29 | 38667.0 |
| 2010-09-22 | FTUK | Futures | 3854.4 | 3855.8 | 3797.4 | 3830.9 | 122868.0 |
| 2010-09-22 | G | Futures | 83.75 | 84.42 | 83.62 | 84.28 | 158246.0 |
| 2010-09-22 | GF | Futures | 277.326 | 277.829 | 273.554 | 274.183 | 1828.0 |
| 2010-09-22 | GSCI | Futures | 884.03 | 886.2 | 871.68 | 877.69 | 336.0 |
| 2010-09-22 | HE | Futures | 103.895 | 104.673 | 102.948 | 103.286 | 14214.0 |
| 2010-09-22 | HG | Futures | 4.6474 | 4.7922 | 4.644 | 4.7582 | 31302.0 |
| 2010-09-22 | HO | Futures | 1.8143 | 1.8274 | 1.7924 | 1.8081 | 16351.0 |
| 2010-09-22 | HRC | Futures | 2685.2 | 2685.2 | 2685.2 | 2685.2 | 0.0 |
| 2010-09-22 | J1 | Futures | 0.014758 | 0.0149175 | 0.0147567 | 0.0148685 | 124663.0 |
| 2010-09-22 | J7 | Futures | 0.014662 | 0.014813 | 0.014662 | 0.014766 | 252.0 |
| 2010-09-22 | JB | Futures | 121.32 | 121.64 | 121.32 | 121.61 | 1761.0 |
| 2010-09-22 | KC | Futures | 455.43 | 464.73 | 444.77 | 446.26 | 11685.0 |
| 2010-09-22 | KE | Futures | 3145.74 | 3188.5 | 3125.92 | 3155.12 | 11640.0 |
| 2010-09-22 | L | Futures | 98.135 | 98.165 | 98.115 | 98.145 | 35013.0 |
> showing 50 of 90 rows — these rows as CSV