PREVIEW / futures_daily / 2015-07-15
file: by_date/futures_daily/2015/2015-07-15.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-15 | ES | Futures | 2228.27 | 2233.83 | 2220.32 | 2230.12 | 1147598.0 |
| 2015-07-15 | NQ | Futures | 5276.31 | 5299.95 | 5264.64 | 5296.45 | 187307.0 |
| 2015-07-15 | YM | Futures | 18446.3 | 18493.6 | 18407.3 | 18478.2 | 96843.0 |
| 2015-07-15 | CL | Futures | 89.44 | 89.56 | 85.64 | 85.99 | 174984.0 |
| 2015-07-15 | GC | Futures | 1507.0 | 1509.5 | 1491.3 | 1498.5 | 150648.0 |
| 2015-07-15 | ZN | Futures | 120.153746 | 120.556146 | 119.81096 | 120.511435 | 1039936.0 |
| 2015-07-15 | A6 | Futures | 0.73554 | 0.7393 | 0.72583 | 0.72762 | 97610.0 |
| 2015-07-15 | AD | Futures | 0.80226 | 0.80297 | 0.78845 | 0.79029 | 98913.0 |
| 2015-07-15 | ALI | Futures | 2293.08 | 2293.08 | 2293.08 | 2293.08 | 0.0 |
| 2015-07-15 | B | Futures | 54.72 | 54.88 | 52.97 | 53.15 | 274669.0 |
| 2015-07-15 | B6 | Futures | 1.6446 | 1.6492 | 1.6388 | 1.6443 | 77698.0 |
| 2015-07-15 | BFX | Futures | 4545.5 | 4583.0 | 4545.5 | 4578.7 | 187.0 |
| 2015-07-15 | BR | Futures | 0.1874 | 0.18821 | 0.18647 | 0.18803 | 2286.0 |
| 2015-07-15 | BZ | Futures | 54.72 | 54.82 | 52.95 | 53.12 | 36575.0 |
| 2015-07-15 | C | Futures | 2390.0 | 2403.0 | 2382.0 | 2385.0 | 14512.0 |
| 2015-07-15 | CB | Futures | 155.813 | 155.813 | 153.179 | 153.179 | 43.0 |
| 2015-07-15 | CC | Futures | 2474.0 | 2490.0 | 2460.0 | 2466.0 | 12059.0 |
| 2015-07-15 | CSC | Futures | 4.364 | 4.364 | 4.28 | 4.3 | 78.0 |
| 2015-07-15 | CT | Futures | 80.74 | 80.97 | 79.54 | 79.93 | 29.0 |
| 2015-07-15 | DC | Futures | 35.17 | 35.17 | 34.31 | 34.55 | 223.0 |
| 2015-07-15 | DX | Futures | 90.627 | 91.212 | 90.496 | 91.062 | 42315.0 |
| 2015-07-15 | E1 | Futures | 1.34586 | 1.34738 | 1.33253 | 1.33608 | 16054.0 |
| 2015-07-15 | E6 | Futures | 1.29438 | 1.29743 | 1.28498 | 1.28721 | 189823.0 |
| 2015-07-15 | E7 | Futures | 1.2869 | 1.2903 | 1.2779 | 1.2801 | 4543.0 |
| 2015-07-15 | EBM | Futures | 313.97 | 316.43 | 311.93 | 313.56 | 18626.0 |
| 2015-07-15 | ED | Futures | 95.6462 | 95.651 | 95.6366 | 95.6462 | 174471.0 |
| 2015-07-15 | ER | Futures | 98.112 | 98.112 | 98.102 | 98.107 | 22643.0 |
| 2015-07-15 | EW | Futures | 1591.8 | 1596.9 | 1580.3 | 1584.8 | 11674.0 |
| 2015-07-15 | FBTP | Futures | 98.64 | 99.52 | 98.64 | 99.24 | 66853.0 |
| 2015-07-15 | FBTS | Futures | 99.768 | 99.875 | 99.759 | 99.812 | 18227.0 |
| 2015-07-15 | FCE | Futures | 4201.6 | 4217.5 | 4181.2 | 4209.6 | 114875.0 |
| 2015-07-15 | FDAX | Futures | 12752.0 | 12792.4 | 12689.0 | 12772.5 | 64654.0 |
| 2015-07-15 | FESX | Futures | 2673.9 | 2688.7 | 2659.8 | 2683.5 | 911968.0 |
| 2015-07-15 | FGBL | Futures | 135.14 | 136.23 | 134.99 | 135.79 | 608202.0 |
| 2015-07-15 | FGBM | Futures | 124.02 | 124.29 | 123.98 | 124.17 | 414146.0 |
| 2015-07-15 | FGBS | Futures | 111.213 | 111.238 | 111.203 | 111.218 | 201122.0 |
| 2015-07-15 | FGBX | Futures | 149.55 | 152.54 | 149.25 | 151.68 | 26879.0 |
| 2015-07-15 | FMWO | Futures | 5860.6 | 5863.0 | 5860.6 | 5863.0 | 4.0 |
| 2015-07-15 | FOAT | Futures | 123.16 | 124.27 | 123.09 | 123.94 | 62240.0 |
| 2015-07-15 | FTDX | Futures | 1646.6 | 1670.1 | 1646.6 | 1667.8 | 299.0 |
| 2015-07-15 | FTI | Futures | 424.44 | 427.2 | 423.36 | 426.55 | 26692.0 |
| 2015-07-15 | FTUK | Futures | 5320.7 | 5345.7 | 5300.8 | 5329.8 | 66675.0 |
| 2015-07-15 | FVSA | Futures | 1842.26 | 1877.36 | 1833.49 | 1846.65 | 5776.0 |
| 2015-07-15 | FXXP | Futures | 305.9 | 307.3 | 304.2 | 306.9 | 11312.0 |
| 2015-07-15 | G | Futures | 100.41 | 100.9 | 100.41 | 100.58 | 161029.0 |
| 2015-07-15 | GF | Futures | 365.456 | 367.497 | 364.054 | 366.094 | 4685.0 |
| 2015-07-15 | GSCI | Futures | 690.48 | 690.48 | 678.4 | 678.4 | 100.0 |
| 2015-07-15 | HE | Futures | 84.783 | 85.341 | 83.694 | 84.113 | 15873.0 |
| 2015-07-15 | HG | Futures | 3.1668 | 3.2117 | 3.1212 | 3.1468 | 45242.0 |
| 2015-07-15 | HH | Futures | 34.307 | 35.372 | 34.307 | 35.312 | 2479.0 |
> showing 50 of 105 rows — these rows as CSV