PREVIEW / futures_daily / 2016-04-11
file: by_date/futures_daily/2016/2016-04-11.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-04-11 | ES | Futures | 2191.46 | 2208.1 | 2182.33 | 2184.48 | 1679757.0 |
| 2016-04-11 | NQ | Futures | 5252.28 | 5298.99 | 5224.08 | 5230.54 | 243297.0 |
| 2016-04-11 | YM | Futures | 18182.2 | 18348.5 | 18104.2 | 18167.6 | 165005.0 |
| 2016-04-11 | CL | Futures | 48.22 | 49.47 | 47.64 | 48.99 | 679351.0 |
| 2016-04-11 | GC | Futures | 1600.6 | 1625.2 | 1600.3 | 1621.5 | 160928.0 |
| 2016-04-11 | ZN | Futures | 126.566005 | 126.701789 | 126.264262 | 126.520743 | 806162.0 |
| 2016-04-11 | A6 | Futures | 0.7617 | 0.7701 | 0.75978 | 0.76808 | 86239.0 |
| 2016-04-11 | AD | Futures | 0.78709 | 0.79353 | 0.78566 | 0.79333 | 60316.0 |
| 2016-04-11 | ALI | Futures | 2050.1 | 2055.91 | 2047.19 | 2047.51 | 31.0 |
| 2016-04-11 | B | Futures | 34.98 | 35.86 | 34.49 | 35.67 | 279920.0 |
| 2016-04-11 | B6 | Futures | 1.4873 | 1.5046 | 1.4856 | 1.4999 | 89599.0 |
| 2016-04-11 | BFX | Futures | 3887.9 | 3887.9 | 3878.5 | 3880.2 | 9.0 |
| 2016-04-11 | BR | Futures | 0.1784 | 0.18347 | 0.1784 | 0.18311 | 52.0 |
| 2016-04-11 | BZ | Futures | 34.68 | 35.5 | 34.15 | 35.31 | 26930.0 |
| 2016-04-11 | C | Futures | 2254.0 | 2274.0 | 2238.0 | 2264.0 | 2968.0 |
| 2016-04-11 | CB | Futures | 268.28 | 274.347 | 268.28 | 270.688 | 61.0 |
| 2016-04-11 | CC | Futures | 2116.0 | 2151.0 | 2115.0 | 2145.0 | 21233.0 |
| 2016-04-11 | CNH | Futures | 7.0578 | 7.0642 | 7.0474 | 7.0474 | 4.0 |
| 2016-04-11 | CSC | Futures | 3.63 | 3.63 | 3.63 | 3.63 | 13.0 |
| 2016-04-11 | CT | Futures | 69.42 | 69.86 | 69.23 | 69.73 | 23587.0 |
| 2016-04-11 | DC | Futures | 28.8 | 28.8 | 28.57 | 28.67 | 16.0 |
| 2016-04-11 | DX | Futures | 87.777 | 87.964 | 87.4 | 87.583 | 20714.0 |
| 2016-04-11 | E1 | Futures | 1.32105 | 1.3257 | 1.31628 | 1.32067 | 16784.0 |
| 2016-04-11 | E6 | Futures | 1.33301 | 1.33756 | 1.32864 | 1.33336 | 148089.0 |
| 2016-04-11 | E7 | Futures | 1.3252 | 1.3302 | 1.3215 | 1.3261 | 2543.0 |
| 2016-04-11 | EBM | Futures | 196.88 | 196.88 | 194.95 | 195.27 | 24201.0 |
| 2016-04-11 | ED | Futures | 95.7208 | 95.7208 | 95.716 | 95.716 | 57150.0 |
| 2016-04-11 | ER | Futures | 98.254 | 98.264 | 98.249 | 98.259 | 39935.0 |
| 2016-04-11 | EW | Futures | 1505.6 | 1521.4 | 1499.1 | 1501.4 | 17519.0 |
| 2016-04-11 | FBON | Futures | 118.28 | 118.68 | 118.15 | 118.41 | 229.0 |
| 2016-04-11 | FBTP | Futures | 107.39 | 107.46 | 106.83 | 106.96 | 74616.0 |
| 2016-04-11 | FBTS | Futures | 100.97 | 101.024 | 100.943 | 100.988 | 20357.0 |
| 2016-04-11 | FCE | Futures | 3578.4 | 3615.9 | 3550.5 | 3593.0 | 150557.0 |
| 2016-04-11 | FDAX | Futures | 10365.5 | 10510.5 | 10260.2 | 10447.7 | 115085.0 |
| 2016-04-11 | FDXM | Futures | 9975.5 | 10120.3 | 9879.3 | 10061.3 | 21288.0 |
| 2016-04-11 | FESX | Futures | 2213.6 | 2243.3 | 2192.6 | 2227.7 | 1174821.0 |
| 2016-04-11 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 14.0 |
| 2016-04-11 | FGBL | Futures | 147.04 | 147.22 | 146.45 | 146.72 | 635439.0 |
| 2016-04-11 | FGBM | Futures | 127.79 | 127.84 | 127.69 | 127.78 | 358638.0 |
| 2016-04-11 | FGBS | Futures | 111.693 | 111.713 | 111.688 | 111.698 | 162478.0 |
| 2016-04-11 | FGBX | Futures | 176.75 | 177.08 | 174.36 | 174.73 | 38023.0 |
| 2016-04-11 | FMWO | Futures | 5558.1 | 5559.4 | 5558.1 | 5558.1 | 15.0 |
| 2016-04-11 | FOAT | Futures | 134.64 | 134.83 | 133.95 | 134.18 | 97382.0 |
| 2016-04-11 | FTDX | Futures | 1552.8 | 1566.1 | 1551.4 | 1556.6 | 140.0 |
| 2016-04-11 | FTI | Futures | 385.01 | 389.53 | 382.62 | 387.77 | 6453.0 |
| 2016-04-11 | FTUK | Futures | 5075.4 | 5099.3 | 5044.0 | 5082.4 | 91645.0 |
| 2016-04-11 | FVSA | Futures | 2793.81 | 2826.94 | 2688.91 | 2744.12 | 8161.0 |
| 2016-04-11 | FXXP | Futures | 261.8 | 264.7 | 260.0 | 263.5 | 16829.0 |
| 2016-04-11 | G | Futures | 109.21 | 109.33 | 108.59 | 108.82 | 139420.0 |
| 2016-04-11 | GF | Futures | 306.066 | 307.514 | 302.171 | 303.669 | 4255.0 |
> showing 50 of 109 rows — these rows as CSV