PREVIEW / futures_daily / 2021-05-17
file: by_date/futures_daily/2021/2021-05-17.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 |
|---|---|---|---|---|---|---|---|
| 2021-05-17 | ES | Futures | 4678.26 | 4689.2 | 4641.79 | 4665.64 | 1480730.0 |
| 2021-05-17 | NQ | Futures | 15433.04 | 15511.76 | 15205.24 | 15344.51 | 488299.0 |
| 2021-05-17 | YM | Futures | 37145.8 | 37204.2 | 36900.1 | 37076.5 | 151437.0 |
| 2021-05-17 | CL | Futures | 46.58 | 47.28 | 46.14 | 47.18 | 229561.0 |
| 2021-05-17 | GC | Futures | 2164.0 | 2191.5 | 2158.4 | 2189.5 | 267705.0 |
| 2021-05-17 | ZN | Futures | 133.096877 | 133.348151 | 132.924126 | 133.018354 | 1189252.0 |
| 2021-05-17 | A6 | Futures | 0.79736 | 0.79818 | 0.79269 | 0.79684 | 70795.0 |
| 2021-05-17 | AD | Futures | 0.83689 | 0.84008 | 0.83481 | 0.84003 | 53097.0 |
| 2021-05-17 | ALI | Futures | 2829.46 | 2861.02 | 2826.64 | 2854.26 | 415.0 |
| 2021-05-17 | B | Futures | 45.08 | 45.53 | 44.59 | 45.43 | 230775.0 |
| 2021-05-17 | B6 | Futures | 1.4317 | 1.4366 | 1.4294 | 1.4363 | 67331.0 |
| 2021-05-17 | BR | Futures | 0.14914 | 0.15068 | 0.14858 | 0.15032 | 7493.0 |
| 2021-05-17 | BTC | Futures | 62552.5 | 64382.4 | 58071.2 | 60847.0 | 11148.0 |
| 2021-05-17 | BZ | Futures | 43.95 | 44.44 | 43.53 | 44.34 | 26662.0 |
| 2021-05-17 | C | Futures | 1534.0 | 1562.0 | 1530.0 | 1550.0 | 7423.0 |
| 2021-05-17 | CB | Futures | 153.122 | 153.122 | 151.45 | 152.544 | 26.0 |
| 2021-05-17 | CC | Futures | 1650.0 | 1700.0 | 1650.0 | 1691.0 | 19568.0 |
| 2021-05-17 | CNH | Futures | 6.2588 | 6.2615 | 6.2532 | 6.2532 | 446.0 |
| 2021-05-17 | CSC | Futures | 2.966 | 2.976 | 2.875 | 2.888 | 189.0 |
| 2021-05-17 | CT | Futures | 77.11 | 77.92 | 76.46 | 76.76 | 16939.0 |
| 2021-05-17 | DC | Futures | 27.39 | 27.46 | 26.65 | 26.7 | 431.0 |
| 2021-05-17 | DX | Futures | 87.306 | 87.374 | 87.093 | 87.11 | 17800.0 |
| 2021-05-17 | E1 | Futures | 1.24906 | 1.25108 | 1.2467 | 1.24816 | 15099.0 |
| 2021-05-17 | E6 | Futures | 1.29498 | 1.29737 | 1.29285 | 1.29631 | 124821.0 |
| 2021-05-17 | E7 | Futures | 1.2884 | 1.2909 | 1.2863 | 1.2898 | 3501.0 |
| 2021-05-17 | EBM | Futures | 315.18 | 320.33 | 314.08 | 315.55 | 16378.0 |
| 2021-05-17 | ED | Futures | 96.5149 | 96.527 | 96.5149 | 96.5246 | 176564.0 |
| 2021-05-17 | ER | Futures | 98.46 | 98.46 | 98.455 | 98.455 | 17294.0 |
| 2021-05-17 | ESG | Futures | 386.62 | 386.77 | 384.09 | 385.79 | 603.0 |
| 2021-05-17 | EW | Futures | 2913.5 | 2914.9 | 2875.0 | 2905.9 | 8818.0 |
| 2021-05-17 | FBON | Futures | 145.51 | 145.9 | 145.06 | 145.31 | 942.0 |
| 2021-05-17 | FBTP | Futures | 135.59 | 135.73 | 134.72 | 135.02 | 185414.0 |
| 2021-05-17 | FBTS | Futures | 109.806 | 109.874 | 109.757 | 109.796 | 84978.0 |
| 2021-05-17 | FCE | Futures | 6346.5 | 6360.5 | 6297.2 | 6317.1 | 15513.0 |
| 2021-05-17 | FDAX | Futures | 16451.3 | 16501.4 | 16359.7 | 16418.3 | 49570.0 |
| 2021-05-17 | FDIV | Futures | 187.4 | 187.45 | 187.35 | 187.45 | 55.0 |
| 2021-05-17 | FDXM | Futures | 16426.0 | 16481.4 | 16339.8 | 16398.3 | 40073.0 |
| 2021-05-17 | FDXS | Futures | 16352.2 | 16392.4 | 16253.7 | 16310.9 | 1907.0 |
| 2021-05-17 | FESX | Futures | 3799.8 | 3804.5 | 3765.8 | 3780.9 | 630610.0 |
| 2021-05-17 | FGBL | Futures | 165.36 | 165.58 | 164.91 | 165.1 | 779783.0 |
| 2021-05-17 | FGBM | Futures | 134.17 | 134.25 | 134.03 | 134.12 | 452103.0 |
| 2021-05-17 | FGBS | Futures | 112.564 | 112.584 | 112.554 | 112.569 | 249393.0 |
| 2021-05-17 | FGBX | Futures | 211.29 | 212.1 | 210.02 | 210.57 | 77832.0 |
| 2021-05-17 | FMWO | Futures | 10338.1 | 10347.5 | 10292.3 | 10301.7 | 3457.0 |
| 2021-05-17 | FOAT | Futures | 153.22 | 153.48 | 152.67 | 152.83 | 210652.0 |
| 2021-05-17 | FTDX | Futures | 3424.7 | 3453.0 | 3418.6 | 3427.3 | 445.0 |
| 2021-05-17 | FTI | Futures | 669.74 | 670.36 | 664.38 | 667.72 | 2158.0 |
| 2021-05-17 | FTUK | Futures | 6860.6 | 6869.4 | 6784.2 | 6832.9 | 80420.0 |
| 2021-05-17 | FVSA | Futures | 106.77 | 115.36 | 105.47 | 112.5 | 41941.0 |
| 2021-05-17 | FXXP | Futures | 419.5 | 420.2 | 416.4 | 418.3 | 34147.0 |
> showing 50 of 122 rows — these rows as CSV