PREVIEW / futures_daily / 2019-05-13
file: by_date/futures_daily/2019/2019-05-13.parquet size: 10 KB rows: 118
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-05-13 | ES | Futures | 3087.68 | 3099.29 | 3026.65 | 3032.05 | 2790074.0 |
| 2019-05-13 | NQ | Futures | 8681.0 | 8700.87 | 8416.86 | 8428.09 | 773473.0 |
| 2019-05-13 | YM | Futures | 27195.4 | 27252.4 | 26615.9 | 26685.5 | 357279.0 |
| 2019-05-13 | CL | Futures | 63.29 | 65.02 | 62.26 | 62.67 | 1003106.0 |
| 2019-05-13 | GC | Futures | 1603.4 | 1620.7 | 1596.1 | 1620.3 | 379440.0 |
| 2019-05-13 | ZN | Futures | 123.414552 | 123.880736 | 123.321315 | 123.740881 | 1832738.0 |
| 2019-05-13 | A6 | Futures | 0.72137 | 0.72188 | 0.71601 | 0.71694 | 113717.0 |
| 2019-05-13 | AD | Futures | 0.75418 | 0.75418 | 0.75034 | 0.7512 | 74456.0 |
| 2019-05-13 | B | Futures | 52.19 | 53.48 | 51.37 | 51.75 | 373469.0 |
| 2019-05-13 | B6 | Futures | 1.3345 | 1.3382 | 1.3279 | 1.3304 | 80073.0 |
| 2019-05-13 | BR | Futures | 0.20212 | 0.20212 | 0.1996 | 0.20096 | 3049.0 |
| 2019-05-13 | BTC | Futures | 11057.4 | 12418.3 | 10624.4 | 12294.6 | 31433.0 |
| 2019-05-13 | BZ | Futures | 52.1 | 53.33 | 51.24 | 51.61 | 62747.0 |
| 2019-05-13 | C | Futures | 1658.0 | 1677.0 | 1649.0 | 1652.0 | 7974.0 |
| 2019-05-13 | CB | Futures | 281.115 | 281.145 | 281.115 | 281.115 | 27.0 |
| 2019-05-13 | CC | Futures | 1553.0 | 1582.0 | 1536.0 | 1540.0 | 14231.0 |
| 2019-05-13 | CNH | Futures | 6.8759 | 6.9369 | 6.8759 | 6.9242 | 1395.0 |
| 2019-05-13 | CSC | Futures | 2.996 | 2.996 | 2.968 | 2.971 | 96.0 |
| 2019-05-13 | CT | Futures | 71.7 | 71.8 | 68.51 | 68.51 | 32758.0 |
| 2019-05-13 | DC | Futures | 24.94 | 25.0 | 24.74 | 24.75 | 345.0 |
| 2019-05-13 | DX | Futures | 93.082 | 93.163 | 92.794 | 93.091 | 17104.0 |
| 2019-05-13 | E1 | Futures | 1.15757 | 1.16492 | 1.15734 | 1.16306 | 29790.0 |
| 2019-05-13 | E6 | Futures | 1.23689 | 1.2398 | 1.23514 | 1.23623 | 160360.0 |
| 2019-05-13 | E7 | Futures | 1.2307 | 1.2337 | 1.2291 | 1.2301 | 3253.0 |
| 2019-05-13 | EBM | Futures | 194.32 | 194.61 | 192.31 | 194.32 | 20202.0 |
| 2019-05-13 | ED | Futures | 95.1941 | 95.2185 | 95.1917 | 95.2112 | 420616.0 |
| 2019-05-13 | ER | Futures | 98.416 | 98.416 | 98.411 | 98.416 | 21950.0 |
| 2019-05-13 | EW | Futures | 2046.0 | 2046.0 | 1984.9 | 1993.0 | 15025.0 |
| 2019-05-13 | FBON | Futures | 136.56 | 136.68 | 136.42 | 136.46 | 771.0 |
| 2019-05-13 | FBTP | Futures | 114.7 | 114.84 | 114.3 | 114.71 | 101458.0 |
| 2019-05-13 | FBTS | Futures | 105.617 | 105.703 | 105.532 | 105.646 | 50402.0 |
| 2019-05-13 | FCE | Futures | 4793.9 | 4793.9 | 4702.2 | 4717.6 | 114117.0 |
| 2019-05-13 | FDAX | Futures | 12735.9 | 12744.3 | 12464.8 | 12507.4 | 141219.0 |
| 2019-05-13 | FDIV | Futures | 143.96 | 143.96 | 142.94 | 142.94 | 90.0 |
| 2019-05-13 | FDXM | Futures | 12632.8 | 12634.9 | 12356.3 | 12399.1 | 70084.0 |
| 2019-05-13 | FESX | Futures | 2911.2 | 2918.2 | 2862.3 | 2871.9 | 1247389.0 |
| 2019-05-13 | FGBL | Futures | 160.53 | 160.8 | 160.31 | 160.72 | 581541.0 |
| 2019-05-13 | FGBM | Futures | 133.33 | 133.41 | 133.27 | 133.39 | 324975.0 |
| 2019-05-13 | FGBS | Futures | 112.824 | 112.855 | 112.809 | 112.849 | 244966.0 |
| 2019-05-13 | FGBX | Futures | 195.06 | 196.66 | 194.53 | 196.19 | 34388.0 |
| 2019-05-13 | FMWO | Futures | 7108.5 | 7108.5 | 6977.8 | 6996.3 | 4747.0 |
| 2019-05-13 | FOAT | Futures | 147.09 | 147.29 | 146.97 | 147.21 | 87520.0 |
| 2019-05-13 | FTDX | Futures | 2760.0 | 2760.0 | 2685.4 | 2704.2 | 727.0 |
| 2019-05-13 | FTI | Futures | 518.67 | 518.9 | 510.5 | 511.69 | 25821.0 |
| 2019-05-13 | FTUK | Futures | 6591.3 | 6595.4 | 6518.4 | 6539.0 | 101732.0 |
| 2019-05-13 | FVSA | Futures | 238.8 | 256.62 | 238.08 | 252.34 | 23363.0 |
| 2019-05-13 | FXXP | Futures | 335.2 | 335.9 | 329.9 | 330.9 | 79361.0 |
| 2019-05-13 | G | Futures | 117.97 | 118.36 | 117.91 | 118.27 | 142347.0 |
| 2019-05-13 | GF | Futures | 286.706 | 286.755 | 280.083 | 280.819 | 8642.0 |
| 2019-05-13 | GSCI | Futures | 488.31 | 488.31 | 488.31 | 488.31 | 2814.0 |
> showing 50 of 118 rows — these rows as CSV