PREVIEW / futures_daily / 2014-03-26
file: by_date/futures_daily/2014/2014-03-26.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-26 | ES | Futures | 1923.39 | 1933.48 | 1905.29 | 1906.32 | 1898746.0 |
| 2014-03-26 | NQ | Futures | 4169.88 | 4198.66 | 4110.31 | 4112.61 | 352854.0 |
| 2014-03-26 | YM | Futures | 16361.8 | 16459.2 | 16236.3 | 16245.3 | 193911.0 |
| 2014-03-26 | CL | Futures | 176.99 | 179.28 | 176.85 | 178.92 | 211367.0 |
| 2014-03-26 | GC | Futures | 1728.7 | 1735.3 | 1712.1 | 1717.3 | 52447.0 |
| 2014-03-26 | ZN | Futures | 114.359743 | 114.895759 | 114.301795 | 114.779864 | 1214639.0 |
| 2014-03-26 | A6 | Futures | 0.87512 | 0.88328 | 0.87464 | 0.88155 | 98232.0 |
| 2014-03-26 | AD | Futures | 0.90619 | 0.91339 | 0.90609 | 0.91076 | 59442.0 |
| 2014-03-26 | B | Futures | 110.27 | 110.7 | 109.85 | 110.42 | 122872.0 |
| 2014-03-26 | B6 | Futures | 1.7366 | 1.7433 | 1.7341 | 1.741 | 74421.0 |
| 2014-03-26 | BR | Futures | 0.22541 | 0.22583 | 0.22348 | 0.22409 | 760.0 |
| 2014-03-26 | BZ | Futures | 112.52 | 112.81 | 111.97 | 112.54 | 8082.0 |
| 2014-03-26 | C | Futures | 1966.0 | 1970.0 | 1953.0 | 1966.0 | 4926.0 |
| 2014-03-26 | CB | Futures | 95.345 | 95.446 | 95.192 | 95.192 | 23.0 |
| 2014-03-26 | CC | Futures | 2192.0 | 2204.0 | 2180.0 | 2200.0 | 10753.0 |
| 2014-03-26 | CSC | Futures | 4.477 | 4.491 | 4.417 | 4.417 | 62.0 |
| 2014-03-26 | CT | Futures | 105.79 | 109.42 | 102.09 | 103.02 | 32676.0 |
| 2014-03-26 | DC | Futures | 35.6 | 35.67 | 35.06 | 35.2 | 279.0 |
| 2014-03-26 | DX | Futures | 76.116 | 76.278 | 76.059 | 76.163 | 11938.0 |
| 2014-03-26 | E1 | Futures | 1.45445 | 1.45496 | 1.44777 | 1.45162 | 25864.0 |
| 2014-03-26 | E6 | Futures | 1.63222 | 1.63222 | 1.62608 | 1.62785 | 143984.0 |
| 2014-03-26 | E7 | Futures | 1.6211 | 1.6212 | 1.6154 | 1.617 | 3485.0 |
| 2014-03-26 | EBM | Futures | 299.8 | 299.8 | 296.28 | 296.63 | 12585.0 |
| 2014-03-26 | ED | Futures | 95.3899 | 95.3947 | 95.3851 | 95.3947 | 113446.0 |
| 2014-03-26 | ER | Futures | 97.827 | 97.847 | 97.822 | 97.842 | 56834.0 |
| 2014-03-26 | EW | Futures | 1413.2 | 1421.7 | 1391.7 | 1393.5 | 18929.0 |
| 2014-03-26 | FBTP | Futures | 86.56 | 87.03 | 86.48 | 86.95 | 54095.0 |
| 2014-03-26 | FBTS | Futures | 97.029 | 97.188 | 97.029 | 97.161 | 13432.0 |
| 2014-03-26 | FCE | Futures | 3395.2 | 3419.7 | 3382.4 | 3408.8 | 113886.0 |
| 2014-03-26 | FDAX | Futures | 10392.7 | 10501.4 | 10356.8 | 10445.7 | 110322.0 |
| 2014-03-26 | FESX | Futures | 2188.8 | 2209.0 | 2181.7 | 2198.2 | 943395.0 |
| 2014-03-26 | FEU3 | Futures | 98.458 | 98.463 | 98.458 | 98.463 | 278.0 |
| 2014-03-26 | FGBL | Futures | 123.56 | 123.92 | 123.54 | 123.76 | 617349.0 |
| 2014-03-26 | FGBM | Futures | 119.62 | 119.8 | 119.59 | 119.72 | 387229.0 |
| 2014-03-26 | FGBS | Futures | 110.503 | 110.538 | 110.498 | 110.523 | 200648.0 |
| 2014-03-26 | FGBX | Futures | 126.42 | 126.97 | 126.36 | 126.74 | 16991.0 |
| 2014-03-26 | FMWO | Futures | 5495.1 | 5495.1 | 5495.1 | 5495.1 | 0.0 |
| 2014-03-26 | FOAT | Futures | 112.37 | 112.75 | 112.35 | 112.64 | 47605.0 |
| 2014-03-26 | FTDX | Futures | 1157.8 | 1164.4 | 1153.6 | 1159.7 | 178.0 |
| 2014-03-26 | FTI | Futures | 336.52 | 339.76 | 336.17 | 338.65 | 28312.0 |
| 2014-03-26 | FTUK | Futures | 4999.4 | 5023.0 | 4955.2 | 4990.2 | 109699.0 |
| 2014-03-26 | FVSA | Futures | 1825.62 | 1835.65 | 1780.48 | 1820.6 | 9469.0 |
| 2014-03-26 | FXXP | Futures | 243.2 | 245.2 | 242.7 | 244.2 | 6549.0 |
| 2014-03-26 | G | Futures | 93.56 | 93.82 | 93.47 | 93.67 | 121929.0 |
| 2014-03-26 | GF | Futures | 284.478 | 286.68 | 284.198 | 285.959 | 1635.0 |
| 2014-03-26 | GSCI | Futures | 1063.31 | 1064.8 | 1060.0 | 1063.23 | 57.0 |
| 2014-03-26 | HE | Futures | 141.293 | 143.567 | 139.339 | 142.663 | 459.0 |
| 2014-03-26 | HG | Futures | 3.7936 | 3.8183 | 3.7505 | 3.7582 | 46100.0 |
| 2014-03-26 | HH | Futures | 55.643 | 55.87 | 55.098 | 55.63 | 3199.0 |
| 2014-03-26 | HO | Futures | 2.3207 | 2.3328 | 2.3091 | 2.3218 | 16943.0 |
> showing 50 of 103 rows — these rows as CSV