PREVIEW / futures_daily / 2020-11-23
file: by_date/futures_daily/2020/2020-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 |
|---|---|---|---|---|---|---|---|
| 2020-11-23 | ES | Futures | 3984.42 | 4031.05 | 3983.3 | 4017.57 | 1204848.0 |
| 2020-11-23 | NQ | Futures | 13769.79 | 13894.53 | 13670.52 | 13782.81 | 425777.0 |
| 2020-11-23 | YM | Futures | 31364.0 | 31889.4 | 31345.7 | 31808.6 | 154472.0 |
| 2020-11-23 | CL | Futures | 30.2 | 30.84 | 30.08 | 30.63 | 300717.0 |
| 2020-11-23 | GC | Futures | 2208.3 | 2214.4 | 2158.9 | 2170.5 | 319657.0 |
| 2020-11-23 | ZN | Futures | 137.396871 | 137.412368 | 137.133421 | 137.179913 | 2573621.0 |
| 2020-11-23 | A6 | Futures | 0.74975 | 0.75335 | 0.7459 | 0.74857 | 96162.0 |
| 2020-11-23 | AD | Futures | 0.77392 | 0.77691 | 0.77286 | 0.77483 | 55214.0 |
| 2020-11-23 | ALI | Futures | 2347.66 | 2347.66 | 2320.26 | 2321.43 | 95.0 |
| 2020-11-23 | B | Futures | 28.4 | 29.06 | 28.28 | 29.02 | 267249.0 |
| 2020-11-23 | B6 | Futures | 1.3484 | 1.3588 | 1.3452 | 1.3514 | 115483.0 |
| 2020-11-23 | BR | Futures | 0.1462 | 0.14726 | 0.14423 | 0.14439 | 11885.0 |
| 2020-11-23 | BTC | Futures | 24579.9 | 24876.9 | 23807.9 | 24296.2 | 12524.0 |
| 2020-11-23 | BZ | Futures | 27.84 | 28.45 | 27.69 | 28.41 | 35378.0 |
| 2020-11-23 | C | Futures | 1594.0 | 1638.0 | 1589.0 | 1631.0 | 2953.0 |
| 2020-11-23 | CB | Futures | 147.885 | 147.885 | 146.754 | 147.793 | 43.0 |
| 2020-11-23 | CC | Futures | 1808.0 | 1823.0 | 1790.0 | 1809.0 | 29746.0 |
| 2020-11-23 | CNH | Futures | 6.4234 | 6.4586 | 6.4165 | 6.452 | 938.0 |
| 2020-11-23 | CSC | Futures | 3.082 | 3.084 | 2.989 | 3.0 | 80.0 |
| 2020-11-23 | CT | Futures | 70.9 | 71.85 | 70.67 | 71.3 | 133.0 |
| 2020-11-23 | DC | Futures | 25.59 | 25.64 | 24.69 | 24.94 | 533.0 |
| 2020-11-23 | DX | Futures | 89.202 | 89.637 | 88.869 | 89.346 | 35608.0 |
| 2020-11-23 | E1 | Futures | 1.24318 | 1.24839 | 1.23843 | 1.24194 | 24076.0 |
| 2020-11-23 | E6 | Futures | 1.27098 | 1.27602 | 1.2645 | 1.26911 | 205523.0 |
| 2020-11-23 | E7 | Futures | 1.2643 | 1.2695 | 1.2581 | 1.2627 | 7179.0 |
| 2020-11-23 | EBM | Futures | 254.97 | 256.17 | 254.67 | 254.97 | 13138.0 |
| 2020-11-23 | ED | Futures | 96.4866 | 96.4914 | 96.4842 | 96.489 | 108387.0 |
| 2020-11-23 | ER | Futures | 98.465 | 98.465 | 98.455 | 98.46 | 79254.0 |
| 2020-11-23 | ESG | Futures | 330.95 | 331.11 | 328.03 | 330.41 | 208.0 |
| 2020-11-23 | EW | Futures | 2286.7 | 2340.8 | 2285.5 | 2329.9 | 11021.0 |
| 2020-11-23 | FBON | Futures | 150.47 | 150.54 | 150.28 | 150.42 | 132.0 |
| 2020-11-23 | FBTP | Futures | 138.41 | 138.61 | 138.3 | 138.5 | 68690.0 |
| 2020-11-23 | FBTS | Futures | 110.029 | 110.068 | 110.02 | 110.049 | 48763.0 |
| 2020-11-23 | FCE | Futures | 5377.4 | 5413.5 | 5347.1 | 5349.5 | 47567.0 |
| 2020-11-23 | FDAX | Futures | 14001.0 | 14189.1 | 13983.9 | 14034.0 | 69639.0 |
| 2020-11-23 | FDIV | Futures | 157.35 | 157.35 | 157.06 | 157.11 | 165.0 |
| 2020-11-23 | FDXM | Futures | 13934.6 | 14117.1 | 13912.3 | 13963.2 | 37626.0 |
| 2020-11-23 | FESX | Futures | 3204.3 | 3239.5 | 3196.9 | 3208.0 | 780016.0 |
| 2020-11-23 | FGBL | Futures | 170.87 | 170.88 | 170.44 | 170.59 | 552775.0 |
| 2020-11-23 | FGBM | Futures | 135.44 | 135.46 | 135.34 | 135.38 | 262207.0 |
| 2020-11-23 | FGBS | Futures | 112.835 | 112.84 | 112.81 | 112.815 | 324980.0 |
| 2020-11-23 | FGBX | Futures | 237.52 | 237.75 | 235.71 | 236.12 | 67754.0 |
| 2020-11-23 | FMWO | Futures | 8983.9 | 9023.0 | 8942.4 | 8959.0 | 1090.0 |
| 2020-11-23 | FOAT | Futures | 159.25 | 159.38 | 159.01 | 159.11 | 126079.0 |
| 2020-11-23 | FTDX | Futures | 3159.9 | 3162.5 | 3149.1 | 3150.7 | 57.0 |
| 2020-11-23 | FTI | Futures | 564.38 | 567.52 | 561.86 | 561.86 | 18144.0 |
| 2020-11-23 | FTUK | Futures | 6072.0 | 6096.8 | 6029.0 | 6052.4 | 86523.0 |
| 2020-11-23 | FVSA | Futures | 155.05 | 160.6 | 154.31 | 159.49 | 14680.0 |
| 2020-11-23 | FXXP | Futures | 362.6 | 363.9 | 359.8 | 360.7 | 47203.0 |
| 2020-11-23 | G | Futures | 126.0 | 126.06 | 125.63 | 125.77 | 498570.0 |
> showing 50 of 121 rows — these rows as CSV