PREVIEW / futures_daily / 2012-10-16
file: by_date/futures_daily/2012/2012-10-16.parquet size: 9 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-16 | ES | Futures | 1461.54 | 1477.31 | 1460.01 | 1475.02 | 1622289.0 |
| 2012-10-16 | NQ | Futures | 3144.05 | 3195.54 | 3140.88 | 3181.73 | 235193.0 |
| 2012-10-16 | YM | Futures | 13042.0 | 13169.9 | 13033.2 | 13136.7 | 114773.0 |
| 2012-10-16 | CL | Futures | 166.39 | 167.23 | 165.48 | 166.78 | 143614.0 |
| 2012-10-16 | GC | Futures | 2320.5 | 2336.0 | 2317.9 | 2331.5 | 105627.0 |
| 2012-10-16 | ZN | Futures | 117.178374 | 117.205842 | 116.725152 | 116.793822 | 906777.0 |
| 2012-10-16 | A6 | Futures | 0.92699 | 0.93035 | 0.92617 | 0.92844 | 106584.0 |
| 2012-10-16 | AD | Futures | 1.02195 | 1.02245 | 1.01422 | 1.01543 | 109835.0 |
| 2012-10-16 | B | Futures | 104.77 | 105.27 | 104.0 | 104.47 | 208778.0 |
| 2012-10-16 | B6 | Futures | 1.6783 | 1.6845 | 1.677 | 1.6823 | 98604.0 |
| 2012-10-16 | BFX | Futures | 2863.8 | 2878.2 | 2854.2 | 2876.9 | 673.0 |
| 2012-10-16 | BR | Futures | 0.23711 | 0.23723 | 0.23687 | 0.23692 | 64.0 |
| 2012-10-16 | BZ | Futures | 108.89 | 109.18 | 107.95 | 108.41 | 360.0 |
| 2012-10-16 | C | Futures | 1555.0 | 1575.0 | 1543.0 | 1571.0 | 4484.0 |
| 2012-10-16 | CB | Futures | 94.87 | 95.004 | 92.822 | 93.264 | 15.0 |
| 2012-10-16 | CC | Futures | 1775.0 | 1836.0 | 1770.0 | 1824.0 | 11569.0 |
| 2012-10-16 | CSC | Futures | 4.246 | 4.246 | 4.105 | 4.105 | 41.0 |
| 2012-10-16 | CT | Futures | 93.35 | 97.0 | 92.91 | 96.6 | 40075.0 |
| 2012-10-16 | DC | Futures | 31.64 | 31.75 | 30.48 | 30.54 | 372.0 |
| 2012-10-16 | DX | Futures | 77.242 | 77.305 | 76.874 | 76.97 | 19137.0 |
| 2012-10-16 | E1 | Futures | 1.38046 | 1.39179 | 1.3802 | 1.39024 | 30610.0 |
| 2012-10-16 | E6 | Futures | 1.52591 | 1.53898 | 1.52497 | 1.53674 | 273330.0 |
| 2012-10-16 | E7 | Futures | 1.5168 | 1.5298 | 1.516 | 1.5275 | 4165.0 |
| 2012-10-16 | ED | Futures | 95.2492 | 95.2635 | 95.2492 | 95.2587 | 105459.0 |
| 2012-10-16 | ER | Futures | 97.857 | 97.866 | 97.852 | 97.857 | 99258.0 |
| 2012-10-16 | EW | Futures | 1001.0 | 1011.9 | 1000.3 | 1011.1 | 18637.0 |
| 2012-10-16 | FBTP | Futures | 72.11 | 72.55 | 72.04 | 72.26 | 15370.0 |
| 2012-10-16 | FBTS | Futures | 89.692 | 89.851 | 89.65 | 89.742 | 3542.0 |
| 2012-10-16 | FCE | Futures | 2586.2 | 2640.3 | 2576.8 | 2629.4 | 129792.0 |
| 2012-10-16 | FDAX | Futures | 8011.8 | 8100.5 | 7993.1 | 8085.7 | 124757.0 |
| 2012-10-16 | FESX | Futures | 1698.8 | 1737.6 | 1697.4 | 1730.1 | 1219948.0 |
| 2012-10-16 | FEU3 | Futures | 98.483 | 98.483 | 98.478 | 98.478 | 205.0 |
| 2012-10-16 | FGBL | Futures | 118.16 | 118.23 | 117.53 | 117.65 | 811290.0 |
| 2012-10-16 | FGBM | Futures | 116.2 | 116.24 | 115.94 | 115.99 | 486139.0 |
| 2012-10-16 | FGBS | Futures | 110.308 | 110.328 | 110.263 | 110.273 | 312877.0 |
| 2012-10-16 | FGBX | Futures | 124.92 | 124.92 | 123.5 | 123.77 | 8339.0 |
| 2012-10-16 | FOAT | Futures | 104.12 | 104.3 | 103.71 | 103.81 | 25201.0 |
| 2012-10-16 | FTDX | Futures | 772.1 | 778.7 | 771.6 | 778.2 | 73.0 |
| 2012-10-16 | FTI | Futures | 283.6 | 285.95 | 282.87 | 285.53 | 28354.0 |
| 2012-10-16 | FTUK | Futures | 4251.6 | 4285.9 | 4242.0 | 4281.9 | 96507.0 |
| 2012-10-16 | FVSA | Futures | 5342.05 | 5353.35 | 5138.76 | 5161.35 | 6707.0 |
| 2012-10-16 | FXXP | Futures | 195.9 | 197.4 | 195.5 | 197.4 | 2241.0 |
| 2012-10-16 | G | Futures | 99.07 | 99.15 | 98.64 | 98.68 | 149783.0 |
| 2012-10-16 | GF | Futures | 279.155 | 283.764 | 278.819 | 283.668 | 2781.0 |
| 2012-10-16 | GSCI | Futures | 1075.33 | 1077.03 | 1070.88 | 1073.31 | 60.0 |
| 2012-10-16 | HE | Futures | 97.543 | 97.947 | 97.046 | 97.699 | 13176.0 |
| 2012-10-16 | HG | Futures | 4.7497 | 4.785 | 4.7368 | 4.7548 | 30107.0 |
| 2012-10-16 | HH | Futures | 43.851 | 44.17 | 43.456 | 43.826 | 1711.0 |
| 2012-10-16 | HO | Futures | 2.5879 | 2.5937 | 2.5684 | 2.5815 | 46031.0 |
| 2012-10-16 | HRC | Futures | 2430.8 | 2430.8 | 2430.8 | 2430.8 | 0.0 |
> showing 50 of 100 rows — these rows as CSV