PREVIEW / futures_daily / 2015-12-04
file: by_date/futures_daily/2015/2015-12-04.parquet size: 9 KB rows: 110
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-04 | ES | Futures | 2184.15 | 2226.43 | 2177.23 | 2221.65 | 2269530.0 |
| 2015-12-04 | NQ | Futures | 5397.07 | 5522.46 | 5381.87 | 5510.77 | 305073.0 |
| 2015-12-04 | YM | Futures | 18059.2 | 18422.4 | 17999.4 | 18385.2 | 198761.0 |
| 2015-12-04 | CL | Futures | 63.8 | 64.87 | 61.16 | 61.73 | 510758.0 |
| 2015-12-04 | GC | Futures | 1369.6 | 1403.6 | 1363.5 | 1398.1 | 208897.0 |
| 2015-12-04 | ZN | Futures | 120.997388 | 121.326673 | 120.638167 | 121.221901 | 58276.0 |
| 2015-12-04 | A6 | Futures | 0.73314 | 0.73854 | 0.72773 | 0.73394 | 102884.0 |
| 2015-12-04 | AD | Futures | 0.76738 | 0.76902 | 0.76339 | 0.76564 | 79416.0 |
| 2015-12-04 | ALI | Futures | 2177.37 | 2192.4 | 2177.37 | 2179.66 | 8.0 |
| 2015-12-04 | B | Futures | 38.94 | 39.5 | 37.62 | 37.91 | 208202.0 |
| 2015-12-04 | B6 | Futures | 1.5949 | 1.5963 | 1.5879 | 1.5904 | 97034.0 |
| 2015-12-04 | BFX | Futures | 4426.4 | 4428.8 | 4420.3 | 4420.3 | 91.0 |
| 2015-12-04 | BR | Futures | 0.16378 | 0.16378 | 0.1629 | 0.16327 | 95.0 |
| 2015-12-04 | BZ | Futures | 38.56 | 39.12 | 37.29 | 37.57 | 24957.0 |
| 2015-12-04 | C | Futures | 2427.0 | 2441.0 | 2422.0 | 2438.0 | 5620.0 |
| 2015-12-04 | CB | Futures | 245.505 | 246.155 | 245.011 | 246.155 | 17.0 |
| 2015-12-04 | CC | Futures | 2489.0 | 2505.0 | 2485.0 | 2499.0 | 10985.0 |
| 2015-12-04 | CNH | Futures | 7.1398 | 7.1664 | 7.1398 | 7.1617 | 84.0 |
| 2015-12-04 | CSC | Futures | 3.998 | 3.998 | 3.983 | 3.986 | 52.0 |
| 2015-12-04 | CT | Futures | 74.91 | 76.01 | 74.67 | 75.8 | 20521.0 |
| 2015-12-04 | DC | Futures | 32.14 | 32.14 | 31.88 | 31.97 | 97.0 |
| 2015-12-04 | DX | Futures | 91.67 | 92.231 | 91.422 | 91.976 | 55178.0 |
| 2015-12-04 | E1 | Futures | 1.27757 | 1.28011 | 1.26451 | 1.27326 | 37823.0 |
| 2015-12-04 | E6 | Futures | 1.28073 | 1.28378 | 1.26948 | 1.27394 | 439242.0 |
| 2015-12-04 | E7 | Futures | 1.2734 | 1.2766 | 1.2626 | 1.2669 | 10215.0 |
| 2015-12-04 | EBM | Futures | 254.3 | 254.67 | 251.38 | 252.84 | 4410.0 |
| 2015-12-04 | ED | Futures | 95.6415 | 95.6415 | 95.627 | 95.6294 | 311072.0 |
| 2015-12-04 | ER | Futures | 98.195 | 98.215 | 98.19 | 98.195 | 175947.0 |
| 2015-12-04 | EW | Futures | 1510.2 | 1529.2 | 1504.1 | 1528.1 | 22065.0 |
| 2015-12-04 | FBON | Futures | 115.17 | 115.5 | 115.12 | 115.46 | 1671.0 |
| 2015-12-04 | FBTP | Futures | 104.07 | 104.57 | 103.85 | 104.26 | 228873.0 |
| 2015-12-04 | FBTS | Futures | 100.65 | 100.65 | 100.463 | 100.588 | 65123.0 |
| 2015-12-04 | FCE | Futures | 3913.2 | 3988.8 | 3899.8 | 3938.2 | 152229.0 |
| 2015-12-04 | FDAX | Futures | 11767.0 | 11982.3 | 11708.1 | 11843.0 | 120730.0 |
| 2015-12-04 | FDXM | Futures | 11006.2 | 11198.6 | 10936.2 | 11064.8 | 17194.0 |
| 2015-12-04 | FESX | Futures | 2478.5 | 2529.4 | 2467.2 | 2496.5 | 1663198.0 |
| 2015-12-04 | FEU3 | Futures | 98.843 | 98.853 | 98.843 | 98.843 | 54.0 |
| 2015-12-04 | FGBL | Futures | 138.4 | 139.0 | 137.95 | 138.56 | 1267237.0 |
| 2015-12-04 | FGBM | Futures | 125.11 | 125.43 | 125.02 | 125.22 | 969238.0 |
| 2015-12-04 | FGBS | Futures | 111.303 | 111.393 | 111.303 | 111.343 | 668853.0 |
| 2015-12-04 | FGBX | Futures | 154.13 | 156.37 | 153.88 | 154.25 | 104339.0 |
| 2015-12-04 | FMWO | Futures | 5632.3 | 5653.3 | 5600.2 | 5647.1 | 1177.0 |
| 2015-12-04 | FOAT | Futures | 127.04 | 127.64 | 126.63 | 127.14 | 229076.0 |
| 2015-12-04 | FTDX | Futures | 1753.9 | 1753.9 | 1724.0 | 1743.0 | 199.0 |
| 2015-12-04 | FTI | Futures | 387.26 | 392.3 | 385.3 | 388.3 | 54064.0 |
| 2015-12-04 | FTUK | Futures | 5016.8 | 5062.2 | 5000.3 | 5010.3 | 118007.0 |
| 2015-12-04 | FVSA | Futures | 2143.8 | 2181.66 | 2049.15 | 2124.87 | 13409.0 |
| 2015-12-04 | FXXP | Futures | 287.4 | 292.1 | 286.3 | 288.8 | 37938.0 |
| 2015-12-04 | G | Futures | 104.5 | 104.56 | 103.59 | 103.96 | 240894.0 |
| 2015-12-04 | GF | Futures | 308.699 | 311.739 | 305.562 | 307.782 | 3365.0 |
> showing 50 of 110 rows — these rows as CSV