PREVIEW / futures_daily / 2013-01-17
file: by_date/futures_daily/2013/2013-01-17.parquet size: 9 KB rows: 101
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-01-17 | ES | Futures | 1498.98 | 1514.84 | 1494.38 | 1509.98 | 1745053.0 |
| 2013-01-17 | NQ | Futures | 3144.56 | 3174.26 | 3133.32 | 3161.0 | 211220.0 |
| 2013-01-17 | YM | Futures | 13173.3 | 13311.6 | 13134.1 | 13279.2 | 121261.0 |
| 2013-01-17 | CL | Futures | 166.76 | 170.05 | 166.11 | 169.07 | 164884.0 |
| 2013-01-17 | GC | Futures | 2239.5 | 2262.5 | 2220.7 | 2253.2 | 202942.0 |
| 2013-01-17 | ZN | Futures | 116.707467 | 116.85907 | 116.211308 | 116.321566 | 1294206.0 |
| 2013-01-17 | A6 | Futures | 0.96277 | 0.96286 | 0.95618 | 0.96048 | 100678.0 |
| 2013-01-17 | AD | Futures | 1.01543 | 1.01733 | 1.01282 | 1.01653 | 59645.0 |
| 2013-01-17 | B | Futures | 102.94 | 104.47 | 102.66 | 104.21 | 206285.0 |
| 2013-01-17 | B6 | Futures | 1.6713 | 1.6756 | 1.6669 | 1.6724 | 124649.0 |
| 2013-01-17 | BFX | Futures | 3024.3 | 3050.9 | 3024.3 | 3050.9 | 175.0 |
| 2013-01-17 | BR | Futures | 0.23875 | 0.23932 | 0.23865 | 0.23917 | 18.0 |
| 2013-01-17 | BZ | Futures | 105.19 | 106.78 | 104.98 | 106.53 | 6507.0 |
| 2013-01-17 | C | Futures | 1570.0 | 1599.0 | 1565.0 | 1596.0 | 15001.0 |
| 2013-01-17 | CB | Futures | 83.612 | 83.612 | 83.533 | 83.533 | 4.0 |
| 2013-01-17 | CC | Futures | 1701.0 | 1743.0 | 1698.0 | 1735.0 | 15899.0 |
| 2013-01-17 | CSC | Futures | 3.719 | 3.734 | 3.719 | 3.734 | 5.0 |
| 2013-01-17 | CT | Futures | 97.25 | 98.39 | 96.75 | 97.89 | 18725.0 |
| 2013-01-17 | DC | Futures | 27.69 | 27.76 | 27.54 | 27.58 | 211.0 |
| 2013-01-17 | DX | Futures | 76.962 | 77.107 | 76.784 | 76.876 | 25252.0 |
| 2013-01-17 | E1 | Futures | 1.38329 | 1.38522 | 1.37595 | 1.38085 | 42411.0 |
| 2013-01-17 | E6 | Futures | 1.56826 | 1.5797 | 1.56578 | 1.57946 | 291059.0 |
| 2013-01-17 | E7 | Futures | 1.5574 | 1.5688 | 1.5552 | 1.5687 | 5829.0 |
| 2013-01-17 | EBM | Futures | 279.51 | 280.62 | 275.34 | 275.9 | 12575.0 |
| 2013-01-17 | ED | Futures | 95.2342 | 95.2342 | 95.2151 | 95.2151 | 148017.0 |
| 2013-01-17 | ER | Futures | 97.773 | 97.783 | 97.7 | 97.734 | 287616.0 |
| 2013-01-17 | EW | Futures | 1080.0 | 1091.8 | 1076.9 | 1089.2 | 13349.0 |
| 2013-01-17 | FBTP | Futures | 77.17 | 77.58 | 77.16 | 77.3 | 22792.0 |
| 2013-01-17 | FBTS | Futures | 91.959 | 92.052 | 91.866 | 91.908 | 4475.0 |
| 2013-01-17 | FCE | Futures | 2775.6 | 2817.3 | 2775.6 | 2808.7 | 99681.0 |
| 2013-01-17 | FDAX | Futures | 8383.5 | 8485.1 | 8370.9 | 8444.7 | 113734.0 |
| 2013-01-17 | FESX | Futures | 1833.6 | 1856.1 | 1832.9 | 1847.9 | 837348.0 |
| 2013-01-17 | FEU3 | Futures | 98.369 | 98.369 | 98.335 | 98.34 | 469.0 |
| 2013-01-17 | FGBL | Futures | 118.61 | 118.71 | 117.79 | 118.0 | 1021389.0 |
| 2013-01-17 | FGBM | Futures | 116.52 | 116.56 | 115.85 | 116.08 | 902855.0 |
| 2013-01-17 | FGBS | Futures | 110.233 | 110.253 | 110.013 | 110.083 | 790092.0 |
| 2013-01-17 | FGBX | Futures | 124.78 | 124.86 | 123.24 | 123.82 | 10592.0 |
| 2013-01-17 | FOAT | Futures | 105.24 | 105.3 | 104.61 | 104.74 | 44512.0 |
| 2013-01-17 | FTDX | Futures | 815.1 | 822.7 | 814.2 | 821.8 | 583.0 |
| 2013-01-17 | FTI | Futures | 300.07 | 301.88 | 298.39 | 301.36 | 20819.0 |
| 2013-01-17 | FTUK | Futures | 4456.8 | 4489.5 | 4442.8 | 4478.5 | 91716.0 |
| 2013-01-17 | FVSA | Futures | 3184.85 | 3212.07 | 3103.19 | 3148.56 | 4810.0 |
| 2013-01-17 | FXXP | Futures | 205.4 | 207.0 | 205.3 | 206.3 | 1898.0 |
| 2013-01-17 | G | Futures | 97.45 | 97.47 | 96.83 | 96.98 | 179272.0 |
| 2013-01-17 | GF | Futures | 277.109 | 277.763 | 271.317 | 272.485 | 7357.0 |
| 2013-01-17 | GSCI | Futures | 1049.19 | 1060.75 | 1049.19 | 1058.83 | 103.0 |
| 2013-01-17 | HE | Futures | 98.007 | 99.011 | 97.748 | 98.638 | 18897.0 |
| 2013-01-17 | HG | Futures | 4.6448 | 4.709 | 4.6243 | 4.7026 | 54295.0 |
| 2013-01-17 | HH | Futures | 39.882 | 41.384 | 39.882 | 41.02 | 756.0 |
| 2013-01-17 | HO | Futures | 2.4187 | 2.4428 | 2.4128 | 2.4319 | 43126.0 |
> showing 50 of 101 rows — these rows as CSV