PREVIEW / futures_daily / 2014-01-14
file: by_date/futures_daily/2014/2014-01-14.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-14 | ES | Futures | 1871.78 | 1890.85 | 1868.68 | 1889.56 | 1595178.0 |
| 2014-01-14 | NQ | Futures | 4035.41 | 4111.57 | 4027.36 | 4108.41 | 293427.0 |
| 2014-01-14 | YM | Futures | 16185.4 | 16286.3 | 16156.5 | 16273.3 | 135764.0 |
| 2014-01-14 | CL | Futures | 162.06 | 164.39 | 161.99 | 163.85 | 151186.0 |
| 2014-01-14 | GC | Futures | 1658.6 | 1661.5 | 1643.3 | 1649.0 | 138193.0 |
| 2014-01-14 | ZN | Futures | 114.062143 | 114.076451 | 113.647216 | 113.704447 | 838856.0 |
| 2014-01-14 | A6 | Futures | 0.85949 | 0.85959 | 0.84987 | 0.85015 | 96059.0 |
| 2014-01-14 | AD | Futures | 0.9301 | 0.9303 | 0.92261 | 0.92372 | 72555.0 |
| 2014-01-14 | B | Futures | 107.81 | 108.24 | 107.14 | 107.53 | 228651.0 |
| 2014-01-14 | B6 | Futures | 1.7205 | 1.7289 | 1.7185 | 1.7258 | 92961.0 |
| 2014-01-14 | BFX | Futures | 3544.3 | 3557.6 | 3544.3 | 3557.6 | 1003.0 |
| 2014-01-14 | BR | Futures | 0.21673 | 0.21772 | 0.2164 | 0.21751 | 1703.0 |
| 2014-01-14 | BZ | Futures | 109.9 | 110.39 | 109.32 | 109.67 | 6713.0 |
| 2014-01-14 | C | Futures | 1833.0 | 1862.0 | 1832.0 | 1860.0 | 8530.0 |
| 2014-01-14 | CB | Futures | 85.377 | 87.34 | 84.997 | 86.813 | 46.0 |
| 2014-01-14 | CC | Futures | 2011.0 | 2045.0 | 2001.0 | 2043.0 | 14187.0 |
| 2014-01-14 | CNH | Futures | 6.9497 | 6.9497 | 6.9373 | 6.9419 | 40.0 |
| 2014-01-14 | CSC | Futures | 3.915 | 4.015 | 3.896 | 4.006 | 16.0 |
| 2014-01-14 | CT | Futures | 95.23 | 96.13 | 95.03 | 95.47 | 12551.0 |
| 2014-01-14 | DC | Futures | 30.23 | 31.07 | 29.88 | 30.98 | 476.0 |
| 2014-01-14 | DX | Futures | 76.714 | 76.828 | 76.59 | 76.795 | 13166.0 |
| 2014-01-14 | E1 | Futures | 1.428 | 1.42916 | 1.42184 | 1.42261 | 26976.0 |
| 2014-01-14 | E6 | Futures | 1.61357 | 1.61722 | 1.6112 | 1.61404 | 167370.0 |
| 2014-01-14 | E7 | Futures | 1.6032 | 1.6066 | 1.6006 | 1.6035 | 5327.0 |
| 2014-01-14 | EBM | Futures | 270.78 | 271.48 | 270.08 | 271.48 | 17142.0 |
| 2014-01-14 | ED | Futures | 95.3662 | 95.371 | 95.3662 | 95.371 | 58666.0 |
| 2014-01-14 | ER | Futures | 97.847 | 97.852 | 97.822 | 97.827 | 90592.0 |
| 2014-01-14 | EW | Futures | 1358.8 | 1373.9 | 1355.3 | 1371.8 | 15527.0 |
| 2014-01-14 | FBTP | Futures | 83.25 | 83.43 | 83.17 | 83.36 | 24027.0 |
| 2014-01-14 | FBTS | Futures | 96.1 | 96.117 | 96.065 | 96.082 | 8951.0 |
| 2014-01-14 | FCE | Futures | 3292.7 | 3335.1 | 3276.4 | 3324.2 | 106577.0 |
| 2014-01-14 | FDAX | Futures | 10472.4 | 10626.0 | 10409.7 | 10578.3 | 113900.0 |
| 2014-01-14 | FESX | Futures | 2168.9 | 2198.5 | 2157.0 | 2189.3 | 872606.0 |
| 2014-01-14 | FEU3 | Futures | 98.458 | 98.458 | 98.443 | 98.443 | 1.0 |
| 2014-01-14 | FGBL | Futures | 119.79 | 119.84 | 119.56 | 119.71 | 591607.0 |
| 2014-01-14 | FGBM | Futures | 117.88 | 117.92 | 117.7 | 117.82 | 352412.0 |
| 2014-01-14 | FGBS | Futures | 110.418 | 110.428 | 110.343 | 110.368 | 307497.0 |
| 2014-01-14 | FGBX | Futures | 120.1 | 120.22 | 119.87 | 120.08 | 13363.0 |
| 2014-01-14 | FMWO | Futures | 5413.2 | 5413.2 | 5413.2 | 5413.2 | 0.0 |
| 2014-01-14 | FOAT | Futures | 108.42 | 108.54 | 108.33 | 108.5 | 44702.0 |
| 2014-01-14 | FTDX | Futures | 1145.5 | 1158.7 | 1115.5 | 1150.2 | 253.0 |
| 2014-01-14 | FTI | Futures | 343.81 | 348.35 | 342.35 | 347.45 | 20082.0 |
| 2014-01-14 | FTUK | Futures | 5042.7 | 5096.8 | 5024.5 | 5080.9 | 87321.0 |
| 2014-01-14 | FVSA | Futures | 1866.93 | 1882.23 | 1815.92 | 1826.12 | 4719.0 |
| 2014-01-14 | FXXP | Futures | 240.1 | 243.2 | 239.7 | 242.6 | 4764.0 |
| 2014-01-14 | G | Futures | 91.98 | 92.07 | 91.79 | 91.97 | 138811.0 |
| 2014-01-14 | GF | Futures | 268.926 | 270.015 | 268.241 | 268.967 | 3276.0 |
| 2014-01-14 | GSCI | Futures | 999.9 | 1001.95 | 996.13 | 1001.3 | 3200.0 |
| 2014-01-14 | HE | Futures | 103.29 | 104.317 | 102.747 | 103.864 | 23601.0 |
| 2014-01-14 | HG | Futures | 4.2216 | 4.2317 | 4.1938 | 4.2134 | 29958.0 |
> showing 50 of 105 rows — these rows as CSV