PREVIEW / futures_daily / 2018-06-15
file: by_date/futures_daily/2018/2018-06-15.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-06-15 | ES | Futures | 3026.95 | 3028.58 | 3003.6 | 3024.24 | 1512061.0 |
| 2018-06-15 | NQ | Futures | 8523.03 | 8532.95 | 8446.96 | 8489.52 | 364647.0 |
| 2018-06-15 | YM | Futures | 26572.0 | 26573.1 | 26245.4 | 26457.2 | 240917.0 |
| 2018-06-15 | CL | Futures | 67.68 | 67.75 | 64.92 | 65.69 | 387347.0 |
| 2018-06-15 | GC | Futures | 1667.2 | 1668.2 | 1631.5 | 1632.2 | 525960.0 |
| 2018-06-15 | ZN | Futures | 118.810822 | 119.199296 | 118.795283 | 118.935134 | 1634656.0 |
| 2018-06-15 | A6 | Futures | 0.76912 | 0.76974 | 0.76552 | 0.76645 | 109895.0 |
| 2018-06-15 | AD | Futures | 0.77411 | 0.77442 | 0.76804 | 0.76971 | 107927.0 |
| 2018-06-15 | B | Futures | 55.64 | 55.7 | 53.46 | 53.78 | 285802.0 |
| 2018-06-15 | B6 | Futures | 1.3741 | 1.3778 | 1.3687 | 1.376 | 110412.0 |
| 2018-06-15 | BFX | Futures | 4394.2 | 4400.5 | 4394.2 | 4400.5 | 28.0 |
| 2018-06-15 | BR | Futures | 0.20007 | 0.20289 | 0.19824 | 0.20289 | 276.0 |
| 2018-06-15 | BTC | Futures | 9479.0 | 9479.0 | 9152.1 | 9280.0 | 2485.0 |
| 2018-06-15 | BZ | Futures | 55.13 | 55.18 | 53.01 | 53.27 | 30144.0 |
| 2018-06-15 | C | Futures | 1534.0 | 1598.0 | 1521.0 | 1592.0 | 5306.0 |
| 2018-06-15 | CB | Futures | 289.014 | 289.703 | 287.874 | 287.874 | 55.0 |
| 2018-06-15 | CC | Futures | 1732.0 | 1811.0 | 1715.0 | 1806.0 | 28115.0 |
| 2018-06-15 | CNH | Futures | 6.509 | 6.5281 | 6.5023 | 6.5276 | 63.0 |
| 2018-06-15 | CSC | Futures | 3.429 | 3.429 | 3.385 | 3.411 | 188.0 |
| 2018-06-15 | CT | Futures | 105.88 | 105.88 | 102.88 | 103.13 | 21715.0 |
| 2018-06-15 | DC | Futures | 27.58 | 27.69 | 27.11 | 27.31 | 266.0 |
| 2018-06-15 | DX | Futures | 89.615 | 89.804 | 89.321 | 89.451 | 36257.0 |
| 2018-06-15 | E1 | Futures | 1.20827 | 1.21102 | 1.20576 | 1.20767 | 33977.0 |
| 2018-06-15 | E6 | Futures | 1.30318 | 1.30928 | 1.29977 | 1.30693 | 321630.0 |
| 2018-06-15 | E7 | Futures | 1.2968 | 1.3026 | 1.2933 | 1.3003 | 7909.0 |
| 2018-06-15 | EBM | Futures | 187.53 | 188.31 | 185.17 | 185.7 | 28166.0 |
| 2018-06-15 | ED | Futures | 94.9572 | 94.9815 | 94.9474 | 94.9669 | 279262.0 |
| 2018-06-15 | ER | Futures | 98.357 | 98.362 | 98.357 | 98.362 | 75804.0 |
| 2018-06-15 | EW | Futures | 2118.7 | 2120.0 | 2100.2 | 2113.4 | 18584.0 |
| 2018-06-15 | FBON | Futures | 129.19 | 129.57 | 129.12 | 129.3 | 275.0 |
| 2018-06-15 | FBTP | Futures | 107.08 | 108.54 | 106.94 | 108.18 | 106799.0 |
| 2018-06-15 | FBTS | Futures | 102.485 | 102.995 | 102.308 | 102.754 | 50432.0 |
| 2018-06-15 | FCE | Futures | 4967.8 | 4991.6 | 4932.7 | 4938.6 | 96980.0 |
| 2018-06-15 | FDAX | Futures | 13658.8 | 13688.9 | 13565.3 | 13586.2 | 9461.0 |
| 2018-06-15 | FDIV | Futures | 155.01 | 155.01 | 154.33 | 154.33 | 124.0 |
| 2018-06-15 | FDXM | Futures | 13550.9 | 13575.7 | 13402.3 | 13431.2 | 39220.0 |
| 2018-06-15 | FESX | Futures | 2944.1 | 2950.8 | 2916.5 | 2925.7 | 1460793.0 |
| 2018-06-15 | FEU3 | Futures | 99.016 | 99.016 | 99.011 | 99.011 | 8.0 |
| 2018-06-15 | FGBL | Futures | 151.59 | 152.2 | 151.47 | 151.86 | 792768.0 |
| 2018-06-15 | FGBM | Futures | 130.62 | 130.87 | 130.55 | 130.73 | 545088.0 |
| 2018-06-15 | FGBS | Futures | 112.688 | 112.718 | 112.668 | 112.678 | 328865.0 |
| 2018-06-15 | FGBX | Futures | 172.75 | 173.95 | 172.35 | 172.69 | 69879.0 |
| 2018-06-15 | FMWO | Futures | 7084.6 | 7084.6 | 7084.6 | 7084.6 | 0.0 |
| 2018-06-15 | FOAT | Futures | 139.75 | 140.4 | 139.72 | 140.2 | 181797.0 |
| 2018-06-15 | FTDX | Futures | 2891.7 | 2891.7 | 2801.9 | 2817.1 | 468.0 |
| 2018-06-15 | FTI | Futures | 524.24 | 525.35 | 518.1 | 518.38 | 32542.0 |
| 2018-06-15 | FTUK | Futures | 6866.9 | 6874.4 | 6735.9 | 6754.6 | 154160.0 |
| 2018-06-15 | FVSA | Futures | 265.32 | 277.96 | 261.43 | 274.07 | 26113.0 |
| 2018-06-15 | FXXP | Futures | 339.1 | 339.2 | 334.4 | 335.5 | 58345.0 |
| 2018-06-15 | G | Futures | 115.23 | 115.33 | 114.75 | 115.03 | 214678.0 |
> showing 50 of 116 rows — these rows as CSV