PREVIEW / futures_daily / 2020-06-01
file: by_date/futures_daily/2020/2020-06-01.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-01 | ES | Futures | 3352.38 | 3384.74 | 3328.31 | 3379.21 | 1277803.0 |
| 2020-06-01 | NQ | Futures | 10906.08 | 11012.41 | 10834.14 | 11000.09 | 345593.0 |
| 2020-06-01 | YM | Futures | 26922.8 | 27230.1 | 26771.3 | 27170.4 | 175632.0 |
| 2020-06-01 | CL | Futures | 25.53 | 26.03 | 24.84 | 25.69 | 385710.0 |
| 2020-06-01 | GC | Futures | 2100.8 | 2114.3 | 2086.2 | 2101.4 | 146131.0 |
| 2020-06-01 | ZN | Futures | 137.762938 | 137.840116 | 137.423354 | 137.639453 | 46926.0 |
| 2020-06-01 | A6 | Futures | 0.68463 | 0.69911 | 0.68299 | 0.6984 | 107620.0 |
| 2020-06-01 | AD | Futures | 0.73585 | 0.7474 | 0.73417 | 0.74633 | 76497.0 |
| 2020-06-01 | ALI | Futures | 1846.85 | 1849.23 | 1838.83 | 1840.31 | 184.0 |
| 2020-06-01 | B | Futures | 24.59 | 25.32 | 24.34 | 25.08 | 212783.0 |
| 2020-06-01 | B6 | Futures | 1.2525 | 1.2697 | 1.2513 | 1.2684 | 97449.0 |
| 2020-06-01 | BR | Futures | 0.14639 | 0.14754 | 0.14639 | 0.14754 | 11.0 |
| 2020-06-01 | BTC | Futures | 13254.6 | 13595.4 | 13164.2 | 13421.5 | 3656.0 |
| 2020-06-01 | BZ | Futures | 24.0 | 24.73 | 23.76 | 24.5 | 26475.0 |
| 2020-06-01 | C | Futures | 1863.0 | 1885.0 | 1858.0 | 1873.0 | 4115.0 |
| 2020-06-01 | CB | Futures | 199.56 | 201.673 | 197.929 | 197.956 | 60.0 |
| 2020-06-01 | CC | Futures | 1597.0 | 1639.0 | 1591.0 | 1629.0 | 20172.0 |
| 2020-06-01 | CNH | Futures | 7.0755 | 7.0876 | 7.0627 | 7.0671 | 1223.0 |
| 2020-06-01 | CSC | Futures | 3.443 | 3.443 | 3.426 | 3.428 | 30.0 |
| 2020-06-01 | CT | Futures | 56.14 | 58.87 | 55.82 | 58.55 | 32114.0 |
| 2020-06-01 | DC | Futures | 28.43 | 28.64 | 28.16 | 28.45 | 99.0 |
| 2020-06-01 | DX | Futures | 95.02 | 95.088 | 94.541 | 94.59 | 15022.0 |
| 2020-06-01 | E1 | Futures | 1.18499 | 1.18955 | 1.18362 | 1.18465 | 19250.0 |
| 2020-06-01 | E6 | Futures | 1.19503 | 1.19917 | 1.19337 | 1.19681 | 126750.0 |
| 2020-06-01 | E7 | Futures | 1.1887 | 1.1927 | 1.1872 | 1.1906 | 5420.0 |
| 2020-06-01 | EBM | Futures | 225.14 | 225.44 | 221.85 | 223.35 | 13097.0 |
| 2020-06-01 | ED | Futures | 96.3895 | 96.4016 | 96.3895 | 96.3944 | 97213.0 |
| 2020-06-01 | ER | Futures | 98.303 | 98.318 | 98.298 | 98.308 | 43400.0 |
| 2020-06-01 | ESG | Futures | 274.49 | 275.53 | 274.49 | 275.53 | 5.0 |
| 2020-06-01 | EW | Futures | 1874.2 | 1900.9 | 1847.2 | 1889.1 | 10352.0 |
| 2020-06-01 | FBON | Futures | 143.42 | 143.56 | 143.15 | 143.38 | 452.0 |
| 2020-06-01 | FBTP | Futures | 127.06 | 127.64 | 126.92 | 127.59 | 110845.0 |
| 2020-06-01 | FBTS | Futures | 107.701 | 107.903 | 107.701 | 107.893 | 76279.0 |
| 2020-06-01 | FCE | Futures | 4610.7 | 4654.9 | 4576.2 | 4616.5 | 59331.0 |
| 2020-06-01 | FDAX | Futures | 12297.7 | 12630.4 | 12294.0 | 12539.9 | 49779.0 |
| 2020-06-01 | FDXM | Futures | 12375.1 | 12691.8 | 12367.7 | 12599.9 | 34432.0 |
| 2020-06-01 | FESX | Futures | 2798.5 | 2864.5 | 2798.5 | 2842.5 | 852275.0 |
| 2020-06-01 | FGBL | Futures | 167.55 | 167.6 | 166.68 | 166.85 | 638434.0 |
| 2020-06-01 | FGBM | Futures | 134.51 | 134.51 | 134.25 | 134.32 | 416838.0 |
| 2020-06-01 | FGBS | Futures | 112.734 | 112.764 | 112.704 | 112.734 | 366120.0 |
| 2020-06-01 | FGBX | Futures | 224.59 | 224.59 | 220.42 | 221.01 | 64696.0 |
| 2020-06-01 | FMWO | Futures | 7453.9 | 7549.2 | 7453.9 | 7504.5 | 10355.0 |
| 2020-06-01 | FOAT | Futures | 153.38 | 153.47 | 152.76 | 152.96 | 209857.0 |
| 2020-06-01 | FTDX | Futures | 3277.2 | 3288.8 | 3226.7 | 3282.8 | 13.0 |
| 2020-06-01 | FTI | Futures | 501.46 | 506.12 | 495.78 | 502.18 | 20895.0 |
| 2020-06-01 | FTUK | Futures | 5732.3 | 5844.1 | 5705.9 | 5815.8 | 92118.0 |
| 2020-06-01 | FVSA | Futures | 262.39 | 270.08 | 256.51 | 261.94 | 17918.0 |
| 2020-06-01 | FXXP | Futures | 327.7 | 331.7 | 325.7 | 329.5 | 31058.0 |
| 2020-06-01 | G | Futures | 126.89 | 126.99 | 126.4 | 126.51 | 117994.0 |
| 2020-06-01 | GF | Futures | 260.531 | 265.038 | 256.897 | 263.875 | 4875.0 |
> showing 50 of 119 rows — these rows as CSV