PREVIEW / futures_daily / 2015-06-26
file: by_date/futures_daily/2015/2015-06-26.parquet size: 9 KB rows: 108
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-06-26 | ES | Futures | 2220.05 | 2226.41 | 2211.04 | 2221.11 | 1321884.0 |
| 2015-06-26 | NQ | Futures | 5261.42 | 5273.68 | 5206.84 | 5231.07 | 226373.0 |
| 2015-06-26 | YM | Futures | 18314.9 | 18408.3 | 18267.6 | 18355.9 | 124413.0 |
| 2015-06-26 | CL | Futures | 99.64 | 100.15 | 98.14 | 99.59 | 231957.0 |
| 2015-06-26 | GC | Futures | 1531.3 | 1538.5 | 1524.2 | 1532.2 | 107921.0 |
| 2015-06-26 | ZN | Futures | 119.691731 | 119.825864 | 119.140293 | 119.244619 | 1076844.0 |
| 2015-06-26 | A6 | Futures | 0.76278 | 0.76337 | 0.75248 | 0.75486 | 80171.0 |
| 2015-06-26 | AD | Futures | 0.82833 | 0.82946 | 0.82373 | 0.82894 | 51099.0 |
| 2015-06-26 | ALI | Futures | 2348.96 | 2348.96 | 2348.96 | 2348.96 | 0.0 |
| 2015-06-26 | B | Futures | 59.69 | 59.7 | 58.7 | 59.41 | 113379.0 |
| 2015-06-26 | B6 | Futures | 1.6561 | 1.6586 | 1.6525 | 1.6549 | 63645.0 |
| 2015-06-26 | BFX | Futures | 4469.9 | 4510.4 | 4469.9 | 4498.8 | 2.0 |
| 2015-06-26 | BR | Futures | 0.18683 | 0.18767 | 0.18683 | 0.18734 | 382.0 |
| 2015-06-26 | BZ | Futures | 59.46 | 59.65 | 58.65 | 59.37 | 23534.0 |
| 2015-06-26 | C | Futures | 2308.0 | 2348.0 | 2305.0 | 2343.0 | 3592.0 |
| 2015-06-26 | CB | Futures | 158.042 | 158.042 | 156.279 | 156.279 | 2.0 |
| 2015-06-26 | CC | Futures | 2403.0 | 2451.0 | 2397.0 | 2443.0 | 14447.0 |
| 2015-06-26 | CSC | Futures | 4.483 | 4.483 | 4.434 | 4.445 | 126.0 |
| 2015-06-26 | CT | Futures | 80.46 | 83.63 | 80.46 | 83.47 | 54.0 |
| 2015-06-26 | DC | Futures | 36.07 | 36.16 | 35.51 | 35.75 | 131.0 |
| 2015-06-26 | DX | Futures | 89.265 | 89.733 | 89.186 | 89.538 | 33076.0 |
| 2015-06-26 | E1 | Futures | 1.36008 | 1.36935 | 1.35843 | 1.35945 | 17863.0 |
| 2015-06-26 | E6 | Futures | 1.31705 | 1.31952 | 1.30883 | 1.31247 | 181984.0 |
| 2015-06-26 | E7 | Futures | 1.3101 | 1.3121 | 1.3017 | 1.3052 | 4360.0 |
| 2015-06-26 | EBM | Futures | 306.6 | 318.89 | 306.6 | 318.48 | 32397.0 |
| 2015-06-26 | ED | Futures | 95.6222 | 95.6222 | 95.6127 | 95.6175 | 89067.0 |
| 2015-06-26 | ER | Futures | 98.087 | 98.087 | 98.073 | 98.082 | 108110.0 |
| 2015-06-26 | EW | Futures | 1601.1 | 1606.5 | 1595.8 | 1606.1 | 17306.0 |
| 2015-06-26 | FBTP | Futures | 97.71 | 98.38 | 97.71 | 97.9 | 77463.0 |
| 2015-06-26 | FBTS | Futures | 99.581 | 99.643 | 99.536 | 99.599 | 16602.0 |
| 2015-06-26 | FCE | Futures | 4167.4 | 4246.2 | 4152.8 | 4216.2 | 134452.0 |
| 2015-06-26 | FDAX | Futures | 12602.8 | 12786.3 | 12571.8 | 12715.0 | 93762.0 |
| 2015-06-26 | FDIV | Futures | 155.66 | 156.67 | 155.66 | 156.17 | 7.0 |
| 2015-06-26 | FESX | Futures | 2647.2 | 2694.6 | 2637.6 | 2681.3 | 1089712.0 |
| 2015-06-26 | FEU3 | Futures | 98.724 | 98.724 | 98.724 | 98.724 | 1500.0 |
| 2015-06-26 | FGBL | Futures | 134.75 | 134.81 | 133.7 | 134.0 | 589126.0 |
| 2015-06-26 | FGBM | Futures | 123.71 | 123.75 | 123.38 | 123.47 | 416571.0 |
| 2015-06-26 | FGBS | Futures | 111.158 | 111.168 | 111.113 | 111.133 | 211291.0 |
| 2015-06-26 | FGBX | Futures | 149.21 | 149.37 | 146.39 | 147.24 | 33756.0 |
| 2015-06-26 | FMWO | Futures | 5880.3 | 5903.7 | 5880.3 | 5892.6 | 206.0 |
| 2015-06-26 | FOAT | Futures | 123.09 | 123.18 | 122.29 | 122.47 | 70031.0 |
| 2015-06-26 | FTDX | Futures | 1587.7 | 1602.3 | 1583.0 | 1599.9 | 105.0 |
| 2015-06-26 | FTI | Futures | 426.95 | 433.63 | 425.9 | 431.66 | 37410.0 |
| 2015-06-26 | FTUK | Futures | 5356.4 | 5359.6 | 5308.8 | 5330.6 | 91360.0 |
| 2015-06-26 | FVSA | Futures | 1778.87 | 1798.99 | 1718.5 | 1742.65 | 12363.0 |
| 2015-06-26 | FXXP | Futures | 302.0 | 305.3 | 301.3 | 304.3 | 13481.0 |
| 2015-06-26 | G | Futures | 100.48 | 100.66 | 99.88 | 100.09 | 141605.0 |
| 2015-06-26 | GF | Futures | 370.004 | 372.13 | 369.027 | 369.367 | 5583.0 |
| 2015-06-26 | GSCI | Futures | 723.4 | 728.57 | 721.07 | 726.24 | 21.0 |
| 2015-06-26 | HE | Futures | 81.47 | 82.449 | 81.035 | 82.068 | 5962.0 |
> showing 50 of 108 rows — these rows as CSV