PREVIEW / futures_daily / 2015-10-19
file: by_date/futures_daily/2015/2015-10-19.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-10-19 | ES | Futures | 2153.57 | 2157.29 | 2142.66 | 2156.76 | 1306548.0 |
| 2015-10-19 | NQ | Futures | 5184.86 | 5209.41 | 5157.38 | 5208.24 | 202407.0 |
| 2015-10-19 | YM | Futures | 17649.6 | 17692.9 | 17573.2 | 17660.9 | 109422.0 |
| 2015-10-19 | CL | Futures | 75.77 | 76.07 | 73.39 | 73.48 | 395602.0 |
| 2015-10-19 | GC | Futures | 1519.2 | 1520.9 | 1508.1 | 1514.0 | 108768.0 |
| 2015-10-19 | ZN | Futures | 123.526898 | 123.69154 | 123.302385 | 123.541865 | 885046.0 |
| 2015-10-19 | A6 | Futures | 0.72443 | 0.72873 | 0.72113 | 0.72343 | 64432.0 |
| 2015-10-19 | AD | Futures | 0.79309 | 0.7935 | 0.78582 | 0.78613 | 46212.0 |
| 2015-10-19 | ALI | Futures | 2110.65 | 2110.65 | 2110.65 | 2110.65 | 20.0 |
| 2015-10-19 | B | Futures | 45.1 | 45.37 | 43.48 | 43.51 | 223306.0 |
| 2015-10-19 | B6 | Futures | 1.6254 | 1.6314 | 1.6243 | 1.6285 | 44589.0 |
| 2015-10-19 | BR | Futures | 0.15537 | 0.1566 | 0.15497 | 0.15552 | 791.0 |
| 2015-10-19 | BZ | Futures | 45.01 | 45.08 | 43.24 | 43.27 | 18932.0 |
| 2015-10-19 | C | Futures | 2248.0 | 2298.0 | 2247.0 | 2297.0 | 9139.0 |
| 2015-10-19 | CB | Futures | 190.918 | 190.918 | 190.918 | 190.918 | 8.0 |
| 2015-10-19 | CC | Futures | 2280.0 | 2326.0 | 2280.0 | 2324.0 | 19684.0 |
| 2015-10-19 | CNH | Futures | 7.1023 | 7.1199 | 7.1023 | 7.1199 | 39.0 |
| 2015-10-19 | CSC | Futures | 4.33 | 4.33 | 4.304 | 4.304 | 35.0 |
| 2015-10-19 | CT | Futures | 76.71 | 76.86 | 75.53 | 75.86 | 13093.0 |
| 2015-10-19 | DC | Futures | 34.72 | 34.72 | 34.32 | 34.43 | 100.0 |
| 2015-10-19 | DX | Futures | 88.588 | 88.892 | 88.471 | 88.806 | 19112.0 |
| 2015-10-19 | E1 | Futures | 1.3325 | 1.33453 | 1.32666 | 1.32882 | 10960.0 |
| 2015-10-19 | E6 | Futures | 1.3318 | 1.33403 | 1.32536 | 1.32794 | 133877.0 |
| 2015-10-19 | E7 | Futures | 1.3243 | 1.3268 | 1.318 | 1.3206 | 3061.0 |
| 2015-10-19 | EBM | Futures | 255.03 | 256.86 | 254.67 | 255.76 | 15835.0 |
| 2015-10-19 | ED | Futures | 95.7544 | 95.7592 | 95.7496 | 95.7544 | 116677.0 |
| 2015-10-19 | ER | Futures | 98.166 | 98.166 | 98.156 | 98.161 | 26916.0 |
| 2015-10-19 | EW | Futures | 1506.3 | 1515.7 | 1499.2 | 1513.9 | 15607.0 |
| 2015-10-19 | FBTP | Futures | 103.5 | 103.66 | 103.44 | 103.59 | 61624.0 |
| 2015-10-19 | FBTS | Futures | 100.4 | 100.409 | 100.382 | 100.391 | 25090.0 |
| 2015-10-19 | FCE | Futures | 3922.0 | 3956.6 | 3903.6 | 3921.5 | 68116.0 |
| 2015-10-19 | FDAX | Futures | 11150.2 | 11242.8 | 11086.4 | 11197.1 | 84255.0 |
| 2015-10-19 | FDIV | Futures | 134.65 | 134.74 | 134.37 | 134.65 | 14.0 |
| 2015-10-19 | FESX | Futures | 2446.3 | 2464.2 | 2433.5 | 2447.8 | 663888.0 |
| 2015-10-19 | FEU3 | Futures | 98.808 | 98.808 | 98.803 | 98.803 | 1.0 |
| 2015-10-19 | FGBL | Futures | 139.53 | 139.63 | 139.21 | 139.38 | 446535.0 |
| 2015-10-19 | FGBM | Futures | 125.41 | 125.43 | 125.31 | 125.38 | 323122.0 |
| 2015-10-19 | FGBS | Futures | 111.333 | 111.338 | 111.308 | 111.318 | 230046.0 |
| 2015-10-19 | FGBX | Futures | 159.24 | 159.51 | 158.22 | 158.63 | 19907.0 |
| 2015-10-19 | FMWO | Futures | 5608.8 | 5608.8 | 5602.6 | 5602.6 | 112.0 |
| 2015-10-19 | FOAT | Futures | 127.79 | 127.92 | 127.52 | 127.68 | 68753.0 |
| 2015-10-19 | FTDX | Futures | 1658.1 | 1670.4 | 1658.1 | 1668.5 | 126.0 |
| 2015-10-19 | FTI | Futures | 389.43 | 392.74 | 387.94 | 390.04 | 25776.0 |
| 2015-10-19 | FTUK | Futures | 5111.2 | 5129.7 | 5067.0 | 5080.3 | 61231.0 |
| 2015-10-19 | FVSA | Futures | 2173.5 | 2173.5 | 2072.4 | 2109.16 | 9559.0 |
| 2015-10-19 | FXXP | Futures | 282.1 | 284.7 | 281.3 | 283.2 | 18143.0 |
| 2015-10-19 | G | Futures | 105.04 | 105.17 | 104.84 | 104.94 | 146052.0 |
| 2015-10-19 | GF | Futures | 346.239 | 349.536 | 345.742 | 347.187 | 5453.0 |
| 2015-10-19 | GSCI | Futures | 588.8 | 588.8 | 583.39 | 583.8 | 205.0 |
| 2015-10-19 | HE | Futures | 97.777 | 99.796 | 97.254 | 98.675 | 16289.0 |
> showing 50 of 107 rows — these rows as CSV