PREVIEW / futures_daily / 2014-08-12
file: by_date/futures_daily/2014/2014-08-12.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 |
|---|---|---|---|---|---|---|---|
| 2014-08-12 | ES | Futures | 2009.03 | 2013.97 | 1998.13 | 2005.4 | 1234217.0 |
| 2014-08-12 | NQ | Futures | 4508.39 | 4519.64 | 4480.41 | 4503.78 | 220589.0 |
| 2014-08-12 | YM | Futures | 16673.5 | 16708.8 | 16612.9 | 16667.4 | 116945.0 |
| 2014-08-12 | CL | Futures | 180.12 | 180.3 | 178.22 | 179.25 | 242592.0 |
| 2014-08-12 | GC | Futures | 1717.2 | 1730.5 | 1714.1 | 1719.1 | 98609.0 |
| 2014-08-12 | ZN | Futures | 117.51319 | 117.64449 | 117.425657 | 117.484012 | 840876.0 |
| 2014-08-12 | A6 | Futures | 0.89315 | 0.8945 | 0.8917 | 0.89441 | 48360.0 |
| 2014-08-12 | AD | Futures | 0.92891 | 0.92992 | 0.92647 | 0.92972 | 37397.0 |
| 2014-08-12 | ALI | Futures | 2964.93 | 2964.93 | 2964.93 | 2964.93 | 0.0 |
| 2014-08-12 | B | Futures | 110.45 | 110.64 | 108.69 | 109.11 | 277356.0 |
| 2014-08-12 | B6 | Futures | 1.7641 | 1.7673 | 1.7611 | 1.767 | 65066.0 |
| 2014-08-12 | BFX | Futures | 3721.1 | 3724.9 | 3719.8 | 3720.7 | 642.0 |
| 2014-08-12 | BR | Futures | 0.23065 | 0.23068 | 0.22933 | 0.23062 | 467.0 |
| 2014-08-12 | BZ | Futures | 111.44 | 111.44 | 109.55 | 109.97 | 14141.0 |
| 2014-08-12 | C | Futures | 2131.0 | 2140.0 | 2127.0 | 2134.0 | 4252.0 |
| 2014-08-12 | CB | Futures | 133.589 | 135.825 | 133.589 | 135.825 | 7.0 |
| 2014-08-12 | CC | Futures | 2384.0 | 2395.0 | 2381.0 | 2390.0 | 19413.0 |
| 2014-08-12 | CSC | Futures | 4.645 | 4.694 | 4.645 | 4.694 | 24.0 |
| 2014-08-12 | CT | Futures | 80.9 | 81.24 | 79.49 | 79.51 | 12.0 |
| 2014-08-12 | DC | Futures | 37.9 | 38.28 | 37.75 | 38.21 | 254.0 |
| 2014-08-12 | DX | Futures | 77.395 | 77.595 | 77.39 | 77.414 | 15290.0 |
| 2014-08-12 | E1 | Futures | 1.41404 | 1.41443 | 1.4084 | 1.41263 | 28607.0 |
| 2014-08-12 | E6 | Futures | 1.57958 | 1.57969 | 1.57379 | 1.57745 | 125719.0 |
| 2014-08-12 | E7 | Futures | 1.5692 | 1.5694 | 1.5637 | 1.5672 | 1193.0 |
| 2014-08-12 | ED | Futures | 95.4162 | 95.421 | 95.4115 | 95.4162 | 126408.0 |
| 2014-08-12 | ER | Futures | 97.901 | 97.901 | 97.896 | 97.901 | 18392.0 |
| 2014-08-12 | EW | Futures | 1435.3 | 1441.1 | 1424.4 | 1431.0 | 16298.0 |
| 2014-08-12 | FBTP | Futures | 91.94 | 92.58 | 91.94 | 92.52 | 68316.0 |
| 2014-08-12 | FBTS | Futures | 98.552 | 98.668 | 98.543 | 98.614 | 12680.0 |
| 2014-08-12 | FCE | Futures | 3336.6 | 3338.9 | 3304.3 | 3314.3 | 156076.0 |
| 2014-08-12 | FDAX | Futures | 10102.3 | 10112.2 | 9963.5 | 9989.4 | 100630.0 |
| 2014-08-12 | FESX | Futures | 2188.0 | 2194.4 | 2168.5 | 2175.0 | 915369.0 |
| 2014-08-12 | FGBL | Futures | 129.83 | 130.03 | 129.78 | 129.89 | 471248.0 |
| 2014-08-12 | FGBM | Futures | 122.04 | 122.13 | 122.0 | 122.08 | 235186.0 |
| 2014-08-12 | FGBS | Futures | 110.823 | 110.833 | 110.818 | 110.823 | 113350.0 |
| 2014-08-12 | FGBX | Futures | 138.76 | 138.82 | 138.37 | 138.58 | 21423.0 |
| 2014-08-12 | FMWO | Futures | 5653.1 | 5659.4 | 5640.5 | 5640.5 | 118.0 |
| 2014-08-12 | FOAT | Futures | 119.67 | 119.86 | 119.61 | 119.8 | 43148.0 |
| 2014-08-12 | FTDX | Futures | 1114.5 | 1117.3 | 1101.8 | 1104.6 | 214.0 |
| 2014-08-12 | FTI | Futures | 340.62 | 341.01 | 338.34 | 338.86 | 16642.0 |
| 2014-08-12 | FTUK | Futures | 5069.6 | 5083.1 | 5057.7 | 5071.6 | 76396.0 |
| 2014-08-12 | FVSA | Futures | 1579.19 | 1596.31 | 1562.07 | 1587.75 | 5645.0 |
| 2014-08-12 | FXXP | Futures | 247.6 | 248.4 | 246.7 | 247.3 | 4651.0 |
| 2014-08-12 | G | Futures | 95.53 | 95.74 | 95.42 | 95.65 | 146170.0 |
| 2014-08-12 | GF | Futures | 336.871 | 337.22 | 332.643 | 332.992 | 3083.0 |
| 2014-08-12 | GSCI | Futures | 1030.77 | 1030.86 | 1023.06 | 1024.91 | 1331.0 |
| 2014-08-12 | HE | Futures | 119.596 | 119.837 | 117.48 | 117.48 | 23103.0 |
| 2014-08-12 | HG | Futures | 4.0589 | 4.0762 | 4.0199 | 4.0321 | 53208.0 |
| 2014-08-12 | HH | Futures | 50.448 | 50.448 | 50.448 | 50.448 | 741.0 |
| 2014-08-12 | HO | Futures | 2.302 | 2.3065 | 2.2533 | 2.2716 | 57192.0 |
> showing 50 of 103 rows — these rows as CSV