PREVIEW / futures_daily / 2010-04-12
file: by_date/futures_daily/2010/2010-04-12.parquet size: 9 KB rows: 91
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-12 | ES | Futures | 1163.43 | 1167.08 | 1159.54 | 1161.24 | 1253624.0 |
| 2010-04-12 | NQ | Futures | 2263.19 | 2270.85 | 2254.97 | 2260.36 | 183339.0 |
| 2010-04-12 | YM | Futures | 10084.4 | 10114.7 | 10054.9 | 10067.8 | 90277.0 |
| 2010-04-12 | CL | Futures | 199.27 | 200.54 | 196.72 | 197.33 | 421904.0 |
| 2010-04-12 | GC | Futures | 1600.2 | 1606.2 | 1584.4 | 1594.6 | 122400.0 |
| 2010-04-12 | ZN | Futures | 94.542695 | 95.040087 | 94.364145 | 94.887044 | 883541.0 |
| 2010-04-12 | A6 | Futures | 0.76284 | 0.76555 | 0.75374 | 0.75653 | 69688.0 |
| 2010-04-12 | AD | Futures | 0.98271 | 0.98607 | 0.97837 | 0.9839 | 58804.0 |
| 2010-04-12 | B | Futures | 75.89 | 77.27 | 75.89 | 76.53 | 175326.0 |
| 2010-04-12 | B6 | Futures | 1.6027 | 1.6072 | 1.5934 | 1.5958 | 85810.0 |
| 2010-04-12 | BFX | Futures | 3044.0 | 3044.1 | 3036.4 | 3036.4 | 27.0 |
| 2010-04-12 | BR | Futures | 0.23053 | 0.23053 | 0.23053 | 0.23053 | 15.0 |
| 2010-04-12 | BZ | Futures | 80.81 | 80.88 | 79.98 | 80.18 | 411.0 |
| 2010-04-12 | C | Futures | 2145.0 | 2176.0 | 2136.0 | 2163.0 | 3274.0 |
| 2010-04-12 | CB | Futures | 76.985 | 76.985 | 76.985 | 76.985 | 3.0 |
| 2010-04-12 | CC | Futures | 2417.0 | 2472.0 | 2408.0 | 2461.0 | 9671.0 |
| 2010-04-12 | CT | Futures | 63.73 | 64.42 | 63.51 | 63.54 | 12199.0 |
| 2010-04-12 | DC | Futures | 22.41 | 22.57 | 22.07 | 22.33 | 379.0 |
| 2010-04-12 | DX | Futures | 81.93 | 81.93 | 81.287 | 81.77 | 20213.0 |
| 2010-04-12 | E1 | Futures | 1.24551 | 1.24814 | 1.24051 | 1.2438 | 46625.0 |
| 2010-04-12 | E6 | Futures | 1.61217 | 1.61998 | 1.60496 | 1.60744 | 305464.0 |
| 2010-04-12 | E7 | Futures | 1.5974 | 1.6066 | 1.5918 | 1.5943 | 4833.0 |
| 2010-04-12 | EBM | Futures | 208.5 | 208.91 | 207.27 | 208.09 | 5044.0 |
| 2010-04-12 | ED | Futures | 94.3897 | 94.3992 | 94.3897 | 94.3944 | 81181.0 |
| 2010-04-12 | ER | Futures | 97.345 | 97.36 | 97.33 | 97.36 | 91993.0 |
| 2010-04-12 | EW | Futures | 793.4 | 796.6 | 789.4 | 792.3 | 18420.0 |
| 2010-04-12 | FBTP | Futures | 64.77 | 64.97 | 64.71 | 64.91 | 2960.0 |
| 2010-04-12 | FCE | Futures | 2590.2 | 2597.0 | 2565.6 | 2577.2 | 41547.0 |
| 2010-04-12 | FDAX | Futures | 6842.8 | 6855.8 | 6775.3 | 6810.2 | 112024.0 |
| 2010-04-12 | FESX | Futures | 1800.4 | 1806.6 | 1785.7 | 1795.5 | 906024.0 |
| 2010-04-12 | FEU3 | Futures | 97.904 | 97.919 | 97.904 | 97.919 | 247.0 |
| 2010-04-12 | FGBL | Futures | 95.62 | 95.82 | 95.3 | 95.73 | 811377.0 |
| 2010-04-12 | FGBM | Futures | 101.52 | 101.63 | 101.31 | 101.57 | 547901.0 |
| 2010-04-12 | FGBS | Futures | 106.331 | 106.37 | 106.263 | 106.336 | 529690.0 |
| 2010-04-12 | FGBX | Futures | 90.25 | 90.94 | 90.21 | 90.61 | 2600.0 |
| 2010-04-12 | FTDX | Futures | 740.7 | 746.0 | 739.8 | 742.9 | 242.0 |
| 2010-04-12 | FTI | Futures | 287.58 | 288.19 | 284.77 | 285.51 | 2216.0 |
| 2010-04-12 | FTUK | Futures | 3892.9 | 3894.9 | 3864.1 | 3880.3 | 72990.0 |
| 2010-04-12 | G | Futures | 75.59 | 75.83 | 75.51 | 75.77 | 50723.0 |
| 2010-04-12 | GF | Futures | 298.843 | 299.943 | 297.031 | 297.807 | 3066.0 |
| 2010-04-12 | GSCI | Futures | 991.89 | 997.24 | 987.26 | 988.35 | 3122.0 |
| 2010-04-12 | HE | Futures | 101.79 | 102.156 | 101.301 | 101.423 | 449.0 |
| 2010-04-12 | HG | Futures | 4.9171 | 5.0278 | 4.8461 | 4.87 | 37306.0 |
| 2010-04-12 | HO | Futures | 2.0552 | 2.0626 | 2.0342 | 2.0392 | 26003.0 |
| 2010-04-12 | HRC | Futures | 3221.8 | 3221.8 | 3221.8 | 3221.8 | 0.0 |
| 2010-04-12 | J1 | Futures | 0.013506 | 0.0135286 | 0.0134368 | 0.0134997 | 70676.0 |
| 2010-04-12 | J7 | Futures | 0.013389 | 0.013413 | 0.013332 | 0.013392 | 117.0 |
| 2010-04-12 | JB | Futures | 117.61 | 117.63 | 117.44 | 117.49 | 1069.0 |
| 2010-04-12 | KC | Futures | 342.87 | 344.66 | 341.71 | 343.0 | 16264.0 |
| 2010-04-12 | KE | Futures | 2154.71 | 2176.86 | 2141.41 | 2145.84 | 11507.0 |
> showing 50 of 91 rows — these rows as CSV