PREVIEW / futures_daily / 2022-11-18
file: by_date/futures_daily/2022/2022-11-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-11-18 | ES | Futures | 4414.29 | 4451.62 | 4394.22 | 4429.33 | 1534155.0 |
| 2022-11-18 | NQ | Futures | 13313.14 | 13421.08 | 13153.63 | 13268.09 | 585873.0 |
| 2022-11-18 | YM | Futures | 36541.3 | 36839.4 | 36419.4 | 36752.4 | 162980.0 |
| 2022-11-18 | CL | Futures | 71.31 | 71.81 | 67.59 | 69.79 | 480539.0 |
| 2022-11-18 | GC | Futures | 2017.7 | 2025.5 | 2001.8 | 2007.7 | 137327.0 |
| 2022-11-18 | ZN | Futures | 115.866083 | 116.042904 | 115.432068 | 115.528516 | 1127239.0 |
| 2022-11-18 | A6 | Futures | 0.68455 | 0.68895 | 0.68184 | 0.68332 | 70037.0 |
| 2022-11-18 | AD | Futures | 0.76122 | 0.7627 | 0.75641 | 0.75798 | 61920.0 |
| 2022-11-18 | ALI | Futures | 2734.07 | 2768.37 | 2709.98 | 2762.7 | 588.0 |
| 2022-11-18 | B | Futures | 78.84 | 79.3 | 75.07 | 76.67 | 379661.0 |
| 2022-11-18 | B6 | Futures | 1.1989 | 1.2074 | 1.1979 | 1.2013 | 78330.0 |
| 2022-11-18 | BR | Futures | 0.16116 | 0.16463 | 0.16116 | 0.16314 | 14652.0 |
| 2022-11-18 | BTC | Futures | 22687.2 | 23146.6 | 22440.4 | 22666.7 | 6052.0 |
| 2022-11-18 | BZ | Futures | 77.19 | 77.73 | 73.6 | 75.17 | 34614.0 |
| 2022-11-18 | C | Futures | 1432.0 | 1447.0 | 1421.0 | 1446.0 | 4945.0 |
| 2022-11-18 | CB | Futures | 244.528 | 244.528 | 243.159 | 243.159 | 12.0 |
| 2022-11-18 | CC | Futures | 1436.0 | 1443.0 | 1419.0 | 1433.0 | 29250.0 |
| 2022-11-18 | CNH | Futures | 6.7371 | 6.7463 | 6.7078 | 6.7165 | 636.0 |
| 2022-11-18 | CSC | Futures | 2.706 | 2.715 | 2.687 | 2.69 | 168.0 |
| 2022-11-18 | CT | Futures | 112.72 | 112.84 | 109.02 | 110.29 | 8735.0 |
| 2022-11-18 | DC | Futures | 26.26 | 26.26 | 25.92 | 25.96 | 368.0 |
| 2022-11-18 | DX | Futures | 103.321 | 103.743 | 103.073 | 103.651 | 27109.0 |
| 2022-11-18 | E1 | Futures | 1.15475 | 1.15749 | 1.1513 | 1.15294 | 11893.0 |
| 2022-11-18 | E6 | Futures | 1.08103 | 1.08415 | 1.07557 | 1.07708 | 148836.0 |
| 2022-11-18 | E7 | Futures | 1.0791 | 1.0823 | 1.0738 | 1.0753 | 5918.0 |
| 2022-11-18 | EBM | Futures | 462.45 | 469.54 | 461.74 | 462.1 | 17772.0 |
| 2022-11-18 | ED | Futures | 94.1416 | 94.1515 | 94.1267 | 94.1466 | 117318.0 |
| 2022-11-18 | ER | Futures | 97.766 | 97.796 | 97.751 | 97.791 | 138191.0 |
| 2022-11-18 | ESG | Futures | 380.99 | 383.49 | 379.21 | 382.06 | 275.0 |
| 2022-11-18 | EW | Futures | 2704.4 | 2735.4 | 2693.3 | 2719.9 | 8783.0 |
| 2022-11-18 | FBON | Futures | 124.93 | 125.19 | 123.99 | 125.17 | 128.0 |
| 2022-11-18 | FBTP | Futures | 112.27 | 112.7 | 110.95 | 112.61 | 112832.0 |
| 2022-11-18 | FBTS | Futures | 106.547 | 106.677 | 106.278 | 106.647 | 94224.0 |
| 2022-11-18 | FCE | Futures | 7183.6 | 7243.9 | 7173.2 | 7221.1 | 58272.0 |
| 2022-11-18 | FDAX | Futures | 15642.0 | 15800.3 | 15625.6 | 15770.8 | 66440.0 |
| 2022-11-18 | FDXM | Futures | 15417.0 | 15569.7 | 15392.3 | 15536.4 | 44898.0 |
| 2022-11-18 | FDXS | Futures | 15354.3 | 15489.1 | 15314.7 | 15459.1 | 24936.0 |
| 2022-11-18 | FESX | Futures | 3851.6 | 3895.1 | 3847.6 | 3882.3 | 1115215.0 |
| 2022-11-18 | FGBL | Futures | 139.8 | 140.29 | 138.96 | 139.97 | 531378.0 |
| 2022-11-18 | FGBM | Futures | 121.53 | 121.8 | 121.12 | 121.66 | 405454.0 |
| 2022-11-18 | FGBS | Futures | 109.014 | 109.167 | 108.896 | 109.111 | 435199.0 |
| 2022-11-18 | FGBX | Futures | 155.33 | 156.49 | 153.2 | 155.64 | 40093.0 |
| 2022-11-18 | FMWO | Futures | 9458.1 | 9541.8 | 9426.8 | 9487.2 | 6020.0 |
| 2022-11-18 | FOAT | Futures | 130.36 | 130.92 | 129.57 | 130.67 | 102333.0 |
| 2022-11-18 | FSMX | Futures | 26856.8 | 27282.9 | 26856.8 | 27241.7 | 420.0 |
| 2022-11-18 | FTDX | Futures | 3282.4 | 3307.5 | 3282.4 | 3303.2 | 20.0 |
| 2022-11-18 | FTI | Futures | 729.07 | 735.07 | 725.9 | 730.59 | 22223.0 |
| 2022-11-18 | FTUK | Futures | 7445.3 | 7496.8 | 7420.1 | 7454.9 | 102998.0 |
| 2022-11-18 | FVSA | Futures | 50.43 | 50.54 | 48.88 | 49.32 | 17747.0 |
| 2022-11-18 | FXXP | Futures | 425.5 | 429.8 | 424.9 | 428.5 | 90374.0 |
> showing 50 of 126 rows — these rows as CSV