PREVIEW / futures_daily / 2013-10-18
file: by_date/futures_daily/2013/2013-10-18.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-18 | ES | Futures | 1774.53 | 1787.63 | 1774.02 | 1783.78 | 1537541.0 |
| 2013-10-18 | NQ | Futures | 3798.75 | 3845.27 | 3797.89 | 3838.38 | 235866.0 |
| 2013-10-18 | YM | Futures | 15220.4 | 15276.2 | 15183.6 | 15239.4 | 126574.0 |
| 2013-10-18 | CL | Futures | 179.71 | 181.45 | 179.25 | 179.9 | 194736.0 |
| 2013-10-18 | GC | Futures | 1744.2 | 1757.5 | 1734.1 | 1738.6 | 104101.0 |
| 2013-10-18 | ZN | Futures | 115.008507 | 115.433363 | 114.937697 | 115.008507 | 990417.0 |
| 2013-10-18 | A6 | Futures | 0.90615 | 0.91135 | 0.90379 | 0.90965 | 61926.0 |
| 2013-10-18 | AD | Futures | 0.98016 | 0.98198 | 0.97915 | 0.98016 | 31970.0 |
| 2013-10-18 | B | Futures | 108.77 | 109.88 | 108.59 | 109.58 | 181537.0 |
| 2013-10-18 | B6 | Futures | 1.6957 | 1.7024 | 1.6936 | 1.6956 | 69946.0 |
| 2013-10-18 | BFX | Futures | 3445.0 | 3451.0 | 3443.8 | 3451.0 | 163.0 |
| 2013-10-18 | BR | Futures | 0.23316 | 0.23451 | 0.23135 | 0.23153 | 126.0 |
| 2013-10-18 | BZ | Futures | 109.62 | 110.51 | 109.26 | 110.24 | 6658.0 |
| 2013-10-18 | C | Futures | 1883.0 | 1886.0 | 1838.0 | 1850.0 | 9082.0 |
| 2013-10-18 | CC | Futures | 2065.0 | 2065.0 | 2003.0 | 2028.0 | 15413.0 |
| 2013-10-18 | CSC | Futures | 3.371 | 3.396 | 3.371 | 3.381 | 16.0 |
| 2013-10-18 | CT | Futures | 98.37 | 99.01 | 97.17 | 97.5 | 11270.0 |
| 2013-10-18 | DC | Futures | 25.82 | 25.92 | 25.69 | 25.8 | 184.0 |
| 2013-10-18 | DX | Futures | 76.005 | 76.052 | 75.795 | 75.964 | 12861.0 |
| 2013-10-18 | E1 | Futures | 1.42439 | 1.4276 | 1.42259 | 1.42477 | 25587.0 |
| 2013-10-18 | E6 | Futures | 1.61369 | 1.61758 | 1.61227 | 1.61451 | 131453.0 |
| 2013-10-18 | E7 | Futures | 1.6033 | 1.607 | 1.602 | 1.6041 | 2216.0 |
| 2013-10-18 | ED | Futures | 95.3494 | 95.3542 | 95.3447 | 95.3494 | 70344.0 |
| 2013-10-18 | ER | Futures | 97.852 | 97.857 | 97.847 | 97.852 | 76980.0 |
| 2013-10-18 | EW | Futures | 1301.1 | 1313.9 | 1301.1 | 1312.4 | 17259.0 |
| 2013-10-18 | FBTP | Futures | 80.31 | 80.68 | 80.3 | 80.59 | 28409.0 |
| 2013-10-18 | FBTS | Futures | 94.552 | 94.655 | 94.517 | 94.612 | 8353.0 |
| 2013-10-18 | FCE | Futures | 3295.8 | 3323.0 | 3288.1 | 3319.5 | 102711.0 |
| 2013-10-18 | FDAX | Futures | 9820.6 | 9841.7 | 9772.3 | 9823.4 | 78559.0 |
| 2013-10-18 | FESX | Futures | 2115.4 | 2124.5 | 2104.9 | 2118.2 | 909735.0 |
| 2013-10-18 | FEU3 | Futures | 98.478 | 98.478 | 98.473 | 98.473 | 18.0 |
| 2013-10-18 | FGBL | Futures | 118.96 | 119.42 | 118.85 | 119.25 | 583469.0 |
| 2013-10-18 | FGBM | Futures | 117.53 | 117.76 | 117.48 | 117.67 | 436966.0 |
| 2013-10-18 | FGBS | Futures | 110.418 | 110.448 | 110.393 | 110.433 | 266674.0 |
| 2013-10-18 | FGBX | Futures | 118.72 | 119.59 | 118.61 | 119.32 | 12430.0 |
| 2013-10-18 | FMWO | Futures | 5228.2 | 5245.9 | 5228.2 | 5245.9 | 50.0 |
| 2013-10-18 | FOAT | Futures | 106.6 | 107.0 | 106.56 | 106.93 | 37200.0 |
| 2013-10-18 | FTDX | Futures | 1037.9 | 1039.3 | 1035.1 | 1039.3 | 210.0 |
| 2013-10-18 | FTI | Futures | 330.9 | 332.45 | 329.73 | 332.15 | 28264.0 |
| 2013-10-18 | FTUK | Futures | 4939.9 | 4953.8 | 4916.7 | 4945.5 | 87516.0 |
| 2013-10-18 | FVSA | Futures | 2221.41 | 2221.41 | 2136.2 | 2136.2 | 8941.0 |
| 2013-10-18 | FXXP | Futures | 231.4 | 231.9 | 230.5 | 231.7 | 12466.0 |
| 2013-10-18 | G | Futures | 92.23 | 92.79 | 92.13 | 92.5 | 133214.0 |
| 2013-10-18 | GF | Futures | 268.616 | 270.068 | 267.89 | 269.14 | 2163.0 |
| 2013-10-18 | GSCI | Futures | 1057.29 | 1067.8 | 1057.29 | 1064.38 | 64.0 |
| 2013-10-18 | HE | Futures | 112.648 | 112.648 | 110.339 | 111.319 | 19224.0 |
| 2013-10-18 | HG | Futures | 4.1797 | 4.2044 | 4.162 | 4.1772 | 42754.0 |
| 2013-10-18 | HH | Futures | 39.637 | 40.331 | 39.36 | 40.182 | 1297.0 |
| 2013-10-18 | HO | Futures | 2.3973 | 2.4296 | 2.3929 | 2.4285 | 42368.0 |
| 2013-10-18 | HRC | Futures | 2349.8 | 2349.8 | 2349.8 | 2349.8 | 0.0 |
> showing 50 of 102 rows — these rows as CSV