PREVIEW / futures_daily / 2017-03-08
file: by_date/futures_daily/2017/2017-03-08.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-03-08 | ES | Futures | 2564.71 | 2572.57 | 2557.93 | 2562.81 | 1651698.0 |
| 2017-03-08 | NQ | Futures | 6305.55 | 6337.67 | 6286.4 | 6320.88 | 221615.0 |
| 2017-03-08 | YM | Futures | 22024.4 | 22074.0 | 21947.6 | 21980.2 | 151456.0 |
| 2017-03-08 | CL | Futures | 56.01 | 56.15 | 53.11 | 53.35 | 963392.0 |
| 2017-03-08 | GC | Futures | 1552.9 | 1556.6 | 1541.2 | 1545.0 | 211111.0 |
| 2017-03-08 | ZN | Futures | 121.324056 | 121.446963 | 120.78634 | 121.078243 | 1719991.0 |
| 2017-03-08 | A6 | Futures | 0.77689 | 0.77914 | 0.77034 | 0.77167 | 120331.0 |
| 2017-03-08 | AD | Futures | 0.76136 | 0.76238 | 0.75646 | 0.75697 | 98026.0 |
| 2017-03-08 | ALI | Futures | 2518.48 | 2518.48 | 2503.41 | 2515.59 | 31.0 |
| 2017-03-08 | B | Futures | 40.62 | 40.73 | 38.65 | 38.78 | 444133.0 |
| 2017-03-08 | B6 | Futures | 1.2799 | 1.2813 | 1.2734 | 1.2766 | 179916.0 |
| 2017-03-08 | BFX | Futures | 4465.6 | 4481.4 | 4465.6 | 4481.4 | 2.0 |
| 2017-03-08 | BR | Futures | 0.22596 | 0.22596 | 0.22491 | 0.22491 | 10.0 |
| 2017-03-08 | BZ | Futures | 40.42 | 40.53 | 38.48 | 38.61 | 43000.0 |
| 2017-03-08 | C | Futures | 1633.0 | 1638.0 | 1623.0 | 1634.0 | 12318.0 |
| 2017-03-08 | CB | Futures | 274.721 | 275.85 | 274.721 | 275.24 | 7.0 |
| 2017-03-08 | CC | Futures | 1452.0 | 1467.0 | 1448.0 | 1460.0 | 12007.0 |
| 2017-03-08 | CNH | Futures | 7.2842 | 7.3024 | 7.2842 | 7.3008 | 14.0 |
| 2017-03-08 | CSC | Futures | 3.723 | 3.732 | 3.71 | 3.732 | 38.0 |
| 2017-03-08 | CT | Futures | 86.83 | 87.26 | 86.51 | 87.04 | 10149.0 |
| 2017-03-08 | DC | Futures | 30.41 | 30.8 | 30.29 | 30.71 | 183.0 |
| 2017-03-08 | DX | Futures | 94.747 | 95.143 | 94.696 | 95.042 | 51021.0 |
| 2017-03-08 | E1 | Futures | 1.22302 | 1.22475 | 1.22091 | 1.22202 | 33276.0 |
| 2017-03-08 | E6 | Futures | 1.22051 | 1.22161 | 1.21704 | 1.2186 | 295448.0 |
| 2017-03-08 | E7 | Futures | 1.2144 | 1.2153 | 1.2108 | 1.2123 | 2305.0 |
| 2017-03-08 | EBM | Futures | 194.9 | 195.74 | 194.62 | 194.9 | 17252.0 |
| 2017-03-08 | ED | Futures | 95.5109 | 95.5182 | 95.5061 | 95.5134 | 225646.0 |
| 2017-03-08 | ER | Futures | 98.303 | 98.308 | 98.303 | 98.303 | 31177.0 |
| 2017-03-08 | EW | Futures | 1827.7 | 1835.7 | 1819.0 | 1820.6 | 29945.0 |
| 2017-03-08 | FBON | Futures | 120.6 | 120.75 | 119.91 | 120.02 | 1032.0 |
| 2017-03-08 | FBTP | Futures | 104.14 | 104.38 | 103.56 | 103.66 | 108878.0 |
| 2017-03-08 | FBTS | Futures | 101.809 | 101.9 | 101.728 | 101.746 | 35944.0 |
| 2017-03-08 | FCE | Futures | 4353.9 | 4378.1 | 4338.5 | 4364.5 | 116478.0 |
| 2017-03-08 | FDAX | Futures | 12593.0 | 12687.5 | 12574.5 | 12645.8 | 84764.0 |
| 2017-03-08 | FDXM | Futures | 12542.8 | 12636.4 | 12527.0 | 12594.8 | 29036.0 |
| 2017-03-08 | FESX | Futures | 2703.1 | 2721.5 | 2699.1 | 2715.1 | 1379403.0 |
| 2017-03-08 | FGBL | Futures | 148.22 | 148.23 | 147.47 | 147.51 | 731059.0 |
| 2017-03-08 | FGBM | Futures | 129.7 | 129.73 | 129.37 | 129.39 | 600941.0 |
| 2017-03-08 | FGBS | Futures | 112.462 | 112.492 | 112.392 | 112.402 | 516416.0 |
| 2017-03-08 | FGBX | Futures | 166.67 | 166.87 | 164.95 | 165.27 | 45674.0 |
| 2017-03-08 | FMWO | Futures | 6147.0 | 6162.6 | 6147.0 | 6159.0 | 1256.0 |
| 2017-03-08 | FOAT | Futures | 131.41 | 131.51 | 130.62 | 130.72 | 156177.0 |
| 2017-03-08 | FTDX | Futures | 1883.2 | 1919.0 | 1883.2 | 1916.6 | 44.0 |
| 2017-03-08 | FTI | Futures | 456.2 | 459.7 | 454.98 | 456.84 | 25017.0 |
| 2017-03-08 | FTUK | Futures | 6201.3 | 6225.5 | 6190.7 | 6222.1 | 121207.0 |
| 2017-03-08 | FVSA | Futures | 675.9 | 682.17 | 652.88 | 659.16 | 26832.0 |
| 2017-03-08 | FXXP | Futures | 308.4 | 309.7 | 307.6 | 309.2 | 48659.0 |
| 2017-03-08 | G | Futures | 114.16 | 114.31 | 113.69 | 113.92 | 200526.0 |
| 2017-03-08 | GF | Futures | 282.858 | 285.594 | 281.091 | 283.542 | 1517.0 |
| 2017-03-08 | GSCI | Futures | 508.47 | 510.79 | 496.5 | 496.5 | 2912.0 |
> showing 50 of 110 rows — these rows as CSV