PREVIEW / futures_daily / 2022-08-31
file: by_date/futures_daily/2022/2022-08-31.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-08-31 | ES | Futures | 4472.93 | 4507.7 | 4434.5 | 4438.43 | 2366488.0 |
| 2022-08-31 | NQ | Futures | 14120.3 | 14288.15 | 14017.82 | 14028.09 | 672068.0 |
| 2022-08-31 | YM | Futures | 34760.2 | 34989.8 | 34442.0 | 34475.9 | 194244.0 |
| 2022-08-31 | CL | Futures | 78.94 | 79.3 | 75.49 | 76.58 | 344147.0 |
| 2022-08-31 | GC | Futures | 1986.1 | 1989.0 | 1969.1 | 1975.5 | 176731.0 |
| 2022-08-31 | ZN | Futures | 120.334361 | 120.478955 | 119.659588 | 120.173701 | 143296.0 |
| 2022-08-31 | A6 | Futures | 0.70235 | 0.70742 | 0.7003 | 0.70153 | 109741.0 |
| 2022-08-31 | AD | Futures | 0.77456 | 0.77624 | 0.77172 | 0.77284 | 98273.0 |
| 2022-08-31 | ALI | Futures | 2721.17 | 2738.7 | 2653.89 | 2672.83 | 229.0 |
| 2022-08-31 | B | Futures | 83.72 | 84.3 | 80.38 | 81.43 | 290425.0 |
| 2022-08-31 | B6 | Futures | 1.1828 | 1.1867 | 1.1771 | 1.1788 | 126888.0 |
| 2022-08-31 | BFX | Futures | 3958.3 | 3967.7 | 3958.3 | 3967.7 | 10.0 |
| 2022-08-31 | BR | Futures | 0.16547 | 0.16547 | 0.16547 | 0.16547 | 746.0 |
| 2022-08-31 | BTC | Futures | 27293.7 | 28199.1 | 27072.5 | 27736.0 | 7256.0 |
| 2022-08-31 | BZ | Futures | 81.86 | 82.36 | 78.52 | 79.57 | 24672.0 |
| 2022-08-31 | C | Futures | 1345.0 | 1356.0 | 1345.0 | 1349.0 | 12399.0 |
| 2022-08-31 | CB | Futures | 243.616 | 243.981 | 242.703 | 243.616 | 25.0 |
| 2022-08-31 | CC | Futures | 1411.0 | 1426.0 | 1399.0 | 1413.0 | 21599.0 |
| 2022-08-31 | CNH | Futures | 6.529 | 6.5292 | 6.5004 | 6.5095 | 642.0 |
| 2022-08-31 | CSC | Futures | 2.601 | 2.609 | 2.584 | 2.584 | 20.0 |
| 2022-08-31 | CT | Futures | 151.01 | 151.01 | 148.47 | 149.97 | 12.0 |
| 2022-08-31 | DC | Futures | 25.51 | 25.51 | 25.22 | 25.22 | 47.0 |
| 2022-08-31 | DX | Futures | 104.887 | 105.312 | 104.506 | 104.824 | 27077.0 |
| 2022-08-31 | E1 | Futures | 1.13637 | 1.13841 | 1.12907 | 1.13416 | 31941.0 |
| 2022-08-31 | E6 | Futures | 1.05484 | 1.06136 | 1.05 | 1.05773 | 270752.0 |
| 2022-08-31 | E7 | Futures | 1.0485 | 1.0549 | 1.0436 | 1.0514 | 8832.0 |
| 2022-08-31 | EBM | Futures | 463.05 | 467.61 | 459.2 | 465.86 | 2240.0 |
| 2022-08-31 | ED | Futures | 94.9415 | 94.9587 | 94.9243 | 94.9587 | 96468.0 |
| 2022-08-31 | ER | Futures | 98.01 | 98.045 | 97.981 | 98.0 | 195141.0 |
| 2022-08-31 | ESG | Futures | 384.94 | 387.84 | 379.31 | 381.88 | 722.0 |
| 2022-08-31 | EW | Futures | 2664.9 | 2685.5 | 2642.3 | 2646.5 | 12120.0 |
| 2022-08-31 | FBON | Futures | 126.5 | 127.07 | 125.49 | 125.76 | 586.0 |
| 2022-08-31 | FBTP | Futures | 112.13 | 112.57 | 110.66 | 111.21 | 170854.0 |
| 2022-08-31 | FBTS | Futures | 106.449 | 106.508 | 106.065 | 106.262 | 159235.0 |
| 2022-08-31 | FCE | Futures | 6842.3 | 6865.9 | 6697.8 | 6728.0 | 67087.0 |
| 2022-08-31 | FDAX | Futures | 13924.2 | 14043.7 | 13768.2 | 13825.2 | 75978.0 |
| 2022-08-31 | FDXM | Futures | 14005.0 | 14132.8 | 13853.4 | 13909.7 | 38656.0 |
| 2022-08-31 | FDXS | Futures | 13884.5 | 14014.4 | 13740.6 | 13796.4 | 35319.0 |
| 2022-08-31 | FESX | Futures | 3522.0 | 3559.7 | 3472.4 | 3492.2 | 1095809.0 |
| 2022-08-31 | FGBL | Futures | 146.54 | 147.04 | 145.45 | 146.03 | 1071503.0 |
| 2022-08-31 | FGBM | Futures | 125.2 | 125.49 | 124.68 | 124.9 | 731192.0 |
| 2022-08-31 | FGBS | Futures | 110.505 | 110.602 | 110.343 | 110.394 | 807328.0 |
| 2022-08-31 | FGBX | Futures | 169.29 | 170.27 | 166.41 | 167.98 | 145633.0 |
| 2022-08-31 | FMWO | Futures | 9507.5 | 9519.2 | 9376.4 | 9439.6 | 5717.0 |
| 2022-08-31 | FOAT | Futures | 134.66 | 135.1 | 133.72 | 134.29 | 327522.0 |
| 2022-08-31 | FSMX | Futures | 27081.9 | 27172.7 | 26921.5 | 26999.5 | 239.0 |
| 2022-08-31 | FTDX | Futures | 3158.1 | 3158.1 | 3126.5 | 3126.5 | 100.0 |
| 2022-08-31 | FTI | Futures | 704.63 | 708.85 | 689.48 | 691.53 | 27161.0 |
| 2022-08-31 | FTUK | Futures | 7434.1 | 7494.4 | 7361.1 | 7387.9 | 152344.0 |
| 2022-08-31 | FVSA | Futures | 69.02 | 70.5 | 67.28 | 68.64 | 26709.0 |
> showing 50 of 127 rows — these rows as CSV