PREVIEW / futures_daily / 2020-11-02
file: by_date/futures_daily/2020/2020-11-02.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-11-02 | ES | Futures | 3662.55 | 3733.89 | 3643.73 | 3708.05 | 1849320.0 |
| 2020-11-02 | NQ | Futures | 12774.74 | 12980.23 | 12667.94 | 12808.02 | 602651.0 |
| 2020-11-02 | YM | Futures | 28391.5 | 29000.9 | 28176.2 | 28848.0 | 218401.0 |
| 2020-11-02 | CL | Futures | 25.12 | 26.48 | 23.98 | 26.24 | 489204.0 |
| 2020-11-02 | GC | Futures | 2216.8 | 2240.5 | 2212.4 | 2235.1 | 164943.0 |
| 2020-11-02 | ZN | Futures | 137.040439 | 137.35038 | 137.009445 | 137.164415 | 1439099.0 |
| 2020-11-02 | A6 | Futures | 0.72075 | 0.72465 | 0.71777 | 0.72373 | 88084.0 |
| 2020-11-02 | AD | Futures | 0.7612 | 0.76693 | 0.75806 | 0.76597 | 78382.0 |
| 2020-11-02 | ALI | Futures | 2200.13 | 2240.7 | 2199.83 | 2240.11 | 83.0 |
| 2020-11-02 | B | Futures | 23.55 | 24.8 | 22.52 | 24.55 | 326074.0 |
| 2020-11-02 | B6 | Futures | 1.3118 | 1.3128 | 1.3035 | 1.3085 | 82566.0 |
| 2020-11-02 | BR | Futures | 0.13562 | 0.13719 | 0.13558 | 0.13613 | 8387.0 |
| 2020-11-02 | BTC | Futures | 18416.8 | 18562.0 | 17644.8 | 18199.0 | 5042.0 |
| 2020-11-02 | BZ | Futures | 23.08 | 24.27 | 22.04 | 24.04 | 40454.0 |
| 2020-11-02 | C | Futures | 1426.0 | 1430.0 | 1399.0 | 1403.0 | 7136.0 |
| 2020-11-02 | CB | Futures | 152.459 | 155.0 | 152.459 | 152.459 | 6.0 |
| 2020-11-02 | CC | Futures | 1491.0 | 1500.0 | 1469.0 | 1482.0 | 21164.0 |
| 2020-11-02 | CNH | Futures | 6.5728 | 6.5792 | 6.5617 | 6.5664 | 1215.0 |
| 2020-11-02 | CSC | Futures | 3.952 | 3.952 | 3.86 | 3.895 | 67.0 |
| 2020-11-02 | CT | Futures | 67.94 | 68.28 | 67.26 | 67.92 | 17855.0 |
| 2020-11-02 | DC | Futures | 32.52 | 32.65 | 31.45 | 32.03 | 425.0 |
| 2020-11-02 | DX | Futures | 90.892 | 91.105 | 90.791 | 90.941 | 14746.0 |
| 2020-11-02 | E1 | Futures | 1.2365 | 1.23684 | 1.23129 | 1.23209 | 17274.0 |
| 2020-11-02 | E6 | Futures | 1.24849 | 1.24977 | 1.24602 | 1.24709 | 132536.0 |
| 2020-11-02 | E7 | Futures | 1.2419 | 1.2434 | 1.2397 | 1.2407 | 4493.0 |
| 2020-11-02 | EBM | Futures | 246.53 | 248.04 | 244.42 | 247.13 | 21777.0 |
| 2020-11-02 | ED | Futures | 96.4939 | 96.4939 | 96.489 | 96.489 | 54880.0 |
| 2020-11-02 | ER | Futures | 98.46 | 98.465 | 98.455 | 98.46 | 48951.0 |
| 2020-11-02 | ESG | Futures | 307.57 | 308.3 | 304.12 | 306.46 | 844.0 |
| 2020-11-02 | EW | Futures | 2026.2 | 2068.6 | 2013.0 | 2065.5 | 14994.0 |
| 2020-11-02 | FBON | Futures | 149.39 | 149.63 | 149.16 | 149.51 | 260.0 |
| 2020-11-02 | FBTP | Futures | 136.83 | 137.08 | 136.47 | 136.96 | 99435.0 |
| 2020-11-02 | FBTS | Futures | 109.691 | 109.778 | 109.672 | 109.759 | 72054.0 |
| 2020-11-02 | FCE | Futures | 4452.5 | 4548.2 | 4424.9 | 4532.2 | 75451.0 |
| 2020-11-02 | FDAX | Futures | 12301.5 | 12612.8 | 12257.8 | 12543.0 | 84497.0 |
| 2020-11-02 | FDIV | Futures | 139.24 | 139.24 | 138.39 | 138.72 | 150.0 |
| 2020-11-02 | FDXM | Futures | 12236.3 | 12548.1 | 12199.1 | 12479.7 | 61428.0 |
| 2020-11-02 | FESX | Futures | 2726.4 | 2800.3 | 2716.2 | 2785.5 | 1023097.0 |
| 2020-11-02 | FEU3 | Futures | 99.198 | 99.203 | 99.198 | 99.203 | 25.0 |
| 2020-11-02 | FGBL | Futures | 171.41 | 171.51 | 171.06 | 171.4 | 529997.0 |
| 2020-11-02 | FGBM | Futures | 135.83 | 135.86 | 135.71 | 135.81 | 280077.0 |
| 2020-11-02 | FGBS | Futures | 112.94 | 112.955 | 112.92 | 112.94 | 373668.0 |
| 2020-11-02 | FGBX | Futures | 238.8 | 239.3 | 237.82 | 238.96 | 62663.0 |
| 2020-11-02 | FMWO | Futures | 8054.1 | 8205.7 | 7973.6 | 8171.4 | 3665.0 |
| 2020-11-02 | FOAT | Futures | 159.23 | 159.32 | 158.94 | 159.22 | 160047.0 |
| 2020-11-02 | FTDX | Futures | 2907.9 | 2929.0 | 2897.6 | 2912.5 | 199.0 |
| 2020-11-02 | FTI | Futures | 494.8 | 505.71 | 493.32 | 503.88 | 26392.0 |
| 2020-11-02 | FTUK | Futures | 5284.8 | 5396.7 | 5280.5 | 5383.3 | 108853.0 |
| 2020-11-02 | FVSA | Futures | 226.89 | 230.82 | 213.29 | 219.01 | 29342.0 |
| 2020-11-02 | FXXP | Futures | 315.3 | 322.3 | 315.3 | 321.2 | 82290.0 |
> showing 50 of 121 rows — these rows as CSV