PREVIEW / futures_daily / 2019-06-04
file: by_date/futures_daily/2019/2019-06-04.parquet size: 10 KB rows: 121
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-04 | ES | Futures | 2974.8 | 3031.24 | 2964.0 | 3029.89 | 1836910.0 |
| 2019-06-04 | NQ | Futures | 8075.51 | 8280.32 | 8044.41 | 8271.97 | 565396.0 |
| 2019-06-04 | YM | Futures | 26301.3 | 26773.1 | 26204.2 | 26754.1 | 251904.0 |
| 2019-06-04 | CL | Futures | 54.28 | 55.2 | 53.81 | 54.89 | 831625.0 |
| 2019-06-04 | GC | Futures | 1655.0 | 1660.5 | 1648.8 | 1653.7 | 319959.0 |
| 2019-06-04 | ZN | Futures | 126.258276 | 126.351513 | 125.636697 | 125.900868 | 92950.0 |
| 2019-06-04 | A6 | Futures | 0.71941 | 0.7223 | 0.71725 | 0.72158 | 135134.0 |
| 2019-06-04 | AD | Futures | 0.75246 | 0.75575 | 0.7519 | 0.75494 | 83663.0 |
| 2019-06-04 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-04 | B | Futures | 45.41 | 46.24 | 44.82 | 46.13 | 370265.0 |
| 2019-06-04 | B6 | Futures | 1.298 | 1.3033 | 1.2957 | 1.3022 | 106935.0 |
| 2019-06-04 | BFX | Futures | 3930.0 | 4067.2 | 3930.0 | 4055.5 | 11.0 |
| 2019-06-04 | BR | Futures | 0.20435 | 0.20579 | 0.20435 | 0.20579 | 919.0 |
| 2019-06-04 | BTC | Futures | 13153.7 | 13161.4 | 11547.9 | 11717.0 | 11780.0 |
| 2019-06-04 | BZ | Futures | 44.71 | 45.63 | 44.25 | 45.54 | 58666.0 |
| 2019-06-04 | C | Futures | 1697.0 | 1728.0 | 1681.0 | 1717.0 | 10675.0 |
| 2019-06-04 | CB | Futures | 281.855 | 282.759 | 281.855 | 282.759 | 12.0 |
| 2019-06-04 | CC | Futures | 1583.0 | 1588.0 | 1546.0 | 1580.0 | 20398.0 |
| 2019-06-04 | CNH | Futures | 6.9295 | 6.9431 | 6.9253 | 6.9304 | 918.0 |
| 2019-06-04 | CSC | Futures | 2.993 | 2.993 | 2.974 | 2.983 | 48.0 |
| 2019-06-04 | CT | Futures | 73.18 | 73.18 | 71.68 | 72.2 | 24464.0 |
| 2019-06-04 | DC | Futures | 25.23 | 25.23 | 25.03 | 25.08 | 144.0 |
| 2019-06-04 | DX | Futures | 93.106 | 93.24 | 92.88 | 92.975 | 25602.0 |
| 2019-06-04 | E1 | Futures | 1.17764 | 1.17986 | 1.17344 | 1.17916 | 42643.0 |
| 2019-06-04 | E6 | Futures | 1.23536 | 1.23903 | 1.23338 | 1.237 | 259080.0 |
| 2019-06-04 | E7 | Futures | 1.2298 | 1.2328 | 1.2273 | 1.2309 | 4143.0 |
| 2019-06-04 | EBM | Futures | 211.88 | 213.03 | 209.87 | 210.16 | 21488.0 |
| 2019-06-04 | ED | Futures | 95.3015 | 95.3088 | 95.2332 | 95.2722 | 464851.0 |
| 2019-06-04 | ER | Futures | 98.435 | 98.44 | 98.43 | 98.435 | 53060.0 |
| 2019-06-04 | EW | Futures | 1941.2 | 1984.3 | 1933.9 | 1983.6 | 15595.0 |
| 2019-06-04 | FBON | Futures | 139.9 | 140.63 | 139.84 | 140.26 | 2930.0 |
| 2019-06-04 | FBTP | Futures | 115.82 | 117.02 | 115.82 | 116.44 | 324666.0 |
| 2019-06-04 | FBTS | Futures | 105.655 | 105.989 | 105.608 | 105.855 | 205694.0 |
| 2019-06-04 | FCE | Futures | 4716.3 | 4778.9 | 4697.2 | 4768.0 | 96086.0 |
| 2019-06-04 | FDAX | Futures | 12374.8 | 12626.9 | 12325.3 | 12612.7 | 144626.0 |
| 2019-06-04 | FDIV | Futures | 141.68 | 144.33 | 141.68 | 144.33 | 112.0 |
| 2019-06-04 | FDXM | Futures | 12270.7 | 12513.8 | 12218.5 | 12503.4 | 65674.0 |
| 2019-06-04 | FESX | Futures | 2865.8 | 2916.5 | 2856.2 | 2913.8 | 1095032.0 |
| 2019-06-04 | FGBL | Futures | 162.61 | 162.8 | 162.52 | 162.59 | 1451616.0 |
| 2019-06-04 | FGBM | Futures | 133.99 | 134.0 | 133.87 | 133.89 | 1470241.0 |
| 2019-06-04 | FGBS | Futures | 112.92 | 112.925 | 112.885 | 112.885 | 852802.0 |
| 2019-06-04 | FGBX | Futures | 202.89 | 203.69 | 202.69 | 203.1 | 177309.0 |
| 2019-06-04 | FMWO | Futures | 6882.9 | 7000.9 | 6882.9 | 6966.2 | 5452.0 |
| 2019-06-04 | FOAT | Futures | 148.96 | 149.35 | 148.92 | 149.11 | 388580.0 |
| 2019-06-04 | FTDX | Futures | 2701.2 | 2711.1 | 2669.1 | 2708.1 | 144.0 |
| 2019-06-04 | FTI | Futures | 507.63 | 511.5 | 505.74 | 510.42 | 33002.0 |
| 2019-06-04 | FTUK | Futures | 6566.5 | 6620.2 | 6537.2 | 6614.7 | 97105.0 |
| 2019-06-04 | FVSA | Futures | 242.36 | 243.79 | 230.24 | 233.81 | 31122.0 |
| 2019-06-04 | FXXP | Futures | 329.6 | 333.6 | 328.6 | 333.4 | 66038.0 |
| 2019-06-04 | G | Futures | 119.67 | 119.68 | 119.1 | 119.2 | 198502.0 |
> showing 50 of 121 rows — these rows as CSV