PREVIEW / futures_daily / 2014-04-25
file: by_date/futures_daily/2014/2014-04-25.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-04-25 | ES | Futures | 1937.36 | 1938.65 | 1917.18 | 1924.43 | 1507792.0 |
| 2014-04-25 | NQ | Futures | 4130.16 | 4132.18 | 4047.86 | 4063.98 | 330378.0 |
| 2014-04-25 | YM | Futures | 16472.3 | 16481.3 | 16330.7 | 16390.9 | 153927.0 |
| 2014-04-25 | CL | Futures | 184.62 | 184.84 | 182.0 | 182.21 | 221601.0 |
| 2014-04-25 | GC | Futures | 1704.7 | 1719.7 | 1700.2 | 1713.9 | 107958.0 |
| 2014-04-25 | ZN | Futures | 114.93922 | 115.257932 | 114.895759 | 115.026141 | 1054779.0 |
| 2014-04-25 | A6 | Futures | 0.88674 | 0.8903 | 0.88607 | 0.88751 | 50374.0 |
| 2014-04-25 | AD | Futures | 0.91846 | 0.91958 | 0.91674 | 0.91745 | 30842.0 |
| 2014-04-25 | B | Futures | 113.94 | 114.06 | 112.68 | 112.97 | 95062.0 |
| 2014-04-25 | B6 | Futures | 1.7652 | 1.7687 | 1.7639 | 1.7651 | 52956.0 |
| 2014-04-25 | BFX | Futures | 3727.9 | 3727.9 | 3702.3 | 3702.3 | 5.0 |
| 2014-04-25 | BR | Futures | 0.23492 | 0.23492 | 0.23226 | 0.2326 | 187.0 |
| 2014-04-25 | BZ | Futures | 116.13 | 116.32 | 114.92 | 115.22 | 6379.0 |
| 2014-04-25 | C | Futures | 1935.0 | 1941.0 | 1923.0 | 1926.0 | 8975.0 |
| 2014-04-25 | CB | Futures | 94.938 | 95.446 | 94.938 | 95.446 | 17.0 |
| 2014-04-25 | CC | Futures | 2187.0 | 2200.0 | 2173.0 | 2178.0 | 11162.0 |
| 2014-04-25 | CNH | Futures | 7.184 | 7.1887 | 7.1833 | 7.186 | 2.0 |
| 2014-04-25 | CSC | Futures | 4.509 | 4.511 | 4.471 | 4.488 | 75.0 |
| 2014-04-25 | CT | Futures | 104.94 | 105.2 | 103.83 | 105.0 | 6808.0 |
| 2014-04-25 | DC | Futures | 36.17 | 36.36 | 35.88 | 36.08 | 270.0 |
| 2014-04-25 | DX | Futures | 75.855 | 75.888 | 75.75 | 75.829 | 8588.0 |
| 2014-04-25 | E1 | Futures | 1.45599 | 1.45868 | 1.45547 | 1.4574 | 14087.0 |
| 2014-04-25 | E6 | Futures | 1.63281 | 1.63493 | 1.6321 | 1.63316 | 94850.0 |
| 2014-04-25 | E7 | Futures | 1.6217 | 1.6238 | 1.6213 | 1.6223 | 1688.0 |
| 2014-04-25 | EBM | Futures | 304.38 | 306.85 | 304.38 | 306.14 | 9666.0 |
| 2014-04-25 | ED | Futures | 95.4043 | 95.4091 | 95.4043 | 95.4091 | 39405.0 |
| 2014-04-25 | ER | Futures | 97.813 | 97.822 | 97.808 | 97.817 | 49867.0 |
| 2014-04-25 | EW | Futures | 1401.8 | 1404.1 | 1384.7 | 1388.1 | 15863.0 |
| 2014-04-25 | FBTP | Futures | 88.62 | 88.69 | 88.44 | 88.61 | 34460.0 |
| 2014-04-25 | FBTS | Futures | 97.469 | 97.487 | 97.425 | 97.443 | 12924.0 |
| 2014-04-25 | FCE | Futures | 3504.8 | 3507.1 | 3472.6 | 3483.3 | 95551.0 |
| 2014-04-25 | FDAX | Futures | 10529.6 | 10530.7 | 10360.7 | 10402.6 | 114792.0 |
| 2014-04-25 | FESX | Futures | 2243.4 | 2244.9 | 2212.5 | 2221.2 | 871546.0 |
| 2014-04-25 | FGBL | Futures | 124.25 | 124.7 | 124.24 | 124.67 | 541831.0 |
| 2014-04-25 | FGBM | Futures | 119.69 | 119.91 | 119.69 | 119.87 | 330612.0 |
| 2014-04-25 | FGBS | Futures | 110.478 | 110.528 | 110.473 | 110.513 | 216374.0 |
| 2014-04-25 | FGBX | Futures | 128.31 | 129.47 | 128.21 | 129.33 | 18666.0 |
| 2014-04-25 | FMWO | Futures | 5530.4 | 5530.4 | 5530.4 | 5530.4 | 0.0 |
| 2014-04-25 | FOAT | Futures | 113.56 | 113.92 | 113.56 | 113.89 | 44560.0 |
| 2014-04-25 | FTDX | Futures | 1142.8 | 1142.8 | 1132.0 | 1137.2 | 141.0 |
| 2014-04-25 | FTI | Futures | 338.27 | 338.27 | 334.82 | 335.64 | 26342.0 |
| 2014-04-25 | FTUK | Futures | 5065.3 | 5072.6 | 5042.5 | 5061.2 | 89483.0 |
| 2014-04-25 | FVSA | Futures | 1775.55 | 1861.24 | 1770.79 | 1846.96 | 10378.0 |
| 2014-04-25 | FXXP | Futures | 248.8 | 248.9 | 246.7 | 247.4 | 4835.0 |
| 2014-04-25 | G | Futures | 94.03 | 94.38 | 93.96 | 94.34 | 117116.0 |
| 2014-04-25 | GF | Futures | 285.882 | 287.155 | 285.245 | 286.479 | 2324.0 |
| 2014-04-25 | GSCI | Futures | 1094.83 | 1096.57 | 1089.03 | 1089.36 | 206.0 |
| 2014-04-25 | HE | Futures | 142.401 | 142.401 | 140.359 | 141.059 | 598.0 |
| 2014-04-25 | HG | Futures | 3.9426 | 3.963 | 3.9234 | 3.9522 | 25481.0 |
| 2014-04-25 | HH | Futures | 59.211 | 59.211 | 58.907 | 59.046 | 202.0 |
> showing 50 of 104 rows — these rows as CSV