PREVIEW / futures_daily / 2014-04-29
file: by_date/futures_daily/2014/2014-04-29.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 |
|---|---|---|---|---|---|---|---|
| 2014-04-29 | ES | Futures | 1930.63 | 1940.2 | 1929.6 | 1936.58 | 1219110.0 |
| 2014-04-29 | NQ | Futures | 4076.64 | 4110.88 | 4063.4 | 4102.25 | 306700.0 |
| 2014-04-29 | YM | Futures | 16465.2 | 16560.6 | 16457.2 | 16534.5 | 124193.0 |
| 2014-04-29 | CL | Futures | 182.74 | 185.11 | 182.41 | 183.45 | 218691.0 |
| 2014-04-29 | GC | Futures | 1707.6 | 1715.5 | 1694.6 | 1708.0 | 103817.0 |
| 2014-04-29 | ZN | Futures | 114.881272 | 115.026141 | 114.678455 | 114.968194 | 1129567.0 |
| 2014-04-29 | A6 | Futures | 0.88665 | 0.88886 | 0.88367 | 0.88809 | 58118.0 |
| 2014-04-29 | AD | Futures | 0.91836 | 0.92566 | 0.91836 | 0.92444 | 62331.0 |
| 2014-04-29 | B | Futures | 111.41 | 112.62 | 111.35 | 112.26 | 123253.0 |
| 2014-04-29 | B6 | Futures | 1.7659 | 1.77 | 1.7643 | 1.7683 | 76977.0 |
| 2014-04-29 | BFX | Futures | 3725.4 | 3725.5 | 3712.9 | 3725.5 | 70.0 |
| 2014-04-29 | BR | Futures | 0.23444 | 0.23616 | 0.23365 | 0.23405 | 130.0 |
| 2014-04-29 | BZ | Futures | 113.76 | 114.85 | 113.76 | 114.49 | 9193.0 |
| 2014-04-29 | C | Futures | 1926.0 | 1934.0 | 1917.0 | 1920.0 | 6063.0 |
| 2014-04-29 | CB | Futures | 96.728 | 97.477 | 96.728 | 97.477 | 4.0 |
| 2014-04-29 | CC | Futures | 2177.0 | 2185.0 | 2172.0 | 2176.0 | 5623.0 |
| 2014-04-29 | CNH | Futures | 7.1776 | 7.1823 | 7.1776 | 7.1823 | 35.0 |
| 2014-04-29 | CSC | Futures | 4.433 | 4.477 | 4.433 | 4.477 | 19.0 |
| 2014-04-29 | CT | Futures | 104.0 | 106.17 | 103.57 | 105.91 | 18540.0 |
| 2014-04-29 | DC | Futures | 35.77 | 36.19 | 35.56 | 36.14 | 188.0 |
| 2014-04-29 | DX | Futures | 75.774 | 75.926 | 75.679 | 75.889 | 10324.0 |
| 2014-04-29 | E1 | Futures | 1.45856 | 1.46125 | 1.45124 | 1.45291 | 26846.0 |
| 2014-04-29 | E6 | Futures | 1.63481 | 1.63824 | 1.62962 | 1.63021 | 179268.0 |
| 2014-04-29 | E7 | Futures | 1.6238 | 1.6273 | 1.6188 | 1.6193 | 2993.0 |
| 2014-04-29 | EBM | Futures | 303.33 | 304.03 | 301.21 | 302.62 | 9556.0 |
| 2014-04-29 | ED | Futures | 95.4091 | 95.4138 | 95.4091 | 95.4091 | 50388.0 |
| 2014-04-29 | ER | Futures | 97.817 | 97.852 | 97.813 | 97.837 | 201530.0 |
| 2014-04-29 | EW | Futures | 1385.6 | 1392.9 | 1383.7 | 1388.1 | 18232.0 |
| 2014-04-29 | FBTP | Futures | 88.46 | 88.71 | 88.22 | 88.62 | 81879.0 |
| 2014-04-29 | FBTS | Futures | 97.372 | 97.451 | 97.328 | 97.399 | 15769.0 |
| 2014-04-29 | FCE | Futures | 3503.6 | 3533.7 | 3489.7 | 3527.4 | 109121.0 |
| 2014-04-29 | FDAX | Futures | 10501.4 | 10635.1 | 10485.4 | 10606.9 | 109359.0 |
| 2014-04-29 | FESX | Futures | 2239.8 | 2268.6 | 2236.3 | 2263.6 | 886450.0 |
| 2014-04-29 | FEU3 | Futures | 98.453 | 98.458 | 98.453 | 98.458 | 6.0 |
| 2014-04-29 | FGBL | Futures | 124.42 | 124.52 | 124.09 | 124.48 | 690828.0 |
| 2014-04-29 | FGBM | Futures | 119.78 | 120.01 | 119.63 | 119.94 | 488541.0 |
| 2014-04-29 | FGBS | Futures | 110.498 | 110.578 | 110.463 | 110.553 | 391183.0 |
| 2014-04-29 | FGBX | Futures | 128.72 | 128.72 | 128.09 | 128.64 | 21000.0 |
| 2014-04-29 | FMWO | Futures | 5572.1 | 5574.6 | 5569.6 | 5574.6 | 68.0 |
| 2014-04-29 | FOAT | Futures | 113.65 | 113.7 | 113.32 | 113.65 | 60002.0 |
| 2014-04-29 | FTDX | Futures | 1140.0 | 1148.4 | 1140.0 | 1145.2 | 193.0 |
| 2014-04-29 | FTI | Futures | 337.5 | 341.26 | 336.94 | 340.91 | 30757.0 |
| 2014-04-29 | FTUK | Futures | 5087.1 | 5133.6 | 5080.6 | 5121.0 | 110447.0 |
| 2014-04-29 | FVSA | Futures | 1785.07 | 1794.6 | 1751.75 | 1761.27 | 5186.0 |
| 2014-04-29 | FXXP | Futures | 248.8 | 251.5 | 248.7 | 251.0 | 8711.0 |
| 2014-04-29 | G | Futures | 93.96 | 94.02 | 93.72 | 93.92 | 188968.0 |
| 2014-04-29 | GF | Futures | 288.627 | 288.747 | 286.877 | 287.394 | 1992.0 |
| 2014-04-29 | GSCI | Futures | 1088.45 | 1092.93 | 1088.45 | 1091.35 | 252.0 |
| 2014-04-29 | HE | Futures | 140.738 | 141.147 | 138.522 | 140.301 | 568.0 |
| 2014-04-29 | HG | Futures | 3.9528 | 3.9592 | 3.9183 | 3.9266 | 40097.0 |
> showing 50 of 105 rows — these rows as CSV