PREVIEW / futures_daily / 2015-05-18
file: by_date/futures_daily/2015/2015-05-18.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-18 | ES | Futures | 2228.31 | 2238.3 | 2220.95 | 2235.41 | 917101.0 |
| 2015-05-18 | NQ | Futures | 5214.49 | 5245.25 | 5190.4 | 5233.06 | 128602.0 |
| 2015-05-18 | YM | Futures | 18652.9 | 18709.1 | 18601.7 | 18676.4 | 90043.0 |
| 2015-05-18 | CL | Futures | 101.87 | 103.7 | 100.58 | 101.23 | 305118.0 |
| 2015-05-18 | GC | Futures | 1600.0 | 1612.1 | 1597.9 | 1606.3 | 120822.0 |
| 2015-05-18 | ZN | Futures | 121.213352 | 121.331753 | 120.547344 | 120.650945 | 1040118.0 |
| 2015-05-18 | A6 | Futures | 0.79155 | 0.79293 | 0.78544 | 0.78583 | 51245.0 |
| 2015-05-18 | AD | Futures | 0.84947 | 0.84967 | 0.83854 | 0.83905 | 47009.0 |
| 2015-05-18 | ALI | Futures | 2492.79 | 2492.79 | 2492.79 | 2492.79 | 0.0 |
| 2015-05-18 | B | Futures | 63.69 | 64.61 | 62.75 | 63.08 | 198219.0 |
| 2015-05-18 | B6 | Futures | 1.655 | 1.6571 | 1.6457 | 1.6477 | 81184.0 |
| 2015-05-18 | BFX | Futures | 4444.5 | 4444.5 | 4411.2 | 4443.9 | 20.0 |
| 2015-05-18 | BR | Futures | 0.18945 | 0.18945 | 0.18751 | 0.18791 | 526.0 |
| 2015-05-18 | BZ | Futures | 63.04 | 64.0 | 62.15 | 62.47 | 14256.0 |
| 2015-05-18 | C | Futures | 2235.0 | 2248.0 | 2227.0 | 2247.0 | 10510.0 |
| 2015-05-18 | CB | Futures | 157.783 | 158.997 | 157.783 | 157.783 | 4.0 |
| 2015-05-18 | CC | Futures | 2307.0 | 2323.0 | 2296.0 | 2316.0 | 14513.0 |
| 2015-05-18 | CNH | Futures | 6.981 | 6.9842 | 6.981 | 6.9819 | 13.0 |
| 2015-05-18 | CSC | Futures | 4.514 | 4.548 | 4.506 | 4.546 | 52.0 |
| 2015-05-18 | CT | Futures | 84.2 | 84.31 | 81.72 | 81.78 | 19301.0 |
| 2015-05-18 | DC | Futures | 37.22 | 37.54 | 37.09 | 37.4 | 198.0 |
| 2015-05-18 | DX | Futures | 87.615 | 88.564 | 87.592 | 88.516 | 36971.0 |
| 2015-05-18 | E1 | Futures | 1.39242 | 1.39357 | 1.37687 | 1.37776 | 13704.0 |
| 2015-05-18 | E6 | Futures | 1.34644 | 1.34667 | 1.32903 | 1.32974 | 205989.0 |
| 2015-05-18 | E7 | Futures | 1.3388 | 1.3389 | 1.3215 | 1.322 | 6038.0 |
| 2015-05-18 | EBM | Futures | 287.74 | 295.94 | 287.74 | 295.12 | 11612.0 |
| 2015-05-18 | ED | Futures | 95.5693 | 95.5716 | 95.5669 | 95.5669 | 107084.0 |
| 2015-05-18 | ER | Futures | 98.077 | 98.082 | 98.073 | 98.073 | 38303.0 |
| 2015-05-18 | EW | Futures | 1601.8 | 1618.9 | 1598.4 | 1618.1 | 16226.0 |
| 2015-05-18 | FBTP | Futures | 99.95 | 100.12 | 98.89 | 99.02 | 102637.0 |
| 2015-05-18 | FBTS | Futures | 99.714 | 99.723 | 99.661 | 99.714 | 17755.0 |
| 2015-05-18 | FCE | Futures | 4130.7 | 4144.4 | 4062.6 | 4132.0 | 92529.0 |
| 2015-05-18 | FDAX | Futures | 12737.2 | 12920.2 | 12631.8 | 12870.3 | 101111.0 |
| 2015-05-18 | FESX | Futures | 2621.7 | 2637.9 | 2586.4 | 2629.1 | 955144.0 |
| 2015-05-18 | FGBL | Futures | 136.34 | 136.67 | 136.14 | 136.38 | 566665.0 |
| 2015-05-18 | FGBM | Futures | 123.81 | 123.87 | 123.75 | 123.84 | 375097.0 |
| 2015-05-18 | FGBS | Futures | 111.173 | 111.178 | 111.163 | 111.173 | 122853.0 |
| 2015-05-18 | FGBX | Futures | 158.6 | 159.94 | 157.43 | 158.16 | 26953.0 |
| 2015-05-18 | FMWO | Futures | 5959.3 | 5974.1 | 5958.0 | 5974.1 | 34.0 |
| 2015-05-18 | FOAT | Futures | 125.43 | 125.6 | 125.09 | 125.26 | 83735.0 |
| 2015-05-18 | FTDX | Futures | 1571.5 | 1585.6 | 1562.6 | 1583.7 | 282.0 |
| 2015-05-18 | FTI | Futures | 428.31 | 429.32 | 421.52 | 426.79 | 31217.0 |
| 2015-05-18 | FTUK | Futures | 5485.0 | 5521.3 | 5449.9 | 5481.5 | 81792.0 |
| 2015-05-18 | FVSA | Futures | 1681.44 | 1712.36 | 1611.86 | 1619.59 | 14281.0 |
| 2015-05-18 | FXXP | Futures | 303.8 | 305.3 | 301.2 | 304.7 | 18216.0 |
| 2015-05-18 | G | Futures | 102.71 | 102.73 | 101.85 | 101.97 | 135083.0 |
| 2015-05-18 | GF | Futures | 370.557 | 370.642 | 366.859 | 368.474 | 3843.0 |
| 2015-05-18 | GSCI | Futures | 767.93 | 769.71 | 760.45 | 762.58 | 106.0 |
| 2015-05-18 | HE | Futures | 90.254 | 90.254 | 89.087 | 89.494 | 15252.0 |
| 2015-05-18 | HG | Futures | 3.6706 | 3.7001 | 3.6299 | 3.6468 | 43986.0 |
> showing 50 of 106 rows — these rows as CSV