PREVIEW / futures_daily / 2020-12-22
file: by_date/futures_daily/2020/2020-12-22.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 |
|---|---|---|---|---|---|---|---|
| 2020-12-22 | ES | Futures | 4130.16 | 4141.36 | 4106.34 | 4121.47 | 1104998.0 |
| 2020-12-22 | NQ | Futures | 14646.4 | 14717.63 | 14525.58 | 14659.96 | 457270.0 |
| 2020-12-22 | YM | Futures | 32505.6 | 32559.6 | 32266.9 | 32302.6 | 153134.0 |
| 2020-12-22 | CL | Futures | 33.84 | 33.86 | 32.9 | 33.19 | 295737.0 |
| 2020-12-22 | GC | Futures | 2214.8 | 2222.3 | 2192.1 | 2199.8 | 176016.0 |
| 2020-12-22 | ZN | Futures | 137.056068 | 137.258101 | 137.024986 | 137.24256 | 795131.0 |
| 2020-12-22 | A6 | Futures | 0.77884 | 0.77966 | 0.77228 | 0.77377 | 99067.0 |
| 2020-12-22 | AD | Futures | 0.78831 | 0.78923 | 0.78381 | 0.78578 | 64625.0 |
| 2020-12-22 | ALI | Futures | 2350.85 | 2350.85 | 2350.85 | 2350.85 | 8.0 |
| 2020-12-22 | B | Futures | 32.01 | 32.14 | 31.32 | 31.65 | 194100.0 |
| 2020-12-22 | B6 | Futures | 1.3678 | 1.3694 | 1.3526 | 1.3577 | 124565.0 |
| 2020-12-22 | BR | Futures | 0.15098 | 0.15199 | 0.1509 | 0.15106 | 8.0 |
| 2020-12-22 | BTC | Futures | 30301.8 | 30803.4 | 29220.6 | 30542.8 | 11075.0 |
| 2020-12-22 | BZ | Futures | 31.46 | 31.48 | 30.63 | 30.95 | 22381.0 |
| 2020-12-22 | C | Futures | 1473.0 | 1473.0 | 1432.0 | 1456.0 | 6482.0 |
| 2020-12-22 | CB | Futures | 150.815 | 153.653 | 150.815 | 153.653 | 14.0 |
| 2020-12-22 | CC | Futures | 1695.0 | 1695.0 | 1646.0 | 1666.0 | 18740.0 |
| 2020-12-22 | CNH | Futures | 6.4109 | 6.4198 | 6.402 | 6.4149 | 1030.0 |
| 2020-12-22 | CSC | Futures | 3.064 | 3.138 | 3.064 | 3.138 | 50.0 |
| 2020-12-22 | CT | Futures | 72.23 | 72.67 | 71.77 | 72.29 | 14575.0 |
| 2020-12-22 | DC | Futures | 25.68 | 26.61 | 25.68 | 26.61 | 220.0 |
| 2020-12-22 | DX | Futures | 87.113 | 87.615 | 86.968 | 87.544 | 21871.0 |
| 2020-12-22 | E1 | Futures | 1.27748 | 1.27985 | 1.27138 | 1.27195 | 15815.0 |
| 2020-12-22 | E6 | Futures | 1.31019 | 1.31227 | 1.301 | 1.30197 | 186565.0 |
| 2020-12-22 | E7 | Futures | 1.3039 | 1.3057 | 1.2946 | 1.2955 | 8567.0 |
| 2020-12-22 | EBM | Futures | 255.76 | 258.53 | 255.45 | 257.61 | 10419.0 |
| 2020-12-22 | ED | Futures | 96.5228 | 96.5228 | 96.518 | 96.518 | 42618.0 |
| 2020-12-22 | ER | Futures | 98.46 | 98.47 | 98.455 | 98.46 | 46307.0 |
| 2020-12-22 | ESG | Futures | 340.29 | 342.66 | 339.83 | 340.83 | 2639.0 |
| 2020-12-22 | EW | Futures | 2437.7 | 2453.8 | 2413.8 | 2448.3 | 13908.0 |
| 2020-12-22 | FBON | Futures | 150.83 | 150.94 | 150.47 | 150.85 | 58.0 |
| 2020-12-22 | FBTP | Futures | 138.8 | 139.14 | 138.52 | 138.99 | 54629.0 |
| 2020-12-22 | FBTS | Futures | 110.02 | 110.078 | 109.99 | 110.058 | 25705.0 |
| 2020-12-22 | FCE | Futures | 5232.8 | 5313.0 | 5224.1 | 5301.3 | 58282.0 |
| 2020-12-22 | FDAX | Futures | 14285.1 | 14315.0 | 14091.1 | 14293.6 | 38604.0 |
| 2020-12-22 | FDXM | Futures | 14232.3 | 14273.7 | 14051.6 | 14253.6 | 19385.0 |
| 2020-12-22 | FESX | Futures | 3230.9 | 3240.2 | 3189.1 | 3236.5 | 660595.0 |
| 2020-12-22 | FEU3 | Futures | 99.208 | 99.208 | 99.203 | 99.203 | 127.0 |
| 2020-12-22 | FGBL | Futures | 170.25 | 170.63 | 170.19 | 170.47 | 344003.0 |
| 2020-12-22 | FGBM | Futures | 135.24 | 135.36 | 135.22 | 135.26 | 187113.0 |
| 2020-12-22 | FGBS | Futures | 112.739 | 112.764 | 112.724 | 112.724 | 190192.0 |
| 2020-12-22 | FGBX | Futures | 236.05 | 237.68 | 235.96 | 237.18 | 36079.0 |
| 2020-12-22 | FMWO | Futures | 9294.2 | 9365.2 | 9294.2 | 9336.8 | 2340.0 |
| 2020-12-22 | FOAT | Futures | 158.75 | 159.07 | 158.61 | 158.93 | 82465.0 |
| 2020-12-22 | FTDX | Futures | 3263.9 | 3272.2 | 3257.2 | 3270.6 | 75.0 |
| 2020-12-22 | FTI | Futures | 569.69 | 577.63 | 568.76 | 576.31 | 17008.0 |
| 2020-12-22 | FTUK | Futures | 6125.3 | 6181.2 | 6088.7 | 6169.6 | 75292.0 |
| 2020-12-22 | FVSA | Futures | 185.35 | 189.12 | 178.93 | 179.68 | 18110.0 |
| 2020-12-22 | FXXP | Futures | 362.1 | 363.6 | 358.6 | 362.9 | 61846.0 |
| 2020-12-22 | G | Futures | 127.09 | 127.45 | 126.82 | 127.34 | 149361.0 |
> showing 50 of 121 rows — these rows as CSV