PREVIEW / futures_daily / 2018-05-03
file: by_date/futures_daily/2018/2018-05-03.parquet size: 9 KB rows: 111
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-05-03 | ES | Futures | 2856.51 | 2866.84 | 2817.9 | 2861.94 | 2146587.0 |
| 2018-05-03 | NQ | Futures | 7760.85 | 7808.55 | 7652.29 | 7800.35 | 518811.0 |
| 2018-05-03 | YM | Futures | 25092.0 | 25218.4 | 24720.2 | 25186.8 | 329134.0 |
| 2018-05-03 | CL | Futures | 67.93 | 68.85 | 67.46 | 68.68 | 691219.0 |
| 2018-05-03 | GC | Futures | 1666.7 | 1683.9 | 1666.3 | 1675.9 | 306718.0 |
| 2018-05-03 | ZN | Futures | 118.625145 | 118.935316 | 118.547602 | 118.795739 | 1462604.0 |
| 2018-05-03 | A6 | Futures | 0.77067 | 0.77561 | 0.76974 | 0.77437 | 135852.0 |
| 2018-05-03 | AD | Futures | 0.78637 | 0.79001 | 0.78429 | 0.78798 | 71658.0 |
| 2018-05-03 | B | Futures | 53.55 | 54.3 | 53.11 | 53.95 | 382135.0 |
| 2018-05-03 | B6 | Futures | 1.4084 | 1.4141 | 1.4045 | 1.408 | 133792.0 |
| 2018-05-03 | BR | Futures | 0.21435 | 0.21572 | 0.21298 | 0.21542 | 3586.0 |
| 2018-05-03 | BTC | Futures | 12982.6 | 13769.0 | 12891.3 | 13586.4 | 4177.0 |
| 2018-05-03 | BZ | Futures | 53.05 | 53.73 | 52.57 | 53.4 | 35839.0 |
| 2018-05-03 | C | Futures | 1748.0 | 1773.0 | 1739.0 | 1771.0 | 900.0 |
| 2018-05-03 | CB | Futures | 297.122 | 297.122 | 296.165 | 296.165 | 23.0 |
| 2018-05-03 | CC | Futures | 2038.0 | 2076.0 | 2025.0 | 2071.0 | 18856.0 |
| 2018-05-03 | CNH | Futures | 6.4628 | 6.4628 | 6.4438 | 6.4438 | 6.0 |
| 2018-05-03 | CSC | Futures | 3.463 | 3.465 | 3.45 | 3.461 | 18.0 |
| 2018-05-03 | CT | Futures | 96.28 | 96.76 | 95.29 | 96.06 | 16756.0 |
| 2018-05-03 | DC | Futures | 28.05 | 28.05 | 27.85 | 27.91 | 182.0 |
| 2018-05-03 | DX | Futures | 87.325 | 87.334 | 86.943 | 87.005 | 23017.0 |
| 2018-05-03 | E1 | Futures | 1.20984 | 1.21393 | 1.20851 | 1.21152 | 28607.0 |
| 2018-05-03 | E6 | Futures | 1.35117 | 1.35691 | 1.3501 | 1.35511 | 271769.0 |
| 2018-05-03 | E7 | Futures | 1.3437 | 1.3497 | 1.3429 | 1.3479 | 4300.0 |
| 2018-05-03 | EBM | Futures | 183.11 | 184.99 | 182.03 | 184.45 | 18681.0 |
| 2018-05-03 | ED | Futures | 94.9403 | 94.9452 | 94.9354 | 94.9403 | 210195.0 |
| 2018-05-03 | ER | Futures | 98.347 | 98.347 | 98.342 | 98.342 | 29248.0 |
| 2018-05-03 | EW | Futures | 1980.5 | 1990.1 | 1959.3 | 1982.8 | 17110.0 |
| 2018-05-03 | FBON | Futures | 129.42 | 129.82 | 129.15 | 129.75 | 774.0 |
| 2018-05-03 | FBTP | Futures | 115.83 | 116.39 | 115.51 | 116.25 | 106716.0 |
| 2018-05-03 | FBTS | Futures | 104.269 | 104.352 | 104.241 | 104.333 | 44617.0 |
| 2018-05-03 | FCE | Futures | 4897.1 | 4901.1 | 4869.9 | 4881.1 | 69297.0 |
| 2018-05-03 | FDAX | Futures | 13294.1 | 13315.9 | 13173.5 | 13199.5 | 109558.0 |
| 2018-05-03 | FDXM | Futures | 13177.8 | 13196.3 | 13056.3 | 13082.0 | 30242.0 |
| 2018-05-03 | FESX | Futures | 2908.1 | 2912.2 | 2889.7 | 2892.2 | 899397.0 |
| 2018-05-03 | FEU3 | Futures | 99.026 | 99.03 | 99.026 | 99.03 | 955.0 |
| 2018-05-03 | FGBL | Futures | 149.3 | 149.96 | 149.09 | 149.87 | 894937.0 |
| 2018-05-03 | FGBM | Futures | 129.53 | 129.8 | 129.44 | 129.76 | 592543.0 |
| 2018-05-03 | FGBS | Futures | 112.502 | 112.532 | 112.487 | 112.532 | 304726.0 |
| 2018-05-03 | FGBX | Futures | 168.94 | 170.1 | 168.4 | 169.87 | 56042.0 |
| 2018-05-03 | FMWO | Futures | 6896.6 | 6898.9 | 6809.0 | 6820.7 | 1985.0 |
| 2018-05-03 | FOAT | Futures | 138.46 | 139.01 | 138.27 | 138.94 | 190715.0 |
| 2018-05-03 | FTDX | Futures | 2661.7 | 2676.5 | 2651.3 | 2659.7 | 266.0 |
| 2018-05-03 | FTI | Futures | 509.61 | 510.72 | 506.19 | 507.44 | 20728.0 |
| 2018-05-03 | FTUK | Futures | 6620.5 | 6636.9 | 6579.5 | 6592.3 | 130680.0 |
| 2018-05-03 | FVSA | Futures | 336.38 | 357.05 | 331.79 | 351.31 | 27508.0 |
| 2018-05-03 | FXXP | Futures | 330.7 | 331.4 | 328.7 | 329.1 | 49129.0 |
| 2018-05-03 | G | Futures | 113.48 | 114.25 | 113.27 | 114.09 | 263989.0 |
| 2018-05-03 | GF | Futures | 298.214 | 303.701 | 297.299 | 303.002 | 1912.0 |
| 2018-05-03 | GSCI | Futures | 530.51 | 535.36 | 529.89 | 534.85 | 283.0 |
> showing 50 of 111 rows — these rows as CSV