PREVIEW / futures_daily / 2022-08-02
file: by_date/futures_daily/2022/2022-08-02.parquet size: 10 KB rows: 125
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-08-02 | ES | Futures | 4621.57 | 4647.65 | 4577.54 | 4592.4 | 1892241.0 |
| 2022-08-02 | NQ | Futures | 14814.84 | 14955.0 | 14632.71 | 14758.03 | 674564.0 |
| 2022-08-02 | YM | Futures | 35825.1 | 35841.5 | 35370.3 | 35386.7 | 228064.0 |
| 2022-08-02 | CL | Futures | 79.49 | 81.79 | 78.5 | 80.05 | 328538.0 |
| 2022-08-02 | GC | Futures | 2047.6 | 2065.6 | 2032.5 | 2048.1 | 174165.0 |
| 2022-08-02 | ZN | Futures | 125.041699 | 125.507613 | 123.370835 | 123.515429 | 1984438.0 |
| 2022-08-02 | A6 | Futures | 0.72048 | 0.72094 | 0.7086 | 0.70988 | 115164.0 |
| 2022-08-02 | AD | Futures | 0.78988 | 0.79013 | 0.78689 | 0.78871 | 78913.0 |
| 2022-08-02 | ALI | Futures | 2731.16 | 2746.63 | 2695.73 | 2703.32 | 1414.0 |
| 2022-08-02 | B | Futures | 84.67 | 86.83 | 83.5 | 85.24 | 229684.0 |
| 2022-08-02 | B6 | Futures | 1.2444 | 1.2471 | 1.2348 | 1.2358 | 94709.0 |
| 2022-08-02 | BR | Futures | 0.16578 | 0.16691 | 0.16317 | 0.16348 | 9505.0 |
| 2022-08-02 | BTC | Futures | 31847.4 | 32482.9 | 31343.0 | 31778.3 | 5487.0 |
| 2022-08-02 | BZ | Futures | 82.95 | 84.95 | 81.69 | 83.4 | 17357.0 |
| 2022-08-02 | C | Futures | 1285.0 | 1304.0 | 1284.0 | 1299.0 | 6171.0 |
| 2022-08-02 | CB | Futures | 227.635 | 232.47 | 227.635 | 231.664 | 16.0 |
| 2022-08-02 | CC | Futures | 1398.0 | 1417.0 | 1389.0 | 1399.0 | 23060.0 |
| 2022-08-02 | CNH | Futures | 6.3964 | 6.4055 | 6.3632 | 6.3755 | 1336.0 |
| 2022-08-02 | CSC | Futures | 2.748 | 2.751 | 2.705 | 2.744 | 73.0 |
| 2022-08-02 | CT | Futures | 126.54 | 129.78 | 124.24 | 127.88 | 14.0 |
| 2022-08-02 | DC | Futures | 26.28 | 26.41 | 25.95 | 26.28 | 342.0 |
| 2022-08-02 | DX | Futures | 101.53 | 102.447 | 101.212 | 102.354 | 38603.0 |
| 2022-08-02 | E1 | Futures | 1.16794 | 1.1728 | 1.15881 | 1.15948 | 28535.0 |
| 2022-08-02 | E6 | Futures | 1.0824 | 1.08629 | 1.07246 | 1.07346 | 201639.0 |
| 2022-08-02 | E7 | Futures | 1.076 | 1.0797 | 1.066 | 1.067 | 8617.0 |
| 2022-08-02 | EBM | Futures | 467.26 | 476.72 | 466.21 | 475.32 | 12098.0 |
| 2022-08-02 | ED | Futures | 95.0447 | 95.0545 | 94.966 | 94.9759 | 122729.0 |
| 2022-08-02 | ER | Futures | 98.262 | 98.307 | 98.213 | 98.258 | 93370.0 |
| 2022-08-02 | ESG | Futures | 395.58 | 399.7 | 394.23 | 395.14 | 431.0 |
| 2022-08-02 | EW | Futures | 2735.4 | 2739.8 | 2701.4 | 2710.0 | 10345.0 |
| 2022-08-02 | FBON | Futures | 136.45 | 137.59 | 134.97 | 135.21 | 235.0 |
| 2022-08-02 | FBTP | Futures | 119.58 | 120.3 | 118.43 | 118.62 | 102194.0 |
| 2022-08-02 | FBTS | Futures | 108.28 | 108.418 | 107.906 | 107.955 | 77095.0 |
| 2022-08-02 | FCE | Futures | 7041.8 | 7062.7 | 7002.3 | 7035.2 | 47069.0 |
| 2022-08-02 | FDAX | Futures | 14473.1 | 14529.0 | 14338.6 | 14469.9 | 52144.0 |
| 2022-08-02 | FDXM | Futures | 14562.6 | 14618.9 | 14427.3 | 14558.3 | 32133.0 |
| 2022-08-02 | FDXS | Futures | 14449.3 | 14499.8 | 14309.7 | 14439.7 | 22225.0 |
| 2022-08-02 | FESX | Futures | 3663.9 | 3669.8 | 3629.2 | 3655.9 | 684006.0 |
| 2022-08-02 | FGBL | Futures | 156.49 | 157.61 | 155.04 | 156.03 | 680972.0 |
| 2022-08-02 | FGBM | Futures | 130.14 | 130.66 | 129.45 | 129.88 | 457597.0 |
| 2022-08-02 | FGBS | Futures | 112.035 | 112.193 | 111.776 | 111.934 | 610349.0 |
| 2022-08-02 | FGBX | Futures | 191.68 | 194.56 | 189.62 | 191.99 | 67457.0 |
| 2022-08-02 | FMWO | Futures | 9792.0 | 9849.4 | 9737.0 | 9809.6 | 4549.0 |
| 2022-08-02 | FOAT | Futures | 143.09 | 144.05 | 141.7 | 142.44 | 170512.0 |
| 2022-08-02 | FSMX | Futures | 29028.8 | 29342.1 | 28976.4 | 29276.8 | 31.0 |
| 2022-08-02 | FTDX | Futures | 3326.7 | 3349.1 | 3311.1 | 3340.6 | 67.0 |
| 2022-08-02 | FTI | Futures | 730.53 | 735.55 | 726.43 | 731.44 | 17136.0 |
| 2022-08-02 | FTUK | Futures | 7451.3 | 7485.3 | 7425.4 | 7471.6 | 76862.0 |
| 2022-08-02 | FVSA | Futures | 70.27 | 72.08 | 68.17 | 69.85 | 23281.0 |
| 2022-08-02 | FXXP | Futures | 429.5 | 432.1 | 427.7 | 430.5 | 68534.0 |
> showing 50 of 125 rows — these rows as CSV