PREVIEW / futures_daily / 2013-07-22
file: by_date/futures_daily/2013/2013-07-22.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-07-22 | ES | Futures | 1740.64 | 1745.02 | 1736.0 | 1740.9 | 900143.0 |
| 2013-07-22 | NQ | Futures | 3520.86 | 3534.16 | 3514.78 | 3525.19 | 140933.0 |
| 2013-07-22 | YM | Futures | 15369.9 | 15403.6 | 15321.3 | 15354.0 | 69810.0 |
| 2013-07-22 | CL | Futures | 188.74 | 189.67 | 185.97 | 186.77 | 283866.0 |
| 2013-07-22 | GC | Futures | 1720.7 | 1777.7 | 1719.7 | 1773.6 | 191735.0 |
| 2013-07-22 | ZN | Futures | 114.16315 | 114.373705 | 114.149113 | 114.191224 | 603203.0 |
| 2013-07-22 | A6 | Futures | 0.85775 | 0.86638 | 0.85719 | 0.86385 | 77839.0 |
| 2013-07-22 | AD | Futures | 0.97026 | 0.97479 | 0.97026 | 0.97298 | 50685.0 |
| 2013-07-22 | B | Futures | 105.33 | 105.7 | 104.6 | 105.18 | 198418.0 |
| 2013-07-22 | B6 | Futures | 1.5999 | 1.6124 | 1.5991 | 1.6095 | 90802.0 |
| 2013-07-22 | BFX | Futures | 3179.4 | 3179.4 | 3163.8 | 3165.3 | 100.0 |
| 2013-07-22 | BR | Futures | 0.21984 | 0.22007 | 0.21843 | 0.21982 | 91.0 |
| 2013-07-22 | BZ | Futures | 106.14 | 106.39 | 105.31 | 105.89 | 8730.0 |
| 2013-07-22 | C | Futures | 1698.0 | 1704.0 | 1677.0 | 1688.0 | 5404.0 |
| 2013-07-22 | CB | Futures | 77.139 | 77.139 | 76.063 | 76.063 | 13.0 |
| 2013-07-22 | CC | Futures | 1757.0 | 1763.0 | 1743.0 | 1754.0 | 13551.0 |
| 2013-07-22 | CNH | Futures | 7.1312 | 7.134 | 7.1254 | 7.1254 | 11.0 |
| 2013-07-22 | CSC | Futures | 3.52 | 3.524 | 3.499 | 3.513 | 4.0 |
| 2013-07-22 | CT | Futures | 102.62 | 102.88 | 102.62 | 102.88 | 6.0 |
| 2013-07-22 | DC | Futures | 27.33 | 27.42 | 26.86 | 26.93 | 307.0 |
| 2013-07-22 | DX | Futures | 79.036 | 79.074 | 78.491 | 78.67 | 31657.0 |
| 2013-07-22 | E1 | Futures | 1.36604 | 1.37954 | 1.36604 | 1.37337 | 23479.0 |
| 2013-07-22 | E6 | Futures | 1.55079 | 1.56034 | 1.55067 | 1.5568 | 170678.0 |
| 2013-07-22 | E7 | Futures | 1.541 | 1.5502 | 1.5408 | 1.5466 | 2494.0 |
| 2013-07-22 | ED | Futures | 95.2916 | 95.2964 | 95.2869 | 95.2869 | 47453.0 |
| 2013-07-22 | ER | Futures | 97.827 | 97.827 | 97.808 | 97.813 | 48764.0 |
| 2013-07-22 | EW | Futures | 1257.7 | 1261.9 | 1254.3 | 1260.5 | 14111.0 |
| 2013-07-22 | FBTP | Futures | 77.54 | 78.11 | 77.43 | 77.95 | 23472.0 |
| 2013-07-22 | FBTS | Futures | 92.902 | 93.135 | 92.877 | 93.109 | 6015.0 |
| 2013-07-22 | FCE | Futures | 3038.8 | 3051.6 | 3027.6 | 3047.7 | 62757.0 |
| 2013-07-22 | FDAX | Futures | 9281.2 | 9302.3 | 9224.6 | 9247.4 | 71672.0 |
| 2013-07-22 | FESX | Futures | 1911.3 | 1919.7 | 1902.9 | 1912.7 | 578889.0 |
| 2013-07-22 | FGBL | Futures | 120.81 | 120.87 | 120.62 | 120.74 | 350469.0 |
| 2013-07-22 | FGBM | Futures | 117.89 | 117.95 | 117.75 | 117.81 | 289116.0 |
| 2013-07-22 | FGBS | Futures | 110.432 | 110.447 | 110.392 | 110.392 | 206705.0 |
| 2013-07-22 | FGBX | Futures | 125.82 | 126.18 | 125.49 | 125.88 | 7987.0 |
| 2013-07-22 | FMWO | Futures | 4990.2 | 4990.2 | 4990.2 | 4990.2 | 0.0 |
| 2013-07-22 | FOAT | Futures | 107.11 | 107.2 | 106.94 | 106.99 | 30958.0 |
| 2013-07-22 | FTDX | Futures | 937.1 | 941.8 | 937.1 | 940.0 | 4.0 |
| 2013-07-22 | FTI | Futures | 323.0 | 324.14 | 322.34 | 322.95 | 21711.0 |
| 2013-07-22 | FTUK | Futures | 4943.3 | 4955.3 | 4920.4 | 4933.2 | 67079.0 |
| 2013-07-22 | FVSA | Futures | 2780.62 | 2794.84 | 2723.73 | 2745.06 | 6156.0 |
| 2013-07-22 | FXXP | Futures | 220.5 | 221.1 | 219.9 | 220.4 | 2642.0 |
| 2013-07-22 | G | Futures | 95.55 | 95.75 | 95.37 | 95.68 | 76536.0 |
| 2013-07-22 | GF | Futures | 257.704 | 258.167 | 256.609 | 257.662 | 2147.0 |
| 2013-07-22 | GSCI | Futures | 1066.56 | 1069.09 | 1059.44 | 1060.01 | 66.0 |
| 2013-07-22 | HE | Futures | 99.303 | 100.981 | 99.303 | 100.336 | 11399.0 |
| 2013-07-22 | HG | Futures | 3.9911 | 4.0793 | 3.9892 | 4.0412 | 55830.0 |
| 2013-07-22 | HH | Futures | 41.058 | 41.058 | 40.568 | 40.958 | 851.0 |
| 2013-07-22 | HO | Futures | 2.4821 | 2.4996 | 2.4591 | 2.4645 | 50255.0 |
> showing 50 of 103 rows — these rows as CSV