PREVIEW / futures_daily / 2011-11-15
file: by_date/futures_daily/2011/2011-11-15.parquet size: 9 KB rows: 96
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-11-15 | ES | Futures | 1249.31 | 1260.04 | 1231.84 | 1251.8 | 2243400.0 |
| 2011-11-15 | NQ | Futures | 2674.72 | 2710.1 | 2636.76 | 2693.55 | 257276.0 |
| 2011-11-15 | YM | Futures | 11579.8 | 11651.8 | 11447.2 | 11564.4 | 119079.0 |
| 2011-11-15 | CL | Futures | 183.93 | 187.21 | 182.99 | 186.4 | 153152.0 |
| 2011-11-15 | GC | Futures | 2406.0 | 2413.8 | 2377.5 | 2406.2 | 132676.0 |
| 2011-11-15 | ZN | Futures | 111.884791 | 112.273605 | 111.737309 | 111.831161 | 945368.0 |
| 2011-11-15 | A6 | Futures | 0.89363 | 0.89583 | 0.88571 | 0.89275 | 92123.0 |
| 2011-11-15 | AD | Futures | 0.98344 | 0.98414 | 0.97404 | 0.98014 | 63340.0 |
| 2011-11-15 | B | Futures | 98.57 | 99.76 | 98.3 | 99.3 | 185029.0 |
| 2011-11-15 | B6 | Futures | 1.659 | 1.6623 | 1.6483 | 1.6519 | 81318.0 |
| 2011-11-15 | BFX | Futures | 2479.1 | 2479.3 | 2453.6 | 2465.7 | 333.0 |
| 2011-11-15 | BR | Futures | 0.25467 | 0.25467 | 0.25467 | 0.25467 | 62.0 |
| 2011-11-15 | BZ | Futures | 104.39 | 105.14 | 103.9 | 104.85 | 593.0 |
| 2011-11-15 | C | Futures | 1667.0 | 1672.0 | 1643.0 | 1671.0 | 6355.0 |
| 2011-11-15 | CB | Futures | 92.601 | 93.149 | 92.601 | 93.149 | 7.0 |
| 2011-11-15 | CC | Futures | 1990.0 | 2000.0 | 1954.0 | 1967.0 | 18742.0 |
| 2011-11-15 | CSC | Futures | 4.58 | 4.629 | 4.58 | 4.629 | 14.0 |
| 2011-11-15 | CT | Futures | 129.06 | 134.97 | 129.06 | 132.35 | 12280.0 |
| 2011-11-15 | DC | Futures | 32.43 | 33.29 | 32.38 | 32.89 | 669.0 |
| 2011-11-15 | DX | Futures | 76.24 | 76.883 | 76.201 | 76.635 | 24759.0 |
| 2011-11-15 | E1 | Futures | 1.44533 | 1.44533 | 1.42709 | 1.43457 | 20705.0 |
| 2011-11-15 | E6 | Futures | 1.62812 | 1.63027 | 1.61294 | 1.61856 | 260681.0 |
| 2011-11-15 | E7 | Futures | 1.6146 | 1.6163 | 1.5993 | 1.6047 | 4919.0 |
| 2011-11-15 | ED | Futures | 94.9125 | 94.922 | 94.891 | 94.9006 | 208517.0 |
| 2011-11-15 | ER | Futures | 97.322 | 97.332 | 97.307 | 97.322 | 154080.0 |
| 2011-11-15 | EW | Futures | 886.9 | 897.7 | 873.4 | 891.2 | 29494.0 |
| 2011-11-15 | FBTP | Futures | 57.16 | 57.17 | 55.5 | 55.81 | 15504.0 |
| 2011-11-15 | FBTS | Futures | 78.34 | 78.532 | 77.176 | 77.89 | 2531.0 |
| 2011-11-15 | FCE | Futures | 2204.6 | 2210.3 | 2163.5 | 2176.7 | 76811.0 |
| 2011-11-15 | FDAX | Futures | 6436.7 | 6534.4 | 6316.7 | 6460.1 | 202978.0 |
| 2011-11-15 | FESX | Futures | 1507.2 | 1517.8 | 1479.9 | 1500.6 | 1401278.0 |
| 2011-11-15 | FEU3 | Futures | 97.876 | 97.88 | 97.876 | 97.88 | 7.0 |
| 2011-11-15 | FGBL | Futures | 112.14 | 112.52 | 111.84 | 112.23 | 759033.0 |
| 2011-11-15 | FGBM | Futures | 112.24 | 112.45 | 112.08 | 112.28 | 347923.0 |
| 2011-11-15 | FGBS | Futures | 109.501 | 109.536 | 109.461 | 109.496 | 424160.0 |
| 2011-11-15 | FGBX | Futures | 116.47 | 116.92 | 115.81 | 116.5 | 4681.0 |
| 2011-11-15 | FTDX | Futures | 638.9 | 640.8 | 629.3 | 631.1 | 78.0 |
| 2011-11-15 | FTI | Futures | 247.87 | 249.55 | 243.67 | 246.06 | 19137.0 |
| 2011-11-15 | FTUK | Futures | 3948.0 | 3992.5 | 3886.6 | 3963.8 | 132001.0 |
| 2011-11-15 | FVSA | Futures | 16216.24 | 17008.85 | 16044.87 | 16173.4 | 2545.0 |
| 2011-11-15 | FXXP | Futures | 165.6 | 166.4 | 163.0 | 165.5 | 1729.0 |
| 2011-11-15 | G | Futures | 92.81 | 93.26 | 92.66 | 93.03 | 116623.0 |
| 2011-11-15 | GF | Futures | 314.28 | 319.88 | 314.28 | 319.611 | 2761.0 |
| 2011-11-15 | GSCI | Futures | 1025.26 | 1035.64 | 1025.26 | 1034.95 | 195.0 |
| 2011-11-15 | HE | Futures | 111.829 | 112.182 | 109.901 | 111.122 | 19733.0 |
| 2011-11-15 | HG | Futures | 4.6169 | 4.6599 | 4.5706 | 4.6335 | 38961.0 |
| 2011-11-15 | HO | Futures | 2.5418 | 2.5643 | 2.5324 | 2.5473 | 52775.0 |
| 2011-11-15 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-15 | J1 | Futures | 0.0163084 | 0.0163474 | 0.0161891 | 0.0163197 | 65001.0 |
| 2011-11-15 | J7 | Futures | 0.016204 | 0.016248 | 0.016091 | 0.016221 | 481.0 |
> showing 50 of 96 rows — these rows as CSV