PREVIEW / futures_daily / 2016-01-13
file: by_date/futures_daily/2016/2016-01-13.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 |
|---|---|---|---|---|---|---|---|
| 2016-01-13 | ES | Futures | 2053.49 | 2079.13 | 2005.96 | 2009.7 | 2899958.0 |
| 2016-01-13 | NQ | Futures | 5051.18 | 5117.12 | 4885.3 | 4895.26 | 521065.0 |
| 2016-01-13 | YM | Futures | 16919.0 | 17108.4 | 16582.7 | 16614.8 | 305051.0 |
| 2016-01-13 | CL | Futures | 45.42 | 47.16 | 44.77 | 45.33 | 637903.0 |
| 2016-01-13 | GC | Futures | 1401.6 | 1413.0 | 1392.1 | 1402.0 | 156109.0 |
| 2016-01-13 | ZN | Futures | 122.964872 | 123.476285 | 122.66404 | 123.280745 | 1702895.0 |
| 2016-01-13 | A6 | Futures | 0.69689 | 0.7042 | 0.69428 | 0.69528 | 104312.0 |
| 2016-01-13 | AD | Futures | 0.71644 | 0.72073 | 0.71102 | 0.71204 | 96419.0 |
| 2016-01-13 | ALI | Futures | 2077.09 | 2077.09 | 2077.09 | 2077.09 | 0.0 |
| 2016-01-13 | B | Futures | 26.93 | 27.43 | 25.8 | 26.09 | 472154.0 |
| 2016-01-13 | B6 | Futures | 1.518 | 1.5232 | 1.513 | 1.5199 | 83424.0 |
| 2016-01-13 | BFX | Futures | 4281.5 | 4289.3 | 4235.8 | 4239.4 | 106.0 |
| 2016-01-13 | BR | Futures | 0.154 | 0.15592 | 0.154 | 0.15523 | 42.0 |
| 2016-01-13 | BZ | Futures | 26.54 | 27.18 | 25.53 | 25.82 | 49051.0 |
| 2016-01-13 | C | Futures | 2168.0 | 2191.0 | 2161.0 | 2182.0 | 9358.0 |
| 2016-01-13 | CB | Futures | 262.452 | 262.452 | 262.452 | 262.452 | 4.0 |
| 2016-01-13 | CC | Futures | 2112.0 | 2140.0 | 2112.0 | 2132.0 | 20209.0 |
| 2016-01-13 | CNH | Futures | 7.3313 | 7.3403 | 7.304 | 7.304 | 41.0 |
| 2016-01-13 | CSC | Futures | 3.745 | 3.785 | 3.745 | 3.775 | 96.0 |
| 2016-01-13 | CT | Futures | 72.04 | 73.13 | 72.04 | 72.79 | 14708.0 |
| 2016-01-13 | DC | Futures | 29.48 | 29.89 | 29.46 | 29.78 | 146.0 |
| 2016-01-13 | DX | Futures | 92.579 | 92.85 | 92.392 | 92.46 | 27274.0 |
| 2016-01-13 | E1 | Futures | 1.26185 | 1.2621 | 1.25213 | 1.25743 | 18432.0 |
| 2016-01-13 | E6 | Futures | 1.27064 | 1.27514 | 1.26532 | 1.27385 | 179786.0 |
| 2016-01-13 | E7 | Futures | 1.2633 | 1.2678 | 1.2583 | 1.2667 | 4454.0 |
| 2016-01-13 | EBM | Futures | 241.19 | 241.19 | 237.3 | 237.66 | 17259.0 |
| 2016-01-13 | ED | Futures | 95.5832 | 95.5976 | 95.5736 | 95.588 | 246774.0 |
| 2016-01-13 | ER | Futures | 98.239 | 98.239 | 98.229 | 98.234 | 44881.0 |
| 2016-01-13 | EW | Futures | 1372.6 | 1385.9 | 1334.9 | 1340.1 | 34847.0 |
| 2016-01-13 | FBON | Futures | 114.73 | 115.55 | 114.67 | 115.19 | 620.0 |
| 2016-01-13 | FBTP | Futures | 104.71 | 105.27 | 104.56 | 105.07 | 118874.0 |
| 2016-01-13 | FBTS | Futures | 100.837 | 100.873 | 100.828 | 100.846 | 19274.0 |
| 2016-01-13 | FCE | Futures | 3711.7 | 3744.0 | 3596.6 | 3681.9 | 108488.0 |
| 2016-01-13 | FDAX | Futures | 10959.7 | 11023.2 | 10555.8 | 10788.9 | 130816.0 |
| 2016-01-13 | FDXM | Futures | 10480.1 | 10539.2 | 10095.5 | 10316.3 | 26671.0 |
| 2016-01-13 | FESX | Futures | 2351.8 | 2372.3 | 2276.5 | 2329.0 | 1445578.0 |
| 2016-01-13 | FEU3 | Futures | 98.887 | 98.892 | 98.887 | 98.892 | 33.0 |
| 2016-01-13 | FGBL | Futures | 140.44 | 141.13 | 140.25 | 140.82 | 729316.0 |
| 2016-01-13 | FGBM | Futures | 125.89 | 126.07 | 125.83 | 126.0 | 412231.0 |
| 2016-01-13 | FGBS | Futures | 111.508 | 111.528 | 111.488 | 111.518 | 157176.0 |
| 2016-01-13 | FGBX | Futures | 158.91 | 160.8 | 158.34 | 159.43 | 39172.0 |
| 2016-01-13 | FMWO | Futures | 5309.1 | 5311.6 | 5269.2 | 5281.7 | 909.0 |
| 2016-01-13 | FOAT | Futures | 128.23 | 128.7 | 128.04 | 128.56 | 93085.0 |
| 2016-01-13 | FTDX | Futures | 1659.0 | 1677.7 | 1616.8 | 1647.5 | 291.0 |
| 2016-01-13 | FTI | Futures | 371.15 | 375.35 | 360.26 | 368.4 | 26231.0 |
| 2016-01-13 | FTUK | Futures | 4807.1 | 4859.3 | 4716.2 | 4806.3 | 124250.0 |
| 2016-01-13 | FVSA | Futures | 2613.57 | 2828.05 | 2578.66 | 2633.53 | 17987.0 |
| 2016-01-13 | FXXP | Futures | 272.0 | 274.2 | 264.9 | 270.1 | 32429.0 |
| 2016-01-13 | G | Futures | 105.54 | 105.79 | 105.48 | 105.7 | 161407.0 |
| 2016-01-13 | GF | Futures | 308.519 | 311.906 | 306.359 | 308.667 | 3338.0 |
> showing 50 of 110 rows — these rows as CSV