PREVIEW / futures_daily / 2017-04-25
file: by_date/futures_daily/2017/2017-04-25.parquet size: 9 KB rows: 111
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-25 | ES | Futures | 2573.92 | 2594.83 | 2572.02 | 2590.21 | 1324272.0 |
| 2017-04-25 | NQ | Futures | 6480.2 | 6545.27 | 6476.66 | 6534.67 | 172850.0 |
| 2017-04-25 | YM | Futures | 21837.8 | 22123.7 | 21827.2 | 22100.5 | 126509.0 |
| 2017-04-25 | CL | Futures | 51.36 | 51.99 | 50.99 | 51.71 | 587240.0 |
| 2017-04-25 | GC | Futures | 1634.2 | 1636.8 | 1614.9 | 1620.5 | 253774.0 |
| 2017-04-25 | ZN | Futures | 123.705369 | 123.751459 | 123.167653 | 123.305923 | 1116975.0 |
| 2017-04-25 | A6 | Futures | 0.77619 | 0.7765 | 0.77126 | 0.77291 | 73242.0 |
| 2017-04-25 | AD | Futures | 0.75534 | 0.75574 | 0.74896 | 0.75167 | 84587.0 |
| 2017-04-25 | ALI | Futures | 2581.37 | 2581.37 | 2581.37 | 2581.37 | 0.0 |
| 2017-04-25 | B | Futures | 37.42 | 37.9 | 37.15 | 37.7 | 322573.0 |
| 2017-04-25 | B6 | Futures | 1.3429 | 1.3487 | 1.3411 | 1.347 | 99440.0 |
| 2017-04-25 | BR | Futures | 0.22948 | 0.22948 | 0.22618 | 0.22759 | 4198.0 |
| 2017-04-25 | BZ | Futures | 37.32 | 37.6 | 36.89 | 37.43 | 28434.0 |
| 2017-04-25 | C | Futures | 1442.0 | 1477.0 | 1425.0 | 1471.0 | 3227.0 |
| 2017-04-25 | CB | Futures | 261.203 | 261.203 | 259.678 | 259.678 | 2.0 |
| 2017-04-25 | CC | Futures | 1378.0 | 1422.0 | 1378.0 | 1416.0 | 17606.0 |
| 2017-04-25 | CNH | Futures | 7.1993 | 7.2025 | 7.1992 | 7.1992 | 5.0 |
| 2017-04-25 | CSC | Futures | 3.522 | 3.531 | 3.478 | 3.487 | 51.0 |
| 2017-04-25 | CT | Futures | 87.3 | 87.95 | 86.35 | 87.89 | 14867.0 |
| 2017-04-25 | DC | Futures | 29.31 | 29.4 | 28.71 | 28.78 | 306.0 |
| 2017-04-25 | DX | Futures | 92.202 | 92.328 | 91.829 | 91.907 | 26514.0 |
| 2017-04-25 | E1 | Futures | 1.24502 | 1.24972 | 1.24317 | 1.24836 | 21347.0 |
| 2017-04-25 | E6 | Futures | 1.25502 | 1.26452 | 1.25312 | 1.26331 | 238244.0 |
| 2017-04-25 | E7 | Futures | 1.2482 | 1.2581 | 1.2467 | 1.2569 | 6488.0 |
| 2017-04-25 | EBM | Futures | 182.3 | 184.54 | 182.02 | 184.26 | 28174.0 |
| 2017-04-25 | ED | Futures | 95.5494 | 95.5542 | 95.5349 | 95.5397 | 210884.0 |
| 2017-04-25 | ER | Futures | 98.332 | 98.337 | 98.328 | 98.332 | 54219.0 |
| 2017-04-25 | EW | Futures | 1843.2 | 1864.0 | 1840.9 | 1856.5 | 12670.0 |
| 2017-04-25 | FBON | Futures | 122.49 | 122.54 | 121.73 | 121.84 | 630.0 |
| 2017-04-25 | FBTP | Futures | 105.99 | 106.16 | 105.48 | 105.6 | 101590.0 |
| 2017-04-25 | FBTS | Futures | 102.054 | 102.063 | 101.972 | 102.0 | 35865.0 |
| 2017-04-25 | FCE | Futures | 4646.1 | 4669.2 | 4638.5 | 4655.4 | 97508.0 |
| 2017-04-25 | FDAX | Futures | 13143.6 | 13215.9 | 13143.6 | 13192.1 | 75220.0 |
| 2017-04-25 | FDIV | Futures | 148.27 | 148.58 | 147.96 | 148.58 | 102.0 |
| 2017-04-25 | FDXM | Futures | 13032.3 | 13101.3 | 13032.3 | 13076.2 | 21671.0 |
| 2017-04-25 | FESX | Futures | 2865.9 | 2882.2 | 2865.1 | 2874.0 | 1120184.0 |
| 2017-04-25 | FEU3 | Futures | 99.001 | 99.011 | 99.001 | 99.006 | 45.0 |
| 2017-04-25 | FGBL | Futures | 148.26 | 148.4 | 147.65 | 147.95 | 840676.0 |
| 2017-04-25 | FGBM | Futures | 129.06 | 129.15 | 128.89 | 128.97 | 494170.0 |
| 2017-04-25 | FGBS | Futures | 112.207 | 112.242 | 112.197 | 112.227 | 345652.0 |
| 2017-04-25 | FGBX | Futures | 169.47 | 169.61 | 167.53 | 168.31 | 49068.0 |
| 2017-04-25 | FMWO | Futures | 6292.8 | 6325.4 | 6292.8 | 6323.0 | 4652.0 |
| 2017-04-25 | FOAT | Futures | 134.05 | 134.26 | 133.39 | 133.54 | 201933.0 |
| 2017-04-25 | FTDX | Futures | 2029.8 | 2038.6 | 2028.8 | 2028.8 | 195.0 |
| 2017-04-25 | FTI | Futures | 476.21 | 478.18 | 475.24 | 475.7 | 28517.0 |
| 2017-04-25 | FTUK | Futures | 6163.7 | 6191.5 | 6162.8 | 6182.9 | 92057.0 |
| 2017-04-25 | FVSA | Futures | 572.66 | 576.24 | 558.35 | 565.5 | 36017.0 |
| 2017-04-25 | FXXP | Futures | 321.9 | 323.6 | 321.9 | 323.0 | 29966.0 |
| 2017-04-25 | G | Futures | 115.87 | 115.94 | 115.44 | 115.68 | 138557.0 |
| 2017-04-25 | GF | Futures | 316.136 | 317.797 | 313.329 | 315.449 | 5573.0 |
> showing 50 of 111 rows — these rows as CSV