PREVIEW / futures_daily / 2015-06-23
file: by_date/futures_daily/2015/2015-06-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 |
|---|---|---|---|---|---|---|---|
| 2015-06-23 | ES | Futures | 2241.25 | 2247.34 | 2237.54 | 2243.1 | 837133.0 |
| 2015-06-23 | NQ | Futures | 5299.08 | 5310.75 | 5280.4 | 5302.0 | 116969.0 |
| 2015-06-23 | YM | Futures | 18531.6 | 18597.3 | 18511.0 | 18555.2 | 77646.0 |
| 2015-06-23 | CL | Futures | 100.56 | 102.7 | 99.46 | 101.9 | 336224.0 |
| 2015-06-23 | GC | Futures | 1548.0 | 1551.1 | 1535.3 | 1536.6 | 122250.0 |
| 2015-06-23 | ZN | Futures | 119.93019 | 119.989805 | 119.497982 | 119.661923 | 1203581.0 |
| 2015-06-23 | A6 | Futures | 0.76199 | 0.76407 | 0.75713 | 0.76218 | 72676.0 |
| 2015-06-23 | AD | Futures | 0.82915 | 0.82956 | 0.82465 | 0.82772 | 62612.0 |
| 2015-06-23 | ALI | Futures | 2369.83 | 2369.83 | 2369.83 | 2369.83 | 0.0 |
| 2015-06-23 | B | Futures | 59.47 | 61.05 | 59.04 | 60.63 | 266021.0 |
| 2015-06-23 | B6 | Futures | 1.6649 | 1.6653 | 1.6525 | 1.6531 | 97292.0 |
| 2015-06-23 | BFX | Futures | 4541.3 | 4542.5 | 4529.4 | 4529.4 | 6.0 |
| 2015-06-23 | BR | Futures | 0.18935 | 0.19001 | 0.18785 | 0.18959 | 25.0 |
| 2015-06-23 | BZ | Futures | 59.7 | 61.23 | 59.16 | 60.76 | 25137.0 |
| 2015-06-23 | C | Futures | 2305.0 | 2312.0 | 2293.0 | 2295.0 | 4748.0 |
| 2015-06-23 | CB | Futures | 162.135 | 162.135 | 156.826 | 157.069 | 24.0 |
| 2015-06-23 | CC | Futures | 2405.0 | 2412.0 | 2381.0 | 2391.0 | 9263.0 |
| 2015-06-23 | CNH | Futures | 7.0134 | 7.0134 | 7.0103 | 7.0103 | 12.0 |
| 2015-06-23 | CSC | Futures | 4.508 | 4.513 | 4.47 | 4.48 | 70.0 |
| 2015-06-23 | CT | Futures | 80.62 | 80.68 | 79.34 | 80.09 | 3381.0 |
| 2015-06-23 | DC | Futures | 36.29 | 36.29 | 35.92 | 36.07 | 81.0 |
| 2015-06-23 | DX | Futures | 88.46 | 89.757 | 88.446 | 89.532 | 47348.0 |
| 2015-06-23 | E1 | Futures | 1.3818 | 1.38268 | 1.3564 | 1.36148 | 22874.0 |
| 2015-06-23 | E6 | Futures | 1.33373 | 1.33455 | 1.30941 | 1.31341 | 272290.0 |
| 2015-06-23 | E7 | Futures | 1.3264 | 1.3271 | 1.3023 | 1.3062 | 6687.0 |
| 2015-06-23 | EBM | Futures | 299.63 | 302.91 | 299.22 | 302.5 | 8334.0 |
| 2015-06-23 | ED | Futures | 95.6222 | 95.627 | 95.6079 | 95.6127 | 122935.0 |
| 2015-06-23 | ER | Futures | 98.082 | 98.097 | 98.082 | 98.087 | 36532.0 |
| 2015-06-23 | EW | Futures | 1619.3 | 1622.7 | 1616.5 | 1621.7 | 8304.0 |
| 2015-06-23 | FBTP | Futures | 97.91 | 98.52 | 97.78 | 97.92 | 103822.0 |
| 2015-06-23 | FBTS | Futures | 99.456 | 99.634 | 99.447 | 99.572 | 24549.0 |
| 2015-06-23 | FCE | Futures | 4179.9 | 4226.2 | 4179.5 | 4210.3 | 107889.0 |
| 2015-06-23 | FDAX | Futures | 12741.0 | 12871.4 | 12737.7 | 12762.0 | 114423.0 |
| 2015-06-23 | FDIV | Futures | 157.69 | 158.48 | 157.32 | 157.32 | 5.0 |
| 2015-06-23 | FESX | Futures | 2676.1 | 2701.3 | 2671.7 | 2682.8 | 1232014.0 |
| 2015-06-23 | FEU3 | Futures | 98.734 | 98.734 | 98.729 | 98.729 | 62.0 |
| 2015-06-23 | FGBL | Futures | 134.15 | 134.59 | 133.85 | 134.44 | 669423.0 |
| 2015-06-23 | FGBM | Futures | 123.47 | 123.62 | 123.41 | 123.57 | 406955.0 |
| 2015-06-23 | FGBS | Futures | 111.143 | 111.143 | 111.123 | 111.138 | 158325.0 |
| 2015-06-23 | FGBX | Futures | 149.51 | 149.96 | 148.05 | 149.45 | 38333.0 |
| 2015-06-23 | FMWO | Futures | 5948.0 | 5955.3 | 5941.8 | 5941.8 | 656.0 |
| 2015-06-23 | FOAT | Futures | 122.77 | 123.14 | 122.46 | 122.95 | 79106.0 |
| 2015-06-23 | FTDX | Futures | 1582.5 | 1608.9 | 1575.5 | 1601.4 | 511.0 |
| 2015-06-23 | FTI | Futures | 428.43 | 433.93 | 428.21 | 431.4 | 32914.0 |
| 2015-06-23 | FTUK | Futures | 5381.9 | 5410.5 | 5381.9 | 5397.8 | 74694.0 |
| 2015-06-23 | FVSA | Futures | 1678.25 | 1682.28 | 1617.88 | 1638.01 | 33727.0 |
| 2015-06-23 | FXXP | Futures | 303.6 | 307.4 | 303.4 | 306.0 | 32246.0 |
| 2015-06-23 | G | Futures | 100.46 | 101.01 | 100.22 | 100.67 | 257204.0 |
| 2015-06-23 | GF | Futures | 384.924 | 385.306 | 382.076 | 383.138 | 2853.0 |
| 2015-06-23 | GSCI | Futures | 721.98 | 733.4 | 719.9 | 732.15 | 90.0 |
> showing 50 of 108 rows — these rows as CSV