PREVIEW / futures_daily / 2020-01-15
file: by_date/futures_daily/2020/2020-01-15.parquet size: 10 KB rows: 118
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-01-15 | ES | Futures | 3550.82 | 3562.97 | 3540.02 | 3557.3 | 1468347.0 |
| 2020-01-15 | NQ | Futures | 10394.29 | 10433.29 | 10349.55 | 10391.99 | 497100.0 |
| 2020-01-15 | YM | Futures | 30386.6 | 30550.5 | 30285.8 | 30486.4 | 224025.0 |
| 2020-01-15 | CL | Futures | 59.72 | 59.9 | 58.89 | 59.32 | 271198.0 |
| 2020-01-15 | GC | Futures | 1903.0 | 1917.7 | 1902.6 | 1911.8 | 310070.0 |
| 2020-01-15 | ZN | Futures | 128.025152 | 128.288419 | 127.978694 | 128.195502 | 1349774.0 |
| 2020-01-15 | A6 | Futures | 0.7084 | 0.71004 | 0.70604 | 0.7087 | 70440.0 |
| 2020-01-15 | AD | Futures | 0.77159 | 0.773 | 0.77053 | 0.7727 | 50724.0 |
| 2020-01-15 | ALI | Futures | 2188.3 | 2188.6 | 2181.11 | 2184.1 | 94.0 |
| 2020-01-15 | B | Futures | 52.69 | 52.82 | 51.96 | 52.33 | 229526.0 |
| 2020-01-15 | B6 | Futures | 1.3229 | 1.325 | 1.319 | 1.3234 | 74724.0 |
| 2020-01-15 | BR | Futures | 0.19579 | 0.19587 | 0.19372 | 0.19405 | 402.0 |
| 2020-01-15 | BTC | Futures | 13354.8 | 13635.2 | 13089.5 | 13460.9 | 7019.0 |
| 2020-01-15 | BZ | Futures | 51.96 | 52.08 | 51.23 | 51.59 | 34164.0 |
| 2020-01-15 | C | Futures | 1865.0 | 1896.0 | 1862.0 | 1880.0 | 16115.0 |
| 2020-01-15 | CB | Futures | 238.286 | 238.286 | 237.814 | 238.168 | 37.0 |
| 2020-01-15 | CC | Futures | 1743.0 | 1781.0 | 1730.0 | 1759.0 | 24254.0 |
| 2020-01-15 | CNH | Futures | 6.876 | 6.8788 | 6.8608 | 6.8648 | 364.0 |
| 2020-01-15 | CSC | Futures | 3.303 | 3.342 | 3.294 | 3.342 | 127.0 |
| 2020-01-15 | CT | Futures | 67.9 | 67.9 | 66.68 | 66.89 | 19480.0 |
| 2020-01-15 | DC | Futures | 27.91 | 28.24 | 27.85 | 28.17 | 295.0 |
| 2020-01-15 | DX | Futures | 94.24 | 94.322 | 94.036 | 94.109 | 10975.0 |
| 2020-01-15 | E1 | Futures | 1.18564 | 1.19112 | 1.18507 | 1.19021 | 30107.0 |
| 2020-01-15 | E6 | Futures | 1.20323 | 1.20717 | 1.20226 | 1.20577 | 143915.0 |
| 2020-01-15 | E7 | Futures | 1.1969 | 1.2009 | 1.1961 | 1.1995 | 2217.0 |
| 2020-01-15 | EBM | Futures | 213.74 | 215.66 | 212.37 | 214.57 | 39255.0 |
| 2020-01-15 | ED | Futures | 95.318 | 95.318 | 95.3083 | 95.3132 | 197486.0 |
| 2020-01-15 | ER | Futures | 98.372 | 98.377 | 98.372 | 98.372 | 31360.0 |
| 2020-01-15 | ESG | Futures | 293.74 | 293.81 | 289.29 | 289.29 | 932.0 |
| 2020-01-15 | EW | Futures | 2185.7 | 2196.6 | 2177.8 | 2187.8 | 17021.0 |
| 2020-01-15 | FBON | Futures | 142.7 | 143.16 | 142.7 | 142.94 | 439.0 |
| 2020-01-15 | FBTP | Futures | 127.96 | 128.31 | 127.74 | 128.06 | 130408.0 |
| 2020-01-15 | FBTS | Futures | 108.105 | 108.172 | 108.095 | 108.124 | 41370.0 |
| 2020-01-15 | FCE | Futures | 5468.9 | 5487.5 | 5444.9 | 5464.3 | 61048.0 |
| 2020-01-15 | FDAX | Futures | 14215.2 | 14232.1 | 14151.8 | 14187.7 | 83644.0 |
| 2020-01-15 | FDIV | Futures | 159.92 | 160.1 | 159.92 | 160.1 | 2.0 |
| 2020-01-15 | FDXM | Futures | 14029.5 | 14053.5 | 13975.2 | 14009.6 | 40387.0 |
| 2020-01-15 | FESX | Futures | 3314.5 | 3319.8 | 3297.7 | 3308.3 | 785423.0 |
| 2020-01-15 | FGBL | Futures | 163.38 | 164.02 | 163.34 | 163.77 | 672851.0 |
| 2020-01-15 | FGBM | Futures | 133.34 | 133.55 | 133.34 | 133.49 | 364955.0 |
| 2020-01-15 | FGBS | Futures | 112.603 | 112.634 | 112.598 | 112.619 | 226267.0 |
| 2020-01-15 | FGBX | Futures | 208.32 | 210.41 | 208.28 | 209.7 | 71015.0 |
| 2020-01-15 | FMWO | Futures | 7965.4 | 7992.6 | 7954.0 | 7985.8 | 912.0 |
| 2020-01-15 | FOAT | Futures | 151.29 | 151.8 | 151.27 | 151.56 | 119414.0 |
| 2020-01-15 | FTDX | Futures | 3126.3 | 3127.3 | 3111.2 | 3114.7 | 61.0 |
| 2020-01-15 | FTI | Futures | 584.28 | 585.67 | 582.74 | 584.61 | 28478.0 |
| 2020-01-15 | FTUK | Futures | 7091.1 | 7111.8 | 7076.6 | 7106.6 | 78519.0 |
| 2020-01-15 | FVSA | Futures | 117.77 | 119.47 | 116.49 | 116.92 | 16763.0 |
| 2020-01-15 | FXXP | Futures | 380.5 | 381.6 | 379.7 | 381.0 | 56500.0 |
| 2020-01-15 | G | Futures | 120.93 | 121.78 | 120.93 | 121.58 | 251303.0 |
> showing 50 of 118 rows — these rows as CSV