PREVIEW / futures_daily / 2020-04-06
file: by_date/futures_daily/2020/2020-04-06.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-06 | ES | Futures | 2749.62 | 2952.66 | 2749.34 | 2926.1 | 2034419.0 |
| 2020-04-06 | NQ | Futures | 8639.28 | 9285.02 | 8639.0 | 9205.63 | 396874.0 |
| 2020-04-06 | YM | Futures | 22348.4 | 24182.6 | 22348.4 | 23995.9 | 222337.0 |
| 2020-04-06 | CL | Futures | 25.86 | 27.99 | 25.05 | 25.85 | 752710.0 |
| 2020-04-06 | GC | Futures | 1998.2 | 2080.8 | 1986.7 | 2054.2 | 192753.0 |
| 2020-04-06 | ZN | Futures | 137.299869 | 137.346176 | 136.651573 | 136.728751 | 950207.0 |
| 2020-04-06 | A6 | Futures | 0.61641 | 0.62741 | 0.61569 | 0.62586 | 52970.0 |
| 2020-04-06 | AD | Futures | 0.71148 | 0.72044 | 0.71107 | 0.71832 | 46989.0 |
| 2020-04-06 | ALI | Futures | 1785.25 | 1793.14 | 1781.61 | 1785.86 | 72.0 |
| 2020-04-06 | B | Futures | 24.33 | 26.23 | 23.0 | 25.32 | 296072.0 |
| 2020-04-06 | B6 | Futures | 1.2417 | 1.2522 | 1.2403 | 1.2497 | 65294.0 |
| 2020-04-06 | BR | Futures | 0.15411 | 0.15591 | 0.1537 | 0.15423 | 65.0 |
| 2020-04-06 | BTC | Futures | 9674.2 | 10461.4 | 9624.5 | 10397.6 | 10939.0 |
| 2020-04-06 | BZ | Futures | 23.22 | 25.44 | 22.7 | 24.56 | 36779.0 |
| 2020-04-06 | C | Futures | 1681.0 | 1751.0 | 1670.0 | 1749.0 | 8080.0 |
| 2020-04-06 | CB | Futures | 151.405 | 158.404 | 151.405 | 156.982 | 28.0 |
| 2020-04-06 | CC | Futures | 1483.0 | 1547.0 | 1483.0 | 1534.0 | 23569.0 |
| 2020-04-06 | CNH | Futures | 7.0438 | 7.044 | 7.0306 | 7.0369 | 223.0 |
| 2020-04-06 | CSC | Futures | 2.584 | 2.705 | 2.505 | 2.615 | 141.0 |
| 2020-04-06 | CT | Futures | 48.99 | 51.86 | 47.47 | 51.08 | 34088.0 |
| 2020-04-06 | DC | Futures | 20.96 | 21.66 | 19.74 | 20.75 | 1164.0 |
| 2020-04-06 | DX | Futures | 97.534 | 97.694 | 97.215 | 97.428 | 11184.0 |
| 2020-04-06 | E1 | Futures | 1.16791 | 1.16996 | 1.16552 | 1.16734 | 11129.0 |
| 2020-04-06 | E6 | Futures | 1.16451 | 1.16687 | 1.15983 | 1.16295 | 126450.0 |
| 2020-04-06 | E7 | Futures | 1.1583 | 1.1608 | 1.1538 | 1.1569 | 6094.0 |
| 2020-04-06 | EBM | Futures | 215.85 | 219.21 | 215.57 | 218.65 | 14260.0 |
| 2020-04-06 | ED | Futures | 96.1744 | 96.1793 | 96.1406 | 96.1454 | 250800.0 |
| 2020-04-06 | ER | Futures | 98.279 | 98.284 | 98.24 | 98.254 | 124855.0 |
| 2020-04-06 | ESG | Futures | 233.76 | 239.65 | 233.76 | 239.65 | 2.0 |
| 2020-04-06 | EW | Futures | 1426.5 | 1530.5 | 1422.1 | 1525.1 | 9849.0 |
| 2020-04-06 | FBON | Futures | 140.61 | 140.74 | 140.06 | 140.58 | 82.0 |
| 2020-04-06 | FBTP | Futures | 126.65 | 126.89 | 125.86 | 126.6 | 53716.0 |
| 2020-04-06 | FBTS | Futures | 107.201 | 107.287 | 107.037 | 107.21 | 32098.0 |
| 2020-04-06 | FCE | Futures | 4174.2 | 4287.5 | 4129.6 | 4207.1 | 46614.0 |
| 2020-04-06 | FDAX | Futures | 10211.0 | 10840.8 | 10211.0 | 10625.6 | 97486.0 |
| 2020-04-06 | FDIV | Futures | 112.55 | 114.22 | 112.55 | 114.22 | 300.0 |
| 2020-04-06 | FDXM | Futures | 10237.0 | 10888.4 | 10237.0 | 10676.4 | 72477.0 |
| 2020-04-06 | FESX | Futures | 2447.8 | 2581.8 | 2447.8 | 2541.5 | 1365394.0 |
| 2020-04-06 | FGBL | Futures | 167.05 | 167.24 | 166.63 | 167.02 | 320312.0 |
| 2020-04-06 | FGBM | Futures | 134.27 | 134.4 | 134.12 | 134.28 | 233871.0 |
| 2020-04-06 | FGBS | Futures | 112.764 | 112.82 | 112.744 | 112.78 | 135131.0 |
| 2020-04-06 | FGBX | Futures | 225.17 | 225.78 | 223.6 | 224.7 | 26488.0 |
| 2020-04-06 | FMWO | Futures | 6404.5 | 6568.0 | 6355.1 | 6438.6 | 3763.0 |
| 2020-04-06 | FOAT | Futures | 151.01 | 151.59 | 150.87 | 151.39 | 52292.0 |
| 2020-04-06 | FTDX | Futures | 2675.2 | 2690.3 | 2659.0 | 2686.3 | 167.0 |
| 2020-04-06 | FTI | Futures | 455.32 | 465.35 | 451.57 | 458.45 | 26499.0 |
| 2020-04-06 | FTUK | Futures | 5134.4 | 5334.3 | 5116.5 | 5256.1 | 92468.0 |
| 2020-04-06 | FVSA | Futures | 347.03 | 372.68 | 347.03 | 369.98 | 18333.0 |
| 2020-04-06 | FXXP | Futures | 294.6 | 299.1 | 290.4 | 295.4 | 49981.0 |
| 2020-04-06 | G | Futures | 124.98 | 125.2 | 124.78 | 125.06 | 70692.0 |
> showing 50 of 119 rows — these rows as CSV