PREVIEW / futures_daily / 2013-05-21
file: by_date/futures_daily/2013/2013-05-21.parquet size: 9 KB rows: 103
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-05-21 | ES | Futures | 1707.85 | 1717.86 | 1704.25 | 1709.9 | 1694697.0 |
| 2013-05-21 | NQ | Futures | 3487.79 | 3507.72 | 3476.82 | 3490.1 | 185202.0 |
| 2013-05-21 | YM | Futures | 15080.8 | 15178.3 | 15064.0 | 15120.2 | 123536.0 |
| 2013-05-21 | CL | Futures | 168.96 | 169.54 | 166.92 | 167.73 | 259159.0 |
| 2013-05-21 | GC | Futures | 1848.4 | 1858.4 | 1802.8 | 1828.8 | 225016.0 |
| 2013-05-21 | ZN | Futures | 117.378502 | 117.628954 | 117.114136 | 117.461986 | 1662154.0 |
| 2013-05-21 | A6 | Futures | 0.90356 | 0.90679 | 0.8983 | 0.9031 | 147920.0 |
| 2013-05-21 | AD | Futures | 0.98045 | 0.98095 | 0.97281 | 0.97763 | 83056.0 |
| 2013-05-21 | B | Futures | 100.82 | 101.17 | 99.6 | 99.98 | 179064.0 |
| 2013-05-21 | B6 | Futures | 1.5966 | 1.5983 | 1.5811 | 1.5852 | 141015.0 |
| 2013-05-21 | BFX | Futures | 3266.0 | 3269.9 | 3266.0 | 3269.9 | 66.0 |
| 2013-05-21 | BR | Futures | 0.2421 | 0.24304 | 0.24188 | 0.24255 | 91.0 |
| 2013-05-21 | BZ | Futures | 101.99 | 102.15 | 100.6 | 100.99 | 3839.0 |
| 2013-05-21 | C | Futures | 1648.0 | 1687.0 | 1645.0 | 1683.0 | 7499.0 |
| 2013-05-21 | CB | Futures | 81.105 | 81.105 | 80.846 | 80.859 | 35.0 |
| 2013-05-21 | CC | Futures | 1728.0 | 1762.0 | 1719.0 | 1758.0 | 14386.0 |
| 2013-05-21 | CNH | Futures | 7.1573 | 7.1647 | 7.1524 | 7.1599 | 90.0 |
| 2013-05-21 | CSC | Futures | 3.589 | 3.605 | 3.583 | 3.585 | 5.0 |
| 2013-05-21 | CT | Futures | 102.57 | 102.77 | 100.46 | 100.5 | 19395.0 |
| 2013-05-21 | DC | Futures | 27.63 | 27.77 | 27.31 | 27.43 | 176.0 |
| 2013-05-21 | DX | Futures | 80.62 | 81.019 | 80.476 | 80.687 | 42611.0 |
| 2013-05-21 | E1 | Futures | 1.33143 | 1.33272 | 1.31959 | 1.32603 | 52877.0 |
| 2013-05-21 | E6 | Futures | 1.51932 | 1.52509 | 1.51413 | 1.5212 | 258625.0 |
| 2013-05-21 | E7 | Futures | 1.5095 | 1.5151 | 1.5044 | 1.5113 | 3014.0 |
| 2013-05-21 | ED | Futures | 95.2707 | 95.2707 | 95.2683 | 95.2683 | 67364.0 |
| 2013-05-21 | ER | Futures | 97.832 | 97.842 | 97.827 | 97.832 | 37977.0 |
| 2013-05-21 | EW | Futures | 1235.4 | 1241.6 | 1232.4 | 1237.0 | 13306.0 |
| 2013-05-21 | FBTP | Futures | 80.12 | 80.23 | 79.92 | 79.96 | 25923.0 |
| 2013-05-21 | FBTS | Futures | 93.22 | 93.22 | 93.109 | 93.134 | 7822.0 |
| 2013-05-21 | FCE | Futures | 3084.4 | 3117.7 | 3075.1 | 3110.3 | 90643.0 |
| 2013-05-21 | FDAX | Futures | 9376.7 | 9435.6 | 9333.3 | 9400.0 | 91738.0 |
| 2013-05-21 | FESX | Futures | 1966.5 | 1975.6 | 1951.8 | 1965.1 | 823069.0 |
| 2013-05-21 | FGBL | Futures | 121.41 | 121.46 | 120.9 | 120.97 | 871196.0 |
| 2013-05-21 | FGBM | Futures | 118.06 | 118.09 | 117.82 | 117.86 | 586297.0 |
| 2013-05-21 | FGBS | Futures | 110.542 | 110.562 | 110.522 | 110.527 | 291325.0 |
| 2013-05-21 | FGBX | Futures | 126.74 | 126.95 | 125.73 | 125.98 | 11526.0 |
| 2013-05-21 | FMWO | Futures | 4970.1 | 4973.9 | 4970.1 | 4973.9 | 68.0 |
| 2013-05-21 | FOAT | Futures | 109.47 | 109.55 | 109.06 | 109.09 | 27914.0 |
| 2013-05-21 | FTDX | Futures | 917.4 | 917.4 | 907.0 | 914.1 | 79.0 |
| 2013-05-21 | FTI | Futures | 321.23 | 322.53 | 319.83 | 322.23 | 20931.0 |
| 2013-05-21 | FTUK | Futures | 4996.8 | 5044.0 | 4990.1 | 5025.1 | 73163.0 |
| 2013-05-21 | FVSA | Futures | 2868.57 | 2944.86 | 2868.57 | 2891.46 | 6868.0 |
| 2013-05-21 | FXXP | Futures | 227.3 | 227.3 | 225.6 | 226.6 | 5692.0 |
| 2013-05-21 | G | Futures | 98.58 | 98.96 | 98.44 | 98.49 | 208287.0 |
| 2013-05-21 | GF | Futures | 244.772 | 247.51 | 244.52 | 246.794 | 3305.0 |
| 2013-05-21 | GSCI | Futures | 1028.83 | 1028.83 | 1019.03 | 1022.19 | 149.0 |
| 2013-05-21 | HE | Futures | 90.397 | 91.108 | 90.004 | 90.642 | 13083.0 |
| 2013-05-21 | HG | Futures | 4.2774 | 4.308 | 4.2328 | 4.2596 | 54536.0 |
| 2013-05-21 | HH | Futures | 46.687 | 47.227 | 46.687 | 47.103 | 2818.0 |
| 2013-05-21 | HO | Futures | 2.3763 | 2.3763 | 2.345 | 2.3523 | 8415.0 |
> showing 50 of 103 rows — these rows as CSV