PREVIEW / futures_daily / 2021-10-05
file: by_date/futures_daily/2021/2021-10-05.parquet size: 10 KB rows: 123
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-10-05 | ES | Futures | 4832.25 | 4904.25 | 4802.16 | 4875.28 | 1650217.0 |
| 2021-10-05 | NQ | Futures | 16713.4 | 17014.37 | 16617.4 | 16899.63 | 574640.0 |
| 2021-10-05 | YM | Futures | 36873.4 | 37389.1 | 36649.3 | 37192.2 | 194338.0 |
| 2021-10-05 | CL | Futures | 57.13 | 58.53 | 57.05 | 58.12 | 449617.0 |
| 2021-10-05 | GC | Futures | 2065.9 | 2066.3 | 2040.0 | 2054.4 | 151424.0 |
| 2021-10-05 | ZN | Futures | 134.321695 | 134.353476 | 133.876763 | 133.972106 | 1485058.0 |
| 2021-10-05 | A6 | Futures | 0.74778 | 0.74865 | 0.74337 | 0.74767 | 76271.0 |
| 2021-10-05 | AD | Futures | 0.80648 | 0.80917 | 0.80379 | 0.80709 | 69591.0 |
| 2021-10-05 | ALI | Futures | 3319.03 | 3336.21 | 3299.31 | 3329.45 | 1476.0 |
| 2021-10-05 | B | Futures | 55.06 | 56.32 | 55.0 | 55.93 | 340269.0 |
| 2021-10-05 | B6 | Futures | 1.3811 | 1.3854 | 1.379 | 1.3835 | 77821.0 |
| 2021-10-05 | BR | Futures | 0.1478 | 0.14816 | 0.14662 | 0.14707 | 128.0 |
| 2021-10-05 | BTC | Futures | 65564.1 | 69360.2 | 65284.9 | 68648.9 | 8408.0 |
| 2021-10-05 | BZ | Futures | 53.78 | 55.0 | 53.73 | 54.63 | 44439.0 |
| 2021-10-05 | C | Futures | 1650.0 | 1657.0 | 1626.0 | 1633.0 | 8032.0 |
| 2021-10-05 | CB | Futures | 138.293 | 139.514 | 138.293 | 139.514 | 18.0 |
| 2021-10-05 | CC | Futures | 1774.0 | 1777.0 | 1745.0 | 1769.0 | 21110.0 |
| 2021-10-05 | CNH | Futures | 6.2075 | 6.216 | 6.2036 | 6.2053 | 176.0 |
| 2021-10-05 | CSC | Futures | 2.509 | 2.516 | 2.509 | 2.511 | 44.0 |
| 2021-10-05 | CT | Futures | 98.0 | 101.67 | 98.0 | 101.67 | 17546.0 |
| 2021-10-05 | DC | Futures | 23.26 | 23.4 | 23.22 | 23.35 | 114.0 |
| 2021-10-05 | DX | Futures | 90.685 | 90.897 | 90.646 | 90.793 | 18794.0 |
| 2021-10-05 | E1 | Futures | 1.21351 | 1.21418 | 1.2078 | 1.20914 | 19573.0 |
| 2021-10-05 | E6 | Futures | 1.23603 | 1.2365 | 1.23204 | 1.2338 | 134068.0 |
| 2021-10-05 | E7 | Futures | 1.2294 | 1.2296 | 1.2254 | 1.2271 | 2737.0 |
| 2021-10-05 | EBM | Futures | 389.44 | 389.44 | 383.93 | 386.13 | 23705.0 |
| 2021-10-05 | ED | Futures | 96.5634 | 96.5634 | 96.5537 | 96.5634 | 119581.0 |
| 2021-10-05 | ER | Futures | 98.48 | 98.484 | 98.475 | 98.48 | 33137.0 |
| 2021-10-05 | ESG | Futures | 400.18 | 404.82 | 399.83 | 402.52 | 324.0 |
| 2021-10-05 | EW | Futures | 2871.9 | 2895.0 | 2848.1 | 2867.3 | 12022.0 |
| 2021-10-05 | FBON | Futures | 149.12 | 149.45 | 148.82 | 148.84 | 1039.0 |
| 2021-10-05 | FBTP | Futures | 138.73 | 139.08 | 138.27 | 138.34 | 120504.0 |
| 2021-10-05 | FBTS | Futures | 110.38 | 110.439 | 110.371 | 110.38 | 47319.0 |
| 2021-10-05 | FCE | Futures | 6503.4 | 6594.6 | 6487.4 | 6589.6 | 53693.0 |
| 2021-10-05 | FDAX | Futures | 16102.2 | 16235.8 | 16006.0 | 16226.1 | 65015.0 |
| 2021-10-05 | FDIV | Futures | 181.32 | 182.65 | 181.32 | 182.65 | 35.0 |
| 2021-10-05 | FDXM | Futures | 16149.0 | 16282.0 | 16050.4 | 16272.3 | 49643.0 |
| 2021-10-05 | FDXS | Futures | 15984.2 | 16130.8 | 15903.5 | 16121.2 | 17322.0 |
| 2021-10-05 | FESX | Futures | 3825.8 | 3881.8 | 3799.9 | 3878.4 | 712187.0 |
| 2021-10-05 | FGBL | Futures | 167.66 | 167.87 | 167.13 | 167.15 | 704297.0 |
| 2021-10-05 | FGBM | Futures | 134.76 | 134.87 | 134.62 | 134.64 | 411904.0 |
| 2021-10-05 | FGBS | Futures | 112.659 | 112.679 | 112.639 | 112.649 | 187290.0 |
| 2021-10-05 | FGBX | Futures | 219.98 | 220.74 | 218.38 | 218.45 | 70580.0 |
| 2021-10-05 | FMWO | Futures | 10611.7 | 10759.1 | 10604.6 | 10750.8 | 2263.0 |
| 2021-10-05 | FOAT | Futures | 155.17 | 155.43 | 154.72 | 154.75 | 139998.0 |
| 2021-10-05 | FTDX | Futures | 3723.0 | 3775.3 | 3721.4 | 3771.7 | 51.0 |
| 2021-10-05 | FTI | Futures | 724.5 | 736.77 | 723.12 | 736.14 | 18356.0 |
| 2021-10-05 | FTUK | Futures | 6935.1 | 6971.2 | 6890.7 | 6966.2 | 79087.0 |
| 2021-10-05 | FVSA | Futures | 89.04 | 91.29 | 83.03 | 83.78 | 28076.0 |
| 2021-10-05 | FXXP | Futures | 429.6 | 433.8 | 428.2 | 433.3 | 66001.0 |
> showing 50 of 123 rows — these rows as CSV