PREVIEW / futures_daily / 2022-07-19
file: by_date/futures_daily/2022/2022-07-19.parquet size: 10 KB rows: 127
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-19 | ES | Futures | 4306.06 | 4428.9 | 4301.01 | 4417.12 | 1611604.0 |
| 2022-07-19 | NQ | Futures | 13599.04 | 14077.48 | 13576.2 | 14015.25 | 585591.0 |
| 2022-07-19 | YM | Futures | 33964.2 | 34817.1 | 33928.2 | 34759.1 | 143737.0 |
| 2022-07-19 | CL | Futures | 83.82 | 85.62 | 81.83 | 85.41 | 327214.0 |
| 2022-07-19 | GC | Futures | 1972.8 | 1983.6 | 1967.5 | 1976.9 | 131771.0 |
| 2022-07-19 | ZN | Futures | 121.523245 | 121.828499 | 121.185859 | 121.298321 | 1036276.0 |
| 2022-07-19 | A6 | Futures | 0.69841 | 0.7086 | 0.69738 | 0.70686 | 93482.0 |
| 2022-07-19 | AD | Futures | 0.78116 | 0.78805 | 0.78065 | 0.78734 | 74829.0 |
| 2022-07-19 | ALI | Futures | 2724.97 | 2736.5 | 2681.1 | 2685.88 | 1514.0 |
| 2022-07-19 | B | Futures | 85.05 | 86.55 | 83.33 | 86.34 | 226403.0 |
| 2022-07-19 | B6 | Futures | 1.2144 | 1.224 | 1.2115 | 1.2189 | 108517.0 |
| 2022-07-19 | BR | Futures | 0.15826 | 0.16 | 0.15826 | 0.159 | 840.0 |
| 2022-07-19 | BTC | Futures | 30191.5 | 33069.9 | 30073.0 | 32700.5 | 11774.0 |
| 2022-07-19 | BZ | Futures | 82.93 | 84.51 | 81.36 | 84.31 | 21900.0 |
| 2022-07-19 | C | Futures | 1281.0 | 1302.0 | 1271.0 | 1299.0 | 7801.0 |
| 2022-07-19 | CB | Futures | 218.772 | 218.772 | 217.946 | 217.946 | 21.0 |
| 2022-07-19 | CC | Futures | 1389.0 | 1407.0 | 1377.0 | 1403.0 | 16275.0 |
| 2022-07-19 | CNH | Futures | 6.3741 | 6.3741 | 6.3548 | 6.3608 | 595.0 |
| 2022-07-19 | CSC | Futures | 2.796 | 2.797 | 2.772 | 2.797 | 35.0 |
| 2022-07-19 | CT | Futures | 127.5 | 127.77 | 123.53 | 127.03 | 19.0 |
| 2022-07-19 | DC | Futures | 26.47 | 26.47 | 26.18 | 26.33 | 201.0 |
| 2022-07-19 | DX | Futures | 103.508 | 103.691 | 102.495 | 102.784 | 39641.0 |
| 2022-07-19 | E1 | Futures | 1.13626 | 1.15069 | 1.13487 | 1.14637 | 26289.0 |
| 2022-07-19 | E6 | Futures | 1.07198 | 1.08503 | 1.0692 | 1.08103 | 243697.0 |
| 2022-07-19 | E7 | Futures | 1.0656 | 1.0784 | 1.0627 | 1.0746 | 10111.0 |
| 2022-07-19 | EBM | Futures | 469.36 | 477.43 | 460.95 | 472.52 | 18944.0 |
| 2022-07-19 | ED | Futures | 94.8825 | 94.8923 | 94.8579 | 94.8678 | 98910.0 |
| 2022-07-19 | ER | Futures | 98.193 | 98.213 | 98.055 | 98.084 | 238441.0 |
| 2022-07-19 | ESG | Futures | 373.52 | 382.66 | 373.49 | 382.33 | 606.0 |
| 2022-07-19 | EW | Futures | 2507.9 | 2590.9 | 2506.5 | 2586.8 | 10607.0 |
| 2022-07-19 | FBON | Futures | 128.7 | 128.81 | 128.25 | 128.29 | 82.0 |
| 2022-07-19 | FBTP | Futures | 114.94 | 115.6 | 114.31 | 114.68 | 121517.0 |
| 2022-07-19 | FBTS | Futures | 107.148 | 107.296 | 106.794 | 106.922 | 87629.0 |
| 2022-07-19 | FCE | Futures | 6629.1 | 6830.0 | 6611.0 | 6803.1 | 61808.0 |
| 2022-07-19 | FDAX | Futures | 13843.5 | 14368.7 | 13785.4 | 14317.0 | 70457.0 |
| 2022-07-19 | FDIV | Futures | 155.8 | 159.42 | 155.8 | 159.42 | 30.0 |
| 2022-07-19 | FDXM | Futures | 13928.1 | 14460.8 | 13869.7 | 14404.5 | 41240.0 |
| 2022-07-19 | FDXS | Futures | 13810.4 | 14337.7 | 13756.7 | 14287.2 | 28342.0 |
| 2022-07-19 | FESX | Futures | 3450.6 | 3566.6 | 3439.7 | 3556.7 | 1123178.0 |
| 2022-07-19 | FGBL | Futures | 150.21 | 150.6 | 148.65 | 149.12 | 695622.0 |
| 2022-07-19 | FGBM | Futures | 127.45 | 127.62 | 126.49 | 126.75 | 549181.0 |
| 2022-07-19 | FGBS | Futures | 111.349 | 111.425 | 111.024 | 111.131 | 518743.0 |
| 2022-07-19 | FGBX | Futures | 174.96 | 175.82 | 172.25 | 173.11 | 49724.0 |
| 2022-07-19 | FMWO | Futures | 9171.5 | 9432.6 | 9162.1 | 9364.7 | 5436.0 |
| 2022-07-19 | FOAT | Futures | 137.72 | 138.13 | 136.67 | 137.09 | 181066.0 |
| 2022-07-19 | FSMX | Futures | 27528.8 | 28389.4 | 27425.1 | 28347.7 | 536.0 |
| 2022-07-19 | FTDX | Futures | 3108.3 | 3189.1 | 3074.6 | 3185.4 | 164.0 |
| 2022-07-19 | FTI | Futures | 681.39 | 698.21 | 678.05 | 694.58 | 22633.0 |
| 2022-07-19 | FTUK | Futures | 7247.5 | 7369.2 | 7223.2 | 7346.9 | 102091.0 |
| 2022-07-19 | FVSA | Futures | 83.26 | 84.1 | 77.95 | 78.65 | 34930.0 |
> showing 50 of 127 rows — these rows as CSV