PREVIEW / futures_daily / 2022-01-18
file: by_date/futures_daily/2022/2022-01-18.parquet size: 10 KB rows: 126
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-18 | ES | Futures | 5255.22 | 5261.69 | 5135.83 | 5148.5 | 2268240.0 |
| 2022-01-18 | NQ | Futures | 18001.67 | 18043.74 | 17487.56 | 17528.19 | 868066.0 |
| 2022-01-18 | YM | Futures | 39115.3 | 39164.4 | 38328.8 | 38464.1 | 322172.0 |
| 2022-01-18 | CL | Futures | 64.05 | 65.74 | 63.41 | 64.86 | 494002.0 |
| 2022-01-18 | GC | Futures | 2121.8 | 2126.7 | 2105.5 | 2114.4 | 362944.0 |
| 2022-01-18 | ZN | Futures | 130.877162 | 130.893134 | 130.078546 | 130.206325 | 2515636.0 |
| 2022-01-18 | A6 | Futures | 0.73942 | 0.74085 | 0.7347 | 0.73634 | 113456.0 |
| 2022-01-18 | AD | Futures | 0.80825 | 0.81226 | 0.80724 | 0.81099 | 107503.0 |
| 2022-01-18 | ALI | Futures | 3393.3 | 3395.52 | 3384.7 | 3394.69 | 27.0 |
| 2022-01-18 | B | Futures | 60.03 | 61.55 | 60.01 | 60.76 | 356876.0 |
| 2022-01-18 | B6 | Futures | 1.3855 | 1.3875 | 1.3756 | 1.3781 | 146010.0 |
| 2022-01-18 | BR | Futures | 0.14898 | 0.14914 | 0.14687 | 0.14708 | 2005.0 |
| 2022-01-18 | BTC | Futures | 56702.3 | 56761.3 | 53956.9 | 54599.0 | 6821.0 |
| 2022-01-18 | BZ | Futures | 58.33 | 59.71 | 57.69 | 59.01 | 45875.0 |
| 2022-01-18 | C | Futures | 1427.0 | 1427.0 | 1407.0 | 1414.0 | 10277.0 |
| 2022-01-18 | CB | Futures | 191.565 | 193.516 | 189.614 | 190.121 | 50.0 |
| 2022-01-18 | CC | Futures | 1679.0 | 1683.0 | 1648.0 | 1655.0 | 31842.0 |
| 2022-01-18 | CNH | Futures | 6.0681 | 6.0718 | 6.0485 | 6.0665 | 1231.0 |
| 2022-01-18 | CSC | Futures | 2.894 | 2.92 | 2.861 | 2.872 | 197.0 |
| 2022-01-18 | CT | Futures | 116.33 | 117.88 | 115.63 | 117.6 | 15842.0 |
| 2022-01-18 | DC | Futures | 28.16 | 28.7 | 27.88 | 28.11 | 469.0 |
| 2022-01-18 | DX | Futures | 91.952 | 92.59 | 91.909 | 92.506 | 24080.0 |
| 2022-01-18 | E1 | Futures | 1.22288 | 1.22522 | 1.21763 | 1.21875 | 25536.0 |
| 2022-01-18 | E6 | Futures | 1.21124 | 1.21293 | 1.20032 | 1.20149 | 287778.0 |
| 2022-01-18 | E7 | Futures | 1.2042 | 1.2061 | 1.1935 | 1.1948 | 13108.0 |
| 2022-01-18 | EBM | Futures | 381.89 | 385.47 | 378.67 | 383.32 | 24719.0 |
| 2022-01-18 | ED | Futures | 96.4187 | 96.4236 | 96.38 | 96.3897 | 256985.0 |
| 2022-01-18 | ER | Futures | 98.514 | 98.519 | 98.509 | 98.514 | 35419.0 |
| 2022-01-18 | ESG | Futures | 436.3 | 436.3 | 428.08 | 428.94 | 971.0 |
| 2022-01-18 | EW | Futures | 3003.8 | 3003.8 | 2924.3 | 2929.4 | 13127.0 |
| 2022-01-18 | FBON | Futures | 146.66 | 146.97 | 146.48 | 146.79 | 183.0 |
| 2022-01-18 | FBTP | Futures | 133.95 | 134.23 | 133.69 | 133.99 | 138601.0 |
| 2022-01-18 | FBTS | Futures | 109.884 | 109.962 | 109.874 | 109.933 | 54488.0 |
| 2022-01-18 | FCE | Futures | 7188.5 | 7194.0 | 7102.9 | 7139.4 | 35558.0 |
| 2022-01-18 | FDAX | Futures | 17092.3 | 17120.2 | 16799.4 | 16931.3 | 96541.0 |
| 2022-01-18 | FDIV | Futures | 193.8 | 193.9 | 193.8 | 193.9 | 15.0 |
| 2022-01-18 | FDXM | Futures | 17170.6 | 17194.3 | 16872.1 | 17005.7 | 57389.0 |
| 2022-01-18 | FDXS | Futures | 16997.4 | 17038.0 | 16719.7 | 16851.1 | 20352.0 |
| 2022-01-18 | FESX | Futures | 4125.4 | 4133.1 | 4057.6 | 4088.9 | 757722.0 |
| 2022-01-18 | FGBL | Futures | 165.32 | 165.45 | 164.97 | 165.22 | 737075.0 |
| 2022-01-18 | FGBM | Futures | 133.5 | 133.59 | 133.4 | 133.53 | 497105.0 |
| 2022-01-18 | FGBS | Futures | 112.538 | 112.563 | 112.513 | 112.548 | 250803.0 |
| 2022-01-18 | FGBX | Futures | 220.92 | 221.31 | 219.66 | 220.38 | 71377.0 |
| 2022-01-18 | FMWO | Futures | 11276.0 | 11296.1 | 11121.0 | 11175.5 | 8258.0 |
| 2022-01-18 | FOAT | Futures | 153.14 | 153.2 | 152.75 | 152.97 | 178777.0 |
| 2022-01-18 | FSMX | Futures | 35971.2 | 35971.2 | 35657.5 | 35803.3 | 407.0 |
| 2022-01-18 | FTDX | Futures | 3649.8 | 3649.8 | 3590.9 | 3612.1 | 249.0 |
| 2022-01-18 | FTI | Futures | 749.04 | 750.29 | 737.03 | 741.61 | 9761.0 |
| 2022-01-18 | FTUK | Futures | 7523.0 | 7533.0 | 7436.5 | 7478.8 | 101466.0 |
| 2022-01-18 | FVSA | Futures | 63.51 | 68.39 | 63.07 | 67.06 | 60127.0 |
> showing 50 of 126 rows — these rows as CSV