PREVIEW / futures_daily / 2018-02-28
file: by_date/futures_daily/2018/2018-02-28.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 |
|---|---|---|---|---|---|---|---|
| 2018-02-28 | ES | Futures | 2985.11 | 3001.96 | 2947.62 | 2950.33 | 1876678.0 |
| 2018-02-28 | NQ | Futures | 8097.24 | 8163.71 | 8031.66 | 8040.15 | 461819.0 |
| 2018-02-28 | YM | Futures | 26798.6 | 26973.7 | 26384.2 | 26405.2 | 271877.0 |
| 2018-02-28 | CL | Futures | 63.23 | 63.89 | 61.79 | 62.08 | 768409.0 |
| 2018-02-28 | GC | Futures | 1684.7 | 1690.8 | 1681.9 | 1683.4 | 263797.0 |
| 2018-02-28 | ZN | Futures | 118.920796 | 119.167616 | 118.766534 | 119.121337 | 329530.0 |
| 2018-02-28 | A6 | Futures | 0.80172 | 0.80429 | 0.79833 | 0.80008 | 109839.0 |
| 2018-02-28 | AD | Futures | 0.79488 | 0.79569 | 0.79077 | 0.79153 | 76922.0 |
| 2018-02-28 | B | Futures | 47.84 | 48.21 | 46.55 | 46.72 | 356644.0 |
| 2018-02-28 | B6 | Futures | 1.4477 | 1.4484 | 1.4316 | 1.433 | 161588.0 |
| 2018-02-28 | BR | Futures | 0.23325 | 0.23325 | 0.23325 | 0.23325 | 1.0 |
| 2018-02-28 | BTC | Futures | 14794.4 | 15266.0 | 14329.7 | 14766.6 | 1130.0 |
| 2018-02-28 | BZ | Futures | 47.3 | 47.63 | 45.99 | 46.15 | 34490.0 |
| 2018-02-28 | C | Futures | 1434.0 | 1442.0 | 1418.0 | 1440.0 | 15619.0 |
| 2018-02-28 | CB | Futures | 287.918 | 288.474 | 284.15 | 284.15 | 33.0 |
| 2018-02-28 | CC | Futures | 1632.0 | 1633.0 | 1599.0 | 1627.0 | 28961.0 |
| 2018-02-28 | CNH | Futures | 6.4595 | 6.4632 | 6.4563 | 6.4582 | 63.0 |
| 2018-02-28 | CSC | Futures | 3.342 | 3.35 | 3.331 | 3.346 | 33.0 |
| 2018-02-28 | CT | Futures | 94.57 | 95.46 | 94.03 | 95.32 | 18387.0 |
| 2018-02-28 | DC | Futures | 26.56 | 26.65 | 26.39 | 26.44 | 81.0 |
| 2018-02-28 | DX | Futures | 84.806 | 85.13 | 84.749 | 85.037 | 24709.0 |
| 2018-02-28 | E1 | Futures | 1.29489 | 1.29489 | 1.28481 | 1.28785 | 25523.0 |
| 2018-02-28 | E6 | Futures | 1.38863 | 1.38948 | 1.3833 | 1.385 | 216326.0 |
| 2018-02-28 | E7 | Futures | 1.3818 | 1.3826 | 1.3765 | 1.378 | 3095.0 |
| 2018-02-28 | EBM | Futures | 178.01 | 180.17 | 177.75 | 179.9 | 14323.0 |
| 2018-02-28 | ED | Futures | 95.0518 | 95.0712 | 95.0397 | 95.064 | 403497.0 |
| 2018-02-28 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.337 | 28963.0 |
| 2018-02-28 | EW | Futures | 2004.1 | 2011.5 | 1974.3 | 1977.1 | 21752.0 |
| 2018-02-28 | FBON | Futures | 126.04 | 126.61 | 126.04 | 126.52 | 218.0 |
| 2018-02-28 | FBTP | Futures | 111.65 | 111.89 | 111.38 | 111.78 | 105656.0 |
| 2018-02-28 | FBTS | Futures | 103.622 | 103.704 | 103.613 | 103.677 | 73962.0 |
| 2018-02-28 | FCE | Futures | 4697.3 | 4731.8 | 4673.9 | 4698.7 | 61115.0 |
| 2018-02-28 | FDAX | Futures | 12892.2 | 12984.5 | 12820.6 | 12898.4 | 87651.0 |
| 2018-02-28 | FDXM | Futures | 12912.5 | 13006.0 | 12840.8 | 12920.3 | 28978.0 |
| 2018-02-28 | FESX | Futures | 2808.6 | 2827.4 | 2789.8 | 2808.6 | 1105376.0 |
| 2018-02-28 | FGBL | Futures | 147.58 | 147.84 | 147.39 | 147.77 | 701486.0 |
| 2018-02-28 | FGBM | Futures | 128.71 | 128.83 | 128.6 | 128.81 | 517352.0 |
| 2018-02-28 | FGBS | Futures | 112.336 | 112.372 | 112.316 | 112.372 | 366542.0 |
| 2018-02-28 | FGBX | Futures | 166.05 | 166.44 | 165.66 | 166.19 | 94509.0 |
| 2018-02-28 | FMWO | Futures | 7061.2 | 7075.2 | 6991.2 | 7043.7 | 5590.0 |
| 2018-02-28 | FOAT | Futures | 136.52 | 136.85 | 136.35 | 136.76 | 152980.0 |
| 2018-02-28 | FTDX | Futures | 2597.2 | 2627.6 | 2597.2 | 2622.7 | 140.0 |
| 2018-02-28 | FTI | Futures | 491.67 | 494.88 | 488.63 | 491.67 | 20132.0 |
| 2018-02-28 | FTUK | Futures | 6329.1 | 6358.0 | 6280.2 | 6313.0 | 127705.0 |
| 2018-02-28 | FVSA | Futures | 428.43 | 448.13 | 411.19 | 427.2 | 18116.0 |
| 2018-02-28 | FXXP | Futures | 324.0 | 325.4 | 321.4 | 323.4 | 31741.0 |
| 2018-02-28 | G | Futures | 112.23 | 112.81 | 112.22 | 112.69 | 244316.0 |
| 2018-02-28 | GF | Futures | 321.16 | 322.807 | 317.098 | 317.866 | 3742.0 |
| 2018-02-28 | GSCI | Futures | 512.58 | 513.38 | 503.88 | 504.5 | 384.0 |
| 2018-02-28 | HE | Futures | 89.115 | 89.243 | 86.193 | 86.322 | 38957.0 |
> showing 50 of 110 rows — these rows as CSV