PREVIEW / futures_daily / 2015-04-24
file: by_date/futures_daily/2015/2015-04-24.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-04-24 | ES | Futures | 2215.96 | 2223.58 | 2211.23 | 2220.43 | 958312.0 |
| 2015-04-24 | NQ | Futures | 5215.94 | 5266.73 | 5212.46 | 5258.61 | 204737.0 |
| 2015-04-24 | YM | Futures | 18390.0 | 18449.3 | 18341.9 | 18428.9 | 97748.0 |
| 2015-04-24 | CL | Futures | 97.69 | 98.4 | 95.94 | 97.04 | 328322.0 |
| 2015-04-24 | GC | Futures | 1561.0 | 1564.2 | 1536.3 | 1537.5 | 156378.0 |
| 2015-04-24 | ZN | Futures | 122.249363 | 122.634168 | 122.101362 | 122.560167 | 1065745.0 |
| 2015-04-24 | A6 | Futures | 0.76502 | 0.77114 | 0.76364 | 0.76956 | 79305.0 |
| 2015-04-24 | AD | Futures | 0.84007 | 0.84303 | 0.83732 | 0.83844 | 54013.0 |
| 2015-04-24 | ALI | Futures | 2542.31 | 2542.31 | 2542.31 | 2542.31 | 0.0 |
| 2015-04-24 | B | Futures | 62.47 | 63.49 | 62.21 | 62.99 | 259489.0 |
| 2015-04-24 | B6 | Futures | 1.5846 | 1.5981 | 1.5813 | 1.5969 | 84232.0 |
| 2015-04-24 | BFX | Futures | 4558.7 | 4560.6 | 4527.7 | 4559.3 | 32.0 |
| 2015-04-24 | BR | Futures | 0.18956 | 0.19087 | 0.18879 | 0.19056 | 186.0 |
| 2015-04-24 | BZ | Futures | 62.04 | 62.9 | 61.69 | 62.44 | 20163.0 |
| 2015-04-24 | C | Futures | 2095.0 | 2151.0 | 2095.0 | 2147.0 | 3041.0 |
| 2015-04-24 | CB | Futures | 154.951 | 155.619 | 154.951 | 155.093 | 2.0 |
| 2015-04-24 | CC | Futures | 2088.0 | 2130.0 | 2088.0 | 2128.0 | 16886.0 |
| 2015-04-24 | CNH | Futures | 6.9913 | 6.996 | 6.9903 | 6.9903 | 45.0 |
| 2015-04-24 | CSC | Futures | 4.639 | 4.676 | 4.639 | 4.65 | 75.0 |
| 2015-04-24 | CT | Futures | 82.79 | 83.88 | 82.13 | 83.57 | 19217.0 |
| 2015-04-24 | DC | Futures | 37.96 | 38.5 | 37.94 | 38.12 | 457.0 |
| 2015-04-24 | DX | Futures | 91.582 | 91.775 | 90.986 | 91.173 | 53910.0 |
| 2015-04-24 | E1 | Futures | 1.33838 | 1.34259 | 1.33341 | 1.33864 | 20074.0 |
| 2015-04-24 | E6 | Futures | 1.27353 | 1.28259 | 1.26894 | 1.27882 | 283322.0 |
| 2015-04-24 | E7 | Futures | 1.2659 | 1.2752 | 1.2616 | 1.2714 | 7186.0 |
| 2015-04-24 | EBM | Futures | 296.06 | 296.86 | 292.85 | 293.65 | 12279.0 |
| 2015-04-24 | ED | Futures | 95.5477 | 95.5477 | 95.5381 | 95.5477 | 109297.0 |
| 2015-04-24 | ER | Futures | 98.068 | 98.073 | 98.063 | 98.068 | 43413.0 |
| 2015-04-24 | EW | Futures | 1612.7 | 1616.5 | 1603.8 | 1604.2 | 13244.0 |
| 2015-04-24 | FBTP | Futures | 102.79 | 102.94 | 102.35 | 102.5 | 75432.0 |
| 2015-04-24 | FBTS | Futures | 99.67 | 99.697 | 99.635 | 99.661 | 12168.0 |
| 2015-04-24 | FCE | Futures | 4224.5 | 4255.3 | 4204.4 | 4234.0 | 96884.0 |
| 2015-04-24 | FDAX | Futures | 13080.5 | 13220.3 | 13021.7 | 13120.5 | 108330.0 |
| 2015-04-24 | FESX | Futures | 2685.1 | 2712.4 | 2672.6 | 2689.5 | 922991.0 |
| 2015-04-24 | FEU3 | Futures | 98.705 | 98.71 | 98.705 | 98.71 | 158.0 |
| 2015-04-24 | FGBL | Futures | 141.41 | 141.6 | 141.2 | 141.52 | 546428.0 |
| 2015-04-24 | FGBM | Futures | 124.84 | 124.87 | 124.77 | 124.83 | 319650.0 |
| 2015-04-24 | FGBS | Futures | 111.293 | 111.298 | 111.273 | 111.283 | 178784.0 |
| 2015-04-24 | FGBX | Futures | 178.02 | 178.67 | 177.15 | 177.84 | 27349.0 |
| 2015-04-24 | FMWO | Futures | 5944.5 | 5946.9 | 5926.0 | 5938.3 | 383.0 |
| 2015-04-24 | FOAT | Futures | 130.43 | 130.62 | 130.13 | 130.37 | 59820.0 |
| 2015-04-24 | FTDX | Futures | 1556.5 | 1561.7 | 1547.1 | 1552.8 | 118.0 |
| 2015-04-24 | FTI | Futures | 435.23 | 437.98 | 434.62 | 436.06 | 26228.0 |
| 2015-04-24 | FTUK | Futures | 5531.5 | 5569.7 | 5528.0 | 5543.7 | 81497.0 |
| 2015-04-24 | FVSA | Futures | 1752.94 | 1776.68 | 1709.41 | 1733.15 | 14202.0 |
| 2015-04-24 | FXXP | Futures | 309.8 | 311.6 | 309.2 | 310.3 | 9390.0 |
| 2015-04-24 | G | Futures | 104.27 | 104.53 | 103.86 | 104.5 | 125982.0 |
| 2015-04-24 | GF | Futures | 363.549 | 369.006 | 361.96 | 367.889 | 4276.0 |
| 2015-04-24 | GSCI | Futures | 742.76 | 742.76 | 736.72 | 741.4 | 112.0 |
| 2015-04-24 | HE | Futures | 83.28 | 83.656 | 82.817 | 83.222 | 206.0 |
> showing 50 of 107 rows — these rows as CSV