PREVIEW / futures_daily / 2016-03-21
file: by_date/futures_daily/2016/2016-03-21.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-21 | ES | Futures | 2186.63 | 2195.22 | 2180.72 | 2193.34 | 1278261.0 |
| 2016-03-21 | NQ | Futures | 5163.86 | 5195.0 | 5142.71 | 5189.13 | 169724.0 |
| 2016-03-21 | YM | Futures | 18185.3 | 18249.7 | 18134.3 | 18224.8 | 102160.0 |
| 2016-03-21 | CL | Futures | 49.85 | 50.74 | 49.05 | 50.4 | 479337.0 |
| 2016-03-21 | GC | Futures | 1612.8 | 1614.8 | 1594.8 | 1598.7 | 176624.0 |
| 2016-03-21 | ZN | Futures | 124.936594 | 125.012029 | 124.559415 | 124.574502 | 780943.0 |
| 2016-03-21 | A6 | Futures | 0.76585 | 0.76889 | 0.76302 | 0.76585 | 64359.0 |
| 2016-03-21 | AD | Futures | 0.78525 | 0.78535 | 0.78044 | 0.78269 | 46752.0 |
| 2016-03-21 | ALI | Futures | 2093.08 | 2093.08 | 2090.5 | 2093.08 | 34.0 |
| 2016-03-21 | B | Futures | 34.4 | 34.88 | 33.71 | 34.6 | 234102.0 |
| 2016-03-21 | B6 | Futures | 1.5229 | 1.5239 | 1.5129 | 1.5159 | 60202.0 |
| 2016-03-21 | BFX | Futures | 3995.0 | 4003.2 | 3995.0 | 4003.2 | 4.0 |
| 2016-03-21 | BR | Futures | 0.17774 | 0.17833 | 0.17566 | 0.17735 | 45.0 |
| 2016-03-21 | BZ | Futures | 33.96 | 34.52 | 33.38 | 34.25 | 24893.0 |
| 2016-03-21 | C | Futures | 2380.0 | 2393.0 | 2351.0 | 2361.0 | 6548.0 |
| 2016-03-21 | CB | Futures | 248.067 | 248.067 | 248.067 | 248.067 | 1.0 |
| 2016-03-21 | CC | Futures | 2280.0 | 2288.0 | 2240.0 | 2249.0 | 12954.0 |
| 2016-03-21 | CNH | Futures | 7.0679 | 7.074 | 7.0678 | 7.074 | 11.0 |
| 2016-03-21 | CSC | Futures | 3.57 | 3.611 | 3.57 | 3.592 | 26.0 |
| 2016-03-21 | CT | Futures | 65.58 | 67.28 | 65.53 | 66.81 | 14889.0 |
| 2016-03-21 | DC | Futures | 28.11 | 28.38 | 28.07 | 28.34 | 304.0 |
| 2016-03-21 | DX | Futures | 88.663 | 88.952 | 88.589 | 88.853 | 12491.0 |
| 2016-03-21 | E1 | Futures | 1.3007 | 1.30321 | 1.2958 | 1.3007 | 13353.0 |
| 2016-03-21 | E6 | Futures | 1.31756 | 1.31937 | 1.31342 | 1.31552 | 118079.0 |
| 2016-03-21 | E7 | Futures | 1.3105 | 1.3122 | 1.3064 | 1.3084 | 1681.0 |
| 2016-03-21 | EBM | Futures | 196.88 | 197.52 | 196.24 | 197.2 | 16729.0 |
| 2016-03-21 | ED | Futures | 95.6726 | 95.6774 | 95.6485 | 95.6485 | 187747.0 |
| 2016-03-21 | ER | Futures | 98.254 | 98.259 | 98.249 | 98.259 | 41422.0 |
| 2016-03-21 | EW | Futures | 1504.0 | 1510.4 | 1499.6 | 1506.8 | 10921.0 |
| 2016-03-21 | FBON | Futures | 118.39 | 118.55 | 118.14 | 118.37 | 154.0 |
| 2016-03-21 | FBTP | Futures | 107.41 | 107.79 | 107.41 | 107.63 | 61617.0 |
| 2016-03-21 | FBTS | Futures | 101.015 | 101.051 | 101.006 | 101.042 | 12199.0 |
| 2016-03-21 | FCE | Futures | 3697.2 | 3732.2 | 3675.1 | 3685.9 | 71687.0 |
| 2016-03-21 | FDAX | Futures | 10690.5 | 10884.9 | 10627.1 | 10718.9 | 93651.0 |
| 2016-03-21 | FDXM | Futures | 10295.1 | 10480.2 | 10234.1 | 10322.0 | 21584.0 |
| 2016-03-21 | FESX | Futures | 2316.6 | 2349.3 | 2302.5 | 2315.8 | 1010453.0 |
| 2016-03-21 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 41.0 |
| 2016-03-21 | FGBL | Futures | 145.43 | 145.79 | 145.07 | 145.27 | 546618.0 |
| 2016-03-21 | FGBM | Futures | 127.23 | 127.39 | 127.17 | 127.24 | 418916.0 |
| 2016-03-21 | FGBS | Futures | 111.613 | 111.638 | 111.603 | 111.618 | 136825.0 |
| 2016-03-21 | FGBX | Futures | 171.35 | 172.55 | 170.2 | 170.46 | 34013.0 |
| 2016-03-21 | FMWO | Futures | 5532.0 | 5566.9 | 5532.0 | 5554.4 | 313.0 |
| 2016-03-21 | FOAT | Futures | 133.03 | 133.44 | 132.79 | 132.96 | 54854.0 |
| 2016-03-21 | FTDX | Futures | 1528.5 | 1544.2 | 1517.1 | 1520.4 | 346.0 |
| 2016-03-21 | FTI | Futures | 392.33 | 395.84 | 390.38 | 392.91 | 27567.0 |
| 2016-03-21 | FTUK | Futures | 5046.5 | 5078.3 | 5025.5 | 5051.0 | 80332.0 |
| 2016-03-21 | FVSA | Futures | 2710.99 | 2749.64 | 2584.0 | 2699.95 | 21909.0 |
| 2016-03-21 | FXXP | Futures | 268.0 | 271.0 | 266.8 | 268.4 | 18679.0 |
| 2016-03-21 | G | Futures | 108.22 | 108.42 | 107.97 | 108.06 | 114807.0 |
| 2016-03-21 | GF | Futures | 316.765 | 316.765 | 309.6 | 310.14 | 4318.0 |
> showing 50 of 110 rows — these rows as CSV