PREVIEW / futures_daily / 2013-05-10
file: by_date/futures_daily/2013/2013-05-10.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-10 | ES | Futures | 1669.35 | 1674.48 | 1663.45 | 1672.94 | 1641619.0 |
| 2013-05-10 | NQ | Futures | 3420.51 | 3440.72 | 3417.62 | 3436.97 | 169255.0 |
| 2013-05-10 | YM | Futures | 14823.8 | 14880.9 | 14768.6 | 14837.5 | 136164.0 |
| 2013-05-10 | CL | Futures | 167.71 | 167.85 | 162.84 | 167.5 | 354119.0 |
| 2013-05-10 | GC | Futures | 1934.9 | 1939.8 | 1883.1 | 1907.1 | 231401.0 |
| 2013-05-10 | ZN | Futures | 118.157686 | 118.227256 | 117.434158 | 117.61504 | 1911587.0 |
| 2013-05-10 | A6 | Futures | 0.92894 | 0.9295 | 0.91704 | 0.92156 | 167003.0 |
| 2013-05-10 | AD | Futures | 0.99702 | 0.99763 | 0.98889 | 0.9927 | 100641.0 |
| 2013-05-10 | B | Futures | 100.11 | 100.26 | 97.56 | 99.73 | 192383.0 |
| 2013-05-10 | B6 | Futures | 1.6163 | 1.6171 | 1.6019 | 1.6064 | 140856.0 |
| 2013-05-10 | BR | Futures | 0.24453 | 0.24478 | 0.24329 | 0.24351 | 306.0 |
| 2013-05-10 | BZ | Futures | 101.11 | 101.14 | 98.56 | 100.73 | 5388.0 |
| 2013-05-10 | C | Futures | 1645.0 | 1659.0 | 1638.0 | 1638.0 | 17966.0 |
| 2013-05-10 | CB | Futures | 81.524 | 81.993 | 81.524 | 81.993 | 5.0 |
| 2013-05-10 | CC | Futures | 1755.0 | 1755.0 | 1723.0 | 1725.0 | 18124.0 |
| 2013-05-10 | CNH | Futures | 7.1763 | 7.1915 | 7.1721 | 7.1866 | 190.0 |
| 2013-05-10 | CSC | Futures | 3.655 | 3.655 | 3.575 | 3.589 | 58.0 |
| 2013-05-10 | CT | Futures | 105.12 | 105.32 | 102.41 | 103.64 | 14585.0 |
| 2013-05-10 | DC | Futures | 27.92 | 27.92 | 27.3 | 27.46 | 524.0 |
| 2013-05-10 | DX | Futures | 79.592 | 80.269 | 79.544 | 79.992 | 45849.0 |
| 2013-05-10 | E1 | Futures | 1.35729 | 1.35793 | 1.33645 | 1.34494 | 67220.0 |
| 2013-05-10 | E6 | Futures | 1.53818 | 1.539 | 1.52533 | 1.53099 | 302174.0 |
| 2013-05-10 | E7 | Futures | 1.5283 | 1.5288 | 1.5154 | 1.521 | 4455.0 |
| 2013-05-10 | ED | Futures | 95.2683 | 95.2683 | 95.2587 | 95.2683 | 84842.0 |
| 2013-05-10 | ER | Futures | 97.832 | 97.832 | 97.808 | 97.813 | 124740.0 |
| 2013-05-10 | EW | Futures | 1207.4 | 1213.0 | 1204.3 | 1212.2 | 13405.0 |
| 2013-05-10 | FBTP | Futures | 80.18 | 80.4 | 79.96 | 80.07 | 28240.0 |
| 2013-05-10 | FBTS | Futures | 93.211 | 93.22 | 93.091 | 93.134 | 6608.0 |
| 2013-05-10 | FCE | Futures | 3020.6 | 3051.0 | 3018.7 | 3035.6 | 108364.0 |
| 2013-05-10 | FDAX | Futures | 9199.9 | 9293.9 | 9174.9 | 9201.6 | 126269.0 |
| 2013-05-10 | FESX | Futures | 1929.5 | 1948.3 | 1925.3 | 1930.9 | 982203.0 |
| 2013-05-10 | FEU3 | Futures | 98.428 | 98.428 | 98.413 | 98.413 | 100.0 |
| 2013-05-10 | FGBL | Futures | 122.07 | 122.08 | 121.05 | 121.24 | 961509.0 |
| 2013-05-10 | FGBM | Futures | 118.14 | 118.15 | 117.72 | 117.81 | 573588.0 |
| 2013-05-10 | FGBS | Futures | 110.512 | 110.517 | 110.422 | 110.447 | 358453.0 |
| 2013-05-10 | FGBX | Futures | 129.21 | 129.21 | 126.81 | 127.21 | 13671.0 |
| 2013-05-10 | FMWO | Futures | 4894.0 | 4894.0 | 4882.6 | 4882.6 | 1.0 |
| 2013-05-10 | FOAT | Futures | 109.61 | 109.62 | 108.72 | 108.88 | 46692.0 |
| 2013-05-10 | FTDX | Futures | 899.4 | 899.4 | 890.9 | 896.1 | 37.0 |
| 2013-05-10 | FTI | Futures | 311.49 | 314.36 | 311.49 | 313.27 | 2561.0 |
| 2013-05-10 | FTUK | Futures | 4872.0 | 4908.4 | 4872.0 | 4895.0 | 85083.0 |
| 2013-05-10 | FVSA | Futures | 2859.77 | 2891.46 | 2820.16 | 2891.46 | 5001.0 |
| 2013-05-10 | FXXP | Futures | 222.6 | 224.1 | 222.4 | 223.0 | 6944.0 |
| 2013-05-10 | G | Futures | 99.53 | 99.53 | 98.88 | 99.01 | 193278.0 |
| 2013-05-10 | GF | Futures | 245.994 | 247.552 | 245.32 | 247.047 | 3032.0 |
| 2013-05-10 | GSCI | Futures | 1018.14 | 1021.3 | 1005.99 | 1020.08 | 2018.0 |
| 2013-05-10 | HE | Futures | 88.803 | 89.122 | 88.288 | 88.778 | 22773.0 |
| 2013-05-10 | HG | Futures | 4.2488 | 4.3131 | 4.2093 | 4.2717 | 72520.0 |
| 2013-05-10 | HH | Futures | 44.575 | 44.912 | 43.912 | 43.934 | 1877.0 |
| 2013-05-10 | HO | Futures | 2.3564 | 2.3583 | 2.297 | 2.3394 | 55909.0 |
> showing 50 of 103 rows — these rows as CSV