PREVIEW / futures_daily / 2010-04-01
file: by_date/futures_daily/2010/2010-04-01.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-04-01 | ES | Futures | 1136.41 | 1146.63 | 1135.19 | 1142.98 | 1942722.0 |
| 2010-04-01 | NQ | Futures | 2218.67 | 2243.06 | 2201.65 | 2214.41 | 309482.0 |
| 2010-04-01 | YM | Futures | 9943.7 | 10019.1 | 9933.6 | 9983.2 | 120063.0 |
| 2010-04-01 | CL | Futures | 195.04 | 199.74 | 194.69 | 198.57 | 295387.0 |
| 2010-04-01 | GC | Futures | 1529.3 | 1549.2 | 1526.1 | 1545.0 | 108427.0 |
| 2010-04-01 | ZN | Futures | 94.836029 | 94.887044 | 94.529942 | 94.708493 | 888553.0 |
| 2010-04-01 | A6 | Futures | 0.74684 | 0.75054 | 0.74488 | 0.74832 | 73968.0 |
| 2010-04-01 | AD | Futures | 0.97195 | 0.98054 | 0.97116 | 0.97847 | 68309.0 |
| 2010-04-01 | B | Futures | 74.15 | 75.89 | 73.91 | 75.49 | 82196.0 |
| 2010-04-01 | B6 | Futures | 1.5759 | 1.5877 | 1.5746 | 1.5847 | 107902.0 |
| 2010-04-01 | BFX | Futures | 2996.4 | 3017.5 | 2991.8 | 3017.5 | 297.0 |
| 2010-04-01 | BR | Futures | 0.2284 | 0.22871 | 0.2284 | 0.22871 | 95.0 |
| 2010-04-01 | C | Futures | 2262.0 | 2284.0 | 2253.0 | 2262.0 | 2989.0 |
| 2010-04-01 | CB | Futures | 74.764 | 74.764 | 74.394 | 74.394 | 1.0 |
| 2010-04-01 | CC | Futures | 2509.0 | 2540.0 | 2490.0 | 2531.0 | 8738.0 |
| 2010-04-01 | CT | Futures | 65.98 | 66.39 | 65.61 | 66.28 | 8308.0 |
| 2010-04-01 | DC | Futures | 22.99 | 23.1 | 22.8 | 22.99 | 153.0 |
| 2010-04-01 | DX | Futures | 82.3 | 82.564 | 81.89 | 82.054 | 26581.0 |
| 2010-04-01 | E1 | Futures | 1.24946 | 1.26223 | 1.2409 | 1.24801 | 71025.0 |
| 2010-04-01 | E6 | Futures | 1.59786 | 1.60803 | 1.5923 | 1.60531 | 312578.0 |
| 2010-04-01 | E7 | Futures | 1.5846 | 1.595 | 1.5794 | 1.5922 | 4134.0 |
| 2010-04-01 | EBM | Futures | 205.22 | 206.86 | 205.22 | 206.04 | 4775.0 |
| 2010-04-01 | ED | Futures | 94.3944 | 94.4039 | 94.3944 | 94.3992 | 126204.0 |
| 2010-04-01 | ER | Futures | 97.389 | 97.399 | 97.365 | 97.375 | 198600.0 |
| 2010-04-01 | EW | Futures | 768.0 | 777.5 | 767.4 | 775.3 | 25205.0 |
| 2010-04-01 | FBTP | Futures | 64.91 | 65.06 | 64.91 | 65.06 | 2433.0 |
| 2010-04-01 | FCE | Futures | 2558.2 | 2586.4 | 2553.4 | 2581.6 | 116416.0 |
| 2010-04-01 | FDAX | Futures | 6737.3 | 6797.1 | 6725.9 | 6775.9 | 119540.0 |
| 2010-04-01 | FESX | Futures | 1763.7 | 1784.5 | 1760.0 | 1777.2 | 971310.0 |
| 2010-04-01 | FEU3 | Futures | 97.938 | 97.938 | 97.934 | 97.934 | 1582.0 |
| 2010-04-01 | FGBL | Futures | 96.29 | 96.38 | 96.09 | 96.33 | 664195.0 |
| 2010-04-01 | FGBM | Futures | 101.93 | 101.98 | 101.81 | 101.93 | 427721.0 |
| 2010-04-01 | FGBS | Futures | 106.434 | 106.444 | 106.385 | 106.424 | 371542.0 |
| 2010-04-01 | FGBX | Futures | 91.64 | 92.13 | 91.28 | 91.96 | 4013.0 |
| 2010-04-01 | FTDX | Futures | 726.1 | 731.8 | 724.3 | 728.7 | 633.0 |
| 2010-04-01 | FTI | Futures | 278.74 | 284.38 | 278.74 | 283.93 | 34694.0 |
| 2010-04-01 | FTUK | Futures | 3822.5 | 3860.4 | 3822.1 | 3845.5 | 93677.0 |
| 2010-04-01 | G | Futures | 76.37 | 76.7 | 76.17 | 76.57 | 83037.0 |
| 2010-04-01 | GF | Futures | 288.536 | 288.992 | 286.709 | 288.014 | 622.0 |
| 2010-04-01 | GSCI | Futures | 984.34 | 992.44 | 984.34 | 992.35 | 864.0 |
| 2010-04-01 | HE | Futures | 98.494 | 99.745 | 98.098 | 99.745 | 299.0 |
| 2010-04-01 | HG | Futures | 4.8529 | 4.9267 | 4.831 | 4.8966 | 21404.0 |
| 2010-04-01 | HO | Futures | 1.9906 | 2.0432 | 1.985 | 2.0331 | 19207.0 |
| 2010-04-01 | HRC | Futures | 3221.8 | 3221.8 | 3221.8 | 3221.8 | 0.0 |
| 2010-04-01 | J1 | Futures | 0.0134607 | 0.0134833 | 0.0133739 | 0.0134054 | 103683.0 |
| 2010-04-01 | J7 | Futures | 0.013353 | 0.013374 | 0.01327 | 0.013298 | 291.0 |
| 2010-04-01 | JB | Futures | 117.44 | 117.89 | 117.3 | 117.8 | 4258.0 |
| 2010-04-01 | KC | Futures | 350.7 | 354.3 | 350.06 | 352.88 | 9574.0 |
| 2010-04-01 | KE | Futures | 2052.79 | 2090.45 | 2052.79 | 2082.7 | 10524.0 |
| 2010-04-01 | L | Futures | 97.868 | 97.878 | 97.868 | 97.878 | 21119.0 |
> showing 50 of 90 rows — these rows as CSV