PREVIEW / futures_daily / 2014-05-29
file: by_date/futures_daily/2014/2014-05-29.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-29 | ES | Futures | 1975.9 | 1984.43 | 1973.31 | 1984.43 | 981817.0 |
| 2014-05-29 | NQ | Futures | 4277.79 | 4301.97 | 4274.34 | 4299.95 | 184922.0 |
| 2014-05-29 | YM | Futures | 16698.2 | 16755.4 | 16676.1 | 16749.4 | 78751.0 |
| 2014-05-29 | CL | Futures | 187.46 | 189.06 | 186.64 | 188.41 | 205506.0 |
| 2014-05-29 | GC | Futures | 1658.7 | 1662.1 | 1648.8 | 1656.3 | 140234.0 |
| 2014-05-29 | ZN | Futures | 117.213666 | 117.532378 | 117.025336 | 117.199179 | 1711331.0 |
| 2014-05-29 | A6 | Futures | 0.88597 | 0.89376 | 0.88386 | 0.89145 | 85038.0 |
| 2014-05-29 | AD | Futures | 0.93195 | 0.93631 | 0.93175 | 0.93499 | 47219.0 |
| 2014-05-29 | ALI | Futures | 2755.79 | 2755.79 | 2755.79 | 2755.79 | 20.0 |
| 2014-05-29 | B | Futures | 114.28 | 114.82 | 114.1 | 114.28 | 102708.0 |
| 2014-05-29 | B6 | Futures | 1.7561 | 1.7593 | 1.7543 | 1.7572 | 76737.0 |
| 2014-05-29 | BR | Futures | 0.23107 | 0.23107 | 0.23107 | 0.23107 | 2537.0 |
| 2014-05-29 | BZ | Futures | 115.34 | 115.8 | 115.11 | 115.28 | 10654.0 |
| 2014-05-29 | C | Futures | 1994.0 | 2005.0 | 1987.0 | 2004.0 | 7810.0 |
| 2014-05-29 | CB | Futures | 113.467 | 114.026 | 112.209 | 112.489 | 9.0 |
| 2014-05-29 | CC | Futures | 2238.0 | 2253.0 | 2227.0 | 2246.0 | 15968.0 |
| 2014-05-29 | CNH | Futures | 7.1839 | 7.1839 | 7.1638 | 7.1638 | 29.0 |
| 2014-05-29 | CSC | Futures | 4.433 | 4.444 | 4.421 | 4.433 | 23.0 |
| 2014-05-29 | CT | Futures | 95.57 | 97.9 | 95.17 | 97.01 | 17131.0 |
| 2014-05-29 | DC | Futures | 34.91 | 35.25 | 34.82 | 35.13 | 74.0 |
| 2014-05-29 | DX | Futures | 76.582 | 76.582 | 76.382 | 76.515 | 12365.0 |
| 2014-05-29 | E1 | Futures | 1.42904 | 1.43327 | 1.42878 | 1.42981 | 26110.0 |
| 2014-05-29 | E6 | Futures | 1.60459 | 1.60861 | 1.60388 | 1.60577 | 126642.0 |
| 2014-05-29 | E7 | Futures | 1.594 | 1.5984 | 1.5931 | 1.5951 | 1662.0 |
| 2014-05-29 | ED | Futures | 95.4114 | 95.4138 | 95.4091 | 95.4114 | 97672.0 |
| 2014-05-29 | ER | Futures | 97.876 | 97.881 | 97.876 | 97.881 | 39720.0 |
| 2014-05-29 | EW | Futures | 1416.8 | 1424.2 | 1414.5 | 1423.8 | 12835.0 |
| 2014-05-29 | FBTP | Futures | 89.95 | 90.05 | 89.71 | 89.76 | 66638.0 |
| 2014-05-29 | FBTS | Futures | 97.592 | 97.619 | 97.522 | 97.557 | 16165.0 |
| 2014-05-29 | FCE | Futures | 3599.6 | 3607.2 | 3591.2 | 3604.4 | 43291.0 |
| 2014-05-29 | FDAX | Futures | 10976.3 | 11002.8 | 10955.3 | 10975.8 | 41160.0 |
| 2014-05-29 | FESX | Futures | 2326.8 | 2332.5 | 2321.0 | 2326.8 | 423598.0 |
| 2014-05-29 | FGBL | Futures | 126.92 | 126.96 | 126.55 | 126.79 | 550563.0 |
| 2014-05-29 | FGBM | Futures | 121.1 | 121.1 | 120.96 | 121.04 | 342472.0 |
| 2014-05-29 | FGBS | Futures | 110.753 | 110.763 | 110.733 | 110.743 | 212029.0 |
| 2014-05-29 | FGBX | Futures | 132.48 | 132.62 | 131.54 | 132.13 | 12565.0 |
| 2014-05-29 | FMWO | Futures | 5686.9 | 5686.9 | 5686.9 | 5686.9 | 0.0 |
| 2014-05-29 | FOAT | Futures | 116.33 | 116.48 | 116.13 | 116.23 | 56411.0 |
| 2014-05-29 | FTDX | Futures | 1208.9 | 1212.2 | 1207.0 | 1210.3 | 33.0 |
| 2014-05-29 | FTI | Futures | 350.8 | 352.66 | 349.89 | 351.75 | 11695.0 |
| 2014-05-29 | FTUK | Futures | 5206.0 | 5240.0 | 5206.0 | 5230.8 | 52777.0 |
| 2014-05-29 | FVSA | Futures | 1569.0 | 1573.67 | 1550.32 | 1564.33 | 5682.0 |
| 2014-05-29 | FXXP | Futures | 257.5 | 258.6 | 257.5 | 258.1 | 2595.0 |
| 2014-05-29 | G | Futures | 94.52 | 94.83 | 94.49 | 94.73 | 140290.0 |
| 2014-05-29 | GF | Futures | 299.929 | 303.416 | 299.507 | 301.998 | 3012.0 |
| 2014-05-29 | GSCI | Futures | 1084.14 | 1085.88 | 1082.9 | 1084.06 | 31.0 |
| 2014-05-29 | HE | Futures | 128.34 | 128.368 | 126.554 | 127.559 | 9519.0 |
| 2014-05-29 | HG | Futures | 4.0506 | 4.0589 | 4.0084 | 4.018 | 35372.0 |
| 2014-05-29 | HH | Futures | 58.374 | 58.843 | 57.665 | 57.791 | 5.0 |
| 2014-05-29 | HO | Futures | 2.3475 | 2.3493 | 2.3368 | 2.3373 | 7878.0 |
> showing 50 of 104 rows — these rows as CSV