PREVIEW / futures_daily / 2014-12-05
file: by_date/futures_daily/2014/2014-12-05.parquet size: 9 KB rows: 108
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-12-05 | ES | Futures | 2164.12 | 2171.69 | 2160.73 | 2168.56 | 1148282.0 |
| 2014-12-05 | NQ | Futures | 4998.66 | 5014.6 | 4986.78 | 4998.95 | 199234.0 |
| 2014-12-05 | YM | Futures | 18145.8 | 18241.1 | 18141.7 | 18213.7 | 100804.0 |
| 2014-12-05 | CL | Futures | 128.77 | 128.95 | 125.63 | 126.92 | 276529.0 |
| 2014-12-05 | GC | Futures | 1578.4 | 1581.8 | 1552.9 | 1558.1 | 157202.0 |
| 2014-12-05 | ZN | Futures | 119.242275 | 119.242275 | 118.422237 | 118.568672 | 38300.0 |
| 2014-12-05 | A6 | Futures | 0.81398 | 0.81592 | 0.80766 | 0.80853 | 84760.0 |
| 2014-12-05 | AD | Futures | 0.89193 | 0.89244 | 0.88502 | 0.88827 | 73325.0 |
| 2014-12-05 | ALI | Futures | 2967.91 | 2967.91 | 2967.91 | 2967.91 | 0.0 |
| 2014-12-05 | B | Futures | 72.07 | 72.56 | 70.82 | 71.8 | 140997.0 |
| 2014-12-05 | B6 | Futures | 1.647 | 1.6497 | 1.6362 | 1.6377 | 89638.0 |
| 2014-12-05 | BFX | Futures | 3997.7 | 4033.4 | 3997.7 | 4033.4 | 4.0 |
| 2014-12-05 | BR | Futures | 0.20742 | 0.20811 | 0.2069 | 0.20811 | 19.0 |
| 2014-12-05 | BZ | Futures | 72.6 | 73.3 | 71.46 | 72.44 | 15880.0 |
| 2014-12-05 | C | Futures | 2076.0 | 2114.0 | 2074.0 | 2106.0 | 4040.0 |
| 2014-12-05 | CB | Futures | 139.204 | 139.225 | 138.013 | 138.835 | 28.0 |
| 2014-12-05 | CC | Futures | 2112.0 | 2150.0 | 2112.0 | 2133.0 | 9885.0 |
| 2014-12-05 | CNH | Futures | 7.0604 | 7.062 | 7.0604 | 7.062 | 5.0 |
| 2014-12-05 | CSC | Futures | 4.643 | 4.677 | 4.617 | 4.66 | 124.0 |
| 2014-12-05 | CT | Futures | 77.17 | 77.79 | 76.08 | 76.17 | 14312.0 |
| 2014-12-05 | DC | Futures | 36.96 | 37.4 | 36.72 | 37.1 | 180.0 |
| 2014-12-05 | DX | Futures | 84.167 | 84.955 | 84.153 | 84.827 | 42735.0 |
| 2014-12-05 | E1 | Futures | 1.31637 | 1.31778 | 1.30474 | 1.30704 | 62158.0 |
| 2014-12-05 | E6 | Futures | 1.45714 | 1.45891 | 1.44455 | 1.44655 | 305520.0 |
| 2014-12-05 | E7 | Futures | 1.4481 | 1.4497 | 1.4355 | 1.4375 | 4399.0 |
| 2014-12-05 | EBM | Futures | 303.33 | 307.38 | 301.7 | 306.16 | 16600.0 |
| 2014-12-05 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 155438.0 |
| 2014-12-05 | ER | Futures | 97.999 | 98.004 | 97.999 | 97.999 | 15496.0 |
| 2014-12-05 | EW | Futures | 1502.9 | 1508.0 | 1500.1 | 1504.9 | 16599.0 |
| 2014-12-05 | FBTP | Futures | 97.87 | 98.46 | 97.83 | 98.42 | 117664.0 |
| 2014-12-05 | FBTS | Futures | 98.721 | 98.819 | 98.721 | 98.783 | 18336.0 |
| 2014-12-05 | FCE | Futures | 3521.6 | 3582.8 | 3520.8 | 3577.1 | 107289.0 |
| 2014-12-05 | FDAX | Futures | 10850.4 | 11063.5 | 10850.4 | 11055.3 | 110802.0 |
| 2014-12-05 | FDIV | Futures | 143.53 | 145.43 | 143.53 | 145.43 | 30.0 |
| 2014-12-05 | FESX | Futures | 2326.7 | 2377.4 | 2326.7 | 2373.0 | 1181003.0 |
| 2014-12-05 | FEU3 | Futures | 98.626 | 98.626 | 98.626 | 98.626 | 720.0 |
| 2014-12-05 | FGBL | Futures | 133.99 | 134.11 | 133.52 | 133.68 | 766252.0 |
| 2014-12-05 | FGBM | Futures | 123.17 | 123.18 | 122.93 | 123.03 | 471757.0 |
| 2014-12-05 | FGBS | Futures | 110.833 | 110.843 | 110.788 | 110.808 | 327940.0 |
| 2014-12-05 | FGBX | Futures | 148.15 | 148.59 | 147.27 | 147.77 | 39320.0 |
| 2014-12-05 | FMWO | Futures | 5797.7 | 5799.0 | 5787.7 | 5799.0 | 14.0 |
| 2014-12-05 | FOAT | Futures | 124.04 | 124.18 | 123.73 | 123.82 | 120565.0 |
| 2014-12-05 | FTDX | Futures | 1302.9 | 1304.3 | 1296.7 | 1303.8 | 134.0 |
| 2014-12-05 | FTI | Futures | 369.64 | 375.33 | 369.64 | 374.72 | 27243.0 |
| 2014-12-05 | FTUK | Futures | 5188.1 | 5224.1 | 5188.1 | 5212.5 | 73422.0 |
| 2014-12-05 | FVSA | Futures | 1485.66 | 1485.66 | 1424.12 | 1432.91 | 7974.0 |
| 2014-12-05 | FXXP | Futures | 263.6 | 266.8 | 263.6 | 266.3 | 7378.0 |
| 2014-12-05 | G | Futures | 100.96 | 101.1 | 100.55 | 100.72 | 182305.0 |
| 2014-12-05 | GF | Futures | 379.903 | 380.424 | 375.45 | 376.854 | 5134.0 |
| 2014-12-05 | GSCI | Futures | 804.17 | 807.89 | 797.83 | 800.62 | 1424.0 |
> showing 50 of 108 rows — these rows as CSV