PREVIEW / futures_daily / 2015-10-29
file: by_date/futures_daily/2015/2015-10-29.parquet size: 9 KB rows: 110
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-10-29 | ES | Futures | 2213.67 | 2219.52 | 2205.42 | 2215.79 | 1407730.0 |
| 2015-10-29 | NQ | Futures | 5453.48 | 5460.5 | 5428.34 | 5450.56 | 184529.0 |
| 2015-10-29 | YM | Futures | 18239.8 | 18269.7 | 18162.4 | 18246.0 | 105568.0 |
| 2015-10-29 | CL | Futures | 73.13 | 74.29 | 71.7 | 73.13 | 436513.0 |
| 2015-10-29 | GC | Futures | 1492.4 | 1500.7 | 1477.0 | 1481.0 | 155610.0 |
| 2015-10-29 | ZN | Futures | 122.748587 | 122.868327 | 122.179821 | 122.239692 | 1568986.0 |
| 2015-10-29 | A6 | Futures | 0.70873 | 0.71043 | 0.70533 | 0.70653 | 73007.0 |
| 2015-10-29 | AD | Futures | 0.77609 | 0.77967 | 0.77342 | 0.77824 | 58837.0 |
| 2015-10-29 | ALI | Futures | 2029.34 | 2029.34 | 2029.34 | 2029.34 | 0.0 |
| 2015-10-29 | B | Futures | 43.96 | 44.25 | 43.18 | 43.74 | 84218.0 |
| 2015-10-29 | B6 | Futures | 1.6073 | 1.6132 | 1.6048 | 1.6126 | 67066.0 |
| 2015-10-29 | BFX | Futures | 4352.3 | 4354.1 | 4351.1 | 4354.1 | 3.0 |
| 2015-10-29 | BR | Futures | 0.15533 | 0.15884 | 0.15429 | 0.15789 | 1336.0 |
| 2015-10-29 | BZ | Futures | 43.53 | 44.0 | 42.95 | 43.46 | 16327.0 |
| 2015-10-29 | C | Futures | 2345.0 | 2356.0 | 2321.0 | 2345.0 | 8303.0 |
| 2015-10-29 | CB | Futures | 204.696 | 206.664 | 204.696 | 206.664 | 22.0 |
| 2015-10-29 | CC | Futures | 2348.0 | 2379.0 | 2323.0 | 2357.0 | 16761.0 |
| 2015-10-29 | CNH | Futures | 7.1148 | 7.1148 | 7.0748 | 7.0748 | 186.0 |
| 2015-10-29 | CSC | Futures | 4.271 | 4.271 | 4.238 | 4.253 | 45.0 |
| 2015-10-29 | CT | Futures | 75.2 | 75.48 | 74.57 | 74.76 | 12280.0 |
| 2015-10-29 | DC | Futures | 34.19 | 34.19 | 34.01 | 34.12 | 207.0 |
| 2015-10-29 | DX | Futures | 91.38 | 91.464 | 91.015 | 91.061 | 34760.0 |
| 2015-10-29 | E1 | Futures | 1.27745 | 1.2848 | 1.27567 | 1.28239 | 22842.0 |
| 2015-10-29 | E6 | Futures | 1.28061 | 1.28764 | 1.2778 | 1.28635 | 237228.0 |
| 2015-10-29 | E7 | Futures | 1.2737 | 1.2807 | 1.2707 | 1.2793 | 4881.0 |
| 2015-10-29 | EBM | Futures | 261.61 | 265.63 | 260.88 | 264.17 | 18065.0 |
| 2015-10-29 | ED | Futures | 95.7111 | 95.7256 | 95.7111 | 95.7159 | 232188.0 |
| 2015-10-29 | ER | Futures | 98.2 | 98.205 | 98.195 | 98.2 | 102936.0 |
| 2015-10-29 | EW | Futures | 1529.5 | 1529.5 | 1517.3 | 1520.0 | 14686.0 |
| 2015-10-29 | FBON | Futures | 116.29 | 116.67 | 115.72 | 115.88 | 889.0 |
| 2015-10-29 | FBTP | Futures | 104.99 | 105.27 | 104.44 | 104.57 | 142788.0 |
| 2015-10-29 | FBTS | Futures | 100.615 | 100.615 | 100.543 | 100.561 | 32826.0 |
| 2015-10-29 | FCE | Futures | 4100.0 | 4100.0 | 4036.2 | 4073.8 | 83890.0 |
| 2015-10-29 | FDAX | Futures | 11979.6 | 11997.7 | 11829.8 | 11882.7 | 89177.0 |
| 2015-10-29 | FDIV | Futures | 142.05 | 142.05 | 141.03 | 141.03 | 9.0 |
| 2015-10-29 | FDXM | Futures | 11197.6 | 11203.7 | 11052.5 | 11099.8 | 3590.0 |
| 2015-10-29 | FESX | Futures | 2573.7 | 2577.4 | 2534.7 | 2550.4 | 997393.0 |
| 2015-10-29 | FEU3 | Futures | 98.848 | 98.848 | 98.843 | 98.848 | 88.0 |
| 2015-10-29 | FGBL | Futures | 140.62 | 140.81 | 139.69 | 139.79 | 740374.0 |
| 2015-10-29 | FGBM | Futures | 125.87 | 125.91 | 125.57 | 125.6 | 492931.0 |
| 2015-10-29 | FGBS | Futures | 111.463 | 111.483 | 111.428 | 111.433 | 280134.0 |
| 2015-10-29 | FGBX | Futures | 162.46 | 162.99 | 160.18 | 160.51 | 39019.0 |
| 2015-10-29 | FMWO | Futures | 5692.9 | 5702.8 | 5676.8 | 5702.8 | 399.0 |
| 2015-10-29 | FOAT | Futures | 129.06 | 129.32 | 128.28 | 128.36 | 82384.0 |
| 2015-10-29 | FTDX | Futures | 1714.5 | 1714.5 | 1697.9 | 1702.2 | 178.0 |
| 2015-10-29 | FTI | Futures | 404.03 | 404.81 | 400.23 | 402.59 | 27456.0 |
| 2015-10-29 | FTUK | Futures | 5166.3 | 5167.5 | 5094.3 | 5119.7 | 96104.0 |
| 2015-10-29 | FVSA | Futures | 2035.64 | 2086.19 | 2003.48 | 2035.64 | 10582.0 |
| 2015-10-29 | FXXP | Futures | 294.1 | 294.1 | 290.6 | 292.1 | 15355.0 |
| 2015-10-29 | G | Futures | 104.8 | 104.95 | 104.08 | 104.14 | 230783.0 |
> showing 50 of 110 rows — these rows as CSV