PREVIEW / futures_daily / 2019-05-22
file: by_date/futures_daily/2019/2019-05-22.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 |
|---|---|---|---|---|---|---|---|
| 2019-05-22 | ES | Futures | 3094.43 | 3099.56 | 3076.61 | 3086.6 | 1258767.0 |
| 2019-05-22 | NQ | Futures | 8598.62 | 8612.73 | 8516.23 | 8560.88 | 455678.0 |
| 2019-05-22 | YM | Futures | 27296.7 | 27343.1 | 27162.6 | 27202.8 | 196584.0 |
| 2019-05-22 | CL | Futures | 64.61 | 64.66 | 62.64 | 63.04 | 766728.0 |
| 2019-05-22 | GC | Futures | 1586.1 | 1589.5 | 1583.2 | 1585.9 | 191366.0 |
| 2019-05-22 | ZN | Futures | 123.46117 | 123.834118 | 123.414552 | 123.75642 | 1523116.0 |
| 2019-05-22 | A6 | Futures | 0.70993 | 0.71137 | 0.7089 | 0.71013 | 71267.0 |
| 2019-05-22 | AD | Futures | 0.75458 | 0.75746 | 0.75271 | 0.75332 | 87735.0 |
| 2019-05-22 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-22 | B | Futures | 52.99 | 53.08 | 51.89 | 52.31 | 371518.0 |
| 2019-05-22 | B6 | Futures | 1.3033 | 1.3046 | 1.2948 | 1.2994 | 138205.0 |
| 2019-05-22 | BR | Futures | 0.1982 | 0.19956 | 0.19748 | 0.198 | 5373.0 |
| 2019-05-22 | BTC | Futures | 12418.3 | 12487.9 | 11923.4 | 12294.6 | 10834.0 |
| 2019-05-22 | BZ | Futures | 52.91 | 52.93 | 51.75 | 52.17 | 57458.0 |
| 2019-05-22 | C | Futures | 1721.0 | 1727.0 | 1708.0 | 1710.0 | 6950.0 |
| 2019-05-22 | CB | Futures | 282.73 | 283.868 | 282.526 | 283.576 | 48.0 |
| 2019-05-22 | CC | Futures | 1647.0 | 1647.0 | 1622.0 | 1625.0 | 22754.0 |
| 2019-05-22 | CNH | Futures | 6.946 | 6.9524 | 6.9368 | 6.9443 | 678.0 |
| 2019-05-22 | CSC | Futures | 2.968 | 2.971 | 2.961 | 2.97 | 64.0 |
| 2019-05-22 | CT | Futures | 70.48 | 70.6 | 69.21 | 69.87 | 11000.0 |
| 2019-05-22 | DC | Futures | 25.07 | 25.15 | 24.97 | 25.03 | 247.0 |
| 2019-05-22 | DX | Futures | 93.81 | 93.906 | 93.676 | 93.821 | 7573.0 |
| 2019-05-22 | E1 | Futures | 1.15722 | 1.16201 | 1.15594 | 1.15967 | 19805.0 |
| 2019-05-22 | E6 | Futures | 1.22762 | 1.22976 | 1.22619 | 1.22745 | 126258.0 |
| 2019-05-22 | E7 | Futures | 1.2217 | 1.2235 | 1.2202 | 1.2214 | 3469.0 |
| 2019-05-22 | EBM | Futures | 201.52 | 201.81 | 199.22 | 201.52 | 15136.0 |
| 2019-05-22 | ED | Futures | 95.1795 | 95.1868 | 95.177 | 95.1795 | 193998.0 |
| 2019-05-22 | ER | Futures | 98.426 | 98.426 | 98.421 | 98.421 | 25525.0 |
| 2019-05-22 | EW | Futures | 2016.6 | 2019.6 | 1996.2 | 2000.9 | 12125.0 |
| 2019-05-22 | FBON | Futures | 137.74 | 137.95 | 137.69 | 137.84 | 321.0 |
| 2019-05-22 | FBTP | Futures | 115.44 | 115.48 | 115.16 | 115.39 | 57790.0 |
| 2019-05-22 | FBTS | Futures | 105.77 | 105.798 | 105.693 | 105.77 | 32216.0 |
| 2019-05-22 | FCE | Futures | 4838.0 | 4857.0 | 4805.7 | 4837.5 | 80144.0 |
| 2019-05-22 | FDAX | Futures | 12791.7 | 12853.2 | 12683.2 | 12806.9 | 108276.0 |
| 2019-05-22 | FDIV | Futures | 145.4 | 145.4 | 144.65 | 145.07 | 124.0 |
| 2019-05-22 | FDXM | Futures | 12671.4 | 12741.3 | 12574.4 | 12695.9 | 51294.0 |
| 2019-05-22 | FESX | Futures | 2946.2 | 2953.2 | 2920.0 | 2945.3 | 847827.0 |
| 2019-05-22 | FGBL | Futures | 160.72 | 161.08 | 160.64 | 160.91 | 682595.0 |
| 2019-05-22 | FGBM | Futures | 133.41 | 133.54 | 133.39 | 133.48 | 370750.0 |
| 2019-05-22 | FGBS | Futures | 112.834 | 112.86 | 112.824 | 112.849 | 240456.0 |
| 2019-05-22 | FGBX | Futures | 195.67 | 196.72 | 195.47 | 196.19 | 34514.0 |
| 2019-05-22 | FMWO | Futures | 7106.2 | 7122.4 | 7064.5 | 7107.3 | 3072.0 |
| 2019-05-22 | FOAT | Futures | 147.31 | 147.6 | 147.27 | 147.49 | 103376.0 |
| 2019-05-22 | FTDX | Futures | 2835.5 | 2874.5 | 2835.5 | 2869.5 | 337.0 |
| 2019-05-22 | FTI | Futures | 520.74 | 522.54 | 516.97 | 521.15 | 28826.0 |
| 2019-05-22 | FTUK | Futures | 6734.3 | 6750.4 | 6694.0 | 6721.5 | 86375.0 |
| 2019-05-22 | FVSA | Futures | 220.26 | 224.54 | 215.27 | 215.99 | 39941.0 |
| 2019-05-22 | FXXP | Futures | 337.9 | 339.3 | 336.0 | 338.5 | 78117.0 |
| 2019-05-22 | G | Futures | 118.67 | 119.27 | 118.67 | 119.01 | 208639.0 |
| 2019-05-22 | GF | Futures | 280.181 | 281.31 | 278.464 | 279.838 | 3676.0 |
> showing 50 of 120 rows — these rows as CSV