PREVIEW / futures_daily / 2020-04-08
file: by_date/futures_daily/2020/2020-04-08.parquet size: 10 KB rows: 120
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-04-08 | ES | Futures | 2921.68 | 3045.6 | 2899.82 | 3026.24 | 1920688.0 |
| 2020-04-08 | NQ | Futures | 9188.72 | 9448.96 | 9117.92 | 9389.06 | 424380.0 |
| 2020-04-08 | YM | Futures | 23986.3 | 24962.6 | 23735.5 | 24804.7 | 238333.0 |
| 2020-04-08 | CL | Futures | 24.08 | 26.21 | 23.53 | 24.87 | 823554.0 |
| 2020-04-08 | GC | Futures | 2035.8 | 2056.5 | 2026.1 | 2042.6 | 125327.0 |
| 2020-04-08 | ZN | Futures | 136.389167 | 136.620702 | 136.034148 | 136.173069 | 1137637.0 |
| 2020-04-08 | A6 | Futures | 0.63388 | 0.64179 | 0.62843 | 0.64076 | 70730.0 |
| 2020-04-08 | AD | Futures | 0.72424 | 0.725 | 0.72029 | 0.72247 | 50867.0 |
| 2020-04-08 | ALI | Futures | 1790.71 | 1791.92 | 1784.04 | 1786.16 | 151.0 |
| 2020-04-08 | B | Futures | 24.99 | 25.94 | 24.16 | 25.16 | 320612.0 |
| 2020-04-08 | B6 | Futures | 1.2532 | 1.2616 | 1.2482 | 1.2587 | 50089.0 |
| 2020-04-08 | BR | Futures | 0.15681 | 0.15923 | 0.15521 | 0.15866 | 113.0 |
| 2020-04-08 | BTC | Futures | 10206.1 | 10603.3 | 10156.4 | 10404.7 | 3066.0 |
| 2020-04-08 | BZ | Futures | 24.08 | 25.17 | 23.44 | 24.4 | 39293.0 |
| 2020-04-08 | C | Futures | 1749.0 | 1752.0 | 1717.0 | 1742.0 | 3049.0 |
| 2020-04-08 | CB | Futures | 168.944 | 169.529 | 160.802 | 163.116 | 48.0 |
| 2020-04-08 | CC | Futures | 1562.0 | 1565.0 | 1542.0 | 1550.0 | 16745.0 |
| 2020-04-08 | CNH | Futures | 6.9967 | 7.0152 | 6.9967 | 7.0028 | 1067.0 |
| 2020-04-08 | CSC | Futures | 2.776 | 2.791 | 2.628 | 2.633 | 243.0 |
| 2020-04-08 | CT | Futures | 50.75 | 52.12 | 50.25 | 51.84 | 23953.0 |
| 2020-04-08 | DC | Futures | 22.17 | 22.81 | 20.95 | 21.09 | 709.0 |
| 2020-04-08 | DX | Futures | 96.678 | 97.191 | 96.649 | 96.862 | 11099.0 |
| 2020-04-08 | E1 | Futures | 1.17747 | 1.1785 | 1.17178 | 1.17542 | 14010.0 |
| 2020-04-08 | E6 | Futures | 1.17316 | 1.17413 | 1.16623 | 1.16967 | 130074.0 |
| 2020-04-08 | E7 | Futures | 1.1672 | 1.1679 | 1.1602 | 1.1636 | 5013.0 |
| 2020-04-08 | EBM | Futures | 220.05 | 222.01 | 218.93 | 220.89 | 17929.0 |
| 2020-04-08 | ED | Futures | 96.0971 | 96.1019 | 96.0101 | 96.0729 | 533659.0 |
| 2020-04-08 | ER | Futures | 98.195 | 98.205 | 98.122 | 98.142 | 170729.0 |
| 2020-04-08 | ESG | Futures | 244.17 | 247.59 | 243.47 | 246.86 | 1215.0 |
| 2020-04-08 | EW | Futures | 1534.5 | 1632.8 | 1525.3 | 1624.9 | 14978.0 |
| 2020-04-08 | FBON | Futures | 139.0 | 139.74 | 138.91 | 139.31 | 288.0 |
| 2020-04-08 | FBTP | Futures | 125.08 | 125.31 | 123.5 | 124.99 | 79504.0 |
| 2020-04-08 | FBTS | Futures | 106.816 | 106.902 | 106.316 | 106.729 | 50276.0 |
| 2020-04-08 | FCE | Futures | 4273.9 | 4325.2 | 4195.0 | 4301.5 | 42023.0 |
| 2020-04-08 | FDAX | Futures | 10752.5 | 11009.0 | 10725.6 | 10902.2 | 71230.0 |
| 2020-04-08 | FDIV | Futures | 115.05 | 116.03 | 115.05 | 116.03 | 717.0 |
| 2020-04-08 | FDXM | Futures | 10804.4 | 11065.9 | 10777.9 | 10954.3 | 87382.0 |
| 2020-04-08 | FESX | Futures | 2551.6 | 2604.8 | 2532.3 | 2579.1 | 1283682.0 |
| 2020-04-08 | FEU3 | Futures | 98.937 | 98.937 | 98.877 | 98.877 | 100.0 |
| 2020-04-08 | FGBL | Futures | 166.01 | 166.52 | 165.25 | 165.69 | 620310.0 |
| 2020-04-08 | FGBM | Futures | 133.98 | 134.13 | 133.75 | 133.9 | 365534.0 |
| 2020-04-08 | FGBS | Futures | 112.724 | 112.759 | 112.689 | 112.709 | 247847.0 |
| 2020-04-08 | FGBX | Futures | 222.01 | 223.85 | 219.08 | 220.42 | 42802.0 |
| 2020-04-08 | FMWO | Futures | 6538.6 | 6745.7 | 6511.6 | 6659.8 | 4072.0 |
| 2020-04-08 | FOAT | Futures | 150.49 | 150.69 | 149.75 | 150.18 | 102458.0 |
| 2020-04-08 | FTDX | Futures | 2739.4 | 2790.4 | 2733.8 | 2773.2 | 129.0 |
| 2020-04-08 | FTI | Futures | 466.01 | 471.91 | 459.82 | 468.63 | 23546.0 |
| 2020-04-08 | FTUK | Futures | 5299.5 | 5386.2 | 5242.4 | 5317.4 | 107683.0 |
| 2020-04-08 | FVSA | Futures | 393.84 | 405.54 | 386.18 | 391.14 | 15621.0 |
| 2020-04-08 | FXXP | Futures | 298.7 | 303.0 | 294.8 | 300.2 | 53597.0 |
> showing 50 of 120 rows — these rows as CSV