PREVIEW / futures_daily / 2020-08-26
file: by_date/futures_daily/2020/2020-08-26.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-08-26 | ES | Futures | 3877.37 | 3920.98 | 3868.36 | 3917.32 | 1277539.0 |
| 2020-08-26 | NQ | Futures | 13625.33 | 13929.41 | 13610.53 | 13917.52 | 578801.0 |
| 2020-08-26 | YM | Futures | 30237.8 | 30370.7 | 30109.2 | 30341.7 | 144026.0 |
| 2020-08-26 | CL | Futures | 31.38 | 31.66 | 31.1 | 31.38 | 262243.0 |
| 2020-08-26 | GC | Futures | 2290.0 | 2318.8 | 2253.8 | 2305.9 | 342207.0 |
| 2020-08-26 | ZN | Futures | 138.016705 | 138.094129 | 137.768947 | 138.063159 | 2944270.0 |
| 2020-08-26 | A6 | Futures | 0.74003 | 0.74487 | 0.73942 | 0.74343 | 57539.0 |
| 2020-08-26 | AD | Futures | 0.77058 | 0.77301 | 0.7687 | 0.77154 | 52547.0 |
| 2020-08-26 | ALI | Futures | 2123.94 | 2138.83 | 2122.45 | 2122.75 | 499.0 |
| 2020-08-26 | B | Futures | 29.58 | 29.67 | 29.34 | 29.42 | 237882.0 |
| 2020-08-26 | B6 | Futures | 1.3349 | 1.3425 | 1.3321 | 1.3396 | 82393.0 |
| 2020-08-26 | BR | Futures | 0.14097 | 0.14097 | 0.13967 | 0.13967 | 729.0 |
| 2020-08-26 | BTC | Futures | 15412.2 | 15817.3 | 15385.2 | 15702.5 | 2732.0 |
| 2020-08-26 | BZ | Futures | 28.93 | 29.02 | 28.7 | 28.79 | 18235.0 |
| 2020-08-26 | C | Futures | 1540.0 | 1551.0 | 1499.0 | 1504.0 | 2690.0 |
| 2020-08-26 | CB | Futures | 175.2 | 175.226 | 174.057 | 174.311 | 31.0 |
| 2020-08-26 | CC | Futures | 1642.0 | 1648.0 | 1610.0 | 1626.0 | 11295.0 |
| 2020-08-26 | CNH | Futures | 6.8081 | 6.8081 | 6.7845 | 6.7881 | 552.0 |
| 2020-08-26 | CSC | Futures | 3.397 | 3.401 | 3.361 | 3.361 | 30.0 |
| 2020-08-26 | DC | Futures | 27.71 | 27.71 | 27.0 | 27.19 | 263.0 |
| 2020-08-26 | DX | Futures | 89.851 | 90.194 | 89.672 | 89.828 | 18757.0 |
| 2020-08-26 | E1 | Futures | 1.25215 | 1.25249 | 1.24579 | 1.25045 | 17570.0 |
| 2020-08-26 | E6 | Futures | 1.27035 | 1.27099 | 1.26364 | 1.26825 | 164948.0 |
| 2020-08-26 | E7 | Futures | 1.2641 | 1.2645 | 1.2574 | 1.262 | 7870.0 |
| 2020-08-26 | EBM | Futures | 223.65 | 223.65 | 221.55 | 222.75 | 2895.0 |
| 2020-08-26 | ED | Futures | 96.4427 | 96.4451 | 96.4354 | 96.4427 | 171480.0 |
| 2020-08-26 | ER | Futures | 98.406 | 98.406 | 98.396 | 98.401 | 59562.0 |
| 2020-08-26 | ESG | Futures | 316.0 | 318.03 | 316.0 | 318.03 | 30.0 |
| 2020-08-26 | EW | Futures | 2056.7 | 2060.1 | 2044.7 | 2049.5 | 9106.0 |
| 2020-08-26 | FBON | Futures | 146.0 | 146.21 | 145.91 | 146.15 | 715.0 |
| 2020-08-26 | FBTP | Futures | 132.84 | 133.05 | 132.53 | 132.9 | 79749.0 |
| 2020-08-26 | FBTS | Futures | 108.89 | 108.948 | 108.861 | 108.938 | 43106.0 |
| 2020-08-26 | FCE | Futures | 4882.9 | 4930.2 | 4839.1 | 4910.7 | 53663.0 |
| 2020-08-26 | FDAX | Futures | 13931.1 | 14071.8 | 13816.3 | 14010.7 | 59927.0 |
| 2020-08-26 | FDXM | Futures | 13872.3 | 14018.4 | 13766.5 | 13960.2 | 35817.0 |
| 2020-08-26 | FESX | Futures | 3082.3 | 3106.3 | 3056.4 | 3095.2 | 559068.0 |
| 2020-08-26 | FGBL | Futures | 168.16 | 168.2 | 167.65 | 167.84 | 733619.0 |
| 2020-08-26 | FGBM | Futures | 134.68 | 134.68 | 134.49 | 134.55 | 401542.0 |
| 2020-08-26 | FGBS | Futures | 112.699 | 112.699 | 112.654 | 112.669 | 483262.0 |
| 2020-08-26 | FGBX | Futures | 225.61 | 225.86 | 223.9 | 224.6 | 67774.0 |
| 2020-08-26 | FMWO | Futures | 8494.8 | 8599.0 | 8494.8 | 8555.2 | 2304.0 |
| 2020-08-26 | FOAT | Futures | 155.71 | 155.81 | 155.47 | 155.67 | 175397.0 |
| 2020-08-26 | FTDX | Futures | 3199.3 | 3239.6 | 3199.3 | 3237.6 | 53.0 |
| 2020-08-26 | FTI | Futures | 522.41 | 529.31 | 519.62 | 527.26 | 20011.0 |
| 2020-08-26 | FTUK | Futures | 5710.0 | 5724.2 | 5657.6 | 5707.2 | 62196.0 |
| 2020-08-26 | FVSA | Futures | 202.51 | 204.58 | 192.55 | 193.38 | 16707.0 |
| 2020-08-26 | FXXP | Futures | 341.3 | 345.2 | 339.7 | 344.0 | 28614.0 |
| 2020-08-26 | G | Futures | 126.13 | 126.26 | 125.79 | 125.89 | 229290.0 |
| 2020-08-26 | GF | Futures | 272.624 | 273.766 | 268.579 | 269.864 | 1899.0 |
| 2020-08-26 | GSCI | Futures | 351.03 | 351.03 | 351.03 | 351.03 | 1.0 |
> showing 50 of 119 rows — these rows as CSV