PREVIEW / futures_daily / 2014-06-19
file: by_date/futures_daily/2014/2014-06-19.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-19 | ES | Futures | 2023.58 | 2027.99 | 2019.42 | 2025.91 | 1422610.0 |
| 2014-06-19 | NQ | Futures | 4378.3 | 4388.11 | 4354.65 | 4371.67 | 218554.0 |
| 2014-06-19 | YM | Futures | 16965.1 | 16996.4 | 16928.7 | 16984.2 | 113707.0 |
| 2014-06-19 | CL | Futures | 193.08 | 194.34 | 192.0 | 193.72 | 311395.0 |
| 2014-06-19 | GC | Futures | 1684.1 | 1741.9 | 1681.5 | 1731.4 | 237994.0 |
| 2014-06-19 | ZN | Futures | 116.24396 | 116.462793 | 115.893828 | 116.098071 | 1324008.0 |
| 2014-06-19 | A6 | Futures | 0.90282 | 0.90601 | 0.90204 | 0.9032 | 65828.0 |
| 2014-06-19 | AD | Futures | 0.9351 | 0.93754 | 0.9348 | 0.93632 | 55283.0 |
| 2014-06-19 | ALI | Futures | 2787.8 | 2787.8 | 2787.8 | 2787.8 | 35.0 |
| 2014-06-19 | B | Futures | 119.55 | 121.11 | 119.47 | 120.43 | 250241.0 |
| 2014-06-19 | B6 | Futures | 1.7852 | 1.7925 | 1.7844 | 1.7904 | 102075.0 |
| 2014-06-19 | BFX | Futures | 3847.4 | 3847.4 | 3842.3 | 3842.3 | 11.0 |
| 2014-06-19 | BR | Futures | 0.23228 | 0.23228 | 0.23228 | 0.23228 | 959.0 |
| 2014-06-19 | BZ | Futures | 120.63 | 122.15 | 120.53 | 121.48 | 14027.0 |
| 2014-06-19 | C | Futures | 2043.0 | 2046.0 | 2030.0 | 2038.0 | 1918.0 |
| 2014-06-19 | CB | Futures | 120.733 | 121.712 | 118.358 | 118.358 | 27.0 |
| 2014-06-19 | CC | Futures | 2290.0 | 2298.0 | 2276.0 | 2289.0 | 10181.0 |
| 2014-06-19 | CNH | Futures | 7.1724 | 7.1747 | 7.1724 | 7.1746 | 10.0 |
| 2014-06-19 | CSC | Futures | 4.667 | 4.694 | 4.622 | 4.622 | 27.0 |
| 2014-06-19 | CT | Futures | 102.58 | 102.73 | 98.86 | 99.49 | 10228.0 |
| 2014-06-19 | DC | Futures | 36.86 | 37.31 | 36.72 | 36.83 | 234.0 |
| 2014-06-19 | DX | Futures | 76.384 | 76.432 | 76.166 | 76.314 | 25783.0 |
| 2014-06-19 | E1 | Futures | 1.43122 | 1.43955 | 1.43071 | 1.43429 | 49942.0 |
| 2014-06-19 | E6 | Futures | 1.60365 | 1.61037 | 1.60341 | 1.60601 | 153177.0 |
| 2014-06-19 | E7 | Futures | 1.5931 | 1.5999 | 1.593 | 1.5955 | 2002.0 |
| 2014-06-19 | ED | Futures | 95.4067 | 95.4162 | 95.4067 | 95.4115 | 89131.0 |
| 2014-06-19 | ER | Futures | 97.911 | 97.92 | 97.906 | 97.916 | 41795.0 |
| 2014-06-19 | EW | Futures | 1472.4 | 1475.3 | 1466.7 | 1471.4 | 14786.0 |
| 2014-06-19 | FBTP | Futures | 91.09 | 91.24 | 90.89 | 91.03 | 60294.0 |
| 2014-06-19 | FBTS | Futures | 98.001 | 98.045 | 97.885 | 97.93 | 18431.0 |
| 2014-06-19 | FCE | Futures | 3637.9 | 3653.1 | 3633.5 | 3636.7 | 72067.0 |
| 2014-06-19 | FDAX | Futures | 11027.4 | 11046.7 | 11013.1 | 11026.8 | 49465.0 |
| 2014-06-19 | FESX | Futures | 2373.5 | 2388.6 | 2372.7 | 2380.7 | 823475.0 |
| 2014-06-19 | FGBL | Futures | 126.76 | 127.24 | 126.7 | 127.08 | 595996.0 |
| 2014-06-19 | FGBM | Futures | 121.18 | 121.35 | 121.13 | 121.27 | 409148.0 |
| 2014-06-19 | FGBS | Futures | 110.748 | 110.753 | 110.733 | 110.753 | 192203.0 |
| 2014-06-19 | FGBX | Futures | 130.56 | 131.45 | 130.56 | 131.11 | 18090.0 |
| 2014-06-19 | FMWO | Futures | 5804.1 | 5804.1 | 5796.5 | 5796.5 | 276.0 |
| 2014-06-19 | FOAT | Futures | 116.41 | 116.95 | 116.41 | 116.82 | 70670.0 |
| 2014-06-19 | FTDX | Futures | 1242.7 | 1256.2 | 1242.7 | 1243.6 | 1161.0 |
| 2014-06-19 | FTI | Futures | 361.38 | 362.24 | 360.9 | 361.42 | 20272.0 |
| 2014-06-19 | FTUK | Futures | 5202.3 | 5224.6 | 5199.2 | 5202.7 | 103203.0 |
| 2014-06-19 | FVSA | Futures | 1310.85 | 1310.85 | 1254.98 | 1267.87 | 13002.0 |
| 2014-06-19 | FXXP | Futures | 261.8 | 262.2 | 261.4 | 261.6 | 12304.0 |
| 2014-06-19 | G | Futures | 93.38 | 93.63 | 93.15 | 93.24 | 166023.0 |
| 2014-06-19 | GF | Futures | 314.757 | 318.55 | 314.68 | 318.09 | 3901.0 |
| 2014-06-19 | GSCI | Futures | 1108.17 | 1116.08 | 1108.17 | 1113.67 | 109.0 |
| 2014-06-19 | HE | Futures | 133.338 | 135.048 | 133.233 | 134.732 | 9489.0 |
| 2014-06-19 | HG | Futures | 3.9196 | 3.9324 | 3.8908 | 3.9311 | 15127.0 |
| 2014-06-19 | HH | Futures | 58.882 | 59.452 | 58.058 | 58.108 | 1290.0 |
> showing 50 of 104 rows — these rows as CSV