PREVIEW / futures_daily / 2014-05-16
file: by_date/futures_daily/2014/2014-05-16.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-05-16 | ES | Futures | 1931.67 | 1940.72 | 1925.72 | 1939.69 | 1522446.0 |
| 2014-05-16 | NQ | Futures | 4101.96 | 4131.89 | 4078.36 | 4124.12 | 294611.0 |
| 2014-05-16 | YM | Futures | 16483.3 | 16538.5 | 16444.1 | 16532.5 | 130925.0 |
| 2014-05-16 | CL | Futures | 183.99 | 185.12 | 183.66 | 184.77 | 144384.0 |
| 2014-05-16 | GC | Futures | 1708.1 | 1710.6 | 1696.7 | 1704.2 | 116836.0 |
| 2014-05-16 | ZN | Futures | 116.764572 | 116.837006 | 116.532781 | 116.619702 | 1078930.0 |
| 2014-05-16 | A6 | Futures | 0.89712 | 0.89856 | 0.895 | 0.89798 | 39592.0 |
| 2014-05-16 | AD | Futures | 0.93104 | 0.93337 | 0.93053 | 0.93246 | 29990.0 |
| 2014-05-16 | ALI | Futures | 2668.94 | 2668.94 | 2668.94 | 2668.94 | 0.0 |
| 2014-05-16 | B | Futures | 112.79 | 113.92 | 112.71 | 113.61 | 229928.0 |
| 2014-05-16 | B6 | Futures | 1.7642 | 1.7699 | 1.7636 | 1.7675 | 61760.0 |
| 2014-05-16 | BFX | Futures | 3743.3 | 3745.2 | 3732.6 | 3735.2 | 16.0 |
| 2014-05-16 | BR | Futures | 0.23644 | 0.2375 | 0.23644 | 0.23721 | 282.0 |
| 2014-05-16 | BZ | Futures | 115.24 | 116.17 | 114.96 | 115.87 | 6131.0 |
| 2014-05-16 | C | Futures | 1883.0 | 1897.0 | 1878.0 | 1893.0 | 4944.0 |
| 2014-05-16 | CB | Futures | 105.016 | 105.841 | 104.458 | 105.841 | 20.0 |
| 2014-05-16 | CC | Futures | 2137.0 | 2153.0 | 2136.0 | 2151.0 | 5780.0 |
| 2014-05-16 | CSC | Futures | 4.377 | 4.41 | 4.375 | 4.39 | 52.0 |
| 2014-05-16 | CT | Futures | 101.84 | 102.29 | 101.07 | 101.14 | 9221.0 |
| 2014-05-16 | DC | Futures | 35.55 | 35.63 | 35.25 | 35.49 | 190.0 |
| 2014-05-16 | DX | Futures | 76.059 | 76.173 | 76.031 | 76.104 | 12145.0 |
| 2014-05-16 | E1 | Futures | 1.44072 | 1.44251 | 1.43776 | 1.43943 | 19887.0 |
| 2014-05-16 | E6 | Futures | 1.6184 | 1.62041 | 1.61545 | 1.61699 | 118219.0 |
| 2014-05-16 | E7 | Futures | 1.6081 | 1.6096 | 1.6047 | 1.6062 | 2829.0 |
| 2014-05-16 | ED | Futures | 95.4186 | 95.4186 | 95.4138 | 95.4186 | 74980.0 |
| 2014-05-16 | ER | Futures | 97.886 | 97.886 | 97.852 | 97.876 | 58208.0 |
| 2014-05-16 | EW | Futures | 1386.9 | 1394.6 | 1379.2 | 1393.1 | 13050.0 |
| 2014-05-16 | FBTP | Futures | 88.62 | 89.18 | 88.36 | 88.95 | 128244.0 |
| 2014-05-16 | FBTS | Futures | 97.302 | 97.495 | 97.152 | 97.443 | 25309.0 |
| 2014-05-16 | FCE | Futures | 3531.8 | 3536.5 | 3498.6 | 3531.0 | 115176.0 |
| 2014-05-16 | FDAX | Futures | 10688.1 | 10700.8 | 10581.5 | 10620.7 | 114471.0 |
| 2014-05-16 | FESX | Futures | 2262.1 | 2272.2 | 2244.2 | 2263.6 | 969049.0 |
| 2014-05-16 | FGBL | Futures | 126.53 | 126.65 | 126.21 | 126.27 | 642976.0 |
| 2014-05-16 | FGBM | Futures | 120.89 | 120.92 | 120.74 | 120.77 | 430605.0 |
| 2014-05-16 | FGBS | Futures | 110.703 | 110.708 | 110.673 | 110.678 | 263258.0 |
| 2014-05-16 | FGBX | Futures | 132.25 | 132.38 | 131.44 | 131.62 | 17265.0 |
| 2014-05-16 | FMWO | Futures | 5583.4 | 5588.5 | 5570.8 | 5582.2 | 150.0 |
| 2014-05-16 | FOAT | Futures | 115.86 | 115.87 | 115.57 | 115.67 | 67573.0 |
| 2014-05-16 | FTDX | Futures | 1156.9 | 1156.9 | 1138.6 | 1144.7 | 163.0 |
| 2014-05-16 | FTI | Futures | 345.88 | 346.23 | 342.99 | 344.5 | 30180.0 |
| 2014-05-16 | FTUK | Futures | 5214.4 | 5224.7 | 5182.0 | 5213.7 | 106669.0 |
| 2014-05-16 | FVSA | Futures | 1709.09 | 1713.76 | 1653.06 | 1667.07 | 7983.0 |
| 2014-05-16 | FXXP | Futures | 253.5 | 253.6 | 251.5 | 253.3 | 6873.0 |
| 2014-05-16 | G | Futures | 95.35 | 95.4 | 95.03 | 95.09 | 120893.0 |
| 2014-05-16 | GF | Futures | 295.254 | 296.557 | 294.258 | 296.289 | 2127.0 |
| 2014-05-16 | GSCI | Futures | 1081.08 | 1082.73 | 1080.41 | 1081.33 | 58.0 |
| 2014-05-16 | HE | Futures | 133.027 | 133.641 | 132.386 | 132.72 | 11950.0 |
| 2014-05-16 | HG | Futures | 4.018 | 4.0372 | 3.9963 | 4.0212 | 34857.0 |
| 2014-05-16 | HH | Futures | 56.321 | 56.473 | 55.915 | 55.941 | 306.0 |
| 2014-05-16 | HO | Futures | 2.3539 | 2.3664 | 2.3491 | 2.3538 | 45969.0 |
> showing 50 of 103 rows — these rows as CSV