PREVIEW / futures_daily / 2012-05-09
file: by_date/futures_daily/2012/2012-05-09.parquet size: 9 KB rows: 98
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-09 | ES | Futures | 1369.49 | 1371.25 | 1349.58 | 1361.42 | 2523438.0 |
| 2012-05-09 | NQ | Futures | 3006.66 | 3015.82 | 2960.83 | 3000.93 | 373576.0 |
| 2012-05-09 | YM | Futures | 12520.8 | 12529.6 | 12350.6 | 12443.0 | 208761.0 |
| 2012-05-09 | CL | Futures | 178.63 | 178.65 | 174.58 | 177.59 | 332865.0 |
| 2012-05-09 | GC | Futures | 2146.8 | 2148.2 | 2110.1 | 2131.1 | 210608.0 |
| 2012-05-09 | ZN | Futures | 115.126986 | 115.465436 | 115.086372 | 115.154062 | 1247003.0 |
| 2012-05-09 | A6 | Futures | 0.90594 | 0.90639 | 0.89793 | 0.90153 | 173011.0 |
| 2012-05-09 | AD | Futures | 1.00662 | 1.00682 | 0.99887 | 1.0039 | 118692.0 |
| 2012-05-09 | B | Futures | 101.91 | 102.05 | 100.35 | 101.99 | 169902.0 |
| 2012-05-09 | B6 | Futures | 1.6954 | 1.6957 | 1.6858 | 1.694 | 126754.0 |
| 2012-05-09 | BFX | Futures | 2641.4 | 2644.1 | 2604.9 | 2629.6 | 7.0 |
| 2012-05-09 | BR | Futures | 0.24271 | 0.24271 | 0.24073 | 0.24245 | 231.0 |
| 2012-05-09 | BZ | Futures | 108.34 | 108.69 | 106.96 | 108.69 | 2413.0 |
| 2012-05-09 | C | Futures | 1527.0 | 1545.0 | 1527.0 | 1542.0 | 4100.0 |
| 2012-05-09 | CB | Futures | 70.777 | 70.777 | 70.683 | 70.683 | 9.0 |
| 2012-05-09 | CC | Futures | 1754.0 | 1763.0 | 1722.0 | 1760.0 | 9765.0 |
| 2012-05-09 | CSC | Futures | 3.375 | 3.412 | 3.357 | 3.393 | 17.0 |
| 2012-05-09 | CT | Futures | 106.85 | 106.85 | 104.36 | 104.99 | 14499.0 |
| 2012-05-09 | DC | Futures | 23.33 | 23.68 | 23.27 | 23.59 | 177.0 |
| 2012-05-09 | DX | Futures | 77.516 | 77.913 | 77.487 | 77.736 | 38813.0 |
| 2012-05-09 | E1 | Futures | 1.41779 | 1.41819 | 1.40797 | 1.41203 | 68364.0 |
| 2012-05-09 | E6 | Futures | 1.55236 | 1.55295 | 1.54149 | 1.54567 | 333777.0 |
| 2012-05-09 | E7 | Futures | 1.5372 | 1.5381 | 1.5268 | 1.5308 | 3631.0 |
| 2012-05-09 | ED | Futures | 95.0597 | 95.0597 | 95.0311 | 95.0454 | 369227.0 |
| 2012-05-09 | ER | Futures | 97.548 | 97.562 | 97.513 | 97.523 | 246947.0 |
| 2012-05-09 | EW | Futures | 976.4 | 977.1 | 958.7 | 971.3 | 26093.0 |
| 2012-05-09 | FBTP | Futures | 66.72 | 66.77 | 65.77 | 65.97 | 25599.0 |
| 2012-05-09 | FBTS | Futures | 85.551 | 85.559 | 85.233 | 85.29 | 2619.0 |
| 2012-05-09 | FCE | Futures | 2249.6 | 2254.0 | 2201.6 | 2235.2 | 159971.0 |
| 2012-05-09 | FDAX | Futures | 7165.5 | 7198.1 | 7050.0 | 7153.9 | 208864.0 |
| 2012-05-09 | FESX | Futures | 1525.3 | 1529.5 | 1489.4 | 1510.8 | 1681604.0 |
| 2012-05-09 | FGBL | Futures | 116.84 | 117.28 | 116.77 | 117.09 | 719252.0 |
| 2012-05-09 | FGBM | Futures | 115.31 | 115.53 | 115.22 | 115.44 | 586978.0 |
| 2012-05-09 | FGBS | Futures | 110.203 | 110.258 | 110.173 | 110.233 | 461846.0 |
| 2012-05-09 | FGBX | Futures | 122.5 | 123.49 | 122.33 | 123.19 | 5659.0 |
| 2012-05-09 | FOAT | Futures | 96.28 | 96.38 | 95.68 | 95.91 | 19773.0 |
| 2012-05-09 | FTDX | Futures | 725.6 | 726.0 | 714.8 | 719.5 | 125.0 |
| 2012-05-09 | FTI | Futures | 261.38 | 261.73 | 256.7 | 260.04 | 52589.0 |
| 2012-05-09 | FTUK | Futures | 4059.4 | 4059.4 | 3970.7 | 4020.7 | 156910.0 |
| 2012-05-09 | FVSA | Futures | 10053.02 | 10681.33 | 9953.81 | 10301.03 | 5837.0 |
| 2012-05-09 | FXXP | Futures | 180.9 | 181.3 | 177.9 | 179.7 | 9262.0 |
| 2012-05-09 | G | Futures | 96.52 | 96.97 | 96.33 | 96.71 | 140455.0 |
| 2012-05-09 | GF | Futures | 315.832 | 316.249 | 313.437 | 313.802 | 2764.0 |
| 2012-05-09 | GSCI | Futures | 1019.72 | 1028.85 | 1018.37 | 1028.85 | 2094.0 |
| 2012-05-09 | HE | Futures | 89.899 | 91.206 | 89.286 | 90.513 | 27496.0 |
| 2012-05-09 | HG | Futures | 4.8311 | 4.8383 | 4.7277 | 4.7925 | 69031.0 |
| 2012-05-09 | HO | Futures | 2.4626 | 2.4667 | 2.4315 | 2.4654 | 61478.0 |
| 2012-05-09 | HRC | Futures | 2609.8 | 2609.8 | 2609.8 | 2609.8 | 25.0 |
| 2012-05-09 | J1 | Futures | 0.0156999 | 0.0157927 | 0.0156899 | 0.0157413 | 87111.0 |
| 2012-05-09 | J7 | Futures | 0.015631 | 0.015716 | 0.015617 | 0.015667 | 353.0 |
> showing 50 of 98 rows — these rows as CSV