PREVIEW / futures_daily / 2019-01-02
file: by_date/futures_daily/2019/2019-01-02.parquet size: 10 KB rows: 113
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-02 | ES | Futures | 2715.34 | 2729.68 | 2654.98 | 2718.58 | 1969697.0 |
| 2019-01-02 | NQ | Futures | 7351.16 | 7420.33 | 7124.82 | 7376.05 | 659316.0 |
| 2019-01-02 | YM | Futures | 24597.2 | 24699.6 | 24034.0 | 24602.5 | 315923.0 |
| 2019-01-02 | CL | Futures | 48.04 | 50.11 | 46.52 | 48.81 | 850480.0 |
| 2019-01-02 | GC | Futures | 1619.1 | 1626.7 | 1613.6 | 1618.0 | 235334.0 |
| 2019-01-02 | ZN | Futures | 121.315871 | 122.016129 | 121.315871 | 121.689342 | 1537272.0 |
| 2019-01-02 | A6 | Futures | 0.72673 | 0.72724 | 0.72024 | 0.72199 | 100484.0 |
| 2019-01-02 | AD | Futures | 0.7437 | 0.74734 | 0.74228 | 0.74638 | 87823.0 |
| 2019-01-02 | B | Futures | 39.07 | 40.83 | 37.91 | 39.64 | 300950.0 |
| 2019-01-02 | B6 | Futures | 1.3142 | 1.3163 | 1.2965 | 1.2995 | 102778.0 |
| 2019-01-02 | BR | Futures | 0.20599 | 0.20818 | 0.20599 | 0.20818 | 18.0 |
| 2019-01-02 | BTC | Futures | 5438.5 | 5635.8 | 5387.3 | 5599.3 | 3227.0 |
| 2019-01-02 | BZ | Futures | 38.84 | 40.49 | 37.58 | 39.31 | 43517.0 |
| 2019-01-02 | C | Futures | 1549.0 | 1549.0 | 1524.0 | 1544.0 | 10505.0 |
| 2019-01-02 | CB | Futures | 272.076 | 272.076 | 272.076 | 272.076 | 1.0 |
| 2019-01-02 | CC | Futures | 1667.0 | 1670.0 | 1631.0 | 1649.0 | 22875.0 |
| 2019-01-02 | CNH | Futures | 6.8849 | 6.8967 | 6.8756 | 6.8923 | 740.0 |
| 2019-01-02 | CSC | Futures | 2.831 | 2.842 | 2.819 | 2.827 | 124.0 |
| 2019-01-02 | CT | Futures | 78.76 | 79.07 | 77.08 | 77.17 | 18923.0 |
| 2019-01-02 | DC | Futures | 24.16 | 24.21 | 24.05 | 24.16 | 296.0 |
| 2019-01-02 | DX | Futures | 91.259 | 92.089 | 90.959 | 91.958 | 32136.0 |
| 2019-01-02 | E1 | Futures | 1.20605 | 1.20852 | 1.19347 | 1.19535 | 27180.0 |
| 2019-01-02 | E6 | Futures | 1.27431 | 1.27829 | 1.25917 | 1.26116 | 213671.0 |
| 2019-01-02 | E7 | Futures | 1.268 | 1.2719 | 1.253 | 1.255 | 3955.0 |
| 2019-01-02 | EBM | Futures | 208.97 | 210.0 | 208.46 | 209.74 | 5711.0 |
| 2019-01-02 | ED | Futures | 94.9988 | 95.0086 | 94.9891 | 94.9988 | 185842.0 |
| 2019-01-02 | ER | Futures | 98.401 | 98.401 | 98.396 | 98.396 | 38050.0 |
| 2019-01-02 | EW | Futures | 1771.3 | 1780.9 | 1736.1 | 1766.4 | 16637.0 |
| 2019-01-02 | FBON | Futures | 129.87 | 130.1 | 129.7 | 129.89 | 1256.0 |
| 2019-01-02 | FBTP | Futures | 112.41 | 112.49 | 111.56 | 112.24 | 44753.0 |
| 2019-01-02 | FBTS | Futures | 104.944 | 104.973 | 104.736 | 104.878 | 31755.0 |
| 2019-01-02 | FCE | Futures | 4126.7 | 4179.6 | 4087.2 | 4161.4 | 97424.0 |
| 2019-01-02 | FDAX | Futures | 11210.5 | 11251.5 | 10906.3 | 11107.5 | 101639.0 |
| 2019-01-02 | FDXM | Futures | 11176.9 | 11216.7 | 10880.2 | 11080.5 | 41852.0 |
| 2019-01-02 | FESX | Futures | 2562.9 | 2569.7 | 2497.9 | 2544.9 | 942077.0 |
| 2019-01-02 | FGBL | Futures | 155.65 | 156.83 | 155.53 | 156.54 | 713330.0 |
| 2019-01-02 | FGBM | Futures | 131.91 | 132.4 | 131.91 | 132.25 | 442200.0 |
| 2019-01-02 | FGBS | Futures | 112.744 | 112.809 | 112.729 | 112.759 | 445147.0 |
| 2019-01-02 | FGBX | Futures | 183.66 | 186.86 | 183.62 | 186.05 | 45624.0 |
| 2019-01-02 | FMWO | Futures | 6262.7 | 6326.8 | 6198.6 | 6305.8 | 2496.0 |
| 2019-01-02 | FOAT | Futures | 141.47 | 142.23 | 141.37 | 141.96 | 125178.0 |
| 2019-01-02 | FTDX | Futures | 2411.1 | 2455.4 | 2399.2 | 2449.4 | 388.0 |
| 2019-01-02 | FTI | Futures | 450.59 | 457.98 | 446.24 | 455.17 | 27334.0 |
| 2019-01-02 | FTUK | Futures | 6098.2 | 6104.1 | 5954.3 | 6072.7 | 105166.0 |
| 2019-01-02 | FVSA | Futures | 474.29 | 495.62 | 448.9 | 467.18 | 28019.0 |
| 2019-01-02 | FXXP | Futures | 290.7 | 295.8 | 289.1 | 294.0 | 41572.0 |
| 2019-01-02 | G | Futures | 117.03 | 117.74 | 117.02 | 117.32 | 195942.0 |
| 2019-01-02 | GF | Futures | 320.092 | 320.092 | 315.948 | 318.477 | 3035.0 |
| 2019-01-02 | GSCI | Futures | 421.92 | 434.69 | 421.92 | 429.84 | 181.0 |
| 2019-01-02 | HE | Futures | 73.808 | 76.273 | 73.657 | 74.198 | 25537.0 |
> showing 50 of 113 rows — these rows as CSV