PREVIEW / futures_daily / 2017-06-02
file: by_date/futures_daily/2017/2017-06-02.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 |
|---|---|---|---|---|---|---|---|
| 2017-06-02 | ES | Futures | 2638.27 | 2649.67 | 2635.83 | 2647.5 | 1735800.0 |
| 2017-06-02 | NQ | Futures | 6859.15 | 6933.35 | 6857.09 | 6932.47 | 298205.0 |
| 2017-06-02 | YM | Futures | 22302.0 | 22398.1 | 22290.4 | 22372.7 | 127109.0 |
| 2017-06-02 | CL | Futures | 49.76 | 49.92 | 48.41 | 49.37 | 802662.0 |
| 2017-06-02 | GC | Futures | 1618.7 | 1636.8 | 1610.1 | 1634.3 | 272288.0 |
| 2017-06-02 | ZN | Futures | 124.365991 | 124.903707 | 124.273812 | 124.765437 | 63468.0 |
| 2017-06-02 | A6 | Futures | 0.75689 | 0.76439 | 0.75679 | 0.76315 | 102387.0 |
| 2017-06-02 | AD | Futures | 0.75457 | 0.75712 | 0.75294 | 0.75595 | 66040.0 |
| 2017-06-02 | ALI | Futures | 2536.65 | 2536.65 | 2536.65 | 2536.65 | 0.0 |
| 2017-06-02 | B | Futures | 35.73 | 35.94 | 34.82 | 35.53 | 451455.0 |
| 2017-06-02 | B6 | Futures | 1.3512 | 1.3533 | 1.3472 | 1.3507 | 85009.0 |
| 2017-06-02 | BFX | Futures | 4775.8 | 4775.8 | 4742.5 | 4742.5 | 1.0 |
| 2017-06-02 | BR | Futures | 0.2246 | 0.2246 | 0.22404 | 0.22404 | 6.0 |
| 2017-06-02 | BZ | Futures | 35.7 | 35.78 | 34.68 | 35.38 | 44207.0 |
| 2017-06-02 | C | Futures | 1588.0 | 1597.0 | 1567.0 | 1572.0 | 8654.0 |
| 2017-06-02 | CB | Futures | 304.076 | 307.512 | 304.076 | 307.512 | 12.0 |
| 2017-06-02 | CC | Futures | 1548.0 | 1554.0 | 1523.0 | 1530.0 | 23194.0 |
| 2017-06-02 | CNH | Futures | 7.0904 | 7.0983 | 7.0694 | 7.0694 | 51.0 |
| 2017-06-02 | CSC | Futures | 3.623 | 3.623 | 3.614 | 3.614 | 1.0 |
| 2017-06-02 | CT | Futures | 86.07 | 86.13 | 84.8 | 84.93 | 16362.0 |
| 2017-06-02 | DC | Futures | 30.1 | 30.36 | 30.02 | 30.17 | 149.0 |
| 2017-06-02 | DX | Futures | 90.525 | 90.614 | 89.98 | 90.064 | 29195.0 |
| 2017-06-02 | E1 | Futures | 1.2732 | 1.28543 | 1.27246 | 1.2837 | 25980.0 |
| 2017-06-02 | E6 | Futures | 1.29262 | 1.30092 | 1.29153 | 1.29994 | 180335.0 |
| 2017-06-02 | E7 | Futures | 1.2859 | 1.2944 | 1.285 | 1.2934 | 3690.0 |
| 2017-06-02 | EBM | Futures | 185.11 | 185.67 | 184.83 | 185.11 | 4248.0 |
| 2017-06-02 | ED | Futures | 95.5784 | 95.593 | 95.576 | 95.5784 | 313109.0 |
| 2017-06-02 | ER | Futures | 98.337 | 98.342 | 98.332 | 98.337 | 55696.0 |
| 2017-06-02 | EW | Futures | 1857.4 | 1869.0 | 1854.0 | 1859.1 | 18797.0 |
| 2017-06-02 | FBON | Futures | 123.53 | 123.69 | 123.26 | 123.28 | 2011.0 |
| 2017-06-02 | FBTP | Futures | 106.41 | 106.72 | 106.29 | 106.34 | 198603.0 |
| 2017-06-02 | FBTS | Futures | 102.462 | 102.498 | 102.453 | 102.462 | 39551.0 |
| 2017-06-02 | FCE | Futures | 4796.0 | 4812.6 | 4770.4 | 4784.7 | 90462.0 |
| 2017-06-02 | FDAX | Futures | 13444.4 | 13597.0 | 13436.5 | 13531.0 | 100076.0 |
| 2017-06-02 | FDXM | Futures | 13321.1 | 13477.0 | 13316.9 | 13412.1 | 28368.0 |
| 2017-06-02 | FESX | Futures | 2930.4 | 2946.7 | 2919.8 | 2923.0 | 1044246.0 |
| 2017-06-02 | FGBL | Futures | 149.01 | 149.59 | 149.01 | 149.52 | 1185873.0 |
| 2017-06-02 | FGBM | Futures | 129.69 | 129.87 | 129.68 | 129.82 | 988531.0 |
| 2017-06-02 | FGBS | Futures | 112.342 | 112.372 | 112.337 | 112.357 | 521432.0 |
| 2017-06-02 | FGBX | Futures | 167.63 | 168.89 | 167.57 | 168.65 | 91028.0 |
| 2017-06-02 | FMWO | Futures | 6500.0 | 6506.1 | 6492.8 | 6506.1 | 2272.0 |
| 2017-06-02 | FOAT | Futures | 135.61 | 136.0 | 135.61 | 135.93 | 222494.0 |
| 2017-06-02 | FTDX | Futures | 2281.8 | 2292.0 | 2266.6 | 2273.9 | 258.0 |
| 2017-06-02 | FTI | Futures | 485.84 | 487.26 | 481.85 | 482.63 | 30938.0 |
| 2017-06-02 | FTUK | Futures | 6473.9 | 6494.4 | 6442.2 | 6444.8 | 90761.0 |
| 2017-06-02 | FVSA | Futures | 489.27 | 489.27 | 477.42 | 480.81 | 17553.0 |
| 2017-06-02 | FXXP | Futures | 332.4 | 332.8 | 330.2 | 330.7 | 39095.0 |
| 2017-06-02 | G | Futures | 115.91 | 116.17 | 115.81 | 116.0 | 155300.0 |
| 2017-06-02 | GF | Futures | 348.156 | 350.406 | 343.766 | 348.431 | 7616.0 |
| 2017-06-02 | GSCI | Futures | 458.14 | 462.57 | 458.14 | 461.28 | 770.0 |
> showing 50 of 109 rows — these rows as CSV