PREVIEW / futures_daily / 2020-04-15
file: by_date/futures_daily/2020/2020-04-15.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-15 | ES | Futures | 3146.57 | 3148.51 | 3044.22 | 3070.5 | 1831570.0 |
| 2020-04-15 | NQ | Futures | 9981.19 | 9982.63 | 9729.26 | 9852.5 | 407752.0 |
| 2020-04-15 | YM | Futures | 25514.3 | 25574.1 | 24652.1 | 24959.4 | 184465.0 |
| 2020-04-15 | CL | Futures | 20.73 | 20.95 | 19.24 | 19.39 | 367570.0 |
| 2020-04-15 | GC | Futures | 2132.1 | 2134.2 | 2100.0 | 2110.4 | 186697.0 |
| 2020-04-15 | ZN | Futures | 136.543524 | 137.593146 | 136.512652 | 137.469661 | 1331091.0 |
| 2020-04-15 | A6 | Futures | 0.66223 | 0.66234 | 0.64569 | 0.65032 | 72667.0 |
| 2020-04-15 | AD | Futures | 0.73022 | 0.73088 | 0.7175 | 0.71999 | 71425.0 |
| 2020-04-15 | ALI | Futures | 1813.16 | 1813.76 | 1806.59 | 1807.19 | 68.0 |
| 2020-04-15 | B | Futures | 23.18 | 23.23 | 20.8 | 21.21 | 284337.0 |
| 2020-04-15 | B6 | Futures | 1.2824 | 1.2827 | 1.2629 | 1.2745 | 70983.0 |
| 2020-04-15 | BR | Futures | 0.1571 | 0.1571 | 0.15497 | 0.15603 | 123.0 |
| 2020-04-15 | BTC | Futures | 9780.5 | 9858.6 | 9482.7 | 9560.7 | 2144.0 |
| 2020-04-15 | BZ | Futures | 22.3 | 22.6 | 20.19 | 20.58 | 32129.0 |
| 2020-04-15 | C | Futures | 1671.0 | 1673.0 | 1637.0 | 1639.0 | 2842.0 |
| 2020-04-15 | CB | Futures | 148.366 | 150.569 | 144.323 | 150.457 | 67.0 |
| 2020-04-15 | CC | Futures | 1482.0 | 1482.0 | 1447.0 | 1456.0 | 15590.0 |
| 2020-04-15 | CNH | Futures | 6.9813 | 7.0141 | 6.9808 | 7.006 | 438.0 |
| 2020-04-15 | CSC | Futures | 2.422 | 2.453 | 2.398 | 2.422 | 180.0 |
| 2020-04-15 | CT | Futures | 50.68 | 51.21 | 49.98 | 50.79 | 14095.0 |
| 2020-04-15 | DC | Futures | 19.8 | 19.88 | 19.2 | 19.61 | 408.0 |
| 2020-04-15 | DX | Futures | 95.557 | 96.756 | 95.557 | 96.201 | 15571.0 |
| 2020-04-15 | E1 | Futures | 1.18886 | 1.18898 | 1.17634 | 1.18419 | 18305.0 |
| 2020-04-15 | E6 | Futures | 1.18224 | 1.183 | 1.16854 | 1.17569 | 142554.0 |
| 2020-04-15 | E7 | Futures | 1.1761 | 1.1768 | 1.1625 | 1.1695 | 5116.0 |
| 2020-04-15 | EBM | Futures | 218.37 | 219.49 | 217.53 | 218.09 | 22020.0 |
| 2020-04-15 | ED | Futures | 96.2324 | 96.2711 | 96.2324 | 96.2614 | 352886.0 |
| 2020-04-15 | ER | Futures | 98.254 | 98.264 | 98.22 | 98.235 | 95734.0 |
| 2020-04-15 | ESG | Futures | 249.94 | 252.64 | 249.03 | 250.88 | 110.0 |
| 2020-04-15 | EW | Futures | 1660.5 | 1662.1 | 1585.2 | 1593.4 | 9877.0 |
| 2020-04-15 | FBON | Futures | 138.81 | 139.21 | 138.47 | 138.59 | 326.0 |
| 2020-04-15 | FBTP | Futures | 123.47 | 123.73 | 121.27 | 122.3 | 96218.0 |
| 2020-04-15 | FBTS | Futures | 106.287 | 106.373 | 105.681 | 105.969 | 66285.0 |
| 2020-04-15 | FCE | Futures | 4332.5 | 4398.8 | 4167.4 | 4188.2 | 60483.0 |
| 2020-04-15 | FDAX | Futures | 11308.3 | 11351.7 | 10819.2 | 10853.0 | 101727.0 |
| 2020-04-15 | FDIV | Futures | 118.12 | 118.12 | 114.45 | 114.45 | 540.0 |
| 2020-04-15 | FDXM | Futures | 11378.3 | 11405.9 | 10870.3 | 10904.9 | 72025.0 |
| 2020-04-15 | FESX | Futures | 2644.3 | 2649.8 | 2534.1 | 2541.5 | 1518267.0 |
| 2020-04-15 | FEU3 | Futures | 99.001 | 99.001 | 98.971 | 98.971 | 200.0 |
| 2020-04-15 | FGBL | Futures | 166.63 | 167.95 | 166.57 | 167.85 | 532337.0 |
| 2020-04-15 | FGBM | Futures | 134.27 | 134.66 | 134.24 | 134.62 | 313782.0 |
| 2020-04-15 | FGBS | Futures | 112.845 | 112.895 | 112.82 | 112.885 | 233406.0 |
| 2020-04-15 | FGBX | Futures | 222.69 | 228.11 | 222.69 | 227.8 | 39411.0 |
| 2020-04-15 | FMWO | Futures | 6902.1 | 6906.8 | 6739.8 | 6753.9 | 1399.0 |
| 2020-04-15 | FOAT | Futures | 151.15 | 151.91 | 151.0 | 151.81 | 103143.0 |
| 2020-04-15 | FTDX | Futures | 2901.6 | 2901.6 | 2822.3 | 2822.3 | 85.0 |
| 2020-04-15 | FTI | Futures | 470.69 | 471.26 | 454.89 | 456.54 | 11885.0 |
| 2020-04-15 | FTUK | Futures | 5440.4 | 5450.3 | 5238.6 | 5255.6 | 121566.0 |
| 2020-04-15 | FVSA | Futures | 309.22 | 335.77 | 309.22 | 329.92 | 10677.0 |
| 2020-04-15 | FXXP | Futures | 306.2 | 306.6 | 295.4 | 296.5 | 113202.0 |
> showing 50 of 120 rows — these rows as CSV