PREVIEW / futures_daily / 2022-07-14
file: by_date/futures_daily/2022/2022-07-14.parquet size: 10 KB rows: 129
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-14 | ES | Futures | 4258.1 | 4269.88 | 4177.33 | 4255.3 | 1916260.0 |
| 2022-07-14 | NQ | Futures | 13393.5 | 13513.97 | 13144.29 | 13471.15 | 654560.0 |
| 2022-07-14 | YM | Futures | 33566.3 | 33647.2 | 32920.1 | 33461.3 | 172967.0 |
| 2022-07-14 | CL | Futures | 79.82 | 80.11 | 74.81 | 78.71 | 255519.0 |
| 2022-07-14 | GC | Futures | 2003.3 | 2004.7 | 1958.7 | 1971.2 | 266354.0 |
| 2022-07-14 | ZN | Futures | 122.133753 | 122.294413 | 121.217991 | 121.844565 | 1657510.0 |
| 2022-07-14 | A6 | Futures | 0.69287 | 0.69595 | 0.68498 | 0.69277 | 131475.0 |
| 2022-07-14 | AD | Futures | 0.78161 | 0.78181 | 0.7669 | 0.77375 | 161623.0 |
| 2022-07-14 | ALI | Futures | 2661.71 | 2665.38 | 2633.98 | 2643.04 | 191.0 |
| 2022-07-14 | B | Futures | 79.97 | 80.74 | 76.01 | 79.71 | 318794.0 |
| 2022-07-14 | B6 | Futures | 1.2084 | 1.2085 | 1.195 | 1.2021 | 138400.0 |
| 2022-07-14 | BFX | Futures | 4273.8 | 4273.8 | 4226.8 | 4226.8 | 11.0 |
| 2022-07-14 | BR | Futures | 0.15787 | 0.15809 | 0.15574 | 0.15778 | 334.0 |
| 2022-07-14 | BTC | Futures | 27724.3 | 29111.2 | 27299.2 | 28748.8 | 10781.0 |
| 2022-07-14 | BZ | Futures | 78.42 | 78.83 | 74.22 | 77.83 | 27515.0 |
| 2022-07-14 | C | Futures | 1287.0 | 1309.0 | 1260.0 | 1262.0 | 11456.0 |
| 2022-07-14 | CB | Futures | 218.772 | 221.209 | 214.783 | 215.146 | 33.0 |
| 2022-07-14 | CC | Futures | 1376.0 | 1378.0 | 1337.0 | 1343.0 | 38248.0 |
| 2022-07-14 | CNH | Futures | 6.3414 | 6.3977 | 6.3385 | 6.3658 | 1090.0 |
| 2022-07-14 | CSC | Futures | 2.839 | 2.839 | 2.748 | 2.802 | 104.0 |
| 2022-07-14 | CT | Futures | 120.68 | 120.69 | 115.89 | 115.89 | 57.0 |
| 2022-07-14 | DC | Futures | 27.22 | 27.56 | 25.95 | 26.36 | 323.0 |
| 2022-07-14 | DX | Futures | 104.25 | 105.283 | 104.197 | 104.576 | 42040.0 |
| 2022-07-14 | E1 | Futures | 1.13487 | 1.13537 | 1.12398 | 1.13023 | 28747.0 |
| 2022-07-14 | E6 | Futures | 1.0631 | 1.06325 | 1.05184 | 1.05994 | 301539.0 |
| 2022-07-14 | E7 | Futures | 1.0568 | 1.0568 | 1.0455 | 1.0536 | 11427.0 |
| 2022-07-14 | EBM | Futures | 481.28 | 490.04 | 470.41 | 480.58 | 17872.0 |
| 2022-07-14 | ED | Futures | 94.7056 | 94.8481 | 94.6466 | 94.8088 | 293370.0 |
| 2022-07-14 | ER | Futures | 98.173 | 98.208 | 98.104 | 98.159 | 155373.0 |
| 2022-07-14 | ESG | Futures | 364.4 | 368.62 | 361.21 | 368.07 | 466.0 |
| 2022-07-14 | EW | Futures | 2478.1 | 2482.7 | 2425.9 | 2461.3 | 10442.0 |
| 2022-07-14 | FBON | Futures | 129.3 | 129.3 | 127.88 | 128.65 | 266.0 |
| 2022-07-14 | FBTP | Futures | 115.61 | 115.8 | 113.49 | 114.67 | 249331.0 |
| 2022-07-14 | FBTS | Futures | 107.365 | 107.365 | 106.538 | 106.941 | 143635.0 |
| 2022-07-14 | FCE | Futures | 6583.5 | 6595.1 | 6443.0 | 6488.6 | 52117.0 |
| 2022-07-14 | FDAX | Futures | 13677.8 | 13771.4 | 13363.6 | 13461.5 | 79047.0 |
| 2022-07-14 | FDIV | Futures | 148.1 | 149.29 | 148.1 | 149.04 | 70.0 |
| 2022-07-14 | FDXM | Futures | 13764.6 | 13853.4 | 13445.2 | 13543.8 | 50862.0 |
| 2022-07-14 | FDXS | Futures | 13660.0 | 13740.6 | 13336.8 | 13433.4 | 31124.0 |
| 2022-07-14 | FESX | Futures | 3404.9 | 3434.7 | 3335.5 | 3363.3 | 1105785.0 |
| 2022-07-14 | FGBL | Futures | 150.98 | 151.01 | 149.23 | 150.18 | 785110.0 |
| 2022-07-14 | FGBM | Futures | 127.74 | 127.82 | 126.76 | 127.43 | 560830.0 |
| 2022-07-14 | FGBS | Futures | 111.41 | 111.481 | 111.064 | 111.324 | 599215.0 |
| 2022-07-14 | FGBX | Futures | 177.01 | 177.76 | 174.52 | 176.45 | 78775.0 |
| 2022-07-14 | FMWO | Futures | 9075.5 | 9075.5 | 8890.5 | 8967.7 | 10271.0 |
| 2022-07-14 | FOAT | Futures | 138.38 | 138.41 | 136.85 | 137.54 | 170918.0 |
| 2022-07-14 | FSMX | Futures | 27229.4 | 27259.3 | 26566.5 | 26711.9 | 189.0 |
| 2022-07-14 | FTDX | Futures | 3121.1 | 3131.8 | 3066.6 | 3074.6 | 43.0 |
| 2022-07-14 | FTI | Futures | 673.59 | 673.59 | 659.2 | 664.52 | 15032.0 |
| 2022-07-14 | FTUK | Futures | 7194.8 | 7235.4 | 7051.4 | 7101.5 | 129013.0 |
> showing 50 of 129 rows — these rows as CSV