PREVIEW / futures_daily / 2012-12-28
file: by_date/futures_daily/2012/2012-12-28.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-28 | ES | Futures | 1446.03 | 1449.61 | 1414.31 | 1416.1 | 1061849.0 |
| 2012-12-28 | NQ | Futures | 3027.78 | 3034.12 | 2978.76 | 2982.79 | 149073.0 |
| 2012-12-28 | YM | Futures | 12769.3 | 12798.7 | 12518.3 | 12529.1 | 94521.0 |
| 2012-12-28 | CL | Futures | 161.78 | 162.38 | 160.3 | 161.16 | 131374.0 |
| 2012-12-28 | GC | Futures | 2217.5 | 2221.5 | 2204.3 | 2206.7 | 75137.0 |
| 2012-12-28 | ZN | Futures | 117.093367 | 117.382793 | 117.052021 | 117.272536 | 457798.0 |
| 2012-12-28 | A6 | Futures | 0.94337 | 0.94584 | 0.94273 | 0.94346 | 50198.0 |
| 2012-12-28 | AD | Futures | 1.0063 | 1.0072 | 1.0038 | 1.0047 | 35941.0 |
| 2012-12-28 | B | Futures | 103.15 | 103.56 | 102.05 | 102.7 | 66713.0 |
| 2012-12-28 | B6 | Futures | 1.6831 | 1.6895 | 1.6798 | 1.6875 | 58501.0 |
| 2012-12-28 | BFX | Futures | 2979.7 | 2993.1 | 2978.5 | 2993.1 | 62.0 |
| 2012-12-28 | BR | Futures | 0.23841 | 0.23841 | 0.23841 | 0.23841 | 21.0 |
| 2012-12-28 | BZ | Futures | 105.77 | 105.83 | 104.52 | 104.99 | 997.0 |
| 2012-12-28 | C | Futures | 1548.0 | 1552.0 | 1536.0 | 1541.0 | 5230.0 |
| 2012-12-28 | CB | Futures | 84.576 | 84.706 | 84.576 | 84.706 | 12.0 |
| 2012-12-28 | CC | Futures | 1703.0 | 1716.0 | 1694.0 | 1697.0 | 7165.0 |
| 2012-12-28 | CSC | Futures | 3.886 | 3.886 | 3.875 | 3.884 | 16.0 |
| 2012-12-28 | CT | Futures | 95.5 | 95.66 | 93.91 | 93.96 | 14129.0 |
| 2012-12-28 | DC | Futures | 28.91 | 29.15 | 28.91 | 28.99 | 58.0 |
| 2012-12-28 | DX | Futures | 76.89 | 77.203 | 76.851 | 76.948 | 15291.0 |
| 2012-12-28 | E1 | Futures | 1.41097 | 1.4138 | 1.40376 | 1.41148 | 14924.0 |
| 2012-12-28 | E6 | Futures | 1.56212 | 1.5646 | 1.55387 | 1.56047 | 132099.0 |
| 2012-12-28 | E7 | Futures | 1.5515 | 1.554 | 1.5433 | 1.5498 | 2468.0 |
| 2012-12-28 | EBM | Futures | 276.45 | 278.96 | 275.9 | 277.84 | 8462.0 |
| 2012-12-28 | ED | Futures | 95.2056 | 95.2199 | 95.2056 | 95.2151 | 86434.0 |
| 2012-12-28 | ER | Futures | 97.832 | 97.847 | 97.827 | 97.842 | 48284.0 |
| 2012-12-28 | EW | Futures | 1026.7 | 1030.2 | 1013.7 | 1014.4 | 11182.0 |
| 2012-12-28 | FBTP | Futures | 75.08 | 75.35 | 74.84 | 75.3 | 20662.0 |
| 2012-12-28 | FBTS | Futures | 90.79 | 90.815 | 90.705 | 90.722 | 2568.0 |
| 2012-12-28 | FCE | Futures | 2770.0 | 2776.4 | 2720.6 | 2728.9 | 67419.0 |
| 2012-12-28 | FDAX | Futures | 8373.1 | 8383.0 | 8313.1 | 8320.7 | 38121.0 |
| 2012-12-28 | FESX | Futures | 1811.8 | 1816.6 | 1774.3 | 1781.8 | 496453.0 |
| 2012-12-28 | FEU3 | Futures | 98.443 | 98.448 | 98.443 | 98.448 | 45.0 |
| 2012-12-28 | FGBL | Futures | 120.3 | 120.53 | 120.2 | 120.38 | 224009.0 |
| 2012-12-28 | FGBM | Futures | 117.62 | 117.7 | 117.53 | 117.66 | 136205.0 |
| 2012-12-28 | FGBS | Futures | 110.487 | 110.602 | 110.472 | 110.567 | 126876.0 |
| 2012-12-28 | FGBX | Futures | 128.68 | 129.71 | 128.68 | 128.9 | 5564.0 |
| 2012-12-28 | FOAT | Futures | 106.24 | 106.32 | 106.13 | 106.21 | 7329.0 |
| 2012-12-28 | FTDX | Futures | 784.8 | 784.8 | 781.5 | 781.5 | 7.0 |
| 2012-12-28 | FTI | Futures | 296.59 | 297.24 | 293.2 | 294.27 | 15605.0 |
| 2012-12-28 | FTUK | Futures | 4368.9 | 4370.0 | 4305.2 | 4332.1 | 47678.0 |
| 2012-12-28 | FVSA | Futures | 4050.86 | 4365.59 | 3989.94 | 4355.43 | 7336.0 |
| 2012-12-28 | FXXP | Futures | 202.0 | 202.0 | 199.7 | 200.4 | 8109.0 |
| 2012-12-28 | G | Futures | 98.72 | 99.21 | 98.67 | 98.85 | 63578.0 |
| 2012-12-28 | GF | Futures | 287.62 | 289.28 | 286.529 | 288.474 | 1141.0 |
| 2012-12-28 | GSCI | Futures | 1040.25 | 1042.75 | 1035.42 | 1036.63 | 109.0 |
| 2012-12-28 | HE | Futures | 99.843 | 100.216 | 99.097 | 99.126 | 12505.0 |
| 2012-12-28 | HG | Futures | 4.6262 | 4.6519 | 4.605 | 4.6095 | 25538.0 |
| 2012-12-28 | HH | Futures | 40.656 | 40.75 | 40.633 | 40.727 | 261.0 |
| 2012-12-28 | HO | Futures | 2.4493 | 2.4493 | 2.4159 | 2.4243 | 27017.0 |
> showing 50 of 101 rows — these rows as CSV