PREVIEW / futures_daily / 2013-12-27
file: by_date/futures_daily/2013/2013-12-27.parquet size: 9 KB rows: 103
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-12-27 | ES | Futures | 1893.17 | 1896.77 | 1889.82 | 1893.17 | 622702.0 |
| 2013-12-27 | NQ | Futures | 4118.76 | 4124.22 | 4100.65 | 4104.39 | 94798.0 |
| 2013-12-27 | YM | Futures | 16400.1 | 16440.0 | 16364.1 | 16395.1 | 53726.0 |
| 2013-12-27 | CL | Futures | 175.88 | 177.86 | 175.43 | 177.1 | 127198.0 |
| 2013-12-27 | GC | Futures | 1603.3 | 1613.9 | 1600.1 | 1607.4 | 83755.0 |
| 2013-12-27 | ZN | Futures | 112.645667 | 112.831669 | 112.473973 | 112.617051 | 380023.0 |
| 2013-12-27 | A6 | Futures | 0.84196 | 0.84653 | 0.84015 | 0.84053 | 47812.0 |
| 2013-12-27 | AD | Futures | 0.94914 | 0.95187 | 0.94286 | 0.94357 | 42098.0 |
| 2013-12-27 | B | Futures | 113.7 | 114.5 | 113.2 | 113.88 | 62738.0 |
| 2013-12-27 | B6 | Futures | 1.7236 | 1.7407 | 1.7227 | 1.7284 | 85287.0 |
| 2013-12-27 | BR | Futures | 0.21632 | 0.218 | 0.21632 | 0.21762 | 14.0 |
| 2013-12-27 | BZ | Futures | 115.9 | 116.78 | 115.51 | 116.16 | 5627.0 |
| 2013-12-27 | C | Futures | 1886.0 | 1894.0 | 1856.0 | 1858.0 | 5641.0 |
| 2013-12-27 | CB | Futures | 80.716 | 80.716 | 79.244 | 79.489 | 31.0 |
| 2013-12-27 | CC | Futures | 2064.0 | 2097.0 | 2043.0 | 2067.0 | 10381.0 |
| 2013-12-27 | CSC | Futures | 3.799 | 3.799 | 3.785 | 3.785 | 22.0 |
| 2013-12-27 | CT | Futures | 94.87 | 97.15 | 94.87 | 95.92 | 12784.0 |
| 2013-12-27 | DC | Futures | 29.27 | 29.32 | 29.07 | 29.15 | 118.0 |
| 2013-12-27 | DX | Futures | 76.647 | 76.657 | 75.905 | 76.588 | 25254.0 |
| 2013-12-27 | E1 | Futures | 1.43288 | 1.45997 | 1.43262 | 1.43917 | 31230.0 |
| 2013-12-27 | E6 | Futures | 1.61581 | 1.64001 | 1.61569 | 1.62112 | 176825.0 |
| 2013-12-27 | E7 | Futures | 1.6052 | 1.6292 | 1.6052 | 1.6105 | 5982.0 |
| 2013-12-27 | EBM | Futures | 286.44 | 286.79 | 284.01 | 284.35 | 6212.0 |
| 2013-12-27 | ED | Futures | 95.3375 | 95.3471 | 95.3375 | 95.3471 | 38181.0 |
| 2013-12-27 | ER | Futures | 97.857 | 97.871 | 97.847 | 97.867 | 42204.0 |
| 2013-12-27 | EW | Futures | 1362.1 | 1367.4 | 1360.5 | 1362.5 | 8788.0 |
| 2013-12-27 | FBTP | Futures | 81.38 | 81.7 | 81.19 | 81.43 | 12029.0 |
| 2013-12-27 | FBTS | Futures | 95.416 | 95.565 | 95.302 | 95.398 | 4630.0 |
| 2013-12-27 | FCE | Futures | 3308.6 | 3342.5 | 3304.4 | 3336.3 | 66240.0 |
| 2013-12-27 | FDAX | Futures | 10606.0 | 10654.2 | 10598.8 | 10636.5 | 48065.0 |
| 2013-12-27 | FDIV | Futures | 145.85 | 146.83 | 145.85 | 146.73 | 65.0 |
| 2013-12-27 | FESX | Futures | 2175.3 | 2190.7 | 2171.8 | 2185.8 | 433896.0 |
| 2013-12-27 | FEU3 | Futures | 98.478 | 98.483 | 98.478 | 98.483 | 64.0 |
| 2013-12-27 | FGBL | Futures | 118.78 | 118.82 | 118.14 | 118.25 | 216955.0 |
| 2013-12-27 | FGBM | Futures | 117.28 | 117.32 | 116.88 | 116.95 | 139199.0 |
| 2013-12-27 | FGBS | Futures | 110.318 | 110.328 | 110.263 | 110.278 | 105875.0 |
| 2013-12-27 | FGBX | Futures | 119.42 | 119.48 | 118.31 | 118.68 | 6467.0 |
| 2013-12-27 | FMWO | Futures | 5438.4 | 5438.4 | 5432.1 | 5432.1 | 100.0 |
| 2013-12-27 | FOAT | Futures | 107.97 | 107.97 | 107.27 | 107.36 | 13839.0 |
| 2013-12-27 | FTDX | Futures | 1095.3 | 1098.1 | 1087.8 | 1091.5 | 154.0 |
| 2013-12-27 | FTI | Futures | 342.34 | 345.13 | 342.21 | 344.58 | 18722.0 |
| 2013-12-27 | FTUK | Futures | 5053.3 | 5091.1 | 5041.1 | 5074.8 | 52677.0 |
| 2013-12-27 | FVSA | Futures | 1778.58 | 1826.94 | 1778.58 | 1821.56 | 2933.0 |
| 2013-12-27 | FXXP | Futures | 239.5 | 240.8 | 238.8 | 240.4 | 5723.0 |
| 2013-12-27 | G | Futures | 90.39 | 90.4 | 89.67 | 89.73 | 49149.0 |
| 2013-12-27 | GF | Futures | 268.207 | 270.018 | 268.207 | 268.851 | 1678.0 |
| 2013-12-27 | GSCI | Futures | 1055.91 | 1061.69 | 1055.91 | 1057.56 | 796.0 |
| 2013-12-27 | HE | Futures | 103.26 | 103.713 | 103.139 | 103.441 | 9668.0 |
| 2013-12-27 | HG | Futures | 4.2816 | 4.293 | 4.2564 | 4.2753 | 37853.0 |
| 2013-12-27 | HH | Futures | 44.148 | 44.409 | 43.477 | 43.758 | 137.0 |
> showing 50 of 103 rows — these rows as CSV