PREVIEW / futures_daily / 2018-02-15
file: by_date/futures_daily/2018/2018-02-15.parquet size: 10 KB rows: 112
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-02-15 | ES | Futures | 2929.68 | 2974.52 | 2922.07 | 2971.53 | 1668909.0 |
| 2018-02-15 | NQ | Futures | 7824.65 | 7996.23 | 7811.47 | 7982.76 | 458423.0 |
| 2018-02-15 | YM | Futures | 26216.5 | 26628.8 | 26145.8 | 26611.9 | 283559.0 |
| 2018-02-15 | CL | Futures | 60.98 | 61.89 | 60.01 | 61.6 | 576514.0 |
| 2018-02-15 | GC | Futures | 1728.2 | 1736.9 | 1725.4 | 1731.2 | 274926.0 |
| 2018-02-15 | ZN | Futures | 118.874517 | 119.028779 | 118.504288 | 118.920796 | 1801379.0 |
| 2018-02-15 | A6 | Futures | 0.81468 | 0.81931 | 0.8117 | 0.81612 | 109952.0 |
| 2018-02-15 | AD | Futures | 0.8129 | 0.81478 | 0.81016 | 0.81315 | 65791.0 |
| 2018-02-15 | B | Futures | 46.24 | 46.75 | 45.29 | 46.16 | 292913.0 |
| 2018-02-15 | B6 | Futures | 1.4578 | 1.4685 | 1.4571 | 1.4671 | 116090.0 |
| 2018-02-15 | BR | Futures | 0.23556 | 0.23681 | 0.23389 | 0.23404 | 3670.0 |
| 2018-02-15 | BTC | Futures | 12231.6 | 13246.6 | 12199.1 | 13129.4 | 1783.0 |
| 2018-02-15 | BZ | Futures | 45.55 | 46.1 | 44.7 | 45.56 | 36176.0 |
| 2018-02-15 | C | Futures | 1345.0 | 1363.0 | 1339.0 | 1350.0 | 8530.0 |
| 2018-02-15 | CB | Futures | 277.232 | 280.506 | 273.093 | 273.68 | 127.0 |
| 2018-02-15 | CC | Futures | 1547.0 | 1573.0 | 1536.0 | 1566.0 | 27831.0 |
| 2018-02-15 | CNH | Futures | 6.4396 | 6.4407 | 6.4148 | 6.4148 | 154.0 |
| 2018-02-15 | CSC | Futures | 3.287 | 3.319 | 3.265 | 3.28 | 101.0 |
| 2018-02-15 | CT | Futures | 88.3 | 89.1 | 87.73 | 88.08 | 7781.0 |
| 2018-02-15 | DC | Futures | 26.05 | 26.37 | 25.85 | 25.98 | 451.0 |
| 2018-02-15 | DX | Futures | 83.477 | 83.477 | 83.059 | 83.115 | 27690.0 |
| 2018-02-15 | E1 | Futures | 1.31006 | 1.32086 | 1.30933 | 1.31844 | 24028.0 |
| 2018-02-15 | E6 | Futures | 1.41419 | 1.42088 | 1.4138 | 1.42049 | 198451.0 |
| 2018-02-15 | E7 | Futures | 1.4073 | 1.4137 | 1.4067 | 1.4133 | 4630.0 |
| 2018-02-15 | EBM | Futures | 171.81 | 173.43 | 171.0 | 172.89 | 22203.0 |
| 2018-02-15 | ED | Futures | 95.1756 | 95.1756 | 95.1465 | 95.1514 | 388038.0 |
| 2018-02-15 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.332 | 28137.0 |
| 2018-02-15 | EW | Futures | 1989.1 | 2015.1 | 1984.1 | 2011.2 | 13156.0 |
| 2018-02-15 | FBON | Futures | 125.78 | 126.15 | 125.7 | 126.13 | 679.0 |
| 2018-02-15 | FBTP | Futures | 110.82 | 111.08 | 110.53 | 110.95 | 99581.0 |
| 2018-02-15 | FBTS | Futures | 103.65 | 103.65 | 103.586 | 103.604 | 70135.0 |
| 2018-02-15 | FCE | Futures | 4594.0 | 4639.5 | 4586.0 | 4610.3 | 88941.0 |
| 2018-02-15 | FDAX | Futures | 12907.2 | 12944.0 | 12726.2 | 12787.4 | 95198.0 |
| 2018-02-15 | FDXM | Futures | 12934.3 | 12965.5 | 12748.3 | 12809.1 | 38321.0 |
| 2018-02-15 | FESX | Futures | 2774.3 | 2788.2 | 2755.5 | 2765.3 | 1256212.0 |
| 2018-02-15 | FEU3 | Futures | 99.006 | 99.011 | 99.006 | 99.011 | 500.0 |
| 2018-02-15 | FGBL | Futures | 146.11 | 146.44 | 145.9 | 146.32 | 720297.0 |
| 2018-02-15 | FGBM | Futures | 128.21 | 128.32 | 128.13 | 128.28 | 519160.0 |
| 2018-02-15 | FGBS | Futures | 112.276 | 112.281 | 112.246 | 112.276 | 295672.0 |
| 2018-02-15 | FGBX | Futures | 162.71 | 163.5 | 162.01 | 163.23 | 55970.0 |
| 2018-02-15 | FMWO | Futures | 6994.7 | 7023.9 | 6969.0 | 6983.0 | 2351.0 |
| 2018-02-15 | FOAT | Futures | 135.56 | 135.75 | 135.3 | 135.65 | 113373.0 |
| 2018-02-15 | FTDX | Futures | 2533.4 | 2544.9 | 2514.4 | 2522.9 | 362.0 |
| 2018-02-15 | FTI | Futures | 484.0 | 486.43 | 482.34 | 484.32 | 20233.0 |
| 2018-02-15 | FTUK | Futures | 6288.1 | 6318.2 | 6263.6 | 6286.7 | 121252.0 |
| 2018-02-15 | FVSA | Futures | 443.2 | 450.59 | 433.35 | 443.2 | 32274.0 |
| 2018-02-15 | FXXP | Futures | 320.1 | 321.8 | 319.0 | 320.1 | 57381.0 |
| 2018-02-15 | G | Futures | 111.05 | 111.35 | 110.79 | 111.21 | 243814.0 |
| 2018-02-15 | GF | Futures | 325.607 | 329.67 | 324.948 | 329.011 | 5274.0 |
| 2018-02-15 | GSCI | Futures | 499.56 | 502.29 | 497.05 | 502.29 | 38.0 |
> showing 50 of 112 rows — these rows as CSV