PREVIEW / futures_daily / 2011-08-12
file: by_date/futures_daily/2011/2011-08-12.parquet size: 9 KB rows: 98
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-08-12 | ES | Futures | 1160.23 | 1178.6 | 1138.88 | 1168.67 | 2720118.0 |
| 2011-08-12 | NQ | Futures | 2457.44 | 2496.73 | 2407.33 | 2479.65 | 292340.0 |
| 2011-08-12 | YM | Futures | 10477.0 | 10691.6 | 10297.4 | 10635.8 | 153442.0 |
| 2011-08-12 | CL | Futures | 163.95 | 167.44 | 161.02 | 163.63 | 350091.0 |
| 2011-08-12 | GC | Futures | 2386.4 | 2391.0 | 2330.1 | 2352.8 | 210578.0 |
| 2011-08-12 | ZN | Futures | 109.938987 | 110.657455 | 109.899072 | 110.590931 | 1193830.0 |
| 2011-08-12 | A6 | Futures | 0.8956 | 0.89752 | 0.88708 | 0.89682 | 148159.0 |
| 2011-08-12 | AD | Futures | 1.01253 | 1.01393 | 1.00524 | 1.00694 | 100125.0 |
| 2011-08-12 | B | Futures | 92.14 | 93.15 | 91.23 | 92.18 | 149685.0 |
| 2011-08-12 | B6 | Futures | 1.6882 | 1.6965 | 1.6811 | 1.6929 | 103119.0 |
| 2011-08-12 | BFX | Futures | 2697.9 | 2727.0 | 2697.9 | 2712.7 | 1918.0 |
| 2011-08-12 | BR | Futures | 0.27325 | 0.27461 | 0.27325 | 0.27461 | 104.0 |
| 2011-08-12 | BZ | Futures | 95.69 | 95.69 | 95.2 | 95.2 | 937.0 |
| 2011-08-12 | C | Futures | 1986.0 | 2002.0 | 1984.0 | 1989.0 | 1660.0 |
| 2011-08-12 | CB | Futures | 108.491 | 109.587 | 108.491 | 109.587 | 5.0 |
| 2011-08-12 | CC | Futures | 2270.0 | 2292.0 | 2261.0 | 2279.0 | 10687.0 |
| 2011-08-12 | CSC | Futures | 4.644 | 4.725 | 4.644 | 4.725 | 9.0 |
| 2011-08-12 | CT | Futures | 127.18 | 131.4 | 127.17 | 130.71 | 66.0 |
| 2011-08-12 | DC | Futures | 31.45 | 32.56 | 30.93 | 32.38 | 975.0 |
| 2011-08-12 | DX | Futures | 74.078 | 74.331 | 73.776 | 74.022 | 17278.0 |
| 2011-08-12 | E1 | Futures | 1.71381 | 1.73473 | 1.68164 | 1.68687 | 48661.0 |
| 2011-08-12 | E6 | Futures | 1.6902 | 1.69673 | 1.67974 | 1.69103 | 275331.0 |
| 2011-08-12 | E7 | Futures | 1.6775 | 1.6845 | 1.6677 | 1.6787 | 3733.0 |
| 2011-08-12 | ED | Futures | 94.8906 | 94.8953 | 94.862 | 94.8763 | 198140.0 |
| 2011-08-12 | ER | Futures | 97.628 | 97.653 | 97.549 | 97.583 | 160646.0 |
| 2011-08-12 | EW | Futures | 827.3 | 842.1 | 809.2 | 837.1 | 33568.0 |
| 2011-08-12 | FBTP | Futures | 64.14 | 64.28 | 63.86 | 64.11 | 6230.0 |
| 2011-08-12 | FCE | Futures | 2174.5 | 2263.9 | 2111.3 | 2249.6 | 14294.0 |
| 2011-08-12 | FDAX | Futures | 6217.1 | 6483.2 | 6069.1 | 6405.2 | 206477.0 |
| 2011-08-12 | FESX | Futures | 1425.9 | 1488.1 | 1387.4 | 1475.9 | 2299510.0 |
| 2011-08-12 | FEU3 | Futures | 98.129 | 98.129 | 98.104 | 98.124 | 178.0 |
| 2011-08-12 | FGBL | Futures | 107.09 | 107.34 | 106.3 | 106.66 | 802973.0 |
| 2011-08-12 | FGBM | Futures | 109.27 | 109.42 | 108.87 | 109.08 | 464156.0 |
| 2011-08-12 | FGBS | Futures | 108.934 | 108.954 | 108.721 | 108.825 | 485220.0 |
| 2011-08-12 | FGBX | Futures | 104.83 | 105.54 | 103.53 | 104.04 | 5836.0 |
| 2011-08-12 | FTDX | Futures | 642.6 | 668.9 | 638.6 | 663.1 | 893.0 |
| 2011-08-12 | FTI | Futures | 233.24 | 238.99 | 227.32 | 237.81 | 1252.0 |
| 2011-08-12 | FTUK | Futures | 3675.4 | 3773.1 | 3586.2 | 3739.2 | 159631.0 |
| 2011-08-12 | FVSA | Futures | 13389.17 | 13389.17 | 12186.09 | 12904.06 | 2973.0 |
| 2011-08-12 | FXXP | Futures | 154.0 | 161.4 | 153.1 | 160.3 | 3848.0 |
| 2011-08-12 | G | Futures | 89.79 | 90.06 | 89.5 | 89.59 | 110818.0 |
| 2011-08-12 | GF | Futures | 313.453 | 317.002 | 313.282 | 314.884 | 1160.0 |
| 2011-08-12 | GSCI | Futures | 1013.42 | 1016.78 | 1003.16 | 1003.16 | 676.0 |
| 2011-08-12 | HE | Futures | 107.756 | 109.435 | 107.176 | 109.283 | 12717.0 |
| 2011-08-12 | HG | Futures | 5.3473 | 5.3711 | 5.2627 | 5.3037 | 34415.0 |
| 2011-08-12 | HO | Futures | 2.345 | 2.3785 | 2.3299 | 2.3509 | 49612.0 |
| 2011-08-12 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-12 | J1 | Futures | 0.01636 | 0.0164379 | 0.0163298 | 0.0163763 | 77931.0 |
| 2011-08-12 | J7 | Futures | 0.016251 | 0.016326 | 0.016223 | 0.016267 | 353.0 |
| 2011-08-12 | JB | Futures | 123.69 | 123.87 | 123.51 | 123.76 | 3314.0 |
> showing 50 of 98 rows — these rows as CSV