PREVIEW / futures_daily / 2011-12-12
file: by_date/futures_daily/2011/2011-12-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-12-12 | ES | Futures | 1253.8 | 1258.29 | 1223.85 | 1233.08 | 908998.0 |
| 2011-12-12 | NQ | Futures | 2649.89 | 2654.46 | 2594.82 | 2618.5 | 95705.0 |
| 2011-12-12 | YM | Futures | 11729.7 | 11752.9 | 11473.4 | 11549.8 | 134117.0 |
| 2011-12-12 | CL | Futures | 186.68 | 186.87 | 182.86 | 183.29 | 279146.0 |
| 2011-12-12 | GC | Futures | 2317.9 | 2320.4 | 2241.7 | 2252.3 | 165096.0 |
| 2011-12-12 | ZN | Futures | 112.152558 | 112.638652 | 112.044537 | 112.517128 | 544443.0 |
| 2011-12-12 | A6 | Futures | 0.89767 | 0.89883 | 0.88495 | 0.8861 | 22159.0 |
| 2011-12-12 | AD | Futures | 0.98234 | 0.98335 | 0.97381 | 0.97572 | 22783.0 |
| 2011-12-12 | B | Futures | 96.7 | 96.74 | 95.3 | 95.43 | 109479.0 |
| 2011-12-12 | B6 | Futures | 1.6345 | 1.6357 | 1.6228 | 1.6272 | 30802.0 |
| 2011-12-12 | BFX | Futures | 2480.0 | 2480.0 | 2441.9 | 2441.9 | 411.0 |
| 2011-12-12 | BR | Futures | 0.25036 | 0.25036 | 0.25036 | 0.25036 | 52.0 |
| 2011-12-12 | BZ | Futures | 102.51 | 102.59 | 101.18 | 101.28 | 479.0 |
| 2011-12-12 | C | Futures | 1356.0 | 1493.0 | 1312.0 | 1447.0 | 29941.0 |
| 2011-12-12 | CB | Futures | 89.077 | 89.077 | 88.929 | 88.929 | 23.0 |
| 2011-12-12 | CC | Futures | 1595.0 | 1741.0 | 1537.0 | 1691.0 | 32916.0 |
| 2011-12-12 | CSC | Futures | 3.932 | 3.932 | 3.908 | 3.932 | 10.0 |
| 2011-12-12 | CT | Futures | 116.49 | 117.0 | 112.13 | 112.26 | 12255.0 |
| 2011-12-12 | DC | Futures | 28.24 | 28.31 | 28.02 | 28.31 | 123.0 |
| 2011-12-12 | DX | Futures | 77.242 | 78.216 | 77.096 | 78.082 | 17357.0 |
| 2011-12-12 | E1 | Futures | 1.41961 | 1.42184 | 1.40044 | 1.40399 | 13369.0 |
| 2011-12-12 | E6 | Futures | 1.59812 | 1.60015 | 1.57505 | 1.5778 | 85459.0 |
| 2011-12-12 | E7 | Futures | 1.5845 | 1.5854 | 1.5607 | 1.5634 | 973.0 |
| 2011-12-12 | EBM | Futures | 229.31 | 229.97 | 227.35 | 229.64 | 6091.0 |
| 2011-12-12 | ED | Futures | 94.9435 | 94.9483 | 94.9196 | 94.9292 | 146265.0 |
| 2011-12-12 | ER | Futures | 97.174 | 97.223 | 97.154 | 97.174 | 107148.0 |
| 2011-12-12 | EW | Futures | 890.3 | 891.4 | 865.2 | 874.9 | 47499.0 |
| 2011-12-12 | FBTP | Futures | 59.03 | 59.03 | 56.88 | 58.11 | 11074.0 |
| 2011-12-12 | FBTS | Futures | 77.866 | 78.308 | 77.577 | 78.308 | 823.0 |
| 2011-12-12 | FCE | Futures | 2265.3 | 2265.3 | 2198.3 | 2208.4 | 43080.0 |
| 2011-12-12 | FDAX | Futures | 6516.5 | 6525.8 | 6253.2 | 6295.0 | 211600.0 |
| 2011-12-12 | FESX | Futures | 1557.7 | 1559.7 | 1504.2 | 1514.3 | 970438.0 |
| 2011-12-12 | FEU3 | Futures | 97.732 | 97.732 | 97.727 | 97.727 | 1.0 |
| 2011-12-12 | FGBL | Futures | 109.43 | 110.73 | 109.43 | 110.5 | 426276.0 |
| 2011-12-12 | FGBM | Futures | 111.68 | 112.33 | 111.68 | 112.19 | 225062.0 |
| 2011-12-12 | FGBS | Futures | 109.526 | 109.705 | 109.526 | 109.68 | 248998.0 |
| 2011-12-12 | FGBX | Futures | 112.45 | 115.1 | 112.36 | 114.66 | 3561.0 |
| 2011-12-12 | FTDX | Futures | 623.8 | 623.8 | 617.3 | 617.7 | 250.0 |
| 2011-12-12 | FTI | Futures | 255.93 | 255.93 | 249.6 | 249.98 | 4086.0 |
| 2011-12-12 | FTUK | Futures | 3972.8 | 3973.1 | 3872.9 | 3897.0 | 58350.0 |
| 2011-12-12 | FVSA | Futures | 14673.88 | 14813.44 | 14534.32 | 14713.75 | 607.0 |
| 2011-12-12 | FXXP | Futures | 167.9 | 167.9 | 165.7 | 166.6 | 4653.0 |
| 2011-12-12 | G | Futures | 93.73 | 94.14 | 93.62 | 93.89 | 78359.0 |
| 2011-12-12 | GF | Futures | 305.394 | 308.356 | 303.509 | 308.033 | 2880.0 |
| 2011-12-12 | GSCI | Futures | 1001.61 | 1005.53 | 999.73 | 1003.49 | 1845.0 |
| 2011-12-12 | HE | Futures | 106.544 | 107.53 | 105.65 | 106.76 | 16598.0 |
| 2011-12-12 | HG | Futures | 4.7049 | 4.7108 | 4.5307 | 4.569 | 35326.0 |
| 2011-12-12 | HO | Futures | 2.3726 | 2.3738 | 2.3498 | 2.3553 | 15420.0 |
| 2011-12-12 | HRC | Futures | 2745.9 | 2745.9 | 2745.9 | 2745.9 | 0.0 |
| 2011-12-12 | J1 | Futures | 0.0162092 | 0.0162217 | 0.0161338 | 0.0161564 | 24567.0 |
> showing 50 of 98 rows — these rows as CSV