PREVIEW / futures_daily / 2015-03-05
file: by_date/futures_daily/2015/2015-03-05.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-03-05 | ES | Futures | 2197.4 | 2204.74 | 2193.99 | 2200.81 | 1097593.0 |
| 2015-03-05 | NQ | Futures | 5156.63 | 5180.41 | 5143.28 | 5162.72 | 185176.0 |
| 2015-03-05 | YM | Futures | 18423.2 | 18483.3 | 18404.9 | 18454.8 | 89647.0 |
| 2015-03-05 | CL | Futures | 95.51 | 96.96 | 93.64 | 93.92 | 370953.0 |
| 2015-03-05 | GC | Futures | 1569.3 | 1580.6 | 1563.5 | 1564.0 | 131863.0 |
| 2015-03-05 | ZN | Futures | 120.261669 | 120.43833 | 120.026122 | 120.335278 | 74462.0 |
| 2015-03-05 | A6 | Futures | 0.76506 | 0.7676 | 0.75908 | 0.76114 | 99329.0 |
| 2015-03-05 | AD | Futures | 0.81952 | 0.82085 | 0.81341 | 0.81412 | 56982.0 |
| 2015-03-05 | ALI | Futures | 2670.36 | 2670.36 | 2670.36 | 2670.36 | 0.0 |
| 2015-03-05 | B | Futures | 60.22 | 61.11 | 59.62 | 59.99 | 177542.0 |
| 2015-03-05 | B6 | Futures | 1.6049 | 1.6055 | 1.5998 | 1.6022 | 84681.0 |
| 2015-03-05 | BFX | Futures | 4497.1 | 4503.7 | 4497.1 | 4503.7 | 3.0 |
| 2015-03-05 | BR | Futures | 0.18574 | 0.18717 | 0.18426 | 0.18448 | 98.0 |
| 2015-03-05 | BZ | Futures | 59.84 | 60.53 | 59.14 | 59.47 | 27702.0 |
| 2015-03-05 | C | Futures | 2238.0 | 2242.0 | 2218.0 | 2239.0 | 2632.0 |
| 2015-03-05 | CB | Futures | 145.242 | 145.646 | 145.242 | 145.646 | 6.0 |
| 2015-03-05 | CC | Futures | 2211.0 | 2219.0 | 2185.0 | 2212.0 | 11788.0 |
| 2015-03-05 | CNH | Futures | 7.1326 | 7.139 | 7.1326 | 7.1365 | 11.0 |
| 2015-03-05 | CSC | Futures | 4.532 | 4.532 | 4.468 | 4.506 | 52.0 |
| 2015-03-05 | CT | Futures | 81.21 | 82.12 | 80.85 | 81.05 | 11070.0 |
| 2015-03-05 | DC | Futures | 36.71 | 36.84 | 36.23 | 36.62 | 186.0 |
| 2015-03-05 | DX | Futures | 90.852 | 91.453 | 90.738 | 91.244 | 37530.0 |
| 2015-03-05 | E1 | Futures | 1.32557 | 1.32608 | 1.30986 | 1.31025 | 16010.0 |
| 2015-03-05 | E6 | Futures | 1.30352 | 1.30752 | 1.29247 | 1.29717 | 285354.0 |
| 2015-03-05 | E7 | Futures | 1.2955 | 1.2996 | 1.2846 | 1.2894 | 5812.0 |
| 2015-03-05 | EBM | Futures | 299.27 | 301.68 | 296.46 | 296.86 | 16740.0 |
| 2015-03-05 | ED | Futures | 95.457 | 95.4594 | 95.4546 | 95.4594 | 126810.0 |
| 2015-03-05 | ER | Futures | 98.058 | 98.068 | 98.058 | 98.063 | 41229.0 |
| 2015-03-05 | EW | Futures | 1570.8 | 1575.6 | 1567.4 | 1573.5 | 14030.0 |
| 2015-03-05 | FBTP | Futures | 102.49 | 103.28 | 102.37 | 102.98 | 183009.0 |
| 2015-03-05 | FBTS | Futures | 99.528 | 99.714 | 99.51 | 99.626 | 35136.0 |
| 2015-03-05 | FCE | Futures | 4009.0 | 4046.4 | 4000.9 | 4034.6 | 87360.0 |
| 2015-03-05 | FDAX | Futures | 12685.0 | 12806.0 | 12665.6 | 12762.2 | 105452.0 |
| 2015-03-05 | FESX | Futures | 2591.0 | 2614.8 | 2586.7 | 2606.2 | 987103.0 |
| 2015-03-05 | FEU3 | Futures | 98.68 | 98.68 | 98.68 | 98.68 | 6.0 |
| 2015-03-05 | FGBL | Futures | 139.01 | 139.78 | 138.43 | 139.3 | 1358241.0 |
| 2015-03-05 | FGBM | Futures | 124.5 | 124.71 | 124.29 | 124.56 | 910145.0 |
| 2015-03-05 | FGBS | Futures | 111.178 | 111.183 | 111.078 | 111.128 | 741173.0 |
| 2015-03-05 | FGBX | Futures | 166.1 | 168.91 | 164.44 | 167.78 | 70219.0 |
| 2015-03-05 | FMWO | Futures | 5819.0 | 5830.1 | 5819.0 | 5820.2 | 1629.0 |
| 2015-03-05 | FOAT | Futures | 127.67 | 128.15 | 127.12 | 127.82 | 172643.0 |
| 2015-03-05 | FTDX | Futures | 1479.1 | 1496.9 | 1479.1 | 1491.3 | 160.0 |
| 2015-03-05 | FTI | Futures | 418.87 | 422.71 | 418.48 | 422.2 | 29063.0 |
| 2015-03-05 | FTUK | Futures | 5375.1 | 5420.3 | 5368.5 | 5411.4 | 81888.0 |
| 2015-03-05 | FVSA | Futures | 1705.4 | 1741.21 | 1660.64 | 1687.5 | 11391.0 |
| 2015-03-05 | FXXP | Futures | 295.5 | 298.4 | 295.5 | 297.6 | 11141.0 |
| 2015-03-05 | G | Futures | 102.34 | 102.81 | 102.05 | 102.45 | 175740.0 |
| 2015-03-05 | GF | Futures | 349.54 | 350.13 | 345.322 | 348.486 | 2661.0 |
| 2015-03-05 | GSCI | Futures | 716.83 | 716.83 | 710.81 | 712.96 | 76.0 |
| 2015-03-05 | HE | Futures | 92.132 | 92.165 | 89.281 | 89.65 | 16387.0 |
> showing 50 of 107 rows — these rows as CSV