PREVIEW / futures_daily / 2009-07-14
file: by_date/futures_daily/2009/2009-07-14.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-14 | ES | Futures | 859.18 | 867.33 | 856.3 | 864.94 | 2009856.0 |
| 2009-07-14 | NQ | Futures | 1623.64 | 1636.6 | 1618.58 | 1629.28 | 257499.0 |
| 2009-07-14 | YM | Futures | 7449.0 | 7519.4 | 7426.4 | 7492.3 | 126141.0 |
| 2009-07-14 | CL | Futures | 157.05 | 160.17 | 154.53 | 155.48 | 152586.0 |
| 2009-07-14 | GC | Futures | 1275.4 | 1284.5 | 1270.7 | 1277.6 | 82435.0 |
| 2009-07-14 | ZN | Futures | 93.19442 | 93.354485 | 92.615726 | 92.812728 | 904992.0 |
| 2009-07-14 | A6 | Futures | 0.62715 | 0.63687 | 0.62514 | 0.63093 | 76413.0 |
| 2009-07-14 | AD | Futures | 0.85872 | 0.87255 | 0.85654 | 0.86968 | 73002.0 |
| 2009-07-14 | B | Futures | 58.04 | 59.34 | 57.59 | 57.93 | 114430.0 |
| 2009-07-14 | B6 | Futures | 1.691 | 1.7021 | 1.6899 | 1.6951 | 82567.0 |
| 2009-07-14 | BFX | Futures | 2280.4 | 2303.2 | 2272.7 | 2302.2 | 1458.0 |
| 2009-07-14 | BR | Futures | 0.19481 | 0.19656 | 0.19481 | 0.19481 | 63.0 |
| 2009-07-14 | C | Futures | 1835.0 | 1850.0 | 1823.0 | 1848.0 | 8418.0 |
| 2009-07-14 | CB | Futures | 73.07 | 73.61 | 73.07 | 73.61 | 8.0 |
| 2009-07-14 | CC | Futures | 2377.0 | 2428.0 | 2377.0 | 2425.0 | 6155.0 |
| 2009-07-14 | CT | Futures | 53.74 | 54.49 | 53.67 | 54.48 | 93.0 |
| 2009-07-14 | DC | Futures | 19.78 | 20.01 | 19.71 | 19.81 | 126.0 |
| 2009-07-14 | DX | Futures | 82.077 | 82.379 | 81.929 | 82.262 | 4142.0 |
| 2009-07-14 | E1 | Futures | 1.22345 | 1.2261 | 1.21087 | 1.21378 | 33389.0 |
| 2009-07-14 | E6 | Futures | 1.66063 | 1.66408 | 1.65161 | 1.65422 | 179240.0 |
| 2009-07-14 | E7 | Futures | 1.6438 | 1.6469 | 1.6347 | 1.6372 | 2051.0 |
| 2009-07-14 | ED | Futures | 93.8716 | 93.8811 | 93.8527 | 93.8716 | 138091.0 |
| 2009-07-14 | ER | Futures | 97.032 | 97.037 | 97.012 | 97.032 | 102162.0 |
| 2009-07-14 | EW | Futures | 538.8 | 545.5 | 536.7 | 543.7 | 25516.0 |
| 2009-07-14 | FCE | Futures | 2005.8 | 2027.8 | 1995.3 | 2019.9 | 72864.0 |
| 2009-07-14 | FDAX | Futures | 5197.8 | 5271.4 | 5161.6 | 5241.2 | 151715.0 |
| 2009-07-14 | FESX | Futures | 1405.2 | 1419.5 | 1396.2 | 1409.3 | 1125377.0 |
| 2009-07-14 | FEU3 | Futures | 97.603 | 97.608 | 97.599 | 97.608 | 328.0 |
| 2009-07-14 | FGBL | Futures | 92.76 | 92.77 | 92.34 | 92.65 | 633568.0 |
| 2009-07-14 | FGBM | Futures | 98.48 | 98.49 | 98.18 | 98.41 | 376249.0 |
| 2009-07-14 | FGBS | Futures | 104.215 | 104.22 | 104.109 | 104.205 | 420959.0 |
| 2009-07-14 | FGBX | Futures | 84.87 | 85.01 | 84.52 | 84.85 | 1065.0 |
| 2009-07-14 | FTDX | Futures | 561.2 | 565.7 | 554.1 | 555.9 | 1619.0 |
| 2009-07-14 | FTI | Futures | 204.56 | 206.45 | 204.14 | 205.87 | 18285.0 |
| 2009-07-14 | FTUK | Futures | 2770.1 | 2804.6 | 2762.5 | 2783.7 | 93431.0 |
| 2009-07-14 | G | Futures | 75.79 | 75.82 | 75.43 | 75.56 | 66658.0 |
| 2009-07-14 | GF | Futures | 286.655 | 286.655 | 284.175 | 284.244 | 2188.0 |
| 2009-07-14 | GSCI | Futures | 850.36 | 865.5 | 847.22 | 847.22 | 3444.0 |
| 2009-07-14 | HE | Futures | 91.477 | 92.34 | 90.973 | 91.549 | 16632.0 |
| 2009-07-14 | HG | Futures | 3.1424 | 3.2449 | 3.1157 | 3.2281 | 20797.0 |
| 2009-07-14 | HO | Futures | 1.5673 | 1.5986 | 1.5535 | 1.5682 | 24006.0 |
| 2009-07-14 | HRC | Futures | 2435.8 | 2435.8 | 2435.8 | 2435.8 | 0.0 |
| 2009-07-14 | J1 | Futures | 0.0135472 | 0.0135887 | 0.0134351 | 0.0135031 | 89253.0 |
| 2009-07-14 | J7 | Futures | 0.013353 | 0.013397 | 0.013253 | 0.013317 | 76.0 |
| 2009-07-14 | JB | Futures | 116.99 | 117.02 | 116.63 | 116.69 | 3228.0 |
| 2009-07-14 | KC | Futures | 311.77 | 319.1 | 310.82 | 313.4 | 6862.0 |
| 2009-07-14 | KE | Futures | 2732.72 | 2743.51 | 2663.18 | 2676.37 | 7286.0 |
| 2009-07-14 | L | Futures | 97.259 | 97.298 | 97.239 | 97.288 | 28971.0 |
| 2009-07-14 | LBS | Futures | 787.9 | 803.0 | 760.7 | 765.2 | 1339.0 |
| 2009-07-14 | LE | Futures | 149.664 | 150.502 | 149.092 | 149.885 | 19863.0 |
> showing 50 of 85 rows — these rows as CSV