PREVIEW / futures_daily / 2019-12-11
file: by_date/futures_daily/2019/2019-12-11.parquet size: 10 KB rows: 113
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-12-11 | ES | Futures | 3394.39 | 3404.13 | 3387.89 | 3402.51 | 1225764.0 |
| 2019-12-11 | NQ | Futures | 9641.44 | 9693.01 | 9616.95 | 9686.67 | 304183.0 |
| 2019-12-11 | YM | Futures | 29307.0 | 29377.4 | 29194.6 | 29320.7 | 3791.0 |
| 2019-12-11 | CL | Futures | 60.31 | 60.47 | 59.34 | 60.0 | 589650.0 |
| 2019-12-11 | GC | Futures | 1806.7 | 1825.1 | 1804.7 | 1814.7 | 251732.0 |
| 2019-12-11 | ZN | Futures | 127.715427 | 128.195502 | 127.684454 | 128.133557 | 1196002.0 |
| 2019-12-11 | A6 | Futures | 0.69958 | 0.70788 | 0.69917 | 0.70778 | 89235.0 |
| 2019-12-11 | AD | Futures | 0.76197 | 0.76615 | 0.76151 | 0.76579 | 78198.0 |
| 2019-12-11 | ALI | Futures | 2156.95 | 2157.86 | 2152.4 | 2155.74 | 90.0 |
| 2019-12-11 | B | Futures | 51.62 | 51.83 | 50.82 | 51.39 | 250138.0 |
| 2019-12-11 | B6 | Futures | 1.3348 | 1.3445 | 1.3339 | 1.3435 | 153501.0 |
| 2019-12-11 | BR | Futures | 0.19652 | 0.19746 | 0.19587 | 0.19587 | 36.0 |
| 2019-12-11 | BTC | Futures | 10908.5 | 10968.7 | 10727.9 | 10795.6 | 2979.0 |
| 2019-12-11 | BZ | Futures | 51.06 | 51.13 | 50.14 | 50.71 | 31647.0 |
| 2019-12-11 | C | Futures | 1742.0 | 1744.0 | 1718.0 | 1723.0 | 22317.0 |
| 2019-12-11 | CB | Futures | 244.535 | 244.535 | 243.474 | 243.474 | 33.0 |
| 2019-12-11 | CC | Futures | 1690.0 | 1694.0 | 1677.0 | 1680.0 | 11518.0 |
| 2019-12-11 | CNH | Futures | 7.0193 | 7.0225 | 7.0099 | 7.0109 | 380.0 |
| 2019-12-11 | CSC | Futures | 3.311 | 3.316 | 3.296 | 3.301 | 101.0 |
| 2019-12-11 | CT | Futures | 62.71 | 62.96 | 62.15 | 62.66 | 12650.0 |
| 2019-12-11 | DC | Futures | 27.8 | 27.86 | 27.52 | 27.7 | 114.0 |
| 2019-12-11 | DX | Futures | 94.211 | 94.288 | 93.735 | 93.775 | 10153.0 |
| 2019-12-11 | E1 | Futures | 1.16919 | 1.1725 | 1.16679 | 1.17204 | 52089.0 |
| 2019-12-11 | E6 | Futures | 1.2028 | 1.20857 | 1.20065 | 1.20781 | 429430.0 |
| 2019-12-11 | E7 | Futures | 1.1965 | 1.2021 | 1.1944 | 1.2015 | 5636.0 |
| 2019-12-11 | EBM | Futures | 200.83 | 201.65 | 199.73 | 200.0 | 15800.0 |
| 2019-12-11 | ED | Futures | 95.3277 | 95.3423 | 95.3229 | 95.3326 | 230334.0 |
| 2019-12-11 | ER | Futures | 98.391 | 98.391 | 98.386 | 98.386 | 32434.0 |
| 2019-12-11 | EW | Futures | 2122.2 | 2127.8 | 2118.8 | 2125.5 | 2125.0 |
| 2019-12-11 | FBON | Futures | 142.77 | 143.33 | 142.71 | 143.26 | 216.0 |
| 2019-12-11 | FBTP | Futures | 128.26 | 128.92 | 128.18 | 128.73 | 71503.0 |
| 2019-12-11 | FBTS | Futures | 108.134 | 108.22 | 108.124 | 108.182 | 35942.0 |
| 2019-12-11 | FCE | Futures | 5295.5 | 5309.0 | 5271.5 | 5304.5 | 54319.0 |
| 2019-12-11 | FDAX | Futures | 13786.7 | 13898.5 | 13759.2 | 13879.0 | 95534.0 |
| 2019-12-11 | FDXM | Futures | 13640.0 | 13739.2 | 13614.9 | 13730.3 | 514.0 |
| 2019-12-11 | FESX | Futures | 3213.2 | 3238.7 | 3209.7 | 3237.0 | 268265.0 |
| 2019-12-11 | FGBL | Futures | 164.58 | 165.13 | 164.45 | 164.89 | 431703.0 |
| 2019-12-11 | FGBM | Futures | 133.8 | 133.97 | 133.79 | 133.89 | 290809.0 |
| 2019-12-11 | FGBS | Futures | 112.699 | 112.724 | 112.699 | 112.714 | 146688.0 |
| 2019-12-11 | FGBX | Futures | 212.86 | 214.55 | 212.54 | 213.82 | 29175.0 |
| 2019-12-11 | FMWO | Futures | 7627.0 | 7658.8 | 7619.0 | 7641.7 | 5312.0 |
| 2019-12-11 | FOAT | Futures | 151.83 | 152.2 | 151.81 | 152.16 | 83591.0 |
| 2019-12-11 | FTDX | Futures | 3027.8 | 3036.3 | 3027.8 | 3036.3 | 2.0 |
| 2019-12-11 | FTI | Futures | 573.65 | 573.94 | 571.21 | 573.51 | 10.0 |
| 2019-12-11 | FTUK | Futures | 6712.6 | 6741.7 | 6687.7 | 6707.0 | 25674.0 |
| 2019-12-11 | FVSA | Futures | 142.92 | 145.96 | 141.4 | 141.9 | 29344.0 |
| 2019-12-11 | FXXP | Futures | 367.4 | 368.8 | 366.8 | 368.5 | 20602.0 |
| 2019-12-11 | G | Futures | 120.23 | 120.36 | 120.06 | 120.25 | 165135.0 |
| 2019-12-11 | GF | Futures | 299.226 | 301.175 | 298.12 | 300.753 | 5012.0 |
| 2019-12-11 | GSCI | Futures | 468.87 | 468.87 | 468.87 | 468.87 | 1393.0 |
> showing 50 of 113 rows — these rows as CSV