PREVIEW / futures_daily / 2017-04-28
file: by_date/futures_daily/2017/2017-04-28.parquet size: 9 KB rows: 108
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-04-28 | ES | Futures | 2591.57 | 2594.29 | 2582.88 | 2585.33 | 1167297.0 |
| 2017-04-28 | NQ | Futures | 6577.37 | 6592.97 | 6562.35 | 6572.65 | 185941.0 |
| 2017-04-28 | YM | Futures | 22048.8 | 22083.6 | 22009.8 | 22025.6 | 89493.0 |
| 2017-04-28 | CL | Futures | 51.41 | 51.92 | 50.92 | 51.47 | 633992.0 |
| 2017-04-28 | GC | Futures | 1618.0 | 1624.0 | 1616.7 | 1621.9 | 173293.0 |
| 2017-04-28 | ZN | Futures | 123.551736 | 123.643916 | 123.183017 | 123.613189 | 1666787.0 |
| 2017-04-28 | A6 | Futures | 0.76623 | 0.76829 | 0.76387 | 0.76746 | 78817.0 |
| 2017-04-28 | AD | Futures | 0.7484 | 0.74896 | 0.74504 | 0.74652 | 74194.0 |
| 2017-04-28 | ALI | Futures | 2551.99 | 2551.99 | 2551.99 | 2551.99 | 0.0 |
| 2017-04-28 | B | Futures | 37.26 | 37.72 | 37.02 | 37.33 | 352782.0 |
| 2017-04-28 | B6 | Futures | 1.3547 | 1.3611 | 1.353 | 1.3591 | 135726.0 |
| 2017-04-28 | BFX | Futures | 4620.7 | 4620.7 | 4607.4 | 4607.4 | 3.0 |
| 2017-04-28 | BR | Futures | 0.22633 | 0.22644 | 0.22361 | 0.22629 | 3500.0 |
| 2017-04-28 | BZ | Futures | 37.0 | 37.45 | 36.76 | 37.06 | 33680.0 |
| 2017-04-28 | C | Futures | 1487.0 | 1495.0 | 1446.0 | 1456.0 | 10354.0 |
| 2017-04-28 | CB | Futures | 263.309 | 263.309 | 262.424 | 262.424 | 6.0 |
| 2017-04-28 | CC | Futures | 1421.0 | 1440.0 | 1382.0 | 1408.0 | 23607.0 |
| 2017-04-28 | CSC | Futures | 3.504 | 3.511 | 3.487 | 3.495 | 27.0 |
| 2017-04-28 | CT | Futures | 86.22 | 87.46 | 86.0 | 87.35 | 17787.0 |
| 2017-04-28 | DC | Futures | 29.29 | 29.29 | 28.75 | 28.88 | 150.0 |
| 2017-04-28 | DX | Futures | 92.3 | 92.351 | 91.843 | 92.14 | 26318.0 |
| 2017-04-28 | E1 | Futures | 1.24638 | 1.25269 | 1.24441 | 1.24651 | 34816.0 |
| 2017-04-28 | E6 | Futures | 1.2553 | 1.26394 | 1.25346 | 1.25795 | 224136.0 |
| 2017-04-28 | E7 | Futures | 1.2489 | 1.2575 | 1.2472 | 1.2515 | 4854.0 |
| 2017-04-28 | EBM | Futures | 187.9 | 189.02 | 187.62 | 188.46 | 23263.0 |
| 2017-04-28 | ED | Futures | 95.5639 | 95.5639 | 95.5446 | 95.5591 | 216617.0 |
| 2017-04-28 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.337 | 40762.0 |
| 2017-04-28 | EW | Futures | 1858.6 | 1861.0 | 1837.4 | 1838.8 | 18980.0 |
| 2017-04-28 | FBON | Futures | 122.16 | 122.21 | 121.81 | 122.09 | 488.0 |
| 2017-04-28 | FBTP | Futures | 105.91 | 105.93 | 105.37 | 105.65 | 101745.0 |
| 2017-04-28 | FBTS | Futures | 102.063 | 102.09 | 102.027 | 102.081 | 29392.0 |
| 2017-04-28 | FCE | Futures | 4650.5 | 4667.0 | 4642.9 | 4648.3 | 70388.0 |
| 2017-04-28 | FDAX | Futures | 13147.8 | 13174.2 | 13118.2 | 13162.0 | 61274.0 |
| 2017-04-28 | FDXM | Futures | 13036.5 | 13057.4 | 13003.0 | 13046.4 | 17038.0 |
| 2017-04-28 | FESX | Futures | 2857.7 | 2868.3 | 2852.0 | 2863.4 | 915839.0 |
| 2017-04-28 | FGBL | Futures | 148.83 | 148.87 | 148.21 | 148.68 | 784863.0 |
| 2017-04-28 | FGBM | Futures | 129.41 | 129.46 | 129.15 | 129.41 | 595923.0 |
| 2017-04-28 | FGBS | Futures | 112.317 | 112.342 | 112.257 | 112.322 | 301752.0 |
| 2017-04-28 | FGBX | Futures | 169.67 | 169.71 | 167.63 | 168.93 | 55231.0 |
| 2017-04-28 | FMWO | Futures | 6319.3 | 6326.6 | 6310.9 | 6312.1 | 2267.0 |
| 2017-04-28 | FOAT | Futures | 134.24 | 134.31 | 133.56 | 134.14 | 141653.0 |
| 2017-04-28 | FTDX | Futures | 2046.0 | 2056.8 | 2046.0 | 2056.8 | 278.0 |
| 2017-04-28 | FTI | Futures | 474.14 | 474.97 | 472.95 | 473.96 | 22808.0 |
| 2017-04-28 | FTUK | Futures | 6154.7 | 6159.0 | 6113.2 | 6131.6 | 94315.0 |
| 2017-04-28 | FVSA | Futures | 578.03 | 592.35 | 572.66 | 590.56 | 24931.0 |
| 2017-04-28 | FXXP | Futures | 324.0 | 324.0 | 322.8 | 323.6 | 28148.0 |
| 2017-04-28 | G | Futures | 115.8 | 115.83 | 115.4 | 115.74 | 193987.0 |
| 2017-04-28 | GF | Futures | 337.387 | 343.345 | 330.857 | 342.657 | 4874.0 |
| 2017-04-28 | GSCI | Futures | 480.9 | 481.53 | 478.07 | 479.27 | 95.0 |
| 2017-04-28 | HE | Futures | 79.735 | 80.392 | 79.615 | 80.064 | 212.0 |
> showing 50 of 108 rows — these rows as CSV