PREVIEW / futures_daily / 2015-05-07
file: by_date/futures_daily/2015/2015-05-07.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-07 | ES | Futures | 2181.52 | 2195.72 | 2162.86 | 2191.51 | 1437746.0 |
| 2015-05-07 | NQ | Futures | 5075.45 | 5119.28 | 5030.17 | 5111.45 | 249245.0 |
| 2015-05-07 | YM | Futures | 18186.4 | 18328.6 | 18032.0 | 18297.9 | 176646.0 |
| 2015-05-07 | CL | Futures | 103.05 | 104.11 | 99.32 | 100.08 | 437022.0 |
| 2015-05-07 | GC | Futures | 1558.8 | 1559.7 | 1541.3 | 1546.9 | 134937.0 |
| 2015-05-07 | ZN | Futures | 120.280941 | 120.784147 | 119.748135 | 120.665746 | 1888100.0 |
| 2015-05-07 | A6 | Futures | 0.78426 | 0.7879 | 0.77656 | 0.77785 | 95418.0 |
| 2015-05-07 | AD | Futures | 0.84753 | 0.84804 | 0.83905 | 0.84089 | 55867.0 |
| 2015-05-07 | ALI | Futures | 2561.96 | 2561.96 | 2561.96 | 2561.96 | 0.0 |
| 2015-05-07 | B | Futures | 64.77 | 65.84 | 62.71 | 63.04 | 215495.0 |
| 2015-05-07 | B6 | Futures | 1.604 | 1.6074 | 1.5957 | 1.6056 | 92382.0 |
| 2015-05-07 | BFX | Futures | 4286.4 | 4343.7 | 4286.4 | 4337.0 | 13.0 |
| 2015-05-07 | BR | Futures | 0.18702 | 0.18759 | 0.18471 | 0.18731 | 968.0 |
| 2015-05-07 | BZ | Futures | 64.03 | 65.15 | 62.12 | 62.44 | 14354.0 |
| 2015-05-07 | C | Futures | 2181.0 | 2189.0 | 2171.0 | 2180.0 | 2865.0 |
| 2015-05-07 | CB | Futures | 158.593 | 161.425 | 158.593 | 161.425 | 20.0 |
| 2015-05-07 | CC | Futures | 2156.0 | 2173.0 | 2144.0 | 2161.0 | 11957.0 |
| 2015-05-07 | CNH | Futures | 6.9891 | 7.0009 | 6.9891 | 6.9997 | 7.0 |
| 2015-05-07 | CSC | Futures | 4.602 | 4.652 | 4.572 | 4.623 | 67.0 |
| 2015-05-07 | CT | Futures | 83.09 | 83.15 | 81.83 | 82.55 | 15489.0 |
| 2015-05-07 | DC | Futures | 37.96 | 38.5 | 37.65 | 38.19 | 534.0 |
| 2015-05-07 | DX | Futures | 88.498 | 89.146 | 88.24 | 88.966 | 43625.0 |
| 2015-05-07 | E1 | Futures | 1.39369 | 1.40657 | 1.38299 | 1.38477 | 28080.0 |
| 2015-05-07 | E6 | Futures | 1.33456 | 1.34032 | 1.3221 | 1.32574 | 300545.0 |
| 2015-05-07 | E7 | Futures | 1.3268 | 1.3325 | 1.3144 | 1.3181 | 7340.0 |
| 2015-05-07 | EBM | Futures | 283.64 | 284.46 | 281.59 | 282.82 | 9205.0 |
| 2015-05-07 | ED | Futures | 95.5477 | 95.5573 | 95.5477 | 95.5525 | 188928.0 |
| 2015-05-07 | ER | Futures | 98.073 | 98.077 | 98.068 | 98.073 | 38322.0 |
| 2015-05-07 | EW | Futures | 1570.4 | 1579.9 | 1555.6 | 1575.1 | 14710.0 |
| 2015-05-07 | FBTS | Futures | 99.546 | 99.679 | 99.528 | 99.626 | 42651.0 |
| 2015-05-07 | FCE | Futures | 4056.3 | 4072.8 | 3983.6 | 4061.7 | 155388.0 |
| 2015-05-07 | FDAX | Futures | 12611.2 | 12706.7 | 12401.6 | 12681.1 | 124564.0 |
| 2015-05-07 | FESX | Futures | 2580.5 | 2598.2 | 2535.5 | 2591.5 | 1523646.0 |
| 2015-05-07 | FGBL | Futures | 136.58 | 137.21 | 134.54 | 136.82 | 1725063.0 |
| 2015-05-07 | FGBM | Futures | 123.8 | 123.92 | 123.2 | 123.78 | 1042807.0 |
| 2015-05-07 | FGBS | Futures | 111.198 | 111.213 | 111.158 | 111.188 | 404889.0 |
| 2015-05-07 | FGBX | Futures | 159.92 | 162.89 | 154.32 | 161.71 | 71825.0 |
| 2015-05-07 | FMWO | Futures | 5821.2 | 5847.1 | 5789.1 | 5845.8 | 1100.0 |
| 2015-05-07 | FOAT | Futures | 125.18 | 125.82 | 123.29 | 125.53 | 217193.0 |
| 2015-05-07 | FTDX | Futures | 1486.6 | 1515.2 | 1477.2 | 1515.2 | 205.0 |
| 2015-05-07 | FTI | Futures | 412.86 | 415.69 | 406.63 | 414.68 | 41610.0 |
| 2015-05-07 | FTUK | Futures | 5426.7 | 5434.2 | 5342.7 | 5414.1 | 148077.0 |
| 2015-05-07 | FVSA | Futures | 1899.34 | 1927.04 | 1804.38 | 1824.16 | 15152.0 |
| 2015-05-07 | FXXP | Futures | 294.8 | 297.2 | 291.0 | 296.7 | 28942.0 |
| 2015-05-07 | G | Futures | 101.4 | 102.34 | 100.98 | 102.1 | 257152.0 |
| 2015-05-07 | GF | Futures | 368.146 | 370.338 | 367.416 | 369.306 | 1727.0 |
| 2015-05-07 | GSCI | Futures | 767.1 | 767.1 | 748.46 | 750.59 | 2810.0 |
| 2015-05-07 | HE | Futures | 91.612 | 91.72 | 90.444 | 90.689 | 20972.0 |
| 2015-05-07 | HG | Futures | 3.6731 | 3.6857 | 3.6449 | 3.6612 | 38306.0 |
| 2015-05-07 | HH | Futures | 33.571 | 34.203 | 32.927 | 33.219 | 3516.0 |
> showing 50 of 106 rows — these rows as CSV