PREVIEW / futures_daily / 2013-08-20
file: by_date/futures_daily/2013/2013-08-20.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-08-20 | ES | Futures | 1693.52 | 1706.39 | 1690.17 | 1699.95 | 1582327.0 |
| 2013-08-20 | NQ | Futures | 3552.67 | 3582.45 | 3543.7 | 3563.94 | 164001.0 |
| 2013-08-20 | YM | Futures | 14864.4 | 14913.9 | 14826.7 | 14852.5 | 117490.0 |
| 2013-08-20 | CL | Futures | 187.6 | 188.04 | 183.92 | 184.77 | 361065.0 |
| 2013-08-20 | GC | Futures | 1805.1 | 1822.5 | 1787.6 | 1815.3 | 137476.0 |
| 2013-08-20 | ZN | Futures | 111.98741 | 112.548892 | 111.98741 | 112.450632 | 1036793.0 |
| 2013-08-20 | A6 | Futures | 0.854 | 0.85541 | 0.84546 | 0.85165 | 93706.0 |
| 2013-08-20 | AD | Futures | 0.97338 | 0.97359 | 0.96794 | 0.96925 | 64708.0 |
| 2013-08-20 | B | Futures | 107.54 | 108.58 | 106.5 | 108.01 | 233190.0 |
| 2013-08-20 | B6 | Futures | 1.6403 | 1.6456 | 1.6383 | 1.6433 | 79274.0 |
| 2013-08-20 | BFX | Futures | 3323.6 | 3323.6 | 3319.9 | 3319.9 | 11.0 |
| 2013-08-20 | BR | Futures | 0.20425 | 0.20707 | 0.20425 | 0.20601 | 128.0 |
| 2013-08-20 | BZ | Futures | 108.29 | 109.35 | 107.32 | 108.8 | 7184.0 |
| 2013-08-20 | C | Futures | 1758.0 | 1768.0 | 1754.0 | 1755.0 | 3081.0 |
| 2013-08-20 | CB | Futures | 67.452 | 67.691 | 67.452 | 67.452 | 45.0 |
| 2013-08-20 | CC | Futures | 1871.0 | 1898.0 | 1868.0 | 1878.0 | 12369.0 |
| 2013-08-20 | CSC | Futures | 3.341 | 3.341 | 3.301 | 3.313 | 20.0 |
| 2013-08-20 | CT | Futures | 109.56 | 109.56 | 105.71 | 105.71 | 62.0 |
| 2013-08-20 | DC | Futures | 25.71 | 25.71 | 25.15 | 25.28 | 353.0 |
| 2013-08-20 | DX | Futures | 77.712 | 77.775 | 77.192 | 77.348 | 30888.0 |
| 2013-08-20 | E1 | Futures | 1.39136 | 1.40563 | 1.38969 | 1.4019 | 43336.0 |
| 2013-08-20 | E6 | Futures | 1.57392 | 1.58772 | 1.5725 | 1.58383 | 244413.0 |
| 2013-08-20 | E7 | Futures | 1.5636 | 1.5772 | 1.5621 | 1.5735 | 4450.0 |
| 2013-08-20 | ED | Futures | 95.306 | 95.3084 | 95.3036 | 95.306 | 77986.0 |
| 2013-08-20 | ER | Futures | 97.827 | 97.827 | 97.817 | 97.822 | 20479.0 |
| 2013-08-20 | EW | Futures | 1219.0 | 1236.2 | 1215.1 | 1233.0 | 15516.0 |
| 2013-08-20 | FBTP | Futures | 78.43 | 78.62 | 78.2 | 78.26 | 24783.0 |
| 2013-08-20 | FBTS | Futures | 93.324 | 93.367 | 93.246 | 93.272 | 5243.0 |
| 2013-08-20 | FCE | Futures | 3134.0 | 3137.5 | 3087.8 | 3108.6 | 140015.0 |
| 2013-08-20 | FDAX | Futures | 9230.7 | 9237.4 | 9150.8 | 9209.7 | 102434.0 |
| 2013-08-20 | FESX | Futures | 1970.9 | 1973.7 | 1942.9 | 1956.9 | 1125661.0 |
| 2013-08-20 | FEU3 | Futures | 98.438 | 98.438 | 98.433 | 98.433 | 15.0 |
| 2013-08-20 | FGBL | Futures | 117.43 | 117.79 | 117.34 | 117.73 | 587417.0 |
| 2013-08-20 | FGBM | Futures | 116.38 | 116.56 | 116.34 | 116.51 | 380532.0 |
| 2013-08-20 | FGBS | Futures | 110.183 | 110.213 | 110.163 | 110.198 | 233664.0 |
| 2013-08-20 | FGBX | Futures | 119.43 | 120.26 | 119.43 | 120.14 | 6206.0 |
| 2013-08-20 | FMWO | Futures | 4929.4 | 4929.4 | 4929.4 | 4929.4 | 0.0 |
| 2013-08-20 | FOAT | Futures | 105.38 | 105.62 | 105.27 | 105.54 | 33313.0 |
| 2013-08-20 | FTDX | Futures | 960.7 | 962.6 | 956.9 | 962.6 | 97.0 |
| 2013-08-20 | FTI | Futures | 324.8 | 324.89 | 320.04 | 322.09 | 33101.0 |
| 2013-08-20 | FTUK | Futures | 4828.5 | 4840.5 | 4787.3 | 4825.2 | 77127.0 |
| 2013-08-20 | FVSA | Futures | 2688.43 | 2774.93 | 2655.15 | 2721.7 | 10132.0 |
| 2013-08-20 | FXXP | Futures | 223.0 | 223.0 | 221.3 | 222.7 | 10013.0 |
| 2013-08-20 | G | Futures | 91.84 | 92.28 | 91.8 | 92.19 | 134133.0 |
| 2013-08-20 | GF | Futures | 259.796 | 261.44 | 259.672 | 260.207 | 1224.0 |
| 2013-08-20 | GSCI | Futures | 1060.93 | 1069.57 | 1059.13 | 1063.07 | 216.0 |
| 2013-08-20 | HE | Futures | 104.611 | 105.397 | 104.369 | 105.186 | 11706.0 |
| 2013-08-20 | HG | Futures | 4.224 | 4.2367 | 4.1873 | 4.2316 | 14056.0 |
| 2013-08-20 | HH | Futures | 38.438 | 38.504 | 37.81 | 37.942 | 2286.0 |
| 2013-08-20 | HO | Futures | 2.4633 | 2.4841 | 2.4447 | 2.4702 | 16215.0 |
> showing 50 of 104 rows — these rows as CSV