PREVIEW / futures_daily / 2017-06-15
file: by_date/futures_daily/2017/2017-06-15.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 |
|---|---|---|---|---|---|---|---|
| 2017-06-15 | ES | Futures | 2645.05 | 2645.87 | 2626.04 | 2643.15 | 1874682.0 |
| 2017-06-15 | NQ | Futures | 6735.85 | 6738.79 | 6631.52 | 6711.46 | 435110.0 |
| 2017-06-15 | YM | Futures | 22539.7 | 22548.1 | 22429.7 | 22537.5 | 187622.0 |
| 2017-06-15 | CL | Futures | 46.37 | 46.5 | 45.9 | 46.14 | 339519.0 |
| 2017-06-15 | GC | Futures | 1611.9 | 1619.3 | 1599.2 | 1601.6 | 255149.0 |
| 2017-06-15 | ZN | Futures | 125.073421 | 125.15037 | 124.688674 | 124.734844 | 1271460.0 |
| 2017-06-15 | A6 | Futures | 0.77845 | 0.78297 | 0.7764 | 0.77784 | 50665.0 |
| 2017-06-15 | AD | Futures | 0.76917 | 0.77034 | 0.76541 | 0.76739 | 93889.0 |
| 2017-06-15 | ALI | Futures | 2484.0 | 2484.0 | 2484.0 | 2484.0 | 0.0 |
| 2017-06-15 | B | Futures | 33.29 | 33.58 | 33.22 | 33.38 | 301404.0 |
| 2017-06-15 | B6 | Futures | 1.3362 | 1.3411 | 1.3302 | 1.3376 | 66723.0 |
| 2017-06-15 | BFX | Futures | 4680.1 | 4691.6 | 4680.1 | 4691.6 | 8.0 |
| 2017-06-15 | BR | Futures | 0.22126 | 0.22219 | 0.21911 | 0.22219 | 15.0 |
| 2017-06-15 | BZ | Futures | 33.29 | 33.43 | 33.08 | 33.24 | 26749.0 |
| 2017-06-15 | C | Futures | 1659.0 | 1672.0 | 1647.0 | 1650.0 | 3140.0 |
| 2017-06-15 | CB | Futures | 333.757 | 335.794 | 327.218 | 333.301 | 27.0 |
| 2017-06-15 | CC | Futures | 1581.0 | 1585.0 | 1565.0 | 1571.0 | 21198.0 |
| 2017-06-15 | CNH | Futures | 7.0896 | 7.0896 | 7.0891 | 7.0891 | 1.0 |
| 2017-06-15 | CSC | Futures | 3.631 | 3.637 | 3.612 | 3.623 | 30.0 |
| 2017-06-15 | CT | Futures | 81.4 | 81.4 | 78.93 | 79.64 | 20925.0 |
| 2017-06-15 | DC | Futures | 30.56 | 30.64 | 30.29 | 30.35 | 180.0 |
| 2017-06-15 | DX | Futures | 90.225 | 90.818 | 90.123 | 90.717 | 28822.0 |
| 2017-06-15 | E1 | Futures | 1.27211 | 1.27309 | 1.26449 | 1.26719 | 17311.0 |
| 2017-06-15 | E6 | Futures | 1.29181 | 1.2929 | 1.28179 | 1.28419 | 136668.0 |
| 2017-06-15 | E7 | Futures | 1.2848 | 1.286 | 1.2751 | 1.2775 | 8290.0 |
| 2017-06-15 | EBM | Futures | 189.01 | 189.84 | 188.17 | 189.84 | 11948.0 |
| 2017-06-15 | ED | Futures | 95.5935 | 95.5983 | 95.5789 | 95.5838 | 254209.0 |
| 2017-06-15 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.332 | 31619.0 |
| 2017-06-15 | EW | Futures | 1870.0 | 1870.0 | 1852.5 | 1862.7 | 15448.0 |
| 2017-06-15 | FBON | Futures | 125.22 | 125.22 | 124.26 | 124.77 | 922.0 |
| 2017-06-15 | FBTP | Futures | 109.35 | 109.45 | 108.62 | 109.15 | 107479.0 |
| 2017-06-15 | FBTS | Futures | 102.863 | 102.872 | 102.781 | 102.845 | 42628.0 |
| 2017-06-15 | FCE | Futures | 4721.7 | 4726.7 | 4656.4 | 4695.1 | 82866.0 |
| 2017-06-15 | FDAX | Futures | 13523.1 | 13526.8 | 13319.9 | 13402.2 | 116985.0 |
| 2017-06-15 | FDXM | Futures | 13406.9 | 13406.9 | 13196.6 | 13276.1 | 3659.0 |
| 2017-06-15 | FESX | Futures | 2890.4 | 2891.2 | 2848.7 | 2873.2 | 1163133.0 |
| 2017-06-15 | FEU3 | Futures | 99.011 | 99.011 | 99.006 | 99.006 | 105.0 |
| 2017-06-15 | FGBL | Futures | 150.19 | 150.29 | 149.35 | 149.52 | 763925.0 |
| 2017-06-15 | FGBM | Futures | 129.84 | 129.87 | 129.35 | 129.48 | 768696.0 |
| 2017-06-15 | FGBS | Futures | 112.342 | 112.342 | 112.217 | 112.257 | 522390.0 |
| 2017-06-15 | FGBX | Futures | 171.46 | 172.12 | 169.7 | 170.06 | 55014.0 |
| 2017-06-15 | FMWO | Futures | 6450.6 | 6453.1 | 6432.6 | 6450.6 | 2857.0 |
| 2017-06-15 | FOAT | Futures | 137.25 | 137.34 | 136.6 | 136.78 | 130730.0 |
| 2017-06-15 | FTDX | Futures | 2284.2 | 2284.7 | 2238.1 | 2251.1 | 1238.0 |
| 2017-06-15 | FTI | Futures | 481.06 | 481.15 | 475.29 | 478.06 | 21882.0 |
| 2017-06-15 | FTUK | Futures | 6406.4 | 6414.6 | 6320.8 | 6362.3 | 146563.0 |
| 2017-06-15 | FVSA | Futures | 475.49 | 513.28 | 475.49 | 495.96 | 26462.0 |
| 2017-06-15 | FXXP | Futures | 328.4 | 328.5 | 325.3 | 327.5 | 61740.0 |
| 2017-06-15 | G | Futures | 117.01 | 117.13 | 116.07 | 116.22 | 234680.0 |
| 2017-06-15 | GF | Futures | 319.125 | 324.393 | 317.753 | 322.857 | 6142.0 |
> showing 50 of 110 rows — these rows as CSV