PREVIEW / futures_daily / 2019-01-22
file: by_date/futures_daily/2019/2019-01-22.parquet size: 10 KB rows: 116
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-01-22 | ES | Futures | 2889.92 | 2894.52 | 2832.81 | 2849.59 | 1880446.0 |
| 2019-01-22 | NQ | Futures | 7866.36 | 7866.36 | 7654.49 | 7702.53 | 651258.0 |
| 2019-01-22 | YM | Futures | 26042.3 | 26054.9 | 25542.3 | 25725.8 | 280459.0 |
| 2019-01-22 | CL | Futures | 56.11 | 56.69 | 54.12 | 55.13 | 951158.0 |
| 2019-01-22 | GC | Futures | 1613.7 | 1619.1 | 1607.8 | 1617.1 | 318850.0 |
| 2019-01-22 | ZN | Futures | 120.677858 | 121.129135 | 120.662296 | 121.082451 | 1733333.0 |
| 2019-01-22 | A6 | Futures | 0.73858 | 0.74053 | 0.73373 | 0.73404 | 121974.0 |
| 2019-01-22 | AD | Futures | 0.7644 | 0.76496 | 0.75883 | 0.75934 | 78422.0 |
| 2019-01-22 | B | Futures | 45.19 | 45.27 | 43.73 | 44.4 | 283221.0 |
| 2019-01-22 | B6 | Futures | 1.3257 | 1.336 | 1.321 | 1.3342 | 147117.0 |
| 2019-01-22 | BFX | Futures | 4056.0 | 4056.0 | 4035.6 | 4035.6 | 1.0 |
| 2019-01-22 | BR | Futures | 0.21209 | 0.21209 | 0.20814 | 0.2105 | 149.0 |
| 2019-01-22 | BTC | Futures | 5153.4 | 5292.3 | 4956.0 | 5233.8 | 6725.0 |
| 2019-01-22 | BZ | Futures | 44.92 | 45.19 | 43.37 | 44.03 | 53602.0 |
| 2019-01-22 | C | Futures | 1461.0 | 1465.0 | 1419.0 | 1430.0 | 12953.0 |
| 2019-01-22 | CB | Futures | 273.23 | 273.23 | 272.501 | 272.623 | 57.0 |
| 2019-01-22 | CC | Futures | 1580.0 | 1587.0 | 1534.0 | 1547.0 | 29231.0 |
| 2019-01-22 | CNH | Futures | 6.8156 | 6.832 | 6.8064 | 6.829 | 961.0 |
| 2019-01-22 | CSC | Futures | 2.747 | 2.752 | 2.719 | 2.721 | 152.0 |
| 2019-01-22 | CT | Futures | 80.61 | 80.93 | 79.25 | 79.66 | 16729.0 |
| 2019-01-22 | DC | Futures | 23.51 | 23.64 | 23.22 | 23.23 | 242.0 |
| 2019-01-22 | DX | Futures | 91.56 | 91.698 | 91.431 | 91.516 | 10683.0 |
| 2019-01-22 | E1 | Futures | 1.18759 | 1.18818 | 1.18324 | 1.18536 | 25019.0 |
| 2019-01-22 | E6 | Futures | 1.26166 | 1.26459 | 1.2584 | 1.26127 | 185488.0 |
| 2019-01-22 | E7 | Futures | 1.2548 | 1.2583 | 1.2523 | 1.2551 | 3651.0 |
| 2019-01-22 | EBM | Futures | 210.77 | 212.05 | 210.77 | 211.54 | 27824.0 |
| 2019-01-22 | ED | Futures | 95.0183 | 95.0281 | 95.0086 | 95.0183 | 247703.0 |
| 2019-01-22 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 41647.0 |
| 2019-01-22 | EW | Futures | 1937.5 | 1938.7 | 1896.9 | 1906.8 | 16774.0 |
| 2019-01-22 | FBON | Futures | 130.4 | 130.75 | 130.4 | 130.58 | 504.0 |
| 2019-01-22 | FBTP | Futures | 111.75 | 112.01 | 111.67 | 111.9 | 66450.0 |
| 2019-01-22 | FBTS | Futures | 105.19 | 105.313 | 105.181 | 105.266 | 33169.0 |
| 2019-01-22 | FCE | Futures | 4338.5 | 4354.1 | 4306.2 | 4339.8 | 62692.0 |
| 2019-01-22 | FDAX | Futures | 11700.7 | 11707.0 | 11560.4 | 11641.4 | 95013.0 |
| 2019-01-22 | FDXM | Futures | 11675.9 | 11686.4 | 11533.3 | 11613.0 | 42526.0 |
| 2019-01-22 | FESX | Futures | 2662.0 | 2663.7 | 2632.9 | 2648.3 | 845118.0 |
| 2019-01-22 | FEU3 | Futures | 99.001 | 99.001 | 99.001 | 99.001 | 100.0 |
| 2019-01-22 | FGBL | Futures | 156.17 | 156.64 | 156.05 | 156.38 | 608301.0 |
| 2019-01-22 | FGBM | Futures | 132.12 | 132.29 | 132.06 | 132.18 | 332007.0 |
| 2019-01-22 | FGBS | Futures | 112.708 | 112.734 | 112.688 | 112.713 | 290018.0 |
| 2019-01-22 | FGBX | Futures | 184.29 | 185.62 | 184.02 | 185.02 | 32644.0 |
| 2019-01-22 | FMWO | Futures | 6686.9 | 6695.1 | 6611.2 | 6669.4 | 1565.0 |
| 2019-01-22 | FOAT | Futures | 142.22 | 142.36 | 142.07 | 142.24 | 82788.0 |
| 2019-01-22 | FTDX | Futures | 2547.3 | 2583.6 | 2547.3 | 2557.2 | 186.0 |
| 2019-01-22 | FTI | Futures | 478.54 | 479.54 | 474.48 | 477.53 | 23298.0 |
| 2019-01-22 | FTUK | Futures | 6290.8 | 6297.7 | 6182.0 | 6228.0 | 85144.0 |
| 2019-01-22 | FVSA | Futures | 316.07 | 334.82 | 311.38 | 321.69 | 38829.0 |
| 2019-01-22 | FXXP | Futures | 310.5 | 311.7 | 308.2 | 310.2 | 43945.0 |
| 2019-01-22 | G | Futures | 116.53 | 116.58 | 116.17 | 116.3 | 207516.0 |
| 2019-01-22 | GF | Futures | 311.081 | 311.135 | 308.784 | 309.44 | 7319.0 |
> showing 50 of 116 rows — these rows as CSV