PREVIEW / futures_daily / 2020-07-21
file: by_date/futures_daily/2020/2020-07-21.parquet size: 10 KB rows: 120
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-07-21 | ES | Futures | 3651.12 | 3684.33 | 3646.06 | 3659.56 | 1463931.0 |
| 2020-07-21 | NQ | Futures | 12711.61 | 12834.35 | 12517.21 | 12594.1 | 587994.0 |
| 2020-07-21 | YM | Futures | 28533.8 | 28855.3 | 28496.3 | 28642.0 | 173817.0 |
| 2020-07-21 | CL | Futures | 29.77 | 31.02 | 29.73 | 30.59 | 389117.0 |
| 2020-07-21 | GC | Futures | 2184.6 | 2215.0 | 2181.8 | 2213.8 | 271085.0 |
| 2020-07-21 | ZN | Futures | 138.218008 | 138.341887 | 138.078644 | 138.264463 | 614084.0 |
| 2020-07-21 | A6 | Futures | 0.72172 | 0.73541 | 0.72172 | 0.7351 | 112195.0 |
| 2020-07-21 | AD | Futures | 0.74992 | 0.75621 | 0.74987 | 0.7555 | 75929.0 |
| 2020-07-21 | ALI | Futures | 2038.83 | 2071.3 | 2038.83 | 2066.14 | 547.0 |
| 2020-07-21 | B | Futures | 28.13 | 29.25 | 28.12 | 28.87 | 229784.0 |
| 2020-07-21 | B6 | Futures | 1.2854 | 1.297 | 1.2849 | 1.2959 | 95802.0 |
| 2020-07-21 | BR | Futures | 0.14841 | 0.15308 | 0.14841 | 0.15308 | 555.0 |
| 2020-07-21 | BTC | Futures | 12677.9 | 13056.7 | 12636.6 | 12939.6 | 5408.0 |
| 2020-07-21 | BZ | Futures | 27.5 | 28.59 | 27.47 | 28.23 | 24167.0 |
| 2020-07-21 | C | Futures | 1415.0 | 1444.0 | 1392.0 | 1395.0 | 6835.0 |
| 2020-07-21 | CB | Futures | 192.579 | 192.579 | 190.814 | 191.991 | 66.0 |
| 2020-07-21 | CC | Futures | 1453.0 | 1481.0 | 1425.0 | 1427.0 | 20076.0 |
| 2020-07-21 | CNH | Futures | 6.8974 | 6.9081 | 6.8853 | 6.8854 | 127.0 |
| 2020-07-21 | CSC | Futures | 4.345 | 4.482 | 4.345 | 4.421 | 222.0 |
| 2020-07-21 | CT | Futures | 63.83 | 63.99 | 63.6 | 63.62 | 20.0 |
| 2020-07-21 | DC | Futures | 35.82 | 36.82 | 35.73 | 36.43 | 729.0 |
| 2020-07-21 | DX | Futures | 92.44 | 92.604 | 91.744 | 91.822 | 24675.0 |
| 2020-07-21 | E1 | Futures | 1.21138 | 1.22035 | 1.21047 | 1.21944 | 22066.0 |
| 2020-07-21 | E6 | Futures | 1.22968 | 1.23976 | 1.22716 | 1.23875 | 252875.0 |
| 2020-07-21 | E7 | Futures | 1.2232 | 1.2336 | 1.2212 | 1.2326 | 8600.0 |
| 2020-07-21 | EBM | Futures | 217.66 | 219.75 | 216.76 | 219.15 | 11483.0 |
| 2020-07-21 | ED | Futures | 96.4185 | 96.4233 | 96.4137 | 96.4233 | 94620.0 |
| 2020-07-21 | ER | Futures | 98.367 | 98.372 | 98.362 | 98.372 | 34979.0 |
| 2020-07-21 | ESG | Futures | 296.48 | 299.2 | 294.85 | 295.17 | 32.0 |
| 2020-07-21 | EW | Futures | 1939.8 | 1975.1 | 1934.7 | 1962.4 | 11448.0 |
| 2020-07-21 | FBON | Futures | 146.05 | 146.67 | 145.99 | 146.28 | 134.0 |
| 2020-07-21 | FBTP | Futures | 132.1 | 132.43 | 131.72 | 131.99 | 85284.0 |
| 2020-07-21 | FBTS | Futures | 108.715 | 108.812 | 108.706 | 108.764 | 65037.0 |
| 2020-07-21 | FCE | Futures | 4961.0 | 4996.3 | 4894.8 | 4929.1 | 57508.0 |
| 2020-07-21 | FDAX | Futures | 13914.1 | 14134.5 | 13880.1 | 13979.9 | 93808.0 |
| 2020-07-21 | FDIV | Futures | 152.09 | 152.09 | 151.04 | 151.04 | 300.0 |
| 2020-07-21 | FDXM | Futures | 13861.7 | 14083.0 | 13828.9 | 13929.5 | 59777.0 |
| 2020-07-21 | FESX | Futures | 3128.4 | 3181.1 | 3114.6 | 3137.7 | 972319.0 |
| 2020-07-21 | FGBL | Futures | 168.39 | 168.59 | 168.22 | 168.51 | 407568.0 |
| 2020-07-21 | FGBM | Futures | 134.73 | 134.81 | 134.67 | 134.77 | 267252.0 |
| 2020-07-21 | FGBS | Futures | 112.714 | 112.744 | 112.714 | 112.729 | 228316.0 |
| 2020-07-21 | FGBX | Futures | 227.26 | 227.74 | 226.52 | 227.41 | 31513.0 |
| 2020-07-21 | FMWO | Futures | 8162.9 | 8191.4 | 8125.0 | 8168.9 | 1451.0 |
| 2020-07-21 | FOAT | Futures | 155.96 | 156.24 | 155.86 | 156.08 | 119939.0 |
| 2020-07-21 | FTDX | Futures | 3262.1 | 3262.1 | 3188.0 | 3199.3 | 91.0 |
| 2020-07-21 | FTI | Futures | 543.85 | 546.52 | 535.86 | 540.97 | 22532.0 |
| 2020-07-21 | FTUK | Futures | 5886.8 | 5938.3 | 5861.3 | 5890.6 | 79244.0 |
| 2020-07-21 | FVSA | Futures | 229.39 | 233.92 | 218.54 | 228.49 | 41983.0 |
| 2020-07-21 | FXXP | Futures | 349.4 | 350.2 | 344.2 | 346.6 | 46527.0 |
| 2020-07-21 | G | Futures | 127.38 | 127.64 | 127.33 | 127.59 | 175817.0 |
> showing 50 of 120 rows — these rows as CSV