PREVIEW / futures_daily / 2019-11-13
file: by_date/futures_daily/2019/2019-11-13.parquet size: 10 KB rows: 120
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-11-13 | ES | Futures | 3346.49 | 3352.71 | 3329.71 | 3351.09 | 1251057.0 |
| 2019-11-13 | NQ | Futures | 9533.98 | 9543.77 | 9472.9 | 9525.62 | 382042.0 |
| 2019-11-13 | YM | Futures | 29038.3 | 29153.7 | 28894.4 | 29143.2 | 160990.0 |
| 2019-11-13 | CL | Futures | 58.03 | 58.82 | 57.46 | 58.41 | 212615.0 |
| 2019-11-13 | GC | Futures | 1796.7 | 1810.7 | 1796.5 | 1805.1 | 352334.0 |
| 2019-11-13 | ZN | Futures | 127.173476 | 127.761884 | 127.173476 | 127.730915 | 1483757.0 |
| 2019-11-13 | A6 | Futures | 0.70245 | 0.7042 | 0.7005 | 0.70143 | 93291.0 |
| 2019-11-13 | AD | Futures | 0.76106 | 0.76136 | 0.75925 | 0.7601 | 63763.0 |
| 2019-11-13 | ALI | Futures | 2168.48 | 2176.07 | 2151.48 | 2168.18 | 155.0 |
| 2019-11-13 | B | Futures | 49.33 | 50.04 | 48.83 | 49.75 | 273025.0 |
| 2019-11-13 | B6 | Futures | 1.3078 | 1.3087 | 1.3048 | 1.3067 | 70153.0 |
| 2019-11-13 | BR | Futures | 0.19384 | 0.19384 | 0.19267 | 0.19287 | 8819.0 |
| 2019-11-13 | BTC | Futures | 12729.4 | 12823.3 | 12606.7 | 12686.1 | 2121.0 |
| 2019-11-13 | BZ | Futures | 48.75 | 49.35 | 48.17 | 49.07 | 33278.0 |
| 2019-11-13 | C | Futures | 1782.0 | 1813.0 | 1772.0 | 1808.0 | 13537.0 |
| 2019-11-13 | CB | Futures | 246.832 | 247.983 | 246.832 | 247.983 | 7.0 |
| 2019-11-13 | CC | Futures | 1705.0 | 1750.0 | 1702.0 | 1737.0 | 36712.0 |
| 2019-11-13 | CNH | Futures | 7.0172 | 7.0308 | 7.0095 | 7.0274 | 1080.0 |
| 2019-11-13 | CSC | Futures | 3.381 | 3.413 | 3.357 | 3.388 | 192.0 |
| 2019-11-13 | CT | Futures | 63.08 | 63.12 | 62.42 | 62.51 | 18788.0 |
| 2019-11-13 | DC | Futures | 27.99 | 28.49 | 27.86 | 28.2 | 637.0 |
| 2019-11-13 | DX | Futures | 94.898 | 95.01 | 94.855 | 94.942 | 10001.0 |
| 2019-11-13 | E1 | Futures | 1.16082 | 1.16646 | 1.16082 | 1.16542 | 31788.0 |
| 2019-11-13 | E6 | Futures | 1.19589 | 1.19691 | 1.19421 | 1.19491 | 150184.0 |
| 2019-11-13 | E7 | Futures | 1.1897 | 1.1907 | 1.188 | 1.1888 | 2731.0 |
| 2019-11-13 | EBM | Futures | 195.09 | 195.36 | 194.27 | 194.27 | 14765.0 |
| 2019-11-13 | ED | Futures | 95.318 | 95.3229 | 95.3083 | 95.318 | 212547.0 |
| 2019-11-13 | ER | Futures | 98.391 | 98.396 | 98.386 | 98.391 | 87452.0 |
| 2019-11-13 | EW | Futures | 2092.1 | 2092.6 | 2076.5 | 2087.2 | 12370.0 |
| 2019-11-13 | FBON | Futures | 143.02 | 143.34 | 142.7 | 142.94 | 618.0 |
| 2019-11-13 | FBTP | Futures | 128.75 | 128.93 | 128.4 | 128.64 | 118882.0 |
| 2019-11-13 | FBTS | Futures | 108.095 | 108.134 | 107.989 | 108.057 | 51476.0 |
| 2019-11-13 | FCE | Futures | 5338.9 | 5346.6 | 5307.7 | 5338.5 | 143878.0 |
| 2019-11-13 | FDAX | Futures | 13979.2 | 13999.3 | 13855.8 | 13954.4 | 96551.0 |
| 2019-11-13 | FDIV | Futures | 162.33 | 162.33 | 161.4 | 162.28 | 71.0 |
| 2019-11-13 | FDXM | Futures | 13794.1 | 13816.0 | 13674.3 | 13772.2 | 37548.0 |
| 2019-11-13 | FESX | Futures | 3242.1 | 3247.4 | 3221.1 | 3238.6 | 1054894.0 |
| 2019-11-13 | FGBL | Futures | 163.98 | 164.66 | 163.9 | 164.57 | 704537.0 |
| 2019-11-13 | FGBM | Futures | 133.61 | 133.77 | 133.59 | 133.74 | 426236.0 |
| 2019-11-13 | FGBS | Futures | 112.684 | 112.704 | 112.674 | 112.694 | 297314.0 |
| 2019-11-13 | FGBX | Futures | 210.96 | 213.72 | 210.81 | 213.3 | 52931.0 |
| 2019-11-13 | FMWO | Futures | 7542.8 | 7562.1 | 7513.2 | 7549.6 | 5418.0 |
| 2019-11-13 | FOAT | Futures | 151.56 | 152.05 | 151.47 | 151.95 | 129965.0 |
| 2019-11-13 | FTDX | Futures | 2900.1 | 2932.7 | 2882.4 | 2922.3 | 91.0 |
| 2019-11-13 | FTI | Futures | 570.57 | 571.81 | 568.27 | 570.93 | 40393.0 |
| 2019-11-13 | FTUK | Futures | 6789.8 | 6806.5 | 6747.2 | 6797.2 | 89318.0 |
| 2019-11-13 | FVSA | Futures | 145.45 | 149.0 | 142.92 | 143.93 | 22937.0 |
| 2019-11-13 | FXXP | Futures | 366.4 | 367.3 | 364.5 | 366.8 | 56111.0 |
| 2019-11-13 | G | Futures | 119.92 | 120.59 | 119.92 | 120.4 | 158007.0 |
| 2019-11-13 | GF | Futures | 309.495 | 310.022 | 300.437 | 300.859 | 9892.0 |
> showing 50 of 120 rows — these rows as CSV