PREVIEW / futures_daily / 2022-07-05
file: by_date/futures_daily/2022/2022-07-05.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-05 | ES | Futures | 4294.84 | 4327.65 | 4200.05 | 4301.01 | 2031501.0 |
| 2022-07-05 | NQ | Futures | 13252.48 | 13491.99 | 13004.98 | 13483.71 | 790937.0 |
| 2022-07-05 | YM | Futures | 33950.0 | 34134.8 | 33162.8 | 33824.3 | 213590.0 |
| 2022-07-05 | CL | Futures | 90.18 | 92.37 | 80.75 | 82.47 | 594215.0 |
| 2022-07-05 | GC | Futures | 2096.7 | 2097.6 | 2037.3 | 2038.3 | 310369.0 |
| 2022-07-05 | ZN | Futures | 122.840657 | 123.611825 | 122.069489 | 123.306571 | 1761880.0 |
| 2022-07-05 | A6 | Futures | 0.69871 | 0.70681 | 0.69313 | 0.69605 | 149183.0 |
| 2022-07-05 | AD | Futures | 0.78744 | 0.79018 | 0.77527 | 0.77745 | 157043.0 |
| 2022-07-05 | ALI | Futures | 2760.71 | 2768.06 | 2641.9 | 2683.2 | 2626.0 |
| 2022-07-05 | B | Futures | 91.32 | 92.29 | 81.32 | 82.66 | 428839.0 |
| 2022-07-05 | B6 | Futures | 1.2289 | 1.236 | 1.2089 | 1.214 | 171004.0 |
| 2022-07-05 | BR | Futures | 0.16065 | 0.16156 | 0.15813 | 0.15835 | 2793.0 |
| 2022-07-05 | BTC | Futures | 26860.1 | 28909.1 | 26462.9 | 28421.3 | 15041.0 |
| 2022-07-05 | BZ | Futures | 87.65 | 90.07 | 79.41 | 80.71 | 43356.0 |
| 2022-07-05 | C | Futures | 1284.0 | 1291.0 | 1265.0 | 1287.0 | 3278.0 |
| 2022-07-05 | CB | Futures | 227.233 | 227.233 | 221.632 | 221.793 | 66.0 |
| 2022-07-05 | CC | Futures | 1377.0 | 1393.0 | 1360.0 | 1384.0 | 27886.0 |
| 2022-07-05 | CNH | Futures | 6.321 | 6.345 | 6.308 | 6.3325 | 939.0 |
| 2022-07-05 | CSC | Futures | 3.064 | 3.064 | 2.984 | 2.984 | 173.0 |
| 2022-07-05 | CT | Futures | 132.78 | 133.84 | 128.53 | 128.53 | 61.0 |
| 2022-07-05 | DC | Futures | 29.06 | 29.3 | 28.28 | 28.28 | 357.0 |
| 2022-07-05 | DX | Futures | 101.207 | 102.813 | 101.13 | 102.562 | 50056.0 |
| 2022-07-05 | E1 | Futures | 1.15826 | 1.16296 | 1.14532 | 1.14776 | 34996.0 |
| 2022-07-05 | E6 | Futures | 1.10249 | 1.10654 | 1.08229 | 1.08508 | 346097.0 |
| 2022-07-05 | E7 | Futures | 1.0952 | 1.0998 | 1.0757 | 1.0785 | 12806.0 |
| 2022-07-05 | EBM | Futures | 480.93 | 487.59 | 460.95 | 465.16 | 31091.0 |
| 2022-07-05 | ED | Futures | 95.138 | 95.1675 | 95.0643 | 95.1478 | 101656.0 |
| 2022-07-05 | ER | Futures | 98.45 | 98.475 | 98.426 | 98.46 | 123910.0 |
| 2022-07-05 | ESG | Futures | 368.25 | 372.01 | 363.64 | 371.94 | 839.0 |
| 2022-07-05 | EW | Futures | 2498.9 | 2507.9 | 2424.4 | 2496.8 | 15402.0 |
| 2022-07-05 | FBON | Futures | 128.11 | 129.16 | 127.79 | 129.13 | 236.0 |
| 2022-07-05 | FBTP | Futures | 115.36 | 116.23 | 115.0 | 115.98 | 150925.0 |
| 2022-07-05 | FBTS | Futures | 107.532 | 107.847 | 107.463 | 107.827 | 78682.0 |
| 2022-07-05 | FCE | Futures | 6510.1 | 6522.6 | 6289.3 | 6300.2 | 69533.0 |
| 2022-07-05 | FDAX | Futures | 13828.5 | 13872.6 | 13308.7 | 13315.1 | 94809.0 |
| 2022-07-05 | FDIV | Futures | 150.93 | 150.93 | 148.0 | 148.0 | 26.0 |
| 2022-07-05 | FDXM | Futures | 13885.9 | 13958.4 | 13390.0 | 13396.5 | 57306.0 |
| 2022-07-05 | FDXS | Futures | 13788.9 | 13843.7 | 13283.1 | 13287.4 | 33453.0 |
| 2022-07-05 | FESX | Futures | 3435.7 | 3456.5 | 3316.6 | 3318.6 | 1184595.0 |
| 2022-07-05 | FGBL | Futures | 147.29 | 149.47 | 146.77 | 149.26 | 804111.0 |
| 2022-07-05 | FGBM | Futures | 126.39 | 127.5 | 126.1 | 127.46 | 585406.0 |
| 2022-07-05 | FGBS | Futures | 111.075 | 111.491 | 110.993 | 111.481 | 587462.0 |
| 2022-07-05 | FGBX | Futures | 166.66 | 172.05 | 165.82 | 171.17 | 69650.0 |
| 2022-07-05 | FMWO | Futures | 9191.4 | 9241.7 | 8977.1 | 8986.5 | 6551.0 |
| 2022-07-05 | FOAT | Futures | 135.09 | 136.86 | 134.76 | 136.63 | 183305.0 |
| 2022-07-05 | FSMX | Futures | 27599.3 | 27605.7 | 26211.6 | 26381.6 | 645.0 |
| 2022-07-05 | FTDX | Futures | 3116.9 | 3116.9 | 3012.5 | 3041.9 | 193.0 |
| 2022-07-05 | FTI | Futures | 659.86 | 661.9 | 640.34 | 641.31 | 24323.0 |
| 2022-07-05 | FTUK | Futures | 7299.7 | 7325.6 | 7049.3 | 7057.9 | 127138.0 |
| 2022-07-05 | FVSA | Futures | 82.09 | 89.16 | 81.23 | 89.02 | 42776.0 |
> showing 50 of 127 rows — these rows as CSV