PREVIEW / futures_daily / 2015-11-13
file: by_date/futures_daily/2015/2015-11-13.parquet size: 9 KB rows: 109
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-11-13 | ES | Futures | 2170.59 | 2176.44 | 2139.74 | 2147.18 | 2128939.0 |
| 2015-11-13 | NQ | Futures | 5359.36 | 5367.25 | 5244.78 | 5263.78 | 344229.0 |
| 2015-11-13 | YM | Futures | 17958.1 | 17999.4 | 17698.1 | 17752.8 | 179695.0 |
| 2015-11-13 | CL | Futures | 66.29 | 67.23 | 64.17 | 64.87 | 248589.0 |
| 2015-11-13 | GC | Futures | 1398.7 | 1404.5 | 1391.8 | 1395.3 | 130832.0 |
| 2015-11-13 | ZN | Futures | 120.92255 | 121.326673 | 120.832745 | 121.206933 | 1050601.0 |
| 2015-11-13 | A6 | Futures | 0.71123 | 0.71503 | 0.70963 | 0.71203 | 68461.0 |
| 2015-11-13 | AD | Futures | 0.77035 | 0.77179 | 0.76707 | 0.76953 | 53164.0 |
| 2015-11-13 | ALI | Futures | 2106.13 | 2106.13 | 2106.13 | 2106.13 | 25.0 |
| 2015-11-13 | B | Futures | 39.86 | 40.53 | 38.95 | 39.23 | 303947.0 |
| 2015-11-13 | B6 | Futures | 1.6035 | 1.6079 | 1.5991 | 1.6036 | 65326.0 |
| 2015-11-13 | BR | Futures | 0.16131 | 0.16229 | 0.15675 | 0.15989 | 2391.0 |
| 2015-11-13 | BZ | Futures | 39.56 | 40.27 | 38.71 | 38.98 | 29960.0 |
| 2015-11-13 | C | Futures | 2426.0 | 2460.0 | 2423.0 | 2459.0 | 7245.0 |
| 2015-11-13 | CB | Futures | 216.505 | 217.464 | 216.505 | 217.464 | 7.0 |
| 2015-11-13 | CC | Futures | 2459.0 | 2481.0 | 2450.0 | 2480.0 | 26788.0 |
| 2015-11-13 | CNH | Futures | 7.1159 | 7.1381 | 7.1159 | 7.1324 | 135.0 |
| 2015-11-13 | CSC | Futures | 4.209 | 4.209 | 4.161 | 4.191 | 37.0 |
| 2015-11-13 | CT | Futures | 74.18 | 74.4 | 73.61 | 73.99 | 19883.0 |
| 2015-11-13 | DC | Futures | 33.63 | 33.7 | 33.32 | 33.43 | 227.0 |
| 2015-11-13 | DX | Futures | 92.259 | 92.871 | 92.235 | 92.682 | 35039.0 |
| 2015-11-13 | E1 | Futures | 1.26819 | 1.26958 | 1.25766 | 1.2602 | 28250.0 |
| 2015-11-13 | E6 | Futures | 1.2662 | 1.26761 | 1.25554 | 1.25824 | 229608.0 |
| 2015-11-13 | E7 | Futures | 1.2593 | 1.2615 | 1.2486 | 1.2513 | 5629.0 |
| 2015-11-13 | EBM | Futures | 262.71 | 263.07 | 258.69 | 258.69 | 16970.0 |
| 2015-11-13 | ED | Futures | 95.6871 | 95.6967 | 95.6823 | 95.6919 | 135812.0 |
| 2015-11-13 | ER | Futures | 98.229 | 98.239 | 98.225 | 98.229 | 52726.0 |
| 2015-11-13 | EW | Futures | 1492.0 | 1497.3 | 1474.7 | 1479.2 | 25799.0 |
| 2015-11-13 | FBON | Futures | 114.31 | 114.67 | 114.27 | 114.56 | 769.0 |
| 2015-11-13 | FBTP | Futures | 104.32 | 104.77 | 104.27 | 104.66 | 82004.0 |
| 2015-11-13 | FBTS | Futures | 100.588 | 100.65 | 100.588 | 100.633 | 14358.0 |
| 2015-11-13 | FCE | Futures | 4033.5 | 4056.9 | 3976.7 | 4014.7 | 1843.0 |
| 2015-11-13 | FDAX | Futures | 11805.6 | 11913.5 | 11680.6 | 11777.5 | 113195.0 |
| 2015-11-13 | FDIV | Futures | 138.77 | 138.77 | 137.84 | 137.84 | 6.0 |
| 2015-11-13 | FDXM | Futures | 11028.8 | 11130.7 | 10914.6 | 11006.2 | 15045.0 |
| 2015-11-13 | FESX | Futures | 2518.2 | 2541.4 | 2490.5 | 2513.7 | 1422270.0 |
| 2015-11-13 | FEU3 | Futures | 98.882 | 98.882 | 98.877 | 98.877 | 5.0 |
| 2015-11-13 | FGBL | Futures | 139.11 | 139.78 | 139.1 | 139.63 | 604438.0 |
| 2015-11-13 | FGBM | Futures | 125.66 | 125.86 | 125.65 | 125.79 | 364072.0 |
| 2015-11-13 | FGBS | Futures | 111.503 | 111.548 | 111.498 | 111.523 | 169136.0 |
| 2015-11-13 | FGBX | Futures | 155.51 | 157.08 | 155.35 | 156.55 | 26976.0 |
| 2015-11-13 | FMWO | Futures | 5595.2 | 5595.2 | 5527.2 | 5534.6 | 610.0 |
| 2015-11-13 | FOAT | Futures | 127.86 | 128.57 | 127.86 | 128.43 | 70039.0 |
| 2015-11-13 | FTDX | Futures | 1711.2 | 1711.2 | 1682.7 | 1687.0 | 136.0 |
| 2015-11-13 | FTI | Futures | 396.86 | 398.47 | 390.95 | 393.99 | 176.0 |
| 2015-11-13 | FTUK | Futures | 4933.9 | 4951.2 | 4887.7 | 4912.6 | 123771.0 |
| 2015-11-13 | FVSA | Futures | 2148.54 | 2247.92 | 2139.07 | 2200.59 | 17487.0 |
| 2015-11-13 | FXXP | Futures | 288.3 | 289.8 | 285.9 | 287.5 | 25951.0 |
| 2015-11-13 | G | Futures | 103.36 | 103.73 | 103.35 | 103.62 | 134049.0 |
| 2015-11-13 | GF | Futures | 321.391 | 324.238 | 313.911 | 317.627 | 5043.0 |
> showing 50 of 109 rows — these rows as CSV