PREVIEW / futures_daily / 2013-08-14
file: by_date/futures_daily/2013/2013-08-14.parquet size: 9 KB rows: 103
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-08-14 | ES | Futures | 1742.18 | 1743.99 | 1731.37 | 1732.4 | 1504592.0 |
| 2013-08-14 | NQ | Futures | 3630.75 | 3636.53 | 3602.41 | 3612.82 | 234087.0 |
| 2013-08-14 | YM | Futures | 15279.7 | 15289.6 | 15145.9 | 15168.7 | 145184.0 |
| 2013-08-14 | CL | Futures | 186.58 | 187.67 | 185.17 | 187.32 | 149167.0 |
| 2013-08-14 | GC | Futures | 1746.2 | 1766.7 | 1739.3 | 1763.5 | 120612.0 |
| 2013-08-14 | ZN | Futures | 112.899817 | 113.110373 | 112.801558 | 112.998077 | 785023.0 |
| 2013-08-14 | A6 | Futures | 0.85212 | 0.85775 | 0.85025 | 0.85597 | 76931.0 |
| 2013-08-14 | AD | Futures | 0.97359 | 0.9756 | 0.97076 | 0.97439 | 43498.0 |
| 2013-08-14 | B | Futures | 106.28 | 106.86 | 105.69 | 106.71 | 214660.0 |
| 2013-08-14 | B6 | Futures | 1.6191 | 1.6298 | 1.6167 | 1.6254 | 120338.0 |
| 2013-08-14 | BFX | Futures | 3408.3 | 3408.3 | 3395.6 | 3400.1 | 1041.0 |
| 2013-08-14 | BR | Futures | 0.21361 | 0.2139 | 0.21197 | 0.21247 | 1583.0 |
| 2013-08-14 | BZ | Futures | 106.8 | 107.64 | 106.47 | 107.49 | 8033.0 |
| 2013-08-14 | C | Futures | 1728.0 | 1763.0 | 1724.0 | 1753.0 | 4812.0 |
| 2013-08-14 | CB | Futures | 68.887 | 69.126 | 68.528 | 69.126 | 23.0 |
| 2013-08-14 | CC | Futures | 1827.0 | 1872.0 | 1823.0 | 1859.0 | 17801.0 |
| 2013-08-14 | CSC | Futures | 3.368 | 3.404 | 3.368 | 3.404 | 3.0 |
| 2013-08-14 | CT | Futures | 108.96 | 109.56 | 108.35 | 108.91 | 15.0 |
| 2013-08-14 | DC | Futures | 25.84 | 26.2 | 25.79 | 26.11 | 184.0 |
| 2013-08-14 | DX | Futures | 78.171 | 78.276 | 78.042 | 78.136 | 20072.0 |
| 2013-08-14 | E1 | Futures | 1.37774 | 1.37889 | 1.37093 | 1.3753 | 29081.0 |
| 2013-08-14 | E6 | Futures | 1.56554 | 1.56766 | 1.56247 | 1.56495 | 169868.0 |
| 2013-08-14 | E7 | Futures | 1.5553 | 1.5572 | 1.5524 | 1.5547 | 2382.0 |
| 2013-08-14 | ED | Futures | 95.3012 | 95.306 | 95.2964 | 95.3012 | 69593.0 |
| 2013-08-14 | ER | Futures | 97.817 | 97.822 | 97.808 | 97.822 | 41760.0 |
| 2013-08-14 | EW | Futures | 1260.2 | 1260.8 | 1251.4 | 1251.7 | 16448.0 |
| 2013-08-14 | FBTP | Futures | 78.73 | 79.1 | 78.66 | 79.06 | 21988.0 |
| 2013-08-14 | FBTS | Futures | 93.324 | 93.461 | 93.307 | 93.436 | 2782.0 |
| 2013-08-14 | FCE | Futures | 3164.1 | 3181.4 | 3154.8 | 3172.9 | 123887.0 |
| 2013-08-14 | FDAX | Futures | 9376.1 | 9392.2 | 9325.1 | 9363.4 | 70717.0 |
| 2013-08-14 | FESX | Futures | 1999.7 | 2006.7 | 1989.9 | 2001.1 | 765498.0 |
| 2013-08-14 | FGBL | Futures | 117.86 | 118.15 | 117.69 | 118.02 | 661428.0 |
| 2013-08-14 | FGBM | Futures | 116.44 | 116.6 | 116.36 | 116.55 | 390099.0 |
| 2013-08-14 | FGBS | Futures | 110.153 | 110.203 | 110.133 | 110.188 | 280212.0 |
| 2013-08-14 | FGBX | Futures | 120.97 | 121.26 | 120.51 | 120.87 | 9196.0 |
| 2013-08-14 | FMWO | Futures | 5011.7 | 5011.7 | 5011.7 | 5011.7 | 0.0 |
| 2013-08-14 | FOAT | Futures | 105.84 | 106.13 | 105.74 | 106.09 | 27165.0 |
| 2013-08-14 | FTDX | Futures | 973.4 | 983.8 | 971.5 | 980.0 | 145.0 |
| 2013-08-14 | FTI | Futures | 329.08 | 331.61 | 329.08 | 331.04 | 37777.0 |
| 2013-08-14 | FTUK | Futures | 4952.7 | 4976.7 | 4924.9 | 4941.4 | 66899.0 |
| 2013-08-14 | FVSA | Futures | 2575.3 | 2588.61 | 2548.68 | 2555.34 | 3711.0 |
| 2013-08-14 | FXXP | Futures | 226.7 | 227.7 | 226.1 | 227.5 | 2036.0 |
| 2013-08-14 | G | Futures | 92.66 | 92.93 | 92.32 | 92.62 | 160175.0 |
| 2013-08-14 | GF | Futures | 259.672 | 260.166 | 258.275 | 258.891 | 1933.0 |
| 2013-08-14 | GSCI | Futures | 1052.13 | 1060.44 | 1051.56 | 1057.65 | 362.0 |
| 2013-08-14 | HE | Futures | 104.944 | 106.91 | 104.944 | 106.637 | 22795.0 |
| 2013-08-14 | HG | Futures | 4.2062 | 4.25 | 4.1808 | 4.2379 | 57729.0 |
| 2013-08-14 | HH | Futures | 36.818 | 37.138 | 36.818 | 36.818 | 286.0 |
| 2013-08-14 | HO | Futures | 2.4375 | 2.4534 | 2.4309 | 2.4477 | 35308.0 |
| 2013-08-14 | HRC | Futures | 2259.4 | 2259.4 | 2259.4 | 2259.4 | 0.0 |
> showing 50 of 103 rows — these rows as CSV