PREVIEW / futures_daily / 2012-11-29
file: by_date/futures_daily/2012/2012-11-29.parquet size: 9 KB rows: 99
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-11-29 | ES | Futures | 1431.77 | 1443.73 | 1429.48 | 1440.93 | 1877829.0 |
| 2012-11-29 | NQ | Futures | 3064.65 | 3093.42 | 3060.34 | 3083.64 | 273982.0 |
| 2012-11-29 | YM | Futures | 12656.3 | 12742.2 | 12634.8 | 12714.9 | 136755.0 |
| 2012-11-29 | CL | Futures | 155.01 | 158.8 | 154.97 | 157.69 | 270030.0 |
| 2012-11-29 | GC | Futures | 2295.3 | 2307.0 | 2292.2 | 2304.8 | 178274.0 |
| 2012-11-29 | ZN | Futures | 117.672797 | 117.865073 | 117.590393 | 117.796403 | 1124410.0 |
| 2012-11-29 | A6 | Futures | 0.95089 | 0.95116 | 0.94543 | 0.94689 | 101103.0 |
| 2012-11-29 | AD | Futures | 1.01131 | 1.01222 | 1.00951 | 1.01111 | 75459.0 |
| 2012-11-29 | B | Futures | 101.53 | 102.89 | 101.26 | 102.42 | 143658.0 |
| 2012-11-29 | B6 | Futures | 1.6725 | 1.676 | 1.6713 | 1.675 | 88152.0 |
| 2012-11-29 | BFX | Futures | 2956.7 | 2966.1 | 2955.5 | 2962.5 | 63.0 |
| 2012-11-29 | BR | Futures | 0.23103 | 0.23142 | 0.23103 | 0.23117 | 41.0 |
| 2012-11-29 | BZ | Futures | 104.65 | 105.89 | 104.33 | 105.52 | 394.0 |
| 2012-11-29 | C | Futures | 1612.0 | 1622.0 | 1604.0 | 1615.0 | 4641.0 |
| 2012-11-29 | CB | Futures | 87.573 | 87.573 | 87.573 | 87.573 | 6.0 |
| 2012-11-29 | CC | Futures | 1857.0 | 1900.0 | 1857.0 | 1879.0 | 14331.0 |
| 2012-11-29 | CT | Futures | 91.42 | 93.1 | 90.95 | 92.31 | 20020.0 |
| 2012-11-29 | DC | Futures | 29.59 | 29.67 | 29.56 | 29.64 | 32.0 |
| 2012-11-29 | DX | Futures | 77.799 | 77.842 | 77.513 | 77.691 | 19817.0 |
| 2012-11-29 | E1 | Futures | 1.38599 | 1.3914 | 1.38381 | 1.38741 | 27799.0 |
| 2012-11-29 | E6 | Futures | 1.52532 | 1.53286 | 1.52391 | 1.52803 | 246992.0 |
| 2012-11-29 | E7 | Futures | 1.516 | 1.5237 | 1.5149 | 1.5189 | 2894.0 |
| 2012-11-29 | ED | Futures | 95.2301 | 95.2325 | 95.2277 | 95.2301 | 69551.0 |
| 2012-11-29 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.876 | 53134.0 |
| 2012-11-29 | EW | Futures | 1009.9 | 1022.7 | 1009.9 | 1020.5 | 24354.0 |
| 2012-11-29 | FBTP | Futures | 74.61 | 75.28 | 74.47 | 74.79 | 60388.0 |
| 2012-11-29 | FBTS | Futures | 90.722 | 90.974 | 90.53 | 90.63 | 4981.0 |
| 2012-11-29 | FCE | Futures | 2668.1 | 2688.9 | 2660.2 | 2687.4 | 99595.0 |
| 2012-11-29 | FDAX | Futures | 8097.2 | 8127.3 | 8075.3 | 8108.2 | 121984.0 |
| 2012-11-29 | FESX | Futures | 1747.8 | 1757.3 | 1741.6 | 1755.3 | 997347.0 |
| 2012-11-29 | FEU3 | Futures | 98.497 | 98.497 | 98.497 | 98.497 | 276.0 |
| 2012-11-29 | FGBL | Futures | 119.35 | 119.53 | 119.2 | 119.38 | 687399.0 |
| 2012-11-29 | FGBM | Futures | 116.94 | 117.0 | 116.84 | 116.91 | 299244.0 |
| 2012-11-29 | FGBS | Futures | 110.467 | 110.487 | 110.437 | 110.457 | 214063.0 |
| 2012-11-29 | FGBX | Futures | 126.06 | 126.4 | 125.51 | 126.12 | 6995.0 |
| 2012-11-29 | FOAT | Futures | 105.3 | 105.7 | 105.27 | 105.51 | 42063.0 |
| 2012-11-29 | FTDX | Futures | 788.1 | 799.4 | 780.1 | 794.7 | 58.0 |
| 2012-11-29 | FTI | Futures | 288.27 | 290.33 | 287.97 | 289.9 | 31044.0 |
| 2012-11-29 | FTUK | Futures | 4258.9 | 4307.2 | 4258.9 | 4299.1 | 92863.0 |
| 2012-11-29 | FVSA | Futures | 4116.43 | 4219.91 | 4081.93 | 4116.43 | 5998.0 |
| 2012-11-29 | FXXP | Futures | 197.9 | 199.6 | 197.9 | 199.2 | 2687.0 |
| 2012-11-29 | G | Futures | 99.05 | 99.33 | 99.0 | 99.16 | 150693.0 |
| 2012-11-29 | GF | Futures | 277.041 | 279.413 | 276.851 | 278.464 | 2096.0 |
| 2012-11-29 | GSCI | Futures | 1044.49 | 1051.83 | 1044.49 | 1045.53 | 116.0 |
| 2012-11-29 | HE | Futures | 100.417 | 101.22 | 99.613 | 99.986 | 21115.0 |
| 2012-11-29 | HG | Futures | 4.5491 | 4.6512 | 4.5427 | 4.63 | 63234.0 |
| 2012-11-29 | HH | Futures | 43.228 | 43.228 | 42.828 | 42.828 | 266.0 |
| 2012-11-29 | HO | Futures | 2.4302 | 2.4712 | 2.4282 | 2.4606 | 10947.0 |
| 2012-11-29 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-11-29 | J1 | Futures | 0.0152546 | 0.0152859 | 0.0152283 | 0.015247 | 96968.0 |
> showing 50 of 99 rows — these rows as CSV