PREVIEW / futures_daily / 2016-12-12
file: by_date/futures_daily/2016/2016-12-12.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2016-12-12 | ES | Futures | 2445.22 | 2455.49 | 2436.02 | 2440.08 | 1019782.0 |
| 2016-12-12 | NQ | Futures | 5773.71 | 5794.92 | 5718.91 | 5736.88 | 124198.0 |
| 2016-12-12 | YM | Futures | 20758.4 | 20864.8 | 20735.2 | 20774.2 | 150068.0 |
| 2016-12-12 | CL | Futures | 56.74 | 58.82 | 56.3 | 57.01 | 847025.0 |
| 2016-12-12 | GC | Futures | 1491.5 | 1499.8 | 1480.0 | 1497.1 | 166798.0 |
| 2016-12-12 | ZN | Futures | 121.171236 | 121.43103 | 120.804467 | 121.27821 | 1418496.0 |
| 2016-12-12 | A6 | Futures | 0.7604 | 0.76706 | 0.76009 | 0.76511 | 8913.0 |
| 2016-12-12 | AD | Futures | 0.77811 | 0.78021 | 0.7776 | 0.77842 | 17442.0 |
| 2016-12-12 | ALI | Futures | 2362.4 | 2362.4 | 2362.4 | 2362.4 | 0.0 |
| 2016-12-12 | B | Futures | 41.63 | 43.13 | 41.06 | 41.49 | 372173.0 |
| 2016-12-12 | B6 | Futures | 1.3234 | 1.3352 | 1.3213 | 1.3323 | 45920.0 |
| 2016-12-12 | BFX | Futures | 4246.8 | 4246.8 | 4244.4 | 4245.6 | 45.0 |
| 2016-12-12 | BR | Futures | 0.20818 | 0.20818 | 0.20818 | 0.20818 | 7.0 |
| 2016-12-12 | BZ | Futures | 40.49 | 42.51 | 40.49 | 41.18 | 45732.0 |
| 2016-12-12 | C | Futures | 1811.0 | 1853.0 | 1777.0 | 1847.0 | 19694.0 |
| 2016-12-12 | CB | Futures | 259.312 | 259.678 | 259.312 | 259.678 | 8.0 |
| 2016-12-12 | CC | Futures | 1644.0 | 1736.0 | 1632.0 | 1705.0 | 30031.0 |
| 2016-12-12 | CNH | Futures | 7.4423 | 7.447 | 7.408 | 7.408 | 206.0 |
| 2016-12-12 | CSC | Futures | 4.029 | 4.183 | 4.029 | 4.183 | 130.0 |
| 2016-12-12 | CT | Futures | 81.3 | 82.46 | 81.16 | 82.35 | 15708.0 |
| 2016-12-12 | DC | Futures | 32.56 | 33.99 | 32.56 | 33.95 | 750.0 |
| 2016-12-12 | DX | Futures | 94.58 | 94.692 | 93.807 | 93.974 | 12349.0 |
| 2016-12-12 | E1 | Futures | 1.22463 | 1.23132 | 1.2224 | 1.22897 | 4488.0 |
| 2016-12-12 | E6 | Futures | 1.2238 | 1.23604 | 1.22138 | 1.2335 | 107295.0 |
| 2016-12-12 | E7 | Futures | 1.2172 | 1.2298 | 1.2154 | 1.2272 | 760.0 |
| 2016-12-12 | EBM | Futures | 189.14 | 189.14 | 186.87 | 187.72 | 11116.0 |
| 2016-12-12 | ED | Futures | 95.5858 | 95.5906 | 95.581 | 95.5858 | 230419.0 |
| 2016-12-12 | ER | Futures | 98.283 | 98.288 | 98.283 | 98.283 | 36015.0 |
| 2016-12-12 | EW | Futures | 1800.5 | 1807.8 | 1785.3 | 1790.3 | 50712.0 |
| 2016-12-12 | FBON | Futures | 120.83 | 121.41 | 120.83 | 121.41 | 99.0 |
| 2016-12-12 | FBTP | Futures | 104.81 | 105.45 | 104.18 | 105.27 | 102484.0 |
| 2016-12-12 | FBTS | Futures | 101.575 | 101.584 | 101.394 | 101.557 | 25793.0 |
| 2016-12-12 | FCE | Futures | 4205.8 | 4205.8 | 4167.1 | 4179.8 | 51769.0 |
| 2016-12-12 | FDAX | Futures | 11886.8 | 11886.8 | 11773.2 | 11816.0 | 110454.0 |
| 2016-12-12 | FDXM | Futures | 11814.2 | 11815.3 | 11711.2 | 11754.3 | 1020.0 |
| 2016-12-12 | FESX | Futures | 2560.7 | 2560.7 | 2537.5 | 2547.1 | 1045105.0 |
| 2016-12-12 | FGBL | Futures | 145.54 | 145.56 | 145.02 | 145.24 | 675173.0 |
| 2016-12-12 | FGBM | Futures | 128.45 | 128.46 | 128.23 | 128.3 | 444623.0 |
| 2016-12-12 | FGBS | Futures | 112.117 | 112.127 | 112.067 | 112.092 | 276060.0 |
| 2016-12-12 | FGBX | Futures | 163.29 | 163.33 | 161.41 | 162.44 | 53766.0 |
| 2016-12-12 | FMWO | Futures | 5890.1 | 5890.1 | 5875.5 | 5890.1 | 4489.0 |
| 2016-12-12 | FOAT | Futures | 131.86 | 131.87 | 130.98 | 131.49 | 132308.0 |
| 2016-12-12 | FTDX | Futures | 1718.5 | 1718.5 | 1709.7 | 1709.7 | 1024.0 |
| 2016-12-12 | FTI | Futures | 428.09 | 428.59 | 426.41 | 427.77 | 12373.0 |
| 2016-12-12 | FTUK | Futures | 5869.3 | 5875.3 | 5770.6 | 5778.2 | 293820.0 |
| 2016-12-12 | FVSA | Futures | 1115.39 | 1137.31 | 1115.39 | 1129.09 | 5423.0 |
| 2016-12-12 | FXXP | Futures | 293.4 | 293.4 | 290.9 | 291.7 | 76816.0 |
| 2016-12-12 | G | Futures | 109.56 | 109.85 | 109.36 | 109.64 | 178261.0 |
| 2016-12-12 | GF | Futures | 281.248 | 287.94 | 279.129 | 286.769 | 5721.0 |
| 2016-12-12 | GSCI | Futures | 529.26 | 530.25 | 523.83 | 525.15 | 3103.0 |
> showing 50 of 108 rows — these rows as CSV