PREVIEW / futures_daily / 2021-04-29
file: by_date/futures_daily/2021/2021-04-29.parquet size: 10 KB rows: 123
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-04-29 | ES | Futures | 4695.93 | 4725.39 | 4677.14 | 4716.98 | 1746965.0 |
| 2021-04-29 | NQ | Futures | 16117.3 | 16221.69 | 15938.52 | 16094.23 | 595555.0 |
| 2021-04-29 | YM | Futures | 36492.0 | 36776.7 | 36396.8 | 36746.4 | 156887.0 |
| 2021-04-29 | CL | Futures | 45.35 | 46.61 | 45.32 | 46.29 | 384489.0 |
| 2021-04-29 | GC | Futures | 2089.0 | 2098.4 | 2057.0 | 2073.1 | 231520.0 |
| 2021-04-29 | ZN | Futures | 132.845603 | 132.845603 | 132.248826 | 132.657147 | 1634108.0 |
| 2021-04-29 | A6 | Futures | 0.7989 | 0.80182 | 0.79479 | 0.79736 | 91756.0 |
| 2021-04-29 | AD | Futures | 0.8224 | 0.82544 | 0.8223 | 0.82509 | 82444.0 |
| 2021-04-29 | ALI | Futures | 2767.21 | 2784.06 | 2763.21 | 2772.64 | 75.0 |
| 2021-04-29 | B | Futures | 43.61 | 44.76 | 43.59 | 44.51 | 320974.0 |
| 2021-04-29 | B6 | Futures | 1.4154 | 1.4195 | 1.4148 | 1.4165 | 72411.0 |
| 2021-04-29 | BFX | Futures | 4108.5 | 4108.5 | 4088.6 | 4088.6 | 1.0 |
| 2021-04-29 | BR | Futures | 0.14763 | 0.14902 | 0.14676 | 0.14755 | 21248.0 |
| 2021-04-29 | BTC | Futures | 75692.8 | 76535.2 | 72468.1 | 73207.0 | 3907.0 |
| 2021-04-29 | BZ | Futures | 42.5 | 43.68 | 42.47 | 43.44 | 34469.0 |
| 2021-04-29 | C | Futures | 1482.0 | 1506.0 | 1481.0 | 1494.0 | 2910.0 |
| 2021-04-29 | CB | Futures | 150.376 | 151.099 | 149.86 | 149.86 | 19.0 |
| 2021-04-29 | CC | Futures | 1647.0 | 1690.0 | 1645.0 | 1665.0 | 19852.0 |
| 2021-04-29 | CNH | Futures | 6.2926 | 6.2926 | 6.2796 | 6.2796 | 611.0 |
| 2021-04-29 | CSC | Futures | 2.994 | 3.006 | 2.992 | 3.002 | 97.0 |
| 2021-04-29 | CT | Futures | 83.65 | 84.17 | 80.24 | 80.69 | 20532.0 |
| 2021-04-29 | DC | Futures | 27.85 | 27.96 | 27.76 | 27.87 | 213.0 |
| 2021-04-29 | DX | Futures | 87.48 | 87.717 | 87.354 | 87.546 | 22120.0 |
| 2021-04-29 | E1 | Futures | 1.23871 | 1.24073 | 1.23533 | 1.23994 | 22632.0 |
| 2021-04-29 | E6 | Futures | 1.29338 | 1.29588 | 1.29071 | 1.29311 | 153721.0 |
| 2021-04-29 | E7 | Futures | 1.2866 | 1.2893 | 1.2842 | 1.2866 | 4095.0 |
| 2021-04-29 | EBM | Futures | 319.93 | 328.87 | 318.02 | 320.89 | 7611.0 |
| 2021-04-29 | ED | Futures | 96.4932 | 96.498 | 96.4883 | 96.4932 | 107398.0 |
| 2021-04-29 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 59534.0 |
| 2021-04-29 | ESG | Futures | 390.74 | 391.85 | 387.84 | 390.91 | 600.0 |
| 2021-04-29 | EW | Futures | 2947.6 | 2975.8 | 2930.0 | 2950.6 | 9752.0 |
| 2021-04-29 | FBON | Futures | 147.48 | 147.58 | 146.81 | 146.94 | 748.0 |
| 2021-04-29 | FBTP | Futures | 137.4 | 137.47 | 136.68 | 136.89 | 229535.0 |
| 2021-04-29 | FBTS | Futures | 109.991 | 110.0 | 109.922 | 109.952 | 90860.0 |
| 2021-04-29 | FCE | Futures | 6185.3 | 6219.9 | 6150.3 | 6170.5 | 48946.0 |
| 2021-04-29 | FDAX | Futures | 16344.7 | 16361.8 | 16091.0 | 16163.5 | 61873.0 |
| 2021-04-29 | FDIV | Futures | 183.14 | 183.19 | 181.37 | 181.62 | 236.0 |
| 2021-04-29 | FDXM | Futures | 16316.3 | 16339.8 | 16071.4 | 16143.8 | 65605.0 |
| 2021-04-29 | FDXS | Futures | 16182.7 | 16252.6 | 15986.8 | 16057.8 | 1802.0 |
| 2021-04-29 | FESX | Futures | 3756.3 | 3774.3 | 3726.1 | 3739.3 | 802173.0 |
| 2021-04-29 | FGBL | Futures | 166.81 | 166.84 | 165.88 | 166.1 | 929374.0 |
| 2021-04-29 | FGBM | Futures | 134.62 | 134.62 | 134.33 | 134.39 | 499215.0 |
| 2021-04-29 | FGBS | Futures | 112.634 | 112.639 | 112.604 | 112.614 | 282195.0 |
| 2021-04-29 | FGBX | Futures | 216.96 | 216.96 | 213.54 | 214.18 | 95733.0 |
| 2021-04-29 | FMWO | Futures | 10432.0 | 10450.8 | 10346.3 | 10388.6 | 2691.0 |
| 2021-04-29 | FOAT | Futures | 155.19 | 155.19 | 154.26 | 154.44 | 219332.0 |
| 2021-04-29 | FTDX | Futures | 3619.5 | 3639.0 | 3576.8 | 3584.0 | 201.0 |
| 2021-04-29 | FTI | Futures | 672.02 | 679.0 | 668.47 | 670.51 | 22757.0 |
| 2021-04-29 | FTUK | Futures | 6761.8 | 6806.1 | 6728.7 | 6752.0 | 82793.0 |
| 2021-04-29 | FVSA | Futures | 99.57 | 105.1 | 97.46 | 103.26 | 20521.0 |
> showing 50 of 123 rows — these rows as CSV