PREVIEW / futures_daily / 2015-04-29
file: by_date/futures_daily/2015/2015-04-29.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-04-29 | ES | Futures | 2219.37 | 2221.21 | 2198.08 | 2207.02 | 1739720.0 |
| 2015-04-29 | NQ | Futures | 5238.87 | 5240.9 | 5173.85 | 5201.14 | 290967.0 |
| 2015-04-29 | YM | Futures | 18461.6 | 18480.0 | 18283.6 | 18364.4 | 202232.0 |
| 2015-04-29 | CL | Futures | 96.67 | 100.74 | 96.01 | 99.47 | 411097.0 |
| 2015-04-29 | GC | Futures | 1585.1 | 1587.8 | 1571.1 | 1583.3 | 141075.0 |
| 2015-04-29 | ZN | Futures | 121.93856 | 122.101362 | 121.331753 | 121.731358 | 2026714.0 |
| 2015-04-29 | A6 | Futures | 0.78938 | 0.79441 | 0.78455 | 0.79037 | 142176.0 |
| 2015-04-29 | AD | Futures | 0.84865 | 0.85427 | 0.84518 | 0.84937 | 79515.0 |
| 2015-04-29 | ALI | Futures | 2587.94 | 2587.94 | 2568.29 | 2568.29 | 3.0 |
| 2015-04-29 | B | Futures | 62.16 | 64.15 | 61.75 | 63.34 | 109670.0 |
| 2015-04-29 | B6 | Futures | 1.6142 | 1.6309 | 1.6129 | 1.6237 | 143655.0 |
| 2015-04-29 | BFX | Futures | 4529.5 | 4529.5 | 4441.2 | 4441.2 | 20.0 |
| 2015-04-29 | BR | Futures | 0.19164 | 0.19361 | 0.1907 | 0.19153 | 1877.0 |
| 2015-04-29 | BZ | Futures | 61.52 | 63.53 | 61.19 | 62.73 | 15245.0 |
| 2015-04-29 | C | Futures | 2144.0 | 2161.0 | 2135.0 | 2148.0 | 3241.0 |
| 2015-04-29 | CB | Futures | 158.188 | 158.188 | 154.506 | 156.165 | 65.0 |
| 2015-04-29 | CC | Futures | 2167.0 | 2175.0 | 2140.0 | 2170.0 | 16720.0 |
| 2015-04-29 | CNH | Futures | 6.9999 | 6.9999 | 6.9927 | 6.9938 | 42.0 |
| 2015-04-29 | CSC | Futures | 4.487 | 4.487 | 4.436 | 4.458 | 66.0 |
| 2015-04-29 | CT | Futures | 83.83 | 84.77 | 83.15 | 84.51 | 12890.0 |
| 2015-04-29 | DC | Futures | 36.77 | 36.89 | 36.37 | 36.71 | 475.0 |
| 2015-04-29 | DX | Futures | 90.371 | 90.418 | 88.967 | 89.505 | 101559.0 |
| 2015-04-29 | E1 | Futures | 1.33686 | 1.36668 | 1.33341 | 1.35852 | 40044.0 |
| 2015-04-29 | E6 | Futures | 1.29176 | 1.31645 | 1.28941 | 1.3074 | 457377.0 |
| 2015-04-29 | E7 | Futures | 1.2843 | 1.309 | 1.2822 | 1.2998 | 10994.0 |
| 2015-04-29 | EBM | Futures | 285.23 | 288.04 | 284.83 | 286.03 | 15615.0 |
| 2015-04-29 | ED | Futures | 95.5429 | 95.5477 | 95.5381 | 95.5477 | 160441.0 |
| 2015-04-29 | ER | Futures | 98.082 | 98.087 | 98.073 | 98.077 | 58831.0 |
| 2015-04-29 | EW | Futures | 1601.4 | 1602.2 | 1582.9 | 1586.4 | 13986.0 |
| 2015-04-29 | FBTP | Futures | 103.03 | 103.06 | 102.01 | 102.12 | 130162.0 |
| 2015-04-29 | FBTS | Futures | 99.714 | 99.723 | 99.626 | 99.643 | 24031.0 |
| 2015-04-29 | FCE | Futures | 4218.3 | 4240.5 | 4083.1 | 4105.3 | 155170.0 |
| 2015-04-29 | FDAX | Futures | 13132.1 | 13216.4 | 12630.1 | 12728.3 | 182194.0 |
| 2015-04-29 | FDIV | Futures | 158.2 | 158.25 | 157.51 | 157.51 | 4.0 |
| 2015-04-29 | FESX | Futures | 2696.2 | 2710.2 | 2604.1 | 2626.2 | 1574854.0 |
| 2015-04-29 | FGBL | Futures | 141.43 | 141.45 | 140.02 | 140.13 | 1151159.0 |
| 2015-04-29 | FGBM | Futures | 124.86 | 124.89 | 124.41 | 124.46 | 934749.0 |
| 2015-04-29 | FGBS | Futures | 111.298 | 111.308 | 111.218 | 111.228 | 431912.0 |
| 2015-04-29 | FGBX | Futures | 176.79 | 176.87 | 171.98 | 172.48 | 62565.0 |
| 2015-04-29 | FMWO | Futures | 5911.2 | 5923.5 | 5902.6 | 5916.1 | 95.0 |
| 2015-04-29 | FOAT | Futures | 130.28 | 130.35 | 128.8 | 128.88 | 113370.0 |
| 2015-04-29 | FTDX | Futures | 1552.8 | 1556.1 | 1495.1 | 1507.7 | 142.0 |
| 2015-04-29 | FTI | Futures | 434.58 | 435.93 | 421.17 | 423.22 | 41388.0 |
| 2015-04-29 | FTUK | Futures | 5518.1 | 5536.2 | 5431.4 | 5454.7 | 125024.0 |
| 2015-04-29 | FVSA | Futures | 1669.84 | 1812.29 | 1669.84 | 1776.68 | 18676.0 |
| 2015-04-29 | FXXP | Futures | 309.3 | 310.5 | 300.4 | 302.4 | 19547.0 |
| 2015-04-29 | G | Futures | 103.92 | 103.93 | 102.84 | 102.95 | 266998.0 |
| 2015-04-29 | GF | Futures | 365.826 | 367.416 | 363.163 | 366.127 | 2450.0 |
| 2015-04-29 | GSCI | Futures | 741.48 | 755.02 | 736.46 | 749.82 | 518.0 |
| 2015-04-29 | HE | Futures | 85.593 | 88.774 | 85.42 | 87.126 | 751.0 |
> showing 50 of 107 rows — these rows as CSV