PREVIEW / futures_daily / 2018-08-13
file: by_date/futures_daily/2018/2018-08-13.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 |
|---|---|---|---|---|---|---|---|
| 2018-08-13 | ES | Futures | 3079.9 | 3088.59 | 3062.8 | 3068.77 | 1282874.0 |
| 2018-08-13 | NQ | Futures | 8657.41 | 8719.78 | 8602.32 | 8647.49 | 377939.0 |
| 2018-08-13 | YM | Futures | 26693.2 | 26733.2 | 26490.9 | 26568.9 | 166859.0 |
| 2018-08-13 | CL | Futures | 70.13 | 70.3 | 67.99 | 69.53 | 578219.0 |
| 2018-08-13 | GC | Futures | 1544.2 | 1548.0 | 1519.1 | 1519.5 | 374115.0 |
| 2018-08-13 | ZN | Futures | 119.649926 | 119.820854 | 119.463458 | 119.58777 | 2075482.0 |
| 2018-08-13 | A6 | Futures | 0.74999 | 0.75082 | 0.7465 | 0.74681 | 126237.0 |
| 2018-08-13 | AD | Futures | 0.77067 | 0.77336 | 0.76941 | 0.77098 | 60865.0 |
| 2018-08-13 | B | Futures | 53.21 | 53.28 | 51.79 | 52.93 | 220337.0 |
| 2018-08-13 | B6 | Futures | 1.3176 | 1.3214 | 1.3151 | 1.3175 | 89100.0 |
| 2018-08-13 | BR | Futures | 0.19732 | 0.19801 | 0.19211 | 0.19416 | 4984.0 |
| 2018-08-13 | BTC | Futures | 9124.6 | 9338.2 | 8739.9 | 8875.3 | 7804.0 |
| 2018-08-13 | BZ | Futures | 53.13 | 53.21 | 51.71 | 52.86 | 17644.0 |
| 2018-08-13 | C | Futures | 1473.0 | 1486.0 | 1461.0 | 1465.0 | 3956.0 |
| 2018-08-13 | CB | Futures | 285.445 | 288.534 | 285.445 | 287.544 | 31.0 |
| 2018-08-13 | CC | Futures | 1478.0 | 1511.0 | 1478.0 | 1500.0 | 23323.0 |
| 2018-08-13 | CNH | Futures | 6.9524 | 6.9807 | 6.9518 | 6.9794 | 597.0 |
| 2018-08-13 | CSC | Futures | 3.301 | 3.307 | 3.264 | 3.28 | 58.0 |
| 2018-08-13 | CT | Futures | 95.77 | 95.77 | 92.36 | 93.29 | 38.0 |
| 2018-08-13 | DC | Futures | 26.79 | 26.98 | 26.48 | 26.69 | 486.0 |
| 2018-08-13 | DX | Futures | 91.159 | 91.291 | 90.941 | 91.16 | 20274.0 |
| 2018-08-13 | E1 | Futures | 1.20528 | 1.20803 | 1.20397 | 1.20612 | 27980.0 |
| 2018-08-13 | E6 | Futures | 1.27684 | 1.28182 | 1.27427 | 1.27746 | 325193.0 |
| 2018-08-13 | E7 | Futures | 1.2702 | 1.2752 | 1.2678 | 1.271 | 6895.0 |
| 2018-08-13 | EBM | Futures | 217.6 | 218.39 | 213.94 | 214.2 | 18054.0 |
| 2018-08-13 | ED | Futures | 95.0692 | 95.0765 | 95.0643 | 95.074 | 362298.0 |
| 2018-08-13 | ER | Futures | 98.357 | 98.362 | 98.357 | 98.362 | 36024.0 |
| 2018-08-13 | EW | Futures | 2112.9 | 2122.0 | 2096.6 | 2103.6 | 8840.0 |
| 2018-08-13 | FBON | Futures | 128.98 | 128.99 | 127.86 | 128.63 | 694.0 |
| 2018-08-13 | FBTP | Futures | 105.21 | 105.34 | 104.23 | 104.54 | 96626.0 |
| 2018-08-13 | FBTS | Futures | 96.92 | 101.743 | 96.92 | 101.566 | 47984.0 |
| 2018-08-13 | FCE | Futures | 4856.7 | 4891.9 | 4846.8 | 4875.6 | 66546.0 |
| 2018-08-13 | FDAX | Futures | 12892.1 | 12956.4 | 12873.8 | 12930.3 | 75655.0 |
| 2018-08-13 | FDIV | Futures | 147.69 | 148.05 | 147.51 | 147.78 | 190.0 |
| 2018-08-13 | FDXM | Futures | 12724.3 | 12789.3 | 12709.9 | 12765.1 | 39102.0 |
| 2018-08-13 | FESX | Futures | 2846.4 | 2854.7 | 2837.2 | 2848.9 | 913439.0 |
| 2018-08-13 | FEU3 | Futures | 99.001 | 99.011 | 99.001 | 99.011 | 149.0 |
| 2018-08-13 | FGBL | Futures | 154.02 | 154.17 | 153.8 | 153.93 | 648555.0 |
| 2018-08-13 | FGBM | Futures | 131.48 | 131.59 | 131.37 | 131.45 | 359021.0 |
| 2018-08-13 | FGBS | Futures | 112.729 | 112.764 | 112.708 | 112.729 | 320494.0 |
| 2018-08-13 | FGBX | Futures | 179.86 | 180.08 | 179.24 | 179.52 | 31140.0 |
| 2018-08-13 | FMWO | Futures | 7088.1 | 7127.7 | 7076.4 | 7109.0 | 486.0 |
| 2018-08-13 | FOAT | Futures | 141.24 | 141.25 | 140.97 | 141.04 | 91792.0 |
| 2018-08-13 | FTDX | Futures | 2859.8 | 2882.3 | 2853.4 | 2879.9 | 163.0 |
| 2018-08-13 | FTI | Futures | 519.37 | 521.22 | 518.48 | 519.88 | 8774.0 |
| 2018-08-13 | FTUK | Futures | 6810.7 | 6810.7 | 6763.1 | 6796.0 | 74842.0 |
| 2018-08-13 | FVSA | Futures | 276.11 | 283.08 | 271.76 | 278.72 | 22976.0 |
| 2018-08-13 | FXXP | Futures | 332.0 | 333.2 | 331.4 | 332.8 | 34636.0 |
| 2018-08-13 | G | Futures | 116.04 | 116.1 | 115.68 | 115.77 | 186068.0 |
| 2018-08-13 | GF | Futures | 309.701 | 310.897 | 307.881 | 308.817 | 5709.0 |
> showing 50 of 116 rows — these rows as CSV