PREVIEW / futures_daily / 2020-02-26
file: by_date/futures_daily/2020/2020-02-26.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-02-26 | ES | Futures | 3389.08 | 3436.6 | 3338.32 | 3359.11 | 3889097.0 |
| 2020-02-26 | NQ | Futures | 10172.05 | 10366.19 | 9989.96 | 10151.41 | 1251412.0 |
| 2020-02-26 | YM | Futures | 28485.8 | 28900.6 | 28032.1 | 28265.2 | 588272.0 |
| 2020-02-26 | CL | Futures | 51.13 | 51.5 | 49.32 | 49.76 | 884482.0 |
| 2020-02-26 | GC | Futures | 1996.3 | 2020.4 | 1983.2 | 2003.4 | 531901.0 |
| 2020-02-26 | ZN | Futures | 131.726376 | 132.221937 | 131.525054 | 132.144505 | 4313431.0 |
| 2020-02-26 | A6 | Futures | 0.67672 | 0.67754 | 0.67098 | 0.67252 | 129014.0 |
| 2020-02-26 | AD | Futures | 0.75844 | 0.7593 | 0.75562 | 0.75662 | 96470.0 |
| 2020-02-26 | ALI | Futures | 2048.35 | 2056.78 | 2046.25 | 2049.26 | 181.0 |
| 2020-02-26 | B | Futures | 46.28 | 46.6 | 44.56 | 44.92 | 435682.0 |
| 2020-02-26 | B6 | Futures | 1.3192 | 1.3198 | 1.3085 | 1.3099 | 113081.0 |
| 2020-02-26 | BR | Futures | 0.18414 | 0.1848 | 0.18357 | 0.18365 | 39.0 |
| 2020-02-26 | BTC | Futures | 13886.0 | 13915.3 | 12710.6 | 12973.5 | 2011.0 |
| 2020-02-26 | BZ | Futures | 45.03 | 45.34 | 43.37 | 43.72 | 44355.0 |
| 2020-02-26 | C | Futures | 1879.0 | 1881.0 | 1863.0 | 1869.0 | 3270.0 |
| 2020-02-26 | CB | Futures | 218.102 | 218.102 | 216.931 | 218.074 | 18.0 |
| 2020-02-26 | CC | Futures | 1828.0 | 1833.0 | 1786.0 | 1794.0 | 17663.0 |
| 2020-02-26 | CNH | Futures | 6.9946 | 7.0046 | 6.9875 | 6.9919 | 903.0 |
| 2020-02-26 | CSC | Futures | 3.218 | 3.218 | 3.207 | 3.209 | 190.0 |
| 2020-02-26 | CT | Futures | 64.35 | 64.36 | 62.94 | 63.03 | 25612.0 |
| 2020-02-26 | DC | Futures | 26.46 | 26.46 | 26.26 | 26.34 | 150.0 |
| 2020-02-26 | DX | Futures | 96.079 | 96.283 | 95.943 | 96.029 | 18097.0 |
| 2020-02-26 | E1 | Futures | 1.17227 | 1.17559 | 1.16953 | 1.17284 | 37069.0 |
| 2020-02-26 | E6 | Futures | 1.17366 | 1.17657 | 1.17075 | 1.17549 | 273653.0 |
| 2020-02-26 | E7 | Futures | 1.1673 | 1.1705 | 1.1646 | 1.1694 | 7438.0 |
| 2020-02-26 | EBM | Futures | 211.27 | 212.37 | 210.72 | 211.54 | 12410.0 |
| 2020-02-26 | ED | Futures | 95.4587 | 95.4975 | 95.4514 | 95.4926 | 621545.0 |
| 2020-02-26 | ER | Futures | 98.411 | 98.426 | 98.411 | 98.416 | 86210.0 |
| 2020-02-26 | ESG | Futures | 280.9 | 284.47 | 278.63 | 278.8 | 1878.0 |
| 2020-02-26 | EW | Futures | 2058.8 | 2078.0 | 2015.6 | 2023.5 | 24556.0 |
| 2020-02-26 | FBON | Futures | 146.44 | 146.5 | 145.82 | 146.31 | 1086.0 |
| 2020-02-26 | FBTP | Futures | 132.04 | 132.2 | 131.34 | 132.17 | 184540.0 |
| 2020-02-26 | FBTS | Futures | 108.557 | 108.701 | 108.442 | 108.557 | 112535.0 |
| 2020-02-26 | FCE | Futures | 5092.2 | 5161.4 | 4993.2 | 5138.8 | 218669.0 |
| 2020-02-26 | FDAX | Futures | 13428.4 | 13587.6 | 13073.6 | 13501.9 | 241248.0 |
| 2020-02-26 | FDIV | Futures | 148.32 | 149.94 | 146.18 | 149.94 | 101.0 |
| 2020-02-26 | FDXM | Futures | 13256.7 | 13416.5 | 12907.9 | 13332.4 | 238407.0 |
| 2020-02-26 | FESX | Futures | 3120.7 | 3166.5 | 3048.5 | 3148.0 | 3162698.0 |
| 2020-02-26 | FGBL | Futures | 167.99 | 168.39 | 167.52 | 167.95 | 1408048.0 |
| 2020-02-26 | FGBM | Futures | 134.68 | 134.87 | 134.61 | 134.73 | 737278.0 |
| 2020-02-26 | FGBS | Futures | 112.855 | 112.89 | 112.845 | 112.855 | 543781.0 |
| 2020-02-26 | FGBX | Futures | 224.17 | 225.36 | 221.98 | 223.27 | 129633.0 |
| 2020-02-26 | FMWO | Futures | 7579.8 | 7635.4 | 7432.4 | 7626.3 | 19370.0 |
| 2020-02-26 | FOAT | Futures | 155.14 | 155.49 | 154.78 | 155.17 | 255106.0 |
| 2020-02-26 | FTDX | Futures | 3004.7 | 3069.5 | 2924.8 | 3057.9 | 441.0 |
| 2020-02-26 | FTI | Futures | 553.81 | 560.09 | 542.1 | 558.16 | 71310.0 |
| 2020-02-26 | FTUK | Futures | 6464.4 | 6572.3 | 6403.9 | 6565.3 | 245790.0 |
| 2020-02-26 | FVSA | Futures | 163.91 | 174.08 | 154.15 | 156.19 | 127029.0 |
| 2020-02-26 | FXXP | Futures | 365.0 | 369.3 | 357.2 | 367.9 | 135853.0 |
| 2020-02-26 | G | Futures | 123.1 | 123.72 | 123.0 | 123.26 | 264025.0 |
> showing 50 of 121 rows — these rows as CSV