PREVIEW / futures_daily / 2020-12-03
file: by_date/futures_daily/2020/2020-12-03.parquet size: 10 KB rows: 120
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-12-03 | ES | Futures | 4124.3 | 4136.66 | 4106.6 | 4117.0 | 1124033.0 |
| 2020-12-03 | NQ | Futures | 14438.95 | 14517.96 | 14406.53 | 14427.66 | 376884.0 |
| 2020-12-03 | YM | Futures | 32174.6 | 32396.4 | 32033.6 | 32224.2 | 155243.0 |
| 2020-12-03 | CL | Futures | 32.0 | 32.61 | 31.77 | 32.46 | 350768.0 |
| 2020-12-03 | GC | Futures | 2157.0 | 2172.9 | 2148.5 | 2165.5 | 180357.0 |
| 2020-12-03 | ZN | Futures | 136.82348 | 137.071433 | 136.730498 | 136.947457 | 24033.0 |
| 2020-12-03 | A6 | Futures | 0.7611 | 0.76484 | 0.7595 | 0.76453 | 80717.0 |
| 2020-12-03 | AD | Futures | 0.78451 | 0.78852 | 0.78304 | 0.78831 | 64162.0 |
| 2020-12-03 | ALI | Futures | 2400.7 | 2404.83 | 2395.99 | 2396.87 | 22.0 |
| 2020-12-03 | B | Futures | 30.33 | 30.93 | 30.12 | 30.78 | 274725.0 |
| 2020-12-03 | B6 | Futures | 1.3561 | 1.3691 | 1.354 | 1.3638 | 140756.0 |
| 2020-12-03 | BR | Futures | 0.15036 | 0.1516 | 0.15036 | 0.15157 | 11.0 |
| 2020-12-03 | BTC | Futures | 25195.1 | 25898.6 | 24843.3 | 25488.2 | 7203.0 |
| 2020-12-03 | BZ | Futures | 29.72 | 30.24 | 29.47 | 30.11 | 36526.0 |
| 2020-12-03 | C | Futures | 1550.0 | 1577.0 | 1525.0 | 1533.0 | 683.0 |
| 2020-12-03 | CB | Futures | 155.498 | 157.113 | 155.498 | 156.537 | 27.0 |
| 2020-12-03 | CC | Futures | 1740.0 | 1792.0 | 1729.0 | 1742.0 | 16957.0 |
| 2020-12-03 | CNH | Futures | 6.4138 | 6.4186 | 6.392 | 6.398 | 928.0 |
| 2020-12-03 | CSC | Futures | 3.021 | 3.023 | 3.021 | 3.023 | 16.0 |
| 2020-12-03 | CT | Futures | 69.18 | 69.54 | 68.67 | 68.7 | 13512.0 |
| 2020-12-03 | DC | Futures | 25.14 | 25.5 | 25.06 | 25.43 | 88.0 |
| 2020-12-03 | DX | Futures | 87.97 | 87.994 | 87.425 | 87.63 | 22118.0 |
| 2020-12-03 | E1 | Futures | 1.26583 | 1.27376 | 1.26492 | 1.27059 | 23622.0 |
| 2020-12-03 | E6 | Futures | 1.29782 | 1.3044 | 1.29648 | 1.30092 | 234305.0 |
| 2020-12-03 | E7 | Futures | 1.2914 | 1.2978 | 1.29 | 1.2943 | 8150.0 |
| 2020-12-03 | EBM | Futures | 252.86 | 252.86 | 248.64 | 251.05 | 7011.0 |
| 2020-12-03 | ED | Futures | 96.4914 | 96.4963 | 96.4866 | 96.4963 | 183329.0 |
| 2020-12-03 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.465 | 24727.0 |
| 2020-12-03 | ESG | Futures | 339.28 | 340.54 | 338.22 | 338.83 | 671.0 |
| 2020-12-03 | EW | Futures | 2345.6 | 2369.2 | 2334.6 | 2354.7 | 13162.0 |
| 2020-12-03 | FBON | Futures | 150.22 | 150.46 | 150.14 | 150.46 | 1656.0 |
| 2020-12-03 | FBTP | Futures | 138.46 | 138.75 | 138.33 | 138.67 | 252854.0 |
| 2020-12-03 | FBTS | Futures | 110.029 | 110.068 | 110.02 | 110.058 | 143907.0 |
| 2020-12-03 | FCE | Futures | 5434.9 | 5444.7 | 5402.2 | 5433.0 | 36730.0 |
| 2020-12-03 | FDAX | Futures | 14165.2 | 14212.1 | 14048.9 | 14134.8 | 58233.0 |
| 2020-12-03 | FDXM | Futures | 14103.3 | 14134.0 | 13978.1 | 14063.5 | 36702.0 |
| 2020-12-03 | FESX | Futures | 3250.5 | 3258.9 | 3230.2 | 3250.5 | 637890.0 |
| 2020-12-03 | FGBL | Futures | 169.83 | 170.36 | 169.76 | 170.13 | 1331908.0 |
| 2020-12-03 | FGBM | Futures | 135.16 | 135.36 | 135.15 | 135.28 | 869944.0 |
| 2020-12-03 | FGBS | Futures | 112.754 | 112.795 | 112.749 | 112.775 | 744096.0 |
| 2020-12-03 | FGBX | Futures | 233.93 | 235.52 | 233.31 | 234.83 | 156381.0 |
| 2020-12-03 | FMWO | Futures | 9218.4 | 9262.2 | 9206.5 | 9256.3 | 5322.0 |
| 2020-12-03 | FOAT | Futures | 158.46 | 158.82 | 158.37 | 158.74 | 398278.0 |
| 2020-12-03 | FTDX | Futures | 3188.7 | 3193.9 | 3160.4 | 3173.8 | 52.0 |
| 2020-12-03 | FTI | Futures | 570.93 | 572.98 | 568.22 | 570.38 | 16471.0 |
| 2020-12-03 | FTUK | Futures | 6144.1 | 6213.4 | 6135.5 | 6192.9 | 95386.0 |
| 2020-12-03 | FVSA | Futures | 153.57 | 156.16 | 150.61 | 153.2 | 14061.0 |
| 2020-12-03 | FXXP | Futures | 362.3 | 363.4 | 361.1 | 363.0 | 41424.0 |
| 2020-12-03 | G | Futures | 125.64 | 125.94 | 125.55 | 125.79 | 212666.0 |
| 2020-12-03 | GF | Futures | 276.59 | 277.126 | 271.711 | 272.833 | 4664.0 |
> showing 50 of 120 rows — these rows as CSV