PREVIEW / futures_daily / 2013-11-05
file: by_date/futures_daily/2013/2013-11-05.parquet size: 9 KB rows: 102
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-11-05 | ES | Futures | 1810.74 | 1812.03 | 1798.16 | 1804.32 | 1479362.0 |
| 2013-11-05 | NQ | Futures | 3879.72 | 3894.08 | 3854.17 | 3881.73 | 224570.0 |
| 2013-11-05 | YM | Futures | 15496.1 | 15511.0 | 15378.7 | 15472.2 | 140629.0 |
| 2013-11-05 | CL | Futures | 168.09 | 168.85 | 165.6 | 166.13 | 226454.0 |
| 2013-11-05 | GC | Futures | 1737.7 | 1746.6 | 1726.2 | 1730.0 | 99655.0 |
| 2013-11-05 | ZN | Futures | 115.050992 | 115.150125 | 114.555327 | 114.711108 | 1134295.0 |
| 2013-11-05 | A6 | Futures | 0.89557 | 0.89841 | 0.89142 | 0.89416 | 88449.0 |
| 2013-11-05 | AD | Futures | 0.96834 | 0.96894 | 0.9646 | 0.9648 | 39186.0 |
| 2013-11-05 | B | Futures | 106.12 | 106.36 | 105.11 | 105.24 | 119109.0 |
| 2013-11-05 | B6 | Futures | 1.6754 | 1.6857 | 1.6736 | 1.6841 | 106010.0 |
| 2013-11-05 | BFX | Futures | 3472.0 | 3472.0 | 3450.5 | 3452.3 | 19.0 |
| 2013-11-05 | BR | Futures | 0.22326 | 0.22326 | 0.22064 | 0.22158 | 522.0 |
| 2013-11-05 | BZ | Futures | 106.87 | 107.03 | 105.83 | 105.94 | 5682.0 |
| 2013-11-05 | C | Futures | 1805.0 | 1850.0 | 1796.0 | 1846.0 | 8116.0 |
| 2013-11-05 | CB | Futures | 71.937 | 72.008 | 71.937 | 72.008 | 5.0 |
| 2013-11-05 | CC | Futures | 1979.0 | 2044.0 | 1979.0 | 2037.0 | 22650.0 |
| 2013-11-05 | CSC | Futures | 3.464 | 3.478 | 3.464 | 3.466 | 7.0 |
| 2013-11-05 | CT | Futures | 89.23 | 89.45 | 88.3 | 89.09 | 16673.0 |
| 2013-11-05 | DC | Futures | 26.4 | 26.55 | 26.26 | 26.4 | 357.0 |
| 2013-11-05 | DX | Futures | 76.824 | 77.076 | 76.772 | 76.974 | 15125.0 |
| 2013-11-05 | E1 | Futures | 1.41256 | 1.41333 | 1.40511 | 1.40819 | 30567.0 |
| 2013-11-05 | E6 | Futures | 1.59469 | 1.59598 | 1.58725 | 1.5902 | 189195.0 |
| 2013-11-05 | E7 | Futures | 1.5845 | 1.5856 | 1.577 | 1.5799 | 3278.0 |
| 2013-11-05 | ED | Futures | 95.359 | 95.3638 | 95.359 | 95.359 | 59466.0 |
| 2013-11-05 | ER | Futures | 97.881 | 97.881 | 97.871 | 97.876 | 68021.0 |
| 2013-11-05 | EW | Futures | 1321.7 | 1323.7 | 1309.8 | 1312.9 | 15086.0 |
| 2013-11-05 | FBTP | Futures | 81.28 | 81.36 | 80.88 | 80.95 | 37891.0 |
| 2013-11-05 | FBTS | Futures | 94.984 | 95.019 | 94.88 | 94.906 | 7891.0 |
| 2013-11-05 | FCE | Futures | 3329.2 | 3329.6 | 3276.5 | 3291.6 | 116129.0 |
| 2013-11-05 | FDAX | Futures | 10049.2 | 10050.9 | 9948.2 | 9994.3 | 92537.0 |
| 2013-11-05 | FESX | Futures | 2146.3 | 2147.0 | 2112.6 | 2123.1 | 804181.0 |
| 2013-11-05 | FEU3 | Futures | 98.497 | 98.497 | 98.497 | 98.497 | 300.0 |
| 2013-11-05 | FGBL | Futures | 120.81 | 120.89 | 120.16 | 120.2 | 726800.0 |
| 2013-11-05 | FGBM | Futures | 118.5 | 118.55 | 118.13 | 118.15 | 593621.0 |
| 2013-11-05 | FGBS | Futures | 110.543 | 110.563 | 110.483 | 110.488 | 340956.0 |
| 2013-11-05 | FGBX | Futures | 122.12 | 122.21 | 120.87 | 120.97 | 19736.0 |
| 2013-11-05 | FMWO | Futures | 5257.3 | 5257.3 | 5257.3 | 5257.3 | 0.0 |
| 2013-11-05 | FOAT | Futures | 108.8 | 108.82 | 108.13 | 108.19 | 40943.0 |
| 2013-11-05 | FTDX | Futures | 1078.4 | 1078.4 | 1063.8 | 1065.2 | 170.0 |
| 2013-11-05 | FTI | Futures | 338.84 | 339.32 | 335.47 | 337.07 | 23001.0 |
| 2013-11-05 | FTUK | Futures | 5070.4 | 5079.8 | 5014.2 | 5037.4 | 94947.0 |
| 2013-11-05 | FVSA | Futures | 2069.25 | 2130.11 | 2057.08 | 2099.68 | 7165.0 |
| 2013-11-05 | FXXP | Futures | 235.5 | 235.7 | 233.3 | 234.5 | 15465.0 |
| 2013-11-05 | G | Futures | 93.12 | 93.18 | 92.29 | 92.42 | 192789.0 |
| 2013-11-05 | GF | Futures | 263.938 | 266.277 | 263.898 | 265.793 | 1626.0 |
| 2013-11-05 | GSCI | Futures | 1013.1 | 1018.69 | 1011.18 | 1013.1 | 310.0 |
| 2013-11-05 | HE | Futures | 111.699 | 112.775 | 111.351 | 111.699 | 24218.0 |
| 2013-11-05 | HG | Futures | 4.1322 | 4.1487 | 4.1063 | 4.1259 | 43421.0 |
| 2013-11-05 | HH | Futures | 35.201 | 35.724 | 34.78 | 35.56 | 3708.0 |
| 2013-11-05 | HO | Futures | 2.302 | 2.3128 | 2.2893 | 2.294 | 52599.0 |
> showing 50 of 102 rows — these rows as CSV