PREVIEW / futures_daily / 2021-11-23
file: by_date/futures_daily/2021/2021-11-23.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 |
|---|---|---|---|---|---|---|---|
| 2021-11-23 | ES | Futures | 5271.24 | 5281.93 | 5229.62 | 5274.05 | 1872492.0 |
| 2021-11-23 | NQ | Futures | 18910.43 | 18933.21 | 18586.97 | 18810.11 | 901449.0 |
| 2021-11-23 | YM | Futures | 38755.7 | 38943.9 | 38483.7 | 38914.6 | 220528.0 |
| 2021-11-23 | CL | Futures | 57.51 | 59.31 | 56.64 | 59.04 | 506987.0 |
| 2021-11-23 | GC | Futures | 2108.3 | 2114.6 | 2078.6 | 2081.1 | 311348.0 |
| 2021-11-23 | ZN | Futures | 132.176489 | 132.271831 | 131.795119 | 131.985804 | 3340651.0 |
| 2021-11-23 | A6 | Futures | 0.7406 | 0.74188 | 0.73876 | 0.7404 | 71953.0 |
| 2021-11-23 | AD | Futures | 0.79933 | 0.80186 | 0.79648 | 0.80044 | 75197.0 |
| 2021-11-23 | ALI | Futures | 3027.82 | 3029.78 | 3000.16 | 3000.16 | 833.0 |
| 2021-11-23 | B | Futures | 54.35 | 56.47 | 53.7 | 56.27 | 366596.0 |
| 2021-11-23 | B6 | Futures | 1.3601 | 1.3612 | 1.3543 | 1.3584 | 75398.0 |
| 2021-11-23 | BR | Futures | 0.14475 | 0.14565 | 0.14317 | 0.14451 | 14428.0 |
| 2021-11-23 | BTC | Futures | 74528.4 | 76326.6 | 72947.6 | 76214.6 | 9700.0 |
| 2021-11-23 | BZ | Futures | 53.02 | 55.13 | 52.45 | 54.95 | 41865.0 |
| 2021-11-23 | C | Futures | 1472.0 | 1487.0 | 1472.0 | 1482.0 | 2436.0 |
| 2021-11-23 | CB | Futures | 160.353 | 160.353 | 157.622 | 157.622 | 28.0 |
| 2021-11-23 | CC | Futures | 1628.0 | 1635.0 | 1609.0 | 1616.0 | 16227.0 |
| 2021-11-23 | CNH | Futures | 6.1269 | 6.1317 | 6.122 | 6.1275 | 498.0 |
| 2021-11-23 | CSC | Futures | 2.456 | 2.474 | 2.452 | 2.452 | 244.0 |
| 2021-11-23 | CT | Futures | 109.81 | 112.59 | 109.01 | 112.34 | 214.0 |
| 2021-11-23 | DC | Futures | 23.51 | 23.78 | 23.3 | 23.64 | 477.0 |
| 2021-11-23 | DX | Futures | 93.206 | 93.351 | 93.062 | 93.235 | 15183.0 |
| 2021-11-23 | E1 | Futures | 1.2013 | 1.20466 | 1.19895 | 1.20052 | 22349.0 |
| 2021-11-23 | E6 | Futures | 1.19417 | 1.19831 | 1.19316 | 1.19571 | 179263.0 |
| 2021-11-23 | E7 | Futures | 1.1878 | 1.1918 | 1.1865 | 1.1892 | 4372.0 |
| 2021-11-23 | EBM | Futures | 452.27 | 458.88 | 451.16 | 457.78 | 15933.0 |
| 2021-11-23 | ED | Futures | 96.5005 | 96.5005 | 96.4909 | 96.4957 | 178175.0 |
| 2021-11-23 | ER | Futures | 98.499 | 98.504 | 98.499 | 98.499 | 32212.0 |
| 2021-11-23 | ESG | Futures | 442.45 | 443.64 | 439.35 | 443.08 | 490.0 |
| 2021-11-23 | EW | Futures | 3093.6 | 3107.1 | 3062.0 | 3089.5 | 18006.0 |
| 2021-11-23 | FBON | Futures | 149.4 | 149.4 | 148.43 | 148.52 | 557.0 |
| 2021-11-23 | FBTP | Futures | 138.07 | 138.14 | 136.92 | 137.12 | 175208.0 |
| 2021-11-23 | FBTS | Futures | 110.439 | 110.468 | 110.322 | 110.351 | 78700.0 |
| 2021-11-23 | FCE | Futures | 7156.6 | 7190.5 | 7077.7 | 7121.2 | 63249.0 |
| 2021-11-23 | FDAX | Futures | 17179.5 | 17199.9 | 16951.9 | 17062.0 | 93775.0 |
| 2021-11-23 | FDIV | Futures | 185.39 | 186.27 | 185.39 | 185.93 | 50.0 |
| 2021-11-23 | FDXM | Futures | 17214.5 | 17247.7 | 17001.2 | 17110.5 | 57108.0 |
| 2021-11-23 | FDXS | Futures | 17065.3 | 17084.4 | 16842.3 | 16951.7 | 39036.0 |
| 2021-11-23 | FESX | Futures | 4136.0 | 4143.7 | 4082.4 | 4106.8 | 835263.0 |
| 2021-11-23 | FGBL | Futures | 169.14 | 169.16 | 168.04 | 168.29 | 784989.0 |
| 2021-11-23 | FGBM | Futures | 135.03 | 135.06 | 134.74 | 134.82 | 399170.0 |
| 2021-11-23 | FGBS | Futures | 112.83 | 112.86 | 112.81 | 112.85 | 309537.0 |
| 2021-11-23 | FGBX | Futures | 230.96 | 231.29 | 227.9 | 228.83 | 91952.0 |
| 2021-11-23 | FMWO | Futures | 11353.4 | 11404.1 | 11295.6 | 11340.4 | 3558.0 |
| 2021-11-23 | FOAT | Futures | 156.49 | 156.51 | 155.27 | 155.52 | 215105.0 |
| 2021-11-23 | FTDX | Futures | 4029.3 | 4029.3 | 3939.5 | 3952.4 | 614.0 |
| 2021-11-23 | FTI | Futures | 773.41 | 774.36 | 764.25 | 765.15 | 28337.0 |
| 2021-11-23 | FTUK | Futures | 7137.1 | 7194.4 | 7104.5 | 7175.6 | 87717.0 |
| 2021-11-23 | FVSA | Futures | 65.38 | 67.44 | 63.95 | 65.85 | 25887.0 |
| 2021-11-23 | FXXP | Futures | 460.9 | 461.5 | 455.4 | 457.4 | 84283.0 |
> showing 50 of 121 rows — these rows as CSV