PREVIEW / futures_daily / 2021-02-18
file: by_date/futures_daily/2021/2021-02-18.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-02-18 | ES | Futures | 4402.79 | 4411.48 | 4349.27 | 4381.78 | 1536949.0 |
| 2021-02-18 | NQ | Futures | 15801.26 | 15828.66 | 15534.25 | 15724.56 | 574576.0 |
| 2021-02-18 | YM | Futures | 34076.9 | 34160.0 | 33723.7 | 33943.0 | 194049.0 |
| 2021-02-18 | CL | Futures | 43.9 | 44.31 | 42.54 | 43.06 | 538433.0 |
| 2021-02-18 | GC | Futures | 2085.0 | 2100.0 | 2073.9 | 2083.8 | 224767.0 |
| 2021-02-18 | ZN | Futures | 135.22223 | 135.331017 | 134.895869 | 135.128984 | 2072926.0 |
| 2021-02-18 | A6 | Futures | 0.79531 | 0.79915 | 0.7931 | 0.7969 | 106367.0 |
| 2021-02-18 | AD | Futures | 0.79738 | 0.79971 | 0.79561 | 0.7988 | 70518.0 |
| 2021-02-18 | ALI | Futures | 2532.94 | 2542.55 | 2519.25 | 2520.12 | 77.0 |
| 2021-02-18 | B | Futures | 41.29 | 41.6 | 40.14 | 40.6 | 420556.0 |
| 2021-02-18 | B6 | Futures | 1.4075 | 1.4204 | 1.4055 | 1.4193 | 106123.0 |
| 2021-02-18 | BFX | Futures | 3821.5 | 3822.0 | 3803.3 | 3803.8 | 32.0 |
| 2021-02-18 | BR | Futures | 0.14357 | 0.14482 | 0.14302 | 0.14353 | 4083.0 |
| 2021-02-18 | BTC | Futures | 70658.3 | 71194.8 | 68740.3 | 70202.3 | 8340.0 |
| 2021-02-18 | BZ | Futures | 40.38 | 40.76 | 39.36 | 39.79 | 43309.0 |
| 2021-02-18 | C | Futures | 1494.0 | 1497.0 | 1490.0 | 1493.0 | 2723.0 |
| 2021-02-18 | CB | Futures | 147.7 | 147.7 | 144.886 | 144.886 | 8.0 |
| 2021-02-18 | CC | Futures | 1608.0 | 1634.0 | 1605.0 | 1611.0 | 16491.0 |
| 2021-02-18 | CNH | Futures | 6.2882 | 6.3239 | 6.2857 | 6.3156 | 500.0 |
| 2021-02-18 | CSC | Futures | 2.873 | 2.875 | 2.821 | 2.842 | 145.0 |
| 2021-02-18 | CT | Futures | 85.37 | 86.21 | 85.02 | 85.73 | 5404.0 |
| 2021-02-18 | DC | Futures | 25.05 | 25.11 | 24.59 | 24.71 | 291.0 |
| 2021-02-18 | DX | Futures | 87.857 | 87.978 | 87.533 | 87.596 | 32788.0 |
| 2021-02-18 | E1 | Futures | 1.2566 | 1.26066 | 1.25513 | 1.25965 | 20238.0 |
| 2021-02-18 | E6 | Futures | 1.28643 | 1.29198 | 1.28563 | 1.29102 | 176081.0 |
| 2021-02-18 | E7 | Futures | 1.28 | 1.2855 | 1.2792 | 1.2847 | 5868.0 |
| 2021-02-18 | EBM | Futures | 282.88 | 293.35 | 282.88 | 292.74 | 31074.0 |
| 2021-02-18 | ED | Futures | 96.5373 | 96.5421 | 96.5349 | 96.5397 | 167783.0 |
| 2021-02-18 | ER | Futures | 98.455 | 98.46 | 98.455 | 98.46 | 19381.0 |
| 2021-02-18 | ESG | Futures | 362.07 | 362.33 | 359.09 | 361.53 | 186.0 |
| 2021-02-18 | EW | Futures | 2702.6 | 2709.0 | 2657.1 | 2670.4 | 7665.0 |
| 2021-02-18 | FBON | Futures | 148.41 | 148.45 | 147.6 | 147.91 | 1509.0 |
| 2021-02-18 | FBTP | Futures | 138.91 | 139.09 | 137.97 | 138.31 | 191460.0 |
| 2021-02-18 | FBTS | Futures | 109.903 | 109.952 | 109.777 | 109.845 | 135239.0 |
| 2021-02-18 | FCE | Futures | 5608.5 | 5616.3 | 5558.9 | 5567.2 | 43612.0 |
| 2021-02-18 | FDAX | Futures | 14888.5 | 14898.1 | 14759.5 | 14800.0 | 63075.0 |
| 2021-02-18 | FDIV | Futures | 168.07 | 168.21 | 167.3 | 167.3 | 135.0 |
| 2021-02-18 | FDXM | Futures | 14844.6 | 14852.1 | 14718.1 | 14758.5 | 52273.0 |
| 2021-02-18 | FESX | Futures | 3450.4 | 3453.2 | 3409.5 | 3416.9 | 862842.0 |
| 2021-02-18 | FGBL | Futures | 167.78 | 167.92 | 167.07 | 167.36 | 1022728.0 |
| 2021-02-18 | FGBM | Futures | 134.73 | 134.77 | 134.5 | 134.58 | 555065.0 |
| 2021-02-18 | FGBS | Futures | 112.649 | 112.659 | 112.614 | 112.634 | 289788.0 |
| 2021-02-18 | FGBX | Futures | 222.31 | 223.15 | 220.07 | 221.22 | 126693.0 |
| 2021-02-18 | FMWO | Futures | 9949.3 | 9949.3 | 9845.1 | 9878.2 | 4822.0 |
| 2021-02-18 | FOAT | Futures | 156.2 | 156.36 | 155.36 | 155.62 | 375026.0 |
| 2021-02-18 | FTDX | Futures | 3643.3 | 3668.1 | 3601.1 | 3611.9 | 87.0 |
| 2021-02-18 | FTI | Futures | 638.59 | 638.92 | 626.52 | 628.86 | 16201.0 |
| 2021-02-18 | FTUK | Futures | 6433.5 | 6446.5 | 6309.3 | 6327.6 | 121913.0 |
| 2021-02-18 | FVSA | Futures | 149.87 | 154.15 | 148.23 | 151.19 | 31475.0 |
| 2021-02-18 | FXXP | Futures | 385.9 | 387.4 | 382.3 | 383.1 | 45946.0 |
> showing 50 of 122 rows — these rows as CSV