PREVIEW / futures_daily / 2013-07-17
file: by_date/futures_daily/2013/2013-07-17.parquet size: 9 KB rows: 101
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-07-17 | ES | Futures | 1721.84 | 1730.85 | 1715.66 | 1725.7 | 1413187.0 |
| 2013-07-17 | NQ | Futures | 3554.98 | 3570.31 | 3546.01 | 3561.92 | 186222.0 |
| 2013-07-17 | YM | Futures | 15251.9 | 15322.3 | 15209.3 | 15303.5 | 128740.0 |
| 2013-07-17 | CL | Futures | 184.2 | 185.86 | 183.01 | 185.74 | 159379.0 |
| 2013-07-17 | GC | Futures | 1714.1 | 1725.4 | 1685.0 | 1695.9 | 223427.0 |
| 2013-07-17 | ZN | Futures | 113.713965 | 114.373705 | 113.50341 | 114.107002 | 1287702.0 |
| 2013-07-17 | A6 | Futures | 0.86329 | 0.86817 | 0.85869 | 0.86197 | 124432.0 |
| 2013-07-17 | AD | Futures | 0.96935 | 0.97147 | 0.9624 | 0.96583 | 78035.0 |
| 2013-07-17 | B | Futures | 104.94 | 105.76 | 104.36 | 105.63 | 183572.0 |
| 2013-07-17 | B6 | Futures | 1.5878 | 1.6002 | 1.5803 | 1.5939 | 165014.0 |
| 2013-07-17 | BFX | Futures | 3165.9 | 3171.4 | 3139.2 | 3163.1 | 421.0 |
| 2013-07-17 | BR | Futures | 0.2169 | 0.22031 | 0.21685 | 0.21965 | 103.0 |
| 2013-07-17 | BZ | Futures | 105.71 | 106.43 | 105.06 | 106.34 | 5284.0 |
| 2013-07-17 | C | Futures | 1682.0 | 1698.0 | 1678.0 | 1682.0 | 11806.0 |
| 2013-07-17 | CB | Futures | 77.486 | 77.486 | 77.259 | 77.378 | 6.0 |
| 2013-07-17 | CC | Futures | 1707.0 | 1739.0 | 1701.0 | 1719.0 | 18482.0 |
| 2013-07-17 | CSC | Futures | 3.545 | 3.551 | 3.518 | 3.526 | 24.0 |
| 2013-07-17 | CT | Futures | 100.39 | 100.39 | 100.1 | 100.12 | 8.0 |
| 2013-07-17 | DC | Futures | 27.13 | 27.35 | 27.05 | 27.15 | 237.0 |
| 2013-07-17 | DX | Futures | 79.022 | 79.375 | 78.821 | 79.17 | 52420.0 |
| 2013-07-17 | E1 | Futures | 1.36861 | 1.3744 | 1.36129 | 1.36617 | 38548.0 |
| 2013-07-17 | E6 | Futures | 1.55291 | 1.55598 | 1.5443 | 1.54772 | 253146.0 |
| 2013-07-17 | E7 | Futures | 1.5431 | 1.5459 | 1.5342 | 1.5376 | 4078.0 |
| 2013-07-17 | ED | Futures | 95.2869 | 95.2916 | 95.2821 | 95.2869 | 97090.0 |
| 2013-07-17 | ER | Futures | 97.817 | 97.827 | 97.813 | 97.822 | 64661.0 |
| 2013-07-17 | EW | Futures | 1238.7 | 1246.5 | 1234.6 | 1244.1 | 15505.0 |
| 2013-07-17 | FBTP | Futures | 76.97 | 77.17 | 76.75 | 76.87 | 23251.0 |
| 2013-07-17 | FBTS | Futures | 92.748 | 92.782 | 92.61 | 92.636 | 5953.0 |
| 2013-07-17 | FCE | Futures | 2981.6 | 3003.7 | 2955.7 | 2994.8 | 140849.0 |
| 2013-07-17 | FDAX | Futures | 9114.2 | 9181.4 | 9033.2 | 9158.6 | 98159.0 |
| 2013-07-17 | FESX | Futures | 1872.7 | 1888.8 | 1855.9 | 1880.4 | 874845.0 |
| 2013-07-17 | FGBL | Futures | 120.41 | 120.56 | 119.96 | 120.52 | 645890.0 |
| 2013-07-17 | FGBM | Futures | 117.71 | 117.81 | 117.47 | 117.79 | 392745.0 |
| 2013-07-17 | FGBS | Futures | 110.427 | 110.442 | 110.382 | 110.432 | 306619.0 |
| 2013-07-17 | FGBX | Futures | 125.59 | 125.72 | 124.74 | 125.66 | 7540.0 |
| 2013-07-17 | FMWO | Futures | 4935.7 | 4935.7 | 4931.9 | 4931.9 | 40.0 |
| 2013-07-17 | FOAT | Futures | 107.14 | 107.14 | 106.68 | 107.03 | 31903.0 |
| 2013-07-17 | FTDX | Futures | 930.5 | 933.4 | 920.7 | 931.5 | 56.0 |
| 2013-07-17 | FTI | Futures | 317.92 | 320.28 | 316.08 | 319.15 | 37755.0 |
| 2013-07-17 | FTUK | Futures | 4886.3 | 4913.3 | 4851.4 | 4893.8 | 88063.0 |
| 2013-07-17 | FVSA | Futures | 2937.07 | 3057.97 | 2908.63 | 2922.85 | 4864.0 |
| 2013-07-17 | FXXP | Futures | 217.1 | 218.7 | 215.7 | 218.2 | 6798.0 |
| 2013-07-17 | G | Futures | 95.69 | 95.78 | 95.0 | 95.5 | 171993.0 |
| 2013-07-17 | GF | Futures | 256.398 | 257.156 | 254.376 | 254.376 | 2073.0 |
| 2013-07-17 | GSCI | Futures | 1056.74 | 1059.2 | 1053.47 | 1059.2 | 180.0 |
| 2013-07-17 | HE | Futures | 99.535 | 99.871 | 98.683 | 98.967 | 13665.0 |
| 2013-07-17 | HG | Futures | 4.0279 | 4.0577 | 3.9493 | 3.9696 | 66550.0 |
| 2013-07-17 | HH | Futures | 40.713 | 40.824 | 40.189 | 40.423 | 13583.0 |
| 2013-07-17 | HO | Futures | 2.4403 | 2.4715 | 2.4317 | 2.4661 | 35249.0 |
| 2013-07-17 | HRC | Futures | 2203.6 | 2203.6 | 2203.6 | 2203.6 | 0.0 |
> showing 50 of 101 rows — these rows as CSV