PREVIEW / futures_daily / 2021-05-07
file: by_date/futures_daily/2021/2021-05-07.parquet size: 10 KB rows: 123
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 |
|---|---|---|---|---|---|---|---|
| 2021-05-07 | ES | Futures | 4710.24 | 4749.24 | 4703.79 | 4741.38 | 1652592.0 |
| 2021-05-07 | NQ | Futures | 15703.22 | 15937.95 | 15672.95 | 15813.09 | 550632.0 |
| 2021-05-07 | YM | Futures | 37285.4 | 37587.4 | 37195.5 | 37541.9 | 167978.0 |
| 2021-05-07 | CL | Futures | 46.21 | 46.45 | 45.5 | 46.21 | 431417.0 |
| 2021-05-07 | GC | Futures | 2128.3 | 2162.5 | 2125.9 | 2146.9 | 367695.0 |
| 2021-05-07 | ZN | Futures | 133.253924 | 134.196202 | 133.222514 | 133.426675 | 2831157.0 |
| 2021-05-07 | A6 | Futures | 0.79813 | 0.80633 | 0.79592 | 0.80469 | 109311.0 |
| 2021-05-07 | AD | Futures | 0.83335 | 0.83568 | 0.83091 | 0.83456 | 80016.0 |
| 2021-05-07 | ALI | Futures | 2935.97 | 2937.4 | 2908.56 | 2925.98 | 911.0 |
| 2021-05-07 | B | Futures | 44.65 | 44.9 | 44.08 | 44.66 | 262581.0 |
| 2021-05-07 | B6 | Futures | 1.4105 | 1.4223 | 1.4103 | 1.4213 | 124092.0 |
| 2021-05-07 | BR | Futures | 0.14957 | 0.15175 | 0.14922 | 0.15108 | 17683.0 |
| 2021-05-07 | BTC | Futures | 77819.5 | 81265.1 | 76424.7 | 79766.8 | 4969.0 |
| 2021-05-07 | BZ | Futures | 43.59 | 43.79 | 43.01 | 43.58 | 29163.0 |
| 2021-05-07 | C | Futures | 1451.0 | 1491.0 | 1446.0 | 1486.0 | 885.0 |
| 2021-05-07 | CC | Futures | 1608.0 | 1647.0 | 1593.0 | 1641.0 | 20773.0 |
| 2021-05-07 | CNH | Futures | 6.2798 | 6.2818 | 6.2343 | 6.2343 | 691.0 |
| 2021-05-07 | CSC | Futures | 2.873 | 2.909 | 2.873 | 2.902 | 44.0 |
| 2021-05-07 | CT | Futures | 84.66 | 84.85 | 82.54 | 83.6 | 15724.0 |
| 2021-05-07 | DC | Futures | 26.82 | 26.87 | 26.46 | 26.66 | 444.0 |
| 2021-05-07 | DX | Futures | 87.818 | 87.895 | 87.137 | 87.181 | 46400.0 |
| 2021-05-07 | E1 | Futures | 1.24096 | 1.25097 | 1.23871 | 1.25007 | 27610.0 |
| 2021-05-07 | E6 | Futures | 1.28635 | 1.29785 | 1.28517 | 1.29716 | 226470.0 |
| 2021-05-07 | E7 | Futures | 1.2799 | 1.2912 | 1.2787 | 1.2907 | 8001.0 |
| 2021-05-07 | EBM | Futures | 342.76 | 343.13 | 334.31 | 341.29 | 31146.0 |
| 2021-05-07 | ED | Futures | 96.5077 | 96.5125 | 96.5028 | 96.5125 | 159052.0 |
| 2021-05-07 | ER | Futures | 98.45 | 98.455 | 98.45 | 98.45 | 31341.0 |
| 2021-05-07 | ESG | Futures | 389.91 | 393.37 | 389.78 | 392.59 | 342.0 |
| 2021-05-07 | EW | Futures | 2927.8 | 2964.5 | 2914.5 | 2960.6 | 9836.0 |
| 2021-05-07 | FBON | Futures | 147.26 | 147.37 | 146.56 | 146.93 | 1120.0 |
| 2021-05-07 | FBTP | Futures | 137.18 | 137.2 | 136.27 | 136.6 | 223847.0 |
| 2021-05-07 | FBTS | Futures | 110.01 | 110.02 | 109.874 | 109.932 | 132274.0 |
| 2021-05-07 | FCE | Futures | 6274.7 | 6290.0 | 6238.2 | 6281.1 | 56985.0 |
| 2021-05-07 | FDAX | Futures | 16249.9 | 16435.3 | 16239.2 | 16395.9 | 63459.0 |
| 2021-05-07 | FDIV | Futures | 185.54 | 186.23 | 185.54 | 186.23 | 50.0 |
| 2021-05-07 | FDXM | Futures | 16230.1 | 16415.4 | 16218.4 | 16376.0 | 60529.0 |
| 2021-05-07 | FDXS | Futures | 16163.7 | 16325.7 | 16163.7 | 16288.7 | 2854.0 |
| 2021-05-07 | FESX | Futures | 3768.6 | 3800.8 | 3765.8 | 3790.4 | 818499.0 |
| 2021-05-07 | FEU3 | Futures | 99.193 | 99.193 | 99.188 | 99.193 | 496.0 |
| 2021-05-07 | FGBL | Futures | 166.64 | 167.17 | 166.41 | 166.67 | 1002366.0 |
| 2021-05-07 | FGBM | Futures | 134.66 | 134.75 | 134.53 | 134.62 | 522697.0 |
| 2021-05-07 | FGBS | Futures | 112.639 | 112.644 | 112.609 | 112.624 | 250460.0 |
| 2021-05-07 | FGBX | Futures | 215.01 | 217.0 | 214.35 | 215.16 | 96643.0 |
| 2021-05-07 | FMWO | Futures | 10405.0 | 10501.4 | 10392.1 | 10487.3 | 3235.0 |
| 2021-05-07 | FOAT | Futures | 154.64 | 154.93 | 154.25 | 154.5 | 306776.0 |
| 2021-05-07 | FTDX | Futures | 3478.2 | 3556.8 | 3476.6 | 3518.8 | 115.0 |
| 2021-05-07 | FTI | Futures | 676.48 | 679.61 | 673.07 | 678.74 | 22205.0 |
| 2021-05-07 | FTUK | Futures | 6887.9 | 6941.5 | 6871.4 | 6919.1 | 79369.0 |
| 2021-05-07 | FVSA | Futures | 107.47 | 107.47 | 97.99 | 101.15 | 31039.0 |
| 2021-05-07 | FXXP | Futures | 420.1 | 421.1 | 417.5 | 419.9 | 76724.0 |
> showing 50 of 123 rows — these rows as CSV