PREVIEW / futures_daily / 2013-06-27
file: by_date/futures_daily/2013/2013-06-27.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-06-27 | ES | Futures | 1644.59 | 1662.62 | 1642.53 | 1654.64 | 1601032.0 |
| 2013-06-27 | NQ | Futures | 3338.09 | 3375.68 | 3334.04 | 3353.99 | 173476.0 |
| 2013-06-27 | YM | Futures | 14699.9 | 14870.3 | 14689.0 | 14803.9 | 143042.0 |
| 2013-06-27 | CL | Futures | 166.38 | 169.68 | 166.09 | 169.05 | 269312.0 |
| 2013-06-27 | GC | Futures | 1626.9 | 1651.7 | 1587.8 | 1608.4 | 261390.0 |
| 2013-06-27 | ZN | Futures | 113.391113 | 113.896446 | 113.250743 | 113.770113 | 1308690.0 |
| 2013-06-27 | A6 | Futures | 0.86554 | 0.87136 | 0.86404 | 0.86554 | 110729.0 |
| 2013-06-27 | AD | Futures | 0.95968 | 0.96462 | 0.95716 | 0.95948 | 75260.0 |
| 2013-06-27 | B | Futures | 98.59 | 100.13 | 98.53 | 99.62 | 82413.0 |
| 2013-06-27 | B6 | Futures | 1.6049 | 1.6083 | 1.593 | 1.5992 | 120082.0 |
| 2013-06-27 | BR | Futures | 0.22321 | 0.22438 | 0.22247 | 0.22348 | 416.0 |
| 2013-06-27 | BZ | Futures | 99.86 | 100.8 | 99.33 | 100.29 | 18039.0 |
| 2013-06-27 | C | Futures | 1540.0 | 1546.0 | 1531.0 | 1539.0 | 3199.0 |
| 2013-06-27 | CB | Futures | 71.757 | 73.193 | 71.757 | 73.193 | 40.0 |
| 2013-06-27 | CC | Futures | 1628.0 | 1628.0 | 1598.0 | 1605.0 | 14864.0 |
| 2013-06-27 | CSC | Futures | 3.461 | 3.465 | 3.442 | 3.446 | 49.0 |
| 2013-06-27 | CT | Futures | 101.95 | 102.73 | 101.43 | 102.57 | 42.0 |
| 2013-06-27 | DC | Futures | 26.34 | 26.54 | 26.15 | 26.23 | 259.0 |
| 2013-06-27 | DX | Futures | 79.447 | 79.734 | 79.337 | 79.468 | 30547.0 |
| 2013-06-27 | E1 | Futures | 1.36424 | 1.36733 | 1.35563 | 1.36141 | 28804.0 |
| 2013-06-27 | E6 | Futures | 1.53556 | 1.54146 | 1.53462 | 1.54028 | 231530.0 |
| 2013-06-27 | E7 | Futures | 1.5254 | 1.5315 | 1.5246 | 1.5302 | 3233.0 |
| 2013-06-27 | ED | Futures | 95.2534 | 95.2678 | 95.2486 | 95.2582 | 99017.0 |
| 2013-06-27 | ER | Futures | 97.793 | 97.817 | 97.788 | 97.803 | 169278.0 |
| 2013-06-27 | EW | Futures | 1164.6 | 1184.9 | 1163.6 | 1182.5 | 18060.0 |
| 2013-06-27 | FBTP | Futures | 75.74 | 76.69 | 75.58 | 76.31 | 60565.0 |
| 2013-06-27 | FBTS | Futures | 91.879 | 92.387 | 91.879 | 92.18 | 10404.0 |
| 2013-06-27 | FCE | Futures | 2891.5 | 2932.3 | 2872.1 | 2916.7 | 103025.0 |
| 2013-06-27 | FDAX | Futures | 8832.3 | 8912.8 | 8793.4 | 8882.8 | 92172.0 |
| 2013-06-27 | FESX | Futures | 1825.0 | 1846.0 | 1812.4 | 1837.6 | 898592.0 |
| 2013-06-27 | FEU3 | Futures | 98.413 | 98.413 | 98.413 | 98.413 | 58.0 |
| 2013-06-27 | FGBL | Futures | 118.02 | 118.81 | 117.91 | 118.45 | 704108.0 |
| 2013-06-27 | FGBM | Futures | 116.31 | 116.67 | 116.24 | 116.49 | 449163.0 |
| 2013-06-27 | FGBS | Futures | 110.168 | 110.223 | 110.158 | 110.198 | 356796.0 |
| 2013-06-27 | FGBX | Futures | 122.21 | 123.61 | 121.93 | 123.08 | 13847.0 |
| 2013-06-27 | FMWO | Futures | 4698.9 | 4725.5 | 4696.3 | 4724.2 | 185.0 |
| 2013-06-27 | FOAT | Futures | 105.14 | 105.91 | 105.03 | 105.55 | 49022.0 |
| 2013-06-27 | FTDX | Futures | 880.2 | 898.5 | 880.2 | 895.7 | 128.0 |
| 2013-06-27 | FTI | Futures | 297.16 | 301.69 | 295.98 | 300.43 | 27784.0 |
| 2013-06-27 | FTUK | Futures | 4597.5 | 4668.8 | 4591.1 | 4650.0 | 76930.0 |
| 2013-06-27 | FVSA | Futures | 3432.42 | 3469.4 | 3291.87 | 3314.06 | 2303.0 |
| 2013-06-27 | FXXP | Futures | 209.3 | 211.2 | 208.1 | 210.5 | 8871.0 |
| 2013-06-27 | G | Futures | 94.3 | 94.77 | 94.22 | 94.46 | 164668.0 |
| 2013-06-27 | GF | Futures | 250.838 | 252.86 | 250.669 | 252.228 | 2682.0 |
| 2013-06-27 | GSCI | Futures | 1006.85 | 1016.06 | 1006.85 | 1011.29 | 172.0 |
| 2013-06-27 | HE | Futures | 99.981 | 101.799 | 99.957 | 101.575 | 11226.0 |
| 2013-06-27 | HG | Futures | 3.87 | 3.9048 | 3.8509 | 3.882 | 59275.0 |
| 2013-06-27 | HH | Futures | 41.66 | 41.66 | 39.632 | 39.9 | 3206.0 |
| 2013-06-27 | HO | Futures | 2.3001 | 2.3372 | 2.2988 | 2.3218 | 14912.0 |
| 2013-06-27 | HRC | Futures | 2186.3 | 2193.2 | 2186.3 | 2193.2 | 15.0 |
> showing 50 of 102 rows — these rows as CSV