PREVIEW / futures_daily / 2014-07-10
file: by_date/futures_daily/2014/2014-07-10.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-07-10 | ES | Futures | 2043.83 | 2044.61 | 2020.72 | 2033.7 | 1972746.0 |
| 2014-07-10 | NQ | Futures | 4484.16 | 4487.62 | 4420.7 | 4469.45 | 317254.0 |
| 2014-07-10 | YM | Futures | 17066.0 | 17072.0 | 16872.2 | 16993.3 | 171720.0 |
| 2014-07-10 | CL | Futures | 186.23 | 188.15 | 185.5 | 188.02 | 238076.0 |
| 2014-07-10 | GC | Futures | 1745.8 | 1774.5 | 1745.8 | 1764.5 | 179492.0 |
| 2014-07-10 | ZN | Futures | 116.62327 | 117.163057 | 116.62327 | 116.87128 | 1404292.0 |
| 2014-07-10 | A6 | Futures | 0.90523 | 0.91016 | 0.90069 | 0.90388 | 80047.0 |
| 2014-07-10 | AD | Futures | 0.95176 | 0.95257 | 0.94973 | 0.95196 | 41158.0 |
| 2014-07-10 | ALI | Futures | 2809.67 | 2838.42 | 2809.67 | 2838.42 | 5.0 |
| 2014-07-10 | B | Futures | 113.91 | 114.86 | 113.57 | 114.66 | 254102.0 |
| 2014-07-10 | B6 | Futures | 1.8026 | 1.804 | 1.7972 | 1.8011 | 64503.0 |
| 2014-07-10 | BR | Futures | 0.23539 | 0.23539 | 0.23352 | 0.23418 | 274.0 |
| 2014-07-10 | BZ | Futures | 114.63 | 115.58 | 114.31 | 115.39 | 17788.0 |
| 2014-07-10 | C | Futures | 2005.0 | 2015.0 | 1995.0 | 2014.0 | 10029.0 |
| 2014-07-10 | CB | Futures | 118.484 | 118.484 | 116.737 | 117.408 | 13.0 |
| 2014-07-10 | CC | Futures | 2266.0 | 2272.0 | 2245.0 | 2264.0 | 16094.0 |
| 2014-07-10 | CNH | Futures | 7.1471 | 7.1471 | 7.1409 | 7.1409 | 2.0 |
| 2014-07-10 | CT | Futures | 88.81 | 88.81 | 86.92 | 86.92 | 62.0 |
| 2014-07-10 | DC | Futures | 34.14 | 34.73 | 34.14 | 34.42 | 235.0 |
| 2014-07-10 | DX | Futures | 75.99 | 76.171 | 75.957 | 76.1 | 13260.0 |
| 2014-07-10 | E1 | Futures | 1.43929 | 1.44058 | 1.43558 | 1.43686 | 25292.0 |
| 2014-07-10 | E6 | Futures | 1.61002 | 1.61108 | 1.60377 | 1.60554 | 145228.0 |
| 2014-07-10 | E7 | Futures | 1.5995 | 1.6005 | 1.5934 | 1.5951 | 1464.0 |
| 2014-07-10 | ED | Futures | 95.4115 | 95.4162 | 95.4115 | 95.4115 | 99495.0 |
| 2014-07-10 | ER | Futures | 97.911 | 97.911 | 97.901 | 97.906 | 36202.0 |
| 2014-07-10 | EW | Futures | 1476.0 | 1476.2 | 1450.2 | 1464.6 | 17907.0 |
| 2014-07-10 | FBTP | Futures | 91.39 | 91.46 | 90.8 | 90.93 | 89540.0 |
| 2014-07-10 | FBTS | Futures | 98.25 | 98.259 | 98.125 | 98.161 | 13625.0 |
| 2014-07-10 | FCE | Futures | 3480.6 | 3481.8 | 3414.8 | 3433.9 | 145770.0 |
| 2014-07-10 | FDAX | Futures | 10820.9 | 10821.5 | 10595.1 | 10646.9 | 140133.0 |
| 2014-07-10 | FESX | Futures | 2305.2 | 2305.9 | 2251.2 | 2264.9 | 1458984.0 |
| 2014-07-10 | FEU3 | Futures | 98.527 | 98.527 | 98.527 | 98.527 | 6.0 |
| 2014-07-10 | FGBL | Futures | 128.29 | 128.75 | 128.23 | 128.36 | 759989.0 |
| 2014-07-10 | FGBM | Futures | 121.66 | 121.85 | 121.63 | 121.7 | 461202.0 |
| 2014-07-10 | FGBS | Futures | 110.778 | 110.803 | 110.773 | 110.783 | 209471.0 |
| 2014-07-10 | FGBX | Futures | 133.32 | 134.59 | 133.28 | 134.06 | 19864.0 |
| 2014-07-10 | FMWO | Futures | 5732.4 | 5751.2 | 5727.3 | 5751.2 | 559.0 |
| 2014-07-10 | FOAT | Futures | 118.16 | 118.44 | 118.05 | 118.08 | 68922.0 |
| 2014-07-10 | FTDX | Futures | 1215.0 | 1215.0 | 1181.4 | 1187.9 | 644.0 |
| 2014-07-10 | FTI | Futures | 354.77 | 354.9 | 347.49 | 348.22 | 160.0 |
| 2014-07-10 | FTUK | Futures | 5138.1 | 5138.5 | 5073.1 | 5095.0 | 109592.0 |
| 2014-07-10 | FVSA | Futures | 1285.06 | 1435.49 | 1285.06 | 1388.21 | 29307.0 |
| 2014-07-10 | FXXP | Futures | 255.7 | 255.7 | 251.4 | 252.7 | 6357.0 |
| 2014-07-10 | G | Futures | 94.15 | 94.62 | 94.08 | 94.21 | 158059.0 |
| 2014-07-10 | GF | Futures | 327.554 | 329.776 | 322.765 | 322.765 | 5518.0 |
| 2014-07-10 | GSCI | Futures | 1064.74 | 1068.83 | 1063.23 | 1068.83 | 1167.0 |
| 2014-07-10 | HE | Futures | 136.424 | 136.87 | 133.407 | 134.273 | 23820.0 |
| 2014-07-10 | HG | Futures | 4.1586 | 4.188 | 4.1324 | 4.1759 | 43794.0 |
| 2014-07-10 | HH | Futures | 52.452 | 52.502 | 52.098 | 52.098 | 646.0 |
| 2014-07-10 | HO | Futures | 2.3033 | 2.3314 | 2.297 | 2.3206 | 27284.0 |
> showing 50 of 103 rows — these rows as CSV