PREVIEW / futures_daily / 2018-06-07
file: by_date/futures_daily/2018/2018-06-07.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-07 | ES | Futures | 3015.82 | 3022.89 | 3001.41 | 3014.73 | 1773923.0 |
| 2018-06-07 | NQ | Futures | 8447.6 | 8467.21 | 8329.68 | 8381.47 | 410243.0 |
| 2018-06-07 | YM | Futures | 26490.9 | 26679.5 | 26460.4 | 26617.3 | 227962.0 |
| 2018-06-07 | CL | Futures | 65.49 | 66.5 | 65.23 | 66.38 | 675041.0 |
| 2018-06-07 | GC | Futures | 1660.8 | 1669.6 | 1658.4 | 1663.5 | 259648.0 |
| 2018-06-07 | ZN | Futures | 118.733705 | 119.400574 | 118.594127 | 119.028368 | 21426.0 |
| 2018-06-07 | A6 | Futures | 0.78866 | 0.78897 | 0.7828 | 0.78363 | 101509.0 |
| 2018-06-07 | AD | Futures | 0.78171 | 0.78227 | 0.77832 | 0.77969 | 72503.0 |
| 2018-06-07 | B | Futures | 55.56 | 56.71 | 55.24 | 56.62 | 327984.0 |
| 2018-06-07 | B6 | Futures | 1.39 | 1.3957 | 1.3852 | 1.391 | 154522.0 |
| 2018-06-07 | BR | Futures | 0.19382 | 0.19382 | 0.19047 | 0.19367 | 119.0 |
| 2018-06-07 | BTC | Futures | 10935.6 | 11056.4 | 10857.5 | 10949.8 | 1437.0 |
| 2018-06-07 | BZ | Futures | 55.07 | 56.13 | 54.71 | 56.09 | 36710.0 |
| 2018-06-07 | C | Futures | 1496.0 | 1508.0 | 1466.0 | 1469.0 | 11933.0 |
| 2018-06-07 | CB | Futures | 292.642 | 292.821 | 292.642 | 292.821 | 2.0 |
| 2018-06-07 | CC | Futures | 1700.0 | 1705.0 | 1663.0 | 1669.0 | 43192.0 |
| 2018-06-07 | CNH | Futures | 6.4744 | 6.48 | 6.4741 | 6.48 | 8.0 |
| 2018-06-07 | CSC | Futures | 3.452 | 3.482 | 3.437 | 3.478 | 95.0 |
| 2018-06-07 | CT | Futures | 103.79 | 107.93 | 102.82 | 106.54 | 33503.0 |
| 2018-06-07 | DC | Futures | 27.89 | 28.19 | 27.66 | 28.11 | 290.0 |
| 2018-06-07 | DX | Futures | 88.263 | 88.263 | 87.891 | 88.066 | 18375.0 |
| 2018-06-07 | E1 | Futures | 1.2226 | 1.23128 | 1.22176 | 1.22947 | 25339.0 |
| 2018-06-07 | E6 | Futures | 1.32762 | 1.33472 | 1.32723 | 1.33095 | 299866.0 |
| 2018-06-07 | E7 | Futures | 1.3205 | 1.3275 | 1.3202 | 1.3239 | 6121.0 |
| 2018-06-07 | EBM | Futures | 193.02 | 193.8 | 190.67 | 190.93 | 13792.0 |
| 2018-06-07 | ED | Futures | 94.9719 | 94.9743 | 94.9597 | 94.967 | 262235.0 |
| 2018-06-07 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.337 | 43536.0 |
| 2018-06-07 | EW | Futures | 2108.3 | 2115.7 | 2098.8 | 2107.4 | 20367.0 |
| 2018-06-07 | FBON | Futures | 127.02 | 128.02 | 126.98 | 127.91 | 1087.0 |
| 2018-06-07 | FBTP | Futures | 105.23 | 106.08 | 104.05 | 104.84 | 95977.0 |
| 2018-06-07 | FBTS | Futures | 100.982 | 101.455 | 100.222 | 100.834 | 65149.0 |
| 2018-06-07 | FCE | Futures | 4920.2 | 4934.1 | 4850.5 | 4886.5 | 71133.0 |
| 2018-06-07 | FDAX | Futures | 13407.3 | 13421.4 | 13156.4 | 13311.7 | 105463.0 |
| 2018-06-07 | FDXM | Futures | 13285.9 | 13301.4 | 13040.8 | 13193.2 | 37800.0 |
| 2018-06-07 | FESX | Futures | 2894.7 | 2903.9 | 2853.1 | 2880.6 | 1241457.0 |
| 2018-06-07 | FEU3 | Futures | 98.986 | 98.986 | 98.942 | 98.942 | 74.0 |
| 2018-06-07 | FGBL | Futures | 150.76 | 151.22 | 150.19 | 150.42 | 1004209.0 |
| 2018-06-07 | FGBM | Futures | 130.25 | 130.46 | 129.98 | 130.11 | 544886.0 |
| 2018-06-07 | FGBS | Futures | 112.623 | 112.708 | 112.593 | 112.638 | 422527.0 |
| 2018-06-07 | FGBX | Futures | 172.83 | 173.65 | 171.35 | 171.89 | 70693.0 |
| 2018-06-07 | FMWO | Futures | 7139.5 | 7139.5 | 7100.9 | 7117.3 | 8903.0 |
| 2018-06-07 | FOAT | Futures | 138.36 | 138.44 | 137.93 | 138.14 | 226260.0 |
| 2018-06-07 | FTDX | Futures | 2836.3 | 2836.3 | 2746.8 | 2789.8 | 303.0 |
| 2018-06-07 | FTI | Futures | 521.52 | 522.86 | 515.24 | 519.4 | 23485.0 |
| 2018-06-07 | FTUK | Futures | 6825.5 | 6865.7 | 6772.1 | 6814.1 | 214089.0 |
| 2018-06-07 | FVSA | Futures | 310.38 | 326.49 | 305.01 | 310.38 | 27321.0 |
| 2018-06-07 | FXXP | Futures | 335.6 | 336.5 | 331.3 | 333.7 | 55410.0 |
| 2018-06-07 | G | Futures | 114.07 | 114.44 | 114.0 | 114.11 | 233701.0 |
| 2018-06-07 | GF | Futures | 304.832 | 305.142 | 301.828 | 302.605 | 4530.0 |
| 2018-06-07 | GSCI | Futures | 530.18 | 535.34 | 530.18 | 534.89 | 2134.0 |
> showing 50 of 114 rows — these rows as CSV