PREVIEW / futures_daily / 2019-03-04
file: by_date/futures_daily/2019/2019-03-04.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-03-04 | ES | Futures | 3046.63 | 3052.86 | 2996.29 | 3022.27 | 1791972.0 |
| 2019-03-04 | NQ | Futures | 8309.2 | 8349.14 | 8190.53 | 8273.02 | 556660.0 |
| 2019-03-04 | YM | Futures | 27536.9 | 27604.4 | 27007.4 | 27227.8 | 293705.0 |
| 2019-03-04 | CL | Futures | 57.71 | 58.92 | 57.69 | 58.5 | 549396.0 |
| 2019-03-04 | GC | Futures | 1618.0 | 1622.6 | 1604.7 | 1609.4 | 268391.0 |
| 2019-03-04 | ZN | Futures | 120.864593 | 121.222503 | 120.817909 | 121.175819 | 60189.0 |
| 2019-03-04 | A6 | Futures | 0.73136 | 0.7325 | 0.7291 | 0.73023 | 76070.0 |
| 2019-03-04 | AD | Futures | 0.76243 | 0.76283 | 0.75924 | 0.76061 | 63627.0 |
| 2019-03-04 | B | Futures | 47.12 | 48.12 | 47.1 | 47.63 | 233538.0 |
| 2019-03-04 | B6 | Futures | 1.3598 | 1.3619 | 1.3529 | 1.3533 | 80836.0 |
| 2019-03-04 | BR | Futures | 0.21049 | 0.21065 | 0.21049 | 0.21065 | 1.0 |
| 2019-03-04 | BTC | Futures | 5811.1 | 5834.2 | 5626.7 | 5672.8 | 4577.0 |
| 2019-03-04 | BZ | Futures | 46.78 | 47.74 | 46.78 | 47.25 | 28931.0 |
| 2019-03-04 | C | Futures | 1477.0 | 1477.0 | 1447.0 | 1449.0 | 5919.0 |
| 2019-03-04 | CB | Futures | 277.527 | 278.095 | 277.527 | 278.095 | 9.0 |
| 2019-03-04 | CC | Futures | 1490.0 | 1496.0 | 1450.0 | 1455.0 | 25759.0 |
| 2019-03-04 | CNH | Futures | 6.709 | 6.7232 | 6.6984 | 6.7203 | 1002.0 |
| 2019-03-04 | CSC | Futures | 2.799 | 2.803 | 2.784 | 2.785 | 28.0 |
| 2019-03-04 | CT | Futures | 78.72 | 79.24 | 77.6 | 77.64 | 15042.0 |
| 2019-03-04 | DC | Futures | 23.77 | 23.8 | 23.66 | 23.68 | 35.0 |
| 2019-03-04 | DX | Futures | 91.836 | 92.266 | 91.798 | 92.137 | 16208.0 |
| 2019-03-04 | E1 | Futures | 1.17901 | 1.17901 | 1.1749 | 1.17772 | 18084.0 |
| 2019-03-04 | E6 | Futures | 1.25829 | 1.25889 | 1.25088 | 1.25337 | 156233.0 |
| 2019-03-04 | E7 | Futures | 1.2523 | 1.2527 | 1.2449 | 1.2473 | 3056.0 |
| 2019-03-04 | EBM | Futures | 197.66 | 198.43 | 197.15 | 197.66 | 4707.0 |
| 2019-03-04 | ED | Futures | 95.1136 | 95.1136 | 95.0989 | 95.1013 | 205403.0 |
| 2019-03-04 | ER | Futures | 98.411 | 98.411 | 98.406 | 98.411 | 12092.0 |
| 2019-03-04 | EW | Futures | 2055.3 | 2060.5 | 2022.2 | 2039.6 | 17370.0 |
| 2019-03-04 | FBON | Futures | 132.43 | 132.76 | 132.29 | 132.59 | 2739.0 |
| 2019-03-04 | FBTP | Futures | 112.51 | 112.51 | 111.77 | 112.34 | 264117.0 |
| 2019-03-04 | FBTS | Futures | 105.455 | 105.455 | 105.285 | 105.417 | 152817.0 |
| 2019-03-04 | FCE | Futures | 4721.8 | 4736.5 | 4690.1 | 4714.2 | 65620.0 |
| 2019-03-04 | FDAX | Futures | 12261.4 | 12272.4 | 12108.5 | 12187.8 | 110711.0 |
| 2019-03-04 | FDXM | Futures | 12218.9 | 12243.0 | 12078.4 | 12158.1 | 47893.0 |
| 2019-03-04 | FESX | Futures | 2844.0 | 2848.3 | 2818.4 | 2832.9 | 993207.0 |
| 2019-03-04 | FGBL | Futures | 157.06 | 157.56 | 156.89 | 157.44 | 1380979.0 |
| 2019-03-04 | FGBM | Futures | 132.04 | 132.19 | 131.99 | 132.15 | 1407241.0 |
| 2019-03-04 | FGBS | Futures | 112.567 | 112.598 | 112.562 | 112.582 | 994505.0 |
| 2019-03-04 | FGBX | Futures | 185.95 | 187.23 | 185.79 | 186.82 | 169087.0 |
| 2019-03-04 | FMWO | Futures | 7076.1 | 7077.3 | 6979.4 | 7024.9 | 1874.0 |
| 2019-03-04 | FOAT | Futures | 142.97 | 143.42 | 142.97 | 143.3 | 419876.0 |
| 2019-03-04 | FTDX | Futures | 2640.7 | 2645.7 | 2630.3 | 2632.8 | 141.0 |
| 2019-03-04 | FTI | Futures | 508.47 | 509.69 | 505.04 | 507.7 | 19911.0 |
| 2019-03-04 | FTUK | Futures | 6488.0 | 6515.8 | 6449.8 | 6484.4 | 102302.0 |
| 2019-03-04 | FVSA | Futures | 246.41 | 263.02 | 243.79 | 252.53 | 24486.0 |
| 2019-03-04 | FXXP | Futures | 330.1 | 330.3 | 327.4 | 329.3 | 37876.0 |
| 2019-03-04 | G | Futures | 116.08 | 116.37 | 115.85 | 116.23 | 160122.0 |
| 2019-03-04 | GF | Futures | 309.386 | 309.987 | 307.636 | 308.784 | 3136.0 |
| 2019-03-04 | GSCI | Futures | 486.93 | 486.93 | 482.58 | 483.27 | 61.0 |
| 2019-03-04 | HE | Futures | 64.892 | 65.372 | 64.269 | 64.835 | 21653.0 |
> showing 50 of 115 rows — these rows as CSV