PREVIEW / futures_daily / 2016-04-29
file: by_date/futures_daily/2016/2016-04-29.parquet size: 9 KB rows: 109
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-29 | ES | Futures | 2226.62 | 2229.04 | 2196.56 | 2210.78 | 2419757.0 |
| 2016-04-29 | NQ | Futures | 5150.64 | 5159.75 | 5048.71 | 5089.54 | 402426.0 |
| 2016-04-29 | YM | Futures | 18472.2 | 18496.2 | 18266.4 | 18396.3 | 207630.0 |
| 2016-04-29 | CL | Futures | 54.68 | 55.73 | 53.89 | 54.7 | 598439.0 |
| 2016-04-29 | GC | Futures | 1634.4 | 1674.3 | 1633.1 | 1663.4 | 273994.0 |
| 2016-04-29 | ZN | Futures | 125.570254 | 125.706038 | 125.193075 | 125.585341 | 1496779.0 |
| 2016-04-29 | A6 | Futures | 0.77051 | 0.77476 | 0.76656 | 0.76788 | 91838.0 |
| 2016-04-29 | AD | Futures | 0.8148 | 0.81838 | 0.81224 | 0.81531 | 85772.0 |
| 2016-04-29 | ALI | Futures | 2254.66 | 2254.66 | 2254.66 | 2254.66 | 0.0 |
| 2016-04-29 | B | Futures | 39.49 | 40.08 | 38.81 | 39.32 | 297848.0 |
| 2016-04-29 | B6 | Futures | 1.5384 | 1.5452 | 1.535 | 1.5387 | 107187.0 |
| 2016-04-29 | BFX | Futures | 4004.2 | 4004.2 | 3966.6 | 3966.6 | 10.0 |
| 2016-04-29 | BR | Futures | 0.18435 | 0.18783 | 0.18428 | 0.18718 | 4023.0 |
| 2016-04-29 | BZ | Futures | 39.38 | 39.95 | 38.7 | 39.19 | 27964.0 |
| 2016-04-29 | C | Futures | 2390.0 | 2441.0 | 2390.0 | 2440.0 | 23078.0 |
| 2016-04-29 | CB | Futures | 262.183 | 262.213 | 261.878 | 262.183 | 16.0 |
| 2016-04-29 | CC | Futures | 2341.0 | 2370.0 | 2337.0 | 2365.0 | 23107.0 |
| 2016-04-29 | CNH | Futures | 7.0517 | 7.0654 | 7.0492 | 7.0605 | 31.0 |
| 2016-04-29 | CSC | Futures | 3.52 | 3.52 | 3.482 | 3.484 | 32.0 |
| 2016-04-29 | CT | Futures | 72.45 | 72.99 | 71.83 | 72.54 | 12738.0 |
| 2016-04-29 | DC | Futures | 27.41 | 27.56 | 27.18 | 27.39 | 197.0 |
| 2016-04-29 | DX | Futures | 87.376 | 87.376 | 86.682 | 86.756 | 32882.0 |
| 2016-04-29 | E1 | Futures | 1.30195 | 1.31552 | 1.3012 | 1.31226 | 23842.0 |
| 2016-04-29 | E6 | Futures | 1.32549 | 1.33826 | 1.32514 | 1.3371 | 243008.0 |
| 2016-04-29 | E7 | Futures | 1.3182 | 1.3309 | 1.3182 | 1.3298 | 3813.0 |
| 2016-04-29 | EBM | Futures | 195.59 | 196.24 | 194.63 | 194.95 | 18673.0 |
| 2016-04-29 | ED | Futures | 95.7304 | 95.7352 | 95.7208 | 95.7304 | 110998.0 |
| 2016-04-29 | ER | Futures | 98.264 | 98.264 | 98.254 | 98.259 | 71379.0 |
| 2016-04-29 | EW | Futures | 1551.0 | 1553.2 | 1530.4 | 1541.5 | 18971.0 |
| 2016-04-29 | FBON | Futures | 117.86 | 117.93 | 117.46 | 117.79 | 860.0 |
| 2016-04-29 | FBTP | Futures | 106.04 | 106.21 | 105.74 | 105.97 | 91831.0 |
| 2016-04-29 | FBTS | Futures | 101.033 | 101.06 | 101.015 | 101.051 | 22607.0 |
| 2016-04-29 | FCE | Futures | 3776.2 | 3787.6 | 3710.7 | 3719.2 | 114831.0 |
| 2016-04-29 | FDAX | Futures | 10988.0 | 11045.5 | 10800.6 | 10833.9 | 129429.0 |
| 2016-04-29 | FDXM | Futures | 10575.4 | 10636.4 | 10400.6 | 10431.6 | 24228.0 |
| 2016-04-29 | FESX | Futures | 2361.0 | 2372.0 | 2314.2 | 2322.0 | 1859641.0 |
| 2016-04-29 | FGBL | Futures | 145.3 | 145.43 | 144.51 | 144.79 | 868168.0 |
| 2016-04-29 | FGBM | Futures | 127.43 | 127.47 | 127.13 | 127.19 | 625017.0 |
| 2016-04-29 | FGBS | Futures | 111.648 | 111.653 | 111.598 | 111.603 | 263595.0 |
| 2016-04-29 | FGBX | Futures | 169.23 | 169.91 | 167.56 | 168.49 | 52580.0 |
| 2016-04-29 | FMWO | Futures | 5671.3 | 5686.2 | 5626.5 | 5634.0 | 317.0 |
| 2016-04-29 | FOAT | Futures | 132.77 | 132.88 | 131.92 | 132.22 | 127910.0 |
| 2016-04-29 | FTDX | Futures | 1564.2 | 1564.2 | 1542.3 | 1547.1 | 151.0 |
| 2016-04-29 | FTI | Futures | 399.42 | 400.86 | 393.41 | 394.36 | 45660.0 |
| 2016-04-29 | FTUK | Futures | 5148.0 | 5157.9 | 5106.3 | 5126.6 | 143423.0 |
| 2016-04-29 | FVSA | Futures | 2434.56 | 2633.94 | 2424.06 | 2612.95 | 30097.0 |
| 2016-04-29 | FXXP | Futures | 273.9 | 274.8 | 270.5 | 271.5 | 23385.0 |
| 2016-04-29 | G | Futures | 107.4 | 107.46 | 106.99 | 107.22 | 212519.0 |
| 2016-04-29 | GF | Futures | 279.05 | 282.795 | 276.803 | 280.498 | 2655.0 |
| 2016-04-29 | GSCI | Futures | 531.91 | 532.42 | 527.28 | 528.82 | 336.0 |
> showing 50 of 109 rows — these rows as CSV