PREVIEW / futures_daily / 2022-11-07
file: by_date/futures_daily/2022/2022-11-07.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-07 | ES | Futures | 4179.67 | 4259.64 | 4166.57 | 4252.39 | 1483146.0 |
| 2022-11-07 | NQ | Futures | 12223.8 | 12509.38 | 12183.57 | 12481.9 | 554692.0 |
| 2022-11-07 | YM | Futures | 35116.9 | 35804.6 | 34943.9 | 35732.8 | 184169.0 |
| 2022-11-07 | CL | Futures | 78.63 | 81.0 | 78.11 | 79.32 | 322419.0 |
| 2022-11-07 | GC | Futures | 1921.0 | 1929.0 | 1911.2 | 1923.2 | 187589.0 |
| 2022-11-07 | ZN | Futures | 113.26199 | 113.358438 | 112.731526 | 112.795825 | 1045572.0 |
| 2022-11-07 | A6 | Futures | 0.65765 | 0.66471 | 0.65612 | 0.66328 | 98145.0 |
| 2022-11-07 | AD | Futures | 0.75007 | 0.75347 | 0.74855 | 0.75184 | 77215.0 |
| 2022-11-07 | ALI | Futures | 2625.1 | 2677.39 | 2609.55 | 2652.52 | 1879.0 |
| 2022-11-07 | B | Futures | 85.15 | 87.11 | 84.44 | 85.68 | 241941.0 |
| 2022-11-07 | B6 | Futures | 1.1449 | 1.1665 | 1.1411 | 1.1656 | 138567.0 |
| 2022-11-07 | BR | Futures | 0.17321 | 0.17541 | 0.1693 | 0.17123 | 15996.0 |
| 2022-11-07 | BTC | Futures | 29070.4 | 29090.9 | 28295.6 | 28583.6 | 6250.0 |
| 2022-11-07 | BZ | Futures | 83.88 | 85.41 | 82.96 | 84.0 | 22568.0 |
| 2022-11-07 | C | Futures | 1456.0 | 1481.0 | 1453.0 | 1470.0 | 8734.0 |
| 2022-11-07 | CB | Futures | 237.206 | 237.229 | 231.777 | 237.229 | 42.0 |
| 2022-11-07 | CC | Futures | 1418.0 | 1462.0 | 1418.0 | 1451.0 | 79549.0 |
| 2022-11-07 | CNH | Futures | 6.803 | 6.8378 | 6.7718 | 6.8152 | 1988.0 |
| 2022-11-07 | CSC | Futures | 2.557 | 2.562 | 2.535 | 2.55 | 276.0 |
| 2022-11-07 | CT | Futures | 111.67 | 114.29 | 109.89 | 113.31 | 33512.0 |
| 2022-11-07 | DC | Futures | 24.73 | 24.97 | 24.57 | 24.75 | 894.0 |
| 2022-11-07 | DX | Futures | 107.701 | 107.866 | 106.654 | 106.724 | 34386.0 |
| 2022-11-07 | E1 | Futures | 1.10532 | 1.11496 | 1.10351 | 1.11453 | 18530.0 |
| 2022-11-07 | E6 | Futures | 1.03665 | 1.04737 | 1.03524 | 1.04653 | 179917.0 |
| 2022-11-07 | E7 | Futures | 1.0353 | 1.0456 | 1.0335 | 1.0448 | 6460.0 |
| 2022-11-07 | EBM | Futures | 478.41 | 482.67 | 475.57 | 476.64 | 21528.0 |
| 2022-11-07 | ED | Futures | 94.0277 | 94.0326 | 93.988 | 94.0128 | 98643.0 |
| 2022-11-07 | ER | Futures | 97.676 | 97.681 | 97.656 | 97.661 | 112392.0 |
| 2022-11-07 | ESG | Futures | 362.92 | 366.76 | 362.09 | 366.32 | 363.0 |
| 2022-11-07 | EW | Futures | 2585.6 | 2634.6 | 2584.7 | 2630.2 | 9340.0 |
| 2022-11-07 | FBON | Futures | 121.25 | 121.6 | 120.76 | 121.12 | 74.0 |
| 2022-11-07 | FBTP | Futures | 107.31 | 107.52 | 106.43 | 106.95 | 87211.0 |
| 2022-11-07 | FBTS | Futures | 105.709 | 105.739 | 105.549 | 105.609 | 70438.0 |
| 2022-11-07 | FCE | Futures | 6993.2 | 7030.8 | 6943.5 | 7001.3 | 56936.0 |
| 2022-11-07 | FDAX | Futures | 14668.3 | 14881.1 | 14633.3 | 14796.0 | 58989.0 |
| 2022-11-07 | FDXM | Futures | 14458.8 | 14659.9 | 14415.8 | 14576.0 | 50348.0 |
| 2022-11-07 | FDXS | Futures | 14388.0 | 14587.0 | 14344.1 | 14503.6 | 19787.0 |
| 2022-11-07 | FESX | Futures | 3637.8 | 3680.4 | 3627.0 | 3669.5 | 783189.0 |
| 2022-11-07 | FGBL | Futures | 136.62 | 136.95 | 135.87 | 136.24 | 545086.0 |
| 2022-11-07 | FGBM | Futures | 120.62 | 120.74 | 120.17 | 120.37 | 382278.0 |
| 2022-11-07 | FGBS | Futures | 108.886 | 108.937 | 108.733 | 108.794 | 334200.0 |
| 2022-11-07 | FGBX | Futures | 145.43 | 146.7 | 143.65 | 144.61 | 48246.0 |
| 2022-11-07 | FMWO | Futures | 8930.8 | 9060.9 | 8922.7 | 9019.1 | 3101.0 |
| 2022-11-07 | FOAT | Futures | 126.73 | 127.04 | 125.96 | 126.4 | 104666.0 |
| 2022-11-07 | FSMX | Futures | 25270.8 | 25592.2 | 25141.8 | 25496.0 | 396.0 |
| 2022-11-07 | FTDX | Futures | 3010.4 | 3054.0 | 3010.4 | 3042.3 | 255.0 |
| 2022-11-07 | FTI | Futures | 682.86 | 688.1 | 678.64 | 686.32 | 16825.0 |
| 2022-11-07 | FTUK | Futures | 7375.7 | 7410.0 | 7315.7 | 7363.1 | 104735.0 |
| 2022-11-07 | FVSA | Futures | 55.54 | 55.66 | 52.76 | 53.46 | 29526.0 |
| 2022-11-07 | FXXP | Futures | 410.2 | 414.9 | 409.8 | 413.5 | 58797.0 |
> showing 50 of 126 rows — these rows as CSV