PREVIEW / futures_daily / 2013-02-20
file: by_date/futures_daily/2013/2013-02-20.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-20 | ES | Futures | 1564.21 | 1565.49 | 1541.44 | 1541.96 | 2018732.0 |
| 2013-02-20 | NQ | Futures | 3211.75 | 3214.06 | 3143.12 | 3157.54 | 230436.0 |
| 2013-02-20 | YM | Futures | 13735.2 | 13762.6 | 13613.6 | 13619.5 | 134966.0 |
| 2013-02-20 | CL | Futures | 170.06 | 170.75 | 165.0 | 166.77 | 338967.0 |
| 2013-02-20 | GC | Futures | 2132.3 | 2138.9 | 2071.0 | 2097.4 | 260413.0 |
| 2013-02-20 | ZN | Futures | 115.839189 | 116.059704 | 115.687585 | 115.963229 | 1462435.0 |
| 2013-02-20 | A6 | Futures | 0.94529 | 0.94685 | 0.93495 | 0.93569 | 128820.0 |
| 2013-02-20 | AD | Futures | 0.99066 | 0.99116 | 0.98384 | 0.98414 | 106438.0 |
| 2013-02-20 | B | Futures | 111.01 | 111.31 | 108.81 | 109.36 | 219241.0 |
| 2013-02-20 | B6 | Futures | 1.6117 | 1.6144 | 1.5872 | 1.5928 | 186212.0 |
| 2013-02-20 | BFX | Futures | 3067.5 | 3067.6 | 3056.1 | 3067.6 | 100.0 |
| 2013-02-20 | BR | Futures | 0.25062 | 0.25082 | 0.24935 | 0.25001 | 3366.0 |
| 2013-02-20 | BZ | Futures | 113.84 | 114.08 | 111.53 | 112.08 | 4641.0 |
| 2013-02-20 | C | Futures | 1503.0 | 1510.0 | 1497.0 | 1505.0 | 2959.0 |
| 2013-02-20 | CB | Futures | 84.458 | 84.458 | 84.458 | 84.458 | 5.0 |
| 2013-02-20 | CC | Futures | 1611.0 | 1614.0 | 1592.0 | 1599.0 | 7179.0 |
| 2013-02-20 | CSC | Futures | 3.601 | 3.601 | 3.558 | 3.563 | 61.0 |
| 2013-02-20 | CT | Futures | 103.32 | 104.77 | 103.05 | 103.55 | 8723.0 |
| 2013-02-20 | DC | Futures | 27.33 | 27.33 | 26.95 | 26.95 | 270.0 |
| 2013-02-20 | DX | Futures | 77.599 | 78.341 | 77.493 | 78.269 | 40939.0 |
| 2013-02-20 | E1 | Futures | 1.39513 | 1.40196 | 1.38651 | 1.38728 | 34907.0 |
| 2013-02-20 | E6 | Futures | 1.57911 | 1.58477 | 1.56543 | 1.56708 | 313250.0 |
| 2013-02-20 | E7 | Futures | 1.5686 | 1.5739 | 1.5547 | 1.5564 | 5095.0 |
| 2013-02-20 | EBM | Futures | 273.11 | 274.51 | 270.89 | 271.17 | 12313.0 |
| 2013-02-20 | ED | Futures | 95.2342 | 95.2366 | 95.2318 | 95.2342 | 79522.0 |
| 2013-02-20 | ER | Futures | 97.768 | 97.773 | 97.764 | 97.764 | 54429.0 |
| 2013-02-20 | EW | Futures | 1145.2 | 1145.9 | 1123.4 | 1123.7 | 16062.0 |
| 2013-02-20 | FBTP | Futures | 76.3 | 76.55 | 76.16 | 76.23 | 29340.0 |
| 2013-02-20 | FBTS | Futures | 91.552 | 91.595 | 91.467 | 91.501 | 4997.0 |
| 2013-02-20 | FCE | Futures | 2806.5 | 2812.5 | 2773.8 | 2785.5 | 86826.0 |
| 2013-02-20 | FDAX | Futures | 8467.6 | 8502.0 | 8415.2 | 8445.2 | 115248.0 |
| 2013-02-20 | FESX | Futures | 1815.2 | 1820.0 | 1789.3 | 1798.8 | 918313.0 |
| 2013-02-20 | FEU3 | Futures | 98.374 | 98.374 | 98.369 | 98.369 | 16.0 |
| 2013-02-20 | FGBL | Futures | 117.97 | 117.97 | 117.56 | 117.72 | 848004.0 |
| 2013-02-20 | FGBM | Futures | 116.37 | 116.38 | 116.15 | 116.23 | 464392.0 |
| 2013-02-20 | FGBS | Futures | 110.193 | 110.193 | 110.133 | 110.153 | 281887.0 |
| 2013-02-20 | FGBX | Futures | 123.33 | 123.33 | 122.26 | 122.6 | 6396.0 |
| 2013-02-20 | FOAT | Futures | 104.45 | 104.51 | 104.2 | 104.32 | 35649.0 |
| 2013-02-20 | FTDX | Futures | 858.2 | 861.1 | 851.1 | 859.2 | 55.0 |
| 2013-02-20 | FTI | Futures | 298.73 | 298.99 | 294.22 | 295.34 | 28257.0 |
| 2013-02-20 | FTUK | Futures | 4673.4 | 4705.4 | 4670.8 | 4687.0 | 89385.0 |
| 2013-02-20 | FVSA | Futures | 3339.1 | 3475.21 | 3320.96 | 3438.91 | 11851.0 |
| 2013-02-20 | FXXP | Futures | 209.1 | 209.1 | 207.8 | 208.0 | 1976.0 |
| 2013-02-20 | G | Futures | 95.77 | 96.78 | 95.43 | 95.68 | 196904.0 |
| 2013-02-20 | GF | Futures | 266.693 | 267.207 | 261.882 | 262.91 | 3985.0 |
| 2013-02-20 | GSCI | Futures | 1086.54 | 1087.03 | 1069.81 | 1073.43 | 407.0 |
| 2013-02-20 | HE | Futures | 93.037 | 93.653 | 91.972 | 92.925 | 24627.0 |
| 2013-02-20 | HG | Futures | 4.6879 | 4.7032 | 4.6043 | 4.6248 | 31270.0 |
| 2013-02-20 | HH | Futures | 38.588 | 38.669 | 38.062 | 38.307 | 1829.0 |
| 2013-02-20 | HO | Futures | 2.5914 | 2.5997 | 2.5529 | 2.5669 | 16984.0 |
> showing 50 of 103 rows — these rows as CSV