PREVIEW / futures_daily / 2011-01-12
file: by_date/futures_daily/2011/2011-01-12.parquet size: 9 KB rows: 93
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-01-12 | ES | Futures | 1250.09 | 1264.12 | 1249.35 | 1263.38 | 1604117.0 |
| 2011-01-12 | NQ | Futures | 2595.31 | 2618.86 | 2593.03 | 2616.31 | 176801.0 |
| 2011-01-12 | YM | Futures | 10869.9 | 10978.4 | 10861.5 | 10957.9 | 87477.0 |
| 2011-01-12 | CL | Futures | 186.85 | 189.33 | 186.05 | 188.25 | 382686.0 |
| 2011-01-12 | GC | Futures | 1877.3 | 1888.0 | 1870.7 | 1883.7 | 147502.0 |
| 2011-01-12 | ZN | Futures | 100.296565 | 100.374556 | 99.841617 | 100.296565 | 1086172.0 |
| 2011-01-12 | A6 | Futures | 0.8274 | 0.83876 | 0.82553 | 0.83851 | 108687.0 |
| 2011-01-12 | AD | Futures | 1.00108 | 1.00634 | 1.00098 | 1.00336 | 70261.0 |
| 2011-01-12 | B | Futures | 82.81 | 83.62 | 82.48 | 83.09 | 224551.0 |
| 2011-01-12 | B6 | Futures | 1.6173 | 1.6362 | 1.6156 | 1.6346 | 138823.0 |
| 2011-01-12 | BR | Futures | 0.25411 | 0.25495 | 0.25411 | 0.2548 | 87.0 |
| 2011-01-12 | BZ | Futures | 88.31 | 89.05 | 88.22 | 88.51 | 811.0 |
| 2011-01-12 | C | Futures | 2161.0 | 2185.0 | 2158.0 | 2163.0 | 5828.0 |
| 2011-01-12 | CB | Futures | 113.815 | 114.695 | 113.815 | 113.815 | 14.0 |
| 2011-01-12 | CC | Futures | 2383.0 | 2422.0 | 2381.0 | 2401.0 | 6518.0 |
| 2011-01-12 | CSC | Futures | 3.526 | 3.551 | 3.524 | 3.537 | 43.0 |
| 2011-01-12 | CT | Futures | 128.06 | 130.55 | 126.65 | 126.88 | 17148.0 |
| 2011-01-12 | DC | Futures | 24.59 | 25.08 | 24.31 | 24.49 | 539.0 |
| 2011-01-12 | DX | Futures | 80.929 | 80.999 | 80.056 | 80.106 | 33888.0 |
| 2011-01-12 | E1 | Futures | 1.34665 | 1.35753 | 1.34429 | 1.35608 | 42917.0 |
| 2011-01-12 | E6 | Futures | 1.53465 | 1.55476 | 1.53287 | 1.5531 | 465059.0 |
| 2011-01-12 | E7 | Futures | 1.5229 | 1.5431 | 1.5216 | 1.5415 | 8760.0 |
| 2011-01-12 | EBM | Futures | 229.68 | 236.94 | 229.22 | 231.95 | 14557.0 |
| 2011-01-12 | ED | Futures | 94.8004 | 94.8194 | 94.7956 | 94.8147 | 180955.0 |
| 2011-01-12 | ER | Futures | 97.345 | 97.37 | 97.34 | 97.345 | 94065.0 |
| 2011-01-12 | EW | Futures | 904.3 | 912.1 | 903.7 | 910.4 | 17749.0 |
| 2011-01-12 | FBTP | Futures | 63.59 | 63.83 | 63.49 | 63.69 | 8621.0 |
| 2011-01-12 | FCE | Futures | 2578.3 | 2640.1 | 2578.3 | 2635.7 | 751.0 |
| 2011-01-12 | FDAX | Futures | 7445.1 | 7599.9 | 7444.6 | 7579.0 | 142601.0 |
| 2011-01-12 | FESX | Futures | 1734.6 | 1789.9 | 1734.6 | 1784.3 | 1385164.0 |
| 2011-01-12 | FEU3 | Futures | 97.904 | 97.904 | 97.904 | 97.904 | 83.0 |
| 2011-01-12 | FGBL | Futures | 99.74 | 99.74 | 98.66 | 98.75 | 1161761.0 |
| 2011-01-12 | FGBM | Futures | 105.22 | 105.22 | 104.61 | 104.63 | 671217.0 |
| 2011-01-12 | FGBS | Futures | 107.523 | 107.528 | 107.321 | 107.331 | 637987.0 |
| 2011-01-12 | FGBX | Futures | 98.07 | 98.07 | 96.3 | 96.52 | 4767.0 |
| 2011-01-12 | FTDX | Futures | 771.9 | 782.0 | 771.9 | 781.1 | 509.0 |
| 2011-01-12 | FTI | Futures | 288.87 | 291.24 | 288.87 | 291.24 | 609.0 |
| 2011-01-12 | FTUK | Futures | 4145.0 | 4179.8 | 4144.3 | 4170.4 | 102876.0 |
| 2011-01-12 | FXXP | Futures | 184.1 | 184.7 | 183.9 | 184.7 | 911.0 |
| 2011-01-12 | G | Futures | 81.15 | 81.17 | 80.58 | 80.62 | 127767.0 |
| 2011-01-12 | GF | Futures | 309.574 | 312.103 | 308.526 | 310.931 | 2661.0 |
| 2011-01-12 | GSCI | Futures | 1022.32 | 1032.99 | 1022.0 | 1023.91 | 3092.0 |
| 2011-01-12 | HE | Futures | 100.486 | 101.96 | 100.486 | 101.741 | 24887.0 |
| 2011-01-12 | HG | Futures | 5.7953 | 5.9113 | 5.784 | 5.8793 | 29195.0 |
| 2011-01-12 | HO | Futures | 2.1809 | 2.2057 | 2.1764 | 2.193 | 31336.0 |
| 2011-01-12 | HRC | Futures | 2744.7 | 2744.7 | 2744.7 | 2744.7 | 0.0 |
| 2011-01-12 | J1 | Futures | 0.0150757 | 0.0151749 | 0.0150531 | 0.0151574 | 126222.0 |
| 2011-01-12 | J7 | Futures | 0.014964 | 0.015065 | 0.014947 | 0.01505 | 137.0 |
| 2011-01-12 | JB | Futures | 121.04 | 121.18 | 120.89 | 121.07 | 1726.0 |
| 2011-01-12 | KC | Futures | 579.72 | 599.58 | 578.0 | 590.02 | 21218.0 |
> showing 50 of 93 rows — these rows as CSV