PREVIEW / futures_daily / 2019-09-13
file: by_date/futures_daily/2019/2019-09-13.parquet size: 10 KB rows: 115
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 |
|---|---|---|---|---|---|---|---|
| 2019-09-13 | ES | Futures | 3247.96 | 3262.8 | 3240.95 | 3244.18 | 1275710.0 |
| 2019-09-13 | NQ | Futures | 9114.17 | 9162.82 | 9074.45 | 9079.35 | 243852.0 |
| 2019-09-13 | YM | Futures | 28541.7 | 28671.9 | 28533.3 | 28569.0 | 117553.0 |
| 2019-09-13 | CL | Futures | 56.58 | 57.09 | 55.83 | 56.26 | 207129.0 |
| 2019-09-13 | GC | Futures | 1858.3 | 1870.8 | 1841.8 | 1849.7 | 364417.0 |
| 2019-09-13 | ZN | Futures | 128.443198 | 128.505135 | 127.343805 | 127.421227 | 2497593.0 |
| 2019-09-13 | A6 | Futures | 0.70615 | 0.70871 | 0.70543 | 0.70768 | 65593.0 |
| 2019-09-13 | AD | Futures | 0.76368 | 0.76373 | 0.75889 | 0.7593 | 79693.0 |
| 2019-09-13 | ALI | Futures | 2187.84 | 2203.93 | 2184.8 | 2199.68 | 100.0 |
| 2019-09-13 | B | Futures | 46.69 | 46.97 | 46.03 | 46.51 | 195827.0 |
| 2019-09-13 | B6 | Futures | 1.259 | 1.2759 | 1.2577 | 1.273 | 139636.0 |
| 2019-09-13 | BTC | Futures | 14973.1 | 15087.4 | 14580.2 | 14665.9 | 2876.0 |
| 2019-09-13 | BZ | Futures | 45.97 | 46.26 | 45.35 | 45.82 | 26153.0 |
| 2019-09-13 | C | Futures | 1560.0 | 1592.0 | 1560.0 | 1576.0 | 14595.0 |
| 2019-09-13 | CB | Futures | 265.401 | 265.401 | 263.335 | 263.335 | 8.0 |
| 2019-09-13 | CC | Futures | 1526.0 | 1555.0 | 1524.0 | 1534.0 | 28735.0 |
| 2019-09-13 | CNH | Futures | 7.0646 | 7.0712 | 7.0358 | 7.0446 | 879.0 |
| 2019-09-13 | CSC | Futures | 3.143 | 3.146 | 3.114 | 3.129 | 230.0 |
| 2019-09-13 | CT | Futures | 61.49 | 62.03 | 60.81 | 60.86 | 73.0 |
| 2019-09-13 | DC | Futures | 26.58 | 26.6 | 26.24 | 26.42 | 396.0 |
| 2019-09-13 | DX | Futures | 94.71 | 94.715 | 94.294 | 94.555 | 18065.0 |
| 2019-09-13 | E1 | Futures | 1.1706 | 1.17624 | 1.16945 | 1.16968 | 25947.0 |
| 2019-09-13 | E6 | Futures | 1.20743 | 1.2122 | 1.20634 | 1.20759 | 292235.0 |
| 2019-09-13 | E7 | Futures | 1.2011 | 1.2058 | 1.2002 | 1.2014 | 4863.0 |
| 2019-09-13 | EBM | Futures | 184.97 | 187.98 | 184.97 | 186.33 | 24328.0 |
| 2019-09-13 | ED | Futures | 95.2451 | 95.25 | 95.1723 | 95.182 | 427442.0 |
| 2019-09-13 | ER | Futures | 98.445 | 98.455 | 98.391 | 98.435 | 260976.0 |
| 2019-09-13 | EW | Futures | 2067.0 | 2079.1 | 2063.0 | 2064.9 | 43549.0 |
| 2019-09-13 | FBON | Futures | 144.86 | 145.15 | 144.3 | 144.41 | 510.0 |
| 2019-09-13 | FBTP | Futures | 131.68 | 132.48 | 131.18 | 131.93 | 109107.0 |
| 2019-09-13 | FBTS | Futures | 108.442 | 108.529 | 108.192 | 108.404 | 116104.0 |
| 2019-09-13 | FCE | Futures | 5110.6 | 5125.1 | 5095.7 | 5110.2 | 14016.0 |
| 2019-09-13 | FDAX | Futures | 13082.3 | 13158.1 | 13060.2 | 13146.5 | 92470.0 |
| 2019-09-13 | FDXM | Futures | 12915.2 | 12990.2 | 12902.7 | 12982.9 | 382.0 |
| 2019-09-13 | FESX | Futures | 3086.9 | 3104.5 | 3085.2 | 3102.7 | 445857.0 |
| 2019-09-13 | FGBL | Futures | 167.62 | 167.73 | 166.33 | 166.58 | 950951.0 |
| 2019-09-13 | FGBM | Futures | 134.95 | 134.96 | 134.63 | 134.71 | 676838.0 |
| 2019-09-13 | FGBS | Futures | 112.9 | 112.94 | 112.86 | 112.9 | 708659.0 |
| 2019-09-13 | FGBX | Futures | 221.07 | 221.24 | 216.13 | 216.79 | 83588.0 |
| 2019-09-13 | FMWO | Futures | 7436.4 | 7454.8 | 7423.7 | 7439.8 | 6680.0 |
| 2019-09-13 | FOAT | Futures | 154.41 | 154.51 | 153.55 | 153.71 | 128985.0 |
| 2019-09-13 | FTDX | Futures | 2825.6 | 2832.0 | 2823.1 | 2832.0 | 2.0 |
| 2019-09-13 | FTI | Futures | 544.99 | 547.55 | 543.62 | 546.8 | 966.0 |
| 2019-09-13 | FTUK | Futures | 6790.3 | 6806.5 | 6748.1 | 6800.9 | 194521.0 |
| 2019-09-13 | FVSA | Futures | 180.76 | 180.76 | 176.83 | 177.39 | 16742.0 |
| 2019-09-13 | FXXP | Futures | 351.9 | 353.3 | 351.2 | 353.1 | 36614.0 |
| 2019-09-13 | G | Futures | 121.0 | 121.0 | 120.09 | 120.2 | 191823.0 |
| 2019-09-13 | GF | Futures | 282.271 | 284.312 | 281.016 | 281.696 | 6084.0 |
| 2019-09-13 | GSCI | Futures | 453.79 | 453.79 | 453.29 | 453.29 | 2684.0 |
| 2019-09-13 | HE | Futures | 61.055 | 63.059 | 60.253 | 62.705 | 38816.0 |
> showing 50 of 115 rows — these rows as CSV