PREVIEW / futures_daily / 2018-10-01
file: by_date/futures_daily/2018/2018-10-01.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-10-01 | ES | Futures | 3169.48 | 3190.63 | 3169.48 | 3177.62 | 1239963.0 |
| 2018-10-01 | NQ | Futures | 8911.23 | 8977.14 | 8888.0 | 8915.29 | 358159.0 |
| 2018-10-01 | YM | Futures | 27930.9 | 28173.1 | 27922.5 | 28093.1 | 164208.0 |
| 2018-10-01 | CL | Futures | 76.72 | 79.32 | 76.37 | 78.83 | 601451.0 |
| 2018-10-01 | GC | Futures | 1516.0 | 1516.5 | 1505.8 | 1510.4 | 220507.0 |
| 2018-10-01 | ZN | Futures | 118.250032 | 118.296722 | 118.047709 | 118.203342 | 1262949.0 |
| 2018-10-01 | A6 | Futures | 0.74393 | 0.74455 | 0.74198 | 0.74424 | 59122.0 |
| 2018-10-01 | AD | Futures | 0.78811 | 0.79231 | 0.78548 | 0.792 | 108556.0 |
| 2018-10-01 | B | Futures | 60.83 | 62.78 | 60.65 | 62.44 | 347526.0 |
| 2018-10-01 | B6 | Futures | 1.3449 | 1.3537 | 1.3428 | 1.3454 | 94838.0 |
| 2018-10-01 | BR | Futures | 0.18715 | 0.18902 | 0.18715 | 0.18902 | 14.0 |
| 2018-10-01 | BTC | Futures | 9466.3 | 9560.1 | 9314.7 | 9437.4 | 1477.0 |
| 2018-10-01 | BZ | Futures | 60.47 | 62.31 | 60.21 | 61.97 | 34024.0 |
| 2018-10-01 | C | Futures | 1392.0 | 1399.0 | 1347.0 | 1355.0 | 13306.0 |
| 2018-10-01 | CB | Futures | 273.37 | 273.37 | 273.37 | 273.37 | 2.0 |
| 2018-10-01 | CC | Futures | 1434.0 | 1454.0 | 1384.0 | 1390.0 | 33483.0 |
| 2018-10-01 | CNH | Futures | 6.9479 | 6.9522 | 6.9424 | 6.946 | 90.0 |
| 2018-10-01 | CSC | Futures | 3.254 | 3.262 | 3.244 | 3.244 | 29.0 |
| 2018-10-01 | CT | Futures | 85.59 | 86.65 | 84.6 | 85.66 | 31645.0 |
| 2018-10-01 | DC | Futures | 27.03 | 27.13 | 26.98 | 27.01 | 108.0 |
| 2018-10-01 | DX | Futures | 89.973 | 90.248 | 89.873 | 90.181 | 14857.0 |
| 2018-10-01 | E1 | Futures | 1.2169 | 1.2169 | 1.21085 | 1.21263 | 26036.0 |
| 2018-10-01 | E6 | Futures | 1.29896 | 1.30029 | 1.2934 | 1.29468 | 220813.0 |
| 2018-10-01 | E7 | Futures | 1.2925 | 1.2939 | 1.287 | 1.2884 | 3995.0 |
| 2018-10-01 | EBM | Futures | 207.68 | 209.5 | 207.42 | 209.24 | 15511.0 |
| 2018-10-01 | ED | Futures | 95.0671 | 95.0818 | 95.0573 | 95.0671 | 347455.0 |
| 2018-10-01 | ER | Futures | 98.372 | 98.377 | 98.367 | 98.372 | 96002.0 |
| 2018-10-01 | EW | Futures | 2133.7 | 2141.2 | 2107.4 | 2112.5 | 19827.0 |
| 2018-10-01 | FBON | Futures | 127.93 | 127.93 | 127.66 | 127.72 | 370.0 |
| 2018-10-01 | FBTP | Futures | 106.41 | 106.89 | 105.06 | 105.65 | 141572.0 |
| 2018-10-01 | FBTS | Futures | 102.246 | 102.246 | 101.385 | 101.572 | 144913.0 |
| 2018-10-01 | FCE | Futures | 4955.0 | 4973.0 | 4945.5 | 4960.4 | 54857.0 |
| 2018-10-01 | FDAX | Futures | 12891.8 | 12998.0 | 12860.2 | 12963.3 | 72796.0 |
| 2018-10-01 | FDIV | Futures | 146.03 | 146.17 | 146.03 | 146.17 | 9.0 |
| 2018-10-01 | FDXM | Futures | 12669.5 | 12771.8 | 12639.6 | 12738.8 | 36553.0 |
| 2018-10-01 | FESX | Futures | 2848.6 | 2867.1 | 2843.6 | 2857.0 | 731423.0 |
| 2018-10-01 | FGBL | Futures | 151.92 | 152.16 | 151.56 | 151.95 | 736060.0 |
| 2018-10-01 | FGBM | Futures | 130.35 | 130.55 | 130.26 | 130.45 | 513316.0 |
| 2018-10-01 | FGBS | Futures | 112.517 | 112.573 | 112.492 | 112.542 | 579274.0 |
| 2018-10-01 | FGBX | Futures | 175.68 | 175.88 | 174.4 | 175.25 | 48333.0 |
| 2018-10-01 | FMWO | Futures | 7303.1 | 7321.6 | 7301.9 | 7318.1 | 1247.0 |
| 2018-10-01 | FOAT | Futures | 139.52 | 139.67 | 139.33 | 139.56 | 156885.0 |
| 2018-10-01 | FTDX | Futures | 2781.7 | 2804.8 | 2781.7 | 2798.4 | 196.0 |
| 2018-10-01 | FTI | Futures | 510.46 | 514.08 | 510.04 | 512.64 | 20425.0 |
| 2018-10-01 | FTUK | Futures | 6694.7 | 6694.7 | 6634.8 | 6673.7 | 83843.0 |
| 2018-10-01 | FVSA | Futures | 256.21 | 259.66 | 250.17 | 256.21 | 27199.0 |
| 2018-10-01 | FXXP | Futures | 331.0 | 332.1 | 330.1 | 331.6 | 56986.0 |
| 2018-10-01 | G | Futures | 113.75 | 113.78 | 113.39 | 113.71 | 232563.0 |
| 2018-10-01 | GF | Futures | 329.516 | 331.96 | 327.956 | 330.036 | 2638.0 |
| 2018-10-01 | GSCI | Futures | 545.86 | 555.94 | 543.9 | 555.94 | 316.0 |
> showing 50 of 115 rows — these rows as CSV