PREVIEW / futures_daily / 2013-07-05
file: by_date/futures_daily/2013/2013-07-05.parquet size: 9 KB rows: 104
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-07-05 | ES | Futures | 1657.21 | 1679.61 | 1656.44 | 1676.01 | 1721212.0 |
| 2013-07-05 | NQ | Futures | 3398.24 | 3436.99 | 3386.67 | 3419.93 | 228913.0 |
| 2013-07-05 | YM | Futures | 14788.1 | 14978.4 | 14763.3 | 14942.7 | 167661.0 |
| 2013-07-05 | CL | Futures | 176.09 | 180.6 | 175.42 | 179.8 | 256027.0 |
| 2013-07-05 | GC | Futures | 1663.0 | 1668.8 | 1602.2 | 1609.9 | 227043.0 |
| 2013-07-05 | ZN | Futures | 113.377076 | 113.742039 | 111.833003 | 111.98741 | 1729783.0 |
| 2013-07-05 | A6 | Futures | 0.84809 | 0.857 | 0.84452 | 0.84612 | 170510.0 |
| 2013-07-05 | AD | Futures | 0.95726 | 0.96039 | 0.94799 | 0.95061 | 109328.0 |
| 2013-07-05 | B | Futures | 102.02 | 104.18 | 101.91 | 104.04 | 192043.0 |
| 2013-07-05 | B6 | Futures | 1.601 | 1.6017 | 1.5565 | 1.5615 | 259580.0 |
| 2013-07-05 | BFX | Futures | 3056.8 | 3056.9 | 3051.4 | 3051.4 | 17.0 |
| 2013-07-05 | BR | Futures | 0.21712 | 0.21725 | 0.21569 | 0.21722 | 101.0 |
| 2013-07-05 | BZ | Futures | 102.75 | 104.87 | 102.14 | 104.75 | 11114.0 |
| 2013-07-05 | C | Futures | 1617.0 | 1636.0 | 1604.0 | 1614.0 | 1124.0 |
| 2013-07-05 | CB | Futures | 76.505 | 76.541 | 76.493 | 76.493 | 8.0 |
| 2013-07-05 | CC | Futures | 1680.0 | 1681.0 | 1636.0 | 1647.0 | 12677.0 |
| 2013-07-05 | CSC | Futures | 3.509 | 3.517 | 3.484 | 3.484 | 10.0 |
| 2013-07-05 | CT | Futures | 103.56 | 103.56 | 102.78 | 102.93 | 12.0 |
| 2013-07-05 | DC | Futures | 26.66 | 26.9 | 26.56 | 26.66 | 186.0 |
| 2013-07-05 | DX | Futures | 80.398 | 81.167 | 80.341 | 80.937 | 50501.0 |
| 2013-07-05 | E1 | Futures | 1.35807 | 1.35961 | 1.33108 | 1.33429 | 53525.0 |
| 2013-07-05 | E6 | Futures | 1.53556 | 1.53745 | 1.51149 | 1.51444 | 431229.0 |
| 2013-07-05 | E7 | Futures | 1.5257 | 1.5272 | 1.5017 | 1.5046 | 6150.0 |
| 2013-07-05 | ED | Futures | 95.2534 | 95.2725 | 95.2534 | 95.263 | 162285.0 |
| 2013-07-05 | ER | Futures | 97.827 | 97.847 | 97.827 | 97.842 | 110465.0 |
| 2013-07-05 | EW | Futures | 1191.2 | 1209.2 | 1188.7 | 1206.3 | 21229.0 |
| 2013-07-05 | FBTP | Futures | 77.42 | 77.68 | 76.92 | 77.16 | 29147.0 |
| 2013-07-05 | FBTS | Futures | 92.851 | 93.006 | 92.834 | 92.902 | 8497.0 |
| 2013-07-05 | FCE | Futures | 2956.7 | 2978.8 | 2910.9 | 2912.5 | 122429.0 |
| 2013-07-05 | FDAX | Futures | 8897.2 | 8921.6 | 8664.1 | 8679.7 | 134272.0 |
| 2013-07-05 | FDIV | Futures | 118.41 | 118.41 | 118.16 | 118.16 | 50.0 |
| 2013-07-05 | FESX | Futures | 1858.7 | 1865.7 | 1818.0 | 1822.9 | 1132881.0 |
| 2013-07-05 | FEU3 | Futures | 98.448 | 98.453 | 98.448 | 98.453 | 1.0 |
| 2013-07-05 | FGBL | Futures | 119.12 | 119.25 | 118.39 | 118.61 | 782196.0 |
| 2013-07-05 | FGBM | Futures | 117.17 | 117.32 | 116.87 | 117.02 | 554918.0 |
| 2013-07-05 | FGBS | Futures | 110.357 | 110.382 | 110.293 | 110.357 | 512465.0 |
| 2013-07-05 | FGBX | Futures | 124.21 | 124.38 | 122.27 | 122.85 | 16132.0 |
| 2013-07-05 | FMWO | Futures | 4771.1 | 4771.1 | 4731.8 | 4731.8 | 48.0 |
| 2013-07-05 | FOAT | Futures | 106.34 | 106.41 | 105.79 | 106.01 | 54542.0 |
| 2013-07-05 | FTDX | Futures | 907.0 | 910.3 | 894.3 | 898.1 | 115.0 |
| 2013-07-05 | FTI | Futures | 309.75 | 311.63 | 306.75 | 307.23 | 36798.0 |
| 2013-07-05 | FTUK | Futures | 4774.9 | 4840.2 | 4737.0 | 4760.3 | 135023.0 |
| 2013-07-05 | FVSA | Futures | 3195.7 | 3365.84 | 3143.92 | 3351.05 | 1853.0 |
| 2013-07-05 | FXXP | Futures | 214.3 | 215.4 | 211.6 | 212.0 | 7606.0 |
| 2013-07-05 | G | Futures | 94.75 | 94.78 | 93.7 | 93.87 | 162416.0 |
| 2013-07-05 | GF | Futures | 253.997 | 256.229 | 253.829 | 255.766 | 2397.0 |
| 2013-07-05 | GSCI | Futures | 1031.12 | 1044.53 | 1028.49 | 1040.91 | 371.0 |
| 2013-07-05 | HE | Futures | 100.077 | 101.059 | 99.793 | 100.981 | 19773.0 |
| 2013-07-05 | HG | Futures | 4.0209 | 4.033 | 3.868 | 3.889 | 68974.0 |
| 2013-07-05 | HH | Futures | 40.546 | 40.724 | 39.855 | 40.289 | 678.0 |
> showing 50 of 104 rows — these rows as CSV