PREVIEW / futures_daily / 2014-02-21
file: by_date/futures_daily/2014/2014-02-21.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-02-21 | ES | Futures | 1892.65 | 1900.9 | 1889.3 | 1890.85 | 1316655.0 |
| 2014-02-21 | NQ | Futures | 4220.78 | 4238.32 | 4208.43 | 4212.74 | 186798.0 |
| 2014-02-21 | YM | Futures | 16078.6 | 16145.5 | 16046.6 | 16067.6 | 135684.0 |
| 2014-02-21 | CL | Futures | 183.05 | 183.14 | 180.95 | 181.86 | 160533.0 |
| 2014-02-21 | GC | Futures | 1744.0 | 1751.6 | 1734.6 | 1744.8 | 110099.0 |
| 2014-02-21 | ZN | Futures | 114.94923 | 115.049385 | 114.705996 | 115.020769 | 975735.0 |
| 2014-02-21 | A6 | Futures | 0.8573 | 0.85787 | 0.85177 | 0.85377 | 65265.0 |
| 2014-02-21 | AD | Futures | 0.91187 | 0.91207 | 0.90397 | 0.90954 | 71577.0 |
| 2014-02-21 | B | Futures | 113.46 | 113.46 | 112.28 | 112.8 | 154902.0 |
| 2014-02-21 | B6 | Futures | 1.749 | 1.7568 | 1.7447 | 1.7484 | 122627.0 |
| 2014-02-21 | BR | Futures | 0.21764 | 0.22039 | 0.21754 | 0.21948 | 1930.0 |
| 2014-02-21 | BZ | Futures | 115.49 | 115.63 | 114.57 | 115.08 | 4938.0 |
| 2014-02-21 | C | Futures | 1960.0 | 1964.0 | 1937.0 | 1945.0 | 4005.0 |
| 2014-02-21 | CB | Futures | 87.831 | 87.831 | 87.831 | 87.831 | 2.0 |
| 2014-02-21 | CC | Futures | 2204.0 | 2229.0 | 2181.0 | 2190.0 | 14747.0 |
| 2014-02-21 | CNH | Futures | 7.0091 | 7.0425 | 7.0051 | 7.0159 | 42.0 |
| 2014-02-21 | CT | Futures | 98.39 | 100.4 | 98.39 | 99.3 | 5265.0 |
| 2014-02-21 | DC | Futures | 33.64 | 34.17 | 33.56 | 34.11 | 263.0 |
| 2014-02-21 | DX | Futures | 76.414 | 76.495 | 76.271 | 76.333 | 13849.0 |
| 2014-02-21 | E1 | Futures | 1.44328 | 1.4479 | 1.44084 | 1.44751 | 21007.0 |
| 2014-02-21 | E6 | Futures | 1.61982 | 1.62419 | 1.61746 | 1.62242 | 135181.0 |
| 2014-02-21 | E7 | Futures | 1.609 | 1.6136 | 1.6069 | 1.6118 | 2626.0 |
| 2014-02-21 | EBM | Futures | 276.0 | 276.7 | 275.3 | 276.0 | 9364.0 |
| 2014-02-21 | ED | Futures | 95.3829 | 95.3853 | 95.3829 | 95.3853 | 50527.0 |
| 2014-02-21 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 34611.0 |
| 2014-02-21 | EW | Futures | 1381.8 | 1389.0 | 1380.5 | 1384.0 | 12929.0 |
| 2014-02-21 | FBTP | Futures | 85.03 | 85.35 | 85.03 | 85.27 | 32399.0 |
| 2014-02-21 | FBTS | Futures | 96.59 | 96.687 | 96.582 | 96.669 | 6629.0 |
| 2014-02-21 | FCE | Futures | 3381.6 | 3396.7 | 3372.7 | 3395.1 | 104098.0 |
| 2014-02-21 | FDAX | Futures | 10699.2 | 10725.8 | 10646.5 | 10718.0 | 90380.0 |
| 2014-02-21 | FESX | Futures | 2201.3 | 2206.9 | 2190.0 | 2204.1 | 877010.0 |
| 2014-02-21 | FEU3 | Futures | 98.497 | 98.497 | 98.497 | 98.497 | 51.0 |
| 2014-02-21 | FGBL | Futures | 122.07 | 122.5 | 122.07 | 122.43 | 605980.0 |
| 2014-02-21 | FGBM | Futures | 119.14 | 119.35 | 119.14 | 119.32 | 349412.0 |
| 2014-02-21 | FGBS | Futures | 110.608 | 110.638 | 110.603 | 110.623 | 183329.0 |
| 2014-02-21 | FGBX | Futures | 123.34 | 124.12 | 123.34 | 124.02 | 13146.0 |
| 2014-02-21 | FMWO | Futures | 5454.7 | 5468.6 | 5451.0 | 5468.6 | 40.0 |
| 2014-02-21 | FOAT | Futures | 110.48 | 110.98 | 110.48 | 110.89 | 44127.0 |
| 2014-02-21 | FTDX | Futures | 1187.8 | 1191.1 | 1186.4 | 1187.8 | 65.0 |
| 2014-02-21 | FTI | Futures | 341.94 | 342.49 | 340.95 | 341.98 | 30293.0 |
| 2014-02-21 | FTUK | Futures | 5148.6 | 5174.4 | 5129.0 | 5155.1 | 139193.0 |
| 2014-02-21 | FVSA | Futures | 1781.82 | 1816.66 | 1761.91 | 1786.8 | 8299.0 |
| 2014-02-21 | FXXP | Futures | 246.3 | 246.9 | 245.6 | 246.5 | 7843.0 |
| 2014-02-21 | G | Futures | 92.81 | 92.94 | 92.52 | 92.8 | 177332.0 |
| 2014-02-21 | GF | Futures | 276.061 | 276.665 | 275.093 | 275.214 | 1726.0 |
| 2014-02-21 | GSCI | Futures | 1071.09 | 1072.15 | 1063.54 | 1067.31 | 470.0 |
| 2014-02-21 | HE | Futures | 118.507 | 120.138 | 118.356 | 119.987 | 20492.0 |
| 2014-02-21 | HG | Futures | 4.132 | 4.1364 | 4.1111 | 4.1314 | 23361.0 |
| 2014-02-21 | HH | Futures | 65.947 | 65.947 | 62.484 | 65.182 | 5850.0 |
| 2014-02-21 | HO | Futures | 2.4138 | 2.4138 | 2.385 | 2.3924 | 20461.0 |
> showing 50 of 104 rows — these rows as CSV