PREVIEW / futures_daily / 2019-05-02
file: by_date/futures_daily/2019/2019-05-02.parquet size: 10 KB rows: 114
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-05-02 | ES | Futures | 3150.33 | 3167.88 | 3133.59 | 3151.41 | 1813837.0 |
| 2019-05-02 | NQ | Futures | 8915.47 | 8992.96 | 8851.52 | 8911.44 | 592822.0 |
| 2019-05-02 | YM | Futures | 27802.3 | 27931.1 | 27600.7 | 27724.2 | 258245.0 |
| 2019-05-02 | CL | Futures | 65.31 | 65.38 | 62.58 | 63.46 | 914661.0 |
| 2019-05-02 | GC | Futures | 1591.3 | 1592.4 | 1577.3 | 1583.2 | 282497.0 |
| 2019-05-02 | ZN | Futures | 122.932828 | 122.979446 | 122.482183 | 122.497722 | 1605845.0 |
| 2019-05-02 | A6 | Futures | 0.72395 | 0.72539 | 0.72178 | 0.72199 | 72518.0 |
| 2019-05-02 | AD | Futures | 0.75307 | 0.75352 | 0.75099 | 0.75135 | 65081.0 |
| 2019-05-02 | B | Futures | 53.05 | 53.22 | 51.35 | 52.13 | 346632.0 |
| 2019-05-02 | B6 | Futures | 1.34 | 1.3432 | 1.3364 | 1.3374 | 99404.0 |
| 2019-05-02 | BR | Futures | 0.20316 | 0.20336 | 0.20112 | 0.20136 | 2460.0 |
| 2019-05-02 | BTC | Futures | 8173.2 | 8374.2 | 8165.5 | 8335.6 | 4551.0 |
| 2019-05-02 | BZ | Futures | 53.02 | 53.07 | 51.21 | 51.99 | 51722.0 |
| 2019-05-02 | C | Futures | 1710.0 | 1726.0 | 1703.0 | 1720.0 | 2721.0 |
| 2019-05-02 | CB | Futures | 278.005 | 278.125 | 277.766 | 278.005 | 3.0 |
| 2019-05-02 | CC | Futures | 1556.0 | 1605.0 | 1556.0 | 1598.0 | 23288.0 |
| 2019-05-02 | CNH | Futures | 6.7406 | 6.7557 | 6.7352 | 6.7553 | 115.0 |
| 2019-05-02 | CSC | Futures | 2.964 | 2.978 | 2.962 | 2.973 | 45.0 |
| 2019-05-02 | CT | Futures | 79.92 | 80.17 | 78.89 | 78.98 | 18165.0 |
| 2019-05-02 | DC | Futures | 24.92 | 25.09 | 24.92 | 25.04 | 224.0 |
| 2019-05-02 | DX | Futures | 93.316 | 93.547 | 93.221 | 93.538 | 14396.0 |
| 2019-05-02 | E1 | Futures | 1.15174 | 1.15232 | 1.14824 | 1.1494 | 20944.0 |
| 2019-05-02 | E6 | Futures | 1.23382 | 1.23585 | 1.23058 | 1.23091 | 163209.0 |
| 2019-05-02 | E7 | Futures | 1.2276 | 1.2298 | 1.2244 | 1.2249 | 5623.0 |
| 2019-05-02 | EBM | Futures | 194.75 | 198.19 | 194.75 | 197.13 | 16411.0 |
| 2019-05-02 | ED | Futures | 95.1502 | 95.1599 | 95.1453 | 95.1502 | 272645.0 |
| 2019-05-02 | ER | Futures | 98.411 | 98.416 | 98.411 | 98.411 | 18886.0 |
| 2019-05-02 | EW | Futures | 2065.8 | 2080.6 | 2054.2 | 2074.1 | 17093.0 |
| 2019-05-02 | FBON | Futures | 135.51 | 136.59 | 135.51 | 136.39 | 77.0 |
| 2019-05-02 | FBTP | Futures | 115.41 | 116.12 | 115.41 | 115.91 | 66062.0 |
| 2019-05-02 | FBTS | Futures | 105.874 | 106.008 | 105.865 | 105.979 | 47108.0 |
| 2019-05-02 | FCE | Futures | 4981.2 | 4997.4 | 4949.7 | 4965.0 | 78733.0 |
| 2019-05-02 | FDAX | Futures | 12962.2 | 13074.3 | 12922.7 | 13003.2 | 106999.0 |
| 2019-05-02 | FDIV | Futures | 150.13 | 150.13 | 150.03 | 150.03 | 25.0 |
| 2019-05-02 | FDXM | Futures | 12847.8 | 12961.5 | 12759.1 | 12890.6 | 43133.0 |
| 2019-05-02 | FESX | Futures | 3010.0 | 3024.8 | 2994.2 | 3003.9 | 957844.0 |
| 2019-05-02 | FGBL | Futures | 159.4 | 159.71 | 159.22 | 159.48 | 772196.0 |
| 2019-05-02 | FGBM | Futures | 132.91 | 133.02 | 132.85 | 132.97 | 446266.0 |
| 2019-05-02 | FGBS | Futures | 112.749 | 112.764 | 112.734 | 112.759 | 246244.0 |
| 2019-05-02 | FGBX | Futures | 192.75 | 193.36 | 192.06 | 192.55 | 36754.0 |
| 2019-05-02 | FMWO | Futures | 7277.4 | 7292.5 | 7225.4 | 7240.4 | 2533.0 |
| 2019-05-02 | FOAT | Futures | 146.41 | 146.83 | 146.34 | 146.64 | 194375.0 |
| 2019-05-02 | FTDX | Futures | 2867.6 | 2868.5 | 2836.0 | 2846.8 | 229.0 |
| 2019-05-02 | FTI | Futures | 537.41 | 539.55 | 533.48 | 535.26 | 28166.0 |
| 2019-05-02 | FTUK | Futures | 6676.1 | 6738.9 | 6675.7 | 6696.3 | 91502.0 |
| 2019-05-02 | FVSA | Futures | 198.3 | 209.47 | 196.9 | 204.58 | 39918.0 |
| 2019-05-02 | FXXP | Futures | 345.7 | 346.2 | 343.5 | 344.4 | 57769.0 |
| 2019-05-02 | G | Futures | 117.33 | 117.9 | 117.24 | 117.37 | 206707.0 |
| 2019-05-02 | GF | Futures | 294.387 | 294.699 | 289.078 | 289.338 | 2695.0 |
| 2019-05-02 | GSCI | Futures | 498.13 | 498.41 | 493.67 | 496.61 | 167.0 |
> showing 50 of 114 rows — these rows as CSV