PREVIEW / futures_daily / 2014-05-09
file: by_date/futures_daily/2014/2014-05-09.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-05-09 | ES | Futures | 1935.03 | 1939.95 | 1927.01 | 1938.39 | 1476536.0 |
| 2014-05-09 | NQ | Futures | 4067.43 | 4089.01 | 4040.95 | 4084.12 | 319908.0 |
| 2014-05-09 | YM | Futures | 16563.6 | 16609.8 | 16518.4 | 16594.8 | 141287.0 |
| 2014-05-09 | CL | Futures | 181.62 | 183.26 | 180.6 | 181.11 | 271341.0 |
| 2014-05-09 | GC | Futures | 1699.2 | 1705.6 | 1693.8 | 1696.5 | 110471.0 |
| 2014-05-09 | ZN | Futures | 115.895356 | 116.0692 | 115.808435 | 115.895356 | 935111.0 |
| 2014-05-09 | A6 | Futures | 0.89808 | 0.89894 | 0.89577 | 0.89654 | 46135.0 |
| 2014-05-09 | AD | Futures | 0.9355 | 0.93661 | 0.92809 | 0.92931 | 71125.0 |
| 2014-05-09 | ALI | Futures | 2711.44 | 2711.44 | 2668.86 | 2678.08 | 14.0 |
| 2014-05-09 | B | Futures | 111.46 | 112.26 | 110.82 | 111.05 | 180914.0 |
| 2014-05-09 | B6 | Futures | 1.7792 | 1.7798 | 1.7685 | 1.7697 | 92837.0 |
| 2014-05-09 | BFX | Futures | 3796.9 | 3798.3 | 3796.9 | 3798.3 | 1.0 |
| 2014-05-09 | BR | Futures | 0.23602 | 0.23681 | 0.2355 | 0.23594 | 471.0 |
| 2014-05-09 | BZ | Futures | 113.59 | 114.48 | 113.02 | 113.27 | 5779.0 |
| 2014-05-09 | C | Futures | 1863.0 | 1873.0 | 1856.0 | 1857.0 | 10216.0 |
| 2014-05-09 | CB | Futures | 104.838 | 104.838 | 103.861 | 104.711 | 36.0 |
| 2014-05-09 | CC | Futures | 2121.0 | 2127.0 | 2106.0 | 2112.0 | 9767.0 |
| 2014-05-09 | CNH | Futures | 7.1498 | 7.1505 | 7.145 | 7.1505 | 12.0 |
| 2014-05-09 | CSC | Futures | 4.62 | 4.622 | 4.546 | 4.553 | 26.0 |
| 2014-05-09 | CT | Futures | 104.78 | 105.52 | 103.59 | 104.0 | 7050.0 |
| 2014-05-09 | DC | Futures | 37.47 | 37.52 | 36.69 | 36.78 | 283.0 |
| 2014-05-09 | DX | Futures | 75.489 | 75.974 | 75.489 | 75.965 | 27408.0 |
| 2014-05-09 | E1 | Futures | 1.45856 | 1.45881 | 1.44662 | 1.44688 | 38533.0 |
| 2014-05-09 | E6 | Futures | 1.63375 | 1.63422 | 1.62242 | 1.62265 | 231790.0 |
| 2014-05-09 | E7 | Futures | 1.6229 | 1.6233 | 1.6117 | 1.6118 | 4524.0 |
| 2014-05-09 | ED | Futures | 95.4186 | 95.4234 | 95.4138 | 95.4138 | 122550.0 |
| 2014-05-09 | ER | Futures | 97.867 | 97.876 | 97.857 | 97.857 | 116730.0 |
| 2014-05-09 | EW | Futures | 1388.9 | 1396.5 | 1381.8 | 1394.7 | 15576.0 |
| 2014-05-09 | FBTP | Futures | 90.16 | 90.17 | 89.69 | 89.76 | 51049.0 |
| 2014-05-09 | FBTS | Futures | 97.654 | 97.707 | 97.539 | 97.566 | 10330.0 |
| 2014-05-09 | FCE | Futures | 3536.5 | 3544.8 | 3518.2 | 3529.0 | 86137.0 |
| 2014-05-09 | FDAX | Futures | 10579.3 | 10630.1 | 10562.7 | 10593.1 | 86403.0 |
| 2014-05-09 | FESX | Futures | 2272.9 | 2276.5 | 2257.1 | 2265.7 | 803534.0 |
| 2014-05-09 | FGBL | Futures | 125.06 | 125.15 | 124.88 | 125.01 | 464387.0 |
| 2014-05-09 | FGBM | Futures | 120.23 | 120.3 | 120.17 | 120.22 | 366626.0 |
| 2014-05-09 | FGBS | Futures | 110.623 | 110.648 | 110.583 | 110.593 | 290403.0 |
| 2014-05-09 | FGBX | Futures | 129.16 | 129.29 | 128.51 | 128.84 | 21077.0 |
| 2014-05-09 | FMWO | Futures | 5584.7 | 5584.7 | 5568.3 | 5568.3 | 306.0 |
| 2014-05-09 | FOAT | Futures | 114.65 | 114.87 | 114.56 | 114.67 | 59518.0 |
| 2014-05-09 | FTDX | Futures | 1151.2 | 1157.3 | 1148.4 | 1156.4 | 141.0 |
| 2014-05-09 | FTI | Futures | 345.28 | 346.66 | 344.76 | 345.71 | 22002.0 |
| 2014-05-09 | FTUK | Futures | 5171.3 | 5188.5 | 5164.5 | 5175.1 | 78942.0 |
| 2014-05-09 | FVSA | Futures | 1713.67 | 1746.99 | 1713.67 | 1718.43 | 2536.0 |
| 2014-05-09 | FXXP | Futures | 252.5 | 253.0 | 251.5 | 252.2 | 7450.0 |
| 2014-05-09 | G | Futures | 94.3 | 94.31 | 93.9 | 94.09 | 120251.0 |
| 2014-05-09 | GF | Futures | 292.606 | 294.277 | 292.248 | 293.76 | 1054.0 |
| 2014-05-09 | GSCI | Futures | 1078.59 | 1081.0 | 1073.54 | 1074.45 | 1919.0 |
| 2014-05-09 | HE | Futures | 134.645 | 134.98 | 133.697 | 134.115 | 25656.0 |
| 2014-05-09 | HG | Futures | 3.9094 | 3.9471 | 3.9004 | 3.9394 | 38350.0 |
| 2014-05-09 | HH | Futures | 57.829 | 57.829 | 57.107 | 57.436 | 1222.0 |
> showing 50 of 104 rows — these rows as CSV