PREVIEW / futures_daily / 2019-02-04
file: by_date/futures_daily/2019/2019-02-04.parquet size: 10 KB rows: 115
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-02-04 | ES | Futures | 2922.4 | 2950.27 | 2919.96 | 2946.21 | 1024581.0 |
| 2019-02-04 | NQ | Futures | 7946.53 | 8084.59 | 7940.16 | 8031.91 | 353660.0 |
| 2019-02-04 | YM | Futures | 26304.9 | 26578.1 | 26289.1 | 26567.6 | 140106.0 |
| 2019-02-04 | CL | Futures | 57.53 | 57.98 | 55.42 | 56.74 | 622472.0 |
| 2019-02-04 | GC | Futures | 1653.2 | 1654.5 | 1640.9 | 1649.1 | 159557.0 |
| 2019-02-04 | ZN | Futures | 121.487045 | 121.502606 | 121.129135 | 121.222503 | 1022090.0 |
| 2019-02-04 | A6 | Futures | 0.74733 | 0.74785 | 0.74342 | 0.74476 | 76394.0 |
| 2019-02-04 | AD | Futures | 0.77443 | 0.77443 | 0.77083 | 0.77225 | 60187.0 |
| 2019-02-04 | B | Futures | 45.55 | 46.13 | 44.43 | 45.32 | 297433.0 |
| 2019-02-04 | B6 | Futures | 1.3464 | 1.3484 | 1.3407 | 1.3422 | 69098.0 |
| 2019-02-04 | BR | Futures | 0.21795 | 0.21819 | 0.216 | 0.21732 | 1493.0 |
| 2019-02-04 | BTC | Futures | 4983.7 | 5035.3 | 4976.3 | 5005.8 | 2947.0 |
| 2019-02-04 | BZ | Futures | 44.98 | 45.65 | 43.96 | 44.85 | 36025.0 |
| 2019-02-04 | C | Futures | 1394.0 | 1432.0 | 1393.0 | 1430.0 | 11349.0 |
| 2019-02-04 | CB | Futures | 277.604 | 277.604 | 276.389 | 276.389 | 16.0 |
| 2019-02-04 | CC | Futures | 1494.0 | 1539.0 | 1491.0 | 1527.0 | 28012.0 |
| 2019-02-04 | CNH | Futures | 6.7639 | 6.7907 | 6.7596 | 6.7865 | 362.0 |
| 2019-02-04 | CSC | Futures | 2.71 | 2.71 | 2.685 | 2.691 | 87.0 |
| 2019-02-04 | CT | Futures | 80.34 | 80.47 | 79.15 | 79.26 | 22446.0 |
| 2019-02-04 | DC | Futures | 23.03 | 23.03 | 22.82 | 22.82 | 248.0 |
| 2019-02-04 | DX | Futures | 90.897 | 91.226 | 90.892 | 91.145 | 11858.0 |
| 2019-02-04 | E1 | Futures | 1.18536 | 1.18606 | 1.18089 | 1.1823 | 12074.0 |
| 2019-02-04 | E6 | Futures | 1.27017 | 1.27077 | 1.2668 | 1.26757 | 110867.0 |
| 2019-02-04 | E7 | Futures | 1.2641 | 1.2645 | 1.2606 | 1.2614 | 1985.0 |
| 2019-02-04 | EBM | Futures | 209.74 | 210.77 | 209.74 | 210.25 | 19086.0 |
| 2019-02-04 | ED | Futures | 95.0525 | 95.0574 | 95.0428 | 95.0428 | 137046.0 |
| 2019-02-04 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 53887.0 |
| 2019-02-04 | EW | Futures | 1955.8 | 1980.0 | 1953.7 | 1978.4 | 12630.0 |
| 2019-02-04 | FBON | Futures | 131.92 | 131.92 | 131.63 | 131.7 | 352.0 |
| 2019-02-04 | FBTP | Futures | 111.86 | 112.24 | 111.37 | 111.88 | 75776.0 |
| 2019-02-04 | FBTS | Futures | 105.077 | 105.133 | 104.831 | 105.02 | 51806.0 |
| 2019-02-04 | FCE | Futures | 4491.6 | 4495.7 | 4450.4 | 4477.3 | 57541.0 |
| 2019-02-04 | FDAX | Futures | 11759.1 | 11776.9 | 11655.5 | 11708.1 | 86508.0 |
| 2019-02-04 | FDIV | Futures | 137.29 | 137.82 | 137.29 | 137.82 | 10.0 |
| 2019-02-04 | FDXM | Futures | 11730.4 | 11748.2 | 11626.6 | 11679.6 | 41173.0 |
| 2019-02-04 | FESX | Futures | 2707.3 | 2710.7 | 2683.4 | 2695.3 | 790542.0 |
| 2019-02-04 | FEU3 | Futures | 99.006 | 99.006 | 99.001 | 99.001 | 100.0 |
| 2019-02-04 | FGBL | Futures | 157.46 | 157.49 | 157.09 | 157.15 | 418541.0 |
| 2019-02-04 | FGBM | Futures | 132.38 | 132.39 | 132.23 | 132.27 | 261051.0 |
| 2019-02-04 | FGBS | Futures | 112.708 | 112.713 | 112.673 | 112.683 | 228000.0 |
| 2019-02-04 | FGBX | Futures | 187.67 | 188.04 | 187.19 | 187.35 | 29613.0 |
| 2019-02-04 | FMWO | Futures | 6812.8 | 6844.2 | 6796.4 | 6820.9 | 2329.0 |
| 2019-02-04 | FOAT | Futures | 143.1 | 143.11 | 142.86 | 142.92 | 120528.0 |
| 2019-02-04 | FTDX | Futures | 2526.4 | 2551.8 | 2515.0 | 2529.9 | 359.0 |
| 2019-02-04 | FTI | Futures | 493.29 | 497.17 | 492.82 | 495.35 | 20903.0 |
| 2019-02-04 | FTUK | Futures | 6344.1 | 6379.2 | 6320.4 | 6345.5 | 94393.0 |
| 2019-02-04 | FVSA | Futures | 293.56 | 293.56 | 277.61 | 279.49 | 18938.0 |
| 2019-02-04 | FXXP | Futures | 314.6 | 315.7 | 313.4 | 314.3 | 52363.0 |
| 2019-02-04 | G | Futures | 116.8 | 117.01 | 116.59 | 116.66 | 161439.0 |
| 2019-02-04 | GF | Futures | 311.682 | 317.696 | 311.682 | 315.4 | 8422.0 |
> showing 50 of 115 rows — these rows as CSV