PREVIEW / futures_daily / 2020-08-20
file: by_date/futures_daily/2020/2020-08-20.parquet size: 10 KB rows: 121
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-20 | ES | Futures | 3793.51 | 3812.36 | 3764.81 | 3805.33 | 1203334.0 |
| 2020-08-20 | NQ | Futures | 13146.56 | 13343.29 | 13024.12 | 13320.95 | 401137.0 |
| 2020-08-20 | YM | Futures | 29626.9 | 29704.1 | 29355.8 | 29652.6 | 161159.0 |
| 2020-08-20 | CL | Futures | 31.06 | 31.08 | 30.11 | 30.97 | 377070.0 |
| 2020-08-20 | GC | Futures | 2284.5 | 2318.4 | 2278.1 | 2298.8 | 383338.0 |
| 2020-08-20 | ZN | Futures | 138.063159 | 138.403827 | 138.063159 | 138.310917 | 980383.0 |
| 2020-08-20 | A6 | Futures | 0.73921 | 0.74106 | 0.73417 | 0.74003 | 95458.0 |
| 2020-08-20 | AD | Futures | 0.7685 | 0.77088 | 0.76642 | 0.77017 | 58965.0 |
| 2020-08-20 | ALI | Futures | 2165.63 | 2170.39 | 2147.17 | 2151.33 | 388.0 |
| 2020-08-20 | B | Futures | 29.1 | 29.13 | 28.38 | 28.95 | 249744.0 |
| 2020-08-20 | B6 | Futures | 1.3311 | 1.3431 | 1.3267 | 1.3417 | 121040.0 |
| 2020-08-20 | BR | Futures | 0.14207 | 0.14294 | 0.13961 | 0.14223 | 8443.0 |
| 2020-08-20 | BTC | Futures | 16061.1 | 16348.4 | 16020.1 | 16273.2 | 4860.0 |
| 2020-08-20 | BZ | Futures | 28.5 | 28.5 | 27.71 | 28.27 | 24042.0 |
| 2020-08-20 | C | Futures | 1487.0 | 1513.0 | 1469.0 | 1476.0 | 3439.0 |
| 2020-08-20 | CB | Futures | 171.77 | 173.054 | 171.717 | 171.717 | 15.0 |
| 2020-08-20 | CC | Futures | 1608.0 | 1628.0 | 1571.0 | 1576.0 | 14835.0 |
| 2020-08-20 | CNH | Futures | 6.8291 | 6.8317 | 6.8108 | 6.8128 | 543.0 |
| 2020-08-20 | CSC | Futures | 3.215 | 3.221 | 3.166 | 3.17 | 129.0 |
| 2020-08-20 | CT | Futures | 63.4 | 64.98 | 63.4 | 64.65 | 45.0 |
| 2020-08-20 | DC | Futures | 26.42 | 26.42 | 25.5 | 25.65 | 544.0 |
| 2020-08-20 | DX | Futures | 89.808 | 90.068 | 89.552 | 89.617 | 19706.0 |
| 2020-08-20 | E1 | Futures | 1.24182 | 1.25261 | 1.24034 | 1.2509 | 31073.0 |
| 2020-08-20 | E6 | Futures | 1.27115 | 1.27415 | 1.26697 | 1.27238 | 203582.0 |
| 2020-08-20 | E7 | Futures | 1.2647 | 1.2677 | 1.2607 | 1.266 | 8197.0 |
| 2020-08-20 | EBM | Futures | 217.96 | 218.85 | 216.76 | 217.06 | 4730.0 |
| 2020-08-20 | ED | Futures | 96.4499 | 96.4523 | 96.4427 | 96.4475 | 115427.0 |
| 2020-08-20 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.406 | 56767.0 |
| 2020-08-20 | ESG | Futures | 308.33 | 308.95 | 308.33 | 308.95 | 4.0 |
| 2020-08-20 | EW | Futures | 2046.3 | 2048.3 | 2024.1 | 2036.4 | 10945.0 |
| 2020-08-20 | FBON | Futures | 147.16 | 147.29 | 146.92 | 147.17 | 404.0 |
| 2020-08-20 | FBTP | Futures | 133.97 | 134.12 | 133.78 | 133.94 | 61979.0 |
| 2020-08-20 | FBTS | Futures | 109.084 | 109.132 | 109.045 | 109.064 | 44008.0 |
| 2020-08-20 | FCE | Futures | 4772.9 | 4804.1 | 4752.9 | 4775.8 | 43581.0 |
| 2020-08-20 | FDAX | Futures | 13701.6 | 13711.1 | 13526.3 | 13626.2 | 73408.0 |
| 2020-08-20 | FDXM | Futures | 13651.1 | 13674.4 | 13481.7 | 13577.0 | 45148.0 |
| 2020-08-20 | FESX | Futures | 3036.1 | 3040.7 | 3002.9 | 3020.4 | 780196.0 |
| 2020-08-20 | FEU3 | Futures | 99.154 | 99.154 | 99.154 | 99.154 | 50.0 |
| 2020-08-20 | FGBL | Futures | 168.71 | 169.29 | 168.59 | 169.07 | 562748.0 |
| 2020-08-20 | FGBM | Futures | 134.86 | 135.01 | 134.8 | 134.93 | 340785.0 |
| 2020-08-20 | FGBS | Futures | 112.739 | 112.754 | 112.714 | 112.729 | 257270.0 |
| 2020-08-20 | FGBX | Futures | 227.69 | 230.6 | 227.69 | 229.67 | 46108.0 |
| 2020-08-20 | FMWO | Futures | 8331.2 | 8404.7 | 8320.5 | 8372.7 | 2203.0 |
| 2020-08-20 | FOAT | Futures | 156.58 | 156.9 | 156.32 | 156.69 | 139151.0 |
| 2020-08-20 | FTDX | Futures | 3155.3 | 3164.5 | 3141.0 | 3143.6 | 77.0 |
| 2020-08-20 | FTI | Futures | 514.44 | 516.91 | 512.11 | 514.24 | 15929.0 |
| 2020-08-20 | FTUK | Futures | 5720.4 | 5739.8 | 5673.7 | 5682.6 | 72746.0 |
| 2020-08-20 | FVSA | Futures | 206.24 | 214.13 | 203.75 | 211.64 | 19155.0 |
| 2020-08-20 | FXXP | Futures | 336.5 | 338.6 | 335.7 | 337.3 | 41142.0 |
| 2020-08-20 | G | Futures | 126.58 | 126.83 | 126.47 | 126.64 | 164891.0 |
> showing 50 of 121 rows — these rows as CSV