PREVIEW / futures_daily / 2016-04-26
file: by_date/futures_daily/2016/2016-04-26.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-04-26 | ES | Futures | 2237.9 | 2245.41 | 2232.8 | 2242.46 | 1225834.0 |
| 2016-04-26 | NQ | Futures | 5254.93 | 5275.49 | 5178.26 | 5231.72 | 212776.0 |
| 2016-04-26 | YM | Futures | 18618.8 | 18684.4 | 18561.7 | 18631.3 | 120626.0 |
| 2016-04-26 | CL | Futures | 51.18 | 53.4 | 50.63 | 52.46 | 564392.0 |
| 2016-04-26 | GC | Futures | 1598.0 | 1606.7 | 1588.9 | 1602.7 | 148114.0 |
| 2016-04-26 | ZN | Futures | 124.846071 | 125.027117 | 124.619764 | 124.725374 | 1058861.0 |
| 2016-04-26 | A6 | Futures | 0.77901 | 0.78427 | 0.77739 | 0.78144 | 83370.0 |
| 2016-04-26 | AD | Futures | 0.80662 | 0.81183 | 0.80601 | 0.8101 | 53261.0 |
| 2016-04-26 | ALI | Futures | 2231.4 | 2231.4 | 2231.4 | 2231.4 | 0.0 |
| 2016-04-26 | B | Futures | 37.0 | 38.45 | 36.66 | 37.83 | 174906.0 |
| 2016-04-26 | B6 | Futures | 1.5249 | 1.5417 | 1.5247 | 1.5352 | 105410.0 |
| 2016-04-26 | BFX | Futures | 3999.5 | 4010.1 | 3995.4 | 3995.4 | 3.0 |
| 2016-04-26 | BR | Futures | 0.18217 | 0.18301 | 0.18158 | 0.18275 | 521.0 |
| 2016-04-26 | BZ | Futures | 36.82 | 38.29 | 36.57 | 37.71 | 18177.0 |
| 2016-04-26 | C | Futures | 2384.0 | 2412.0 | 2381.0 | 2412.0 | 5074.0 |
| 2016-04-26 | CB | Futures | 255.171 | 255.171 | 254.866 | 254.866 | 4.0 |
| 2016-04-26 | CC | Futures | 2320.0 | 2350.0 | 2314.0 | 2349.0 | 19769.0 |
| 2016-04-26 | CNH | Futures | 7.0828 | 7.0828 | 7.0805 | 7.0805 | 14.0 |
| 2016-04-26 | CSC | Futures | 3.534 | 3.534 | 3.489 | 3.489 | 66.0 |
| 2016-04-26 | CT | Futures | 72.87 | 73.65 | 72.23 | 72.61 | 15445.0 |
| 2016-04-26 | DC | Futures | 27.74 | 27.78 | 27.35 | 27.39 | 284.0 |
| 2016-04-26 | DX | Futures | 88.318 | 88.36 | 87.782 | 88.144 | 21392.0 |
| 2016-04-26 | E1 | Futures | 1.29077 | 1.29755 | 1.28889 | 1.2919 | 18483.0 |
| 2016-04-26 | E6 | Futures | 1.31587 | 1.32444 | 1.31453 | 1.31849 | 162696.0 |
| 2016-04-26 | E7 | Futures | 1.3085 | 1.3172 | 1.3074 | 1.3114 | 3129.0 |
| 2016-04-26 | EBM | Futures | 195.27 | 196.56 | 194.31 | 194.95 | 18549.0 |
| 2016-04-26 | ED | Futures | 95.7015 | 95.7063 | 95.6967 | 95.7015 | 227138.0 |
| 2016-04-26 | ER | Futures | 98.259 | 98.264 | 98.254 | 98.259 | 25491.0 |
| 2016-04-26 | EW | Futures | 1550.4 | 1567.7 | 1549.1 | 1565.6 | 15953.0 |
| 2016-04-26 | FBON | Futures | 117.59 | 117.59 | 117.2 | 117.49 | 269.0 |
| 2016-04-26 | FBTP | Futures | 105.61 | 105.76 | 105.33 | 105.57 | 91061.0 |
| 2016-04-26 | FBTS | Futures | 100.988 | 101.006 | 100.97 | 100.979 | 12889.0 |
| 2016-04-26 | FCE | Futures | 3817.4 | 3845.5 | 3789.3 | 3804.7 | 70097.0 |
| 2016-04-26 | FDAX | Futures | 11121.2 | 11194.8 | 11003.1 | 11065.9 | 106986.0 |
| 2016-04-26 | FDXM | Futures | 10704.7 | 10780.2 | 10596.1 | 10655.1 | 17003.0 |
| 2016-04-26 | FESX | Futures | 2388.3 | 2406.3 | 2373.5 | 2385.2 | 994467.0 |
| 2016-04-26 | FEU3 | Futures | 98.917 | 98.917 | 98.912 | 98.912 | 27.0 |
| 2016-04-26 | FGBL | Futures | 145.09 | 145.17 | 144.41 | 144.56 | 733109.0 |
| 2016-04-26 | FGBM | Futures | 127.4 | 127.43 | 127.17 | 127.22 | 380773.0 |
| 2016-04-26 | FGBS | Futures | 111.658 | 111.663 | 111.628 | 111.633 | 165118.0 |
| 2016-04-26 | FGBX | Futures | 169.35 | 169.66 | 167.85 | 168.32 | 40607.0 |
| 2016-04-26 | FMWO | Futures | 5719.8 | 5724.8 | 5709.9 | 5721.1 | 92.0 |
| 2016-04-26 | FOAT | Futures | 132.76 | 132.88 | 132.13 | 132.28 | 88422.0 |
| 2016-04-26 | FTDX | Futures | 1575.7 | 1575.7 | 1554.7 | 1561.4 | 139.0 |
| 2016-04-26 | FTI | Futures | 399.56 | 402.72 | 398.38 | 399.51 | 23210.0 |
| 2016-04-26 | FTUK | Futures | 5139.8 | 5158.3 | 5131.5 | 5149.7 | 103261.0 |
| 2016-04-26 | FVSA | Futures | 2408.32 | 2429.31 | 2371.59 | 2403.07 | 11168.0 |
| 2016-04-26 | FXXP | Futures | 275.6 | 276.9 | 274.7 | 275.7 | 21351.0 |
| 2016-04-26 | G | Futures | 107.13 | 107.18 | 106.62 | 106.73 | 252281.0 |
| 2016-04-26 | GF | Futures | 287.439 | 290.436 | 286.94 | 289.986 | 2263.0 |
> showing 50 of 110 rows — these rows as CSV