PREVIEW / futures_daily / 2020-11-13
file: by_date/futures_daily/2020/2020-11-13.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-13 | ES | Futures | 3974.31 | 4033.3 | 3952.41 | 4024.31 | 1334530.0 |
| 2020-11-13 | NQ | Futures | 13726.96 | 13837.81 | 13662.99 | 13815.52 | 445512.0 |
| 2020-11-13 | YM | Futures | 31285.4 | 31740.8 | 31067.9 | 31662.2 | 156897.0 |
| 2020-11-13 | CL | Futures | 29.31 | 29.31 | 28.69 | 28.74 | 201433.0 |
| 2020-11-13 | GC | Futures | 2215.1 | 2239.0 | 2211.0 | 2227.6 | 162538.0 |
| 2020-11-13 | ZN | Futures | 137.071433 | 137.19541 | 136.916463 | 136.978451 | 993902.0 |
| 2020-11-13 | A6 | Futures | 0.74251 | 0.74683 | 0.74149 | 0.7459 | 57571.0 |
| 2020-11-13 | AD | Futures | 0.77098 | 0.77271 | 0.76936 | 0.77149 | 51285.0 |
| 2020-11-13 | ALI | Futures | 2301.71 | 2315.33 | 2296.97 | 2298.45 | 98.0 |
| 2020-11-13 | B | Futures | 27.22 | 27.31 | 26.86 | 26.95 | 216736.0 |
| 2020-11-13 | B6 | Futures | 1.3305 | 1.3389 | 1.3296 | 1.3363 | 67757.0 |
| 2020-11-13 | BR | Futures | 0.14443 | 0.14549 | 0.14226 | 0.14348 | 7128.0 |
| 2020-11-13 | BTC | Futures | 21577.5 | 21887.7 | 21148.6 | 21472.0 | 4062.0 |
| 2020-11-13 | BZ | Futures | 26.73 | 26.73 | 26.29 | 26.39 | 34737.0 |
| 2020-11-13 | C | Futures | 1407.0 | 1421.0 | 1401.0 | 1415.0 | 2948.0 |
| 2020-11-13 | CB | Futures | 154.034 | 154.034 | 151.951 | 152.205 | 27.0 |
| 2020-11-13 | CC | Futures | 1537.0 | 1574.0 | 1533.0 | 1554.0 | 19108.0 |
| 2020-11-13 | CNH | Futures | 6.4881 | 6.5012 | 6.4743 | 6.4744 | 564.0 |
| 2020-11-13 | CSC | Futures | 3.518 | 3.518 | 3.426 | 3.426 | 251.0 |
| 2020-11-13 | CT | Futures | 67.65 | 67.96 | 67.42 | 67.66 | 17211.0 |
| 2020-11-13 | DC | Futures | 29.05 | 29.27 | 28.21 | 28.21 | 621.0 |
| 2020-11-13 | DX | Futures | 89.796 | 89.839 | 89.545 | 89.593 | 14297.0 |
| 2020-11-13 | E1 | Futures | 1.23877 | 1.24182 | 1.2373 | 1.24081 | 12631.0 |
| 2020-11-13 | E6 | Futures | 1.26547 | 1.26889 | 1.26472 | 1.26836 | 87448.0 |
| 2020-11-13 | E7 | Futures | 1.2592 | 1.2624 | 1.2583 | 1.2619 | 4823.0 |
| 2020-11-13 | EBM | Futures | 252.56 | 253.46 | 251.65 | 253.16 | 18576.0 |
| 2020-11-13 | ED | Futures | 96.489 | 96.489 | 96.4842 | 96.4842 | 56684.0 |
| 2020-11-13 | ER | Futures | 98.45 | 98.455 | 98.445 | 98.45 | 41518.0 |
| 2020-11-13 | ESG | Futures | 330.78 | 332.95 | 329.39 | 332.23 | 542.0 |
| 2020-11-13 | EW | Futures | 2213.3 | 2261.3 | 2195.6 | 2257.6 | 10948.0 |
| 2020-11-13 | FBON | Futures | 149.84 | 150.11 | 149.68 | 149.88 | 340.0 |
| 2020-11-13 | FBTP | Futures | 137.77 | 138.12 | 137.73 | 137.96 | 82786.0 |
| 2020-11-13 | FBTS | Futures | 109.923 | 109.971 | 109.913 | 109.942 | 76199.0 |
| 2020-11-13 | FCE | Futures | 5206.1 | 5265.6 | 5196.4 | 5239.3 | 1014.0 |
| 2020-11-13 | FDAX | Futures | 13862.4 | 14003.6 | 13776.0 | 13958.9 | 64034.0 |
| 2020-11-13 | FDXM | Futures | 13785.0 | 13933.5 | 13711.8 | 13888.5 | 46262.0 |
| 2020-11-13 | FESX | Futures | 3150.7 | 3192.3 | 3135.9 | 3178.4 | 875942.0 |
| 2020-11-13 | FGBL | Futures | 170.1 | 170.35 | 169.98 | 170.13 | 512816.0 |
| 2020-11-13 | FGBM | Futures | 135.28 | 135.32 | 135.22 | 135.25 | 321160.0 |
| 2020-11-13 | FGBS | Futures | 112.79 | 112.805 | 112.775 | 112.785 | 212839.0 |
| 2020-11-13 | FGBX | Futures | 234.16 | 235.31 | 233.47 | 234.29 | 54717.0 |
| 2020-11-13 | FMWO | Futures | 8806.2 | 8932.9 | 8789.6 | 8883.2 | 6026.0 |
| 2020-11-13 | FOAT | Futures | 158.56 | 158.87 | 158.5 | 158.65 | 120654.0 |
| 2020-11-13 | FTDX | Futures | 3111.1 | 3132.7 | 3102.3 | 3124.9 | 138.0 |
| 2020-11-13 | FTI | Futures | 558.82 | 562.0 | 557.23 | 557.53 | 901.0 |
| 2020-11-13 | FTUK | Futures | 5987.4 | 6058.1 | 5970.2 | 6034.2 | 102249.0 |
| 2020-11-13 | FVSA | Futures | 170.96 | 172.07 | 158.01 | 162.45 | 12604.0 |
| 2020-11-13 | FXXP | Futures | 354.7 | 358.5 | 353.8 | 357.1 | 55613.0 |
| 2020-11-13 | G | Futures | 125.63 | 125.78 | 125.42 | 125.58 | 186146.0 |
| 2020-11-13 | GF | Futures | 273.418 | 273.809 | 268.588 | 269.076 | 5159.0 |
> showing 50 of 119 rows — these rows as CSV