PREVIEW / futures_daily / 2015-12-29
file: by_date/futures_daily/2015/2015-12-29.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 |
|---|---|---|---|---|---|---|---|
| 2015-12-29 | ES | Futures | 2189.41 | 2215.85 | 2187.01 | 2213.98 | 832686.0 |
| 2015-12-29 | NQ | Futures | 5413.42 | 5507.21 | 5404.92 | 5498.71 | 158098.0 |
| 2015-12-29 | YM | Futures | 18056.2 | 18274.6 | 18035.5 | 18251.8 | 81380.0 |
| 2015-12-29 | CL | Futures | 54.58 | 56.43 | 54.52 | 56.32 | 241945.0 |
| 2015-12-29 | GC | Futures | 1377.8 | 1385.9 | 1375.7 | 1377.4 | 87639.0 |
| 2015-12-29 | ZN | Futures | 121.535922 | 121.61113 | 120.859051 | 120.964342 | 620234.0 |
| 2015-12-29 | A6 | Futures | 0.72404 | 0.72915 | 0.72374 | 0.72895 | 38415.0 |
| 2015-12-29 | AD | Futures | 0.73566 | 0.74026 | 0.73351 | 0.74006 | 36288.0 |
| 2015-12-29 | ALI | Futures | 2170.13 | 2170.13 | 2170.13 | 2170.13 | 0.0 |
| 2015-12-29 | B | Futures | 31.95 | 33.09 | 31.94 | 32.94 | 97073.0 |
| 2015-12-29 | B6 | Futures | 1.566 | 1.5695 | 1.5559 | 1.5605 | 53144.0 |
| 2015-12-29 | BFX | Futures | 4527.3 | 4560.1 | 4527.3 | 4560.1 | 2.0 |
| 2015-12-29 | BR | Futures | 0.15997 | 0.1607 | 0.1584 | 0.1584 | 4892.0 |
| 2015-12-29 | BZ | Futures | 31.61 | 32.74 | 31.61 | 32.59 | 11879.0 |
| 2015-12-29 | C | Futures | 2350.0 | 2364.0 | 2347.0 | 2361.0 | 6506.0 |
| 2015-12-29 | CC | Futures | 2367.0 | 2378.0 | 2349.0 | 2367.0 | 9641.0 |
| 2015-12-29 | CNH | Futures | 7.2884 | 7.2999 | 7.2884 | 7.2945 | 13.0 |
| 2015-12-29 | CSC | Futures | 3.834 | 3.853 | 3.826 | 3.841 | 66.0 |
| 2015-12-29 | CT | Futures | 75.08 | 75.26 | 74.76 | 74.82 | 8574.0 |
| 2015-12-29 | DC | Futures | 30.41 | 30.47 | 30.19 | 30.32 | 135.0 |
| 2015-12-29 | DX | Futures | 91.476 | 91.99 | 91.397 | 91.708 | 17176.0 |
| 2015-12-29 | E1 | Futures | 1.28294 | 1.2847 | 1.2741 | 1.27839 | 9524.0 |
| 2015-12-29 | E6 | Futures | 1.28578 | 1.28788 | 1.27701 | 1.28169 | 111073.0 |
| 2015-12-29 | E7 | Futures | 1.2786 | 1.2807 | 1.2698 | 1.2745 | 2836.0 |
| 2015-12-29 | EBM | Futures | 244.36 | 246.48 | 244.36 | 245.78 | 6445.0 |
| 2015-12-29 | ED | Futures | 95.5543 | 95.5591 | 95.5351 | 95.5351 | 185402.0 |
| 2015-12-29 | ER | Futures | 98.215 | 98.22 | 98.21 | 98.22 | 31928.0 |
| 2015-12-29 | EW | Futures | 1485.3 | 1502.3 | 1485.3 | 1500.5 | 11061.0 |
| 2015-12-29 | FBON | Futures | 115.17 | 115.17 | 114.75 | 114.9 | 161.0 |
| 2015-12-29 | FBTP | Futures | 104.7 | 104.75 | 104.29 | 104.38 | 48180.0 |
| 2015-12-29 | FBTS | Futures | 100.766 | 100.802 | 100.73 | 100.775 | 18322.0 |
| 2015-12-29 | FCE | Futures | 3881.9 | 3933.7 | 3881.9 | 3932.5 | 52229.0 |
| 2015-12-29 | FDAX | Futures | 11637.5 | 11802.3 | 11636.4 | 11761.1 | 50513.0 |
| 2015-12-29 | FDXM | Futures | 11131.3 | 11283.7 | 11127.1 | 11244.3 | 8716.0 |
| 2015-12-29 | FESX | Futures | 2489.4 | 2516.8 | 2486.3 | 2508.4 | 448721.0 |
| 2015-12-29 | FEU3 | Futures | 98.873 | 98.873 | 98.873 | 98.873 | 2.0 |
| 2015-12-29 | FGBL | Futures | 139.93 | 140.04 | 138.84 | 139.15 | 275441.0 |
| 2015-12-29 | FGBM | Futures | 125.5 | 125.53 | 125.3 | 125.38 | 179954.0 |
| 2015-12-29 | FGBS | Futures | 111.398 | 111.408 | 111.383 | 111.398 | 84872.0 |
| 2015-12-29 | FGBX | Futures | 157.74 | 157.95 | 154.7 | 154.93 | 20729.0 |
| 2015-12-29 | FMWO | Futures | 5672.7 | 5685.2 | 5667.7 | 5683.9 | 244.0 |
| 2015-12-29 | FOAT | Futures | 128.11 | 128.21 | 127.23 | 127.31 | 41757.0 |
| 2015-12-29 | FTDX | Futures | 1747.3 | 1775.6 | 1747.3 | 1770.3 | 451.0 |
| 2015-12-29 | FTI | Futures | 387.07 | 391.57 | 386.98 | 391.22 | 20308.0 |
| 2015-12-29 | FTUK | Futures | 5067.7 | 5119.1 | 5041.6 | 5100.3 | 74948.0 |
| 2015-12-29 | FVSA | Futures | 2164.49 | 2192.72 | 2117.44 | 2136.26 | 4274.0 |
| 2015-12-29 | FXXP | Futures | 287.0 | 290.2 | 287.0 | 289.5 | 19053.0 |
| 2015-12-29 | G | Futures | 104.5 | 104.66 | 104.25 | 104.31 | 87806.0 |
| 2015-12-29 | GF | Futures | 313.38 | 314.924 | 311.836 | 313.621 | 1547.0 |
| 2015-12-29 | GSCI | Futures | 492.33 | 494.52 | 492.25 | 494.44 | 46.0 |
> showing 50 of 108 rows — these rows as CSV