PREVIEW / futures_daily / 2018-10-11
file: by_date/futures_daily/2018/2018-10-11.parquet size: 10 KB rows: 117
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-10-11 | ES | Futures | 3011.15 | 3035.28 | 2941.47 | 2977.53 | 4013855.0 |
| 2018-10-11 | NQ | Futures | 8142.59 | 8290.97 | 8023.53 | 8166.69 | 1146270.0 |
| 2018-10-11 | YM | Futures | 26806.3 | 27042.2 | 26213.4 | 26520.9 | 696205.0 |
| 2018-10-11 | CL | Futures | 76.08 | 76.17 | 73.81 | 74.29 | 783962.0 |
| 2018-10-11 | GC | Futures | 1518.2 | 1558.9 | 1514.2 | 1555.9 | 531781.0 |
| 2018-10-11 | ZN | Futures | 117.736442 | 117.985455 | 117.487429 | 117.923202 | 3666139.0 |
| 2018-10-11 | A6 | Futures | 0.72664 | 0.73395 | 0.72634 | 0.73148 | 170719.0 |
| 2018-10-11 | AD | Futures | 0.77557 | 0.77795 | 0.77451 | 0.77598 | 94135.0 |
| 2018-10-11 | B | Futures | 60.59 | 60.71 | 58.63 | 58.97 | 482510.0 |
| 2018-10-11 | B6 | Futures | 1.3612 | 1.3675 | 1.3597 | 1.365 | 118244.0 |
| 2018-10-11 | BR | Futures | 0.20353 | 0.20388 | 0.20129 | 0.20129 | 46.0 |
| 2018-10-11 | BTC | Futures | 9401.3 | 9430.2 | 8701.5 | 8917.9 | 4268.0 |
| 2018-10-11 | BZ | Futures | 60.23 | 60.24 | 58.19 | 58.53 | 48195.0 |
| 2018-10-11 | C | Futures | 1424.0 | 1451.0 | 1421.0 | 1437.0 | 6887.0 |
| 2018-10-11 | CB | Futures | 270.666 | 271.267 | 270.366 | 270.876 | 93.0 |
| 2018-10-11 | CC | Futures | 1453.0 | 1481.0 | 1441.0 | 1464.0 | 19218.0 |
| 2018-10-11 | CNH | Futures | 6.9961 | 7.0115 | 6.9329 | 6.9479 | 930.0 |
| 2018-10-11 | CSC | Futures | 3.188 | 3.188 | 3.164 | 3.174 | 197.0 |
| 2018-10-11 | CT | Futures | 86.28 | 87.28 | 85.48 | 86.22 | 18575.0 |
| 2018-10-11 | DC | Futures | 26.46 | 26.46 | 26.26 | 26.36 | 322.0 |
| 2018-10-11 | DX | Futures | 90.362 | 90.367 | 89.93 | 89.969 | 29203.0 |
| 2018-10-11 | E1 | Futures | 1.20481 | 1.20943 | 1.20137 | 1.20504 | 37319.0 |
| 2018-10-11 | E6 | Futures | 1.28834 | 1.29623 | 1.28817 | 1.29562 | 324112.0 |
| 2018-10-11 | E7 | Futures | 1.2821 | 1.2898 | 1.2819 | 1.2892 | 4954.0 |
| 2018-10-11 | EBM | Futures | 210.53 | 213.13 | 210.01 | 211.57 | 18143.0 |
| 2018-10-11 | ED | Futures | 95.0671 | 95.0769 | 95.0427 | 95.0525 | 519004.0 |
| 2018-10-11 | ER | Futures | 98.377 | 98.377 | 98.372 | 98.377 | 29672.0 |
| 2018-10-11 | EW | Futures | 1995.7 | 2008.4 | 1961.2 | 1965.4 | 47834.0 |
| 2018-10-11 | FBON | Futures | 127.17 | 127.26 | 126.55 | 126.58 | 565.0 |
| 2018-10-11 | FBTP | Futures | 102.96 | 103.72 | 102.81 | 103.13 | 110366.0 |
| 2018-10-11 | FBTS | Futures | 101.188 | 101.319 | 100.907 | 101.001 | 86718.0 |
| 2018-10-11 | FCE | Futures | 4614.7 | 4665.2 | 4557.9 | 4602.1 | 170032.0 |
| 2018-10-11 | FDAX | Futures | 12092.6 | 12289.2 | 11969.6 | 12134.1 | 213480.0 |
| 2018-10-11 | FDIV | Futures | 139.21 | 139.21 | 138.05 | 138.05 | 6.0 |
| 2018-10-11 | FDXM | Futures | 11893.5 | 12077.4 | 11762.3 | 11924.0 | 129473.0 |
| 2018-10-11 | FESX | Futures | 2687.3 | 2725.1 | 2657.1 | 2689.9 | 2411910.0 |
| 2018-10-11 | FEU3 | Futures | 98.996 | 99.001 | 98.996 | 99.001 | 200.0 |
| 2018-10-11 | FGBL | Futures | 151.53 | 151.89 | 151.32 | 151.54 | 927373.0 |
| 2018-10-11 | FGBM | Futures | 130.37 | 130.53 | 130.24 | 130.34 | 482373.0 |
| 2018-10-11 | FGBS | Futures | 112.547 | 112.567 | 112.522 | 112.542 | 427681.0 |
| 2018-10-11 | FGBX | Futures | 174.02 | 174.89 | 173.74 | 174.24 | 48511.0 |
| 2018-10-11 | FMWO | Futures | 6879.0 | 6933.5 | 6768.9 | 6853.5 | 7115.0 |
| 2018-10-11 | FOAT | Futures | 139.1 | 139.39 | 138.82 | 138.96 | 177325.0 |
| 2018-10-11 | FTDX | Futures | 2451.7 | 2539.1 | 2418.8 | 2500.8 | 837.0 |
| 2018-10-11 | FTI | Futures | 485.8 | 486.27 | 480.67 | 481.32 | 66.0 |
| 2018-10-11 | FTUK | Futures | 6308.6 | 6311.3 | 6159.3 | 6240.7 | 263129.0 |
| 2018-10-11 | FVSA | Futures | 347.65 | 361.46 | 325.23 | 342.48 | 92276.0 |
| 2018-10-11 | FXXP | Futures | 311.2 | 314.1 | 307.0 | 310.7 | 153401.0 |
| 2018-10-11 | G | Futures | 112.84 | 112.96 | 112.63 | 112.88 | 304041.0 |
| 2018-10-11 | GF | Futures | 324.472 | 327.019 | 324.264 | 325.928 | 7390.0 |
> showing 50 of 117 rows — these rows as CSV