PREVIEW / futures_daily / 2013-01-23
file: by_date/futures_daily/2013/2013-01-23.parquet size: 9 KB rows: 100
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-01-23 | ES | Futures | 1525.07 | 1525.84 | 1518.93 | 1524.82 | 1192172.0 |
| 2013-01-23 | NQ | Futures | 3179.45 | 3193.58 | 3147.16 | 3182.34 | 189334.0 |
| 2013-01-23 | YM | Futures | 13440.0 | 13466.5 | 13407.7 | 13452.8 | 85885.0 |
| 2013-01-23 | CL | Futures | 170.51 | 170.8 | 167.32 | 167.82 | 318008.0 |
| 2013-01-23 | GC | Futures | 2254.4 | 2258.5 | 2242.9 | 2247.7 | 141433.0 |
| 2013-01-23 | ZN | Futures | 116.610991 | 116.845288 | 116.569645 | 116.693684 | 746276.0 |
| 2013-01-23 | A6 | Futures | 0.96259 | 0.96305 | 0.95939 | 0.96149 | 63469.0 |
| 2013-01-23 | AD | Futures | 1.00941 | 1.01122 | 1.00099 | 1.00209 | 102785.0 |
| 2013-01-23 | B | Futures | 105.45 | 105.98 | 105.02 | 105.66 | 132585.0 |
| 2013-01-23 | B6 | Futures | 1.6548 | 1.6603 | 1.6508 | 1.6548 | 117500.0 |
| 2013-01-23 | BR | Futures | 0.23858 | 0.2399 | 0.23858 | 0.23976 | 2243.0 |
| 2013-01-23 | BZ | Futures | 107.8 | 108.61 | 107.65 | 108.29 | 6679.0 |
| 2013-01-23 | C | Futures | 1551.0 | 1558.0 | 1534.0 | 1551.0 | 6480.0 |
| 2013-01-23 | CB | Futures | 85.227 | 85.227 | 84.185 | 84.315 | 27.0 |
| 2013-01-23 | CC | Futures | 1672.0 | 1685.0 | 1653.0 | 1671.0 | 14733.0 |
| 2013-01-23 | CSC | Futures | 3.621 | 3.625 | 3.603 | 3.61 | 35.0 |
| 2013-01-23 | CT | Futures | 100.56 | 101.32 | 99.35 | 101.29 | 23403.0 |
| 2013-01-23 | DC | Futures | 26.82 | 26.95 | 26.68 | 26.75 | 170.0 |
| 2013-01-23 | DX | Futures | 77.097 | 77.367 | 76.928 | 77.145 | 18756.0 |
| 2013-01-23 | E1 | Futures | 1.38625 | 1.38818 | 1.38252 | 1.38548 | 32929.0 |
| 2013-01-23 | E6 | Futures | 1.57168 | 1.57569 | 1.56495 | 1.57156 | 234950.0 |
| 2013-01-23 | E7 | Futures | 1.5607 | 1.5649 | 1.5544 | 1.5608 | 4466.0 |
| 2013-01-23 | EBM | Futures | 280.62 | 281.46 | 279.23 | 279.79 | 5924.0 |
| 2013-01-23 | ED | Futures | 95.2247 | 95.2342 | 95.2247 | 95.2295 | 68033.0 |
| 2013-01-23 | ER | Futures | 97.754 | 97.778 | 97.749 | 97.754 | 67503.0 |
| 2013-01-23 | EW | Futures | 1102.2 | 1102.9 | 1098.6 | 1102.7 | 11554.0 |
| 2013-01-23 | FBTP | Futures | 77.21 | 77.45 | 77.1 | 77.27 | 23589.0 |
| 2013-01-23 | FBTS | Futures | 91.772 | 91.798 | 91.705 | 91.772 | 2227.0 |
| 2013-01-23 | FCE | Futures | 2812.4 | 2816.5 | 2786.2 | 2796.3 | 75514.0 |
| 2013-01-23 | FDAX | Futures | 8424.5 | 8447.9 | 8395.5 | 8425.0 | 91941.0 |
| 2013-01-23 | FESX | Futures | 1853.4 | 1855.4 | 1839.0 | 1843.8 | 651715.0 |
| 2013-01-23 | FEU3 | Futures | 98.359 | 98.359 | 98.359 | 98.359 | 17.0 |
| 2013-01-23 | FGBL | Futures | 118.34 | 118.76 | 118.25 | 118.68 | 794032.0 |
| 2013-01-23 | FGBM | Futures | 116.24 | 116.5 | 116.22 | 116.46 | 605273.0 |
| 2013-01-23 | FGBS | Futures | 110.138 | 110.173 | 110.118 | 110.158 | 410656.0 |
| 2013-01-23 | FGBX | Futures | 124.95 | 125.31 | 124.35 | 125.14 | 16290.0 |
| 2013-01-23 | FOAT | Futures | 105.19 | 105.29 | 105.01 | 105.24 | 22739.0 |
| 2013-01-23 | FTDX | Futures | 827.9 | 837.9 | 827.9 | 836.9 | 187.0 |
| 2013-01-23 | FTI | Futures | 303.51 | 305.15 | 302.61 | 303.04 | 26857.0 |
| 2013-01-23 | FTUK | Futures | 4535.5 | 4539.9 | 4516.3 | 4531.4 | 73779.0 |
| 2013-01-23 | FVSA | Futures | 3075.97 | 3148.56 | 3021.53 | 3148.56 | 9848.0 |
| 2013-01-23 | FXXP | Futures | 206.9 | 207.4 | 206.5 | 207.1 | 4885.0 |
| 2013-01-23 | G | Futures | 97.44 | 97.47 | 97.05 | 97.41 | 160707.0 |
| 2013-01-23 | GF | Futures | 274.68 | 275.381 | 272.391 | 274.913 | 4347.0 |
| 2013-01-23 | GSCI | Futures | 1068.15 | 1069.51 | 1063.16 | 1064.45 | 218.0 |
| 2013-01-23 | HE | Futures | 98.918 | 99.058 | 97.49 | 98.582 | 22710.0 |
| 2013-01-23 | HG | Futures | 4.7578 | 4.7662 | 4.7212 | 4.7315 | 40037.0 |
| 2013-01-23 | HH | Futures | 41.349 | 42.018 | 41.243 | 41.725 | 2124.0 |
| 2013-01-23 | HO | Futures | 2.4656 | 2.4808 | 2.4561 | 2.4728 | 42466.0 |
| 2013-01-23 | HRC | Futures | 2353.9 | 2353.9 | 2353.9 | 2353.9 | 200.0 |
> showing 50 of 100 rows — these rows as CSV