PREVIEW / futures_daily / 2015-05-19
file: by_date/futures_daily/2015/2015-05-19.parquet size: 9 KB rows: 107
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-19 | ES | Futures | 2236.2 | 2243.82 | 2230.41 | 2233.83 | 1001397.0 |
| 2015-05-19 | NQ | Futures | 5235.97 | 5255.41 | 5220.58 | 5226.1 | 127690.0 |
| 2015-05-19 | YM | Futures | 18686.6 | 18753.1 | 18643.7 | 18702.0 | 96874.0 |
| 2015-05-19 | CL | Futures | 101.37 | 101.54 | 97.35 | 97.45 | 336779.0 |
| 2015-05-19 | GC | Futures | 1603.4 | 1603.5 | 1576.9 | 1578.9 | 178961.0 |
| 2015-05-19 | ZN | Futures | 120.576945 | 121.02095 | 120.073739 | 120.325342 | 1691402.0 |
| 2015-05-19 | A6 | Futures | 0.78702 | 0.78879 | 0.77854 | 0.77962 | 82160.0 |
| 2015-05-19 | AD | Futures | 0.83977 | 0.8415 | 0.83313 | 0.83517 | 62381.0 |
| 2015-05-19 | ALI | Futures | 2492.79 | 2492.79 | 2492.79 | 2492.79 | 0.0 |
| 2015-05-19 | B | Futures | 63.0 | 63.2 | 60.87 | 60.94 | 253354.0 |
| 2015-05-19 | B6 | Futures | 1.6476 | 1.6491 | 1.6256 | 1.6309 | 138660.0 |
| 2015-05-19 | BFX | Futures | 4496.5 | 4511.6 | 4496.5 | 4511.6 | 1.0 |
| 2015-05-19 | BR | Futures | 0.18882 | 0.18882 | 0.18568 | 0.18771 | 1215.0 |
| 2015-05-19 | BZ | Futures | 62.45 | 62.57 | 60.3 | 60.35 | 23142.0 |
| 2015-05-19 | C | Futures | 2248.0 | 2269.0 | 2245.0 | 2267.0 | 10274.0 |
| 2015-05-19 | CB | Futures | 157.783 | 157.804 | 157.177 | 157.804 | 8.0 |
| 2015-05-19 | CC | Futures | 2309.0 | 2325.0 | 2298.0 | 2320.0 | 10523.0 |
| 2015-05-19 | CNH | Futures | 6.9842 | 6.9869 | 6.9818 | 6.9842 | 53.0 |
| 2015-05-19 | CSC | Futures | 4.503 | 4.514 | 4.49 | 4.5 | 61.0 |
| 2015-05-19 | CT | Futures | 81.73 | 82.18 | 80.68 | 81.06 | 23852.0 |
| 2015-05-19 | DC | Futures | 37.47 | 37.58 | 36.95 | 37.09 | 293.0 |
| 2015-05-19 | DX | Futures | 88.385 | 89.723 | 88.385 | 89.543 | 62671.0 |
| 2015-05-19 | E1 | Futures | 1.37738 | 1.37955 | 1.35916 | 1.36069 | 26490.0 |
| 2015-05-19 | E6 | Futures | 1.33115 | 1.33244 | 1.30787 | 1.31222 | 329743.0 |
| 2015-05-19 | E7 | Futures | 1.3232 | 1.3246 | 1.3003 | 1.3046 | 9012.0 |
| 2015-05-19 | EBM | Futures | 292.66 | 292.66 | 290.2 | 292.25 | 9814.0 |
| 2015-05-19 | ED | Futures | 95.5693 | 95.5693 | 95.5621 | 95.5645 | 150070.0 |
| 2015-05-19 | ER | Futures | 98.077 | 98.087 | 98.077 | 98.077 | 33937.0 |
| 2015-05-19 | EW | Futures | 1618.4 | 1624.2 | 1610.6 | 1614.3 | 11889.0 |
| 2015-05-19 | FBTP | Futures | 99.31 | 100.33 | 99.18 | 99.62 | 133397.0 |
| 2015-05-19 | FBTS | Futures | 99.723 | 99.83 | 99.723 | 99.812 | 26560.0 |
| 2015-05-19 | FCE | Futures | 4153.2 | 4226.3 | 4145.3 | 4219.2 | 104552.0 |
| 2015-05-19 | FDAX | Futures | 12946.3 | 13189.3 | 12930.8 | 13184.3 | 119504.0 |
| 2015-05-19 | FDIV | Futures | 160.61 | 161.95 | 160.47 | 161.95 | 15.0 |
| 2015-05-19 | FESX | Futures | 2641.6 | 2695.4 | 2637.9 | 2693.9 | 1153218.0 |
| 2015-05-19 | FGBL | Futures | 136.41 | 137.5 | 136.36 | 136.72 | 988964.0 |
| 2015-05-19 | FGBM | Futures | 123.84 | 124.18 | 123.82 | 123.92 | 595818.0 |
| 2015-05-19 | FGBS | Futures | 111.173 | 111.238 | 111.173 | 111.193 | 262232.0 |
| 2015-05-19 | FGBX | Futures | 158.3 | 162.08 | 158.04 | 159.96 | 50327.0 |
| 2015-05-19 | FMWO | Futures | 5991.3 | 5991.3 | 5969.1 | 5975.3 | 7.0 |
| 2015-05-19 | FOAT | Futures | 125.33 | 126.49 | 125.28 | 125.73 | 116673.0 |
| 2015-05-19 | FTDX | Futures | 1586.6 | 1634.9 | 1586.6 | 1629.7 | 418.0 |
| 2015-05-19 | FTI | Futures | 428.84 | 435.29 | 427.97 | 434.68 | 31171.0 |
| 2015-05-19 | FTUK | Futures | 5493.7 | 5515.4 | 5483.0 | 5498.4 | 80119.0 |
| 2015-05-19 | FVSA | Futures | 1600.26 | 1600.26 | 1557.74 | 1565.47 | 18750.0 |
| 2015-05-19 | FXXP | Futures | 306.4 | 310.2 | 306.4 | 310.2 | 11810.0 |
| 2015-05-19 | G | Futures | 102.12 | 102.71 | 101.54 | 101.89 | 217760.0 |
| 2015-05-19 | GF | Futures | 368.092 | 369.877 | 367.242 | 369.197 | 3985.0 |
| 2015-05-19 | GSCI | Futures | 752.72 | 753.32 | 742.78 | 743.55 | 293.0 |
| 2015-05-19 | HE | Futures | 89.331 | 90.58 | 88.299 | 89.222 | 16175.0 |
> showing 50 of 107 rows — these rows as CSV