PREVIEW / futures_daily / 2019-06-03
file: by_date/futures_daily/2019/2019-06-03.parquet size: 10 KB rows: 120
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-06-03 | ES | Futures | 2960.76 | 2985.33 | 2947.53 | 2969.94 | 2297243.0 |
| 2019-06-03 | NQ | Futures | 8192.18 | 8218.1 | 7997.74 | 8058.23 | 771723.0 |
| 2019-06-03 | YM | Futures | 26117.6 | 26323.5 | 25977.3 | 26250.6 | 322942.0 |
| 2019-06-03 | CL | Futures | 54.83 | 56.07 | 53.48 | 54.65 | 984308.0 |
| 2019-06-03 | GC | Futures | 1633.6 | 1659.1 | 1631.6 | 1652.7 | 363396.0 |
| 2019-06-03 | ZN | Futures | 125.621158 | 126.382592 | 125.621158 | 126.196119 | 177818.0 |
| 2019-06-03 | A6 | Futures | 0.71487 | 0.72013 | 0.71446 | 0.71972 | 106882.0 |
| 2019-06-03 | AD | Futures | 0.74811 | 0.75281 | 0.74761 | 0.75266 | 98594.0 |
| 2019-06-03 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-03 | B | Futures | 45.88 | 46.78 | 45.07 | 45.61 | 386555.0 |
| 2019-06-03 | B6 | Futures | 1.2947 | 1.2992 | 1.2925 | 1.2984 | 121012.0 |
| 2019-06-03 | BR | Futures | 0.20303 | 0.20455 | 0.20303 | 0.20347 | 2201.0 |
| 2019-06-03 | BTC | Futures | 13415.0 | 13622.4 | 12884.8 | 13276.7 | 4641.0 |
| 2019-06-03 | BZ | Futures | 45.27 | 46.17 | 44.43 | 45.03 | 60640.0 |
| 2019-06-03 | C | Futures | 1740.0 | 1747.0 | 1696.0 | 1700.0 | 9094.0 |
| 2019-06-03 | CB | Futures | 282.993 | 282.993 | 282.73 | 282.993 | 47.0 |
| 2019-06-03 | CC | Futures | 1623.0 | 1627.0 | 1573.0 | 1583.0 | 28660.0 |
| 2019-06-03 | CNH | Futures | 6.9427 | 6.9493 | 6.926 | 6.9283 | 1527.0 |
| 2019-06-03 | CSC | Futures | 3.015 | 3.016 | 2.993 | 3.0 | 24.0 |
| 2019-06-03 | CT | Futures | 71.39 | 72.79 | 70.03 | 72.67 | 29977.0 |
| 2019-06-03 | DC | Futures | 25.33 | 25.39 | 25.19 | 25.25 | 110.0 |
| 2019-06-03 | DX | Futures | 93.647 | 93.666 | 92.991 | 93.034 | 29611.0 |
| 2019-06-03 | E1 | Futures | 1.16703 | 1.17893 | 1.16703 | 1.17741 | 46874.0 |
| 2019-06-03 | E6 | Futures | 1.22707 | 1.2375 | 1.2263 | 1.237 | 237367.0 |
| 2019-06-03 | E7 | Futures | 1.2211 | 1.2313 | 1.2203 | 1.2309 | 3600.0 |
| 2019-06-03 | EBM | Futures | 213.03 | 216.2 | 210.73 | 213.32 | 28326.0 |
| 2019-06-03 | ED | Futures | 95.2405 | 95.3015 | 95.2356 | 95.26 | 668329.0 |
| 2019-06-03 | ER | Futures | 98.44 | 98.44 | 98.43 | 98.435 | 51085.0 |
| 2019-06-03 | EW | Futures | 1916.3 | 1942.1 | 1906.4 | 1934.4 | 24147.0 |
| 2019-06-03 | FBON | Futures | 139.59 | 140.27 | 139.58 | 139.87 | 3795.0 |
| 2019-06-03 | FBTP | Futures | 114.93 | 116.26 | 114.61 | 116.09 | 314635.0 |
| 2019-06-03 | FBTS | Futures | 105.417 | 105.779 | 105.398 | 105.693 | 204065.0 |
| 2019-06-03 | FCE | Futures | 4677.2 | 4740.8 | 4659.5 | 4740.8 | 106493.0 |
| 2019-06-03 | FDAX | Futures | 12243.2 | 12413.2 | 12205.3 | 12402.2 | 133137.0 |
| 2019-06-03 | FDIV | Futures | 139.83 | 141.59 | 139.83 | 141.27 | 34.0 |
| 2019-06-03 | FDXM | Futures | 12147.6 | 12304.1 | 12105.8 | 12294.7 | 56000.0 |
| 2019-06-03 | FESX | Futures | 2842.2 | 2879.7 | 2833.4 | 2876.3 | 1037766.0 |
| 2019-06-03 | FGBL | Futures | 162.71 | 162.81 | 162.46 | 162.5 | 1709851.0 |
| 2019-06-03 | FGBM | Futures | 134.02 | 134.06 | 133.88 | 133.9 | 1307357.0 |
| 2019-06-03 | FGBS | Futures | 112.955 | 112.96 | 112.895 | 112.895 | 1124943.0 |
| 2019-06-03 | FGBX | Futures | 202.44 | 203.55 | 202.05 | 202.61 | 183457.0 |
| 2019-06-03 | FMWO | Futures | 6849.3 | 6908.3 | 6832.0 | 6897.9 | 2757.0 |
| 2019-06-03 | FOAT | Futures | 148.89 | 149.28 | 148.82 | 148.95 | 446959.0 |
| 2019-06-03 | FTDX | Futures | 2714.1 | 2718.5 | 2677.5 | 2700.7 | 255.0 |
| 2019-06-03 | FTI | Futures | 506.26 | 510.36 | 504.04 | 510.0 | 35268.0 |
| 2019-06-03 | FTUK | Futures | 6518.8 | 6588.5 | 6483.1 | 6580.3 | 97821.0 |
| 2019-06-03 | FVSA | Futures | 252.34 | 253.77 | 238.08 | 238.8 | 24546.0 |
| 2019-06-03 | FXXP | Futures | 327.5 | 331.0 | 326.7 | 330.8 | 119181.0 |
| 2019-06-03 | G | Futures | 119.44 | 119.65 | 119.35 | 119.51 | 185326.0 |
| 2019-06-03 | GF | Futures | 263.942 | 266.788 | 259.92 | 261.98 | 10196.0 |
> showing 50 of 120 rows — these rows as CSV