PREVIEW / futures_daily / 2013-09-11
file: by_date/futures_daily/2013/2013-09-11.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-11 | ES | Futures | 1732.66 | 1741.15 | 1728.02 | 1739.35 | 1843965.0 |
| 2013-09-11 | NQ | Futures | 3683.38 | 3688.58 | 3655.33 | 3676.73 | 220768.0 |
| 2013-09-11 | YM | Futures | 15031.4 | 15194.6 | 15014.5 | 15181.6 | 7204.0 |
| 2013-09-11 | CL | Futures | 188.72 | 190.01 | 187.26 | 189.07 | 238235.0 |
| 2013-09-11 | GC | Futures | 1804.2 | 1810.2 | 1793.4 | 1803.7 | 100134.0 |
| 2013-09-11 | ZN | Futures | 111.340584 | 111.907058 | 111.298098 | 111.836249 | 1271479.0 |
| 2013-09-11 | A6 | Futures | 0.87413 | 0.8764 | 0.87064 | 0.87602 | 44540.0 |
| 2013-09-11 | AD | Futures | 0.9741 | 0.97753 | 0.97258 | 0.97703 | 39357.0 |
| 2013-09-11 | B | Futures | 108.73 | 110.05 | 108.59 | 109.07 | 198532.0 |
| 2013-09-11 | B6 | Futures | 1.65 | 1.6604 | 1.6489 | 1.6601 | 68904.0 |
| 2013-09-11 | BR | Futures | 0.21906 | 0.22049 | 0.21688 | 0.21975 | 200.0 |
| 2013-09-11 | BZ | Futures | 109.73 | 110.88 | 109.38 | 109.9 | 7393.0 |
| 2013-09-11 | C | Futures | 1815.0 | 1815.0 | 1781.0 | 1799.0 | 8357.0 |
| 2013-09-11 | CB | Futures | 71.193 | 71.289 | 71.193 | 71.217 | 7.0 |
| 2013-09-11 | CC | Futures | 1918.0 | 1937.0 | 1890.0 | 1916.0 | 14140.0 |
| 2013-09-11 | CSC | Futures | 3.244 | 3.244 | 3.244 | 3.244 | 3.0 |
| 2013-09-11 | CT | Futures | 100.75 | 101.24 | 100.75 | 100.99 | 4.0 |
| 2013-09-11 | DC | Futures | 24.77 | 24.84 | 24.64 | 24.8 | 61.0 |
| 2013-09-11 | DX | Futures | 78.158 | 78.272 | 77.786 | 77.854 | 18371.0 |
| 2013-09-11 | E1 | Futures | 1.37555 | 1.38506 | 1.37247 | 1.38249 | 15414.0 |
| 2013-09-11 | E6 | Futures | 1.56625 | 1.57297 | 1.56341 | 1.5712 | 104490.0 |
| 2013-09-11 | E7 | Futures | 1.5557 | 1.5626 | 1.5536 | 1.5611 | 2560.0 |
| 2013-09-11 | ED | Futures | 95.3112 | 95.3208 | 95.3112 | 95.316 | 99011.0 |
| 2013-09-11 | ER | Futures | 97.837 | 97.842 | 97.832 | 97.842 | 64466.0 |
| 2013-09-11 | EW | Futures | 1250.7 | 1253.3 | 1243.7 | 1252.3 | 10025.0 |
| 2013-09-11 | FBTP | Futures | 76.97 | 77.29 | 76.93 | 77.19 | 22233.0 |
| 2013-09-11 | FBTS | Futures | 93.004 | 93.151 | 92.987 | 93.099 | 3505.0 |
| 2013-09-11 | FCE | Futures | 3173.7 | 3180.6 | 3161.0 | 3175.3 | 86136.0 |
| 2013-09-11 | FDAX | Futures | 9401.1 | 9450.0 | 9373.9 | 9416.7 | 84222.0 |
| 2013-09-11 | FESX | Futures | 1992.7 | 2003.2 | 1986.4 | 1995.5 | 253124.0 |
| 2013-09-11 | FGBL | Futures | 116.41 | 116.95 | 116.41 | 116.74 | 631210.0 |
| 2013-09-11 | FGBM | Futures | 116.06 | 116.36 | 116.05 | 116.23 | 352886.0 |
| 2013-09-11 | FGBS | Futures | 110.183 | 110.238 | 110.173 | 110.208 | 181451.0 |
| 2013-09-11 | FGBX | Futures | 117.15 | 118.06 | 117.15 | 117.75 | 11387.0 |
| 2013-09-11 | FMWO | Futures | 5034.5 | 5034.5 | 5034.5 | 5034.5 | 595.0 |
| 2013-09-11 | FOAT | Futures | 103.97 | 104.39 | 103.92 | 104.37 | 45169.0 |
| 2013-09-11 | FTI | Futures | 326.04 | 326.04 | 324.31 | 324.78 | 287.0 |
| 2013-09-11 | FTUK | Futures | 4920.4 | 4928.3 | 4900.2 | 4909.2 | 17604.0 |
| 2013-09-11 | FVSA | Futures | 2675.12 | 2688.43 | 2595.26 | 2595.26 | 3748.0 |
| 2013-09-11 | FXXP | Futures | 226.0 | 226.0 | 225.8 | 225.8 | 1293.0 |
| 2013-09-11 | G | Futures | 90.05 | 90.18 | 89.66 | 90.05 | 119269.0 |
| 2013-09-11 | GF | Futures | 257.208 | 259.572 | 256.516 | 257.942 | 3310.0 |
| 2013-09-11 | GSCI | Futures | 1084.08 | 1085.84 | 1079.81 | 1083.74 | 1659.0 |
| 2013-09-11 | HE | Futures | 110.811 | 110.811 | 108.573 | 109.238 | 41453.0 |
| 2013-09-11 | HG | Futures | 4.1348 | 4.1569 | 4.1221 | 4.124 | 29479.0 |
| 2013-09-11 | HH | Futures | 38.663 | 38.998 | 38.059 | 38.512 | 815.0 |
| 2013-09-11 | HO | Futures | 2.4524 | 2.473 | 2.4461 | 2.4545 | 16430.0 |
| 2013-09-11 | HRC | Futures | 2255.9 | 2255.9 | 2255.9 | 2255.9 | 0.0 |
| 2013-09-11 | J1 | Futures | 0.0125414 | 0.0126143 | 0.0125112 | 0.0125955 | 89636.0 |
| 2013-09-11 | J7 | Futures | 0.012525 | 0.0126 | 0.012502 | 0.012584 | 365.0 |
> showing 50 of 97 rows — these rows as CSV