PREVIEW / futures_daily / 2013-05-23
file: by_date/futures_daily/2013/2013-05-23.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-05-23 | ES | Futures | 1701.69 | 1703.23 | 1676.28 | 1693.99 | 2681434.0 |
| 2013-05-23 | NQ | Futures | 3472.49 | 3475.09 | 3420.51 | 3456.32 | 313279.0 |
| 2013-05-23 | YM | Futures | 15098.5 | 15110.3 | 14911.4 | 15055.2 | 260247.0 |
| 2013-05-23 | CL | Futures | 164.24 | 164.73 | 160.8 | 164.36 | 323633.0 |
| 2013-05-23 | GC | Futures | 1815.9 | 1854.7 | 1798.8 | 1847.6 | 220700.0 |
| 2013-05-23 | ZN | Futures | 116.766286 | 117.308932 | 116.543662 | 116.891512 | 2443629.0 |
| 2013-05-23 | A6 | Futures | 0.89285 | 0.90116 | 0.88408 | 0.89728 | 206807.0 |
| 2013-05-23 | AD | Futures | 0.96789 | 0.97612 | 0.96608 | 0.97442 | 109031.0 |
| 2013-05-23 | B | Futures | 98.38 | 98.8 | 96.83 | 98.57 | 230369.0 |
| 2013-05-23 | B6 | Futures | 1.5737 | 1.5829 | 1.5708 | 1.5803 | 136036.0 |
| 2013-05-23 | BFX | Futures | 3218.7 | 3236.6 | 3218.7 | 3236.6 | 2.0 |
| 2013-05-23 | BR | Futures | 0.24071 | 0.24193 | 0.24071 | 0.24173 | 252.0 |
| 2013-05-23 | BZ | Futures | 99.41 | 99.77 | 97.83 | 99.56 | 4740.0 |
| 2013-05-23 | C | Futures | 1666.0 | 1688.0 | 1645.0 | 1649.0 | 5564.0 |
| 2013-05-23 | CB | Futures | 80.069 | 80.763 | 80.069 | 80.368 | 22.0 |
| 2013-05-23 | CC | Futures | 1732.0 | 1750.0 | 1695.0 | 1712.0 | 17927.0 |
| 2013-05-23 | CNH | Futures | 7.1605 | 7.1655 | 7.1543 | 7.1543 | 36.0 |
| 2013-05-23 | CSC | Futures | 3.629 | 3.641 | 3.613 | 3.641 | 2.0 |
| 2013-05-23 | CT | Futures | 99.98 | 100.53 | 97.7 | 98.01 | 27731.0 |
| 2013-05-23 | DC | Futures | 27.57 | 27.9 | 27.4 | 27.86 | 334.0 |
| 2013-05-23 | DX | Futures | 81.149 | 81.303 | 80.409 | 80.541 | 61589.0 |
| 2013-05-23 | E1 | Futures | 1.31393 | 1.33567 | 1.31046 | 1.3277 | 69429.0 |
| 2013-05-23 | E6 | Futures | 1.51531 | 1.5278 | 1.51177 | 1.52474 | 325451.0 |
| 2013-05-23 | E7 | Futures | 1.5053 | 1.5177 | 1.502 | 1.5148 | 4697.0 |
| 2013-05-23 | ED | Futures | 95.2707 | 95.2731 | 95.2683 | 95.2707 | 130488.0 |
| 2013-05-23 | ER | Futures | 97.832 | 97.837 | 97.827 | 97.827 | 38980.0 |
| 2013-05-23 | EW | Futures | 1219.3 | 1219.8 | 1199.2 | 1216.7 | 23194.0 |
| 2013-05-23 | FBTP | Futures | 79.91 | 79.93 | 79.08 | 79.41 | 58250.0 |
| 2013-05-23 | FBTS | Futures | 93.083 | 93.091 | 92.86 | 92.954 | 13336.0 |
| 2013-05-23 | FCE | Futures | 3071.2 | 3078.2 | 3036.0 | 3057.7 | 178051.0 |
| 2013-05-23 | FDAX | Futures | 9321.7 | 9365.6 | 9206.0 | 9287.7 | 146778.0 |
| 2013-05-23 | FDIV | Futures | 124.97 | 125.86 | 124.97 | 125.86 | 180.0 |
| 2013-05-23 | FESX | Futures | 1942.0 | 1948.3 | 1923.9 | 1938.5 | 1515984.0 |
| 2013-05-23 | FGBL | Futures | 121.2 | 121.65 | 120.95 | 121.02 | 1092607.0 |
| 2013-05-23 | FGBM | Futures | 118.01 | 118.21 | 117.78 | 117.84 | 756332.0 |
| 2013-05-23 | FGBS | Futures | 110.562 | 110.582 | 110.517 | 110.527 | 419106.0 |
| 2013-05-23 | FGBX | Futures | 126.51 | 127.33 | 126.15 | 126.28 | 13281.0 |
| 2013-05-23 | FMWO | Futures | 4877.5 | 4882.6 | 4868.6 | 4882.6 | 14.0 |
| 2013-05-23 | FOAT | Futures | 109.19 | 109.5 | 108.9 | 108.99 | 61695.0 |
| 2013-05-23 | FTDX | Futures | 919.8 | 919.8 | 899.9 | 907.9 | 127.0 |
| 2013-05-23 | FTI | Futures | 320.53 | 320.75 | 315.96 | 317.66 | 41272.0 |
| 2013-05-23 | FTUK | Futures | 5033.6 | 5035.1 | 4932.6 | 4969.3 | 146852.0 |
| 2013-05-23 | FVSA | Futures | 2967.75 | 3082.19 | 2937.23 | 2983.01 | 9643.0 |
| 2013-05-23 | FXXP | Futures | 224.6 | 224.6 | 221.9 | 223.3 | 8181.0 |
| 2013-05-23 | G | Futures | 98.84 | 99.22 | 98.58 | 98.66 | 236263.0 |
| 2013-05-23 | GF | Futures | 242.287 | 243.466 | 239.76 | 240.349 | 3317.0 |
| 2013-05-23 | GSCI | Futures | 1007.61 | 1014.65 | 1000.8 | 1012.47 | 224.0 |
| 2013-05-23 | HE | Futures | 92.138 | 92.653 | 91.942 | 92.408 | 11239.0 |
| 2013-05-23 | HG | Futures | 4.294 | 4.294 | 4.1621 | 4.2093 | 81475.0 |
| 2013-05-23 | HH | Futures | 47.339 | 47.901 | 46.721 | 47.878 | 5664.0 |
> showing 50 of 104 rows — these rows as CSV