PREVIEW / futures_daily / 2020-05-15
file: by_date/futures_daily/2020/2020-05-15.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 |
|---|---|---|---|---|---|---|---|
| 2020-05-15 | ES | Futures | 3149.33 | 3168.42 | 3108.67 | 3149.61 | 1897194.0 |
| 2020-05-15 | NQ | Futures | 10415.98 | 10488.21 | 10232.55 | 10428.59 | 537250.0 |
| 2020-05-15 | YM | Futures | 25103.5 | 25264.6 | 24799.4 | 25093.9 | 272384.0 |
| 2020-05-15 | CL | Futures | 20.31 | 21.62 | 19.96 | 21.4 | 425167.0 |
| 2020-05-15 | GC | Futures | 2108.3 | 2135.8 | 2106.3 | 2129.9 | 200179.0 |
| 2020-05-15 | ZN | Futures | 137.68576 | 137.963601 | 137.562275 | 137.639453 | 1039716.0 |
| 2020-05-15 | A6 | Futures | 0.66408 | 0.66511 | 0.65781 | 0.65946 | 74962.0 |
| 2020-05-15 | AD | Futures | 0.72156 | 0.72288 | 0.71786 | 0.71832 | 47285.0 |
| 2020-05-15 | ALI | Futures | 1782.39 | 1782.39 | 1782.39 | 1782.39 | 0.0 |
| 2020-05-15 | B | Futures | 20.81 | 21.73 | 20.43 | 21.46 | 211277.0 |
| 2020-05-15 | B6 | Futures | 1.2416 | 1.2426 | 1.2283 | 1.2301 | 87713.0 |
| 2020-05-15 | BFX | Futures | 2925.5 | 2960.2 | 2925.5 | 2960.2 | 15.0 |
| 2020-05-15 | BR | Futures | 0.14112 | 0.14206 | 0.13948 | 0.13997 | 6249.0 |
| 2020-05-15 | BTC | Futures | 13706.6 | 13810.9 | 12753.9 | 13066.8 | 7857.0 |
| 2020-05-15 | BZ | Futures | 20.04 | 21.03 | 19.79 | 20.78 | 29410.0 |
| 2020-05-15 | C | Futures | 1870.0 | 1905.0 | 1869.0 | 1882.0 | 5838.0 |
| 2020-05-15 | CB | Futures | 195.154 | 199.085 | 178.48 | 184.029 | 120.0 |
| 2020-05-15 | CC | Futures | 1586.0 | 1590.0 | 1557.0 | 1568.0 | 8506.0 |
| 2020-05-15 | CNH | Futures | 7.0513 | 7.0757 | 7.05 | 7.0701 | 354.0 |
| 2020-05-15 | CSC | Futures | 3.341 | 3.392 | 3.161 | 3.282 | 466.0 |
| 2020-05-15 | CT | Futures | 56.39 | 57.38 | 55.9 | 56.78 | 12545.0 |
| 2020-05-15 | DC | Futures | 26.8 | 26.8 | 25.84 | 26.8 | 786.0 |
| 2020-05-15 | DX | Futures | 96.992 | 97.196 | 96.789 | 97.117 | 12714.0 |
| 2020-05-15 | E1 | Futures | 1.17121 | 1.17531 | 1.16973 | 1.17246 | 14687.0 |
| 2020-05-15 | E6 | Futures | 1.16198 | 1.16693 | 1.16021 | 1.1629 | 140207.0 |
| 2020-05-15 | E7 | Futures | 1.1557 | 1.1608 | 1.1541 | 1.1568 | 7020.0 |
| 2020-05-15 | EBM | Futures | 222.15 | 223.94 | 221.85 | 223.35 | 18755.0 |
| 2020-05-15 | ED | Futures | 96.3678 | 96.3775 | 96.3581 | 96.3678 | 224019.0 |
| 2020-05-15 | ER | Futures | 98.264 | 98.269 | 98.259 | 98.264 | 49268.0 |
| 2020-05-15 | ESG | Futures | 255.27 | 259.33 | 255.27 | 259.33 | 80.0 |
| 2020-05-15 | EW | Futures | 1658.6 | 1675.8 | 1630.0 | 1670.4 | 9269.0 |
| 2020-05-15 | FBON | Futures | 140.42 | 140.69 | 140.31 | 140.35 | 205.0 |
| 2020-05-15 | FBTP | Futures | 123.5 | 123.73 | 122.95 | 123.1 | 60203.0 |
| 2020-05-15 | FBTS | Futures | 106.989 | 107.037 | 106.768 | 106.816 | 52386.0 |
| 2020-05-15 | FCE | Futures | 4165.4 | 4200.9 | 4121.7 | 4143.6 | 56585.0 |
| 2020-05-15 | FDAX | Futures | 11096.8 | 11152.3 | 10968.3 | 11057.1 | 84460.0 |
| 2020-05-15 | FDIV | Futures | 116.68 | 117.33 | 116.63 | 117.1 | 300.0 |
| 2020-05-15 | FDXM | Futures | 11142.4 | 11205.1 | 11023.3 | 11110.0 | 76852.0 |
| 2020-05-15 | FESX | Futures | 2549.7 | 2556.1 | 2513.0 | 2526.8 | 1245070.0 |
| 2020-05-15 | FEU3 | Futures | 99.006 | 99.006 | 99.001 | 99.001 | 100.0 |
| 2020-05-15 | FGBL | Futures | 168.77 | 169.36 | 168.74 | 168.88 | 471135.0 |
| 2020-05-15 | FGBM | Futures | 135.07 | 135.24 | 135.03 | 135.08 | 314862.0 |
| 2020-05-15 | FGBS | Futures | 112.93 | 112.966 | 112.91 | 112.925 | 196987.0 |
| 2020-05-15 | FGBX | Futures | 228.75 | 230.74 | 228.52 | 228.96 | 30405.0 |
| 2020-05-15 | FMWO | Futures | 6986.8 | 6991.5 | 6883.3 | 6912.7 | 4597.0 |
| 2020-05-15 | FOAT | Futures | 153.03 | 153.34 | 152.81 | 152.92 | 81427.0 |
| 2020-05-15 | FTDX | Futures | 2997.7 | 2997.7 | 2943.6 | 2945.6 | 61.0 |
| 2020-05-15 | FTI | Futures | 470.68 | 473.1 | 463.74 | 465.46 | 32829.0 |
| 2020-05-15 | FTUK | Futures | 5460.2 | 5509.3 | 5422.0 | 5463.1 | 98377.0 |
| 2020-05-15 | FVSA | Futures | 290.44 | 304.92 | 286.82 | 298.13 | 8713.0 |
> showing 50 of 121 rows — these rows as CSV