PREVIEW / futures_daily / 2012-05-10
file: by_date/futures_daily/2012/2012-05-10.parquet size: 9 KB rows: 97
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-05-10 | ES | Futures | 1361.68 | 1374.27 | 1356.13 | 1367.97 | 1839321.0 |
| 2012-05-10 | NQ | Futures | 3000.93 | 3020.69 | 2980.02 | 3000.35 | 312502.0 |
| 2012-05-10 | YM | Futures | 12443.0 | 12537.3 | 12390.5 | 12480.9 | 150739.0 |
| 2012-05-10 | CL | Futures | 176.93 | 179.2 | 176.25 | 178.08 | 282314.0 |
| 2012-05-10 | GC | Futures | 2125.1 | 2141.8 | 2118.8 | 2132.9 | 138244.0 |
| 2012-05-10 | ZN | Futures | 115.181138 | 115.262366 | 114.842688 | 115.045758 | 1178319.0 |
| 2012-05-10 | A6 | Futures | 0.90027 | 0.90918 | 0.89982 | 0.90504 | 146931.0 |
| 2012-05-10 | AD | Futures | 1.00279 | 1.00752 | 1.00209 | 1.004 | 81848.0 |
| 2012-05-10 | B | Futures | 101.61 | 102.36 | 101.05 | 101.59 | 146801.0 |
| 2012-05-10 | B6 | Futures | 1.6932 | 1.6982 | 1.6887 | 1.6952 | 120240.0 |
| 2012-05-10 | BR | Futures | 0.24192 | 0.244 | 0.24128 | 0.244 | 384.0 |
| 2012-05-10 | BZ | Futures | 108.12 | 109.07 | 107.73 | 108.27 | 3413.0 |
| 2012-05-10 | C | Futures | 1542.0 | 1552.0 | 1528.0 | 1541.0 | 7910.0 |
| 2012-05-10 | CC | Futures | 1760.0 | 1773.0 | 1738.0 | 1763.0 | 8246.0 |
| 2012-05-10 | CSC | Futures | 3.412 | 3.416 | 3.359 | 3.371 | 19.0 |
| 2012-05-10 | CT | Futures | 105.02 | 105.57 | 100.09 | 100.09 | 27214.0 |
| 2012-05-10 | DC | Futures | 23.71 | 23.97 | 23.58 | 23.66 | 285.0 |
| 2012-05-10 | DX | Futures | 77.797 | 77.84 | 77.593 | 77.76 | 28158.0 |
| 2012-05-10 | E1 | Futures | 1.41033 | 1.41491 | 1.40928 | 1.41216 | 48630.0 |
| 2012-05-10 | E6 | Futures | 1.54424 | 1.54961 | 1.54293 | 1.54627 | 253654.0 |
| 2012-05-10 | E7 | Futures | 1.5294 | 1.5349 | 1.5281 | 1.5314 | 2414.0 |
| 2012-05-10 | ED | Futures | 95.0406 | 95.0549 | 95.0358 | 95.0502 | 167289.0 |
| 2012-05-10 | ER | Futures | 97.523 | 97.538 | 97.513 | 97.528 | 128774.0 |
| 2012-05-10 | EW | Futures | 971.7 | 981.6 | 968.1 | 975.3 | 22907.0 |
| 2012-05-10 | FBTP | Futures | 65.98 | 66.62 | 65.85 | 66.54 | 20449.0 |
| 2012-05-10 | FBTS | Futures | 85.461 | 85.559 | 85.266 | 85.534 | 2148.0 |
| 2012-05-10 | FCE | Futures | 2242.0 | 2264.8 | 2211.3 | 2252.5 | 155938.0 |
| 2012-05-10 | FDAX | Futures | 7189.3 | 7245.6 | 7121.3 | 7206.9 | 163872.0 |
| 2012-05-10 | FESX | Futures | 1517.7 | 1541.2 | 1503.3 | 1530.9 | 1377933.0 |
| 2012-05-10 | FGBL | Futures | 116.96 | 117.26 | 116.65 | 116.94 | 825461.0 |
| 2012-05-10 | FGBM | Futures | 115.39 | 115.52 | 115.24 | 115.38 | 448619.0 |
| 2012-05-10 | FGBS | Futures | 110.228 | 110.238 | 110.198 | 110.228 | 302852.0 |
| 2012-05-10 | FGBX | Futures | 122.87 | 123.71 | 122.54 | 123.09 | 7568.0 |
| 2012-05-10 | FOAT | Futures | 95.94 | 96.34 | 95.79 | 96.21 | 24096.0 |
| 2012-05-10 | FTDX | Futures | 723.7 | 727.0 | 721.4 | 727.0 | 119.0 |
| 2012-05-10 | FTI | Futures | 260.04 | 262.85 | 257.44 | 261.86 | 122.0 |
| 2012-05-10 | FTUK | Futures | 4012.7 | 4046.2 | 3990.4 | 4032.0 | 118128.0 |
| 2012-05-10 | FVSA | Futures | 9788.46 | 10201.83 | 9672.72 | 9689.26 | 6537.0 |
| 2012-05-10 | FXXP | Futures | 180.5 | 181.5 | 178.7 | 180.9 | 4313.0 |
| 2012-05-10 | G | Futures | 96.57 | 96.78 | 95.71 | 96.04 | 158938.0 |
| 2012-05-10 | GF | Futures | 313.802 | 315.627 | 313.061 | 313.604 | 4327.0 |
| 2012-05-10 | GSCI | Futures | 1028.85 | 1032.1 | 1024.57 | 1026.07 | 2065.0 |
| 2012-05-10 | HE | Futures | 90.406 | 90.886 | 89.792 | 90.139 | 25368.0 |
| 2012-05-10 | HG | Futures | 4.7958 | 4.8632 | 4.7715 | 4.8331 | 55360.0 |
| 2012-05-10 | HO | Futures | 2.46 | 2.4715 | 2.4424 | 2.4525 | 48175.0 |
| 2012-05-10 | HRC | Futures | 2629.4 | 2629.4 | 2629.4 | 2629.4 | 0.0 |
| 2012-05-10 | J1 | Futures | 0.0157451 | 0.0157564 | 0.0156749 | 0.0156962 | 76627.0 |
| 2012-05-10 | J7 | Futures | 0.015662 | 0.015681 | 0.015602 | 0.015622 | 300.0 |
| 2012-05-10 | JB | Futures | 125.77 | 125.83 | 125.44 | 125.55 | 2788.0 |
| 2012-05-10 | KC | Futures | 395.74 | 404.87 | 394.16 | 402.73 | 11260.0 |
> showing 50 of 97 rows — these rows as CSV