PREVIEW / futures_daily / 2019-02-13
file: by_date/futures_daily/2019/2019-02-13.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-02-13 | ES | Futures | 2970.3 | 2990.33 | 2969.49 | 2976.8 | 1209879.0 |
| 2019-02-13 | NQ | Futures | 8124.25 | 8185.03 | 8118.17 | 8123.09 | 359971.0 |
| 2019-02-13 | YM | Futures | 26786.9 | 27008.4 | 26775.3 | 26884.0 | 170326.0 |
| 2019-02-13 | CL | Futures | 55.52 | 56.83 | 55.46 | 56.14 | 307069.0 |
| 2019-02-13 | GC | Futures | 1642.9 | 1652.1 | 1635.1 | 1643.9 | 213962.0 |
| 2019-02-13 | ZN | Futures | 121.440361 | 121.487045 | 121.160258 | 121.253626 | 1308329.0 |
| 2019-02-13 | A6 | Futures | 0.73136 | 0.73549 | 0.73044 | 0.73136 | 102329.0 |
| 2019-02-13 | AD | Futures | 0.76557 | 0.76779 | 0.7641 | 0.76471 | 61760.0 |
| 2019-02-13 | B | Futures | 45.46 | 46.39 | 45.45 | 46.12 | 269676.0 |
| 2019-02-13 | B6 | Futures | 1.3258 | 1.3328 | 1.3209 | 1.3217 | 122244.0 |
| 2019-02-13 | BFX | Futures | 4048.4 | 4053.0 | 4048.4 | 4053.0 | 53.0 |
| 2019-02-13 | BR | Futures | 0.21476 | 0.21512 | 0.21181 | 0.21241 | 2285.0 |
| 2019-02-13 | BTC | Futures | 5271.2 | 5352.3 | 5241.7 | 5263.8 | 2811.0 |
| 2019-02-13 | BZ | Futures | 44.95 | 45.89 | 44.95 | 45.63 | 33859.0 |
| 2019-02-13 | C | Futures | 1494.0 | 1503.0 | 1482.0 | 1500.0 | 4028.0 |
| 2019-02-13 | CB | Futures | 275.174 | 275.174 | 273.595 | 273.686 | 6.0 |
| 2019-02-13 | CC | Futures | 1529.0 | 1559.0 | 1516.0 | 1544.0 | 26468.0 |
| 2019-02-13 | CNH | Futures | 6.7789 | 6.7901 | 6.7663 | 6.7901 | 2728.0 |
| 2019-02-13 | CSC | Futures | 2.819 | 2.845 | 2.806 | 2.806 | 155.0 |
| 2019-02-13 | CT | Futures | 76.09 | 76.93 | 75.87 | 76.1 | 20329.0 |
| 2019-02-13 | DC | Futures | 23.88 | 24.04 | 23.67 | 23.7 | 450.0 |
| 2019-02-13 | DX | Futures | 92.061 | 92.504 | 91.975 | 92.45 | 18222.0 |
| 2019-02-13 | E1 | Futures | 1.17207 | 1.17419 | 1.16843 | 1.1689 | 14940.0 |
| 2019-02-13 | E6 | Futures | 1.25514 | 1.25657 | 1.24757 | 1.24867 | 173988.0 |
| 2019-02-13 | E7 | Futures | 1.2491 | 1.2505 | 1.2415 | 1.2426 | 4235.0 |
| 2019-02-13 | EBM | Futures | 207.17 | 207.94 | 206.66 | 206.91 | 21111.0 |
| 2019-02-13 | ED | Futures | 95.0672 | 95.0721 | 95.0574 | 95.0623 | 227008.0 |
| 2019-02-13 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.401 | 33214.0 |
| 2019-02-13 | EW | Futures | 2006.8 | 2020.6 | 2005.4 | 2016.5 | 13484.0 |
| 2019-02-13 | FBON | Futures | 131.81 | 131.98 | 131.59 | 131.77 | 732.0 |
| 2019-02-13 | FBTP | Futures | 111.19 | 111.77 | 110.95 | 111.65 | 89298.0 |
| 2019-02-13 | FBTS | Futures | 104.878 | 105.029 | 104.793 | 104.991 | 55990.0 |
| 2019-02-13 | FCE | Futures | 4524.2 | 4540.2 | 4512.1 | 4523.7 | 102138.0 |
| 2019-02-13 | FDAX | Futures | 11717.0 | 11788.5 | 11683.4 | 11741.2 | 95967.0 |
| 2019-02-13 | FDIV | Futures | 137.64 | 137.91 | 137.64 | 137.91 | 13.0 |
| 2019-02-13 | FDXM | Futures | 11692.7 | 11758.7 | 11654.9 | 11712.6 | 42754.0 |
| 2019-02-13 | FESX | Futures | 2732.1 | 2744.0 | 2724.4 | 2737.2 | 912165.0 |
| 2019-02-13 | FGBL | Futures | 157.83 | 158.06 | 157.7 | 157.95 | 531264.0 |
| 2019-02-13 | FGBM | Futures | 132.45 | 132.52 | 132.39 | 132.46 | 306112.0 |
| 2019-02-13 | FGBS | Futures | 112.678 | 112.683 | 112.653 | 112.658 | 328690.0 |
| 2019-02-13 | FGBX | Futures | 188.28 | 189.05 | 187.98 | 188.77 | 39236.0 |
| 2019-02-13 | FMWO | Futures | 6900.2 | 6914.1 | 6883.9 | 6895.5 | 1976.0 |
| 2019-02-13 | FOAT | Futures | 143.06 | 143.42 | 143.06 | 143.31 | 106049.0 |
| 2019-02-13 | FTDX | Futures | 2538.4 | 2549.8 | 2526.9 | 2536.9 | 227.0 |
| 2019-02-13 | FTI | Futures | 503.12 | 503.96 | 500.44 | 501.98 | 28006.0 |
| 2019-02-13 | FTUK | Futures | 6463.9 | 6505.3 | 6449.8 | 6492.1 | 101836.0 |
| 2019-02-13 | FVSA | Futures | 275.25 | 279.62 | 272.63 | 275.25 | 30146.0 |
| 2019-02-13 | FXXP | Futures | 318.5 | 320.2 | 318.0 | 319.5 | 38285.0 |
| 2019-02-13 | G | Futures | 117.48 | 117.74 | 117.32 | 117.49 | 181636.0 |
| 2019-02-13 | GF | Futures | 315.181 | 315.454 | 313.595 | 313.869 | 6328.0 |
> showing 50 of 116 rows — these rows as CSV