PREVIEW / futures_daily / 2011-11-09
file: by_date/futures_daily/2011/2011-11-09.parquet size: 9 KB rows: 96
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-09 | ES | Futures | 1271.02 | 1271.77 | 1220.61 | 1223.35 | 3248837.0 |
| 2011-11-09 | NQ | Futures | 2733.5 | 2736.64 | 2628.2 | 2637.91 | 337138.0 |
| 2011-11-09 | YM | Futures | 11643.2 | 11650.9 | 11228.2 | 11270.5 | 173635.0 |
| 2011-11-09 | CL | Futures | 181.62 | 183.55 | 177.36 | 179.61 | 445712.0 |
| 2011-11-09 | GC | Futures | 2413.3 | 2431.8 | 2383.2 | 2418.9 | 161799.0 |
| 2011-11-09 | ZN | Futures | 111.509383 | 112.40768 | 111.455754 | 112.246791 | 1247039.0 |
| 2011-11-09 | A6 | Futures | 0.90928 | 0.91051 | 0.88773 | 0.88844 | 157760.0 |
| 2011-11-09 | AD | Futures | 0.99035 | 0.99175 | 0.97574 | 0.97754 | 95667.0 |
| 2011-11-09 | B | Futures | 101.15 | 101.37 | 98.14 | 98.57 | 194159.0 |
| 2011-11-09 | B6 | Futures | 1.6784 | 1.6818 | 1.6594 | 1.6608 | 110232.0 |
| 2011-11-09 | BFX | Futures | 2540.5 | 2549.8 | 2486.5 | 2488.2 | 94.0 |
| 2011-11-09 | BR | Futures | 0.25521 | 0.25566 | 0.25252 | 0.25532 | 239.0 |
| 2011-11-09 | BZ | Futures | 104.07 | 104.17 | 103.66 | 104.08 | 1710.0 |
| 2011-11-09 | C | Futures | 1747.0 | 1758.0 | 1703.0 | 1707.0 | 6395.0 |
| 2011-11-09 | CC | Futures | 2089.0 | 2097.0 | 2005.0 | 2018.0 | 20612.0 |
| 2011-11-09 | CT | Futures | 126.23 | 126.58 | 124.56 | 125.29 | 10090.0 |
| 2011-11-09 | DC | Futures | 30.99 | 31.14 | 30.62 | 30.72 | 340.0 |
| 2011-11-09 | DX | Futures | 75.361 | 76.819 | 75.273 | 76.738 | 33504.0 |
| 2011-11-09 | E1 | Futures | 1.46698 | 1.47157 | 1.44087 | 1.44283 | 25951.0 |
| 2011-11-09 | E6 | Futures | 1.65298 | 1.6562 | 1.61605 | 1.61832 | 424486.0 |
| 2011-11-09 | E7 | Futures | 1.6392 | 1.6419 | 1.6024 | 1.6045 | 7978.0 |
| 2011-11-09 | ED | Futures | 94.9602 | 94.965 | 94.922 | 94.922 | 263822.0 |
| 2011-11-09 | ER | Futures | 97.248 | 97.307 | 97.233 | 97.263 | 233284.0 |
| 2011-11-09 | EW | Futures | 909.6 | 909.8 | 867.3 | 868.5 | 38219.0 |
| 2011-11-09 | FBTP | Futures | 58.07 | 58.07 | 54.35 | 55.48 | 25286.0 |
| 2011-11-09 | FBTS | Futures | 78.364 | 78.548 | 75.867 | 76.815 | 3669.0 |
| 2011-11-09 | FCE | Futures | 2287.6 | 2293.3 | 2168.8 | 2203.2 | 132504.0 |
| 2011-11-09 | FDAX | Futures | 6617.0 | 6625.7 | 6225.0 | 6339.5 | 232221.0 |
| 2011-11-09 | FESX | Futures | 1556.4 | 1559.7 | 1466.0 | 1494.6 | 1859186.0 |
| 2011-11-09 | FEU3 | Futures | 97.811 | 97.821 | 97.811 | 97.821 | 2.0 |
| 2011-11-09 | FGBL | Futures | 111.0 | 112.72 | 110.91 | 112.31 | 1003941.0 |
| 2011-11-09 | FGBM | Futures | 111.7 | 112.39 | 111.68 | 112.18 | 538988.0 |
| 2011-11-09 | FGBS | Futures | 109.263 | 109.447 | 109.248 | 109.382 | 566146.0 |
| 2011-11-09 | FGBX | Futures | 112.97 | 117.29 | 112.86 | 116.41 | 6015.0 |
| 2011-11-09 | FTDX | Futures | 651.4 | 656.9 | 627.4 | 635.3 | 275.0 |
| 2011-11-09 | FTI | Futures | 254.21 | 254.5 | 240.31 | 243.33 | 62433.0 |
| 2011-11-09 | FTUK | Futures | 4032.3 | 4042.4 | 3847.2 | 3912.1 | 161669.0 |
| 2011-11-09 | FVSA | Futures | 16647.33 | 17084.87 | 16397.31 | 16626.49 | 7422.0 |
| 2011-11-09 | FXXP | Futures | 168.8 | 168.8 | 163.5 | 164.7 | 1659.0 |
| 2011-11-09 | G | Futures | 91.96 | 93.27 | 91.94 | 92.82 | 148008.0 |
| 2011-11-09 | GF | Futures | 313.256 | 314.695 | 312.592 | 313.256 | 600.0 |
| 2011-11-09 | GSCI | Futures | 1031.48 | 1043.39 | 1024.35 | 1029.52 | 1781.0 |
| 2011-11-09 | HE | Futures | 109.547 | 110.029 | 108.969 | 109.451 | 23068.0 |
| 2011-11-09 | HG | Futures | 4.6877 | 4.7638 | 4.4833 | 4.5534 | 54056.0 |
| 2011-11-09 | HO | Futures | 2.5062 | 2.5309 | 2.4716 | 2.4889 | 65037.0 |
| 2011-11-09 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-11-09 | J1 | Futures | 0.0161727 | 0.0162142 | 0.0161413 | 0.0161501 | 55878.0 |
| 2011-11-09 | J7 | Futures | 0.016068 | 0.016113 | 0.016045 | 0.016052 | 217.0 |
| 2011-11-09 | JB | Futures | 124.67 | 124.69 | 124.57 | 124.61 | 1772.0 |
| 2011-11-09 | KC | Futures | 542.93 | 545.4 | 534.8 | 542.46 | 11706.0 |
> showing 50 of 96 rows — these rows as CSV