PREVIEW / futures_daily / 2013-11-04
file: by_date/futures_daily/2013/2013-11-04.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-04 | ES | Futures | 1801.75 | 1812.03 | 1800.98 | 1811.0 | 1005972.0 |
| 2013-11-04 | NQ | Futures | 3868.24 | 3890.35 | 3866.8 | 3879.15 | 142512.0 |
| 2013-11-04 | YM | Futures | 15462.2 | 15531.9 | 15445.3 | 15497.1 | 94882.0 |
| 2013-11-04 | CL | Futures | 168.18 | 169.23 | 167.36 | 168.36 | 219109.0 |
| 2013-11-04 | GC | Futures | 1736.5 | 1748.9 | 1733.6 | 1738.7 | 78535.0 |
| 2013-11-04 | ZN | Futures | 114.824402 | 115.164287 | 114.810241 | 115.093478 | 543146.0 |
| 2013-11-04 | A6 | Futures | 0.88943 | 0.89624 | 0.88943 | 0.89548 | 53895.0 |
| 2013-11-04 | AD | Futures | 0.96854 | 0.97076 | 0.96783 | 0.96854 | 31097.0 |
| 2013-11-04 | B | Futures | 105.74 | 106.49 | 105.1 | 106.06 | 137451.0 |
| 2013-11-04 | B6 | Futures | 1.6711 | 1.6769 | 1.6687 | 1.6758 | 63035.0 |
| 2013-11-04 | BFX | Futures | 3466.0 | 3466.0 | 3455.8 | 3461.2 | 46.0 |
| 2013-11-04 | BR | Futures | 0.22502 | 0.22586 | 0.22499 | 0.22525 | 90.0 |
| 2013-11-04 | BZ | Futures | 106.55 | 107.18 | 105.81 | 106.77 | 6714.0 |
| 2013-11-04 | C | Futures | 1810.0 | 1811.0 | 1792.0 | 1804.0 | 5227.0 |
| 2013-11-04 | CB | Futures | 72.404 | 73.016 | 72.104 | 72.14 | 8.0 |
| 2013-11-04 | CC | Futures | 1976.0 | 1982.0 | 1961.0 | 1979.0 | 16996.0 |
| 2013-11-04 | CSC | Futures | 3.52 | 3.52 | 3.464 | 3.47 | 9.0 |
| 2013-11-04 | CT | Futures | 89.84 | 90.47 | 88.98 | 89.1 | 13637.0 |
| 2013-11-04 | DC | Futures | 26.72 | 26.87 | 26.3 | 26.33 | 474.0 |
| 2013-11-04 | DX | Futures | 76.995 | 77.2 | 76.805 | 76.833 | 17473.0 |
| 2013-11-04 | E1 | Futures | 1.40871 | 1.41411 | 1.40447 | 1.41333 | 24113.0 |
| 2013-11-04 | E6 | Futures | 1.59197 | 1.59622 | 1.58631 | 1.59528 | 142687.0 |
| 2013-11-04 | E7 | Futures | 1.5815 | 1.5859 | 1.5762 | 1.585 | 2890.0 |
| 2013-11-04 | ED | Futures | 95.3638 | 95.3638 | 95.359 | 95.359 | 30792.0 |
| 2013-11-04 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 61847.0 |
| 2013-11-04 | EW | Futures | 1311.2 | 1324.3 | 1310.7 | 1322.8 | 12201.0 |
| 2013-11-04 | FBTP | Futures | 81.4 | 81.54 | 81.18 | 81.32 | 20446.0 |
| 2013-11-04 | FBTS | Futures | 94.967 | 95.053 | 94.932 | 95.01 | 7291.0 |
| 2013-11-04 | FCE | Futures | 3321.8 | 3329.6 | 3310.2 | 3320.7 | 61488.0 |
| 2013-11-04 | FDAX | Futures | 10029.2 | 10053.1 | 10009.3 | 10025.4 | 57605.0 |
| 2013-11-04 | FESX | Futures | 2144.2 | 2147.0 | 2136.5 | 2140.7 | 428131.0 |
| 2013-11-04 | FEU3 | Futures | 98.502 | 98.507 | 98.502 | 98.502 | 17.0 |
| 2013-11-04 | FGBL | Futures | 120.79 | 120.98 | 120.77 | 120.82 | 343716.0 |
| 2013-11-04 | FGBM | Futures | 118.52 | 118.6 | 118.48 | 118.5 | 320385.0 |
| 2013-11-04 | FGBS | Futures | 110.558 | 110.578 | 110.533 | 110.558 | 221551.0 |
| 2013-11-04 | FGBX | Futures | 121.82 | 122.23 | 121.79 | 122.08 | 9359.0 |
| 2013-11-04 | FMWO | Futures | 5266.1 | 5266.1 | 5266.1 | 5266.1 | 0.0 |
| 2013-11-04 | FOAT | Futures | 108.81 | 108.9 | 108.72 | 108.8 | 31854.0 |
| 2013-11-04 | FTDX | Futures | 1073.7 | 1077.5 | 1072.8 | 1072.8 | 17.0 |
| 2013-11-04 | FTI | Futures | 337.85 | 339.75 | 337.5 | 338.58 | 15419.0 |
| 2013-11-04 | FTUK | Futures | 5051.7 | 5076.4 | 5043.8 | 5056.9 | 100491.0 |
| 2013-11-04 | FVSA | Futures | 2075.34 | 2099.68 | 2069.25 | 2075.34 | 1557.0 |
| 2013-11-04 | FXXP | Futures | 234.7 | 235.8 | 234.7 | 234.9 | 8399.0 |
| 2013-11-04 | G | Futures | 93.12 | 93.27 | 92.89 | 93.14 | 83066.0 |
| 2013-11-04 | GF | Futures | 264.059 | 264.261 | 263.091 | 263.898 | 1420.0 |
| 2013-11-04 | GSCI | Futures | 1014.85 | 1020.86 | 1010.85 | 1017.44 | 197.0 |
| 2013-11-04 | HE | Futures | 111.857 | 112.332 | 111.509 | 111.794 | 22408.0 |
| 2013-11-04 | HG | Futures | 4.1766 | 4.1892 | 4.112 | 4.119 | 55496.0 |
| 2013-11-04 | HH | Futures | 35.304 | 35.396 | 34.986 | 35.345 | 3190.0 |
| 2013-11-04 | HO | Futures | 2.3094 | 2.3223 | 2.2901 | 2.302 | 58140.0 |
> showing 50 of 103 rows — these rows as CSV