PREVIEW / futures_daily / 2016-10-04
file: by_date/futures_daily/2016/2016-10-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 |
|---|---|---|---|---|---|---|---|
| 2016-10-04 | ES | Futures | 2329.49 | 2335.98 | 2310.29 | 2319.75 | 2143439.0 |
| 2016-10-04 | NQ | Futures | 5735.7 | 5760.74 | 5699.75 | 5724.8 | 276978.0 |
| 2016-10-04 | YM | Futures | 19073.1 | 19141.3 | 18924.0 | 18997.5 | 207369.0 |
| 2016-10-04 | CL | Futures | 53.65 | 54.32 | 53.22 | 53.69 | 513710.0 |
| 2016-10-04 | GC | Futures | 1687.2 | 1687.7 | 1628.1 | 1629.0 | 351260.0 |
| 2016-10-04 | ZN | Futures | 127.36289 | 127.469291 | 126.891682 | 126.952483 | 1402205.0 |
| 2016-10-04 | A6 | Futures | 0.78224 | 0.78346 | 0.77499 | 0.77601 | 101266.0 |
| 2016-10-04 | AD | Futures | 0.78144 | 0.78165 | 0.77545 | 0.77637 | 57930.0 |
| 2016-10-04 | ALI | Futures | 2211.87 | 2211.87 | 2210.6 | 2210.6 | 5.0 |
| 2016-10-04 | B | Futures | 39.42 | 39.9 | 38.96 | 39.37 | 269265.0 |
| 2016-10-04 | B6 | Futures | 1.3541 | 1.3558 | 1.3408 | 1.3417 | 133639.0 |
| 2016-10-04 | BFX | Futures | 4210.4 | 4228.9 | 4210.4 | 4228.9 | 15.0 |
| 2016-10-04 | BR | Futures | 0.20808 | 0.20808 | 0.20609 | 0.20715 | 8.0 |
| 2016-10-04 | BZ | Futures | 38.86 | 39.51 | 38.74 | 39.14 | 24858.0 |
| 2016-10-04 | C | Futures | 2413.0 | 2451.0 | 2407.0 | 2448.0 | 11004.0 |
| 2016-10-04 | CB | Futures | 239.928 | 239.928 | 236.735 | 236.921 | 30.0 |
| 2016-10-04 | CC | Futures | 2049.0 | 2088.0 | 2046.0 | 2082.0 | 20665.0 |
| 2016-10-04 | CNH | Futures | 7.2081 | 7.2208 | 7.2081 | 7.2208 | 3.0 |
| 2016-10-04 | CSC | Futures | 3.741 | 3.741 | 3.716 | 3.721 | 93.0 |
| 2016-10-04 | CT | Futures | 76.9 | 78.14 | 76.72 | 78.05 | 13448.0 |
| 2016-10-04 | DC | Futures | 29.34 | 29.44 | 29.11 | 29.15 | 227.0 |
| 2016-10-04 | DX | Futures | 89.037 | 89.712 | 89.033 | 89.466 | 42193.0 |
| 2016-10-04 | E1 | Futures | 1.28493 | 1.28618 | 1.27272 | 1.27683 | 38038.0 |
| 2016-10-04 | E6 | Futures | 1.30414 | 1.30709 | 1.29527 | 1.30205 | 254938.0 |
| 2016-10-04 | E7 | Futures | 1.2968 | 1.2999 | 1.2883 | 1.295 | 5448.0 |
| 2016-10-04 | EBM | Futures | 188.0 | 189.47 | 188.0 | 188.58 | 13789.0 |
| 2016-10-04 | ED | Futures | 95.6393 | 95.649 | 95.6345 | 95.6345 | 203905.0 |
| 2016-10-04 | ER | Futures | 98.264 | 98.269 | 98.264 | 98.264 | 33197.0 |
| 2016-10-04 | EW | Futures | 1636.8 | 1642.2 | 1622.3 | 1628.8 | 23583.0 |
| 2016-10-04 | FBON | Futures | 125.15 | 125.35 | 124.61 | 125.12 | 1012.0 |
| 2016-10-04 | FBTP | Futures | 109.41 | 109.73 | 108.74 | 109.46 | 144483.0 |
| 2016-10-04 | FBTS | Futures | 101.302 | 101.32 | 101.239 | 101.311 | 18559.0 |
| 2016-10-04 | FCE | Futures | 3959.1 | 4017.4 | 3954.7 | 4000.9 | 111442.0 |
| 2016-10-04 | FDAX | Futures | 11095.8 | 11241.1 | 11072.6 | 11226.9 | 123759.0 |
| 2016-10-04 | FDXM | Futures | 11071.9 | 11216.3 | 11049.7 | 11202.6 | 39717.0 |
| 2016-10-04 | FESX | Futures | 2394.1 | 2427.0 | 2389.3 | 2421.4 | 1307334.0 |
| 2016-10-04 | FEU3 | Futures | 98.942 | 98.947 | 98.942 | 98.947 | 10.0 |
| 2016-10-04 | FGBL | Futures | 151.03 | 151.27 | 150.36 | 150.93 | 832829.0 |
| 2016-10-04 | FGBM | Futures | 129.26 | 129.34 | 129.09 | 129.27 | 434510.0 |
| 2016-10-04 | FGBS | Futures | 111.992 | 112.002 | 111.967 | 111.992 | 355112.0 |
| 2016-10-04 | FGBX | Futures | 187.14 | 188.2 | 184.9 | 186.81 | 50091.0 |
| 2016-10-04 | FMWO | Futures | 5757.0 | 5767.9 | 5744.9 | 5752.1 | 240.0 |
| 2016-10-04 | FOAT | Futures | 138.4 | 138.66 | 137.77 | 138.32 | 134046.0 |
| 2016-10-04 | FTDX | Futures | 1773.4 | 1788.6 | 1772.4 | 1782.7 | 358.0 |
| 2016-10-04 | FTI | Futures | 415.86 | 421.87 | 415.22 | 420.18 | 36649.0 |
| 2016-10-04 | FTUK | Futures | 5849.9 | 5986.2 | 5849.9 | 5976.1 | 251702.0 |
| 2016-10-04 | FVSA | Futures | 1512.2 | 1551.52 | 1462.15 | 1476.45 | 19888.0 |
| 2016-10-04 | FXXP | Futures | 282.4 | 285.7 | 281.9 | 285.2 | 27134.0 |
| 2016-10-04 | G | Futures | 116.36 | 116.57 | 115.77 | 116.08 | 209325.0 |
| 2016-10-04 | GF | Futures | 257.096 | 264.471 | 256.993 | 264.059 | 2944.0 |
> showing 50 of 110 rows — these rows as CSV