PREVIEW / futures_daily / 2011-11-14
file: by_date/futures_daily/2011/2011-11-14.parquet size: 9 KB rows: 96
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-14 | ES | Futures | 1262.03 | 1268.52 | 1241.32 | 1250.3 | 1889071.0 |
| 2011-11-14 | NQ | Futures | 2688.13 | 2701.26 | 2659.31 | 2674.43 | 184831.0 |
| 2011-11-14 | YM | Futures | 11651.8 | 11722.9 | 11513.5 | 11585.6 | 109923.0 |
| 2011-11-14 | CL | Futures | 185.71 | 186.66 | 182.26 | 184.13 | 159897.0 |
| 2011-11-14 | GC | Futures | 2416.0 | 2427.0 | 2395.4 | 2401.1 | 87588.0 |
| 2011-11-14 | ZN | Futures | 111.361902 | 112.059087 | 111.214421 | 111.93842 | 753242.0 |
| 2011-11-14 | A6 | Futures | 0.90304 | 0.90576 | 0.88985 | 0.89072 | 90086.0 |
| 2011-11-14 | AD | Futures | 0.98865 | 0.99085 | 0.98074 | 0.98234 | 46718.0 |
| 2011-11-14 | B | Futures | 100.47 | 100.55 | 97.84 | 98.5 | 203995.0 |
| 2011-11-14 | B6 | Futures | 1.6765 | 1.6793 | 1.6567 | 1.6581 | 81017.0 |
| 2011-11-14 | BFX | Futures | 2490.1 | 2490.1 | 2490.1 | 2490.1 | 328.0 |
| 2011-11-14 | BR | Futures | 0.25476 | 0.25476 | 0.25476 | 0.25476 | 120.0 |
| 2011-11-14 | BZ | Futures | 104.5 | 104.53 | 103.35 | 104.01 | 584.0 |
| 2011-11-14 | C | Futures | 1677.0 | 1693.0 | 1648.0 | 1668.0 | 2973.0 |
| 2011-11-14 | CC | Futures | 2001.0 | 2004.0 | 1950.0 | 1981.0 | 13084.0 |
| 2011-11-14 | CSC | Futures | 4.509 | 4.583 | 4.509 | 4.583 | 7.0 |
| 2011-11-14 | CT | Futures | 128.77 | 130.08 | 126.07 | 129.94 | 14283.0 |
| 2011-11-14 | DC | Futures | 31.56 | 32.65 | 31.56 | 32.52 | 633.0 |
| 2011-11-14 | DX | Futures | 75.568 | 76.417 | 75.518 | 76.331 | 19089.0 |
| 2011-11-14 | E1 | Futures | 1.45963 | 1.46488 | 1.44349 | 1.44559 | 19345.0 |
| 2011-11-14 | E6 | Futures | 1.6464 | 1.64867 | 1.62429 | 1.6268 | 229167.0 |
| 2011-11-14 | E7 | Futures | 1.632 | 1.6345 | 1.6104 | 1.6129 | 4575.0 |
| 2011-11-14 | ED | Futures | 94.922 | 94.9364 | 94.9053 | 94.9101 | 193816.0 |
| 2011-11-14 | ER | Futures | 97.297 | 97.332 | 97.287 | 97.322 | 177357.0 |
| 2011-11-14 | EW | Futures | 894.7 | 899.5 | 879.4 | 887.7 | 24702.0 |
| 2011-11-14 | FBTP | Futures | 58.36 | 58.85 | 56.86 | 57.26 | 20559.0 |
| 2011-11-14 | FBTS | Futures | 79.664 | 79.865 | 78.572 | 78.918 | 1621.0 |
| 2011-11-14 | FCE | Futures | 2258.9 | 2267.8 | 2201.7 | 2219.6 | 24838.0 |
| 2011-11-14 | FDAX | Futures | 6611.5 | 6661.5 | 6432.9 | 6516.0 | 165732.0 |
| 2011-11-14 | FESX | Futures | 1553.1 | 1559.7 | 1505.9 | 1522.5 | 1146575.0 |
| 2011-11-14 | FGBL | Futures | 111.07 | 112.22 | 110.87 | 111.86 | 667546.0 |
| 2011-11-14 | FGBM | Futures | 111.63 | 112.27 | 111.55 | 112.05 | 363013.0 |
| 2011-11-14 | FGBS | Futures | 109.392 | 109.526 | 109.352 | 109.442 | 340767.0 |
| 2011-11-14 | FGBX | Futures | 114.3 | 116.41 | 113.9 | 115.66 | 5609.0 |
| 2011-11-14 | FTDX | Futures | 652.3 | 660.6 | 636.2 | 642.2 | 394.0 |
| 2011-11-14 | FTI | Futures | 254.38 | 254.38 | 247.87 | 249.51 | 5871.0 |
| 2011-11-14 | FTUK | Futures | 3975.3 | 4002.2 | 3923.6 | 3952.0 | 100268.0 |
| 2011-11-14 | FVSA | Futures | 15980.6 | 16194.82 | 15680.7 | 15916.34 | 3453.0 |
| 2011-11-14 | FXXP | Futures | 168.7 | 168.7 | 165.1 | 166.2 | 844.0 |
| 2011-11-14 | G | Futures | 92.16 | 92.85 | 92.07 | 92.64 | 91180.0 |
| 2011-11-14 | GF | Futures | 314.495 | 315.303 | 313.741 | 314.064 | 1695.0 |
| 2011-11-14 | GSCI | Futures | 1029.21 | 1030.3 | 1020.53 | 1023.71 | 99.0 |
| 2011-11-14 | HE | Futures | 111.315 | 112.279 | 110.801 | 111.283 | 14859.0 |
| 2011-11-14 | HG | Futures | 4.5971 | 4.7446 | 4.5931 | 4.6156 | 39819.0 |
| 2011-11-14 | HO | Futures | 2.5593 | 2.5707 | 2.5353 | 2.54 | 47593.0 |
| 2011-11-14 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-14 | J1 | Futures | 0.0162846 | 0.0163675 | 0.0162758 | 0.0163021 | 53726.0 |
| 2011-11-14 | J7 | Futures | 0.016189 | 0.016268 | 0.016177 | 0.016203 | 295.0 |
| 2011-11-14 | JB | Futures | 124.67 | 124.71 | 124.55 | 124.69 | 2904.0 |
| 2011-11-14 | KC | Futures | 559.19 | 561.66 | 537.51 | 544.22 | 13085.0 |
> showing 50 of 96 rows — these rows as CSV