PREVIEW / futures_daily / 2015-04-07
file: by_date/futures_daily/2015/2015-04-07.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 |
|---|---|---|---|---|---|---|---|
| 2015-04-07 | ES | Futures | 2178.1 | 2189.93 | 2172.32 | 2174.16 | 1048474.0 |
| 2015-04-07 | NQ | Futures | 5038.59 | 5076.32 | 5027.56 | 5031.91 | 171692.0 |
| 2015-04-07 | YM | Futures | 18199.7 | 18310.2 | 18180.3 | 18191.6 | 110106.0 |
| 2015-04-07 | CL | Futures | 91.49 | 95.33 | 90.12 | 95.07 | 548870.0 |
| 2015-04-07 | GC | Futures | 1589.4 | 1591.0 | 1580.0 | 1584.1 | 85860.0 |
| 2015-04-07 | ZN | Futures | 122.604567 | 122.663768 | 122.308564 | 122.530566 | 806436.0 |
| 2015-04-07 | A6 | Futures | 0.74688 | 0.75743 | 0.74441 | 0.75003 | 112064.0 |
| 2015-04-07 | AD | Futures | 0.81761 | 0.81904 | 0.81465 | 0.81649 | 49469.0 |
| 2015-04-07 | ALI | Futures | 2627.08 | 2627.08 | 2627.08 | 2627.08 | 0.0 |
| 2015-04-07 | B | Futures | 57.22 | 58.2 | 56.13 | 58.05 | 222597.0 |
| 2015-04-07 | B6 | Futures | 1.5665 | 1.5697 | 1.5574 | 1.5601 | 78254.0 |
| 2015-04-07 | BFX | Futures | 4582.1 | 4633.4 | 4582.1 | 4633.4 | 1.0 |
| 2015-04-07 | BR | Futures | 0.18254 | 0.18254 | 0.17884 | 0.17964 | 31.0 |
| 2015-04-07 | BZ | Futures | 56.15 | 57.67 | 55.66 | 57.54 | 24003.0 |
| 2015-04-07 | C | Futures | 2129.0 | 2131.0 | 2119.0 | 2122.0 | 7090.0 |
| 2015-04-07 | CC | Futures | 2052.0 | 2066.0 | 2047.0 | 2049.0 | 15047.0 |
| 2015-04-07 | CNH | Futures | 7.0151 | 7.0194 | 7.0151 | 7.0186 | 8.0 |
| 2015-04-07 | CSC | Futures | 4.3 | 4.378 | 4.3 | 4.362 | 32.0 |
| 2015-04-07 | CT | Futures | 83.75 | 85.44 | 83.53 | 85.13 | 23277.0 |
| 2015-04-07 | DC | Futures | 34.95 | 35.76 | 34.95 | 35.61 | 141.0 |
| 2015-04-07 | DX | Futures | 91.315 | 92.259 | 91.183 | 92.072 | 39778.0 |
| 2015-04-07 | E1 | Futures | 1.33392 | 1.33711 | 1.32105 | 1.32322 | 16583.0 |
| 2015-04-07 | E6 | Futures | 1.2867 | 1.28941 | 1.27153 | 1.27459 | 223168.0 |
| 2015-04-07 | E7 | Futures | 1.2795 | 1.2818 | 1.2642 | 1.2672 | 5599.0 |
| 2015-04-07 | EBM | Futures | 306.09 | 308.9 | 305.29 | 307.29 | 14873.0 |
| 2015-04-07 | ED | Futures | 95.5429 | 95.5477 | 95.5333 | 95.5381 | 116034.0 |
| 2015-04-07 | ER | Futures | 98.048 | 98.058 | 98.048 | 98.053 | 29752.0 |
| 2015-04-07 | EW | Futures | 1605.4 | 1610.2 | 1592.2 | 1593.2 | 16395.0 |
| 2015-04-07 | FBTP | Futures | 103.79 | 104.18 | 103.71 | 104.13 | 54086.0 |
| 2015-04-07 | FBTS | Futures | 99.661 | 99.714 | 99.652 | 99.688 | 10368.0 |
| 2015-04-07 | FCE | Futures | 4150.9 | 4203.0 | 4143.6 | 4187.9 | 100742.0 |
| 2015-04-07 | FDAX | Futures | 13403.4 | 13510.5 | 13381.8 | 13464.4 | 89964.0 |
| 2015-04-07 | FESX | Futures | 2708.7 | 2735.2 | 2699.1 | 2724.2 | 841594.0 |
| 2015-04-07 | FGBL | Futures | 141.13 | 141.17 | 140.93 | 141.05 | 284953.0 |
| 2015-04-07 | FGBM | Futures | 124.81 | 124.86 | 124.78 | 124.83 | 170388.0 |
| 2015-04-07 | FGBS | Futures | 111.268 | 111.288 | 111.263 | 111.288 | 98503.0 |
| 2015-04-07 | FGBX | Futures | 176.97 | 177.21 | 175.98 | 176.22 | 22001.0 |
| 2015-04-07 | FMWO | Futures | 5822.4 | 5839.7 | 5822.4 | 5829.8 | 732.0 |
| 2015-04-07 | FOAT | Futures | 129.79 | 129.89 | 129.7 | 129.75 | 40345.0 |
| 2015-04-07 | FTDX | Futures | 1523.2 | 1534.5 | 1523.2 | 1530.2 | 188.0 |
| 2015-04-07 | FTI | Futures | 429.38 | 436.01 | 429.21 | 434.79 | 32176.0 |
| 2015-04-07 | FTUK | Futures | 5362.0 | 5449.1 | 5356.5 | 5435.3 | 95670.0 |
| 2015-04-07 | FVSA | Futures | 1766.0 | 1766.0 | 1698.24 | 1706.71 | 13900.0 |
| 2015-04-07 | FXXP | Futures | 303.3 | 306.8 | 303.2 | 305.7 | 11971.0 |
| 2015-04-07 | G | Futures | 105.16 | 105.16 | 104.6 | 104.87 | 100901.0 |
| 2015-04-07 | GF | Futures | 372.164 | 372.206 | 366.778 | 369.28 | 2182.0 |
| 2015-04-07 | GSCI | Futures | 708.08 | 721.09 | 705.84 | 720.74 | 695.0 |
| 2015-04-07 | HE | Futures | 80.041 | 80.33 | 79.347 | 79.81 | 217.0 |
| 2015-04-07 | HG | Futures | 3.4514 | 3.5283 | 3.4457 | 3.5105 | 42429.0 |
| 2015-04-07 | HH | Futures | 32.805 | 33.373 | 32.707 | 33.064 | 2695.0 |
> showing 50 of 105 rows — these rows as CSV