PREVIEW / futures_daily / 2012-12-06
file: by_date/futures_daily/2012/2012-12-06.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-06 | ES | Futures | 1431.51 | 1438.64 | 1428.97 | 1438.13 | 1382373.0 |
| 2012-12-06 | NQ | Futures | 3033.01 | 3062.93 | 3017.48 | 3053.72 | 298028.0 |
| 2012-12-06 | YM | Futures | 12709.0 | 12765.7 | 12691.5 | 12755.9 | 106044.0 |
| 2012-12-06 | CL | Futures | 157.34 | 157.98 | 153.41 | 154.45 | 269293.0 |
| 2012-12-06 | GC | Futures | 2259.7 | 2271.9 | 2248.3 | 2267.9 | 145846.0 |
| 2012-12-06 | ZN | Futures | 118.029881 | 118.222157 | 118.002413 | 118.098551 | 26324.0 |
| 2012-12-06 | A6 | Futures | 0.94925 | 0.95489 | 0.94807 | 0.95107 | 129968.0 |
| 2012-12-06 | AD | Futures | 1.01161 | 1.01442 | 1.01081 | 1.01182 | 81209.0 |
| 2012-12-06 | B | Futures | 100.47 | 100.99 | 98.71 | 99.09 | 131496.0 |
| 2012-12-06 | B6 | Futures | 1.6808 | 1.6844 | 1.6751 | 1.676 | 124463.0 |
| 2012-12-06 | BFX | Futures | 2919.2 | 2925.2 | 2914.0 | 2924.7 | 27.0 |
| 2012-12-06 | BR | Futures | 0.23421 | 0.23421 | 0.23289 | 0.23323 | 119.0 |
| 2012-12-06 | BZ | Futures | 103.7 | 104.02 | 102.01 | 102.08 | 833.0 |
| 2012-12-06 | C | Futures | 1620.0 | 1645.0 | 1614.0 | 1642.0 | 11941.0 |
| 2012-12-06 | CB | Futures | 87.834 | 87.834 | 87.834 | 87.834 | 8.0 |
| 2012-12-06 | CC | Futures | 1826.0 | 1836.0 | 1809.0 | 1826.0 | 10313.0 |
| 2012-12-06 | CSC | Futures | 3.916 | 3.922 | 3.914 | 3.916 | 29.0 |
| 2012-12-06 | CT | Futures | 91.92 | 93.07 | 91.68 | 92.56 | 9890.0 |
| 2012-12-06 | DC | Futures | 28.99 | 29.1 | 28.94 | 28.99 | 92.0 |
| 2012-12-06 | DX | Futures | 77.358 | 77.799 | 77.223 | 77.734 | 25640.0 |
| 2012-12-06 | E1 | Futures | 1.38934 | 1.39076 | 1.37827 | 1.37969 | 36229.0 |
| 2012-12-06 | E6 | Futures | 1.53933 | 1.54122 | 1.52509 | 1.52662 | 319195.0 |
| 2012-12-06 | E7 | Futures | 1.5304 | 1.532 | 1.5161 | 1.5175 | 3678.0 |
| 2012-12-06 | EBM | Futures | 297.59 | 297.87 | 295.64 | 296.48 | 12536.0 |
| 2012-12-06 | ED | Futures | 95.2349 | 95.2372 | 95.2349 | 95.2349 | 56765.0 |
| 2012-12-06 | ER | Futures | 97.881 | 97.896 | 97.871 | 97.881 | 130399.0 |
| 2012-12-06 | EW | Futures | 1016.4 | 1022.6 | 1015.5 | 1020.3 | 15035.0 |
| 2012-12-06 | FBTP | Futures | 75.15 | 75.51 | 74.36 | 74.82 | 31265.0 |
| 2012-12-06 | FBTS | Futures | 90.705 | 90.765 | 90.206 | 90.544 | 8576.0 |
| 2012-12-06 | FCE | Futures | 2715.3 | 2728.1 | 2699.8 | 2710.0 | 113241.0 |
| 2012-12-06 | FDAX | Futures | 8181.6 | 8280.2 | 8173.9 | 8257.7 | 140049.0 |
| 2012-12-06 | FESX | Futures | 1766.8 | 1782.5 | 1762.1 | 1771.6 | 994587.0 |
| 2012-12-06 | FGBL | Futures | 119.87 | 120.46 | 119.78 | 120.42 | 685762.0 |
| 2012-12-06 | FGBM | Futures | 117.13 | 117.57 | 117.12 | 117.55 | 392425.0 |
| 2012-12-06 | FGBS | Futures | 110.482 | 110.607 | 110.467 | 110.597 | 416580.0 |
| 2012-12-06 | FGBX | Futures | 127.27 | 127.62 | 126.61 | 127.57 | 8228.0 |
| 2012-12-06 | FOAT | Futures | 106.07 | 106.11 | 105.65 | 106.04 | 38131.0 |
| 2012-12-06 | FTDX | Futures | 790.5 | 796.6 | 788.6 | 791.4 | 105.0 |
| 2012-12-06 | FTI | Futures | 291.01 | 293.76 | 290.93 | 292.56 | 32065.0 |
| 2012-12-06 | FTUK | Futures | 4314.1 | 4336.8 | 4306.4 | 4321.1 | 74545.0 |
| 2012-12-06 | FVSA | Futures | 4070.43 | 4116.43 | 4001.44 | 4035.94 | 7953.0 |
| 2012-12-06 | FXXP | Futures | 200.3 | 201.5 | 200.3 | 201.3 | 1093.0 |
| 2012-12-06 | G | Futures | 99.16 | 99.5 | 98.91 | 99.49 | 125288.0 |
| 2012-12-06 | GF | Futures | 278.18 | 281.927 | 277.278 | 281.31 | 5130.0 |
| 2012-12-06 | GSCI | Futures | 1030.77 | 1031.26 | 1022.22 | 1022.95 | 328.0 |
| 2012-12-06 | HE | Futures | 98.208 | 98.322 | 96.601 | 96.916 | 21991.0 |
| 2012-12-06 | HG | Futures | 4.7212 | 4.7373 | 4.6653 | 4.6801 | 47522.0 |
| 2012-12-06 | HH | Futures | 43.04 | 43.04 | 43.04 | 43.04 | 814.0 |
| 2012-12-06 | HO | Futures | 2.4131 | 2.4212 | 2.3696 | 2.375 | 16736.0 |
| 2012-12-06 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
> showing 50 of 101 rows — these rows as CSV