PREVIEW / futures_daily / 2013-11-29
file: by_date/futures_daily/2013/2013-11-29.parquet size: 9 KB rows: 100
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-11-29 | ES | Futures | 1853.63 | 1861.85 | 1851.83 | 1853.11 | 818602.0 |
| 2013-11-29 | NQ | Futures | 3984.24 | 4015.82 | 3983.95 | 4005.49 | 97742.0 |
| 2013-11-29 | YM | Futures | 15999.5 | 16081.1 | 15980.6 | 15985.6 | 69967.0 |
| 2013-11-29 | CL | Futures | 163.35 | 166.13 | 162.87 | 164.04 | 143205.0 |
| 2013-11-29 | GC | Futures | 1639.0 | 1661.0 | 1634.0 | 1655.6 | 113086.0 |
| 2013-11-29 | ZN | Futures | 114.810241 | 114.838564 | 114.626136 | 114.781917 | 240474.0 |
| 2013-11-29 | A6 | Futures | 0.85638 | 0.86327 | 0.8543 | 0.85874 | 96228.0 |
| 2013-11-29 | AD | Futures | 0.95308 | 0.95661 | 0.95025 | 0.95055 | 65000.0 |
| 2013-11-29 | B | Futures | 112.32 | 112.87 | 111.02 | 111.09 | 68648.0 |
| 2013-11-29 | B6 | Futures | 1.7095 | 1.7197 | 1.7083 | 1.7173 | 113600.0 |
| 2013-11-29 | BFX | Futures | 3473.9 | 3473.9 | 3469.1 | 3470.8 | 182.0 |
| 2013-11-29 | BR | Futures | 0.21723 | 0.21723 | 0.21723 | 0.21723 | 32.0 |
| 2013-11-29 | BZ | Futures | 114.58 | 114.81 | 112.95 | 113.02 | 3619.0 |
| 2013-11-29 | C | Futures | 1855.0 | 1865.0 | 1845.0 | 1855.0 | 4261.0 |
| 2013-11-29 | CC | Futures | 2060.0 | 2078.0 | 2057.0 | 2069.0 | 7435.0 |
| 2013-11-29 | CNH | Futures | 7.0213 | 7.0213 | 7.0151 | 7.0151 | 1.0 |
| 2013-11-29 | CT | Futures | 89.51 | 90.78 | 88.94 | 90.48 | 9245.0 |
| 2013-11-29 | DX | Futures | 76.762 | 76.886 | 76.695 | 76.85 | 9808.0 |
| 2013-11-29 | E1 | Futures | 1.41616 | 1.42349 | 1.41436 | 1.41719 | 33976.0 |
| 2013-11-29 | E6 | Futures | 1.60224 | 1.60767 | 1.6007 | 1.60342 | 184088.0 |
| 2013-11-29 | E7 | Futures | 1.5919 | 1.5972 | 1.5904 | 1.5931 | 2900.0 |
| 2013-11-29 | ED | Futures | 95.3686 | 95.371 | 95.3662 | 95.371 | 50612.0 |
| 2013-11-29 | ER | Futures | 97.871 | 97.876 | 97.867 | 97.871 | 40048.0 |
| 2013-11-29 | EW | Futures | 1334.6 | 1337.9 | 1327.3 | 1328.7 | 12802.0 |
| 2013-11-29 | FBTP | Futures | 82.04 | 82.22 | 81.96 | 82.08 | 24615.0 |
| 2013-11-29 | FBTS | Futures | 95.658 | 95.684 | 95.572 | 95.624 | 6736.0 |
| 2013-11-29 | FCE | Futures | 3332.3 | 3342.8 | 3324.5 | 3330.0 | 48053.0 |
| 2013-11-29 | FDAX | Futures | 10413.7 | 10462.0 | 10411.0 | 10443.1 | 51115.0 |
| 2013-11-29 | FESX | Futures | 2165.9 | 2172.2 | 2158.2 | 2163.8 | 390233.0 |
| 2013-11-29 | FGBL | Futures | 120.65 | 120.81 | 120.5 | 120.67 | 516110.0 |
| 2013-11-29 | FGBM | Futures | 118.53 | 118.57 | 118.39 | 118.52 | 336908.0 |
| 2013-11-29 | FGBS | Futures | 110.583 | 110.598 | 110.558 | 110.588 | 191389.0 |
| 2013-11-29 | FGBX | Futures | 121.59 | 122.17 | 121.18 | 121.71 | 18865.0 |
| 2013-11-29 | FMWO | Futures | 5377.5 | 5377.5 | 5377.5 | 5377.5 | 0.0 |
| 2013-11-29 | FOAT | Futures | 108.93 | 109.06 | 108.75 | 109.0 | 41738.0 |
| 2013-11-29 | FTDX | Futures | 1085.0 | 1091.6 | 1084.1 | 1087.8 | 65.0 |
| 2013-11-29 | FTI | Futures | 341.9 | 342.85 | 341.6 | 342.21 | 11479.0 |
| 2013-11-29 | FTUK | Futures | 4989.1 | 5011.9 | 4976.7 | 4988.7 | 67492.0 |
| 2013-11-29 | FVSA | Futures | 1881.88 | 1912.14 | 1845.57 | 1906.09 | 6488.0 |
| 2013-11-29 | FXXP | Futures | 236.9 | 237.8 | 236.4 | 237.4 | 4772.0 |
| 2013-11-29 | G | Futures | 92.42 | 92.42 | 91.98 | 92.17 | 127851.0 |
| 2013-11-29 | GF | Futures | 266.517 | 266.758 | 266.074 | 266.396 | 1812.0 |
| 2013-11-29 | GSCI | Futures | 1030.76 | 1036.14 | 1030.76 | 1034.9 | 134.0 |
| 2013-11-29 | HE | Futures | 109.268 | 109.691 | 108.483 | 109.389 | 8230.0 |
| 2013-11-29 | HG | Futures | 4.0391 | 4.0739 | 4.0227 | 4.048 | 55687.0 |
| 2013-11-29 | HH | Futures | 39.27 | 39.64 | 38.969 | 39.61 | 5855.0 |
| 2013-11-29 | HO | Futures | 2.4293 | 2.4464 | 2.4163 | 2.4166 | 3696.0 |
| 2013-11-29 | HRC | Futures | 2388.8 | 2388.8 | 2388.8 | 2388.8 | 0.0 |
| 2013-11-29 | J1 | Futures | 0.0123111 | 0.0123451 | 0.0122633 | 0.0122822 | 108364.0 |
| 2013-11-29 | J7 | Futures | 0.012295 | 0.012334 | 0.012253 | 0.012271 | 498.0 |
> showing 50 of 100 rows — these rows as CSV