PREVIEW / futures_daily / 2014-05-02
file: by_date/futures_daily/2014/2014-05-02.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-05-02 | ES | Futures | 1943.83 | 1951.33 | 1936.84 | 1939.43 | 1717169.0 |
| 2014-05-02 | NQ | Futures | 4131.89 | 4149.16 | 4108.87 | 4120.09 | 297575.0 |
| 2014-05-02 | YM | Futures | 16559.6 | 16617.8 | 16485.3 | 16514.4 | 163094.0 |
| 2014-05-02 | CL | Futures | 179.62 | 181.38 | 179.62 | 180.69 | 213631.0 |
| 2014-05-02 | GC | Futures | 1692.7 | 1719.3 | 1676.0 | 1716.7 | 171945.0 |
| 2014-05-02 | ZN | Futures | 115.50421 | 115.808435 | 114.765377 | 115.576644 | 2456385.0 |
| 2014-05-02 | A6 | Futures | 0.8878 | 0.88895 | 0.88146 | 0.8877 | 92592.0 |
| 2014-05-02 | AD | Futures | 0.92384 | 0.92627 | 0.91927 | 0.92282 | 59472.0 |
| 2014-05-02 | B | Futures | 110.99 | 112.14 | 110.84 | 111.77 | 128067.0 |
| 2014-05-02 | B6 | Futures | 1.7742 | 1.7752 | 1.7661 | 1.7724 | 92847.0 |
| 2014-05-02 | BFX | Futures | 3719.9 | 3719.9 | 3716.9 | 3716.9 | 1.0 |
| 2014-05-02 | BR | Futures | 0.23431 | 0.23579 | 0.23294 | 0.23502 | 139.0 |
| 2014-05-02 | BZ | Futures | 113.15 | 114.36 | 113.15 | 114.0 | 9985.0 |
| 2014-05-02 | C | Futures | 1895.0 | 1897.0 | 1889.0 | 1894.0 | 14385.0 |
| 2014-05-02 | CB | Futures | 105.092 | 105.092 | 103.061 | 104.838 | 55.0 |
| 2014-05-02 | CC | Futures | 2150.0 | 2157.0 | 2142.0 | 2151.0 | 10704.0 |
| 2014-05-02 | CNH | Futures | 7.1805 | 7.1841 | 7.1785 | 7.1785 | 1.0 |
| 2014-05-02 | CSC | Futures | 4.66 | 4.667 | 4.6 | 4.611 | 66.0 |
| 2014-05-02 | CT | Futures | 106.4 | 107.08 | 105.67 | 106.21 | 10187.0 |
| 2014-05-02 | DC | Futures | 37.71 | 37.92 | 37.16 | 37.33 | 232.0 |
| 2014-05-02 | DX | Futures | 75.584 | 75.94 | 75.541 | 75.587 | 23757.0 |
| 2014-05-02 | E1 | Futures | 1.46022 | 1.4633 | 1.45201 | 1.46215 | 38649.0 |
| 2014-05-02 | E6 | Futures | 1.63706 | 1.63859 | 1.62974 | 1.63741 | 196881.0 |
| 2014-05-02 | E7 | Futures | 1.6264 | 1.6277 | 1.6195 | 1.6265 | 4033.0 |
| 2014-05-02 | EBM | Futures | 303.33 | 304.03 | 301.92 | 303.33 | 6771.0 |
| 2014-05-02 | ED | Futures | 95.4138 | 95.4186 | 95.4138 | 95.4138 | 84679.0 |
| 2014-05-02 | ER | Futures | 97.842 | 97.847 | 97.832 | 97.842 | 82829.0 |
| 2014-05-02 | EW | Futures | 1398.6 | 1413.0 | 1396.0 | 1400.8 | 17721.0 |
| 2014-05-02 | FBTP | Futures | 89.1 | 89.18 | 88.8 | 89.1 | 48286.0 |
| 2014-05-02 | FBTS | Futures | 97.469 | 97.522 | 97.346 | 97.504 | 6770.0 |
| 2014-05-02 | FCE | Futures | 3525.0 | 3529.0 | 3497.6 | 3505.9 | 104711.0 |
| 2014-05-02 | FDAX | Futures | 10650.0 | 10656.6 | 10537.9 | 10544.5 | 91641.0 |
| 2014-05-02 | FDIV | Futures | 143.6 | 143.6 | 143.41 | 143.41 | 10.0 |
| 2014-05-02 | FESX | Futures | 2264.3 | 2267.1 | 2244.9 | 2246.3 | 828002.0 |
| 2014-05-02 | FGBL | Futures | 124.91 | 125.1 | 124.36 | 124.95 | 733929.0 |
| 2014-05-02 | FGBM | Futures | 120.08 | 120.26 | 119.85 | 120.19 | 509248.0 |
| 2014-05-02 | FGBS | Futures | 110.598 | 110.618 | 110.538 | 110.603 | 322386.0 |
| 2014-05-02 | FGBX | Futures | 129.65 | 129.88 | 128.45 | 129.51 | 20886.0 |
| 2014-05-02 | FMWO | Futures | 5593.5 | 5612.5 | 5592.3 | 5592.3 | 217.0 |
| 2014-05-02 | FOAT | Futures | 114.24 | 114.43 | 113.75 | 114.29 | 55373.0 |
| 2014-05-02 | FTDX | Futures | 1176.6 | 1176.6 | 1146.6 | 1150.3 | 76.0 |
| 2014-05-02 | FTI | Futures | 342.94 | 343.37 | 341.13 | 341.9 | 27191.0 |
| 2014-05-02 | FTUK | Futures | 5164.1 | 5185.4 | 5154.2 | 5157.6 | 97555.0 |
| 2014-05-02 | FVSA | Futures | 1751.75 | 1785.07 | 1718.43 | 1785.07 | 8762.0 |
| 2014-05-02 | FXXP | Futures | 251.5 | 252.3 | 250.5 | 250.5 | 3958.0 |
| 2014-05-02 | G | Futures | 94.22 | 94.54 | 93.66 | 94.34 | 203246.0 |
| 2014-05-02 | GF | Futures | 292.567 | 293.84 | 291.055 | 292.049 | 2210.0 |
| 2014-05-02 | GSCI | Futures | 1075.28 | 1081.58 | 1075.28 | 1078.59 | 183.0 |
| 2014-05-02 | HE | Futures | 136.264 | 137.491 | 135.734 | 136.403 | 16708.0 |
| 2014-05-02 | HG | Futures | 3.8666 | 3.9337 | 3.8506 | 3.9228 | 36857.0 |
> showing 50 of 105 rows — these rows as CSV