PREVIEW / futures_daily / 2018-06-12
file: by_date/futures_daily/2018/2018-06-12.parquet size: 10 KB rows: 114
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-06-12 | ES | Futures | 3024.52 | 3033.76 | 3021.53 | 3027.51 | 988748.0 |
| 2018-06-12 | NQ | Futures | 8386.16 | 8449.65 | 8375.04 | 8426.53 | 112997.0 |
| 2018-06-12 | YM | Futures | 26701.6 | 26768.0 | 26614.2 | 26674.2 | 140449.0 |
| 2018-06-12 | CL | Futures | 66.48 | 67.13 | 66.3 | 66.79 | 524411.0 |
| 2018-06-12 | GC | Futures | 1665.4 | 1665.8 | 1655.0 | 1658.9 | 236393.0 |
| 2018-06-12 | ZN | Futures | 118.779744 | 118.888517 | 118.577738 | 118.748667 | 1236771.0 |
| 2018-06-12 | A6 | Futures | 0.78301 | 0.78455 | 0.77859 | 0.7791 | 20264.0 |
| 2018-06-12 | AD | Futures | 0.78151 | 0.78176 | 0.77877 | 0.77953 | 37734.0 |
| 2018-06-12 | B | Futures | 56.02 | 56.44 | 55.24 | 55.56 | 260327.0 |
| 2018-06-12 | B6 | Futures | 1.3865 | 1.3912 | 1.3827 | 1.3862 | 48719.0 |
| 2018-06-12 | BR | Futures | 0.20212 | 0.20323 | 0.20125 | 0.20323 | 6.0 |
| 2018-06-12 | BTC | Futures | 9621.1 | 9791.6 | 9130.8 | 9237.4 | 3875.0 |
| 2018-06-12 | BZ | Futures | 55.46 | 55.91 | 54.73 | 55.04 | 26330.0 |
| 2018-06-12 | C | Futures | 1525.0 | 1552.0 | 1510.0 | 1533.0 | 5040.0 |
| 2018-06-12 | CB | Futures | 295.04 | 295.04 | 292.192 | 293.241 | 25.0 |
| 2018-06-12 | CC | Futures | 1728.0 | 1760.0 | 1715.0 | 1752.0 | 30155.0 |
| 2018-06-12 | CNH | Futures | 6.4912 | 6.4961 | 6.491 | 6.4961 | 243.0 |
| 2018-06-12 | CSC | Futures | 3.446 | 3.456 | 3.435 | 3.446 | 68.0 |
| 2018-06-12 | CT | Futures | 108.21 | 108.96 | 107.62 | 108.23 | 21458.0 |
| 2018-06-12 | DC | Futures | 27.93 | 27.99 | 27.74 | 27.93 | 202.0 |
| 2018-06-12 | DX | Futures | 88.341 | 88.573 | 88.128 | 88.465 | 5831.0 |
| 2018-06-12 | E1 | Futures | 1.22285 | 1.22596 | 1.21938 | 1.22213 | 15907.0 |
| 2018-06-12 | E6 | Futures | 1.32762 | 1.33041 | 1.32186 | 1.3237 | 133984.0 |
| 2018-06-12 | E7 | Futures | 1.3202 | 1.3235 | 1.3153 | 1.317 | 1190.0 |
| 2018-06-12 | EBM | Futures | 189.62 | 192.23 | 188.57 | 191.97 | 20659.0 |
| 2018-06-12 | ED | Futures | 94.9669 | 94.9669 | 94.9523 | 94.9572 | 231602.0 |
| 2018-06-12 | ER | Futures | 98.342 | 98.352 | 98.342 | 98.347 | 76558.0 |
| 2018-06-12 | EW | Futures | 2123.6 | 2132.9 | 2120.3 | 2127.3 | 22297.0 |
| 2018-06-12 | FBON | Futures | 127.78 | 127.96 | 127.68 | 127.73 | 186.0 |
| 2018-06-12 | FBTP | Futures | 106.11 | 106.65 | 105.48 | 105.56 | 85527.0 |
| 2018-06-12 | FBTS | Futures | 101.743 | 102.346 | 101.659 | 101.817 | 62440.0 |
| 2018-06-12 | FCE | Futures | 4918.8 | 4935.0 | 4886.9 | 4893.6 | 164425.0 |
| 2018-06-12 | FDAX | Futures | 13398.5 | 13461.4 | 13312.3 | 13342.9 | 166055.0 |
| 2018-06-12 | FDIV | Futures | 152.18 | 152.27 | 152.18 | 152.27 | 15.0 |
| 2018-06-12 | FDXM | Futures | 13296.0 | 13345.6 | 13206.2 | 13233.6 | 2122.0 |
| 2018-06-12 | FESX | Futures | 2900.7 | 2911.5 | 2889.0 | 2893.1 | 2296612.0 |
| 2018-06-12 | FEU3 | Futures | 99.006 | 99.006 | 98.996 | 98.996 | 108.0 |
| 2018-06-12 | FGBL | Futures | 150.61 | 150.69 | 150.17 | 150.62 | 635154.0 |
| 2018-06-12 | FGBM | Futures | 130.17 | 130.17 | 129.96 | 130.14 | 489462.0 |
| 2018-06-12 | FGBS | Futures | 112.628 | 112.633 | 112.578 | 112.608 | 234072.0 |
| 2018-06-12 | FGBX | Futures | 171.93 | 172.31 | 171.07 | 172.09 | 51318.0 |
| 2018-06-12 | FMWO | Futures | 7137.1 | 7141.8 | 7125.4 | 7133.6 | 13149.0 |
| 2018-06-12 | FOAT | Futures | 138.08 | 138.31 | 137.89 | 138.25 | 143497.0 |
| 2018-06-12 | FTDX | Futures | 2796.1 | 2817.1 | 2790.7 | 2804.9 | 903.0 |
| 2018-06-12 | FTI | Futures | 522.72 | 524.15 | 518.75 | 519.35 | 28505.0 |
| 2018-06-12 | FTUK | Futures | 6848.6 | 6856.6 | 6792.5 | 6805.4 | 382955.0 |
| 2018-06-12 | FVSA | Futures | 296.42 | 296.42 | 287.68 | 289.62 | 10540.0 |
| 2018-06-12 | FXXP | Futures | 335.4 | 335.4 | 333.1 | 333.7 | 198672.0 |
| 2018-06-12 | G | Futures | 114.09 | 114.33 | 113.83 | 114.3 | 173967.0 |
| 2018-06-12 | GF | Futures | 301.724 | 303.485 | 299.342 | 302.035 | 4751.0 |
> showing 50 of 114 rows — these rows as CSV