PREVIEW / futures_daily / 2014-09-16
file: by_date/futures_daily/2014/2014-09-16.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 |
|---|---|---|---|---|---|---|---|
| 2014-09-16 | ES | Futures | 2064.89 | 2083.43 | 2058.1 | 2080.29 | 2081652.0 |
| 2014-09-16 | NQ | Futures | 4666.62 | 4712.98 | 4640.83 | 4703.41 | 377333.0 |
| 2014-09-16 | YM | Futures | 17201.3 | 17329.1 | 17135.3 | 17301.7 | 176890.0 |
| 2014-09-16 | CL | Futures | 173.13 | 177.29 | 172.4 | 176.71 | 149068.0 |
| 2014-09-16 | GC | Futures | 1617.5 | 1630.6 | 1616.2 | 1622.1 | 123281.0 |
| 2014-09-16 | ZN | Futures | 116.357499 | 116.635726 | 116.328212 | 116.416073 | 1137205.0 |
| 2014-09-16 | A6 | Futures | 0.87219 | 0.87996 | 0.86791 | 0.87792 | 137973.0 |
| 2014-09-16 | AD | Futures | 0.91692 | 0.92434 | 0.9155 | 0.92342 | 75195.0 |
| 2014-09-16 | ALI | Futures | 3032.77 | 3032.77 | 3032.77 | 3032.77 | 0.0 |
| 2014-09-16 | B | Futures | 102.33 | 103.89 | 101.79 | 103.47 | 199768.0 |
| 2014-09-16 | B6 | Futures | 1.7045 | 1.7133 | 1.6976 | 1.7098 | 127204.0 |
| 2014-09-16 | BFX | Futures | 3819.5 | 3823.8 | 3813.9 | 3823.8 | 930.0 |
| 2014-09-16 | BR | Futures | 0.22576 | 0.22786 | 0.22576 | 0.22732 | 83.0 |
| 2014-09-16 | BZ | Futures | 102.97 | 104.61 | 102.53 | 104.2 | 16751.0 |
| 2014-09-16 | C | Futures | 2130.0 | 2154.0 | 2123.0 | 2140.0 | 8194.0 |
| 2014-09-16 | CB | Futures | 147.217 | 149.125 | 147.217 | 148.759 | 21.0 |
| 2014-09-16 | CC | Futures | 2252.0 | 2280.0 | 2249.0 | 2266.0 | 11435.0 |
| 2014-09-16 | CNH | Futures | 7.108 | 7.1272 | 7.1015 | 7.1015 | 8.0 |
| 2014-09-16 | CSC | Futures | 5.129 | 5.2 | 5.129 | 5.19 | 11.0 |
| 2014-09-16 | CT | Futures | 86.15 | 86.16 | 85.48 | 86.14 | 6.0 |
| 2014-09-16 | DC | Futures | 41.01 | 41.84 | 41.01 | 41.76 | 290.0 |
| 2014-09-16 | DX | Futures | 80.095 | 80.209 | 79.744 | 79.958 | 35275.0 |
| 2014-09-16 | E1 | Futures | 1.36803 | 1.37596 | 1.36688 | 1.37212 | 33538.0 |
| 2014-09-16 | E6 | Futures | 1.52412 | 1.53095 | 1.52212 | 1.52659 | 213185.0 |
| 2014-09-16 | E7 | Futures | 1.5144 | 1.5212 | 1.5127 | 1.517 | 3850.0 |
| 2014-09-16 | ED | Futures | 95.423 | 95.4278 | 95.4183 | 95.423 | 143518.0 |
| 2014-09-16 | ER | Futures | 98.014 | 98.019 | 97.999 | 98.004 | 69533.0 |
| 2014-09-16 | EW | Futures | 1472.7 | 1483.2 | 1465.8 | 1478.7 | 44883.0 |
| 2014-09-16 | FBTP | Futures | 94.56 | 94.56 | 94.15 | 94.31 | 56427.0 |
| 2014-09-16 | FBTS | Futures | 98.659 | 98.712 | 98.641 | 98.677 | 14224.0 |
| 2014-09-16 | FCE | Futures | 3521.7 | 3524.9 | 3491.0 | 3506.5 | 162379.0 |
| 2014-09-16 | FDAX | Futures | 10639.2 | 10657.4 | 10558.2 | 10603.4 | 161378.0 |
| 2014-09-16 | FESX | Futures | 2333.2 | 2336.8 | 2310.7 | 2323.1 | 1158720.0 |
| 2014-09-16 | FEU3 | Futures | 98.631 | 98.631 | 98.621 | 98.621 | 7.0 |
| 2014-09-16 | FGBL | Futures | 130.66 | 130.93 | 130.47 | 130.56 | 680050.0 |
| 2014-09-16 | FGBM | Futures | 122.68 | 122.71 | 122.56 | 122.57 | 345344.0 |
| 2014-09-16 | FGBS | Futures | 110.948 | 110.953 | 110.913 | 110.918 | 205862.0 |
| 2014-09-16 | FGBX | Futures | 139.18 | 139.85 | 138.14 | 138.56 | 20264.0 |
| 2014-09-16 | FMWO | Futures | 5737.4 | 5756.3 | 5727.3 | 5756.3 | 1109.0 |
| 2014-09-16 | FOAT | Futures | 120.37 | 120.48 | 120.11 | 120.15 | 60003.0 |
| 2014-09-16 | FTDX | Futures | 1165.8 | 1167.7 | 1161.5 | 1163.9 | 367.0 |
| 2014-09-16 | FTI | Futures | 361.13 | 362.12 | 359.27 | 360.65 | 37558.0 |
| 2014-09-16 | FTUK | Futures | 5251.2 | 5253.9 | 5196.6 | 5231.0 | 167991.0 |
| 2014-09-16 | FVSA | Futures | 1441.14 | 1465.5 | 1441.14 | 1449.26 | 11215.0 |
| 2014-09-16 | FXXP | Futures | 259.7 | 260.5 | 258.3 | 259.2 | 44982.0 |
| 2014-09-16 | G | Futures | 96.11 | 96.25 | 96.0 | 96.05 | 149149.0 |
| 2014-09-16 | GF | Futures | 351.988 | 352.183 | 349.46 | 351.405 | 2851.0 |
| 2014-09-16 | GSCI | Futures | 984.2 | 999.27 | 982.1 | 997.41 | 149.0 |
| 2014-09-16 | HE | Futures | 128.965 | 129.841 | 126.517 | 129.207 | 15842.0 |
| 2014-09-16 | HG | Futures | 3.9137 | 4.0741 | 3.9086 | 4.0158 | 81866.0 |
> showing 50 of 106 rows — these rows as CSV