PREVIEW / futures_daily / 2013-03-19
file: by_date/futures_daily/2013/2013-03-19.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-03-19 | ES | Futures | 1588.5 | 1592.61 | 1572.59 | 1583.37 | 2546167.0 |
| 2013-03-19 | NQ | Futures | 3219.52 | 3234.25 | 3182.56 | 3210.57 | 280858.0 |
| 2013-03-19 | YM | Futures | 14168.9 | 14222.1 | 14089.2 | 14167.9 | 210333.0 |
| 2013-03-19 | CL | Futures | 164.45 | 164.89 | 161.2 | 161.48 | 286833.0 |
| 2013-03-19 | GC | Futures | 2131.6 | 2146.6 | 2125.4 | 2141.7 | 165885.0 |
| 2013-03-19 | ZN | Futures | 116.84977 | 117.308932 | 116.724544 | 117.155878 | 1574433.0 |
| 2013-03-19 | A6 | Futures | 0.9535 | 0.95396 | 0.94897 | 0.95045 | 77943.0 |
| 2013-03-19 | AD | Futures | 0.98175 | 0.98175 | 0.97502 | 0.97592 | 63224.0 |
| 2013-03-19 | B | Futures | 104.27 | 104.39 | 102.21 | 102.4 | 226677.0 |
| 2013-03-19 | B6 | Futures | 1.5801 | 1.584 | 1.5765 | 1.5794 | 113490.0 |
| 2013-03-19 | BFX | Futures | 3149.4 | 3149.4 | 3120.0 | 3123.8 | 14.0 |
| 2013-03-19 | BR | Futures | 0.24799 | 0.24799 | 0.24725 | 0.24745 | 165.0 |
| 2013-03-19 | BZ | Futures | 106.63 | 106.78 | 104.69 | 104.86 | 3327.0 |
| 2013-03-19 | C | Futures | 1506.0 | 1514.0 | 1496.0 | 1501.0 | 5433.0 |
| 2013-03-19 | CB | Futures | 86.282 | 86.282 | 86.048 | 86.282 | 93.0 |
| 2013-03-19 | CC | Futures | 1583.0 | 1603.0 | 1578.0 | 1588.0 | 10426.0 |
| 2013-03-19 | CSC | Futures | 3.69 | 3.698 | 3.69 | 3.694 | 16.0 |
| 2013-03-19 | CT | Futures | 111.74 | 112.77 | 111.27 | 112.11 | 9048.0 |
| 2013-03-19 | DC | Futures | 27.92 | 28.4 | 27.84 | 28.24 | 335.0 |
| 2013-03-19 | DX | Futures | 79.707 | 80.072 | 79.606 | 79.972 | 32722.0 |
| 2013-03-19 | E1 | Futures | 1.36114 | 1.36642 | 1.35677 | 1.35896 | 36258.0 |
| 2013-03-19 | E6 | Futures | 1.52887 | 1.53004 | 1.51519 | 1.51896 | 410877.0 |
| 2013-03-19 | E7 | Futures | 1.5188 | 1.5199 | 1.5054 | 1.5091 | 7307.0 |
| 2013-03-19 | EBM | Futures | 274.48 | 278.27 | 274.19 | 277.98 | 16343.0 |
| 2013-03-19 | ED | Futures | 95.2349 | 95.2396 | 95.1966 | 95.211 | 581703.0 |
| 2013-03-19 | ER | Futures | 97.793 | 97.798 | 97.685 | 97.729 | 443193.0 |
| 2013-03-19 | EW | Futures | 1159.4 | 1162.8 | 1145.6 | 1154.8 | 18652.0 |
| 2013-03-19 | FBTP | Futures | 75.11 | 75.12 | 74.45 | 74.67 | 31378.0 |
| 2013-03-19 | FBTS | Futures | 91.32 | 91.328 | 91.063 | 91.174 | 4052.0 |
| 2013-03-19 | FCE | Futures | 2869.6 | 2877.8 | 2833.8 | 2845.8 | 98237.0 |
| 2013-03-19 | FDAX | Futures | 8889.8 | 8909.8 | 8818.1 | 8857.5 | 128288.0 |
| 2013-03-19 | FDIV | Futures | 117.76 | 117.76 | 117.16 | 117.16 | 8.0 |
| 2013-03-19 | FESX | Futures | 1839.9 | 1844.1 | 1812.7 | 1824.6 | 1188985.0 |
| 2013-03-19 | FEU3 | Futures | 98.344 | 98.344 | 98.295 | 98.33 | 90.0 |
| 2013-03-19 | FGBL | Futures | 120.73 | 121.38 | 120.67 | 121.21 | 984761.0 |
| 2013-03-19 | FGBM | Futures | 117.84 | 118.09 | 117.81 | 118.03 | 447891.0 |
| 2013-03-19 | FGBS | Futures | 110.497 | 110.552 | 110.482 | 110.537 | 446308.0 |
| 2013-03-19 | FGBX | Futures | 126.68 | 129.04 | 126.57 | 128.35 | 15140.0 |
| 2013-03-19 | FMWO | Futures | 4658.1 | 4658.1 | 4628.9 | 4628.9 | 69.0 |
| 2013-03-19 | FOAT | Futures | 106.84 | 107.14 | 106.7 | 107.04 | 43822.0 |
| 2013-03-19 | FTDX | Futures | 874.8 | 874.8 | 862.0 | 867.2 | 85.0 |
| 2013-03-19 | FTI | Futures | 302.82 | 304.89 | 301.57 | 302.9 | 27832.0 |
| 2013-03-19 | FTUK | Futures | 4741.3 | 4759.8 | 4713.8 | 4736.8 | 84057.0 |
| 2013-03-19 | FVSA | Futures | 3237.88 | 3589.28 | 3221.15 | 3530.71 | 32917.0 |
| 2013-03-19 | FXXP | Futures | 213.2 | 214.4 | 212.8 | 213.6 | 11987.0 |
| 2013-03-19 | G | Futures | 98.48 | 99.05 | 98.37 | 98.91 | 148698.0 |
| 2013-03-19 | GF | Futures | 255.781 | 255.781 | 252.473 | 254.311 | 2585.0 |
| 2013-03-19 | GSCI | Futures | 1040.93 | 1043.1 | 1030.66 | 1031.86 | 111.0 |
| 2013-03-19 | HE | Futures | 89.356 | 89.558 | 88.123 | 88.601 | 305.0 |
| 2013-03-19 | HG | Futures | 4.3549 | 4.39 | 4.3224 | 4.3447 | 58306.0 |
> showing 50 of 104 rows — these rows as CSV