PREVIEW / futures_daily / 2021-03-05
file: by_date/futures_daily/2021/2021-03-05.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 |
|---|---|---|---|---|---|---|---|
| 2021-03-05 | ES | Futures | 4220.38 | 4315.09 | 4178.91 | 4302.76 | 2948117.0 |
| 2021-03-05 | NQ | Futures | 14342.77 | 14645.83 | 14080.08 | 14606.61 | 1016317.0 |
| 2021-03-05 | YM | Futures | 33368.4 | 34066.1 | 33089.8 | 33979.7 | 342921.0 |
| 2021-03-05 | CL | Futures | 45.64 | 47.25 | 45.4 | 47.01 | 573168.0 |
| 2021-03-05 | GC | Futures | 1990.2 | 2002.4 | 1975.8 | 1994.0 | 269333.0 |
| 2021-03-05 | ZN | Futures | 132.720129 | 132.906621 | 132.160653 | 132.73567 | 9767.0 |
| 2021-03-05 | A6 | Futures | 0.79213 | 0.79264 | 0.78192 | 0.78879 | 160656.0 |
| 2021-03-05 | AD | Futures | 0.79961 | 0.80092 | 0.79515 | 0.79971 | 104583.0 |
| 2021-03-05 | ALI | Futures | 2559.74 | 2567.9 | 2533.81 | 2564.11 | 187.0 |
| 2021-03-05 | B | Futures | 42.99 | 44.61 | 42.68 | 44.4 | 361763.0 |
| 2021-03-05 | B6 | Futures | 1.4106 | 1.4122 | 1.3993 | 1.4058 | 105362.0 |
| 2021-03-05 | BFX | Futures | 3781.7 | 3796.8 | 3781.7 | 3796.8 | 1.0 |
| 2021-03-05 | BR | Futures | 0.14032 | 0.14043 | 0.13747 | 0.13838 | 913.0 |
| 2021-03-05 | BTC | Futures | 62496.6 | 64600.4 | 60120.1 | 64353.6 | 8929.0 |
| 2021-03-05 | BZ | Futures | 42.15 | 43.67 | 41.77 | 43.46 | 40754.0 |
| 2021-03-05 | C | Futures | 1676.0 | 1676.0 | 1639.0 | 1646.0 | 2291.0 |
| 2021-03-05 | CB | Futures | 146.145 | 147.136 | 146.145 | 146.764 | 32.0 |
| 2021-03-05 | CC | Futures | 1738.0 | 1747.0 | 1712.0 | 1716.0 | 24454.0 |
| 2021-03-05 | CNH | Futures | 6.3353 | 6.3715 | 6.326 | 6.3584 | 768.0 |
| 2021-03-05 | CSC | Futures | 2.861 | 2.886 | 2.857 | 2.875 | 58.0 |
| 2021-03-05 | CT | Futures | 82.45 | 83.16 | 81.06 | 83.04 | 18596.0 |
| 2021-03-05 | DC | Futures | 25.47 | 25.69 | 25.46 | 25.59 | 67.0 |
| 2021-03-05 | DX | Futures | 88.602 | 89.167 | 88.602 | 88.94 | 47694.0 |
| 2021-03-05 | E1 | Futures | 1.21484 | 1.21913 | 1.21112 | 1.21259 | 35201.0 |
| 2021-03-05 | E6 | Futures | 1.27858 | 1.2788 | 1.26999 | 1.27218 | 291503.0 |
| 2021-03-05 | E7 | Futures | 1.2723 | 1.2723 | 1.2637 | 1.2659 | 9346.0 |
| 2021-03-05 | EBM | Futures | 291.2 | 292.16 | 289.28 | 291.52 | 21154.0 |
| 2021-03-05 | ED | Futures | 96.5204 | 96.5228 | 96.5155 | 96.518 | 115888.0 |
| 2021-03-05 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 27361.0 |
| 2021-03-05 | ESG | Futures | 351.94 | 356.67 | 346.26 | 355.71 | 3178.0 |
| 2021-03-05 | EW | Futures | 2629.1 | 2692.6 | 2573.1 | 2686.5 | 13474.0 |
| 2021-03-05 | FBON | Futures | 147.56 | 147.89 | 147.42 | 147.72 | 702.0 |
| 2021-03-05 | FBTP | Futures | 137.42 | 138.12 | 137.42 | 137.82 | 214755.0 |
| 2021-03-05 | FBTS | Futures | 109.893 | 109.991 | 109.893 | 109.961 | 133463.0 |
| 2021-03-05 | FCE | Futures | 5640.1 | 5686.8 | 5594.9 | 5622.1 | 64003.0 |
| 2021-03-05 | FDAX | Futures | 14839.5 | 14994.0 | 14775.5 | 14830.9 | 92846.0 |
| 2021-03-05 | FDIV | Futures | 170.46 | 171.46 | 170.46 | 170.79 | 115.0 |
| 2021-03-05 | FDXM | Futures | 14808.5 | 14952.0 | 14734.1 | 14789.3 | 75088.0 |
| 2021-03-05 | FESX | Futures | 3402.9 | 3452.2 | 3387.1 | 3408.5 | 1118140.0 |
| 2021-03-05 | FGBL | Futures | 166.97 | 167.6 | 166.92 | 167.31 | 953510.0 |
| 2021-03-05 | FGBM | Futures | 134.58 | 134.76 | 134.54 | 134.65 | 527458.0 |
| 2021-03-05 | FGBS | Futures | 112.624 | 112.649 | 112.609 | 112.639 | 446136.0 |
| 2021-03-05 | FGBX | Futures | 219.63 | 220.89 | 219.12 | 220.33 | 91985.0 |
| 2021-03-05 | FMWO | Futures | 9534.7 | 9699.3 | 9434.0 | 9439.9 | 7050.0 |
| 2021-03-05 | FOAT | Futures | 155.4 | 155.85 | 155.28 | 155.63 | 198964.0 |
| 2021-03-05 | FTDX | Futures | 3344.9 | 3371.2 | 3306.7 | 3313.4 | 306.0 |
| 2021-03-05 | FTI | Futures | 610.09 | 621.47 | 608.18 | 611.78 | 24945.0 |
| 2021-03-05 | FTUK | Futures | 6317.0 | 6450.8 | 6295.3 | 6365.6 | 137525.0 |
| 2021-03-05 | FVSA | Futures | 159.4 | 161.38 | 142.97 | 160.72 | 60367.0 |
| 2021-03-05 | FXXP | Futures | 380.7 | 385.0 | 378.7 | 379.8 | 67963.0 |
> showing 50 of 121 rows — these rows as CSV