PREVIEW / futures_daily / 2013-10-30
file: by_date/futures_daily/2013/2013-10-30.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-30 | ES | Futures | 1816.39 | 1821.53 | 1799.44 | 1808.43 | 1778748.0 |
| 2013-10-30 | NQ | Futures | 3893.79 | 3907.0 | 3863.93 | 3896.09 | 287566.0 |
| 2013-10-30 | YM | Futures | 15544.8 | 15597.6 | 15430.4 | 15475.2 | 163277.0 |
| 2013-10-30 | CL | Futures | 173.96 | 174.05 | 171.79 | 172.18 | 268138.0 |
| 2013-10-30 | GC | Futures | 1778.3 | 1798.1 | 1764.9 | 1784.5 | 156595.0 |
| 2013-10-30 | ZN | Futures | 115.730762 | 116.070647 | 115.376715 | 115.574981 | 1249334.0 |
| 2013-10-30 | A6 | Futures | 0.89274 | 0.89605 | 0.88896 | 0.89142 | 81174.0 |
| 2013-10-30 | AD | Futures | 0.96409 | 0.96652 | 0.96116 | 0.96318 | 51395.0 |
| 2013-10-30 | B | Futures | 108.39 | 109.71 | 108.11 | 109.44 | 128160.0 |
| 2013-10-30 | B6 | Futures | 1.684 | 1.6872 | 1.6787 | 1.6806 | 93296.0 |
| 2013-10-30 | BFX | Futures | 3439.0 | 3439.0 | 3436.0 | 3436.0 | 3.0 |
| 2013-10-30 | BR | Futures | 0.23072 | 0.2312 | 0.23003 | 0.231 | 216.0 |
| 2013-10-30 | BZ | Futures | 108.9 | 110.41 | 108.9 | 110.17 | 6139.0 |
| 2013-10-30 | C | Futures | 1806.0 | 1806.0 | 1789.0 | 1797.0 | 7528.0 |
| 2013-10-30 | CB | Futures | 71.457 | 72.416 | 70.75 | 70.75 | 21.0 |
| 2013-10-30 | CC | Futures | 1982.0 | 1991.0 | 1972.0 | 1982.0 | 12316.0 |
| 2013-10-30 | CNH | Futures | 7.0195 | 7.0229 | 7.0195 | 7.0229 | 30.0 |
| 2013-10-30 | CSC | Futures | 3.439 | 3.464 | 3.437 | 3.464 | 68.0 |
| 2013-10-30 | CT | Futures | 91.95 | 92.36 | 91.13 | 91.32 | 17371.0 |
| 2013-10-30 | DC | Futures | 26.23 | 26.43 | 26.2 | 26.42 | 394.0 |
| 2013-10-30 | DX | Futures | 75.938 | 76.2 | 75.733 | 76.068 | 16307.0 |
| 2013-10-30 | E1 | Futures | 1.43056 | 1.43621 | 1.42439 | 1.4285 | 32604.0 |
| 2013-10-30 | E6 | Futures | 1.6223 | 1.62702 | 1.6164 | 1.62006 | 199993.0 |
| 2013-10-30 | E7 | Futures | 1.6118 | 1.6166 | 1.606 | 1.6096 | 3384.0 |
| 2013-10-30 | ED | Futures | 95.359 | 95.3638 | 95.3542 | 95.359 | 106214.0 |
| 2013-10-30 | ER | Futures | 97.847 | 97.857 | 97.842 | 97.852 | 45169.0 |
| 2013-10-30 | EW | Futures | 1322.2 | 1328.1 | 1309.5 | 1316.0 | 17523.0 |
| 2013-10-30 | FBTP | Futures | 80.92 | 81.15 | 80.63 | 80.8 | 51633.0 |
| 2013-10-30 | FBTS | Futures | 94.742 | 94.759 | 94.586 | 94.621 | 8756.0 |
| 2013-10-30 | FCE | Futures | 3314.1 | 3337.7 | 3298.2 | 3309.8 | 102978.0 |
| 2013-10-30 | FDAX | Futures | 10032.6 | 10070.3 | 9961.0 | 10000.4 | 94435.0 |
| 2013-10-30 | FESX | Futures | 2137.2 | 2150.5 | 2118.9 | 2127.3 | 864566.0 |
| 2013-10-30 | FEU3 | Futures | 98.478 | 98.478 | 98.473 | 98.473 | 1.0 |
| 2013-10-30 | FGBL | Futures | 120.51 | 120.83 | 120.42 | 120.79 | 663231.0 |
| 2013-10-30 | FGBM | Futures | 118.09 | 118.31 | 118.07 | 118.28 | 424385.0 |
| 2013-10-30 | FGBS | Futures | 110.423 | 110.478 | 110.418 | 110.468 | 252441.0 |
| 2013-10-30 | FGBX | Futures | 121.65 | 122.1 | 121.38 | 122.04 | 14172.0 |
| 2013-10-30 | FMWO | Futures | 5304.1 | 5304.1 | 5304.1 | 5304.1 | 0.0 |
| 2013-10-30 | FOAT | Futures | 108.31 | 108.48 | 108.23 | 108.45 | 39010.0 |
| 2013-10-30 | FTDX | Futures | 1065.2 | 1069.5 | 1059.1 | 1061.0 | 155.0 |
| 2013-10-30 | FTI | Futures | 336.94 | 338.58 | 335.3 | 336.98 | 20558.0 |
| 2013-10-30 | FTUK | Futures | 5069.7 | 5098.9 | 5043.1 | 5064.1 | 104058.0 |
| 2013-10-30 | FVSA | Futures | 2057.08 | 2105.77 | 2026.65 | 2081.43 | 3904.0 |
| 2013-10-30 | FXXP | Futures | 234.5 | 235.3 | 233.2 | 233.6 | 4769.0 |
| 2013-10-30 | G | Futures | 93.68 | 94.0 | 93.68 | 93.93 | 119629.0 |
| 2013-10-30 | GF | Futures | 268.818 | 268.898 | 265.672 | 266.076 | 2466.0 |
| 2013-10-30 | GSCI | Futures | 1043.12 | 1047.54 | 1041.62 | 1044.37 | 90.0 |
| 2013-10-30 | HE | Futures | 115.623 | 116.825 | 113.788 | 114.42 | 25254.0 |
| 2013-10-30 | HG | Futures | 4.15 | 4.2139 | 4.1443 | 4.2108 | 67153.0 |
| 2013-10-30 | HH | Futures | 37.304 | 37.458 | 37.14 | 37.14 | 906.0 |
> showing 50 of 104 rows — these rows as CSV