PREVIEW / futures_daily / 2020-09-11
file: by_date/futures_daily/2020/2020-09-11.parquet size: 10 KB rows: 118
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-09-11 | ES | Futures | 3765.37 | 3798.86 | 3724.29 | 3752.43 | 1876451.0 |
| 2020-09-11 | NQ | Futures | 12984.07 | 13180.51 | 12694.49 | 12838.41 | 495802.0 |
| 2020-09-11 | YM | Futures | 29571.5 | 29830.9 | 29410.0 | 29598.4 | 185655.0 |
| 2020-09-11 | CL | Futures | 26.76 | 27.35 | 26.52 | 27.0 | 363787.0 |
| 2020-09-11 | GC | Futures | 2307.5 | 2318.8 | 2295.9 | 2300.5 | 205234.0 |
| 2020-09-11 | ZN | Futures | 138.280203 | 138.481665 | 138.171724 | 138.450671 | 937794.0 |
| 2020-09-11 | A6 | Futures | 0.74508 | 0.75021 | 0.74508 | 0.74693 | 75409.0 |
| 2020-09-11 | AD | Futures | 0.76855 | 0.77083 | 0.76744 | 0.7684 | 62654.0 |
| 2020-09-11 | ALI | Futures | 2135.55 | 2135.55 | 2130.49 | 2130.79 | 153.0 |
| 2020-09-11 | B | Futures | 25.47 | 25.71 | 25.1 | 25.39 | 211875.0 |
| 2020-09-11 | B6 | Futures | 1.2985 | 1.3052 | 1.2947 | 1.2975 | 126063.0 |
| 2020-09-11 | BR | Futures | 0.14738 | 0.14738 | 0.14686 | 0.14714 | 2.0 |
| 2020-09-11 | BTC | Futures | 14001.3 | 14068.8 | 13792.0 | 13960.8 | 4819.0 |
| 2020-09-11 | BZ | Futures | 24.91 | 25.16 | 24.56 | 24.84 | 24576.0 |
| 2020-09-11 | C | Futures | 1584.0 | 1609.0 | 1584.0 | 1600.0 | 6537.0 |
| 2020-09-11 | CB | Futures | 167.73 | 168.365 | 167.705 | 168.365 | 14.0 |
| 2020-09-11 | CC | Futures | 1666.0 | 1687.0 | 1661.0 | 1673.0 | 8933.0 |
| 2020-09-11 | CNH | Futures | 6.7323 | 6.7337 | 6.7266 | 6.7297 | 829.0 |
| 2020-09-11 | CSC | Futures | 3.254 | 3.291 | 3.249 | 3.291 | 44.0 |
| 2020-09-11 | CT | Futures | 65.44 | 65.45 | 64.79 | 64.79 | 3.0 |
| 2020-09-11 | DC | Futures | 26.37 | 26.66 | 26.31 | 26.65 | 123.0 |
| 2020-09-11 | DX | Futures | 90.187 | 90.221 | 89.907 | 90.161 | 27441.0 |
| 2020-09-11 | E1 | Futures | 1.24726 | 1.25054 | 1.24692 | 1.24828 | 14733.0 |
| 2020-09-11 | E6 | Futures | 1.26868 | 1.27452 | 1.26863 | 1.26991 | 216004.0 |
| 2020-09-11 | E7 | Futures | 1.2625 | 1.2679 | 1.2623 | 1.2634 | 6287.0 |
| 2020-09-11 | EBM | Futures | 229.05 | 229.05 | 226.94 | 227.24 | 27077.0 |
| 2020-09-11 | ED | Futures | 96.4358 | 96.4455 | 96.431 | 96.4455 | 159851.0 |
| 2020-09-11 | ER | Futures | 98.411 | 98.416 | 98.406 | 98.416 | 67052.0 |
| 2020-09-11 | ESG | Futures | 311.02 | 311.15 | 308.37 | 309.56 | 34.0 |
| 2020-09-11 | EW | Futures | 1985.3 | 1996.7 | 1957.7 | 1975.6 | 41721.0 |
| 2020-09-11 | FBON | Futures | 146.91 | 147.33 | 146.77 | 147.12 | 272.0 |
| 2020-09-11 | FBTP | Futures | 133.28 | 133.48 | 133.17 | 133.37 | 72045.0 |
| 2020-09-11 | FBTS | Futures | 109.054 | 109.074 | 108.987 | 109.054 | 59462.0 |
| 2020-09-11 | FCE | Futures | 4889.7 | 4919.9 | 4863.9 | 4900.5 | 62308.0 |
| 2020-09-11 | FDAX | Futures | 13962.4 | 14084.0 | 13928.4 | 14038.9 | 73780.0 |
| 2020-09-11 | FDIV | Futures | 153.41 | 153.84 | 153.27 | 153.84 | 525.0 |
| 2020-09-11 | FDXM | Futures | 13969.6 | 14036.4 | 13896.4 | 13998.2 | 544.0 |
| 2020-09-11 | FESX | Futures | 3034.2 | 3067.5 | 3032.4 | 3059.2 | 391072.0 |
| 2020-09-11 | FGBL | Futures | 168.89 | 169.26 | 168.77 | 169.18 | 462776.0 |
| 2020-09-11 | FGBM | Futures | 134.9 | 135.06 | 134.83 | 135.02 | 315941.0 |
| 2020-09-11 | FGBS | Futures | 112.729 | 112.764 | 112.709 | 112.754 | 255211.0 |
| 2020-09-11 | FGBX | Futures | 228.38 | 229.63 | 228.05 | 229.32 | 41690.0 |
| 2020-09-11 | FMWO | Futures | 8352.5 | 8386.9 | 8286.2 | 8352.5 | 6288.0 |
| 2020-09-11 | FOAT | Futures | 156.62 | 157.04 | 156.57 | 156.95 | 116952.0 |
| 2020-09-11 | FTDX | Futures | 3153.2 | 3153.2 | 3150.1 | 3150.1 | 1.0 |
| 2020-09-11 | FTI | Futures | 512.08 | 516.48 | 510.4 | 514.04 | 191.0 |
| 2020-09-11 | FTUK | Futures | 5701.1 | 5761.8 | 5691.6 | 5748.9 | 89539.0 |
| 2020-09-11 | FVSA | Futures | 205.41 | 207.49 | 192.55 | 198.36 | 20352.0 |
| 2020-09-11 | FXXP | Futures | 338.3 | 340.8 | 338.3 | 340.1 | 41431.0 |
| 2020-09-11 | G | Futures | 127.2 | 127.34 | 126.84 | 127.28 | 197878.0 |
> showing 50 of 118 rows — these rows as CSV