PREVIEW / futures_daily / 2015-03-06
file: by_date/futures_daily/2015/2015-03-06.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 |
|---|---|---|---|---|---|---|---|
| 2015-03-06 | ES | Futures | 2200.55 | 2204.74 | 2164.91 | 2170.41 | 1901150.0 |
| 2015-03-06 | NQ | Futures | 5165.04 | 5175.48 | 5092.81 | 5111.08 | 296605.0 |
| 2015-03-06 | YM | Futures | 18454.8 | 18490.4 | 18140.1 | 18191.0 | 185298.0 |
| 2015-03-06 | CL | Futures | 94.16 | 94.77 | 90.44 | 91.79 | 406840.0 |
| 2015-03-06 | GC | Futures | 1565.7 | 1569.0 | 1520.5 | 1522.3 | 214797.0 |
| 2015-03-06 | ZN | Futures | 120.305835 | 120.762208 | 119.304758 | 119.422532 | 38763.0 |
| 2015-03-06 | A6 | Futures | 0.76163 | 0.76829 | 0.75457 | 0.75604 | 140042.0 |
| 2015-03-06 | AD | Futures | 0.81555 | 0.81759 | 0.80648 | 0.8075 | 86128.0 |
| 2015-03-06 | ALI | Futures | 2654.87 | 2654.87 | 2654.87 | 2654.87 | 0.0 |
| 2015-03-06 | B | Futures | 60.22 | 60.77 | 58.72 | 59.22 | 160563.0 |
| 2015-03-06 | B6 | Futures | 1.6034 | 1.6036 | 1.5799 | 1.5823 | 123205.0 |
| 2015-03-06 | BFX | Futures | 4531.5 | 4531.5 | 4504.9 | 4504.9 | 5.0 |
| 2015-03-06 | BR | Futures | 0.1826 | 0.18306 | 0.18072 | 0.18155 | 26.0 |
| 2015-03-06 | BZ | Futures | 59.8 | 60.19 | 58.23 | 58.71 | 21742.0 |
| 2015-03-06 | C | Futures | 2238.0 | 2242.0 | 2217.0 | 2218.0 | 5279.0 |
| 2015-03-06 | CB | Futures | 144.028 | 144.837 | 144.028 | 144.048 | 32.0 |
| 2015-03-06 | CC | Futures | 2204.0 | 2205.0 | 2162.0 | 2174.0 | 15722.0 |
| 2015-03-06 | CSC | Futures | 4.498 | 4.506 | 4.442 | 4.468 | 51.0 |
| 2015-03-06 | CT | Futures | 80.9 | 81.12 | 80.11 | 80.71 | 12577.0 |
| 2015-03-06 | DC | Futures | 36.62 | 36.62 | 35.92 | 36.28 | 131.0 |
| 2015-03-06 | DX | Futures | 91.24 | 92.532 | 91.174 | 92.389 | 55085.0 |
| 2015-03-06 | E1 | Futures | 1.31178 | 1.31357 | 1.29454 | 1.29684 | 28103.0 |
| 2015-03-06 | E6 | Futures | 1.29788 | 1.29788 | 1.27506 | 1.27729 | 344207.0 |
| 2015-03-06 | E7 | Futures | 1.29 | 1.29 | 1.2673 | 1.2697 | 5939.0 |
| 2015-03-06 | EBM | Futures | 296.06 | 298.07 | 295.26 | 296.46 | 13935.0 |
| 2015-03-06 | ED | Futures | 95.457 | 95.4594 | 95.4546 | 95.4594 | 213122.0 |
| 2015-03-06 | ER | Futures | 98.058 | 98.068 | 98.058 | 98.063 | 41298.0 |
| 2015-03-06 | EW | Futures | 1572.7 | 1576.1 | 1550.2 | 1554.6 | 19823.0 |
| 2015-03-06 | FBTP | Futures | 103.32 | 103.52 | 102.99 | 103.07 | 101278.0 |
| 2015-03-06 | FBTS | Futures | 99.706 | 99.741 | 99.599 | 99.626 | 27071.0 |
| 2015-03-06 | FCE | Futures | 4039.1 | 4056.2 | 4017.5 | 4037.9 | 83881.0 |
| 2015-03-06 | FDAX | Futures | 12791.1 | 12882.1 | 12762.2 | 12829.4 | 92681.0 |
| 2015-03-06 | FESX | Futures | 2609.8 | 2622.0 | 2591.7 | 2608.3 | 1001108.0 |
| 2015-03-06 | FGBL | Futures | 139.62 | 139.62 | 138.7 | 138.74 | 770217.0 |
| 2015-03-06 | FGBM | Futures | 124.72 | 124.75 | 124.49 | 124.5 | 499910.0 |
| 2015-03-06 | FGBS | Futures | 111.178 | 111.178 | 111.143 | 111.153 | 260926.0 |
| 2015-03-06 | FGBX | Futures | 168.83 | 170.28 | 166.44 | 166.6 | 52345.0 |
| 2015-03-06 | FMWO | Futures | 5826.4 | 5826.4 | 5768.3 | 5768.3 | 550.0 |
| 2015-03-06 | FOAT | Futures | 128.21 | 128.34 | 127.33 | 127.38 | 86785.0 |
| 2015-03-06 | FTDX | Futures | 1500.7 | 1507.3 | 1499.7 | 1503.0 | 180.0 |
| 2015-03-06 | FTI | Futures | 422.71 | 425.26 | 420.73 | 422.84 | 21227.0 |
| 2015-03-06 | FTUK | Futures | 5414.1 | 5414.9 | 5349.0 | 5375.9 | 93290.0 |
| 2015-03-06 | FVSA | Futures | 1678.55 | 1759.12 | 1647.21 | 1714.36 | 9609.0 |
| 2015-03-06 | FXXP | Futures | 297.4 | 299.9 | 297.1 | 298.2 | 11375.0 |
| 2015-03-06 | G | Futures | 102.57 | 102.78 | 101.63 | 101.7 | 217006.0 |
| 2015-03-06 | GF | Futures | 348.865 | 354.179 | 347.853 | 353.799 | 2965.0 |
| 2015-03-06 | GSCI | Futures | 712.53 | 712.53 | 700.85 | 703.17 | 2915.0 |
| 2015-03-06 | HE | Futures | 89.214 | 89.214 | 87.537 | 88.711 | 23443.0 |
| 2015-03-06 | HG | Futures | 3.3695 | 3.3745 | 3.3097 | 3.3148 | 42864.0 |
| 2015-03-06 | HH | Futures | 35.113 | 35.299 | 34.52 | 35.076 | 2637.0 |
> showing 50 of 104 rows — these rows as CSV