PREVIEW / futures_daily / 2021-03-31
file: by_date/futures_daily/2021/2021-03-31.parquet size: 10 KB rows: 122
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-31 | ES | Futures | 4431.95 | 4470.38 | 4422.97 | 4452.15 | 1642169.0 |
| 2021-03-31 | NQ | Futures | 14873.05 | 15176.69 | 14830.95 | 15097.97 | 478398.0 |
| 2021-03-31 | YM | Futures | 35650.0 | 35765.8 | 35572.0 | 35606.7 | 140701.0 |
| 2021-03-31 | CL | Futures | 43.03 | 43.55 | 41.89 | 42.11 | 414162.0 |
| 2021-03-31 | GC | Futures | 1976.5 | 2012.1 | 1966.4 | 2011.3 | 210770.0 |
| 2021-03-31 | ZN | Futures | 131.966143 | 131.966143 | 131.573526 | 131.604936 | 2350602.0 |
| 2021-03-31 | A6 | Futures | 0.77916 | 0.78326 | 0.77829 | 0.77941 | 85543.0 |
| 2021-03-31 | AD | Futures | 0.80265 | 0.80802 | 0.80224 | 0.80619 | 78443.0 |
| 2021-03-31 | ALI | Futures | 2571.25 | 2571.25 | 2571.25 | 2571.25 | 0.0 |
| 2021-03-31 | B | Futures | 41.36 | 41.93 | 40.44 | 40.58 | 323097.0 |
| 2021-03-31 | B6 | Futures | 1.3951 | 1.4028 | 1.3931 | 1.3994 | 81590.0 |
| 2021-03-31 | BFX | Futures | 3954.5 | 3954.5 | 3927.8 | 3927.8 | 1.0 |
| 2021-03-31 | BR | Futures | 0.13723 | 0.14012 | 0.13676 | 0.13968 | 227.0 |
| 2021-03-31 | BTC | Futures | 77220.1 | 78755.2 | 74644.4 | 77122.6 | 6924.0 |
| 2021-03-31 | BZ | Futures | 40.37 | 40.89 | 39.45 | 39.58 | 38444.0 |
| 2021-03-31 | C | Futures | 1547.0 | 1569.0 | 1545.0 | 1553.0 | 13327.0 |
| 2021-03-31 | CB | Futures | 152.688 | 156.053 | 152.688 | 154.814 | 31.0 |
| 2021-03-31 | CC | Futures | 1586.0 | 1599.0 | 1577.0 | 1582.0 | 19070.0 |
| 2021-03-31 | CNH | Futures | 6.4059 | 6.4085 | 6.3877 | 6.3958 | 122.0 |
| 2021-03-31 | CSC | Futures | 2.836 | 2.926 | 2.825 | 2.896 | 83.0 |
| 2021-03-31 | CT | Futures | 76.36 | 77.02 | 74.37 | 76.53 | 20609.0 |
| 2021-03-31 | DC | Futures | 25.07 | 26.22 | 25.07 | 26.02 | 168.0 |
| 2021-03-31 | DX | Futures | 90.137 | 90.326 | 89.876 | 90.1 | 20928.0 |
| 2021-03-31 | E1 | Futures | 1.19662 | 1.19898 | 1.192 | 1.19234 | 20725.0 |
| 2021-03-31 | E6 | Futures | 1.25054 | 1.25507 | 1.249 | 1.25118 | 180803.0 |
| 2021-03-31 | E7 | Futures | 1.244 | 1.2486 | 1.2426 | 1.2449 | 4200.0 |
| 2021-03-31 | EBM | Futures | 268.53 | 278.43 | 266.61 | 275.23 | 31909.0 |
| 2021-03-31 | ED | Futures | 96.498 | 96.5077 | 96.498 | 96.5028 | 118063.0 |
| 2021-03-31 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 39443.0 |
| 2021-03-31 | ESG | Futures | 365.1 | 368.45 | 364.88 | 366.93 | 471.0 |
| 2021-03-31 | EW | Futures | 2786.7 | 2812.9 | 2782.7 | 2787.8 | 10075.0 |
| 2021-03-31 | FBON | Futures | 148.49 | 148.8 | 148.34 | 148.74 | 404.0 |
| 2021-03-31 | FBTP | Futures | 138.8 | 139.17 | 138.71 | 139.05 | 108320.0 |
| 2021-03-31 | FBTS | Futures | 110.049 | 110.127 | 110.049 | 110.117 | 67230.0 |
| 2021-03-31 | FCE | Futures | 5925.3 | 5947.7 | 5908.7 | 5918.0 | 58237.0 |
| 2021-03-31 | FDAX | Futures | 15997.2 | 16055.8 | 15957.8 | 16021.7 | 54901.0 |
| 2021-03-31 | FDIV | Futures | 183.68 | 183.68 | 182.84 | 182.94 | 95.0 |
| 2021-03-31 | FDXM | Futures | 15972.4 | 16036.3 | 15938.3 | 16002.2 | 48499.0 |
| 2021-03-31 | FESX | Futures | 3655.2 | 3665.6 | 3643.9 | 3654.3 | 990320.0 |
| 2021-03-31 | FEU3 | Futures | 99.208 | 99.208 | 99.203 | 99.203 | 100.0 |
| 2021-03-31 | FGBL | Futures | 167.33 | 167.58 | 167.08 | 167.47 | 771682.0 |
| 2021-03-31 | FGBM | Futures | 134.76 | 134.85 | 134.7 | 134.82 | 448700.0 |
| 2021-03-31 | FGBS | Futures | 112.649 | 112.654 | 112.624 | 112.644 | 230962.0 |
| 2021-03-31 | FGBX | Futures | 217.96 | 219.23 | 217.34 | 218.64 | 97735.0 |
| 2021-03-31 | FMWO | Futures | 9851.8 | 9922.3 | 9830.6 | 9884.7 | 3088.0 |
| 2021-03-31 | FOAT | Futures | 155.63 | 155.93 | 155.48 | 155.81 | 213485.0 |
| 2021-03-31 | FTDX | Futures | 3454.5 | 3494.6 | 3454.5 | 3487.9 | 76.0 |
| 2021-03-31 | FTI | Futures | 656.84 | 660.17 | 655.2 | 656.04 | 19847.0 |
| 2021-03-31 | FTUK | Futures | 6556.7 | 6565.5 | 6489.5 | 6506.6 | 115721.0 |
| 2021-03-31 | FVSA | Futures | 106.6 | 107.46 | 102.04 | 104.61 | 28222.0 |
> showing 50 of 122 rows — these rows as CSV