PREVIEW / futures_daily / 2019-02-06
file: by_date/futures_daily/2019/2019-02-06.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-02-06 | ES | Futures | 2956.5 | 2962.73 | 2947.3 | 2955.15 | 1196377.0 |
| 2019-02-06 | NQ | Futures | 8114.98 | 8149.14 | 8072.15 | 8099.35 | 376560.0 |
| 2019-02-06 | YM | Futures | 26712.1 | 26777.5 | 26640.3 | 26714.2 | 157030.0 |
| 2019-02-06 | CL | Futures | 55.88 | 56.47 | 54.97 | 56.17 | 606720.0 |
| 2019-02-06 | GC | Futures | 1649.2 | 1649.9 | 1637.0 | 1643.0 | 137247.0 |
| 2019-02-06 | ZN | Futures | 121.378116 | 121.611536 | 121.315871 | 121.393677 | 1087271.0 |
| 2019-02-06 | A6 | Futures | 0.74569 | 0.74682 | 0.73219 | 0.73343 | 135431.0 |
| 2019-02-06 | AD | Futures | 0.772 | 0.77205 | 0.76673 | 0.76749 | 65752.0 |
| 2019-02-06 | B | Futures | 44.99 | 45.53 | 44.26 | 45.45 | 225570.0 |
| 2019-02-06 | B6 | Futures | 1.333 | 1.3354 | 1.3298 | 1.3311 | 67184.0 |
| 2019-02-06 | BR | Futures | 0.21712 | 0.21712 | 0.21436 | 0.21544 | 3705.0 |
| 2019-02-06 | BTC | Futures | 5020.5 | 5042.7 | 4880.5 | 4924.7 | 3783.0 |
| 2019-02-06 | BZ | Futures | 44.51 | 45.05 | 43.8 | 44.97 | 26542.0 |
| 2019-02-06 | C | Futures | 1472.0 | 1505.0 | 1472.0 | 1496.0 | 19557.0 |
| 2019-02-06 | CB | Futures | 277.604 | 277.604 | 277.3 | 277.604 | 12.0 |
| 2019-02-06 | CC | Futures | 1532.0 | 1556.0 | 1528.0 | 1539.0 | 35943.0 |
| 2019-02-06 | CNH | Futures | 6.7679 | 6.7876 | 6.7679 | 6.7876 | 124.0 |
| 2019-02-06 | CSC | Futures | 2.687 | 2.7 | 2.687 | 2.7 | 71.0 |
| 2019-02-06 | CT | Futures | 79.96 | 80.73 | 79.63 | 80.24 | 20600.0 |
| 2019-02-06 | DC | Futures | 22.85 | 23.04 | 22.79 | 23.03 | 321.0 |
| 2019-02-06 | DX | Futures | 91.383 | 91.732 | 91.35 | 91.7 | 13756.0 |
| 2019-02-06 | E1 | Futures | 1.17995 | 1.18171 | 1.17689 | 1.17713 | 13499.0 |
| 2019-02-06 | E6 | Futures | 1.26436 | 1.26486 | 1.25939 | 1.25983 | 132693.0 |
| 2019-02-06 | E7 | Futures | 1.2582 | 1.2586 | 1.2532 | 1.2537 | 2747.0 |
| 2019-02-06 | EBM | Futures | 210.25 | 210.51 | 208.97 | 209.23 | 19447.0 |
| 2019-02-06 | ED | Futures | 95.0428 | 95.0476 | 95.033 | 95.0379 | 172433.0 |
| 2019-02-06 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.401 | 22890.0 |
| 2019-02-06 | EW | Futures | 1983.2 | 1990.0 | 1977.6 | 1984.3 | 12794.0 |
| 2019-02-06 | FBON | Futures | 131.67 | 131.81 | 131.62 | 131.68 | 387.0 |
| 2019-02-06 | FBTP | Futures | 111.39 | 111.54 | 110.96 | 111.19 | 167321.0 |
| 2019-02-06 | FBTS | Futures | 104.973 | 105.001 | 104.84 | 104.935 | 46888.0 |
| 2019-02-06 | FCE | Futures | 4544.9 | 4553.4 | 4529.2 | 4548.1 | 53655.0 |
| 2019-02-06 | FDAX | Futures | 11934.5 | 11950.8 | 11865.2 | 11889.9 | 77057.0 |
| 2019-02-06 | FDIV | Futures | 139.08 | 139.44 | 139.08 | 139.21 | 5.0 |
| 2019-02-06 | FDXM | Futures | 11900.2 | 11919.1 | 11836.3 | 11860.9 | 32835.0 |
| 2019-02-06 | FESX | Futures | 2741.5 | 2745.7 | 2730.4 | 2739.8 | 861185.0 |
| 2019-02-06 | FGBL | Futures | 157.28 | 157.53 | 157.23 | 157.37 | 492634.0 |
| 2019-02-06 | FGBM | Futures | 132.28 | 132.35 | 132.22 | 132.23 | 341065.0 |
| 2019-02-06 | FGBS | Futures | 112.658 | 112.678 | 112.638 | 112.643 | 194841.0 |
| 2019-02-06 | FGBX | Futures | 187.59 | 188.46 | 187.53 | 187.96 | 37195.0 |
| 2019-02-06 | FMWO | Futures | 6869.9 | 6886.2 | 6865.2 | 6875.7 | 2699.0 |
| 2019-02-06 | FOAT | Futures | 143.02 | 143.19 | 142.98 | 143.07 | 122700.0 |
| 2019-02-06 | FTDX | Futures | 2590.0 | 2618.9 | 2590.0 | 2606.9 | 317.0 |
| 2019-02-06 | FTI | Futures | 502.32 | 506.34 | 500.71 | 505.68 | 21909.0 |
| 2019-02-06 | FTUK | Futures | 6475.7 | 6486.2 | 6449.8 | 6474.4 | 115210.0 |
| 2019-02-06 | FVSA | Futures | 270.11 | 272.92 | 264.48 | 267.3 | 25248.0 |
| 2019-02-06 | FXXP | Futures | 319.1 | 320.1 | 318.5 | 319.6 | 47414.0 |
| 2019-02-06 | G | Futures | 117.3 | 117.32 | 117.06 | 117.22 | 177752.0 |
| 2019-02-06 | GF | Futures | 314.47 | 316.001 | 312.775 | 313.103 | 4922.0 |
| 2019-02-06 | GSCI | Futures | 466.56 | 469.99 | 466.56 | 469.99 | 4.0 |
> showing 50 of 116 rows — these rows as CSV