PREVIEW / futures_daily / 2021-01-14
file: by_date/futures_daily/2021/2021-01-14.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-01-14 | ES | Futures | 4268.58 | 4278.94 | 4243.64 | 4249.24 | 1170812.0 |
| 2021-01-14 | NQ | Futures | 14966.19 | 15027.61 | 14857.19 | 14880.26 | 417583.0 |
| 2021-01-14 | YM | Futures | 33466.7 | 33602.8 | 33350.1 | 33379.2 | 127416.0 |
| 2021-01-14 | CL | Futures | 37.35 | 37.99 | 36.94 | 37.87 | 320723.0 |
| 2021-01-14 | GC | Futures | 2170.8 | 2184.9 | 2148.4 | 2177.6 | 257661.0 |
| 2021-01-14 | ZN | Futures | 136.061444 | 136.139149 | 135.766165 | 135.828329 | 1704013.0 |
| 2021-01-14 | A6 | Futures | 0.79372 | 0.80095 | 0.7931 | 0.79885 | 96086.0 |
| 2021-01-14 | AD | Futures | 0.79783 | 0.80249 | 0.79723 | 0.80173 | 65429.0 |
| 2021-01-14 | ALI | Futures | 2350.56 | 2350.56 | 2350.56 | 2350.56 | 0.0 |
| 2021-01-14 | B | Futures | 35.32 | 35.73 | 34.89 | 35.63 | 331293.0 |
| 2021-01-14 | B6 | Futures | 1.3852 | 1.3929 | 1.3831 | 1.3899 | 74106.0 |
| 2021-01-14 | BFX | Futures | 3762.5 | 3766.1 | 3762.5 | 3766.1 | 12.0 |
| 2021-01-14 | BR | Futures | 0.1472 | 0.15012 | 0.1472 | 0.14997 | 620.0 |
| 2021-01-14 | BTC | Futures | 48769.9 | 52496.0 | 48009.1 | 51507.6 | 10507.0 |
| 2021-01-14 | BZ | Futures | 34.62 | 34.99 | 34.18 | 34.91 | 33446.0 |
| 2021-01-14 | C | Futures | 1455.0 | 1457.0 | 1436.0 | 1446.0 | 6490.0 |
| 2021-01-14 | CB | Futures | 146.962 | 148.577 | 146.962 | 148.577 | 23.0 |
| 2021-01-14 | CC | Futures | 1639.0 | 1655.0 | 1619.0 | 1643.0 | 16723.0 |
| 2021-01-14 | CNH | Futures | 6.3226 | 6.3361 | 6.3195 | 6.329 | 360.0 |
| 2021-01-14 | CSC | Futures | 3.272 | 3.406 | 3.237 | 3.305 | 72.0 |
| 2021-01-14 | CT | Futures | 78.18 | 78.76 | 77.53 | 78.4 | 12643.0 |
| 2021-01-14 | DC | Futures | 27.95 | 29.19 | 27.73 | 28.28 | 257.0 |
| 2021-01-14 | DX | Futures | 87.296 | 87.567 | 87.055 | 87.224 | 23812.0 |
| 2021-01-14 | E1 | Futures | 1.27341 | 1.27635 | 1.26755 | 1.27308 | 21781.0 |
| 2021-01-14 | E6 | Futures | 1.29988 | 1.30207 | 1.2946 | 1.29946 | 166280.0 |
| 2021-01-14 | E7 | Futures | 1.2933 | 1.2955 | 1.2883 | 1.293 | 7717.0 |
| 2021-01-14 | EBM | Futures | 279.49 | 283.8 | 278.87 | 283.19 | 23902.0 |
| 2021-01-14 | ED | Futures | 96.5131 | 96.518 | 96.5083 | 96.518 | 96657.0 |
| 2021-01-14 | ER | Futures | 98.46 | 98.47 | 98.46 | 98.47 | 53581.0 |
| 2021-01-14 | ESG | Futures | 352.31 | 352.31 | 349.41 | 349.92 | 894.0 |
| 2021-01-14 | EW | Futures | 2600.1 | 2633.0 | 2592.8 | 2617.8 | 13446.0 |
| 2021-01-14 | FBON | Futures | 150.37 | 150.52 | 150.14 | 150.43 | 538.0 |
| 2021-01-14 | FBTP | Futures | 138.38 | 138.73 | 137.85 | 138.11 | 233402.0 |
| 2021-01-14 | FBTS | Futures | 109.893 | 109.932 | 109.718 | 109.796 | 136757.0 |
| 2021-01-14 | FCE | Futures | 5509.3 | 5518.5 | 5484.6 | 5508.8 | 45921.0 |
| 2021-01-14 | FDAX | Futures | 14878.9 | 14947.1 | 14844.8 | 14900.2 | 44654.0 |
| 2021-01-14 | FDIV | Futures | 167.07 | 167.5 | 167.07 | 167.16 | 730.0 |
| 2021-01-14 | FDXM | Futures | 14829.7 | 14903.1 | 14806.3 | 14858.4 | 30321.0 |
| 2021-01-14 | FESX | Futures | 3356.5 | 3379.7 | 3353.7 | 3374.1 | 705085.0 |
| 2021-01-14 | FGBL | Futures | 170.05 | 170.5 | 169.89 | 170.39 | 748879.0 |
| 2021-01-14 | FGBM | Futures | 135.14 | 135.31 | 135.08 | 135.3 | 525450.0 |
| 2021-01-14 | FGBS | Futures | 112.699 | 112.739 | 112.684 | 112.734 | 428703.0 |
| 2021-01-14 | FGBX | Futures | 234.6 | 235.96 | 233.76 | 235.42 | 78518.0 |
| 2021-01-14 | FMWO | Futures | 9704.1 | 9718.3 | 9665.0 | 9710.0 | 2149.0 |
| 2021-01-14 | FOAT | Futures | 158.61 | 158.86 | 158.4 | 158.8 | 162578.0 |
| 2021-01-14 | FTDX | Futures | 3397.4 | 3397.4 | 3383.0 | 3386.1 | 20.0 |
| 2021-01-14 | FTI | Futures | 604.78 | 615.65 | 604.78 | 614.87 | 15287.0 |
| 2021-01-14 | FTUK | Futures | 6461.0 | 6516.8 | 6445.1 | 6502.4 | 82286.0 |
| 2021-01-14 | FVSA | Futures | 158.08 | 160.92 | 156.66 | 157.01 | 12644.0 |
| 2021-01-14 | FXXP | Futures | 380.0 | 382.7 | 379.9 | 382.1 | 65764.0 |
> showing 50 of 122 rows — these rows as CSV