PREVIEW / futures_daily / 2015-06-24
file: by_date/futures_daily/2015/2015-06-24.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-06-24 | ES | Futures | 2244.16 | 2245.22 | 2224.56 | 2225.09 | 1163124.0 |
| 2015-06-24 | NQ | Futures | 5304.62 | 5318.34 | 5270.76 | 5272.22 | 165445.0 |
| 2015-06-24 | YM | Futures | 18562.4 | 18568.5 | 18361.1 | 18366.2 | 123673.0 |
| 2015-06-24 | CL | Futures | 102.12 | 102.84 | 99.88 | 100.66 | 312985.0 |
| 2015-06-24 | GC | Futures | 1537.9 | 1540.7 | 1525.5 | 1531.8 | 118451.0 |
| 2015-06-24 | ZN | Futures | 119.661923 | 119.974901 | 119.542693 | 119.93019 | 1151466.0 |
| 2015-06-24 | A6 | Futures | 0.76248 | 0.76634 | 0.75753 | 0.7602 | 69637.0 |
| 2015-06-24 | AD | Futures | 0.82802 | 0.83191 | 0.82199 | 0.82414 | 66686.0 |
| 2015-06-24 | ALI | Futures | 2351.52 | 2351.52 | 2351.52 | 2351.52 | 0.0 |
| 2015-06-24 | B | Futures | 60.83 | 61.2 | 59.28 | 59.73 | 256385.0 |
| 2015-06-24 | B6 | Futures | 1.6545 | 1.6623 | 1.6481 | 1.6517 | 78728.0 |
| 2015-06-24 | BR | Futures | 0.19007 | 0.19007 | 0.18893 | 0.18893 | 560.0 |
| 2015-06-24 | BZ | Futures | 60.97 | 61.33 | 59.41 | 59.85 | 25722.0 |
| 2015-06-24 | C | Futures | 2292.0 | 2323.0 | 2290.0 | 2319.0 | 2750.0 |
| 2015-06-24 | CB | Futures | 156.826 | 156.826 | 155.61 | 155.691 | 51.0 |
| 2015-06-24 | CC | Futures | 2388.0 | 2418.0 | 2380.0 | 2413.0 | 10946.0 |
| 2015-06-24 | CSC | Futures | 4.47 | 4.508 | 4.47 | 4.508 | 47.0 |
| 2015-06-24 | CT | Futures | 80.09 | 80.24 | 79.25 | 79.35 | 20.0 |
| 2015-06-24 | DC | Futures | 36.07 | 36.4 | 35.88 | 36.33 | 105.0 |
| 2015-06-24 | DX | Futures | 89.471 | 89.612 | 89.045 | 89.32 | 35296.0 |
| 2015-06-24 | E1 | Futures | 1.36249 | 1.37214 | 1.35919 | 1.36364 | 15043.0 |
| 2015-06-24 | E6 | Futures | 1.31329 | 1.32128 | 1.31235 | 1.31787 | 212678.0 |
| 2015-06-24 | E7 | Futures | 1.3059 | 1.3138 | 1.3053 | 1.3106 | 6493.0 |
| 2015-06-24 | EBM | Futures | 303.73 | 304.55 | 300.04 | 302.09 | 10468.0 |
| 2015-06-24 | ED | Futures | 95.6127 | 95.627 | 95.6079 | 95.6175 | 149346.0 |
| 2015-06-24 | ER | Futures | 98.082 | 98.092 | 98.077 | 98.082 | 65682.0 |
| 2015-06-24 | EW | Futures | 1622.9 | 1622.9 | 1603.0 | 1604.1 | 13433.0 |
| 2015-06-24 | FBTP | Futures | 97.78 | 98.11 | 97.05 | 97.79 | 93750.0 |
| 2015-06-24 | FBTS | Futures | 99.581 | 99.625 | 99.465 | 99.51 | 29547.0 |
| 2015-06-24 | FCE | Futures | 4222.4 | 4223.2 | 4160.7 | 4201.2 | 154825.0 |
| 2015-06-24 | FDAX | Futures | 12813.4 | 12818.4 | 12566.3 | 12691.2 | 119871.0 |
| 2015-06-24 | FDIV | Futures | 157.23 | 157.23 | 156.3 | 156.4 | 29.0 |
| 2015-06-24 | FESX | Futures | 2694.6 | 2694.6 | 2645.0 | 2671.7 | 1370961.0 |
| 2015-06-24 | FEU3 | Futures | 98.734 | 98.734 | 98.724 | 98.724 | 219.0 |
| 2015-06-24 | FGBL | Futures | 134.43 | 135.23 | 134.38 | 134.79 | 598367.0 |
| 2015-06-24 | FGBM | Futures | 123.55 | 123.79 | 123.55 | 123.67 | 425158.0 |
| 2015-06-24 | FGBS | Futures | 111.143 | 111.163 | 111.133 | 111.148 | 200304.0 |
| 2015-06-24 | FGBX | Futures | 149.35 | 151.3 | 149.27 | 150.1 | 31010.0 |
| 2015-06-24 | FMWO | Futures | 5949.2 | 5949.2 | 5923.3 | 5923.3 | 521.0 |
| 2015-06-24 | FOAT | Futures | 122.84 | 123.36 | 122.84 | 123.08 | 73705.0 |
| 2015-06-24 | FTDX | Futures | 1604.7 | 1608.4 | 1578.3 | 1590.1 | 308.0 |
| 2015-06-24 | FTI | Futures | 431.92 | 432.84 | 427.21 | 429.96 | 44127.0 |
| 2015-06-24 | FTUK | Futures | 5404.1 | 5424.4 | 5383.1 | 5403.3 | 81598.0 |
| 2015-06-24 | FVSA | Futures | 1633.98 | 1738.62 | 1633.98 | 1698.37 | 13154.0 |
| 2015-06-24 | FXXP | Futures | 306.2 | 306.8 | 303.3 | 304.4 | 31106.0 |
| 2015-06-24 | G | Futures | 100.4 | 100.76 | 100.34 | 100.47 | 151759.0 |
| 2015-06-24 | GF | Futures | 383.181 | 383.181 | 379.738 | 380.078 | 3888.0 |
| 2015-06-24 | GSCI | Futures | 731.4 | 735.15 | 722.98 | 724.82 | 111.0 |
| 2015-06-24 | HE | Futures | 80.708 | 81.769 | 80.708 | 81.279 | 6637.0 |
| 2015-06-24 | HG | Futures | 3.2566 | 3.3084 | 3.246 | 3.2747 | 47852.0 |
> showing 50 of 106 rows — these rows as CSV