PREVIEW / futures_daily / 2021-04-23
file: by_date/futures_daily/2021/2021-04-23.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-04-23 | ES | Futures | 4633.37 | 4698.18 | 4631.69 | 4681.07 | 1509514.0 |
| 2021-04-23 | NQ | Futures | 15867.59 | 16125.95 | 15844.52 | 16063.67 | 450885.0 |
| 2021-04-23 | YM | Futures | 36490.9 | 36860.0 | 36375.1 | 36735.6 | 137997.0 |
| 2021-04-23 | CL | Futures | 43.89 | 44.45 | 43.61 | 44.24 | 345407.0 |
| 2021-04-23 | GC | Futures | 2091.5 | 2105.9 | 2074.5 | 2084.2 | 175847.0 |
| 2021-04-23 | ZN | Futures | 133.316742 | 133.41097 | 132.986945 | 133.112582 | 1165827.0 |
| 2021-04-23 | A6 | Futures | 0.79074 | 0.79592 | 0.78967 | 0.79541 | 67496.0 |
| 2021-04-23 | AD | Futures | 0.8103 | 0.81313 | 0.80999 | 0.81227 | 61359.0 |
| 2021-04-23 | ALI | Futures | 2752.65 | 2754.08 | 2728.66 | 2728.66 | 680.0 |
| 2021-04-23 | B | Futures | 42.55 | 42.88 | 42.14 | 42.75 | 187900.0 |
| 2021-04-23 | B6 | Futures | 1.4054 | 1.4113 | 1.405 | 1.4092 | 69709.0 |
| 2021-04-23 | BFX | Futures | 4073.8 | 4073.8 | 4048.2 | 4055.4 | 2.0 |
| 2021-04-23 | BR | Futures | 0.14423 | 0.14546 | 0.14305 | 0.14376 | 1046.0 |
| 2021-04-23 | BTC | Futures | 67001.7 | 67840.8 | 61655.1 | 66143.2 | 10381.0 |
| 2021-04-23 | BZ | Futures | 41.4 | 41.83 | 41.11 | 41.71 | 22397.0 |
| 2021-04-23 | C | Futures | 1484.0 | 1492.0 | 1482.0 | 1486.0 | 759.0 |
| 2021-04-23 | CB | Futures | 149.448 | 151.099 | 149.448 | 150.665 | 23.0 |
| 2021-04-23 | CC | Futures | 1631.0 | 1641.0 | 1623.0 | 1632.0 | 9431.0 |
| 2021-04-23 | CNH | Futures | 6.3167 | 6.3167 | 6.3076 | 6.3077 | 291.0 |
| 2021-04-23 | CSC | Futures | 2.878 | 2.958 | 2.869 | 2.95 | 82.0 |
| 2021-04-23 | CT | Futures | 80.05 | 83.01 | 80.05 | 82.8 | 1703.0 |
| 2021-04-23 | DC | Futures | 26.48 | 27.06 | 26.21 | 26.87 | 200.0 |
| 2021-04-23 | DX | Futures | 88.214 | 88.214 | 87.726 | 87.783 | 19432.0 |
| 2021-04-23 | E1 | Futures | 1.22869 | 1.23477 | 1.22846 | 1.23364 | 16548.0 |
| 2021-04-23 | E6 | Futures | 1.28171 | 1.29071 | 1.28134 | 1.28986 | 151473.0 |
| 2021-04-23 | E7 | Futures | 1.2754 | 1.2843 | 1.2749 | 1.2833 | 4410.0 |
| 2021-04-23 | EBM | Futures | 300.14 | 303.65 | 297.58 | 301.73 | 5225.0 |
| 2021-04-23 | ED | Futures | 96.498 | 96.498 | 96.4883 | 96.4932 | 75536.0 |
| 2021-04-23 | ER | Futures | 98.46 | 98.46 | 98.455 | 98.455 | 17231.0 |
| 2021-04-23 | ESG | Futures | 383.42 | 387.99 | 383.42 | 387.1 | 372.0 |
| 2021-04-23 | EW | Futures | 2890.0 | 2945.5 | 2890.0 | 2933.5 | 10282.0 |
| 2021-04-23 | FBON | Futures | 148.12 | 148.22 | 147.79 | 147.89 | 659.0 |
| 2021-04-23 | FBTP | Futures | 138.19 | 138.25 | 137.66 | 137.8 | 127935.0 |
| 2021-04-23 | FBTS | Futures | 110.049 | 110.068 | 109.981 | 110.0 | 47487.0 |
| 2021-04-23 | FCE | Futures | 6126.1 | 6144.9 | 6090.6 | 6121.7 | 35990.0 |
| 2021-04-23 | FDAX | Futures | 16280.8 | 16339.4 | 16165.6 | 16301.0 | 47220.0 |
| 2021-04-23 | FDIV | Futures | 183.53 | 183.53 | 183.48 | 183.48 | 5.0 |
| 2021-04-23 | FDXM | Futures | 16255.6 | 16320.6 | 16146.0 | 16281.2 | 50050.0 |
| 2021-04-23 | FDXS | Futures | 16165.8 | 16230.4 | 16073.7 | 16194.4 | 282.0 |
| 2021-04-23 | FESX | Futures | 3738.4 | 3756.3 | 3718.5 | 3749.7 | 664092.0 |
| 2021-04-23 | FGBL | Futures | 167.21 | 167.32 | 166.87 | 167.03 | 617355.0 |
| 2021-04-23 | FGBM | Futures | 134.68 | 134.72 | 134.58 | 134.65 | 290530.0 |
| 2021-04-23 | FGBS | Futures | 112.649 | 112.649 | 112.634 | 112.644 | 175287.0 |
| 2021-04-23 | FGBX | Futures | 218.4 | 218.66 | 216.87 | 217.4 | 66391.0 |
| 2021-04-23 | FMWO | Futures | 10280.5 | 10388.6 | 10268.8 | 10345.1 | 4535.0 |
| 2021-04-23 | FOAT | Futures | 155.57 | 155.61 | 155.22 | 155.33 | 164038.0 |
| 2021-04-23 | FTDX | Futures | 3622.1 | 3622.1 | 3589.7 | 3614.9 | 76.0 |
| 2021-04-23 | FTI | Futures | 669.46 | 674.92 | 667.66 | 674.31 | 14922.0 |
| 2021-04-23 | FTUK | Futures | 6691.1 | 6731.6 | 6678.5 | 6721.3 | 57115.0 |
| 2021-04-23 | FVSA | Futures | 102.73 | 104.84 | 98.78 | 100.89 | 27655.0 |
> showing 50 of 122 rows — these rows as CSV