PREVIEW / futures_daily / 2013-12-23
file: by_date/futures_daily/2013/2013-12-23.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 |
|---|---|---|---|---|---|---|---|
| 2013-12-23 | ES | Futures | 1873.07 | 1880.8 | 1872.81 | 1878.99 | 737153.0 |
| 2013-12-23 | NQ | Futures | 4070.76 | 4101.22 | 4070.76 | 4098.06 | 131151.0 |
| 2013-12-23 | YM | Futures | 16182.4 | 16231.4 | 16179.4 | 16212.4 | 53229.0 |
| 2013-12-23 | CL | Futures | 175.13 | 175.32 | 174.14 | 174.61 | 107273.0 |
| 2013-12-23 | GC | Futures | 1592.2 | 1596.3 | 1578.0 | 1584.9 | 84975.0 |
| 2013-12-23 | ZN | Futures | 113.28952 | 113.318135 | 113.003363 | 113.031979 | 398009.0 |
| 2013-12-23 | A6 | Futures | 0.84558 | 0.8492 | 0.84539 | 0.84672 | 37408.0 |
| 2013-12-23 | AD | Futures | 0.94944 | 0.95501 | 0.94853 | 0.95278 | 42614.0 |
| 2013-12-23 | B | Futures | 113.35 | 113.73 | 113.06 | 113.36 | 103720.0 |
| 2013-12-23 | B6 | Futures | 1.7147 | 1.7194 | 1.7139 | 1.7165 | 44924.0 |
| 2013-12-23 | BR | Futures | 0.21477 | 0.21578 | 0.21477 | 0.21528 | 8.0 |
| 2013-12-23 | BZ | Futures | 115.78 | 115.78 | 115.04 | 115.33 | 3285.0 |
| 2013-12-23 | C | Futures | 1898.0 | 1907.0 | 1884.0 | 1890.0 | 4891.0 |
| 2013-12-23 | CB | Futures | 80.961 | 81.035 | 80.029 | 80.238 | 39.0 |
| 2013-12-23 | CC | Futures | 2092.0 | 2097.0 | 2067.0 | 2084.0 | 7287.0 |
| 2013-12-23 | CNH | Futures | 6.9995 | 7.0022 | 6.9994 | 7.0022 | 172.0 |
| 2013-12-23 | CSC | Futures | 3.832 | 3.832 | 3.807 | 3.812 | 4.0 |
| 2013-12-23 | CT | Futures | 94.64 | 94.71 | 92.84 | 93.77 | 10100.0 |
| 2013-12-23 | DC | Futures | 29.59 | 29.68 | 29.29 | 29.4 | 146.0 |
| 2013-12-23 | DX | Futures | 76.79 | 76.79 | 76.514 | 76.663 | 18039.0 |
| 2013-12-23 | E1 | Futures | 1.43391 | 1.43968 | 1.43262 | 1.43647 | 16205.0 |
| 2013-12-23 | E6 | Futures | 1.61368 | 1.61911 | 1.61368 | 1.61593 | 80934.0 |
| 2013-12-23 | E7 | Futures | 1.603 | 1.6086 | 1.603 | 1.6054 | 2916.0 |
| 2013-12-23 | EBM | Futures | 286.09 | 288.18 | 285.4 | 287.49 | 5775.0 |
| 2013-12-23 | ED | Futures | 95.3375 | 95.3423 | 95.3327 | 95.3375 | 73841.0 |
| 2013-12-23 | ER | Futures | 97.842 | 97.857 | 97.842 | 97.852 | 29917.0 |
| 2013-12-23 | EW | Futures | 1345.7 | 1356.3 | 1345.4 | 1355.6 | 11288.0 |
| 2013-12-23 | FBTP | Futures | 81.79 | 81.8 | 81.42 | 81.49 | 12908.0 |
| 2013-12-23 | FBTS | Futures | 95.539 | 95.556 | 95.425 | 95.451 | 2475.0 |
| 2013-12-23 | FCE | Futures | 3281.4 | 3291.9 | 3266.2 | 3288.8 | 51586.0 |
| 2013-12-23 | FDAX | Futures | 10480.1 | 10554.4 | 10463.5 | 10526.7 | 43739.0 |
| 2013-12-23 | FESX | Futures | 2150.6 | 2162.6 | 2142.2 | 2156.3 | 362534.0 |
| 2013-12-23 | FEU3 | Futures | 98.473 | 98.473 | 98.468 | 98.468 | 4.0 |
| 2013-12-23 | FGBL | Futures | 118.94 | 119.08 | 118.81 | 118.92 | 148714.0 |
| 2013-12-23 | FGBM | Futures | 117.32 | 117.36 | 117.22 | 117.34 | 109721.0 |
| 2013-12-23 | FGBS | Futures | 110.313 | 110.318 | 110.293 | 110.308 | 66763.0 |
| 2013-12-23 | FGBX | Futures | 119.81 | 120.04 | 119.38 | 119.89 | 6827.0 |
| 2013-12-23 | FMWO | Futures | 5370.4 | 5370.4 | 5370.4 | 5370.4 | 0.0 |
| 2013-12-23 | FOAT | Futures | 108.15 | 108.2 | 107.98 | 108.03 | 8741.0 |
| 2013-12-23 | FTDX | Futures | 1092.0 | 1104.7 | 1089.2 | 1094.8 | 103.0 |
| 2013-12-23 | FTI | Futures | 337.71 | 339.85 | 337.41 | 339.72 | 15841.0 |
| 2013-12-23 | FTUK | Futures | 4970.0 | 5021.1 | 4963.9 | 5013.9 | 49526.0 |
| 2013-12-23 | FVSA | Futures | 1843.06 | 1864.55 | 1826.94 | 1837.68 | 2432.0 |
| 2013-12-23 | FXXP | Futures | 235.7 | 239.7 | 235.7 | 236.9 | 3704.0 |
| 2013-12-23 | G | Futures | 90.64 | 90.73 | 90.48 | 90.6 | 39052.0 |
| 2013-12-23 | GF | Futures | 268.287 | 269.052 | 267.643 | 268.328 | 3600.0 |
| 2013-12-23 | GSCI | Futures | 1052.68 | 1052.68 | 1049.3 | 1049.3 | 86.0 |
| 2013-12-23 | HE | Futures | 104.166 | 104.498 | 103.984 | 104.105 | 5754.0 |
| 2013-12-23 | HG | Futures | 4.1749 | 4.1869 | 4.1667 | 4.1774 | 25004.0 |
| 2013-12-23 | HH | Futures | 45.12 | 45.12 | 44.649 | 44.709 | 4172.0 |
> showing 50 of 104 rows — these rows as CSV