PREVIEW / futures_daily / 2019-06-19
file: by_date/futures_daily/2019/2019-06-19.parquet size: 10 KB rows: 117
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-19 | ES | Futures | 3155.97 | 3168.92 | 3145.72 | 3165.41 | 1666878.0 |
| 2019-06-19 | NQ | Futures | 8828.36 | 8880.74 | 8784.61 | 8867.5 | 409721.0 |
| 2019-06-19 | YM | Futures | 27804.7 | 27918.1 | 27753.2 | 27863.5 | 192171.0 |
| 2019-06-19 | CL | Futures | 55.55 | 55.9 | 54.73 | 55.21 | 667512.0 |
| 2019-06-19 | GC | Futures | 1680.7 | 1700.9 | 1673.8 | 1678.7 | 332611.0 |
| 2019-06-19 | ZN | Futures | 126.927104 | 127.331479 | 126.569388 | 127.269268 | 1922272.0 |
| 2019-06-19 | A6 | Futures | 0.70923 | 0.71263 | 0.70707 | 0.71067 | 101380.0 |
| 2019-06-19 | AD | Futures | 0.75486 | 0.7604 | 0.7545 | 0.75975 | 93022.0 |
| 2019-06-19 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-19 | B | Futures | 46.45 | 46.56 | 45.7 | 46.02 | 320057.0 |
| 2019-06-19 | B6 | Futures | 1.2869 | 1.2989 | 1.2855 | 1.2983 | 100156.0 |
| 2019-06-19 | BTC | Futures | 13860.6 | 14221.7 | 13806.8 | 14152.6 | 2222.0 |
| 2019-06-19 | BZ | Futures | 45.75 | 45.94 | 45.11 | 45.43 | 51499.0 |
| 2019-06-19 | C | Futures | 1780.0 | 1795.0 | 1777.0 | 1784.0 | 3573.0 |
| 2019-06-19 | CC | Futures | 1662.0 | 1684.0 | 1655.0 | 1674.0 | 13455.0 |
| 2019-06-19 | CNH | Futures | 6.9109 | 6.9201 | 6.9008 | 6.9008 | 658.0 |
| 2019-06-19 | CSC | Futures | 3.043 | 3.057 | 3.041 | 3.053 | 53.0 |
| 2019-06-19 | CT | Futures | 68.55 | 69.4 | 68.37 | 68.44 | 6695.0 |
| 2019-06-19 | DC | Futures | 25.58 | 25.66 | 25.51 | 25.58 | 100.0 |
| 2019-06-19 | DX | Futures | 93.551 | 93.59 | 92.925 | 92.99 | 29405.0 |
| 2019-06-19 | E1 | Futures | 1.16887 | 1.17884 | 1.16736 | 1.17849 | 25963.0 |
| 2019-06-19 | E6 | Futures | 1.22991 | 1.23645 | 1.22904 | 1.23558 | 177411.0 |
| 2019-06-19 | E7 | Futures | 1.2237 | 1.2299 | 1.2226 | 1.2292 | 8364.0 |
| 2019-06-19 | EBM | Futures | 207.85 | 208.14 | 205.55 | 206.13 | 15988.0 |
| 2019-06-19 | ED | Futures | 95.3184 | 95.4499 | 95.2941 | 95.4207 | 575071.0 |
| 2019-06-19 | ER | Futures | 98.494 | 98.514 | 98.484 | 98.494 | 141881.0 |
| 2019-06-19 | EW | Futures | 2023.2 | 2031.4 | 2019.9 | 2028.4 | 15951.0 |
| 2019-06-19 | FBON | Futures | 142.99 | 142.99 | 142.36 | 142.6 | 429.0 |
| 2019-06-19 | FBTP | Futures | 120.35 | 120.95 | 120.01 | 120.34 | 121329.0 |
| 2019-06-19 | FBTS | Futures | 106.651 | 106.862 | 106.622 | 106.718 | 91431.0 |
| 2019-06-19 | FCE | Futures | 5020.8 | 5045.4 | 5013.9 | 5034.5 | 118019.0 |
| 2019-06-19 | FDAX | Futures | 12993.8 | 12996.5 | 12921.2 | 12951.7 | 49429.0 |
| 2019-06-19 | FDXM | Futures | 12826.5 | 12834.8 | 12763.1 | 12792.2 | 2159.0 |
| 2019-06-19 | FESX | Futures | 3007.3 | 3016.0 | 2997.7 | 3006.4 | 1402379.0 |
| 2019-06-19 | FEU3 | Futures | 99.114 | 99.114 | 99.114 | 99.114 | 5.0 |
| 2019-06-19 | FGBL | Futures | 164.19 | 164.23 | 163.63 | 163.7 | 713166.0 |
| 2019-06-19 | FGBM | Futures | 134.57 | 134.59 | 134.24 | 134.29 | 538546.0 |
| 2019-06-19 | FGBS | Futures | 113.101 | 113.106 | 113.026 | 113.046 | 381257.0 |
| 2019-06-19 | FGBX | Futures | 208.76 | 208.95 | 207.38 | 207.65 | 57361.0 |
| 2019-06-19 | FMWO | Futures | 7271.4 | 7300.2 | 7261.0 | 7271.4 | 7098.0 |
| 2019-06-19 | FOAT | Futures | 151.1 | 151.12 | 150.55 | 150.59 | 148499.0 |
| 2019-06-19 | FTDX | Futures | 2797.5 | 2800.9 | 2788.1 | 2797.0 | 350.0 |
| 2019-06-19 | FTI | Futures | 526.72 | 528.46 | 525.92 | 527.68 | 31101.0 |
| 2019-06-19 | FTUK | Futures | 6826.8 | 6826.8 | 6758.0 | 6769.1 | 225240.0 |
| 2019-06-19 | FVSA | Futures | 200.74 | 203.51 | 197.28 | 202.81 | 42874.0 |
| 2019-06-19 | FXXP | Futures | 343.1 | 343.6 | 341.8 | 342.8 | 106420.0 |
| 2019-06-19 | G | Futures | 120.17 | 120.19 | 119.53 | 119.58 | 160470.0 |
| 2019-06-19 | GF | Futures | 269.633 | 270.566 | 266.346 | 267.916 | 3888.0 |
| 2019-06-19 | GSCI | Futures | 465.96 | 465.96 | 464.09 | 464.09 | 7.0 |
| 2019-06-19 | HE | Futures | 73.09 | 74.014 | 72.977 | 73.608 | 13051.0 |
> showing 50 of 117 rows — these rows as CSV