PREVIEW / futures_daily / 2015-05-05
file: by_date/futures_daily/2015/2015-05-05.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-05 | ES | Futures | 2218.06 | 2220.43 | 2188.62 | 2191.25 | 1590274.0 |
| 2015-05-05 | NQ | Futures | 5194.46 | 5201.72 | 5107.96 | 5117.25 | 306244.0 |
| 2015-05-05 | YM | Futures | 18411.5 | 18435.0 | 18232.5 | 18272.4 | 162515.0 |
| 2015-05-05 | CL | Futures | 100.1 | 103.75 | 99.55 | 102.56 | 389743.0 |
| 2015-05-05 | GC | Futures | 1553.8 | 1569.3 | 1550.4 | 1561.3 | 109749.0 |
| 2015-05-05 | ZN | Futures | 120.976549 | 121.213352 | 120.532544 | 120.695346 | 1502848.0 |
| 2015-05-05 | A6 | Futures | 0.77104 | 0.78297 | 0.76581 | 0.78159 | 126622.0 |
| 2015-05-05 | AD | Futures | 0.84406 | 0.85028 | 0.8412 | 0.84559 | 53755.0 |
| 2015-05-05 | ALI | Futures | 2646.55 | 2646.55 | 2646.55 | 2646.55 | 0.0 |
| 2015-05-05 | B | Futures | 63.97 | 65.8 | 63.69 | 64.98 | 149248.0 |
| 2015-05-05 | B6 | Futures | 1.5915 | 1.6014 | 1.5873 | 1.5968 | 101010.0 |
| 2015-05-05 | BFX | Futures | 4436.3 | 4438.7 | 4351.0 | 4351.0 | 28.0 |
| 2015-05-05 | BR | Futures | 0.18369 | 0.1856 | 0.18314 | 0.18369 | 1112.0 |
| 2015-05-05 | BZ | Futures | 63.27 | 65.14 | 63.27 | 64.36 | 13814.0 |
| 2015-05-05 | C | Futures | 2162.0 | 2190.0 | 2146.0 | 2188.0 | 2083.0 |
| 2015-05-05 | CB | Futures | 154.142 | 154.951 | 154.142 | 154.951 | 26.0 |
| 2015-05-05 | CC | Futures | 2126.0 | 2175.0 | 2116.0 | 2171.0 | 18579.0 |
| 2015-05-05 | CNH | Futures | 6.9999 | 6.9999 | 6.9928 | 6.9928 | 20.0 |
| 2015-05-05 | CSC | Futures | 4.631 | 4.631 | 4.514 | 4.546 | 54.0 |
| 2015-05-05 | CT | Futures | 84.0 | 84.31 | 83.28 | 84.09 | 11036.0 |
| 2015-05-05 | DC | Futures | 38.03 | 38.19 | 37.18 | 37.45 | 514.0 |
| 2015-05-05 | DX | Futures | 89.761 | 90.23 | 89.197 | 89.392 | 48164.0 |
| 2015-05-05 | E1 | Futures | 1.36655 | 1.38146 | 1.35584 | 1.37802 | 25561.0 |
| 2015-05-05 | E6 | Futures | 1.31163 | 1.32045 | 1.30199 | 1.31716 | 276050.0 |
| 2015-05-05 | E7 | Futures | 1.3042 | 1.3128 | 1.2945 | 1.3095 | 7951.0 |
| 2015-05-05 | EBM | Futures | 282.82 | 283.64 | 278.72 | 279.95 | 13909.0 |
| 2015-05-05 | ED | Futures | 95.5429 | 95.5477 | 95.5381 | 95.5429 | 115990.0 |
| 2015-05-05 | ER | Futures | 98.087 | 98.087 | 98.063 | 98.073 | 123361.0 |
| 2015-05-05 | EW | Futures | 1589.8 | 1593.1 | 1566.3 | 1568.9 | 21931.0 |
| 2015-05-05 | FBTP | Futures | 101.62 | 101.69 | 99.25 | 99.38 | 179596.0 |
| 2015-05-05 | FBTS | Futures | 99.67 | 99.679 | 99.528 | 99.572 | 50168.0 |
| 2015-05-05 | FCE | Futures | 4141.4 | 4194.5 | 4052.2 | 4062.5 | 140458.0 |
| 2015-05-05 | FDAX | Futures | 12877.0 | 13060.0 | 12550.2 | 12595.7 | 153255.0 |
| 2015-05-05 | FESX | Futures | 2635.7 | 2667.4 | 2570.9 | 2578.3 | 1255614.0 |
| 2015-05-05 | FEU3 | Futures | 98.715 | 98.72 | 98.715 | 98.72 | 1599.0 |
| 2015-05-05 | FGBL | Futures | 138.18 | 138.79 | 137.35 | 137.57 | 1220081.0 |
| 2015-05-05 | FGBM | Futures | 124.01 | 124.23 | 123.91 | 123.97 | 816531.0 |
| 2015-05-05 | FGBS | Futures | 111.198 | 111.223 | 111.188 | 111.208 | 314272.0 |
| 2015-05-05 | FGBX | Futures | 166.44 | 168.87 | 163.9 | 164.5 | 52286.0 |
| 2015-05-05 | FMWO | Futures | 5916.1 | 5916.1 | 5863.1 | 5863.1 | 206.0 |
| 2015-05-05 | FOAT | Futures | 127.18 | 127.69 | 126.1 | 126.25 | 138606.0 |
| 2015-05-05 | FTDX | Futures | 1535.9 | 1551.8 | 1496.5 | 1496.9 | 282.0 |
| 2015-05-05 | FTI | Futures | 424.92 | 428.88 | 417.08 | 417.78 | 39896.0 |
| 2015-05-05 | FTUK | Futures | 5526.8 | 5532.7 | 5427.8 | 5443.6 | 128333.0 |
| 2015-05-05 | FVSA | Futures | 1772.72 | 1843.95 | 1741.07 | 1843.95 | 17017.0 |
| 2015-05-05 | FXXP | Futures | 302.7 | 305.7 | 297.2 | 297.7 | 17794.0 |
| 2015-05-05 | G | Futures | 102.49 | 102.69 | 101.64 | 101.71 | 223600.0 |
| 2015-05-05 | GF | Futures | 370.08 | 371.197 | 367.76 | 370.123 | 3569.0 |
| 2015-05-05 | GSCI | Futures | 765.82 | 770.5 | 765.82 | 766.16 | 651.0 |
| 2015-05-05 | HE | Futures | 89.087 | 90.743 | 89.087 | 89.874 | 21162.0 |
> showing 50 of 107 rows — these rows as CSV