PREVIEW / futures_daily / 2015-09-09
file: by_date/futures_daily/2015/2015-09-09.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-09 | ES | Futures | 2084.13 | 2111.16 | 2051.28 | 2058.96 | 2144217.0 |
| 2015-09-09 | NQ | Futures | 5020.92 | 5101.47 | 4950.57 | 4967.79 | 354129.0 |
| 2015-09-09 | YM | Futures | 16909.9 | 17138.9 | 16647.0 | 16709.6 | 217783.0 |
| 2015-09-09 | CL | Futures | 74.68 | 75.45 | 71.85 | 72.01 | 422735.0 |
| 2015-09-09 | GC | Futures | 1447.1 | 1451.9 | 1420.1 | 1422.6 | 178299.0 |
| 2015-09-09 | ZN | Futures | 121.985244 | 122.119951 | 121.461381 | 122.075049 | 1251778.0 |
| 2015-09-09 | A6 | Futures | 0.69523 | 0.70008 | 0.69374 | 0.69513 | 127425.0 |
| 2015-09-09 | AD | Futures | 0.77414 | 0.77741 | 0.77005 | 0.7722 | 106565.0 |
| 2015-09-09 | ALI | Futures | 2208.98 | 2208.98 | 2208.98 | 2208.98 | 0.0 |
| 2015-09-09 | B | Futures | 45.47 | 46.1 | 43.76 | 43.97 | 170398.0 |
| 2015-09-09 | B6 | Futures | 1.6202 | 1.6213 | 1.6155 | 1.6172 | 125522.0 |
| 2015-09-09 | BFX | Futures | 4232.2 | 4232.2 | 4227.4 | 4227.4 | 1.0 |
| 2015-09-09 | BR | Futures | 0.15792 | 0.15884 | 0.15749 | 0.15755 | 64.0 |
| 2015-09-09 | BZ | Futures | 45.5 | 46.1 | 43.85 | 43.97 | 13859.0 |
| 2015-09-09 | C | Futures | 2311.0 | 2347.0 | 2311.0 | 2346.0 | 18644.0 |
| 2015-09-09 | CB | Futures | 185.948 | 188.851 | 185.013 | 188.384 | 33.0 |
| 2015-09-09 | CC | Futures | 2371.0 | 2404.0 | 2366.0 | 2398.0 | 19094.0 |
| 2015-09-09 | CNH | Futures | 7.2549 | 7.2663 | 7.2543 | 7.2663 | 39.0 |
| 2015-09-09 | CSC | Futures | 4.455 | 4.455 | 4.455 | 4.455 | 6.0 |
| 2015-09-09 | CT | Futures | 77.28 | 78.24 | 77.28 | 77.49 | 3.0 |
| 2015-09-09 | DC | Futures | 35.37 | 35.45 | 35.37 | 35.41 | 12.0 |
| 2015-09-09 | DX | Futures | 89.733 | 90.258 | 89.733 | 89.874 | 57437.0 |
| 2015-09-09 | E1 | Futures | 1.29799 | 1.307 | 1.29278 | 1.30383 | 28390.0 |
| 2015-09-09 | E6 | Futures | 1.31623 | 1.31775 | 1.30777 | 1.3154 | 296841.0 |
| 2015-09-09 | E7 | Futures | 1.3088 | 1.3105 | 1.3005 | 1.3081 | 4680.0 |
| 2015-09-09 | EBM | Futures | 249.55 | 252.11 | 247.36 | 247.72 | 23851.0 |
| 2015-09-09 | ED | Futures | 95.6606 | 95.663 | 95.6558 | 95.6582 | 197948.0 |
| 2015-09-09 | ER | Futures | 98.126 | 98.131 | 98.126 | 98.126 | 16047.0 |
| 2015-09-09 | EW | Futures | 1484.1 | 1501.4 | 1468.5 | 1472.2 | 18273.0 |
| 2015-09-09 | FBTP | Futures | 101.31 | 101.54 | 101.23 | 101.31 | 58865.0 |
| 2015-09-09 | FBTS | Futures | 100.275 | 100.284 | 100.239 | 100.248 | 11143.0 |
| 2015-09-09 | FCE | Futures | 3922.5 | 3963.2 | 3842.2 | 3905.8 | 109205.0 |
| 2015-09-09 | FDAX | Futures | 11549.8 | 11634.4 | 11227.0 | 11392.8 | 116075.0 |
| 2015-09-09 | FESX | Futures | 2438.5 | 2463.0 | 2381.6 | 2421.5 | 1640110.0 |
| 2015-09-09 | FGBL | Futures | 137.46 | 137.88 | 137.31 | 137.47 | 548036.0 |
| 2015-09-09 | FGBM | Futures | 124.83 | 124.99 | 124.8 | 124.84 | 320755.0 |
| 2015-09-09 | FGBS | Futures | 111.223 | 111.238 | 111.213 | 111.223 | 133280.0 |
| 2015-09-09 | FGBX | Futures | 155.04 | 156.08 | 153.96 | 154.94 | 32789.0 |
| 2015-09-09 | FMWO | Futures | 5480.3 | 5480.3 | 5436.0 | 5437.2 | 364.0 |
| 2015-09-09 | FOAT | Futures | 125.54 | 125.82 | 125.4 | 125.65 | 76631.0 |
| 2015-09-09 | FTDX | Futures | 1640.0 | 1655.5 | 1615.5 | 1632.0 | 211.0 |
| 2015-09-09 | FTI | Futures | 384.18 | 388.35 | 376.39 | 382.28 | 35948.0 |
| 2015-09-09 | FTUK | Futures | 4951.9 | 5004.3 | 4881.9 | 4938.8 | 124223.0 |
| 2015-09-09 | FVSA | Futures | 2471.72 | 2621.13 | 2377.8 | 2463.18 | 19331.0 |
| 2015-09-09 | FXXP | Futures | 280.5 | 283.1 | 277.0 | 279.6 | 21636.0 |
| 2015-09-09 | G | Futures | 104.27 | 104.56 | 104.0 | 104.28 | 189928.0 |
| 2015-09-09 | GF | Futures | 352.502 | 353.45 | 350.433 | 351.424 | 1148.0 |
| 2015-09-09 | GSCI | Futures | 603.98 | 605.3 | 590.7 | 591.77 | 1920.0 |
| 2015-09-09 | HE | Futures | 94.456 | 94.866 | 93.396 | 94.251 | 22008.0 |
| 2015-09-09 | HG | Futures | 3.0463 | 3.0989 | 3.0275 | 3.0501 | 59399.0 |
> showing 50 of 107 rows — these rows as CSV