PREVIEW / futures_daily / 2021-01-20
file: by_date/futures_daily/2021/2021-01-20.parquet size: 10 KB rows: 120
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-20 | ES | Futures | 4255.41 | 4317.89 | 4246.16 | 4309.48 | 1248787.0 |
| 2021-01-20 | NQ | Futures | 15029.05 | 15371.62 | 15014.06 | 15333.84 | 438765.0 |
| 2021-01-20 | YM | Futures | 33315.5 | 33622.2 | 33231.3 | 33581.2 | 140795.0 |
| 2021-01-20 | CL | Futures | 37.47 | 38.02 | 37.31 | 37.65 | 400301.0 |
| 2021-01-20 | GC | Futures | 2164.1 | 2201.8 | 2153.7 | 2195.4 | 274396.0 |
| 2021-01-20 | ZN | Futures | 136.216854 | 136.325641 | 136.061444 | 136.232395 | 1255751.0 |
| 2021-01-20 | A6 | Futures | 0.78967 | 0.79639 | 0.78951 | 0.79469 | 87543.0 |
| 2021-01-20 | AD | Futures | 0.79576 | 0.80371 | 0.79545 | 0.80128 | 83470.0 |
| 2021-01-20 | ALI | Futures | 2319.09 | 2331.91 | 2318.8 | 2320.26 | 91.0 |
| 2021-01-20 | B | Futures | 35.41 | 35.77 | 35.15 | 35.42 | 310886.0 |
| 2021-01-20 | B6 | Futures | 1.3852 | 1.3936 | 1.3838 | 1.3861 | 84373.0 |
| 2021-01-20 | BR | Futures | 0.14618 | 0.14735 | 0.14599 | 0.1463 | 476.0 |
| 2021-01-20 | BTC | Futures | 47729.5 | 47918.1 | 43483.3 | 45564.1 | 9615.0 |
| 2021-01-20 | BZ | Futures | 34.59 | 35.04 | 34.44 | 34.7 | 33793.0 |
| 2021-01-20 | C | Futures | 1508.0 | 1516.0 | 1494.0 | 1503.0 | 7261.0 |
| 2021-01-20 | CB | Futures | 146.731 | 147.654 | 146.731 | 146.731 | 18.0 |
| 2021-01-20 | CC | Futures | 1708.0 | 1725.0 | 1680.0 | 1688.0 | 20172.0 |
| 2021-01-20 | CNH | Futures | 6.3387 | 6.3418 | 6.3239 | 6.3254 | 569.0 |
| 2021-01-20 | CSC | Futures | 3.225 | 3.225 | 3.104 | 3.125 | 203.0 |
| 2021-01-20 | CT | Futures | 78.26 | 78.98 | 77.87 | 78.83 | 15919.0 |
| 2021-01-20 | DC | Futures | 28.05 | 28.05 | 26.75 | 26.99 | 664.0 |
| 2021-01-20 | DX | Futures | 87.383 | 87.683 | 87.258 | 87.469 | 24985.0 |
| 2021-01-20 | E1 | Futures | 1.27206 | 1.27466 | 1.26698 | 1.27025 | 17271.0 |
| 2021-01-20 | E6 | Futures | 1.29673 | 1.29983 | 1.29097 | 1.29422 | 145166.0 |
| 2021-01-20 | E7 | Futures | 1.2899 | 1.2933 | 1.2846 | 1.2878 | 6509.0 |
| 2021-01-20 | EBM | Futures | 287.19 | 290.58 | 285.34 | 288.42 | 36792.0 |
| 2021-01-20 | ED | Futures | 96.5131 | 96.518 | 96.5035 | 96.5083 | 260831.0 |
| 2021-01-20 | ER | Futures | 98.47 | 98.47 | 98.465 | 98.47 | 10504.0 |
| 2021-01-20 | ESG | Futures | 351.29 | 356.1 | 351.11 | 355.64 | 632.0 |
| 2021-01-20 | EW | Futures | 2609.5 | 2640.9 | 2602.7 | 2639.3 | 14302.0 |
| 2021-01-20 | FBON | Futures | 150.42 | 150.53 | 150.16 | 150.27 | 387.0 |
| 2021-01-20 | FBTP | Futures | 139.03 | 139.24 | 138.38 | 138.52 | 138190.0 |
| 2021-01-20 | FBTS | Futures | 109.971 | 110.01 | 109.854 | 109.893 | 103066.0 |
| 2021-01-20 | FCE | Futures | 5439.9 | 5476.3 | 5431.7 | 5458.4 | 52396.0 |
| 2021-01-20 | FDAX | Futures | 14780.8 | 14881.0 | 14695.5 | 14821.3 | 40867.0 |
| 2021-01-20 | FDIV | Futures | 166.21 | 166.45 | 166.21 | 166.45 | 104.0 |
| 2021-01-20 | FDXM | Futures | 14736.2 | 14834.0 | 14654.3 | 14779.8 | 31080.0 |
| 2021-01-20 | FESX | Futures | 3350.9 | 3370.4 | 3331.4 | 3358.3 | 653505.0 |
| 2021-01-20 | FGBL | Futures | 169.9 | 170.06 | 169.82 | 170.01 | 507767.0 |
| 2021-01-20 | FGBM | Futures | 135.13 | 135.17 | 135.08 | 135.16 | 277902.0 |
| 2021-01-20 | FGBS | Futures | 112.694 | 112.699 | 112.674 | 112.689 | 288251.0 |
| 2021-01-20 | FGBX | Futures | 233.79 | 234.16 | 233.16 | 233.87 | 79160.0 |
| 2021-01-20 | FMWO | Futures | 9647.2 | 9769.2 | 9647.2 | 9721.8 | 2926.0 |
| 2021-01-20 | FOAT | Futures | 158.42 | 158.56 | 158.31 | 158.44 | 145833.0 |
| 2021-01-20 | FTDX | Futures | 3427.9 | 3459.8 | 3425.8 | 3453.6 | 135.0 |
| 2021-01-20 | FTI | Futures | 614.2 | 619.64 | 612.7 | 617.35 | 18617.0 |
| 2021-01-20 | FTUK | Futures | 6433.5 | 6468.7 | 6404.1 | 6441.2 | 94959.0 |
| 2021-01-20 | FVSA | Futures | 160.57 | 160.92 | 155.95 | 158.79 | 16948.0 |
| 2021-01-20 | FXXP | Futures | 380.0 | 382.7 | 379.0 | 381.1 | 32184.0 |
| 2021-01-20 | G | Futures | 126.22 | 126.33 | 126.07 | 126.15 | 196819.0 |
> showing 50 of 120 rows — these rows as CSV