PREVIEW / futures_daily / 2019-01-28
file: by_date/futures_daily/2019/2019-01-28.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-28 | ES | Futures | 2879.9 | 2883.69 | 2839.03 | 2860.41 | 1408636.0 |
| 2019-01-28 | NQ | Futures | 7854.49 | 7862.3 | 7697.03 | 7758.97 | 490045.0 |
| 2019-01-28 | YM | Futures | 26015.9 | 26065.5 | 25614.0 | 25813.4 | 210986.0 |
| 2019-01-28 | CL | Futures | 55.7 | 55.78 | 53.38 | 54.07 | 650667.0 |
| 2019-01-28 | GC | Futures | 1635.6 | 1637.2 | 1628.4 | 1636.6 | 126076.0 |
| 2019-01-28 | ZN | Futures | 120.849032 | 121.113574 | 120.771226 | 121.004645 | 1326926.0 |
| 2019-01-28 | A6 | Futures | 0.74033 | 0.7429 | 0.73827 | 0.73878 | 67974.0 |
| 2019-01-28 | AD | Futures | 0.76683 | 0.76769 | 0.76288 | 0.76461 | 53681.0 |
| 2019-01-28 | B | Futures | 44.57 | 44.68 | 43.07 | 43.36 | 210980.0 |
| 2019-01-28 | B6 | Futures | 1.3595 | 1.3599 | 1.3523 | 1.3545 | 94983.0 |
| 2019-01-28 | BR | Futures | 0.21233 | 0.21233 | 0.21058 | 0.21125 | 3233.0 |
| 2019-01-28 | BTC | Futures | 5138.5 | 5182.7 | 4902.6 | 4983.7 | 4345.0 |
| 2019-01-28 | BZ | Futures | 43.98 | 44.2 | 42.61 | 42.91 | 17891.0 |
| 2019-01-28 | C | Futures | 1402.0 | 1434.0 | 1397.0 | 1407.0 | 9196.0 |
| 2019-01-28 | CB | Futures | 273.959 | 275.174 | 273.959 | 275.174 | 21.0 |
| 2019-01-28 | CC | Futures | 1534.0 | 1587.0 | 1532.0 | 1550.0 | 23225.0 |
| 2019-01-28 | CNH | Futures | 6.7618 | 6.7716 | 6.747 | 6.7664 | 473.0 |
| 2019-01-28 | CSC | Futures | 2.68 | 2.697 | 2.669 | 2.676 | 108.0 |
| 2019-01-28 | CT | Futures | 80.61 | 80.75 | 79.68 | 80.45 | 11814.0 |
| 2019-01-28 | DC | Futures | 22.82 | 22.98 | 22.66 | 22.83 | 331.0 |
| 2019-01-28 | DX | Futures | 91.031 | 91.169 | 90.902 | 91.006 | 11815.0 |
| 2019-01-28 | E1 | Futures | 1.18924 | 1.19241 | 1.18912 | 1.19112 | 12935.0 |
| 2019-01-28 | E6 | Futures | 1.26569 | 1.26972 | 1.26376 | 1.26801 | 141624.0 |
| 2019-01-28 | E7 | Futures | 1.2597 | 1.2635 | 1.2576 | 1.2618 | 2471.0 |
| 2019-01-28 | EBM | Futures | 211.8 | 212.05 | 210.51 | 210.77 | 13658.0 |
| 2019-01-28 | ED | Futures | 95.0281 | 95.033 | 95.0232 | 95.033 | 123467.0 |
| 2019-01-28 | ER | Futures | 98.401 | 98.401 | 98.396 | 98.401 | 18785.0 |
| 2019-01-28 | EW | Futures | 1937.3 | 1937.3 | 1918.4 | 1934.4 | 12858.0 |
| 2019-01-28 | FBON | Futures | 131.83 | 131.84 | 131.53 | 131.8 | 384.0 |
| 2019-01-28 | FBTP | Futures | 112.88 | 112.9 | 112.3 | 112.6 | 72803.0 |
| 2019-01-28 | FBTS | Futures | 105.436 | 105.465 | 105.342 | 105.427 | 32047.0 |
| 2019-01-28 | FCE | Futures | 4384.1 | 4398.0 | 4359.5 | 4376.5 | 60315.0 |
| 2019-01-28 | FDAX | Futures | 11825.3 | 11846.8 | 11742.8 | 11777.4 | 86639.0 |
| 2019-01-28 | FDIV | Futures | 137.29 | 137.29 | 137.11 | 137.11 | 4.0 |
| 2019-01-28 | FDXM | Futures | 11800.6 | 11818.5 | 11713.6 | 11748.8 | 38811.0 |
| 2019-01-28 | FESX | Futures | 2688.5 | 2690.2 | 2664.6 | 2672.2 | 829668.0 |
| 2019-01-28 | FGBL | Futures | 157.06 | 157.17 | 156.59 | 156.8 | 647991.0 |
| 2019-01-28 | FGBM | Futures | 132.23 | 132.28 | 132.12 | 132.21 | 380735.0 |
| 2019-01-28 | FGBS | Futures | 112.698 | 112.708 | 112.683 | 112.703 | 184306.0 |
| 2019-01-28 | FGBX | Futures | 187.67 | 187.82 | 186.05 | 186.38 | 40988.0 |
| 2019-01-28 | FMWO | Futures | 6706.7 | 6706.7 | 6644.9 | 6667.1 | 1853.0 |
| 2019-01-28 | FOAT | Futures | 142.82 | 142.83 | 142.43 | 142.6 | 132856.0 |
| 2019-01-28 | FTDX | Futures | 2621.8 | 2639.7 | 2602.0 | 2607.4 | 379.0 |
| 2019-01-28 | FTI | Futures | 483.04 | 484.45 | 479.77 | 481.4 | 22338.0 |
| 2019-01-28 | FTUK | Futures | 6130.1 | 6150.6 | 6076.3 | 6093.2 | 91145.0 |
| 2019-01-28 | FVSA | Futures | 312.32 | 325.45 | 307.63 | 319.82 | 17482.0 |
| 2019-01-28 | FXXP | Futures | 311.3 | 312.4 | 308.9 | 309.8 | 44422.0 |
| 2019-01-28 | G | Futures | 116.24 | 116.84 | 116.24 | 116.72 | 183242.0 |
| 2019-01-28 | GF | Futures | 312.721 | 316.438 | 312.611 | 315.673 | 4710.0 |
| 2019-01-28 | GSCI | Futures | 459.65 | 459.65 | 457.76 | 458.22 | 82.0 |
> showing 50 of 116 rows — these rows as CSV