PREVIEW / futures_daily / 2014-03-13
file: by_date/futures_daily/2014/2014-03-13.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 |
|---|---|---|---|---|---|---|---|
| 2014-03-13 | ES | Futures | 1926.41 | 1932.85 | 1898.32 | 1903.73 | 2346907.0 |
| 2014-03-13 | NQ | Futures | 4262.74 | 4279.13 | 4180.26 | 4197.5 | 450566.0 |
| 2014-03-13 | YM | Futures | 16342.7 | 16409.0 | 16081.7 | 16112.8 | 48940.0 |
| 2014-03-13 | CL | Futures | 174.57 | 175.46 | 173.8 | 174.74 | 268074.0 |
| 2014-03-13 | GC | Futures | 1803.0 | 1813.4 | 1799.2 | 1809.1 | 175113.0 |
| 2014-03-13 | ZN | Futures | 114.982681 | 115.649079 | 114.765377 | 115.54767 | 2029979.0 |
| 2014-03-13 | A6 | Futures | 0.85811 | 0.86916 | 0.85811 | 0.86119 | 90333.0 |
| 2014-03-13 | AD | Futures | 0.90984 | 0.91613 | 0.90964 | 0.9143 | 57041.0 |
| 2014-03-13 | B | Futures | 110.7 | 110.89 | 109.57 | 110.0 | 228723.0 |
| 2014-03-13 | B6 | Futures | 1.7457 | 1.7563 | 1.7442 | 1.7451 | 93448.0 |
| 2014-03-13 | BR | Futures | 0.21969 | 0.2204 | 0.21827 | 0.21827 | 195.0 |
| 2014-03-13 | BZ | Futures | 112.82 | 113.09 | 111.71 | 112.2 | 9262.0 |
| 2014-03-13 | C | Futures | 1938.0 | 1975.0 | 1938.0 | 1966.0 | 7998.0 |
| 2014-03-13 | CB | Futures | 92.92 | 92.92 | 92.87 | 92.908 | 25.0 |
| 2014-03-13 | CC | Futures | 2193.0 | 2241.0 | 2190.0 | 2232.0 | 15735.0 |
| 2014-03-13 | CNH | Futures | 7.049 | 7.0628 | 7.0487 | 7.0628 | 97.0 |
| 2014-03-13 | CSC | Futures | 4.332 | 4.35 | 4.332 | 4.35 | 16.0 |
| 2014-03-13 | CT | Futures | 104.15 | 105.37 | 102.8 | 103.04 | 9820.0 |
| 2014-03-13 | DC | Futures | 34.3 | 34.75 | 34.26 | 34.52 | 121.0 |
| 2014-03-13 | DX | Futures | 75.727 | 75.836 | 75.408 | 75.769 | 42089.0 |
| 2014-03-13 | E1 | Futures | 1.46959 | 1.47627 | 1.46523 | 1.46728 | 29796.0 |
| 2014-03-13 | E6 | Futures | 1.64107 | 1.64874 | 1.63434 | 1.63599 | 209455.0 |
| 2014-03-13 | E7 | Futures | 1.6304 | 1.6378 | 1.6234 | 1.6251 | 3844.0 |
| 2014-03-13 | EBM | Futures | 303.68 | 304.38 | 295.22 | 298.04 | 25701.0 |
| 2014-03-13 | ED | Futures | 95.3899 | 95.3899 | 95.3851 | 95.3851 | 133026.0 |
| 2014-03-13 | ER | Futures | 97.837 | 97.857 | 97.832 | 97.847 | 119579.0 |
| 2014-03-13 | EW | Futures | 1416.3 | 1420.7 | 1394.9 | 1399.3 | 35123.0 |
| 2014-03-13 | FBTP | Futures | 86.34 | 86.55 | 86.2 | 86.38 | 68094.0 |
| 2014-03-13 | FBTS | Futures | 97.02 | 97.047 | 96.959 | 97.012 | 11136.0 |
| 2014-03-13 | FCE | Futures | 3338.8 | 3353.2 | 3273.9 | 3299.6 | 3288.0 |
| 2014-03-13 | FDAX | Futures | 10225.6 | 10235.0 | 9901.2 | 10005.5 | 162445.0 |
| 2014-03-13 | FESX | Futures | 2160.1 | 2163.7 | 2099.0 | 2123.5 | 240688.0 |
| 2014-03-13 | FEU3 | Futures | 98.463 | 98.468 | 98.463 | 98.468 | 305.0 |
| 2014-03-13 | FGBL | Futures | 123.25 | 124.08 | 123.22 | 123.78 | 908389.0 |
| 2014-03-13 | FGBM | Futures | 119.57 | 119.96 | 119.57 | 119.85 | 568860.0 |
| 2014-03-13 | FGBS | Futures | 110.508 | 110.588 | 110.508 | 110.563 | 365878.0 |
| 2014-03-13 | FGBX | Futures | 125.38 | 126.89 | 125.38 | 126.38 | 24938.0 |
| 2014-03-13 | FMWO | Futures | 5503.8 | 5503.8 | 5439.6 | 5439.6 | 891.0 |
| 2014-03-13 | FOAT | Futures | 111.65 | 112.16 | 111.63 | 112.08 | 45391.0 |
| 2014-03-13 | FTDX | Futures | 1172.3 | 1172.3 | 1149.8 | 1149.8 | 6.0 |
| 2014-03-13 | FTI | Futures | 334.89 | 334.89 | 327.04 | 329.39 | 405.0 |
| 2014-03-13 | FTUK | Futures | 5016.5 | 5018.5 | 4919.7 | 4954.4 | 34092.0 |
| 2014-03-13 | FVSA | Futures | 1935.96 | 2031.25 | 1920.91 | 2031.25 | 15924.0 |
| 2014-03-13 | FXXP | Futures | 241.9 | 242.2 | 239.1 | 239.5 | 6300.0 |
| 2014-03-13 | G | Futures | 93.17 | 93.7 | 92.97 | 93.56 | 170602.0 |
| 2014-03-13 | GF | Futures | 281.597 | 282.797 | 280.276 | 281.637 | 2929.0 |
| 2014-03-13 | GSCI | Futures | 1060.83 | 1061.24 | 1055.13 | 1056.2 | 1546.0 |
| 2014-03-13 | HE | Futures | 141.092 | 143.628 | 140.307 | 143.628 | 31243.0 |
| 2014-03-13 | HG | Futures | 3.7461 | 3.7727 | 3.6935 | 3.7043 | 60235.0 |
| 2014-03-13 | HH | Futures | 57.673 | 57.882 | 56.813 | 57.139 | 7522.0 |
> showing 50 of 103 rows — these rows as CSV