PREVIEW / futures_daily / 2016-04-28
file: by_date/futures_daily/2016/2016-04-28.parquet size: 9 KB rows: 111
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-04-28 | ES | Futures | 2246.75 | 2248.63 | 2217.5 | 2225.28 | 1938653.0 |
| 2016-04-28 | NQ | Futures | 5207.63 | 5219.68 | 5106.87 | 5148.88 | 306766.0 |
| 2016-04-28 | YM | Futures | 18690.6 | 18702.0 | 18420.3 | 18467.0 | 192719.0 |
| 2016-04-28 | CL | Futures | 53.96 | 54.97 | 53.54 | 54.83 | 487412.0 |
| 2016-04-28 | GC | Futures | 1607.7 | 1639.1 | 1597.1 | 1632.3 | 227214.0 |
| 2016-04-28 | ZN | Futures | 125.389208 | 125.690951 | 125.193075 | 125.479731 | 1477696.0 |
| 2016-04-28 | A6 | Futures | 0.76707 | 0.77375 | 0.76555 | 0.77142 | 105652.0 |
| 2016-04-28 | AD | Futures | 0.81183 | 0.81705 | 0.81102 | 0.81643 | 63024.0 |
| 2016-04-28 | ALI | Futures | 2245.94 | 2245.94 | 2245.94 | 2245.94 | 0.0 |
| 2016-04-28 | B | Futures | 38.9 | 39.69 | 38.61 | 39.65 | 274447.0 |
| 2016-04-28 | B6 | Futures | 1.5306 | 1.5401 | 1.5295 | 1.5385 | 83017.0 |
| 2016-04-28 | BFX | Futures | 4007.8 | 4034.2 | 3982.5 | 4034.2 | 8.0 |
| 2016-04-28 | BR | Futures | 0.18305 | 0.18497 | 0.18301 | 0.18474 | 8790.0 |
| 2016-04-28 | BZ | Futures | 38.77 | 39.56 | 38.5 | 39.52 | 18470.0 |
| 2016-04-28 | C | Futures | 2403.0 | 2408.0 | 2381.0 | 2393.0 | 5845.0 |
| 2016-04-28 | CB | Futures | 255.75 | 259.622 | 255.75 | 256.116 | 5.0 |
| 2016-04-28 | CC | Futures | 2331.0 | 2342.0 | 2314.0 | 2328.0 | 15598.0 |
| 2016-04-28 | CNH | Futures | 7.0673 | 7.0673 | 7.0539 | 7.0539 | 10.0 |
| 2016-04-28 | CSC | Futures | 3.513 | 3.518 | 3.498 | 3.518 | 27.0 |
| 2016-04-28 | CT | Futures | 73.05 | 73.05 | 72.0 | 72.45 | 12935.0 |
| 2016-04-28 | DC | Futures | 27.58 | 27.64 | 27.39 | 27.58 | 331.0 |
| 2016-04-28 | DX | Futures | 87.964 | 88.169 | 87.325 | 87.383 | 29787.0 |
| 2016-04-28 | E1 | Futures | 1.29592 | 1.30333 | 1.29316 | 1.3022 | 17918.0 |
| 2016-04-28 | E6 | Futures | 1.32234 | 1.32747 | 1.31902 | 1.32532 | 169940.0 |
| 2016-04-28 | E7 | Futures | 1.3153 | 1.3202 | 1.3119 | 1.3181 | 2969.0 |
| 2016-04-28 | EBM | Futures | 194.63 | 197.85 | 193.99 | 196.88 | 18262.0 |
| 2016-04-28 | ED | Futures | 95.7208 | 95.7304 | 95.716 | 95.7304 | 224516.0 |
| 2016-04-28 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.259 | 14806.0 |
| 2016-04-28 | EW | Futures | 1571.4 | 1574.2 | 1547.3 | 1550.8 | 14780.0 |
| 2016-04-28 | FBON | Futures | 117.75 | 117.98 | 117.52 | 117.97 | 338.0 |
| 2016-04-28 | FBTP | Futures | 105.84 | 106.32 | 105.84 | 106.24 | 117646.0 |
| 2016-04-28 | FBTS | Futures | 101.042 | 101.051 | 101.006 | 101.042 | 27003.0 |
| 2016-04-28 | FCE | Futures | 3802.1 | 3825.9 | 3760.4 | 3825.9 | 99372.0 |
| 2016-04-28 | FDAX | Futures | 11044.4 | 11133.0 | 10905.8 | 11109.9 | 120352.0 |
| 2016-04-28 | FDIV | Futures | 130.76 | 132.66 | 130.76 | 132.66 | 10.0 |
| 2016-04-28 | FDXM | Futures | 10637.5 | 10719.2 | 10503.0 | 10697.5 | 23245.0 |
| 2016-04-28 | FESX | Futures | 2379.0 | 2393.8 | 2345.4 | 2387.6 | 1411428.0 |
| 2016-04-28 | FEU3 | Futures | 98.917 | 98.917 | 98.917 | 98.917 | 5.0 |
| 2016-04-28 | FGBL | Futures | 145.15 | 145.6 | 145.08 | 145.22 | 829153.0 |
| 2016-04-28 | FGBM | Futures | 127.43 | 127.53 | 127.37 | 127.42 | 424892.0 |
| 2016-04-28 | FGBS | Futures | 111.668 | 111.678 | 111.643 | 111.648 | 184093.0 |
| 2016-04-28 | FGBX | Futures | 168.82 | 170.22 | 168.46 | 169.12 | 52768.0 |
| 2016-04-28 | FMWO | Futures | 5672.6 | 5733.5 | 5672.6 | 5727.3 | 125.0 |
| 2016-04-28 | FOAT | Futures | 132.61 | 133.01 | 132.54 | 132.69 | 115308.0 |
| 2016-04-28 | FTDX | Futures | 1575.7 | 1575.7 | 1553.3 | 1569.9 | 122.0 |
| 2016-04-28 | FTI | Futures | 399.42 | 404.57 | 396.44 | 404.03 | 40553.0 |
| 2016-04-28 | FTUK | Futures | 5185.6 | 5195.1 | 5100.1 | 5174.8 | 148531.0 |
| 2016-04-28 | FVSA | Futures | 2418.82 | 2518.51 | 2334.87 | 2355.85 | 22544.0 |
| 2016-04-28 | FXXP | Futures | 274.8 | 277.3 | 272.3 | 276.7 | 26366.0 |
| 2016-04-28 | G | Futures | 107.57 | 107.62 | 107.13 | 107.25 | 179582.0 |
> showing 50 of 111 rows — these rows as CSV