PREVIEW / futures_daily / 2013-10-14
file: by_date/futures_daily/2013/2013-10-14.parquet size: 9 KB rows: 99
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-10-14 | ES | Futures | 1729.85 | 1753.22 | 1726.51 | 1750.65 | 1509558.0 |
| 2013-10-14 | NQ | Futures | 3681.03 | 3738.45 | 3669.54 | 3730.7 | 233830.0 |
| 2013-10-14 | YM | Futures | 15002.5 | 15166.7 | 14961.8 | 15148.8 | 137864.0 |
| 2013-10-14 | CL | Futures | 180.62 | 182.68 | 179.94 | 182.34 | 98230.0 |
| 2013-10-14 | GC | Futures | 1686.9 | 1708.2 | 1677.5 | 1688.4 | 110183.0 |
| 2013-10-14 | ZN | Futures | 114.512841 | 114.527003 | 113.903881 | 114.130471 | 190176.0 |
| 2013-10-14 | A6 | Futures | 0.88764 | 0.89435 | 0.88688 | 0.89161 | 41908.0 |
| 2013-10-14 | AD | Futures | 0.97359 | 0.97551 | 0.97288 | 0.9746 | 25884.0 |
| 2013-10-14 | B | Futures | 109.64 | 110.23 | 108.74 | 109.88 | 173253.0 |
| 2013-10-14 | B6 | Futures | 1.6758 | 1.6808 | 1.6739 | 1.6781 | 54636.0 |
| 2013-10-14 | BR | Futures | 0.23156 | 0.23214 | 0.22937 | 0.23021 | 193.0 |
| 2013-10-14 | BZ | Futures | 110.62 | 110.89 | 109.42 | 110.54 | 5510.0 |
| 2013-10-14 | C | Futures | 1899.0 | 1902.0 | 1863.0 | 1873.0 | 8575.0 |
| 2013-10-14 | CC | Futures | 2047.0 | 2055.0 | 2008.0 | 2022.0 | 10256.0 |
| 2013-10-14 | CSC | Futures | 3.358 | 3.377 | 3.358 | 3.367 | 16.0 |
| 2013-10-14 | CT | Futures | 97.97 | 98.51 | 97.81 | 98.08 | 7091.0 |
| 2013-10-14 | DC | Futures | 25.78 | 25.91 | 25.6 | 25.79 | 362.0 |
| 2013-10-14 | DX | Futures | 76.591 | 76.676 | 76.414 | 76.52 | 10067.0 |
| 2013-10-14 | E1 | Futures | 1.41308 | 1.4186 | 1.40948 | 1.41578 | 21972.0 |
| 2013-10-14 | E6 | Futures | 1.60011 | 1.60519 | 1.59882 | 1.60259 | 95690.0 |
| 2013-10-14 | E7 | Futures | 1.5897 | 1.5948 | 1.5885 | 1.5923 | 2082.0 |
| 2013-10-14 | ED | Futures | 95.3112 | 95.3255 | 95.3016 | 95.3112 | 60148.0 |
| 2013-10-14 | ER | Futures | 97.827 | 97.842 | 97.808 | 97.832 | 45944.0 |
| 2013-10-14 | EW | Futures | 1275.7 | 1289.7 | 1270.8 | 1288.0 | 18780.0 |
| 2013-10-14 | FBTP | Futures | 79.74 | 80.06 | 79.71 | 79.97 | 19306.0 |
| 2013-10-14 | FBTS | Futures | 94.275 | 94.336 | 94.189 | 94.301 | 4957.0 |
| 2013-10-14 | FCE | Futures | 3259.0 | 3284.6 | 3247.8 | 3269.1 | 36671.0 |
| 2013-10-14 | FDAX | Futures | 9643.1 | 9724.1 | 9629.8 | 9677.5 | 65939.0 |
| 2013-10-14 | FESX | Futures | 2071.2 | 2092.3 | 2066.3 | 2078.9 | 636735.0 |
| 2013-10-14 | FGBL | Futures | 119.02 | 119.13 | 118.61 | 119.0 | 236263.0 |
| 2013-10-14 | FGBM | Futures | 117.49 | 117.55 | 117.34 | 117.49 | 173779.0 |
| 2013-10-14 | FGBS | Futures | 110.413 | 110.428 | 110.388 | 110.423 | 116325.0 |
| 2013-10-14 | FGBX | Futures | 119.15 | 119.42 | 118.33 | 119.09 | 7379.0 |
| 2013-10-14 | FMWO | Futures | 5111.8 | 5111.8 | 5111.8 | 5111.8 | 0.0 |
| 2013-10-14 | FOAT | Futures | 106.68 | 106.7 | 106.53 | 106.64 | 16969.0 |
| 2013-10-14 | FTDX | Futures | 1022.4 | 1023.8 | 1020.0 | 1022.8 | 180.0 |
| 2013-10-14 | FTI | Futures | 323.21 | 325.89 | 322.35 | 323.9 | 5225.0 |
| 2013-10-14 | FTUK | Futures | 4841.7 | 4890.4 | 4825.5 | 4857.8 | 59559.0 |
| 2013-10-14 | FVSA | Futures | 2464.85 | 2519.62 | 2464.85 | 2489.19 | 11592.0 |
| 2013-10-14 | FXXP | Futures | 226.5 | 228.4 | 226.0 | 227.2 | 7405.0 |
| 2013-10-14 | G | Futures | 92.39 | 92.46 | 92.08 | 92.29 | 44893.0 |
| 2013-10-14 | GF | Futures | 273.576 | 274.141 | 271.802 | 273.254 | 1893.0 |
| 2013-10-14 | GSCI | Futures | 1061.46 | 1067.72 | 1057.71 | 1067.3 | 127.0 |
| 2013-10-14 | HE | Futures | 109.421 | 109.801 | 108.946 | 109.294 | 8296.0 |
| 2013-10-14 | HG | Futures | 4.1379 | 4.2006 | 4.1082 | 4.1823 | 49190.0 |
| 2013-10-14 | HH | Futures | 40.812 | 40.812 | 40.128 | 40.78 | 3451.0 |
| 2013-10-14 | HO | Futures | 2.4285 | 2.4374 | 2.4031 | 2.4249 | 19242.0 |
| 2013-10-14 | HRC | Futures | 2324.5 | 2324.5 | 2324.5 | 2324.5 | 0.0 |
| 2013-10-14 | J1 | Futures | 0.0128169 | 0.012832 | 0.0127666 | 0.0128031 | 48107.0 |
| 2013-10-14 | J7 | Futures | 0.012793 | 0.012822 | 0.012756 | 0.012791 | 443.0 |
> showing 50 of 99 rows — these rows as CSV