PREVIEW / futures_daily / 2022-07-20
file: by_date/futures_daily/2022/2022-07-20.parquet size: 10 KB rows: 128
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-07-20 | ES | Futures | 4427.77 | 4461.71 | 4400.01 | 4445.16 | 1734355.0 |
| 2022-07-20 | NQ | Futures | 14079.76 | 14293.29 | 13971.57 | 14233.63 | 643607.0 |
| 2022-07-20 | YM | Futures | 34778.8 | 34965.8 | 34573.2 | 34826.9 | 153532.0 |
| 2022-07-20 | CL | Futures | 85.07 | 85.39 | 83.22 | 84.68 | 315620.0 |
| 2022-07-20 | GC | Futures | 1975.5 | 1979.2 | 1953.1 | 1964.7 | 174466.0 |
| 2022-07-20 | ZN | Futures | 121.234057 | 121.892763 | 121.057331 | 121.105529 | 1151592.0 |
| 2022-07-20 | A6 | Futures | 0.70732 | 0.71049 | 0.7046 | 0.70578 | 87025.0 |
| 2022-07-20 | AD | Futures | 0.78775 | 0.78892 | 0.78567 | 0.78729 | 87486.0 |
| 2022-07-20 | ALI | Futures | 2710.91 | 2766.31 | 2694.6 | 2728.35 | 1620.0 |
| 2022-07-20 | B | Futures | 86.12 | 86.42 | 84.52 | 86.0 | 186695.0 |
| 2022-07-20 | B6 | Futures | 1.219 | 1.2229 | 1.2144 | 1.2157 | 90361.0 |
| 2022-07-20 | BR | Futures | 0.15813 | 0.15935 | 0.15722 | 0.15739 | 666.0 |
| 2022-07-20 | BTC | Futures | 32965.3 | 33871.4 | 31961.7 | 33028.1 | 10139.0 |
| 2022-07-20 | BZ | Futures | 84.15 | 84.37 | 82.53 | 83.97 | 23989.0 |
| 2022-07-20 | C | Futures | 1299.0 | 1315.0 | 1299.0 | 1309.0 | 7815.0 |
| 2022-07-20 | CB | Futures | 217.563 | 217.563 | 216.354 | 217.059 | 42.0 |
| 2022-07-20 | CC | Futures | 1407.0 | 1427.0 | 1405.0 | 1415.0 | 22889.0 |
| 2022-07-20 | CNH | Futures | 6.3608 | 6.3915 | 6.3536 | 6.3841 | 515.0 |
| 2022-07-20 | CSC | Futures | 2.796 | 2.802 | 2.783 | 2.802 | 107.0 |
| 2022-07-20 | CT | Futures | 126.65 | 128.22 | 126.64 | 127.26 | 16.0 |
| 2022-07-20 | DC | Futures | 26.33 | 26.45 | 26.18 | 26.42 | 266.0 |
| 2022-07-20 | DX | Futures | 102.789 | 103.344 | 102.476 | 103.173 | 31195.0 |
| 2022-07-20 | E1 | Futures | 1.14671 | 1.14781 | 1.14079 | 1.1425 | 22619.0 |
| 2022-07-20 | E6 | Futures | 1.08035 | 1.08524 | 1.07288 | 1.07514 | 240607.0 |
| 2022-07-20 | E7 | Futures | 1.0741 | 1.0785 | 1.0664 | 1.0687 | 8773.0 |
| 2022-07-20 | EBM | Futures | 473.92 | 486.54 | 472.52 | 476.72 | 19948.0 |
| 2022-07-20 | ED | Futures | 94.8579 | 94.8874 | 94.8481 | 94.853 | 90689.0 |
| 2022-07-20 | ER | Futures | 98.089 | 98.144 | 98.065 | 98.099 | 137718.0 |
| 2022-07-20 | ESG | Futures | 383.32 | 385.82 | 380.95 | 384.36 | 457.0 |
| 2022-07-20 | EW | Futures | 2591.7 | 2619.4 | 2570.2 | 2613.0 | 13610.0 |
| 2022-07-20 | FBON | Futures | 128.6 | 129.63 | 128.34 | 128.51 | 136.0 |
| 2022-07-20 | FBTP | Futures | 114.31 | 116.13 | 112.88 | 114.32 | 226338.0 |
| 2022-07-20 | FBTS | Futures | 106.695 | 107.424 | 106.193 | 106.754 | 139917.0 |
| 2022-07-20 | FCE | Futures | 6830.0 | 6855.8 | 6716.4 | 6785.5 | 66695.0 |
| 2022-07-20 | FDAX | Futures | 14355.8 | 14461.2 | 14110.4 | 14281.5 | 73037.0 |
| 2022-07-20 | FDIV | Futures | 160.07 | 160.07 | 158.88 | 159.17 | 38.0 |
| 2022-07-20 | FDXM | Futures | 14428.3 | 14550.7 | 14195.6 | 14368.8 | 40549.0 |
| 2022-07-20 | FDXS | Futures | 14284.0 | 14434.3 | 14081.0 | 14251.7 | 28829.0 |
| 2022-07-20 | FESX | Futures | 3565.7 | 3584.5 | 3511.1 | 3548.8 | 1045387.0 |
| 2022-07-20 | FGBL | Futures | 149.03 | 150.37 | 148.86 | 149.3 | 713598.0 |
| 2022-07-20 | FGBM | Futures | 126.68 | 127.38 | 126.6 | 126.8 | 461330.0 |
| 2022-07-20 | FGBS | Futures | 111.095 | 111.339 | 111.049 | 111.141 | 496917.0 |
| 2022-07-20 | FGBX | Futures | 173.17 | 176.15 | 172.72 | 173.66 | 50793.0 |
| 2022-07-20 | FMWO | Futures | 9463.0 | 9493.5 | 9375.2 | 9466.5 | 6417.0 |
| 2022-07-20 | FOAT | Futures | 136.93 | 138.19 | 136.92 | 137.19 | 155269.0 |
| 2022-07-20 | FSMX | Futures | 28557.3 | 28673.8 | 28300.7 | 28517.7 | 424.0 |
| 2022-07-20 | FTDX | Futures | 3191.8 | 3202.0 | 3164.0 | 3191.8 | 96.0 |
| 2022-07-20 | FTI | Futures | 695.73 | 700.74 | 690.51 | 699.36 | 22656.0 |
| 2022-07-20 | FTUK | Futures | 7370.2 | 7400.6 | 7287.6 | 7317.0 | 97427.0 |
| 2022-07-20 | FVSA | Futures | 76.83 | 81.72 | 76.83 | 79.77 | 26333.0 |
> showing 50 of 128 rows — these rows as CSV