PREVIEW / futures_daily / 2014-06-02
file: by_date/futures_daily/2014/2014-06-02.parquet size: 9 KB rows: 104
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-06-02 | ES | Futures | 1987.8 | 1990.9 | 1980.04 | 1988.31 | 1053526.0 |
| 2014-06-02 | NQ | Futures | 4299.38 | 4306.86 | 4267.43 | 4290.74 | 225591.0 |
| 2014-06-02 | YM | Futures | 16772.5 | 16812.6 | 16737.3 | 16790.6 | 91660.0 |
| 2014-06-02 | CL | Futures | 187.21 | 187.99 | 185.72 | 186.39 | 159042.0 |
| 2014-06-02 | GC | Futures | 1647.6 | 1648.3 | 1635.3 | 1639.1 | 91403.0 |
| 2014-06-02 | ZN | Futures | 116.952902 | 117.010849 | 116.48932 | 116.561755 | 196147.0 |
| 2014-06-02 | A6 | Futures | 0.89356 | 0.89395 | 0.88626 | 0.88742 | 60819.0 |
| 2014-06-02 | AD | Futures | 0.93469 | 0.93499 | 0.92891 | 0.92982 | 51957.0 |
| 2014-06-02 | ALI | Futures | 2759.58 | 2759.58 | 2759.58 | 2759.58 | 0.0 |
| 2014-06-02 | B | Futures | 113.81 | 114.21 | 112.97 | 113.2 | 132259.0 |
| 2014-06-02 | B6 | Futures | 1.7614 | 1.7619 | 1.7577 | 1.7598 | 75139.0 |
| 2014-06-02 | BR | Futures | 0.22883 | 0.22883 | 0.2259 | 0.2268 | 682.0 |
| 2014-06-02 | BZ | Futures | 115.12 | 115.24 | 113.97 | 114.2 | 12377.0 |
| 2014-06-02 | C | Futures | 2018.0 | 2024.0 | 2014.0 | 2018.0 | 8077.0 |
| 2014-06-02 | CB | Futures | 110.952 | 110.952 | 110.113 | 110.533 | 1.0 |
| 2014-06-02 | CC | Futures | 2255.0 | 2270.0 | 2248.0 | 2263.0 | 13131.0 |
| 2014-06-02 | CSC | Futures | 4.462 | 4.484 | 4.457 | 4.457 | 13.0 |
| 2014-06-02 | CT | Futures | 97.14 | 97.64 | 96.43 | 97.38 | 15572.0 |
| 2014-06-02 | DC | Futures | 34.98 | 35.29 | 34.98 | 35.25 | 28.0 |
| 2014-06-02 | DX | Futures | 76.387 | 76.696 | 76.387 | 76.658 | 21374.0 |
| 2014-06-02 | E1 | Futures | 1.43353 | 1.43379 | 1.42686 | 1.42801 | 31689.0 |
| 2014-06-02 | E6 | Futures | 1.6092 | 1.60979 | 1.60388 | 1.60495 | 160355.0 |
| 2014-06-02 | E7 | Futures | 1.5985 | 1.5991 | 1.5933 | 1.5942 | 1728.0 |
| 2014-06-02 | ED | Futures | 95.4114 | 95.4138 | 95.4114 | 95.4138 | 46961.0 |
| 2014-06-02 | ER | Futures | 97.871 | 97.881 | 97.871 | 97.881 | 77247.0 |
| 2014-06-02 | EW | Futures | 1419.6 | 1426.0 | 1412.0 | 1424.9 | 14207.0 |
| 2014-06-02 | FBTP | Futures | 89.75 | 89.99 | 89.68 | 89.74 | 63723.0 |
| 2014-06-02 | FBTS | Futures | 97.601 | 97.645 | 97.566 | 97.592 | 12601.0 |
| 2014-06-02 | FCE | Futures | 3606.8 | 3612.4 | 3590.0 | 3601.6 | 70447.0 |
| 2014-06-02 | FDAX | Futures | 11012.2 | 11035.4 | 10941.0 | 10999.5 | 62284.0 |
| 2014-06-02 | FESX | Futures | 2336.1 | 2339.7 | 2324.6 | 2334.0 | 539699.0 |
| 2014-06-02 | FEU3 | Futures | 98.492 | 98.502 | 98.492 | 98.502 | 408.0 |
| 2014-06-02 | FGBL | Futures | 126.61 | 126.89 | 126.44 | 126.61 | 833248.0 |
| 2014-06-02 | FGBM | Futures | 121.0 | 121.12 | 120.9 | 120.98 | 641236.0 |
| 2014-06-02 | FGBS | Futures | 110.743 | 110.778 | 110.738 | 110.748 | 538739.0 |
| 2014-06-02 | FGBX | Futures | 131.4 | 131.87 | 131.01 | 131.48 | 40097.0 |
| 2014-06-02 | FMWO | Futures | 5715.9 | 5715.9 | 5712.1 | 5713.4 | 79.0 |
| 2014-06-02 | FOAT | Futures | 115.86 | 116.15 | 115.81 | 115.94 | 64046.0 |
| 2014-06-02 | FTDX | Futures | 1197.7 | 1217.8 | 1197.7 | 1216.4 | 178.0 |
| 2014-06-02 | FTI | Futures | 352.74 | 353.43 | 352.14 | 353.0 | 16158.0 |
| 2014-06-02 | FTUK | Futures | 5217.1 | 5233.9 | 5212.9 | 5231.2 | 57142.0 |
| 2014-06-02 | FVSA | Futures | 1569.0 | 1597.02 | 1550.32 | 1564.33 | 4413.0 |
| 2014-06-02 | FXXP | Futures | 258.7 | 259.0 | 257.8 | 258.7 | 4762.0 |
| 2014-06-02 | G | Futures | 94.37 | 94.49 | 93.97 | 94.12 | 115282.0 |
| 2014-06-02 | GF | Futures | 302.151 | 303.262 | 301.155 | 302.802 | 1559.0 |
| 2014-06-02 | GSCI | Futures | 1076.19 | 1076.19 | 1072.8 | 1074.12 | 62.0 |
| 2014-06-02 | HE | Futures | 126.499 | 127.814 | 125.788 | 127.367 | 13905.0 |
| 2014-06-02 | HG | Futures | 4.002 | 4.0544 | 4.002 | 4.0512 | 31672.0 |
| 2014-06-02 | HH | Futures | 57.741 | 58.463 | 57.424 | 58.463 | 104.0 |
| 2014-06-02 | HO | Futures | 2.3152 | 2.3246 | 2.3046 | 2.3081 | 10180.0 |
> showing 50 of 104 rows — these rows as CSV