PREVIEW / futures_daily / 2020-11-10
file: by_date/futures_daily/2020/2020-11-10.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-11-10 | ES | Futures | 3987.79 | 4002.68 | 3939.49 | 3978.25 | 2160319.0 |
| 2020-11-10 | NQ | Futures | 13734.48 | 13778.47 | 13317.42 | 13450.55 | 834533.0 |
| 2020-11-10 | YM | Futures | 31319.8 | 31639.6 | 30985.0 | 31564.2 | 227543.0 |
| 2020-11-10 | CL | Futures | 28.45 | 29.83 | 28.09 | 29.48 | 457045.0 |
| 2020-11-10 | GC | Futures | 2201.5 | 2230.8 | 2195.4 | 2216.0 | 264872.0 |
| 2020-11-10 | ZN | Futures | 136.684007 | 136.792486 | 136.296581 | 136.312078 | 2068812.0 |
| 2020-11-10 | A6 | Futures | 0.74662 | 0.74898 | 0.74467 | 0.74765 | 105047.0 |
| 2020-11-10 | AD | Futures | 0.77945 | 0.78051 | 0.77656 | 0.77843 | 74833.0 |
| 2020-11-10 | ALI | Futures | 2273.28 | 2282.46 | 2273.28 | 2278.31 | 68.0 |
| 2020-11-10 | B | Futures | 26.31 | 27.79 | 26.28 | 27.48 | 315249.0 |
| 2020-11-10 | B6 | Futures | 1.3348 | 1.3468 | 1.3344 | 1.3443 | 109048.0 |
| 2020-11-10 | BR | Futures | 0.14541 | 0.1473 | 0.14498 | 0.14604 | 9064.0 |
| 2020-11-10 | BTC | Futures | 20370.0 | 20581.2 | 19967.5 | 20264.4 | 5971.0 |
| 2020-11-10 | BZ | Futures | 25.99 | 27.18 | 25.63 | 26.9 | 41973.0 |
| 2020-11-10 | C | Futures | 1446.0 | 1447.0 | 1407.0 | 1420.0 | 3244.0 |
| 2020-11-10 | CB | Futures | 155.025 | 156.524 | 155.025 | 156.524 | 9.0 |
| 2020-11-10 | CC | Futures | 1579.0 | 1591.0 | 1541.0 | 1549.0 | 27619.0 |
| 2020-11-10 | CNH | Futures | 6.4934 | 6.5031 | 6.4625 | 6.475 | 1926.0 |
| 2020-11-10 | CSC | Futures | 3.685 | 3.822 | 3.675 | 3.822 | 41.0 |
| 2020-11-10 | CT | Futures | 69.18 | 69.34 | 68.3 | 69.03 | 32464.0 |
| 2020-11-10 | DC | Futures | 30.39 | 31.55 | 29.88 | 31.55 | 530.0 |
| 2020-11-10 | DX | Futures | 89.651 | 89.801 | 89.434 | 89.58 | 22874.0 |
| 2020-11-10 | E1 | Futures | 1.24013 | 1.24341 | 1.23526 | 1.23877 | 29170.0 |
| 2020-11-10 | E6 | Futures | 1.2667 | 1.2697 | 1.26279 | 1.26638 | 155780.0 |
| 2020-11-10 | E7 | Futures | 1.2602 | 1.2631 | 1.2563 | 1.2599 | 7292.0 |
| 2020-11-10 | EBM | Futures | 252.86 | 256.17 | 252.26 | 255.57 | 22860.0 |
| 2020-11-10 | ED | Futures | 96.4987 | 96.5035 | 96.489 | 96.4939 | 150403.0 |
| 2020-11-10 | ER | Futures | 98.45 | 98.455 | 98.445 | 98.45 | 150235.0 |
| 2020-11-10 | ESG | Futures | 329.98 | 330.06 | 324.99 | 327.76 | 1635.0 |
| 2020-11-10 | EW | Futures | 2230.2 | 2270.8 | 2208.2 | 2251.5 | 16551.0 |
| 2020-11-10 | FBON | Futures | 148.38 | 149.07 | 148.38 | 148.83 | 239.0 |
| 2020-11-10 | FBTP | Futures | 136.87 | 137.23 | 136.66 | 136.88 | 140665.0 |
| 2020-11-10 | FBTS | Futures | 109.759 | 109.865 | 109.759 | 109.817 | 106727.0 |
| 2020-11-10 | FCE | Futures | 5102.7 | 5259.3 | 5097.9 | 5238.1 | 113389.0 |
| 2020-11-10 | FDAX | Futures | 13850.1 | 14108.1 | 13716.8 | 14068.1 | 101084.0 |
| 2020-11-10 | FDIV | Futures | 153.32 | 155.97 | 153.32 | 155.97 | 30.0 |
| 2020-11-10 | FDXM | Futures | 13770.2 | 14036.4 | 13652.4 | 13997.2 | 92576.0 |
| 2020-11-10 | FESX | Futures | 3124.8 | 3196.9 | 3092.5 | 3190.5 | 1814016.0 |
| 2020-11-10 | FEU3 | Futures | 99.183 | 99.188 | 99.183 | 99.188 | 250.0 |
| 2020-11-10 | FGBL | Futures | 169.74 | 169.83 | 169.14 | 169.24 | 996027.0 |
| 2020-11-10 | FGBM | Futures | 135.22 | 135.25 | 135.02 | 135.04 | 611188.0 |
| 2020-11-10 | FGBS | Futures | 112.79 | 112.8 | 112.749 | 112.759 | 626399.0 |
| 2020-11-10 | FGBX | Futures | 231.89 | 232.1 | 230.13 | 230.45 | 115544.0 |
| 2020-11-10 | FMWO | Futures | 8783.7 | 8873.7 | 8770.7 | 8837.0 | 5666.0 |
| 2020-11-10 | FOAT | Futures | 157.86 | 158.04 | 157.62 | 157.75 | 204431.0 |
| 2020-11-10 | FTDX | Futures | 3064.8 | 3069.9 | 2994.3 | 3024.6 | 301.0 |
| 2020-11-10 | FTI | Futures | 550.6 | 554.33 | 545.5 | 552.25 | 85.0 |
| 2020-11-10 | FTUK | Futures | 5844.5 | 6016.1 | 5814.4 | 6006.0 | 204509.0 |
| 2020-11-10 | FVSA | Futures | 173.92 | 176.43 | 164.26 | 172.49 | 40832.0 |
| 2020-11-10 | FXXP | Futures | 350.9 | 356.8 | 350.1 | 356.2 | 152821.0 |
> showing 50 of 121 rows — these rows as CSV