PREVIEW / futures_daily / 2015-04-16
file: by_date/futures_daily/2015/2015-04-16.parquet size: 9 KB rows: 108
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-16 | ES | Futures | 2209.65 | 2213.07 | 2196.51 | 2208.86 | 1113607.0 |
| 2015-04-16 | NQ | Futures | 5139.02 | 5142.79 | 5106.22 | 5126.25 | 162971.0 |
| 2015-04-16 | YM | Futures | 18453.4 | 18506.6 | 18358.3 | 18453.4 | 127422.0 |
| 2015-04-16 | CL | Futures | 97.11 | 99.88 | 96.04 | 98.67 | 269515.0 |
| 2015-04-16 | GC | Futures | 1572.5 | 1581.7 | 1562.7 | 1567.6 | 157415.0 |
| 2015-04-16 | ZN | Futures | 122.663768 | 122.900571 | 122.441765 | 122.84137 | 1169425.0 |
| 2015-04-16 | A6 | Futures | 0.75447 | 0.76887 | 0.75418 | 0.76808 | 141084.0 |
| 2015-04-16 | AD | Futures | 0.83007 | 0.84028 | 0.82762 | 0.83824 | 112646.0 |
| 2015-04-16 | ALI | Futures | 2545.48 | 2545.48 | 2545.48 | 2545.48 | 0.0 |
| 2015-04-16 | B | Futures | 60.69 | 62.67 | 59.82 | 61.73 | 293485.0 |
| 2015-04-16 | B6 | Futures | 1.5605 | 1.5751 | 1.5586 | 1.5737 | 94179.0 |
| 2015-04-16 | BFX | Futures | 4626.4 | 4660.5 | 4625.8 | 4625.8 | 169.0 |
| 2015-04-16 | BR | Futures | 0.18705 | 0.18745 | 0.18523 | 0.18682 | 176.0 |
| 2015-04-16 | BZ | Futures | 60.14 | 62.02 | 59.28 | 61.19 | 26829.0 |
| 2015-04-16 | C | Futures | 2130.0 | 2159.0 | 2130.0 | 2146.0 | 3793.0 |
| 2015-04-16 | CB | Futures | 149.692 | 152.119 | 149.692 | 149.692 | 4.0 |
| 2015-04-16 | CC | Futures | 2102.0 | 2130.0 | 2102.0 | 2120.0 | 21739.0 |
| 2015-04-16 | CNH | Futures | 7.0033 | 7.0033 | 6.9914 | 6.9914 | 12.0 |
| 2015-04-16 | CSC | Futures | 4.292 | 4.335 | 4.287 | 4.327 | 42.0 |
| 2015-04-16 | CT | Futures | 82.95 | 83.22 | 81.35 | 82.04 | 13368.0 |
| 2015-04-16 | DC | Futures | 34.98 | 35.49 | 34.93 | 35.47 | 244.0 |
| 2015-04-16 | DX | Futures | 92.564 | 92.888 | 91.521 | 91.657 | 71192.0 |
| 2015-04-16 | E1 | Futures | 1.32194 | 1.33889 | 1.31506 | 1.33813 | 24558.0 |
| 2015-04-16 | E6 | Futures | 1.25683 | 1.27306 | 1.25036 | 1.27071 | 351843.0 |
| 2015-04-16 | E7 | Futures | 1.2492 | 1.2657 | 1.2431 | 1.2634 | 9122.0 |
| 2015-04-16 | EBM | Futures | 296.86 | 297.67 | 293.25 | 294.06 | 28873.0 |
| 2015-04-16 | ED | Futures | 95.5429 | 95.5477 | 95.5429 | 95.5477 | 75881.0 |
| 2015-04-16 | ER | Futures | 98.077 | 98.082 | 98.068 | 98.073 | 49668.0 |
| 2015-04-16 | EW | Futures | 1610.2 | 1612.2 | 1599.6 | 1606.5 | 12621.0 |
| 2015-04-16 | FBTP | Futures | 103.9 | 103.98 | 102.96 | 103.02 | 137610.0 |
| 2015-04-16 | FBTS | Futures | 99.714 | 99.714 | 99.581 | 99.599 | 26843.0 |
| 2015-04-16 | FCE | Futures | 4270.1 | 4273.4 | 4236.4 | 4246.3 | 99958.0 |
| 2015-04-16 | FDAX | Futures | 13614.7 | 13626.4 | 13310.8 | 13352.4 | 118984.0 |
| 2015-04-16 | FDIV | Futures | 166.25 | 166.25 | 165.93 | 165.93 | 5.0 |
| 2015-04-16 | FESX | Futures | 2750.7 | 2753.6 | 2709.4 | 2716.1 | 1206046.0 |
| 2015-04-16 | FEU3 | Futures | 98.724 | 98.724 | 98.715 | 98.715 | 756.0 |
| 2015-04-16 | FGBL | Futures | 142.08 | 142.5 | 142.06 | 142.31 | 609389.0 |
| 2015-04-16 | FGBM | Futures | 125.01 | 125.09 | 125.01 | 125.03 | 332890.0 |
| 2015-04-16 | FGBS | Futures | 111.303 | 111.323 | 111.298 | 111.318 | 141088.0 |
| 2015-04-16 | FGBX | Futures | 180.38 | 181.82 | 180.12 | 181.33 | 34568.0 |
| 2015-04-16 | FMWO | Futures | 5887.8 | 5890.2 | 5882.8 | 5890.2 | 83.0 |
| 2015-04-16 | FOAT | Futures | 131.02 | 131.26 | 130.85 | 130.97 | 95207.0 |
| 2015-04-16 | FTDX | Futures | 1580.9 | 1580.9 | 1553.7 | 1556.5 | 266.0 |
| 2015-04-16 | FTI | Futures | 436.76 | 439.02 | 433.62 | 434.54 | 14829.0 |
| 2015-04-16 | FTUK | Futures | 5565.0 | 5582.4 | 5520.1 | 5536.6 | 94128.0 |
| 2015-04-16 | FVSA | Futures | 1586.74 | 1646.1 | 1586.74 | 1638.18 | 8018.0 |
| 2015-04-16 | FXXP | Futures | 314.6 | 314.6 | 310.8 | 311.7 | 12330.0 |
| 2015-04-16 | G | Futures | 105.12 | 105.32 | 104.7 | 104.82 | 175151.0 |
| 2015-04-16 | GF | Futures | 365.483 | 367.889 | 363.678 | 366.041 | 3029.0 |
| 2015-04-16 | GSCI | Futures | 729.83 | 745.23 | 728.12 | 739.36 | 144.0 |
> showing 50 of 108 rows — these rows as CSV