PREVIEW / futures_daily / 2018-08-30
file: by_date/futures_daily/2018/2018-08-30.parquet size: 10 KB rows: 115
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-30 | ES | Futures | 3166.79 | 3167.33 | 3144.8 | 3151.86 | 1331841.0 |
| 2018-08-30 | NQ | Futures | 8945.67 | 8973.95 | 8891.46 | 8917.98 | 390929.0 |
| 2018-08-30 | YM | Futures | 27559.3 | 27573.0 | 27339.1 | 27406.5 | 141399.0 |
| 2018-08-30 | CL | Futures | 72.61 | 73.43 | 72.44 | 73.17 | 445584.0 |
| 2018-08-30 | GC | Futures | 1536.9 | 1538.6 | 1523.6 | 1527.2 | 288072.0 |
| 2018-08-30 | ZN | Futures | 119.416841 | 119.665465 | 119.385764 | 119.603309 | 1419186.0 |
| 2018-08-30 | A6 | Futures | 0.75185 | 0.75215 | 0.74557 | 0.74639 | 109213.0 |
| 2018-08-30 | AD | Futures | 0.78475 | 0.78521 | 0.77933 | 0.77999 | 79586.0 |
| 2018-08-30 | B | Futures | 56.6 | 57.08 | 56.49 | 56.87 | 260166.0 |
| 2018-08-30 | B6 | Futures | 1.3454 | 1.3464 | 1.3404 | 1.3434 | 97139.0 |
| 2018-08-30 | BR | Futures | 0.18304 | 0.18304 | 0.17969 | 0.18098 | 259.0 |
| 2018-08-30 | BTC | Futures | 10068.5 | 10075.6 | 9703.8 | 9732.4 | 752.0 |
| 2018-08-30 | BZ | Futures | 56.37 | 56.83 | 56.26 | 56.62 | 19343.0 |
| 2018-08-30 | C | Futures | 1565.0 | 1577.0 | 1533.0 | 1535.0 | 2701.0 |
| 2018-08-30 | CC | Futures | 1642.0 | 1643.0 | 1582.0 | 1589.0 | 18317.0 |
| 2018-08-30 | CNH | Futures | 6.8952 | 6.946 | 6.8952 | 6.9434 | 225.0 |
| 2018-08-30 | CSC | Futures | 3.325 | 3.325 | 3.325 | 3.325 | 17.0 |
| 2018-08-30 | CT | Futures | 93.02 | 93.02 | 92.11 | 92.48 | 15.0 |
| 2018-08-30 | DC | Futures | 27.23 | 27.28 | 27.09 | 27.21 | 94.0 |
| 2018-08-30 | DX | Futures | 89.459 | 89.833 | 89.402 | 89.671 | 21374.0 |
| 2018-08-30 | E1 | Futures | 1.23313 | 1.23516 | 1.23145 | 1.23408 | 31207.0 |
| 2018-08-30 | E6 | Futures | 1.3109 | 1.31202 | 1.30335 | 1.30592 | 246754.0 |
| 2018-08-30 | E7 | Futures | 1.3043 | 1.3053 | 1.2968 | 1.2993 | 4068.0 |
| 2018-08-30 | EBM | Futures | 215.77 | 217.87 | 208.97 | 209.5 | 8985.0 |
| 2018-08-30 | ED | Futures | 95.0862 | 95.0911 | 95.0789 | 95.0813 | 247909.0 |
| 2018-08-30 | ER | Futures | 98.367 | 98.372 | 98.362 | 98.367 | 48899.0 |
| 2018-08-30 | EW | Futures | 2173.5 | 2174.0 | 2157.7 | 2160.6 | 9436.0 |
| 2018-08-30 | FBON | Futures | 128.63 | 128.78 | 128.5 | 128.65 | 584.0 |
| 2018-08-30 | FBTP | Futures | 104.67 | 104.95 | 103.71 | 104.06 | 210051.0 |
| 2018-08-30 | FBTS | Futures | 101.882 | 101.984 | 101.409 | 101.65 | 115263.0 |
| 2018-08-30 | FCE | Futures | 4956.8 | 4956.8 | 4920.7 | 4936.5 | 60874.0 |
| 2018-08-30 | FDAX | Futures | 13111.1 | 13112.1 | 12954.8 | 13054.1 | 91063.0 |
| 2018-08-30 | FDIV | Futures | 148.41 | 149.26 | 148.41 | 149.26 | 7.0 |
| 2018-08-30 | FDXM | Futures | 12946.2 | 12946.2 | 12789.3 | 12887.4 | 44352.0 |
| 2018-08-30 | FESX | Futures | 2880.6 | 2881.4 | 2854.7 | 2864.7 | 812580.0 |
| 2018-08-30 | FGBL | Futures | 152.91 | 153.67 | 152.77 | 153.57 | 865703.0 |
| 2018-08-30 | FGBM | Futures | 130.95 | 131.28 | 130.91 | 131.26 | 680370.0 |
| 2018-08-30 | FGBS | Futures | 112.623 | 112.688 | 112.613 | 112.673 | 702132.0 |
| 2018-08-30 | FGBX | Futures | 176.39 | 178.46 | 176.17 | 178.18 | 52610.0 |
| 2018-08-30 | FMWO | Futures | 7286.1 | 7288.4 | 7265.1 | 7268.6 | 1053.0 |
| 2018-08-30 | FOAT | Futures | 140.55 | 141.08 | 140.5 | 141.04 | 272276.0 |
| 2018-08-30 | FTDX | Futures | 2973.0 | 2973.0 | 2945.1 | 2960.8 | 131.0 |
| 2018-08-30 | FTI | Futures | 524.19 | 524.51 | 520.25 | 522.47 | 19932.0 |
| 2018-08-30 | FTUK | Futures | 6734.1 | 6744.4 | 6666.0 | 6688.7 | 89273.0 |
| 2018-08-30 | FVSA | Futures | 255.21 | 274.37 | 253.47 | 265.66 | 43665.0 |
| 2018-08-30 | FXXP | Futures | 333.9 | 334.0 | 332.0 | 333.3 | 45545.0 |
| 2018-08-30 | G | Futures | 114.57 | 114.87 | 114.47 | 114.8 | 264909.0 |
| 2018-08-30 | GF | Futures | 310.845 | 313.55 | 310.325 | 312.405 | 1190.0 |
| 2018-08-30 | GSCI | Futures | 529.73 | 529.73 | 527.19 | 528.71 | 347.0 |
| 2018-08-30 | HE | Futures | 69.534 | 70.584 | 66.251 | 66.521 | 26003.0 |
> showing 50 of 115 rows — these rows as CSV