PREVIEW / futures_daily / 2014-04-08
file: by_date/futures_daily/2014/2014-04-08.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-08 | ES | Futures | 1903.73 | 1913.04 | 1894.16 | 1908.91 | 1854828.0 |
| 2014-04-08 | NQ | Futures | 4030.88 | 4070.31 | 4017.93 | 4061.67 | 400196.0 |
| 2014-04-08 | YM | Futures | 16253.4 | 16292.5 | 16173.0 | 16246.3 | 169951.0 |
| 2014-04-08 | CL | Futures | 179.69 | 183.29 | 179.67 | 183.02 | 299549.0 |
| 2014-04-08 | GC | Futures | 1708.7 | 1732.2 | 1708.7 | 1724.9 | 119225.0 |
| 2014-04-08 | ZN | Futures | 114.794351 | 115.055115 | 114.692942 | 115.011654 | 1219288.0 |
| 2014-04-08 | A6 | Futures | 0.88617 | 0.89568 | 0.88559 | 0.89472 | 74630.0 |
| 2014-04-08 | AD | Futures | 0.92282 | 0.92789 | 0.92211 | 0.92657 | 58673.0 |
| 2014-04-08 | B | Futures | 109.46 | 111.33 | 109.26 | 111.14 | 211635.0 |
| 2014-04-08 | B6 | Futures | 1.7446 | 1.7601 | 1.7445 | 1.7593 | 109353.0 |
| 2014-04-08 | BFX | Futures | 3782.8 | 3782.8 | 3747.6 | 3747.6 | 58.0 |
| 2014-04-08 | BR | Futures | 0.23394 | 0.23663 | 0.23394 | 0.23529 | 543.0 |
| 2014-04-08 | BZ | Futures | 111.69 | 113.45 | 111.36 | 113.28 | 8328.0 |
| 2014-04-08 | C | Futures | 1956.0 | 1967.0 | 1942.0 | 1966.0 | 8435.0 |
| 2014-04-08 | CB | Futures | 93.771 | 93.771 | 93.441 | 93.441 | 13.0 |
| 2014-04-08 | CC | Futures | 2194.0 | 2218.0 | 2183.0 | 2212.0 | 30377.0 |
| 2014-04-08 | CNH | Futures | 7.1152 | 7.1152 | 7.1103 | 7.1103 | 15.0 |
| 2014-04-08 | CSC | Futures | 4.455 | 4.471 | 4.455 | 4.471 | 11.0 |
| 2014-04-08 | CT | Futures | 101.85 | 103.9 | 101.8 | 103.17 | 14070.0 |
| 2014-04-08 | DC | Futures | 35.6 | 35.77 | 35.46 | 35.69 | 109.0 |
| 2014-04-08 | DX | Futures | 76.33 | 76.335 | 75.812 | 75.845 | 25959.0 |
| 2014-04-08 | E1 | Futures | 1.44636 | 1.45496 | 1.44598 | 1.45381 | 29202.0 |
| 2014-04-08 | E6 | Futures | 1.62218 | 1.63033 | 1.62147 | 1.62832 | 159641.0 |
| 2014-04-08 | E7 | Futures | 1.6114 | 1.6196 | 1.6107 | 1.6175 | 3196.0 |
| 2014-04-08 | EBM | Futures | 292.4 | 294.52 | 292.05 | 293.46 | 10464.0 |
| 2014-04-08 | ED | Futures | 95.4043 | 95.4091 | 95.3995 | 95.4043 | 45814.0 |
| 2014-04-08 | ER | Futures | 97.832 | 97.871 | 97.832 | 97.837 | 28875.0 |
| 2014-04-08 | EW | Futures | 1384.8 | 1394.3 | 1375.3 | 1390.0 | 19843.0 |
| 2014-04-08 | FBTP | Futures | 87.96 | 88.01 | 87.73 | 87.82 | 56824.0 |
| 2014-04-08 | FBTS | Futures | 97.522 | 97.566 | 97.469 | 97.522 | 11651.0 |
| 2014-04-08 | FCE | Futures | 3453.9 | 3458.2 | 3407.7 | 3439.9 | 132456.0 |
| 2014-04-08 | FDAX | Futures | 10529.6 | 10544.5 | 10392.7 | 10493.2 | 120042.0 |
| 2014-04-08 | FESX | Futures | 2242.7 | 2248.5 | 2212.5 | 2233.4 | 1083435.0 |
| 2014-04-08 | FGBL | Futures | 123.83 | 124.0 | 123.71 | 123.76 | 573633.0 |
| 2014-04-08 | FGBM | Futures | 119.68 | 119.76 | 119.62 | 119.64 | 401419.0 |
| 2014-04-08 | FGBS | Futures | 110.478 | 110.498 | 110.473 | 110.488 | 196275.0 |
| 2014-04-08 | FGBX | Futures | 126.18 | 126.52 | 126.11 | 126.24 | 17990.0 |
| 2014-04-08 | FMWO | Futures | 5496.4 | 5496.4 | 5496.4 | 5496.4 | 0.0 |
| 2014-04-08 | FOAT | Futures | 113.04 | 113.09 | 112.85 | 112.9 | 62294.0 |
| 2014-04-08 | FTDX | Futures | 1162.0 | 1162.0 | 1132.0 | 1146.1 | 308.0 |
| 2014-04-08 | FTI | Futures | 344.71 | 345.35 | 340.91 | 343.64 | 30260.0 |
| 2014-04-08 | FTUK | Futures | 4989.1 | 5008.5 | 4950.6 | 4978.4 | 107409.0 |
| 2014-04-08 | FVSA | Futures | 1790.51 | 1855.71 | 1770.45 | 1790.51 | 9988.0 |
| 2014-04-08 | FXXP | Futures | 247.9 | 248.3 | 245.3 | 246.8 | 7536.0 |
| 2014-04-08 | G | Futures | 93.85 | 93.96 | 93.61 | 93.73 | 149789.0 |
| 2014-04-08 | GF | Futures | 284.238 | 285.639 | 283.598 | 285.439 | 797.0 |
| 2014-04-08 | GSCI | Futures | 1066.04 | 1076.62 | 1064.14 | 1074.38 | 2696.0 |
| 2014-04-08 | HE | Futures | 139.543 | 139.834 | 137.356 | 137.793 | 271.0 |
| 2014-04-08 | HG | Futures | 3.8545 | 3.8811 | 3.8355 | 3.8665 | 48838.0 |
| 2014-04-08 | HH | Futures | 57.098 | 57.491 | 57.086 | 57.389 | 719.0 |
> showing 50 of 104 rows — these rows as CSV