PREVIEW / futures_daily / 2016-05-13
file: by_date/futures_daily/2016/2016-05-13.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-13 | ES | Futures | 2211.05 | 2215.62 | 2188.77 | 2194.14 | 1878403.0 |
| 2016-05-13 | NQ | Futures | 5096.3 | 5123.62 | 5056.94 | 5080.73 | 249877.0 |
| 2016-05-13 | YM | Futures | 18371.4 | 18392.2 | 18153.0 | 18190.5 | 183037.0 |
| 2016-05-13 | CL | Futures | 55.29 | 55.38 | 54.5 | 55.05 | 519363.0 |
| 2016-05-13 | GC | Futures | 1630.2 | 1646.9 | 1629.2 | 1640.4 | 174352.0 |
| 2016-05-13 | ZN | Futures | 126.098303 | 126.475482 | 126.053042 | 126.460395 | 1278254.0 |
| 2016-05-13 | A6 | Futures | 0.74015 | 0.74045 | 0.73336 | 0.73519 | 102931.0 |
| 2016-05-13 | AD | Futures | 0.79609 | 0.7965 | 0.78903 | 0.79036 | 57267.0 |
| 2016-05-13 | ALI | Futures | 2074.34 | 2079.84 | 2074.34 | 2078.22 | 8.0 |
| 2016-05-13 | B | Futures | 39.72 | 39.94 | 39.23 | 39.7 | 239047.0 |
| 2016-05-13 | B6 | Futures | 1.5211 | 1.5219 | 1.51 | 1.5129 | 91781.0 |
| 2016-05-13 | BR | Futures | 0.1864 | 0.18643 | 0.18389 | 0.18419 | 1107.0 |
| 2016-05-13 | BZ | Futures | 39.56 | 39.79 | 39.1 | 39.57 | 24243.0 |
| 2016-05-13 | C | Futures | 2309.0 | 2314.0 | 2286.0 | 2293.0 | 13920.0 |
| 2016-05-13 | CB | Futures | 256.329 | 256.36 | 252.427 | 252.427 | 14.0 |
| 2016-05-13 | CC | Futures | 2187.0 | 2196.0 | 2167.0 | 2170.0 | 19017.0 |
| 2016-05-13 | CNH | Futures | 7.1212 | 7.134 | 7.1173 | 7.1295 | 13.0 |
| 2016-05-13 | CSC | Futures | 3.265 | 3.291 | 3.231 | 3.253 | 117.0 |
| 2016-05-13 | CT | Futures | 69.0 | 69.43 | 68.53 | 68.96 | 15698.0 |
| 2016-05-13 | DC | Futures | 25.47 | 25.7 | 25.2 | 25.33 | 284.0 |
| 2016-05-13 | DX | Futures | 87.777 | 88.425 | 87.731 | 88.19 | 23155.0 |
| 2016-05-13 | E1 | Futures | 1.29542 | 1.29655 | 1.28537 | 1.29002 | 21730.0 |
| 2016-05-13 | E6 | Futures | 1.32777 | 1.32829 | 1.31692 | 1.31978 | 174953.0 |
| 2016-05-13 | E7 | Futures | 1.3206 | 1.321 | 1.3091 | 1.3127 | 3291.0 |
| 2016-05-13 | EBM | Futures | 195.17 | 197.87 | 194.57 | 197.57 | 11405.0 |
| 2016-05-13 | ED | Futures | 95.7593 | 95.7642 | 95.7497 | 95.7642 | 201082.0 |
| 2016-05-13 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.264 | 84922.0 |
| 2016-05-13 | EW | Futures | 1534.0 | 1535.9 | 1514.2 | 1520.5 | 18454.0 |
| 2016-05-13 | FBON | Futures | 117.88 | 118.05 | 117.66 | 117.98 | 273.0 |
| 2016-05-13 | FBTP | Futures | 106.09 | 106.36 | 105.92 | 106.2 | 65153.0 |
| 2016-05-13 | FBTS | Futures | 101.078 | 101.105 | 101.069 | 101.087 | 17789.0 |
| 2016-05-13 | FCE | Futures | 3640.3 | 3684.2 | 3613.2 | 3672.2 | 5893.0 |
| 2016-05-13 | FDAX | Futures | 10546.5 | 10720.0 | 10485.3 | 10683.5 | 108921.0 |
| 2016-05-13 | FDIV | Futures | 126.97 | 128.91 | 126.97 | 128.91 | 45.0 |
| 2016-05-13 | FDXM | Futures | 10162.7 | 10322.0 | 10097.5 | 10287.9 | 22685.0 |
| 2016-05-13 | FESX | Futures | 2255.7 | 2292.4 | 2240.9 | 2281.5 | 1381240.0 |
| 2016-05-13 | FEU3 | Futures | 98.917 | 98.917 | 98.912 | 98.917 | 92.0 |
| 2016-05-13 | FGBL | Futures | 146.64 | 146.95 | 146.47 | 146.85 | 520184.0 |
| 2016-05-13 | FGBM | Futures | 127.75 | 127.78 | 127.68 | 127.75 | 379568.0 |
| 2016-05-13 | FGBS | Futures | 111.673 | 111.688 | 111.668 | 111.678 | 167386.0 |
| 2016-05-13 | FGBX | Futures | 173.45 | 174.59 | 172.98 | 174.22 | 32643.0 |
| 2016-05-13 | FMWO | Futures | 5574.3 | 5599.2 | 5570.6 | 5599.2 | 235.0 |
| 2016-05-13 | FOAT | Futures | 133.99 | 134.42 | 133.87 | 134.31 | 69095.0 |
| 2016-05-13 | FTDX | Futures | 1548.5 | 1565.7 | 1544.2 | 1563.8 | 254.0 |
| 2016-05-13 | FTI | Futures | 383.32 | 386.82 | 381.12 | 386.69 | 535.0 |
| 2016-05-13 | FTUK | Futures | 5030.8 | 5044.0 | 4974.3 | 5038.3 | 111687.0 |
| 2016-05-13 | FVSA | Futures | 2611.09 | 2643.67 | 2569.2 | 2573.85 | 18350.0 |
| 2016-05-13 | FXXP | Futures | 264.8 | 267.4 | 263.6 | 267.1 | 26554.0 |
| 2016-05-13 | G | Futures | 109.0 | 109.2 | 108.88 | 109.1 | 163570.0 |
| 2016-05-13 | GF | Futures | 294.033 | 296.18 | 285.297 | 292.037 | 6691.0 |
> showing 50 of 109 rows — these rows as CSV