PREVIEW / futures_daily / 2019-10-25
file: by_date/futures_daily/2019/2019-10-25.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 |
|---|---|---|---|---|---|---|---|
| 2019-10-25 | ES | Futures | 3251.76 | 3276.39 | 3247.7 | 3269.62 | 1098391.0 |
| 2019-10-25 | NQ | Futures | 9136.97 | 9267.19 | 9125.44 | 9260.56 | 348318.0 |
| 2019-10-25 | YM | Futures | 28109.2 | 28309.7 | 28039.9 | 28243.6 | 129494.0 |
| 2019-10-25 | CL | Futures | 57.28 | 57.97 | 56.8 | 57.89 | 445020.0 |
| 2019-10-25 | GC | Futures | 1858.2 | 1876.1 | 1854.1 | 1856.9 | 368743.0 |
| 2019-10-25 | ZN | Futures | 128.690948 | 128.799339 | 128.195447 | 128.365776 | 1248579.0 |
| 2019-10-25 | A6 | Futures | 0.70071 | 0.70245 | 0.69958 | 0.70071 | 53456.0 |
| 2019-10-25 | AD | Futures | 0.77098 | 0.77184 | 0.77058 | 0.77154 | 53808.0 |
| 2019-10-25 | ALI | Futures | 2111.41 | 2111.41 | 2110.2 | 2110.2 | 20.0 |
| 2019-10-25 | B | Futures | 48.85 | 49.3 | 48.39 | 49.24 | 177674.0 |
| 2019-10-25 | B6 | Futures | 1.3082 | 1.31 | 1.304 | 1.3066 | 77018.0 |
| 2019-10-25 | BR | Futures | 0.19974 | 0.20204 | 0.19974 | 0.20124 | 26740.0 |
| 2019-10-25 | BTC | Futures | 10751.0 | 12830.5 | 10678.8 | 12585.0 | 8600.0 |
| 2019-10-25 | BZ | Futures | 48.17 | 48.6 | 47.74 | 48.56 | 20288.0 |
| 2019-10-25 | C | Futures | 1698.0 | 1706.0 | 1683.0 | 1684.0 | 6609.0 |
| 2019-10-25 | CB | Futures | 243.26 | 243.644 | 243.26 | 243.26 | 17.0 |
| 2019-10-25 | CC | Futures | 1619.0 | 1629.0 | 1594.0 | 1598.0 | 15985.0 |
| 2019-10-25 | CNH | Futures | 7.0645 | 7.0667 | 7.0444 | 7.0444 | 457.0 |
| 2019-10-25 | CSC | Futures | 3.323 | 3.349 | 3.314 | 3.349 | 150.0 |
| 2019-10-25 | CT | Futures | 62.98 | 63.95 | 62.86 | 63.17 | 16448.0 |
| 2019-10-25 | DC | Futures | 27.71 | 27.9 | 27.54 | 27.87 | 346.0 |
| 2019-10-25 | DX | Futures | 94.183 | 94.41 | 94.082 | 94.332 | 9805.0 |
| 2019-10-25 | E1 | Futures | 1.16358 | 1.16542 | 1.15979 | 1.16071 | 20642.0 |
| 2019-10-25 | E6 | Futures | 1.2077 | 1.20954 | 1.20412 | 1.20499 | 115546.0 |
| 2019-10-25 | E7 | Futures | 1.2014 | 1.2032 | 1.1978 | 1.1988 | 2163.0 |
| 2019-10-25 | EBM | Futures | 197.01 | 198.1 | 195.64 | 198.1 | 23303.0 |
| 2019-10-25 | ED | Futures | 95.3326 | 95.3472 | 95.3083 | 95.3229 | 243057.0 |
| 2019-10-25 | ER | Futures | 98.406 | 98.411 | 98.401 | 98.411 | 35240.0 |
| 2019-10-25 | EW | Futures | 2046.7 | 2064.2 | 2043.7 | 2057.8 | 7479.0 |
| 2019-10-25 | FBON | Futures | 145.03 | 145.13 | 144.77 | 144.83 | 325.0 |
| 2019-10-25 | FBTP | Futures | 131.58 | 131.71 | 131.17 | 131.3 | 55994.0 |
| 2019-10-25 | FBTS | Futures | 108.404 | 108.442 | 108.346 | 108.365 | 43116.0 |
| 2019-10-25 | FCE | Futures | 5164.6 | 5193.6 | 5145.5 | 5191.4 | 87418.0 |
| 2019-10-25 | FDAX | Futures | 13568.8 | 13603.6 | 13530.8 | 13596.7 | 68094.0 |
| 2019-10-25 | FDIV | Futures | 158.11 | 158.8 | 158.11 | 158.71 | 110.0 |
| 2019-10-25 | FDXM | Futures | 13390.0 | 13426.5 | 13354.6 | 13419.2 | 26593.0 |
| 2019-10-25 | FESX | Futures | 3164.1 | 3172.9 | 3151.8 | 3169.3 | 647465.0 |
| 2019-10-25 | FGBL | Futures | 165.84 | 165.96 | 165.3 | 165.53 | 480662.0 |
| 2019-10-25 | FGBM | Futures | 134.18 | 134.22 | 134.03 | 134.1 | 260910.0 |
| 2019-10-25 | FGBS | Futures | 112.774 | 112.785 | 112.749 | 112.759 | 192592.0 |
| 2019-10-25 | FGBX | Futures | 217.48 | 217.93 | 215.15 | 216.13 | 34710.0 |
| 2019-10-25 | FMWO | Futures | 7381.3 | 7413.1 | 7362.0 | 7410.9 | 5003.0 |
| 2019-10-25 | FOAT | Futures | 153.35 | 153.42 | 152.82 | 152.99 | 95221.0 |
| 2019-10-25 | FTDX | Futures | 2783.7 | 2785.1 | 2755.5 | 2768.8 | 77.0 |
| 2019-10-25 | FTI | Futures | 554.08 | 555.47 | 551.55 | 555.15 | 22566.0 |
| 2019-10-25 | FTUK | Futures | 6758.3 | 6779.2 | 6724.5 | 6762.5 | 79217.0 |
| 2019-10-25 | FVSA | Futures | 158.75 | 160.34 | 153.44 | 156.09 | 10444.0 |
| 2019-10-25 | FXXP | Futures | 358.5 | 359.5 | 356.9 | 359.1 | 31082.0 |
| 2019-10-25 | G | Futures | 121.38 | 121.55 | 121.06 | 121.3 | 188181.0 |
| 2019-10-25 | GF | Futures | 301.267 | 305.245 | 300.953 | 304.355 | 1797.0 |
> showing 50 of 119 rows — these rows as CSV