PREVIEW / futures_daily / 2020-04-30
file: by_date/futures_daily/2020/2020-04-30.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-30 | ES | Futures | 3271.32 | 3280.73 | 3184.47 | 3211.57 | 2027924.0 |
| 2020-04-30 | NQ | Futures | 10443.49 | 10483.91 | 10153.44 | 10304.77 | 462961.0 |
| 2020-04-30 | YM | Futures | 26330.6 | 26454.4 | 25686.1 | 25854.7 | 204630.0 |
| 2020-04-30 | CL | Futures | 11.64 | 14.47 | 11.5 | 14.03 | 545344.0 |
| 2020-04-30 | GC | Futures | 2097.5 | 2106.5 | 2046.5 | 2054.6 | 234529.0 |
| 2020-04-30 | ZN | Futures | 137.253562 | 137.670324 | 137.114642 | 137.377047 | 1533122.0 |
| 2020-04-30 | A6 | Futures | 0.67374 | 0.67507 | 0.66696 | 0.67014 | 89672.0 |
| 2020-04-30 | AD | Futures | 0.73027 | 0.73169 | 0.72602 | 0.72784 | 76158.0 |
| 2020-04-30 | ALI | Futures | 1810.77 | 1810.77 | 1810.77 | 1810.77 | 0.0 |
| 2020-04-30 | B | Futures | 16.2 | 17.83 | 16.12 | 17.49 | 391118.0 |
| 2020-04-30 | B6 | Futures | 1.2665 | 1.2838 | 1.2619 | 1.2792 | 113277.0 |
| 2020-04-30 | BFX | Futures | 3067.7 | 3067.7 | 3060.7 | 3060.7 | 17.0 |
| 2020-04-30 | BR | Futures | 0.15251 | 0.15374 | 0.14903 | 0.15013 | 5828.0 |
| 2020-04-30 | BTC | Futures | 12434.0 | 13296.3 | 11794.2 | 12420.1 | 10524.0 |
| 2020-04-30 | BZ | Futures | 15.55 | 17.25 | 15.49 | 16.93 | 42900.0 |
| 2020-04-30 | C | Futures | 1861.0 | 1877.0 | 1833.0 | 1868.0 | 10596.0 |
| 2020-04-30 | CB | Futures | 136.07 | 139.416 | 136.07 | 136.711 | 16.0 |
| 2020-04-30 | CC | Futures | 1555.0 | 1585.0 | 1542.0 | 1577.0 | 19452.0 |
| 2020-04-30 | CNH | Futures | 7.0134 | 7.0259 | 6.9921 | 7.0179 | 262.0 |
| 2020-04-30 | CSC | Futures | 2.464 | 2.483 | 2.446 | 2.452 | 75.0 |
| 2020-04-30 | CT | Futures | 55.77 | 56.52 | 55.13 | 55.88 | 15077.0 |
| 2020-04-30 | DC | Futures | 19.9 | 20.12 | 19.69 | 19.78 | 243.0 |
| 2020-04-30 | DX | Futures | 96.262 | 96.504 | 95.566 | 95.758 | 26659.0 |
| 2020-04-30 | E1 | Futures | 1.17041 | 1.18306 | 1.16836 | 1.18066 | 33947.0 |
| 2020-04-30 | E6 | Futures | 1.16972 | 1.18036 | 1.16521 | 1.17816 | 224340.0 |
| 2020-04-30 | E7 | Futures | 1.1637 | 1.1742 | 1.1592 | 1.172 | 9283.0 |
| 2020-04-30 | EBM | Futures | 217.81 | 219.49 | 217.53 | 219.21 | 13393.0 |
| 2020-04-30 | ED | Futures | 96.3533 | 96.3726 | 96.3291 | 96.3484 | 340948.0 |
| 2020-04-30 | ER | Futures | 98.308 | 98.347 | 98.279 | 98.328 | 186734.0 |
| 2020-04-30 | ESG | Futures | 262.92 | 262.92 | 261.11 | 262.53 | 61.0 |
| 2020-04-30 | EW | Futures | 1801.9 | 1809.8 | 1730.9 | 1739.4 | 15850.0 |
| 2020-04-30 | FBON | Futures | 139.62 | 140.64 | 139.58 | 140.5 | 773.0 |
| 2020-04-30 | FBTP | Futures | 124.04 | 124.89 | 122.83 | 123.84 | 150648.0 |
| 2020-04-30 | FBTS | Futures | 106.951 | 107.374 | 106.681 | 107.124 | 120830.0 |
| 2020-04-30 | FCE | Futures | 4545.6 | 4550.4 | 4353.8 | 4402.2 | 58043.0 |
| 2020-04-30 | FDAX | Futures | 11784.8 | 11990.5 | 11376.0 | 11476.5 | 115364.0 |
| 2020-04-30 | FDIV | Futures | 125.82 | 125.82 | 123.17 | 123.17 | 300.0 |
| 2020-04-30 | FDXM | Futures | 11839.5 | 12047.8 | 11430.4 | 11531.3 | 76421.0 |
| 2020-04-30 | FESX | Futures | 2727.8 | 2771.8 | 2630.5 | 2649.8 | 1566641.0 |
| 2020-04-30 | FEU3 | Futures | 99.045 | 99.065 | 99.04 | 99.065 | 200.0 |
| 2020-04-30 | FGBL | Futures | 168.11 | 169.69 | 168.1 | 169.55 | 814486.0 |
| 2020-04-30 | FGBM | Futures | 134.71 | 135.36 | 134.69 | 135.3 | 530030.0 |
| 2020-04-30 | FGBS | Futures | 112.875 | 113.016 | 112.87 | 112.991 | 544179.0 |
| 2020-04-30 | FGBX | Futures | 227.24 | 232.61 | 227.24 | 232.44 | 69682.0 |
| 2020-04-30 | FMWO | Futures | 7230.4 | 7238.6 | 7068.0 | 7115.1 | 5215.0 |
| 2020-04-30 | FOAT | Futures | 153.05 | 154.04 | 152.94 | 153.97 | 202278.0 |
| 2020-04-30 | FTDX | Futures | 2926.9 | 2926.9 | 2863.2 | 2881.9 | 105.0 |
| 2020-04-30 | FTI | Futures | 497.84 | 498.92 | 474.49 | 479.6 | 38057.0 |
| 2020-04-30 | FTUK | Futures | 5763.4 | 5838.4 | 5497.0 | 5549.8 | 159812.0 |
| 2020-04-30 | FVSA | Futures | 282.66 | 307.42 | 280.86 | 302.02 | 9249.0 |
> showing 50 of 120 rows — these rows as CSV