PREVIEW / futures_daily / 2013-11-26
file: by_date/futures_daily/2013/2013-11-26.parquet size: 9 KB rows: 103
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-11-26 | ES | Futures | 1850.29 | 1856.2 | 1847.72 | 1851.06 | 1095564.0 |
| 2013-11-26 | NQ | Futures | 3935.71 | 3969.31 | 3931.12 | 3959.26 | 188922.0 |
| 2013-11-26 | YM | Futures | 15970.7 | 16017.4 | 15964.7 | 15979.6 | 99326.0 |
| 2013-11-26 | CL | Futures | 166.68 | 167.53 | 165.3 | 165.74 | 160178.0 |
| 2013-11-26 | GC | Futures | 1654.4 | 1665.9 | 1640.7 | 1643.8 | 113515.0 |
| 2013-11-26 | ZN | Futures | 114.895212 | 115.164287 | 114.810241 | 115.164287 | 2242573.0 |
| 2013-11-26 | A6 | Futures | 0.86563 | 0.86828 | 0.85732 | 0.86167 | 96933.0 |
| 2013-11-26 | AD | Futures | 0.95853 | 0.96005 | 0.95641 | 0.95773 | 49546.0 |
| 2013-11-26 | B | Futures | 112.25 | 112.66 | 111.62 | 112.11 | 86634.0 |
| 2013-11-26 | B6 | Futures | 1.6962 | 1.7024 | 1.6939 | 1.7023 | 89492.0 |
| 2013-11-26 | BR | Futures | 0.22059 | 0.22059 | 0.22059 | 0.22059 | 64.0 |
| 2013-11-26 | BZ | Futures | 113.82 | 114.61 | 113.57 | 114.05 | 7840.0 |
| 2013-11-26 | C | Futures | 1878.0 | 1889.0 | 1853.0 | 1861.0 | 3635.0 |
| 2013-11-26 | CB | Futures | 76.055 | 76.055 | 75.564 | 76.055 | 16.0 |
| 2013-11-26 | CC | Futures | 2080.0 | 2083.0 | 2034.0 | 2055.0 | 11471.0 |
| 2013-11-26 | CNH | Futures | 7.0098 | 7.0123 | 7.0092 | 7.0123 | 65.0 |
| 2013-11-26 | CSC | Futures | 3.474 | 3.474 | 3.474 | 3.474 | 5.0 |
| 2013-11-26 | CT | Futures | 89.46 | 90.82 | 89.18 | 90.24 | 12297.0 |
| 2013-11-26 | DC | Futures | 26.52 | 26.6 | 26.49 | 26.55 | 54.0 |
| 2013-11-26 | DX | Futures | 77.015 | 77.119 | 76.814 | 76.832 | 21770.0 |
| 2013-11-26 | E1 | Futures | 1.40999 | 1.41848 | 1.40987 | 1.41822 | 25067.0 |
| 2013-11-26 | E6 | Futures | 1.59587 | 1.60212 | 1.59539 | 1.602 | 177389.0 |
| 2013-11-26 | E7 | Futures | 1.5853 | 1.5919 | 1.5852 | 1.5917 | 2652.0 |
| 2013-11-26 | ED | Futures | 95.371 | 95.3733 | 95.371 | 95.371 | 36522.0 |
| 2013-11-26 | ER | Futures | 97.867 | 97.881 | 97.857 | 97.876 | 82121.0 |
| 2013-11-26 | EW | Futures | 1332.3 | 1334.1 | 1326.6 | 1330.8 | 15087.0 |
| 2013-11-26 | FBTP | Futures | 81.68 | 82.0 | 81.68 | 81.95 | 31627.0 |
| 2013-11-26 | FBTS | Futures | 95.529 | 95.727 | 95.529 | 95.676 | 5590.0 |
| 2013-11-26 | FCE | Futures | 3328.0 | 3336.6 | 3314.4 | 3316.0 | 68687.0 |
| 2013-11-26 | FDAX | Futures | 10318.9 | 10341.6 | 10308.9 | 10323.3 | 68962.0 |
| 2013-11-26 | FESX | Futures | 2149.8 | 2156.8 | 2144.9 | 2148.4 | 615385.0 |
| 2013-11-26 | FGBL | Futures | 120.39 | 120.73 | 120.3 | 120.66 | 578136.0 |
| 2013-11-26 | FGBM | Futures | 118.37 | 118.51 | 118.31 | 118.48 | 372756.0 |
| 2013-11-26 | FGBS | Futures | 110.558 | 110.588 | 110.553 | 110.578 | 211899.0 |
| 2013-11-26 | FGBX | Futures | 121.09 | 121.61 | 120.82 | 121.4 | 12570.0 |
| 2013-11-26 | FMWO | Futures | 5363.5 | 5363.5 | 5348.4 | 5352.2 | 193.0 |
| 2013-11-26 | FOAT | Futures | 108.67 | 108.94 | 108.59 | 108.89 | 28690.0 |
| 2013-11-26 | FTDX | Futures | 1079.4 | 1081.7 | 1077.9 | 1079.4 | 117.0 |
| 2013-11-26 | FTI | Futures | 342.34 | 342.98 | 340.05 | 340.14 | 17429.0 |
| 2013-11-26 | FTUK | Futures | 5014.2 | 5022.8 | 4971.8 | 4976.7 | 84029.0 |
| 2013-11-26 | FVSA | Futures | 1900.03 | 1912.14 | 1875.83 | 1906.09 | 3718.0 |
| 2013-11-26 | FXXP | Futures | 236.2 | 236.6 | 234.7 | 235.4 | 3637.0 |
| 2013-11-26 | G | Futures | 92.06 | 92.42 | 92.02 | 92.36 | 207141.0 |
| 2013-11-26 | GF | Futures | 262.049 | 265.148 | 262.049 | 264.625 | 2374.0 |
| 2013-11-26 | GSCI | Futures | 1032.99 | 1033.82 | 1028.6 | 1032.74 | 23.0 |
| 2013-11-26 | HE | Futures | 108.604 | 109.57 | 108.423 | 109.178 | 12390.0 |
| 2013-11-26 | HG | Futures | 4.0795 | 4.0915 | 4.0492 | 4.0656 | 34457.0 |
| 2013-11-26 | HH | Futures | 38.508 | 38.709 | 37.927 | 38.709 | 1406.0 |
| 2013-11-26 | HO | Futures | 2.416 | 2.4351 | 2.4083 | 2.4274 | 15366.0 |
| 2013-11-26 | HRC | Futures | 2385.3 | 2385.3 | 2385.3 | 2385.3 | 0.0 |
> showing 50 of 103 rows — these rows as CSV