PREVIEW / futures_daily / 2011-10-21
file: by_date/futures_daily/2011/2011-10-21.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-21 | ES | Futures | 1206.63 | 1233.58 | 1205.88 | 1233.08 | 2115010.0 |
| 2011-10-21 | NQ | Futures | 2621.93 | 2677.29 | 2620.78 | 2664.44 | 259719.0 |
| 2011-10-21 | YM | Futures | 11011.1 | 11300.2 | 11006.3 | 11294.5 | 114108.0 |
| 2011-10-21 | CL | Futures | 162.28 | 166.76 | 161.24 | 163.96 | 296555.0 |
| 2011-10-21 | GC | Futures | 2188.5 | 2227.5 | 2177.5 | 2209.0 | 127052.0 |
| 2011-10-21 | ZN | Futures | 110.356347 | 110.54405 | 110.021162 | 110.396569 | 833448.0 |
| 2011-10-21 | A6 | Futures | 0.8931 | 0.90708 | 0.89108 | 0.90277 | 139542.0 |
| 2011-10-21 | AD | Futures | 0.98344 | 0.99255 | 0.98074 | 0.98985 | 75389.0 |
| 2011-10-21 | B | Futures | 96.09 | 97.81 | 95.52 | 95.79 | 183098.0 |
| 2011-10-21 | B6 | Futures | 1.6472 | 1.6662 | 1.6433 | 1.6625 | 102204.0 |
| 2011-10-21 | BFX | Futures | 2556.3 | 2568.7 | 2556.3 | 2568.7 | 329.0 |
| 2011-10-21 | BR | Futures | 0.25209 | 0.25227 | 0.25024 | 0.25157 | 181.0 |
| 2011-10-21 | BZ | Futures | 101.56 | 103.39 | 101.02 | 101.23 | 1024.0 |
| 2011-10-21 | C | Futures | 1776.0 | 1780.0 | 1749.0 | 1751.0 | 3580.0 |
| 2011-10-21 | CC | Futures | 2021.0 | 2034.0 | 2002.0 | 2012.0 | 7198.0 |
| 2011-10-21 | CSC | Futures | 4.008 | 4.008 | 4.008 | 4.008 | 4.0 |
| 2011-10-21 | CT | Futures | 124.86 | 127.38 | 124.37 | 125.18 | 8670.0 |
| 2011-10-21 | DC | Futures | 28.01 | 28.61 | 27.94 | 28.5 | 178.0 |
| 2011-10-21 | DX | Futures | 75.779 | 76.088 | 75.067 | 75.227 | 33459.0 |
| 2011-10-21 | E1 | Futures | 1.46803 | 1.49165 | 1.46685 | 1.48482 | 27914.0 |
| 2011-10-21 | E6 | Futures | 1.64557 | 1.66099 | 1.63708 | 1.65644 | 290552.0 |
| 2011-10-21 | E7 | Futures | 1.632 | 1.6467 | 1.6232 | 1.6423 | 5054.0 |
| 2011-10-21 | ED | Futures | 94.9555 | 94.965 | 94.9459 | 94.9555 | 109141.0 |
| 2011-10-21 | ER | Futures | 97.169 | 97.204 | 97.169 | 97.174 | 120195.0 |
| 2011-10-21 | EW | Futures | 840.4 | 863.5 | 839.9 | 862.3 | 25386.0 |
| 2011-10-21 | FBTP | Futures | 60.83 | 61.52 | 60.7 | 61.34 | 9947.0 |
| 2011-10-21 | FBTS | Futures | 81.422 | 81.791 | 81.366 | 81.735 | 1099.0 |
| 2011-10-21 | FCE | Futures | 2241.6 | 2277.5 | 2216.9 | 2272.5 | 105282.0 |
| 2011-10-21 | FDAX | Futures | 6328.1 | 6509.5 | 6271.7 | 6487.2 | 170305.0 |
| 2011-10-21 | FESX | Futures | 1525.8 | 1552.4 | 1511.2 | 1547.8 | 1476771.0 |
| 2011-10-21 | FEU3 | Futures | 97.742 | 97.742 | 97.722 | 97.732 | 7.0 |
| 2011-10-21 | FGBL | Futures | 109.45 | 109.87 | 108.84 | 108.96 | 742616.0 |
| 2011-10-21 | FGBM | Futures | 110.29 | 110.58 | 109.98 | 110.07 | 405719.0 |
| 2011-10-21 | FGBS | Futures | 108.845 | 108.954 | 108.785 | 108.81 | 430846.0 |
| 2011-10-21 | FGBX | Futures | 110.4 | 111.32 | 109.49 | 109.83 | 6687.0 |
| 2011-10-21 | FTDX | Futures | 626.5 | 636.2 | 623.8 | 634.3 | 157.0 |
| 2011-10-21 | FTI | Futures | 249.2 | 252.39 | 246.72 | 251.85 | 46910.0 |
| 2011-10-21 | FTUK | Futures | 3866.5 | 3931.9 | 3850.4 | 3921.1 | 111083.0 |
| 2011-10-21 | FVSA | Futures | 16668.16 | 16751.51 | 15334.71 | 15376.38 | 5378.0 |
| 2011-10-21 | FXXP | Futures | 163.0 | 166.3 | 163.0 | 166.2 | 5474.0 |
| 2011-10-21 | G | Futures | 90.82 | 90.82 | 90.09 | 90.3 | 83719.0 |
| 2011-10-21 | GF | Futures | 314.861 | 318.125 | 314.252 | 315.857 | 1756.0 |
| 2011-10-21 | GSCI | Futures | 990.89 | 1002.57 | 986.98 | 987.21 | 87.0 |
| 2011-10-21 | HE | Futures | 115.653 | 116.296 | 114.432 | 115.235 | 12979.0 |
| 2011-10-21 | HG | Futures | 4.0823 | 4.3377 | 4.0717 | 4.2649 | 52719.0 |
| 2011-10-21 | HO | Futures | 2.4306 | 2.472 | 2.4195 | 2.4225 | 50906.0 |
| 2011-10-21 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-10-21 | J1 | Futures | 0.016375 | 0.0166049 | 0.0163474 | 0.016522 | 155975.0 |
| 2011-10-21 | J7 | Futures | 0.016258 | 0.016499 | 0.016258 | 0.016422 | 1017.0 |
| 2011-10-21 | JB | Futures | 124.21 | 124.3 | 124.17 | 124.24 | 1214.0 |
> showing 50 of 97 rows — these rows as CSV