PREVIEW / futures_daily / 2016-05-23
file: by_date/futures_daily/2016/2016-05-23.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-23 | ES | Futures | 2204.61 | 2207.56 | 2194.14 | 2196.02 | 1183296.0 |
| 2016-05-23 | NQ | Futures | 5132.14 | 5148.29 | 5109.22 | 5114.22 | 167178.0 |
| 2016-05-23 | YM | Futures | 18199.8 | 18230.0 | 18123.9 | 18164.5 | 113793.0 |
| 2016-05-23 | CL | Futures | 56.81 | 56.85 | 55.56 | 56.36 | 475453.0 |
| 2016-05-23 | GC | Futures | 1613.4 | 1619.9 | 1602.8 | 1613.1 | 218715.0 |
| 2016-05-23 | ZN | Futures | 125.253424 | 125.464644 | 125.147814 | 125.283598 | 1025035.0 |
| 2016-05-23 | A6 | Futures | 0.73083 | 0.73417 | 0.72749 | 0.73033 | 74765.0 |
| 2016-05-23 | AD | Futures | 0.77963 | 0.78044 | 0.77615 | 0.7784 | 45203.0 |
| 2016-05-23 | ALI | Futures | 2089.8 | 2089.8 | 2089.8 | 2089.8 | 0.0 |
| 2016-05-23 | B | Futures | 40.44 | 40.54 | 39.49 | 40.13 | 225090.0 |
| 2016-05-23 | B6 | Futures | 1.5269 | 1.5321 | 1.5207 | 1.5254 | 76499.0 |
| 2016-05-23 | BFX | Futures | 3974.9 | 3974.9 | 3972.5 | 3973.1 | 3.0 |
| 2016-05-23 | BR | Futures | 0.18464 | 0.18464 | 0.18103 | 0.18197 | 637.0 |
| 2016-05-23 | BZ | Futures | 40.34 | 40.38 | 39.38 | 40.0 | 25366.0 |
| 2016-05-23 | C | Futures | 2239.0 | 2317.0 | 2237.0 | 2316.0 | 20538.0 |
| 2016-05-23 | CB | Futures | 257.915 | 257.915 | 255.541 | 257.885 | 16.0 |
| 2016-05-23 | CC | Futures | 2130.0 | 2181.0 | 2128.0 | 2164.0 | 23293.0 |
| 2016-05-23 | CNH | Futures | 7.0842 | 7.1394 | 7.0842 | 7.1347 | 97.0 |
| 2016-05-23 | CSC | Futures | 3.277 | 3.293 | 3.277 | 3.288 | 40.0 |
| 2016-05-23 | CT | Futures | 70.15 | 70.33 | 69.5 | 69.9 | 10423.0 |
| 2016-05-23 | DC | Futures | 25.82 | 25.92 | 25.63 | 25.8 | 176.0 |
| 2016-05-23 | DX | Futures | 88.859 | 89.013 | 88.672 | 88.771 | 11758.0 |
| 2016-05-23 | E1 | Futures | 1.26928 | 1.27217 | 1.26715 | 1.27067 | 15418.0 |
| 2016-05-23 | E6 | Futures | 1.30893 | 1.3119 | 1.30549 | 1.30928 | 110981.0 |
| 2016-05-23 | E7 | Futures | 1.302 | 1.3048 | 1.2984 | 1.3022 | 1668.0 |
| 2016-05-23 | EBM | Futures | 195.17 | 196.37 | 193.66 | 196.07 | 7138.0 |
| 2016-05-23 | ED | Futures | 95.6798 | 95.6871 | 95.663 | 95.6702 | 210879.0 |
| 2016-05-23 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.259 | 18750.0 |
| 2016-05-23 | EW | Futures | 1532.4 | 1535.4 | 1524.8 | 1527.1 | 12588.0 |
| 2016-05-23 | FBON | Futures | 118.44 | 118.57 | 118.19 | 118.25 | 602.0 |
| 2016-05-23 | FBTP | Futures | 106.54 | 106.55 | 106.14 | 106.2 | 66992.0 |
| 2016-05-23 | FBTS | Futures | 101.114 | 101.123 | 101.096 | 101.096 | 15725.0 |
| 2016-05-23 | FCE | Futures | 3706.2 | 3716.5 | 3664.9 | 3687.7 | 83079.0 |
| 2016-05-23 | FDAX | Futures | 10665.8 | 10711.9 | 10533.6 | 10589.5 | 101765.0 |
| 2016-05-23 | FDXM | Futures | 10267.2 | 10315.8 | 10142.0 | 10197.9 | 20483.0 |
| 2016-05-23 | FESX | Futures | 2292.4 | 2301.0 | 2265.9 | 2280.7 | 1233365.0 |
| 2016-05-23 | FGBL | Futures | 146.38 | 146.75 | 146.09 | 146.17 | 631379.0 |
| 2016-05-23 | FGBM | Futures | 127.64 | 127.73 | 127.54 | 127.58 | 433901.0 |
| 2016-05-23 | FGBS | Futures | 111.653 | 111.673 | 111.648 | 111.653 | 207378.0 |
| 2016-05-23 | FGBX | Futures | 172.77 | 173.64 | 171.85 | 172.05 | 35285.0 |
| 2016-05-23 | FMWO | Futures | 5568.1 | 5588.0 | 5568.1 | 5580.5 | 83.0 |
| 2016-05-23 | FOAT | Futures | 134.0 | 134.34 | 133.73 | 133.81 | 73768.0 |
| 2016-05-23 | FTDX | Futures | 1595.6 | 1603.3 | 1589.0 | 1597.1 | 259.0 |
| 2016-05-23 | FTI | Futures | 389.52 | 390.91 | 385.88 | 388.85 | 32436.0 |
| 2016-05-23 | FTUK | Futures | 5070.9 | 5082.4 | 5038.7 | 5060.9 | 90581.0 |
| 2016-05-23 | FVSA | Futures | 2480.77 | 2531.96 | 2476.11 | 2504.04 | 12129.0 |
| 2016-05-23 | FXXP | Futures | 270.1 | 271.6 | 268.0 | 269.8 | 18435.0 |
| 2016-05-23 | G | Futures | 108.65 | 108.79 | 108.36 | 108.44 | 230429.0 |
| 2016-05-23 | GF | Futures | 290.339 | 290.489 | 286.396 | 286.396 | 4487.0 |
| 2016-05-23 | GSCI | Futures | 526.18 | 527.12 | 524.16 | 526.91 | 48.0 |
> showing 50 of 108 rows — these rows as CSV