PREVIEW / futures_daily / 2021-01-27
file: by_date/futures_daily/2021/2021-01-27.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-01-27 | ES | Futures | 4309.76 | 4318.45 | 4154.25 | 4196.56 | 2572020.0 |
| 2021-01-27 | NQ | Futures | 15629.98 | 15670.93 | 14861.52 | 15116.13 | 786471.0 |
| 2021-01-27 | YM | Futures | 33313.4 | 33352.2 | 32454.8 | 32601.7 | 276292.0 |
| 2021-01-27 | CL | Futures | 37.26 | 37.64 | 36.62 | 37.32 | 442376.0 |
| 2021-01-27 | GC | Futures | 2176.9 | 2178.5 | 2151.2 | 2170.6 | 174141.0 |
| 2021-01-27 | ZN | Futures | 136.636461 | 136.900658 | 136.543215 | 136.791871 | 1667733.0 |
| 2021-01-27 | A6 | Futures | 0.7949 | 0.79669 | 0.78428 | 0.78638 | 156828.0 |
| 2021-01-27 | AD | Futures | 0.79814 | 0.79859 | 0.78998 | 0.79176 | 88348.0 |
| 2021-01-27 | ALI | Futures | 2346.77 | 2346.77 | 2346.77 | 2346.77 | 0.0 |
| 2021-01-27 | B | Futures | 35.46 | 35.68 | 34.89 | 35.26 | 316905.0 |
| 2021-01-27 | B6 | Futures | 1.3953 | 1.3975 | 1.3874 | 1.3902 | 105807.0 |
| 2021-01-27 | BR | Futures | 0.14536 | 0.14571 | 0.14365 | 0.14435 | 12987.0 |
| 2021-01-27 | BTC | Futures | 43926.7 | 44530.3 | 39353.0 | 42431.2 | 8212.0 |
| 2021-01-27 | BZ | Futures | 34.73 | 34.97 | 34.2 | 34.56 | 26925.0 |
| 2021-01-27 | C | Futures | 1472.0 | 1509.0 | 1467.0 | 1467.0 | 6603.0 |
| 2021-01-27 | CB | Futures | 138.887 | 139.81 | 137.226 | 137.987 | 24.0 |
| 2021-01-27 | CC | Futures | 1683.0 | 1707.0 | 1642.0 | 1646.0 | 18018.0 |
| 2021-01-27 | CNH | Futures | 6.3355 | 6.3625 | 6.3301 | 6.3567 | 499.0 |
| 2021-01-27 | CSC | Futures | 2.953 | 2.972 | 2.953 | 2.96 | 137.0 |
| 2021-01-27 | CT | Futures | 78.95 | 79.64 | 77.95 | 78.1 | 17426.0 |
| 2021-01-27 | DC | Futures | 25.06 | 25.53 | 25.06 | 25.27 | 493.0 |
| 2021-01-27 | DX | Futures | 87.176 | 87.867 | 87.142 | 87.635 | 47296.0 |
| 2021-01-27 | E1 | Futures | 1.27409 | 1.27522 | 1.26709 | 1.27071 | 23556.0 |
| 2021-01-27 | E6 | Futures | 1.29962 | 1.30074 | 1.28867 | 1.29326 | 284535.0 |
| 2021-01-27 | E7 | Futures | 1.2933 | 1.2942 | 1.2824 | 1.2869 | 10825.0 |
| 2021-01-27 | EBM | Futures | 283.8 | 286.88 | 282.26 | 284.73 | 38772.0 |
| 2021-01-27 | ED | Futures | 96.518 | 96.5276 | 96.518 | 96.5228 | 155325.0 |
| 2021-01-27 | ER | Futures | 98.465 | 98.484 | 98.46 | 98.475 | 166972.0 |
| 2021-01-27 | ESG | Futures | 354.58 | 356.52 | 345.25 | 347.67 | 211.0 |
| 2021-01-27 | EW | Futures | 2587.8 | 2595.6 | 2511.0 | 2527.6 | 16224.0 |
| 2021-01-27 | FBON | Futures | 150.15 | 150.44 | 150.15 | 150.29 | 471.0 |
| 2021-01-27 | FBTP | Futures | 138.08 | 138.41 | 138.05 | 138.21 | 116184.0 |
| 2021-01-27 | FBTS | Futures | 109.816 | 109.913 | 109.816 | 109.884 | 57290.0 |
| 2021-01-27 | FCE | Futures | 5370.0 | 5380.7 | 5238.0 | 5297.2 | 98977.0 |
| 2021-01-27 | FDAX | Futures | 14790.4 | 14801.1 | 14353.3 | 14534.6 | 92776.0 |
| 2021-01-27 | FDIV | Futures | 165.01 | 165.16 | 162.29 | 162.67 | 200.0 |
| 2021-01-27 | FDXM | Futures | 14742.6 | 14760.6 | 14313.1 | 14493.8 | 90569.0 |
| 2021-01-27 | FESX | Futures | 3337.9 | 3340.7 | 3246.7 | 3283.9 | 1353517.0 |
| 2021-01-27 | FGBL | Futures | 170.12 | 170.66 | 169.96 | 170.34 | 863973.0 |
| 2021-01-27 | FGBM | Futures | 135.23 | 135.46 | 135.2 | 135.35 | 505860.0 |
| 2021-01-27 | FGBS | Futures | 112.709 | 112.78 | 112.709 | 112.754 | 450093.0 |
| 2021-01-27 | FGBX | Futures | 233.45 | 234.96 | 232.95 | 233.72 | 101808.0 |
| 2021-01-27 | FMWO | Futures | 9706.4 | 9734.9 | 9455.3 | 9582.0 | 5001.0 |
| 2021-01-27 | FOAT | Futures | 158.33 | 158.83 | 158.24 | 158.53 | 199447.0 |
| 2021-01-27 | FTDX | Futures | 3508.3 | 3539.2 | 3442.3 | 3498.0 | 216.0 |
| 2021-01-27 | FTI | Futures | 615.19 | 615.65 | 601.08 | 606.78 | 32834.0 |
| 2021-01-27 | FTUK | Futures | 6371.4 | 6371.4 | 6221.6 | 6282.8 | 130599.0 |
| 2021-01-27 | FVSA | Futures | 166.96 | 204.61 | 166.96 | 185.08 | 77460.0 |
| 2021-01-27 | FXXP | Futures | 378.3 | 378.8 | 370.2 | 374.0 | 118258.0 |
| 2021-01-27 | G | Futures | 126.41 | 126.74 | 126.24 | 126.5 | 239001.0 |
> showing 50 of 121 rows — these rows as CSV