PREVIEW / futures_daily / 2020-04-16
file: by_date/futures_daily/2020/2020-04-16.parquet size: 10 KB rows: 119
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-16 | ES | Futures | 3062.48 | 3133.01 | 3038.41 | 3084.33 | 1749108.0 |
| 2020-04-16 | NQ | Futures | 9831.87 | 10137.39 | 9745.31 | 10013.29 | 539163.0 |
| 2020-04-16 | YM | Futures | 24896.5 | 25360.6 | 24626.5 | 24976.5 | 236013.0 |
| 2020-04-16 | CL | Futures | 19.55 | 20.1 | 18.56 | 19.01 | 439665.0 |
| 2020-04-16 | GC | Futures | 2114.4 | 2144.1 | 2089.0 | 2100.1 | 204225.0 |
| 2020-04-16 | ZN | Futures | 137.485097 | 137.716631 | 137.268998 | 137.546839 | 1139525.0 |
| 2020-04-16 | A6 | Futures | 0.6497 | 0.65083 | 0.64364 | 0.64847 | 72979.0 |
| 2020-04-16 | AD | Futures | 0.71877 | 0.721 | 0.71487 | 0.71827 | 57843.0 |
| 2020-04-16 | ALI | Futures | 1818.84 | 1839.46 | 1818.84 | 1836.17 | 78.0 |
| 2020-04-16 | B | Futures | 21.49 | 22.21 | 20.83 | 21.31 | 272978.0 |
| 2020-04-16 | B6 | Futures | 1.2721 | 1.2724 | 1.2601 | 1.265 | 57605.0 |
| 2020-04-16 | BR | Futures | 0.15571 | 0.15587 | 0.15534 | 0.15534 | 34.0 |
| 2020-04-16 | BTC | Futures | 9553.6 | 10220.3 | 9170.6 | 10078.4 | 6364.0 |
| 2020-04-16 | BZ | Futures | 20.85 | 21.56 | 20.21 | 20.67 | 30922.0 |
| 2020-04-16 | C | Futures | 1645.0 | 1672.0 | 1643.0 | 1670.0 | 805.0 |
| 2020-04-16 | CB | Futures | 145.578 | 149.732 | 145.578 | 149.203 | 29.0 |
| 2020-04-16 | CC | Futures | 1467.0 | 1485.0 | 1454.0 | 1475.0 | 10482.0 |
| 2020-04-16 | CNH | Futures | 7.0136 | 7.0287 | 7.0118 | 7.0253 | 329.0 |
| 2020-04-16 | CSC | Futures | 2.398 | 2.406 | 2.375 | 2.382 | 81.0 |
| 2020-04-16 | CT | Futures | 50.75 | 51.39 | 50.16 | 50.83 | 4447.0 |
| 2020-04-16 | DC | Futures | 19.28 | 19.45 | 19.13 | 19.26 | 357.0 |
| 2020-04-16 | DX | Futures | 96.378 | 97.075 | 96.349 | 96.794 | 13514.0 |
| 2020-04-16 | E1 | Futures | 1.18283 | 1.18294 | 1.1744 | 1.17759 | 18235.0 |
| 2020-04-16 | E6 | Futures | 1.17408 | 1.1744 | 1.16419 | 1.16736 | 137628.0 |
| 2020-04-16 | E7 | Futures | 1.1681 | 1.1683 | 1.1581 | 1.1613 | 5655.0 |
| 2020-04-16 | EBM | Futures | 218.37 | 221.73 | 218.37 | 220.05 | 27315.0 |
| 2020-04-16 | ED | Futures | 96.2614 | 96.2711 | 96.2179 | 96.2373 | 268895.0 |
| 2020-04-16 | ER | Futures | 98.235 | 98.244 | 98.205 | 98.215 | 102419.0 |
| 2020-04-16 | ESG | Futures | 251.6 | 253.15 | 251.6 | 252.94 | 80.0 |
| 2020-04-16 | EW | Futures | 1594.5 | 1623.8 | 1564.7 | 1593.1 | 12270.0 |
| 2020-04-16 | FBON | Futures | 138.53 | 139.39 | 138.39 | 139.06 | 351.0 |
| 2020-04-16 | FBTP | Futures | 122.21 | 124.01 | 122.21 | 122.81 | 80952.0 |
| 2020-04-16 | FBTS | Futures | 105.979 | 106.527 | 105.979 | 106.229 | 66682.0 |
| 2020-04-16 | FCE | Futures | 4210.5 | 4249.2 | 4151.9 | 4183.8 | 45979.0 |
| 2020-04-16 | FDAX | Futures | 10819.7 | 11040.7 | 10750.9 | 10928.1 | 87565.0 |
| 2020-04-16 | FDIV | Futures | 114.59 | 114.87 | 114.59 | 114.87 | 100.0 |
| 2020-04-16 | FDXM | Futures | 10883.1 | 11091.4 | 10800.2 | 10980.3 | 67415.0 |
| 2020-04-16 | FESX | Futures | 2535.0 | 2589.2 | 2519.4 | 2557.1 | 1219499.0 |
| 2020-04-16 | FGBL | Futures | 167.61 | 168.07 | 167.23 | 167.84 | 460487.0 |
| 2020-04-16 | FGBM | Futures | 134.58 | 134.64 | 134.36 | 134.56 | 283973.0 |
| 2020-04-16 | FGBS | Futures | 112.88 | 112.88 | 112.82 | 112.855 | 204457.0 |
| 2020-04-16 | FGBX | Futures | 226.82 | 228.69 | 225.65 | 227.73 | 26674.0 |
| 2020-04-16 | FMWO | Futures | 6842.1 | 6842.1 | 6732.7 | 6798.6 | 2776.0 |
| 2020-04-16 | FOAT | Futures | 151.54 | 152.07 | 151.33 | 151.87 | 126510.0 |
| 2020-04-16 | FTDX | Futures | 2864.2 | 2873.3 | 2837.9 | 2844.0 | 98.0 |
| 2020-04-16 | FTI | Futures | 460.38 | 464.6 | 457.8 | 460.76 | 14079.0 |
| 2020-04-16 | FTUK | Futures | 5212.2 | 5329.6 | 5210.8 | 5312.7 | 107199.0 |
| 2020-04-16 | FVSA | Futures | 325.87 | 333.97 | 320.92 | 327.67 | 5616.0 |
| 2020-04-16 | FXXP | Futures | 298.1 | 300.6 | 296.6 | 299.3 | 75928.0 |
| 2020-04-16 | G | Futures | 125.21 | 125.57 | 125.21 | 125.43 | 236633.0 |
> showing 50 of 119 rows — these rows as CSV