PREVIEW / futures_daily / 2018-06-08
file: by_date/futures_daily/2018/2018-06-08.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-08 | ES | Futures | 3013.37 | 3022.89 | 2992.71 | 3021.8 | 1367033.0 |
| 2018-06-08 | NQ | Futures | 8380.3 | 8383.81 | 8284.03 | 8370.35 | 215656.0 |
| 2018-06-08 | YM | Futures | 26605.8 | 26681.6 | 26415.1 | 26658.4 | 118435.0 |
| 2018-06-08 | CL | Futures | 66.41 | 66.67 | 65.57 | 66.17 | 571224.0 |
| 2018-06-08 | GC | Futures | 1661.3 | 1665.8 | 1654.6 | 1663.1 | 217650.0 |
| 2018-06-08 | ZN | Futures | 119.028368 | 119.29253 | 118.795283 | 118.935134 | 2042131.0 |
| 2018-06-08 | A6 | Futures | 0.78393 | 0.78435 | 0.77746 | 0.78157 | 97059.0 |
| 2018-06-08 | AD | Futures | 0.77984 | 0.78303 | 0.77584 | 0.78227 | 87075.0 |
| 2018-06-08 | B | Futures | 56.67 | 56.83 | 55.74 | 55.99 | 251826.0 |
| 2018-06-08 | B6 | Futures | 1.3905 | 1.3923 | 1.3835 | 1.3895 | 113664.0 |
| 2018-06-08 | BR | Futures | 0.19656 | 0.20529 | 0.19504 | 0.20369 | 45.0 |
| 2018-06-08 | BTC | Futures | 10900.1 | 10949.8 | 10715.3 | 10878.8 | 1301.0 |
| 2018-06-08 | BZ | Futures | 56.05 | 56.28 | 55.23 | 55.47 | 21902.0 |
| 2018-06-08 | C | Futures | 1467.0 | 1544.0 | 1464.0 | 1537.0 | 22229.0 |
| 2018-06-08 | CC | Futures | 1669.0 | 1750.0 | 1663.0 | 1741.0 | 43366.0 |
| 2018-06-08 | CNH | Futures | 6.4947 | 6.4947 | 6.4902 | 6.4902 | 1.0 |
| 2018-06-08 | CSC | Futures | 3.476 | 3.49 | 3.476 | 3.486 | 53.0 |
| 2018-06-08 | CT | Futures | 106.82 | 108.95 | 106.39 | 107.92 | 31101.0 |
| 2018-06-08 | DC | Futures | 28.21 | 28.26 | 28.08 | 28.18 | 106.0 |
| 2018-06-08 | DX | Futures | 88.155 | 88.489 | 88.07 | 88.218 | 18648.0 |
| 2018-06-08 | E1 | Futures | 1.22995 | 1.23007 | 1.21875 | 1.22333 | 25555.0 |
| 2018-06-08 | E6 | Futures | 1.32988 | 1.33123 | 1.32177 | 1.32667 | 270952.0 |
| 2018-06-08 | E7 | Futures | 1.323 | 1.324 | 1.3148 | 1.3196 | 5743.0 |
| 2018-06-08 | EBM | Futures | 189.36 | 192.5 | 188.83 | 190.67 | 15178.0 |
| 2018-06-08 | ED | Futures | 94.9646 | 94.9743 | 94.9622 | 94.9719 | 234227.0 |
| 2018-06-08 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 129447.0 |
| 2018-06-08 | EW | Futures | 2109.2 | 2120.2 | 2098.7 | 2119.8 | 30412.0 |
| 2018-06-08 | FBON | Futures | 127.33 | 127.73 | 127.33 | 127.55 | 250.0 |
| 2018-06-08 | FBTP | Futures | 104.05 | 104.56 | 103.33 | 103.52 | 100069.0 |
| 2018-06-08 | FBTS | Futures | 100.333 | 100.593 | 99.971 | 100.314 | 58752.0 |
| 2018-06-08 | FCE | Futures | 4859.9 | 4907.6 | 4847.8 | 4889.1 | 97536.0 |
| 2018-06-08 | FDAX | Futures | 13194.3 | 13310.7 | 13098.2 | 13253.0 | 115379.0 |
| 2018-06-08 | FDXM | Futures | 13078.9 | 13193.2 | 12981.1 | 13135.0 | 43922.0 |
| 2018-06-08 | FESX | Futures | 2857.2 | 2877.2 | 2846.4 | 2865.6 | 1659224.0 |
| 2018-06-08 | FEU3 | Futures | 99.026 | 99.026 | 99.016 | 99.021 | 398.0 |
| 2018-06-08 | FGBL | Futures | 150.98 | 151.83 | 150.93 | 151.14 | 985513.0 |
| 2018-06-08 | FGBM | Futures | 130.35 | 130.68 | 130.31 | 130.45 | 540811.0 |
| 2018-06-08 | FGBS | Futures | 112.688 | 112.749 | 112.668 | 112.718 | 471243.0 |
| 2018-06-08 | FGBX | Futures | 173.17 | 175.07 | 172.91 | 173.59 | 71365.0 |
| 2018-06-08 | FMWO | Futures | 7082.2 | 7105.6 | 7054.2 | 7091.6 | 1069.0 |
| 2018-06-08 | FOAT | Futures | 138.44 | 138.86 | 138.32 | 138.42 | 174709.0 |
| 2018-06-08 | FTDX | Futures | 2763.1 | 2780.4 | 2743.3 | 2773.0 | 364.0 |
| 2018-06-08 | FTI | Futures | 515.98 | 519.81 | 513.48 | 517.55 | 34909.0 |
| 2018-06-08 | FTUK | Futures | 6788.0 | 6817.1 | 6747.8 | 6785.3 | 275574.0 |
| 2018-06-08 | FVSA | Futures | 325.42 | 338.31 | 312.53 | 321.12 | 27763.0 |
| 2018-06-08 | FXXP | Futures | 332.1 | 333.8 | 330.7 | 332.6 | 66465.0 |
| 2018-06-08 | G | Futures | 114.55 | 114.94 | 114.18 | 114.29 | 200824.0 |
| 2018-06-08 | GF | Futures | 303.33 | 306.178 | 302.76 | 305.091 | 4529.0 |
| 2018-06-08 | GSCI | Futures | 534.33 | 534.33 | 534.33 | 534.33 | 2564.0 |
| 2018-06-08 | HE | Futures | 82.611 | 83.047 | 82.15 | 82.817 | 24913.0 |
> showing 50 of 114 rows — these rows as CSV