PREVIEW / futures_daily / 2017-03-03
file: by_date/futures_daily/2017/2017-03-03.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-03 | ES | Futures | 2579.89 | 2583.68 | 2573.38 | 2581.51 | 1357594.0 |
| 2017-03-03 | NQ | Futures | 6315.87 | 6333.25 | 6298.78 | 6331.48 | 176727.0 |
| 2017-03-03 | YM | Futures | 22102.4 | 22158.2 | 22041.3 | 22099.2 | 135151.0 |
| 2017-03-03 | CL | Futures | 55.79 | 56.65 | 55.76 | 56.59 | 436360.0 |
| 2017-03-03 | GC | Futures | 1577.4 | 1579.9 | 1562.4 | 1566.8 | 272293.0 |
| 2017-03-03 | ZN | Futures | 121.400466 | 121.522723 | 121.155954 | 121.446312 | 47557.0 |
| 2017-03-03 | A6 | Futures | 0.77525 | 0.77822 | 0.77238 | 0.77658 | 123331.0 |
| 2017-03-03 | AD | Futures | 0.76295 | 0.76386 | 0.76014 | 0.76218 | 75070.0 |
| 2017-03-03 | ALI | Futures | 2488.67 | 2488.67 | 2488.67 | 2488.67 | 0.0 |
| 2017-03-03 | B | Futures | 40.29 | 40.86 | 40.23 | 40.82 | 248708.0 |
| 2017-03-03 | B6 | Futures | 1.287 | 1.2912 | 1.2813 | 1.2882 | 109057.0 |
| 2017-03-03 | BFX | Futures | 4445.0 | 4485.0 | 4445.0 | 4485.0 | 7.0 |
| 2017-03-03 | BR | Futures | 0.2247 | 0.22778 | 0.2247 | 0.22778 | 270.0 |
| 2017-03-03 | BZ | Futures | 40.11 | 40.66 | 40.05 | 40.63 | 24688.0 |
| 2017-03-03 | C | Futures | 1608.0 | 1662.0 | 1608.0 | 1649.0 | 5766.0 |
| 2017-03-03 | CB | Futures | 273.409 | 273.409 | 271.884 | 273.409 | 12.0 |
| 2017-03-03 | CC | Futures | 1464.0 | 1499.0 | 1458.0 | 1493.0 | 20894.0 |
| 2017-03-03 | CNH | Futures | 7.2778 | 7.2947 | 7.2778 | 7.2861 | 22.0 |
| 2017-03-03 | CSC | Futures | 3.71 | 3.719 | 3.71 | 3.71 | 67.0 |
| 2017-03-03 | CT | Futures | 85.58 | 87.1 | 85.45 | 86.93 | 12084.0 |
| 2017-03-03 | DC | Futures | 30.43 | 30.61 | 30.31 | 30.48 | 126.0 |
| 2017-03-03 | DX | Futures | 95.045 | 95.125 | 94.352 | 94.55 | 61013.0 |
| 2017-03-03 | E1 | Futures | 1.22339 | 1.23058 | 1.22314 | 1.22822 | 24997.0 |
| 2017-03-03 | E6 | Futures | 1.21375 | 1.22761 | 1.21346 | 1.22455 | 280776.0 |
| 2017-03-03 | E7 | Futures | 1.2084 | 1.2213 | 1.2072 | 1.2183 | 3490.0 |
| 2017-03-03 | EBM | Futures | 198.26 | 199.4 | 197.69 | 198.26 | 7411.0 |
| 2017-03-03 | ED | Futures | 95.4916 | 95.5037 | 95.4892 | 95.494 | 354613.0 |
| 2017-03-03 | ER | Futures | 98.303 | 98.308 | 98.303 | 98.303 | 59450.0 |
| 2017-03-03 | EW | Futures | 1849.3 | 1853.9 | 1841.3 | 1850.6 | 11694.0 |
| 2017-03-03 | FBON | Futures | 121.18 | 121.4 | 120.9 | 121.06 | 2690.0 |
| 2017-03-03 | FBTP | Futures | 104.78 | 105.26 | 104.64 | 104.92 | 260455.0 |
| 2017-03-03 | FBTS | Futures | 101.755 | 101.9 | 101.737 | 101.864 | 87611.0 |
| 2017-03-03 | FCE | Futures | 4356.6 | 4409.4 | 4351.3 | 4394.4 | 85298.0 |
| 2017-03-03 | FDAX | Futures | 12676.4 | 12726.6 | 12654.2 | 12689.1 | 72065.0 |
| 2017-03-03 | FDIV | Futures | 148.19 | 148.19 | 147.17 | 147.17 | 30.0 |
| 2017-03-03 | FDXM | Futures | 12632.2 | 12675.3 | 12604.8 | 12638.0 | 23644.0 |
| 2017-03-03 | FESX | Futures | 2699.9 | 2731.9 | 2695.1 | 2723.1 | 1192339.0 |
| 2017-03-03 | FGBL | Futures | 148.62 | 148.67 | 147.8 | 147.88 | 1530128.0 |
| 2017-03-03 | FGBM | Futures | 129.72 | 129.74 | 129.34 | 129.37 | 1179518.0 |
| 2017-03-03 | FGBS | Futures | 112.417 | 112.422 | 112.322 | 112.337 | 589377.0 |
| 2017-03-03 | FGBX | Futures | 167.86 | 168.19 | 166.15 | 166.51 | 135268.0 |
| 2017-03-03 | FMWO | Futures | 6162.6 | 6184.3 | 6162.6 | 6175.9 | 1051.0 |
| 2017-03-03 | FOAT | Futures | 131.98 | 132.11 | 131.47 | 131.67 | 319901.0 |
| 2017-03-03 | FTDX | Futures | 1885.7 | 1892.1 | 1882.8 | 1888.6 | 59.0 |
| 2017-03-03 | FTI | Futures | 456.75 | 460.84 | 455.66 | 459.61 | 25716.0 |
| 2017-03-03 | FTUK | Futures | 6240.7 | 6250.5 | 6221.6 | 6238.6 | 87038.0 |
| 2017-03-03 | FVSA | Futures | 707.29 | 707.29 | 677.99 | 686.36 | 27559.0 |
| 2017-03-03 | FXXP | Futures | 310.1 | 311.8 | 309.9 | 311.1 | 33668.0 |
| 2017-03-03 | G | Futures | 114.09 | 114.52 | 114.09 | 114.33 | 186145.0 |
| 2017-03-03 | GF | Futures | 281.604 | 283.542 | 279.553 | 283.2 | 1806.0 |
> showing 50 of 110 rows — these rows as CSV