PREVIEW / futures_daily / 2016-11-14
file: by_date/futures_daily/2016/2016-11-14.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 |
|---|---|---|---|---|---|---|---|
| 2016-11-14 | ES | Futures | 2341.11 | 2351.93 | 2327.87 | 2336.79 | 1815339.0 |
| 2016-11-14 | NQ | Futures | 5601.64 | 5638.77 | 5507.06 | 5532.7 | 285041.0 |
| 2016-11-14 | YM | Futures | 19747.2 | 19864.8 | 19701.0 | 19764.0 | 212519.0 |
| 2016-11-14 | CL | Futures | 47.37 | 47.9 | 46.34 | 47.41 | 378509.0 |
| 2016-11-14 | GC | Futures | 1575.2 | 1579.3 | 1553.7 | 1567.5 | 351968.0 |
| 2016-11-14 | ZN | Futures | 123.76043 | 123.76043 | 122.52921 | 123.213222 | 2439460.0 |
| 2016-11-14 | A6 | Futures | 0.76969 | 0.77132 | 0.76703 | 0.76897 | 99419.0 |
| 2016-11-14 | AD | Futures | 0.75778 | 0.75793 | 0.75394 | 0.75563 | 77414.0 |
| 2016-11-14 | ALI | Futures | 2379.38 | 2380.67 | 2363.37 | 2370.74 | 20.0 |
| 2016-11-14 | B | Futures | 33.83 | 34.17 | 33.1 | 33.75 | 260146.0 |
| 2016-11-14 | B6 | Futures | 1.3251 | 1.3267 | 1.3108 | 1.315 | 138399.0 |
| 2016-11-14 | BR | Futures | 0.20006 | 0.20102 | 0.19629 | 0.1978 | 1972.0 |
| 2016-11-14 | BZ | Futures | 33.78 | 34.0 | 32.95 | 33.59 | 37427.0 |
| 2016-11-14 | C | Futures | 2206.0 | 2213.0 | 2164.0 | 2170.0 | 3400.0 |
| 2016-11-14 | CB | Futures | 246.531 | 246.624 | 244.33 | 244.33 | 10.0 |
| 2016-11-14 | CC | Futures | 1870.0 | 1884.0 | 1832.0 | 1841.0 | 25175.0 |
| 2016-11-14 | CNH | Futures | 7.3623 | 7.3958 | 7.3618 | 7.3908 | 63.0 |
| 2016-11-14 | CSC | Futures | 3.935 | 3.958 | 3.907 | 3.926 | 39.0 |
| 2016-11-14 | CT | Futures | 76.74 | 77.31 | 76.15 | 77.19 | 17188.0 |
| 2016-11-14 | DC | Futures | 31.2 | 31.46 | 31.01 | 31.23 | 189.0 |
| 2016-11-14 | DX | Futures | 92.267 | 93.295 | 92.234 | 93.184 | 54245.0 |
| 2016-11-14 | E1 | Futures | 1.26238 | 1.26275 | 1.2478 | 1.2493 | 37871.0 |
| 2016-11-14 | E6 | Futures | 1.25777 | 1.25846 | 1.24299 | 1.2449 | 247721.0 |
| 2016-11-14 | E7 | Futures | 1.2507 | 1.2517 | 1.2363 | 1.2381 | 6472.0 |
| 2016-11-14 | EBM | Futures | 190.94 | 191.23 | 190.06 | 190.64 | 15259.0 |
| 2016-11-14 | ED | Futures | 95.62 | 95.62 | 95.5911 | 95.608 | 635141.0 |
| 2016-11-14 | ER | Futures | 98.264 | 98.274 | 98.264 | 98.269 | 46379.0 |
| 2016-11-14 | EW | Futures | 1664.2 | 1688.6 | 1662.1 | 1688.1 | 20356.0 |
| 2016-11-14 | FBON | Futures | 120.8 | 120.8 | 119.76 | 120.56 | 344.0 |
| 2016-11-14 | FBTP | Futures | 103.39 | 103.41 | 101.8 | 102.92 | 174254.0 |
| 2016-11-14 | FBTS | Futures | 100.709 | 100.718 | 100.538 | 100.628 | 46718.0 |
| 2016-11-14 | FCE | Futures | 3998.3 | 4022.6 | 3961.2 | 3975.8 | 61327.0 |
| 2016-11-14 | FDAX | Futures | 11375.9 | 11410.7 | 11269.7 | 11308.8 | 112630.0 |
| 2016-11-14 | FDXM | Futures | 11350.2 | 11388.2 | 11246.9 | 11284.3 | 30123.0 |
| 2016-11-14 | FESX | Futures | 2445.4 | 2455.8 | 2420.6 | 2433.4 | 1195092.0 |
| 2016-11-14 | FEU3 | Futures | 98.952 | 98.952 | 98.952 | 98.952 | 3.0 |
| 2016-11-14 | FGBL | Futures | 145.83 | 146.43 | 145.3 | 146.0 | 1161299.0 |
| 2016-11-14 | FGBM | Futures | 127.77 | 127.97 | 127.61 | 127.85 | 944977.0 |
| 2016-11-14 | FGBS | Futures | 111.788 | 111.847 | 111.773 | 111.823 | 480817.0 |
| 2016-11-14 | FGBX | Futures | 170.34 | 172.04 | 167.78 | 170.49 | 68954.0 |
| 2016-11-14 | FMWO | Futures | 5683.2 | 5683.2 | 5646.9 | 5649.3 | 913.0 |
| 2016-11-14 | FOAT | Futures | 131.74 | 132.03 | 130.91 | 131.62 | 212176.0 |
| 2016-11-14 | FTDX | Futures | 1665.6 | 1678.4 | 1652.4 | 1652.4 | 191.0 |
| 2016-11-14 | FTI | Futures | 409.0 | 411.28 | 406.22 | 407.06 | 10243.0 |
| 2016-11-14 | FTUK | Futures | 5700.1 | 5745.7 | 5674.3 | 5696.3 | 136562.0 |
| 2016-11-14 | FVSA | Futures | 1357.31 | 1420.15 | 1354.17 | 1410.73 | 16524.0 |
| 2016-11-14 | FXXP | Futures | 281.0 | 282.0 | 278.0 | 279.1 | 45163.0 |
| 2016-11-14 | G | Futures | 110.18 | 110.51 | 109.59 | 110.13 | 221529.0 |
| 2016-11-14 | GF | Futures | 270.484 | 276.563 | 270.206 | 272.883 | 5890.0 |
| 2016-11-14 | GSCI | Futures | 475.9 | 478.01 | 473.04 | 476.86 | 1505.0 |
> showing 50 of 109 rows — these rows as CSV