PREVIEW / futures_daily / 2018-06-04
file: by_date/futures_daily/2018/2018-06-04.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 |
|---|---|---|---|---|---|---|---|
| 2018-06-04 | ES | Futures | 2969.88 | 2989.72 | 2967.7 | 2985.64 | 857850.0 |
| 2018-06-04 | NQ | Futures | 8286.38 | 8370.35 | 8277.01 | 8366.55 | 247834.0 |
| 2018-06-04 | YM | Futures | 25933.7 | 26190.7 | 25883.1 | 26120.1 | 138703.0 |
| 2018-06-04 | CL | Futures | 66.14 | 66.47 | 64.99 | 65.17 | 696050.0 |
| 2018-06-04 | GC | Futures | 1655.5 | 1662.6 | 1651.8 | 1656.2 | 215328.0 |
| 2018-06-04 | ZN | Futures | 119.229979 | 119.260996 | 118.857773 | 118.935316 | 68235.0 |
| 2018-06-04 | A6 | Futures | 0.77848 | 0.78836 | 0.77746 | 0.78702 | 113616.0 |
| 2018-06-04 | AD | Futures | 0.78116 | 0.78449 | 0.7806 | 0.78272 | 54418.0 |
| 2018-06-04 | B | Futures | 56.14 | 56.35 | 55.07 | 55.13 | 324286.0 |
| 2018-06-04 | B6 | Futures | 1.3838 | 1.3884 | 1.3776 | 1.3797 | 103359.0 |
| 2018-06-04 | BR | Futures | 0.20022 | 0.20323 | 0.1998 | 0.20235 | 15.0 |
| 2018-06-04 | BTC | Futures | 10964.0 | 11227.0 | 10601.7 | 10658.5 | 1625.0 |
| 2018-06-04 | BZ | Futures | 55.57 | 55.81 | 54.55 | 54.62 | 31642.0 |
| 2018-06-04 | C | Futures | 1600.0 | 1600.0 | 1530.0 | 1540.0 | 15316.0 |
| 2018-06-04 | CB | Futures | 292.642 | 292.642 | 291.802 | 292.342 | 25.0 |
| 2018-06-04 | CC | Futures | 1792.0 | 1795.0 | 1711.0 | 1728.0 | 29255.0 |
| 2018-06-04 | CNH | Futures | 6.4963 | 6.4963 | 6.4941 | 6.4941 | 3.0 |
| 2018-06-04 | CSC | Futures | 3.496 | 3.496 | 3.478 | 3.486 | 34.0 |
| 2018-06-04 | CT | Futures | 106.06 | 107.45 | 104.66 | 104.69 | 20224.0 |
| 2018-06-04 | DC | Futures | 28.16 | 28.19 | 27.96 | 28.09 | 112.0 |
| 2018-06-04 | DX | Futures | 88.81 | 88.81 | 88.306 | 88.641 | 16760.0 |
| 2018-06-04 | E1 | Futures | 1.21995 | 1.22646 | 1.21851 | 1.21971 | 19940.0 |
| 2018-06-04 | E6 | Futures | 1.31501 | 1.3243 | 1.31489 | 1.31906 | 250314.0 |
| 2018-06-04 | E7 | Futures | 1.3082 | 1.3172 | 1.3079 | 1.312 | 4690.0 |
| 2018-06-04 | EBM | Futures | 188.57 | 189.36 | 187.27 | 187.53 | 15748.0 |
| 2018-06-04 | ED | Futures | 94.9768 | 94.9841 | 94.9646 | 94.9768 | 253072.0 |
| 2018-06-04 | ER | Futures | 98.337 | 98.337 | 98.332 | 98.337 | 39319.0 |
| 2018-06-04 | EW | Futures | 2071.9 | 2086.2 | 2071.5 | 2085.0 | 12518.0 |
| 2018-06-04 | FBON | Futures | 128.18 | 129.35 | 128.18 | 128.88 | 2193.0 |
| 2018-06-04 | FBTP | Futures | 107.03 | 108.53 | 106.91 | 108.2 | 237601.0 |
| 2018-06-04 | FBTS | Futures | 102.077 | 102.678 | 101.966 | 102.364 | 131317.0 |
| 2018-06-04 | FCE | Futures | 4913.4 | 4930.9 | 4897.2 | 4903.5 | 60547.0 |
| 2018-06-04 | FDAX | Futures | 13246.3 | 13345.5 | 13204.2 | 13271.7 | 83531.0 |
| 2018-06-04 | FDXM | Futures | 13130.4 | 13228.2 | 13087.2 | 13153.6 | 31260.0 |
| 2018-06-04 | FESX | Futures | 2883.9 | 2898.9 | 2878.1 | 2886.4 | 892635.0 |
| 2018-06-04 | FGBL | Futures | 151.73 | 151.9 | 151.3 | 151.4 | 1741286.0 |
| 2018-06-04 | FGBM | Futures | 130.59 | 130.73 | 130.48 | 130.55 | 1716889.0 |
| 2018-06-04 | FGBS | Futures | 112.663 | 112.703 | 112.663 | 112.673 | 1589285.0 |
| 2018-06-04 | FGBX | Futures | 174.9 | 175.38 | 173.82 | 174.09 | 215611.0 |
| 2018-06-04 | FMWO | Futures | 7053.1 | 7062.4 | 7044.9 | 7048.4 | 211.0 |
| 2018-06-04 | FOAT | Futures | 139.78 | 139.87 | 139.39 | 139.43 | 327210.0 |
| 2018-06-04 | FTDX | Futures | 2801.7 | 2801.7 | 2759.7 | 2784.9 | 131.0 |
| 2018-06-04 | FTI | Futures | 518.1 | 520.74 | 517.69 | 519.03 | 21274.0 |
| 2018-06-04 | FTUK | Futures | 6800.4 | 6857.8 | 6794.6 | 6827.3 | 104238.0 |
| 2018-06-04 | FVSA | Futures | 335.09 | 335.09 | 312.53 | 313.61 | 17883.0 |
| 2018-06-04 | FXXP | Futures | 335.1 | 336.3 | 334.4 | 335.0 | 30123.0 |
| 2018-06-04 | G | Futures | 115.19 | 115.35 | 114.99 | 115.15 | 167669.0 |
| 2018-06-04 | GF | Futures | 302.915 | 303.951 | 299.756 | 300.067 | 9025.0 |
| 2018-06-04 | GSCI | Futures | 530.68 | 530.68 | 527.48 | 528.04 | 79.0 |
| 2018-06-04 | HE | Futures | 80.765 | 81.047 | 78.251 | 79.944 | 21927.0 |
> showing 50 of 114 rows — these rows as CSV