PREVIEW / futures_daily / 2020-05-04
file: by_date/futures_daily/2020/2020-05-04.parquet size: 10 KB rows: 122
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-05-04 | ES | Futures | 3085.99 | 3137.72 | 3066.07 | 3126.1 | 1510680.0 |
| 2020-05-04 | NQ | Futures | 9886.9 | 10120.77 | 9809.23 | 10083.51 | 381914.0 |
| 2020-05-04 | YM | Futures | 24930.6 | 25244.3 | 24764.2 | 25151.5 | 157510.0 |
| 2020-05-04 | CL | Futures | 14.23 | 15.95 | 13.44 | 15.18 | 311488.0 |
| 2020-05-04 | GC | Futures | 2075.2 | 2093.2 | 2062.0 | 2077.8 | 148728.0 |
| 2020-05-04 | ZN | Futures | 137.423354 | 137.546839 | 137.114642 | 137.284433 | 916799.0 |
| 2020-05-04 | A6 | Futures | 0.65823 | 0.66121 | 0.65473 | 0.66018 | 73867.0 |
| 2020-05-04 | AD | Futures | 0.71989 | 0.7212 | 0.71598 | 0.71984 | 45399.0 |
| 2020-05-04 | ALI | Futures | 1794.34 | 1799.12 | 1792.55 | 1796.13 | 73.0 |
| 2020-05-04 | B | Futures | 17.24 | 18.54 | 16.84 | 17.96 | 215728.0 |
| 2020-05-04 | B6 | Futures | 1.2674 | 1.2677 | 1.2594 | 1.263 | 61699.0 |
| 2020-05-04 | BFX | Futures | 2922.8 | 2922.8 | 2922.8 | 2922.8 | 12.0 |
| 2020-05-04 | BR | Futures | 0.14698 | 0.14817 | 0.14558 | 0.14735 | 4021.0 |
| 2020-05-04 | BTC | Futures | 12468.8 | 12600.9 | 11961.1 | 12427.1 | 3992.0 |
| 2020-05-04 | BZ | Futures | 16.76 | 17.95 | 16.29 | 17.39 | 30309.0 |
| 2020-05-04 | C | Futures | 1818.0 | 1845.0 | 1809.0 | 1843.0 | 9088.0 |
| 2020-05-04 | CB | Futures | 141.618 | 143.961 | 140.531 | 141.618 | 11.0 |
| 2020-05-04 | CC | Futures | 1561.0 | 1568.0 | 1530.0 | 1560.0 | 13528.0 |
| 2020-05-04 | CNH | Futures | 7.0811 | 7.0897 | 7.0623 | 7.0693 | 389.0 |
| 2020-05-04 | CSC | Futures | 2.409 | 2.521 | 2.391 | 2.521 | 123.0 |
| 2020-05-04 | CT | Futures | 54.26 | 54.39 | 52.49 | 52.96 | 11743.0 |
| 2020-05-04 | DC | Futures | 19.4 | 20.58 | 19.2 | 20.58 | 564.0 |
| 2020-05-04 | DX | Futures | 95.827 | 96.364 | 95.818 | 96.279 | 14588.0 |
| 2020-05-04 | E1 | Futures | 1.18522 | 1.18567 | 1.17987 | 1.18089 | 16800.0 |
| 2020-05-04 | E6 | Futures | 1.18026 | 1.18052 | 1.17187 | 1.17311 | 107609.0 |
| 2020-05-04 | E7 | Futures | 1.1742 | 1.1742 | 1.1658 | 1.167 | 5053.0 |
| 2020-05-04 | EBM | Futures | 218.37 | 220.89 | 218.37 | 220.05 | 9779.0 |
| 2020-05-04 | ED | Futures | 96.3339 | 96.3484 | 96.3243 | 96.3388 | 211072.0 |
| 2020-05-04 | ER | Futures | 98.333 | 98.367 | 98.323 | 98.333 | 56023.0 |
| 2020-05-04 | ESG | Futures | 252.34 | 255.97 | 252.34 | 255.97 | 1863.0 |
| 2020-05-04 | EW | Futures | 1653.7 | 1684.1 | 1638.4 | 1682.5 | 8051.0 |
| 2020-05-04 | FBON | Futures | 140.83 | 140.83 | 139.7 | 140.1 | 290.0 |
| 2020-05-04 | FBTP | Futures | 123.87 | 124.12 | 122.77 | 124.01 | 72182.0 |
| 2020-05-04 | FBTS | Futures | 107.172 | 107.172 | 106.989 | 107.104 | 56363.0 |
| 2020-05-04 | FCE | Futures | 4238.1 | 4278.3 | 4211.9 | 4227.4 | 51331.0 |
| 2020-05-04 | FDAX | Futures | 11047.1 | 11223.7 | 10965.1 | 11082.0 | 91857.0 |
| 2020-05-04 | FDIV | Futures | 118.49 | 119.69 | 118.3 | 118.3 | 200.0 |
| 2020-05-04 | FDXM | Futures | 11113.7 | 11276.3 | 11006.3 | 11134.9 | 65186.0 |
| 2020-05-04 | FESX | Futures | 2558.9 | 2587.4 | 2535.0 | 2557.1 | 1319380.0 |
| 2020-05-04 | FEU3 | Futures | 99.085 | 99.085 | 99.065 | 99.07 | 4.0 |
| 2020-05-04 | FGBL | Futures | 169.49 | 169.81 | 168.91 | 169.17 | 498085.0 |
| 2020-05-04 | FGBM | Futures | 135.57 | 135.65 | 135.09 | 135.2 | 339554.0 |
| 2020-05-04 | FGBS | Futures | 113.046 | 113.097 | 112.951 | 112.976 | 315214.0 |
| 2020-05-04 | FGBX | Futures | 232.76 | 234.54 | 229.3 | 229.9 | 50117.0 |
| 2020-05-04 | FMWO | Futures | 7057.4 | 7057.4 | 6824.5 | 6868.0 | 8408.0 |
| 2020-05-04 | FOAT | Futures | 153.93 | 153.96 | 153.01 | 153.34 | 114572.0 |
| 2020-05-04 | FTDX | Futures | 2782.8 | 2827.8 | 2782.8 | 2824.8 | 105.0 |
| 2020-05-04 | FTI | Futures | 462.4 | 469.85 | 458.88 | 464.13 | 30650.0 |
| 2020-05-04 | FTUK | Futures | 5343.3 | 5465.4 | 5323.5 | 5407.0 | 121191.0 |
| 2020-05-04 | FVSA | Futures | 333.07 | 341.17 | 320.02 | 332.17 | 11993.0 |
> showing 50 of 122 rows — these rows as CSV