PREVIEW / futures_daily / 2015-04-30
file: by_date/futures_daily/2015/2015-04-30.parquet size: 9 KB rows: 106
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-04-30 | ES | Futures | 2206.23 | 2210.17 | 2176.79 | 2185.99 | 2026329.0 |
| 2015-04-30 | NQ | Futures | 5194.46 | 5199.39 | 5092.87 | 5118.12 | 353283.0 |
| 2015-04-30 | YM | Futures | 18363.4 | 18390.0 | 18095.4 | 18165.0 | 205510.0 |
| 2015-04-30 | CL | Futures | 99.42 | 101.63 | 99.13 | 101.25 | 340322.0 |
| 2015-04-30 | GC | Futures | 1576.1 | 1579.9 | 1538.8 | 1547.2 | 212931.0 |
| 2015-04-30 | ZN | Futures | 121.716557 | 121.849759 | 121.06535 | 121.598156 | 1973329.0 |
| 2015-04-30 | A6 | Futures | 0.78682 | 0.78919 | 0.7736 | 0.77873 | 142834.0 |
| 2015-04-30 | AD | Futures | 0.84937 | 0.85059 | 0.84109 | 0.84426 | 74672.0 |
| 2015-04-30 | ALI | Futures | 2589.52 | 2589.52 | 2589.52 | 2589.52 | 0.0 |
| 2015-04-30 | B | Futures | 63.01 | 64.33 | 62.89 | 64.2 | 120188.0 |
| 2015-04-30 | B6 | Futures | 1.6237 | 1.6302 | 1.6104 | 1.6161 | 148154.0 |
| 2015-04-30 | BFX | Futures | 4435.1 | 4455.8 | 4407.7 | 4420.4 | 121.0 |
| 2015-04-30 | BR | Futures | 0.1911 | 0.1911 | 0.18597 | 0.18799 | 1370.0 |
| 2015-04-30 | BZ | Futures | 62.43 | 63.7 | 62.43 | 63.59 | 17561.0 |
| 2015-04-30 | C | Futures | 2151.0 | 2180.0 | 2147.0 | 2177.0 | 9040.0 |
| 2015-04-30 | CB | Futures | 154.142 | 154.547 | 152.119 | 152.929 | 71.0 |
| 2015-04-30 | CC | Futures | 2176.0 | 2185.0 | 2156.0 | 2171.0 | 17806.0 |
| 2015-04-30 | CNH | Futures | 7.0032 | 7.0033 | 6.9994 | 6.9999 | 33.0 |
| 2015-04-30 | CSC | Futures | 4.49 | 4.5 | 4.458 | 4.463 | 108.0 |
| 2015-04-30 | CT | Futures | 84.9 | 85.75 | 84.78 | 85.51 | 24585.0 |
| 2015-04-30 | DC | Futures | 36.71 | 37.13 | 36.62 | 36.71 | 428.0 |
| 2015-04-30 | DX | Futures | 89.489 | 89.709 | 88.705 | 88.934 | 83923.0 |
| 2015-04-30 | E1 | Futures | 1.35776 | 1.37152 | 1.351 | 1.37088 | 35183.0 |
| 2015-04-30 | E6 | Futures | 1.3081 | 1.32562 | 1.30258 | 1.3248 | 445064.0 |
| 2015-04-30 | E7 | Futures | 1.3004 | 1.3181 | 1.2952 | 1.3171 | 11349.0 |
| 2015-04-30 | EBM | Futures | 286.03 | 288.04 | 284.43 | 285.63 | 11557.0 |
| 2015-04-30 | ED | Futures | 95.5429 | 95.5525 | 95.5381 | 95.5429 | 227651.0 |
| 2015-04-30 | ER | Futures | 98.077 | 98.082 | 98.068 | 98.077 | 74049.0 |
| 2015-04-30 | EW | Futures | 1585.5 | 1587.8 | 1564.6 | 1569.4 | 23452.0 |
| 2015-04-30 | FBTP | Futures | 102.09 | 102.33 | 101.23 | 102.1 | 126021.0 |
| 2015-04-30 | FBTS | Futures | 99.643 | 99.697 | 99.528 | 99.688 | 24937.0 |
| 2015-04-30 | FCE | Futures | 4112.7 | 4136.1 | 4068.7 | 4122.1 | 158626.0 |
| 2015-04-30 | FDAX | Futures | 12732.2 | 12860.9 | 12595.7 | 12747.1 | 162902.0 |
| 2015-04-30 | FESX | Futures | 2624.7 | 2643.8 | 2594.5 | 2629.1 | 1500001.0 |
| 2015-04-30 | FGBL | Futures | 140.14 | 140.27 | 138.97 | 139.22 | 1231163.0 |
| 2015-04-30 | FGBM | Futures | 124.46 | 124.51 | 124.08 | 124.2 | 869146.0 |
| 2015-04-30 | FGBS | Futures | 111.223 | 111.238 | 111.183 | 111.203 | 422223.0 |
| 2015-04-30 | FGBX | Futures | 171.94 | 172.56 | 168.52 | 170.38 | 65311.0 |
| 2015-04-30 | FMWO | Futures | 5890.2 | 5905.0 | 5885.3 | 5891.5 | 1852.0 |
| 2015-04-30 | FOAT | Futures | 128.85 | 128.99 | 127.72 | 128.17 | 144819.0 |
| 2015-04-30 | FTDX | Futures | 1492.7 | 1518.0 | 1480.5 | 1509.1 | 395.0 |
| 2015-04-30 | FTI | Futures | 423.17 | 425.31 | 418.08 | 422.39 | 42239.0 |
| 2015-04-30 | FTUK | Futures | 5460.2 | 5481.8 | 5415.6 | 5462.1 | 131850.0 |
| 2015-04-30 | FVSA | Futures | 1792.51 | 1836.03 | 1764.81 | 1772.72 | 9195.0 |
| 2015-04-30 | FXXP | Futures | 302.2 | 302.6 | 298.6 | 301.3 | 21114.0 |
| 2015-04-30 | G | Futures | 103.13 | 103.3 | 102.5 | 102.84 | 264607.0 |
| 2015-04-30 | GF | Futures | 366.858 | 367.975 | 361.917 | 365.998 | 2794.0 |
| 2015-04-30 | GSCI | Futures | 758.08 | 759.02 | 750.17 | 757.57 | 460.0 |
| 2015-04-30 | HE | Futures | 88.514 | 89.959 | 88.224 | 89.005 | 892.0 |
| 2015-04-30 | HG | Futures | 3.505 | 3.6261 | 3.4981 | 3.6217 | 65826.0 |
> showing 50 of 106 rows — these rows as CSV