PREVIEW / futures_daily / 2014-06-16
file: by_date/futures_daily/2014/2014-06-16.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-16 | ES | Futures | 2002.8 | 2008.51 | 1993.45 | 2004.1 | 1739592.0 |
| 2014-06-16 | NQ | Futures | 4346.28 | 4365.32 | 4326.96 | 4352.63 | 257421.0 |
| 2014-06-16 | YM | Futures | 16849.0 | 16882.3 | 16773.4 | 16852.1 | 122329.0 |
| 2014-06-16 | CL | Futures | 193.96 | 195.07 | 193.66 | 194.18 | 140812.0 |
| 2014-06-16 | GC | Futures | 1682.3 | 1693.2 | 1674.0 | 1680.3 | 98247.0 |
| 2014-06-16 | ZN | Futures | 116.068894 | 116.258549 | 115.952183 | 116.068894 | 756977.0 |
| 2014-06-16 | A6 | Futures | 0.9032 | 0.90446 | 0.90011 | 0.90253 | 46319.0 |
| 2014-06-16 | AD | Futures | 0.93348 | 0.9353 | 0.93124 | 0.93388 | 43286.0 |
| 2014-06-16 | ALI | Futures | 2769.37 | 2769.37 | 2769.37 | 2769.37 | 0.0 |
| 2014-06-16 | B | Futures | 117.99 | 118.56 | 117.57 | 118.21 | 175895.0 |
| 2014-06-16 | B6 | Futures | 1.7834 | 1.7868 | 1.7815 | 1.7835 | 78468.0 |
| 2014-06-16 | BFX | Futures | 3809.5 | 3809.5 | 3807.4 | 3807.4 | 10.0 |
| 2014-06-16 | BR | Futures | 0.23165 | 0.23165 | 0.23065 | 0.23091 | 94.0 |
| 2014-06-16 | BZ | Futures | 119.15 | 119.61 | 118.61 | 119.24 | 10542.0 |
| 2014-06-16 | C | Futures | 2046.0 | 2046.0 | 2027.0 | 2034.0 | 3321.0 |
| 2014-06-16 | CB | Futures | 113.747 | 115.703 | 113.467 | 115.703 | 27.0 |
| 2014-06-16 | CC | Futures | 2274.0 | 2284.0 | 2271.0 | 2282.0 | 8526.0 |
| 2014-06-16 | CSC | Futures | 4.555 | 4.555 | 4.553 | 4.553 | 7.0 |
| 2014-06-16 | CT | Futures | 97.96 | 99.59 | 97.96 | 98.7 | 12079.0 |
| 2014-06-16 | DC | Futures | 35.65 | 36.14 | 35.65 | 35.86 | 77.0 |
| 2014-06-16 | DX | Futures | 76.631 | 76.712 | 76.422 | 76.481 | 17393.0 |
| 2014-06-16 | E1 | Futures | 1.42519 | 1.43096 | 1.4234 | 1.42917 | 28538.0 |
| 2014-06-16 | E6 | Futures | 1.5981 | 1.60294 | 1.59492 | 1.60141 | 131468.0 |
| 2014-06-16 | E7 | Futures | 1.5877 | 1.5926 | 1.5846 | 1.591 | 2030.0 |
| 2014-06-16 | ED | Futures | 95.4067 | 95.4067 | 95.4019 | 95.4067 | 122961.0 |
| 2014-06-16 | ER | Futures | 97.925 | 97.935 | 97.916 | 97.93 | 139689.0 |
| 2014-06-16 | EW | Futures | 1451.6 | 1457.6 | 1445.7 | 1452.6 | 36125.0 |
| 2014-06-16 | FBTP | Futures | 91.11 | 91.31 | 91.0 | 91.09 | 30893.0 |
| 2014-06-16 | FBTS | Futures | 98.072 | 98.108 | 97.974 | 98.028 | 12420.0 |
| 2014-06-16 | FCE | Futures | 3610.0 | 3620.7 | 3593.6 | 3595.2 | 51419.0 |
| 2014-06-16 | FDAX | Futures | 10916.1 | 10963.1 | 10902.3 | 10933.8 | 98696.0 |
| 2014-06-16 | FESX | Futures | 2344.7 | 2353.3 | 2338.2 | 2344.7 | 858805.0 |
| 2014-06-16 | FEU3 | Futures | 98.552 | 98.552 | 98.552 | 98.552 | 4.0 |
| 2014-06-16 | FGBL | Futures | 126.65 | 126.79 | 126.53 | 126.69 | 389393.0 |
| 2014-06-16 | FGBM | Futures | 121.2 | 121.23 | 121.1 | 121.18 | 252614.0 |
| 2014-06-16 | FGBS | Futures | 110.773 | 110.773 | 110.748 | 110.758 | 161197.0 |
| 2014-06-16 | FGBX | Futures | 130.12 | 130.42 | 129.98 | 130.24 | 15130.0 |
| 2014-06-16 | FMWO | Futures | 5739.9 | 5739.9 | 5739.9 | 5739.9 | 0.0 |
| 2014-06-16 | FOAT | Futures | 116.27 | 116.46 | 116.18 | 116.29 | 33544.0 |
| 2014-06-16 | FTDX | Futures | 1218.8 | 1218.8 | 1216.5 | 1216.5 | 1.0 |
| 2014-06-16 | FTI | Futures | 356.97 | 358.01 | 356.45 | 356.8 | 8477.0 |
| 2014-06-16 | FTUK | Futures | 5163.5 | 5178.5 | 5152.7 | 5161.5 | 94728.0 |
| 2014-06-16 | FVSA | Futures | 1396.81 | 1444.08 | 1396.81 | 1422.59 | 8201.0 |
| 2014-06-16 | FXXP | Futures | 260.1 | 260.7 | 259.1 | 259.6 | 50466.0 |
| 2014-06-16 | G | Futures | 93.13 | 93.3 | 92.97 | 93.03 | 102810.0 |
| 2014-06-16 | GF | Futures | 319.086 | 320.274 | 317.899 | 319.853 | 2965.0 |
| 2014-06-16 | GSCI | Futures | 1099.5 | 1104.16 | 1099.5 | 1102.58 | 141.0 |
| 2014-06-16 | HE | Futures | 133.864 | 133.943 | 130.471 | 130.734 | 15682.0 |
| 2014-06-16 | HG | Futures | 3.8659 | 3.91 | 3.8615 | 3.8972 | 37672.0 |
| 2014-06-16 | HH | Futures | 60.339 | 61.607 | 59.236 | 59.667 | 603.0 |
> showing 50 of 104 rows — these rows as CSV