PREVIEW / futures_daily / 2019-09-11
file: by_date/futures_daily/2019/2019-09-11.parquet size: 10 KB rows: 116
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-11 | ES | Futures | 3214.51 | 3241.76 | 3206.96 | 3239.33 | 1423833.0 |
| 2019-09-11 | NQ | Futures | 9001.63 | 9101.22 | 8964.79 | 9083.66 | 383871.0 |
| 2019-09-11 | YM | Futures | 28215.2 | 28498.7 | 28170.1 | 28477.7 | 3446.0 |
| 2019-09-11 | CL | Futures | 59.46 | 59.88 | 57.11 | 57.26 | 858772.0 |
| 2019-09-11 | GC | Futures | 1842.8 | 1858.0 | 1841.6 | 1854.3 | 308791.0 |
| 2019-09-11 | ZN | Futures | 128.783855 | 128.923215 | 128.598042 | 128.737402 | 1613505.0 |
| 2019-09-11 | A6 | Futures | 0.70584 | 0.7083 | 0.70461 | 0.70563 | 92429.0 |
| 2019-09-11 | AD | Futures | 0.76725 | 0.76756 | 0.76312 | 0.76438 | 64707.0 |
| 2019-09-11 | ALI | Futures | 2224.27 | 2227.0 | 2214.25 | 2221.84 | 495.0 |
| 2019-09-11 | B | Futures | 48.57 | 48.87 | 46.74 | 46.97 | 315118.0 |
| 2019-09-11 | B6 | Futures | 1.2612 | 1.2626 | 1.2565 | 1.2579 | 122143.0 |
| 2019-09-11 | BR | Futures | 0.19821 | 0.19833 | 0.1976 | 0.1976 | 2.0 |
| 2019-09-11 | BTC | Futures | 14494.5 | 14780.2 | 14144.5 | 14465.9 | 3528.0 |
| 2019-09-11 | BZ | Futures | 47.7 | 48.13 | 46.05 | 46.27 | 37485.0 |
| 2019-09-11 | C | Futures | 1545.0 | 1566.0 | 1540.0 | 1562.0 | 31258.0 |
| 2019-09-11 | CB | Futures | 261.652 | 264.073 | 261.652 | 264.073 | 14.0 |
| 2019-09-11 | CC | Futures | 1501.0 | 1516.0 | 1492.0 | 1512.0 | 20953.0 |
| 2019-09-11 | CNH | Futures | 7.1131 | 7.121 | 7.1056 | 7.1121 | 207.0 |
| 2019-09-11 | CSC | Futures | 3.047 | 3.078 | 3.046 | 3.078 | 18.0 |
| 2019-09-11 | CT | Futures | 58.74 | 58.74 | 58.61 | 58.63 | 6.0 |
| 2019-09-11 | DC | Futures | 25.74 | 25.94 | 25.68 | 25.94 | 162.0 |
| 2019-09-11 | DX | Futures | 94.594 | 94.985 | 94.555 | 94.891 | 19629.0 |
| 2019-09-11 | E1 | Futures | 1.1698 | 1.17037 | 1.16657 | 1.16818 | 31740.0 |
| 2019-09-11 | E6 | Futures | 1.20602 | 1.20689 | 1.19914 | 1.20152 | 220509.0 |
| 2019-09-11 | E7 | Futures | 1.1998 | 1.2005 | 1.193 | 1.1953 | 4659.0 |
| 2019-09-11 | EBM | Futures | 186.06 | 186.33 | 184.97 | 185.24 | 17918.0 |
| 2019-09-11 | ED | Futures | 95.2792 | 95.2986 | 95.2694 | 95.284 | 396857.0 |
| 2019-09-11 | ER | Futures | 98.538 | 98.543 | 98.524 | 98.538 | 98564.0 |
| 2019-09-11 | EW | Futures | 2036.1 | 2069.2 | 2028.7 | 2066.0 | 785.0 |
| 2019-09-11 | FBON | Futures | 144.92 | 145.07 | 144.5 | 145.0 | 289.0 |
| 2019-09-11 | FBTP | Futures | 130.73 | 131.3 | 130.15 | 131.06 | 75782.0 |
| 2019-09-11 | FBTS | Futures | 108.606 | 108.635 | 108.385 | 108.587 | 64869.0 |
| 2019-09-11 | FCE | Futures | 5071.7 | 5097.5 | 5071.2 | 5089.8 | 102257.0 |
| 2019-09-11 | FDAX | Futures | 12915.9 | 13051.8 | 12915.9 | 13002.8 | 94663.0 |
| 2019-09-11 | FDXM | Futures | 12762.1 | 12883.9 | 12762.1 | 12838.6 | 169.0 |
| 2019-09-11 | FESX | Futures | 3050.1 | 3073.8 | 3050.1 | 3065.9 | 379268.0 |
| 2019-09-11 | FEU3 | Futures | 99.238 | 99.238 | 99.238 | 99.238 | 50.0 |
| 2019-09-11 | FGBL | Futures | 167.89 | 168.45 | 167.75 | 168.32 | 619840.0 |
| 2019-09-11 | FGBM | Futures | 135.49 | 135.6 | 135.4 | 135.56 | 400655.0 |
| 2019-09-11 | FGBS | Futures | 113.152 | 113.187 | 113.127 | 113.172 | 379545.0 |
| 2019-09-11 | FGBX | Futures | 219.87 | 222.61 | 219.49 | 222.05 | 58583.0 |
| 2019-09-11 | FMWO | Futures | 7347.5 | 7385.6 | 7339.5 | 7361.4 | 3381.0 |
| 2019-09-11 | FOAT | Futures | 154.59 | 155.11 | 154.36 | 155.0 | 121988.0 |
| 2019-09-11 | FTI | Futures | 540.68 | 543.52 | 539.83 | 543.33 | 21.0 |
| 2019-09-11 | FTUK | Futures | 6728.7 | 6778.7 | 6728.7 | 6767.1 | 48007.0 |
| 2019-09-11 | FVSA | Futures | 186.87 | 190.63 | 185.62 | 187.5 | 31209.0 |
| 2019-09-11 | FXXP | Futures | 349.3 | 350.9 | 348.8 | 350.6 | 30842.0 |
| 2019-09-11 | G | Futures | 121.24 | 121.53 | 120.96 | 121.42 | 207778.0 |
| 2019-09-11 | GF | Futures | 274.684 | 282.638 | 274.422 | 280.545 | 10058.0 |
| 2019-09-11 | GSCI | Futures | 454.86 | 454.86 | 454.52 | 454.52 | 3289.0 |
> showing 50 of 116 rows — these rows as CSV