PREVIEW / futures_daily / 2014-03-27
file: by_date/futures_daily/2014/2014-03-27.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-03-27 | ES | Futures | 1908.91 | 1912.53 | 1897.53 | 1904.25 | 2031166.0 |
| 2014-03-27 | NQ | Futures | 4118.37 | 4127.0 | 4069.44 | 4091.31 | 443690.0 |
| 2014-03-27 | YM | Futures | 16269.4 | 16295.5 | 16178.1 | 16248.3 | 190508.0 |
| 2014-03-27 | CL | Futures | 178.99 | 181.49 | 178.51 | 180.74 | 202200.0 |
| 2014-03-27 | GC | Futures | 1720.4 | 1722.8 | 1699.3 | 1706.0 | 137399.0 |
| 2014-03-27 | ZN | Futures | 114.794351 | 114.924733 | 114.577047 | 114.837811 | 1434929.0 |
| 2014-03-27 | A6 | Futures | 0.88117 | 0.88607 | 0.8804 | 0.88473 | 82138.0 |
| 2014-03-27 | AD | Futures | 0.91147 | 0.91887 | 0.91116 | 0.91735 | 74006.0 |
| 2014-03-27 | B | Futures | 110.32 | 111.41 | 110.15 | 111.25 | 133198.0 |
| 2014-03-27 | B6 | Futures | 1.7413 | 1.7487 | 1.739 | 1.7453 | 91858.0 |
| 2014-03-27 | BFX | Futures | 3752.1 | 3752.6 | 3743.6 | 3743.6 | 150.0 |
| 2014-03-27 | BR | Futures | 0.22491 | 0.22902 | 0.2247 | 0.22881 | 7650.0 |
| 2014-03-27 | BZ | Futures | 112.4 | 113.53 | 112.26 | 113.38 | 8896.0 |
| 2014-03-27 | C | Futures | 1959.0 | 1966.0 | 1953.0 | 1961.0 | 5822.0 |
| 2014-03-27 | CB | Futures | 95.192 | 95.446 | 95.053 | 95.446 | 18.0 |
| 2014-03-27 | CC | Futures | 2200.0 | 2204.0 | 2181.0 | 2194.0 | 10922.0 |
| 2014-03-27 | CNH | Futures | 7.1244 | 7.1338 | 7.1244 | 7.1259 | 21.0 |
| 2014-03-27 | CSC | Futures | 4.462 | 4.491 | 4.446 | 4.491 | 41.0 |
| 2014-03-27 | CT | Futures | 102.95 | 105.55 | 102.95 | 104.03 | 11801.0 |
| 2014-03-27 | DC | Futures | 35.51 | 35.79 | 35.27 | 35.77 | 236.0 |
| 2014-03-27 | DX | Futures | 76.159 | 76.335 | 76.097 | 76.242 | 15606.0 |
| 2014-03-27 | E1 | Futures | 1.45098 | 1.45252 | 1.44713 | 1.44906 | 25543.0 |
| 2014-03-27 | E6 | Futures | 1.62702 | 1.62856 | 1.62053 | 1.62277 | 177625.0 |
| 2014-03-27 | E7 | Futures | 1.6165 | 1.6176 | 1.6096 | 1.612 | 3737.0 |
| 2014-03-27 | EBM | Futures | 294.87 | 299.1 | 294.52 | 298.04 | 16991.0 |
| 2014-03-27 | ED | Futures | 95.3947 | 95.3995 | 95.3899 | 95.3947 | 84785.0 |
| 2014-03-27 | ER | Futures | 97.842 | 97.862 | 97.842 | 97.857 | 139824.0 |
| 2014-03-27 | EW | Futures | 1395.8 | 1398.3 | 1385.3 | 1389.7 | 21705.0 |
| 2014-03-27 | FBTP | Futures | 86.96 | 87.33 | 86.96 | 87.26 | 49220.0 |
| 2014-03-27 | FBTS | Futures | 97.188 | 97.284 | 97.179 | 97.249 | 13620.0 |
| 2014-03-27 | FCE | Futures | 3395.6 | 3413.5 | 3389.0 | 3405.3 | 98305.0 |
| 2014-03-27 | FDAX | Futures | 10419.7 | 10481.6 | 10397.6 | 10458.9 | 103812.0 |
| 2014-03-27 | FESX | Futures | 2190.3 | 2206.8 | 2189.6 | 2202.5 | 756504.0 |
| 2014-03-27 | FGBL | Futures | 123.83 | 124.2 | 123.8 | 124.13 | 632719.0 |
| 2014-03-27 | FGBM | Futures | 119.75 | 119.92 | 119.74 | 119.89 | 415135.0 |
| 2014-03-27 | FGBS | Futures | 110.528 | 110.583 | 110.523 | 110.568 | 346277.0 |
| 2014-03-27 | FGBX | Futures | 126.74 | 127.39 | 126.72 | 127.31 | 21198.0 |
| 2014-03-27 | FMWO | Futures | 5463.6 | 5464.8 | 5461.0 | 5464.8 | 81.0 |
| 2014-03-27 | FOAT | Futures | 112.64 | 113.1 | 112.64 | 113.03 | 53002.0 |
| 2014-03-27 | FTDX | Futures | 1155.9 | 1164.8 | 1154.1 | 1164.8 | 137.0 |
| 2014-03-27 | FTI | Futures | 336.77 | 340.27 | 336.77 | 340.06 | 24557.0 |
| 2014-03-27 | FTUK | Futures | 4962.0 | 4985.3 | 4957.8 | 4979.6 | 94962.0 |
| 2014-03-27 | FVSA | Futures | 1815.59 | 1855.71 | 1810.57 | 1825.62 | 6607.0 |
| 2014-03-27 | FXXP | Futures | 243.7 | 245.1 | 243.4 | 244.8 | 3580.0 |
| 2014-03-27 | G | Futures | 93.74 | 93.96 | 93.61 | 93.89 | 169059.0 |
| 2014-03-27 | GF | Futures | 286.159 | 287.92 | 285.599 | 287.36 | 1754.0 |
| 2014-03-27 | GSCI | Futures | 1063.64 | 1074.8 | 1061.49 | 1073.56 | 546.0 |
| 2014-03-27 | HE | Futures | 143.013 | 146.163 | 142.838 | 146.163 | 351.0 |
| 2014-03-27 | HG | Futures | 3.7563 | 3.8044 | 3.7543 | 3.793 | 42109.0 |
| 2014-03-27 | HH | Futures | 55.478 | 57.744 | 55.478 | 57.44 | 4769.0 |
> showing 50 of 104 rows — these rows as CSV