PREVIEW / futures_daily / 2021-06-09
file: by_date/futures_daily/2021/2021-06-09.parquet size: 10 KB rows: 123
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-09 | ES | Futures | 4741.66 | 4752.32 | 4732.12 | 4733.81 | 1057216.0 |
| 2021-06-09 | NQ | Futures | 15932.18 | 16037.43 | 15921.22 | 15933.62 | 376893.0 |
| 2021-06-09 | YM | Futures | 37433.7 | 37499.7 | 37259.4 | 37272.4 | 117432.0 |
| 2021-06-09 | CL | Futures | 49.83 | 50.27 | 49.44 | 49.8 | 410820.0 |
| 2021-06-09 | GC | Futures | 2215.7 | 2224.3 | 2209.8 | 2217.0 | 147332.0 |
| 2021-06-09 | ZN | Futures | 133.994015 | 134.515884 | 133.962386 | 134.373556 | 1803146.0 |
| 2021-06-09 | A6 | Futures | 0.79336 | 0.79592 | 0.79197 | 0.79326 | 151479.0 |
| 2021-06-09 | AD | Futures | 0.83649 | 0.84024 | 0.83608 | 0.83694 | 126272.0 |
| 2021-06-09 | ALI | Futures | 2784.93 | 2796.21 | 2784.37 | 2791.7 | 454.0 |
| 2021-06-09 | B | Futures | 47.19 | 47.65 | 46.96 | 47.22 | 266374.0 |
| 2021-06-09 | B6 | Futures | 1.4368 | 1.4408 | 1.4328 | 1.4334 | 148086.0 |
| 2021-06-09 | BFX | Futures | 4209.2 | 4240.4 | 4209.2 | 4240.4 | 11.0 |
| 2021-06-09 | BR | Futures | 0.15743 | 0.15743 | 0.15619 | 0.15675 | 2571.0 |
| 2021-06-09 | BTC | Futures | 48515.0 | 53528.1 | 46972.0 | 52702.2 | 8450.0 |
| 2021-06-09 | BZ | Futures | 46.05 | 46.53 | 45.85 | 46.1 | 31013.0 |
| 2021-06-09 | C | Futures | 1445.0 | 1451.0 | 1440.0 | 1443.0 | 3727.0 |
| 2021-06-09 | CB | Futures | 148.688 | 150.032 | 148.688 | 150.032 | 29.0 |
| 2021-06-09 | CC | Futures | 1588.0 | 1596.0 | 1565.0 | 1569.0 | 23800.0 |
| 2021-06-09 | CNH | Futures | 6.2031 | 6.2098 | 6.1888 | 6.1896 | 1404.0 |
| 2021-06-09 | CSC | Futures | 2.661 | 2.665 | 2.659 | 2.661 | 35.0 |
| 2021-06-09 | CT | Futures | 80.06 | 80.91 | 79.46 | 80.77 | 13239.0 |
| 2021-06-09 | DC | Futures | 24.51 | 24.59 | 24.33 | 24.59 | 88.0 |
| 2021-06-09 | DX | Futures | 87.103 | 87.137 | 86.808 | 87.089 | 25269.0 |
| 2021-06-09 | E1 | Futures | 1.2548 | 1.26099 | 1.25446 | 1.25637 | 34587.0 |
| 2021-06-09 | E6 | Futures | 1.29721 | 1.30206 | 1.297 | 1.29791 | 437114.0 |
| 2021-06-09 | E7 | Futures | 1.2907 | 1.2955 | 1.2906 | 1.2914 | 12385.0 |
| 2021-06-09 | EBM | Futures | 316.29 | 316.29 | 311.14 | 312.61 | 18779.0 |
| 2021-06-09 | ED | Futures | 96.5536 | 96.556 | 96.5512 | 96.5536 | 113238.0 |
| 2021-06-09 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.46 | 27348.0 |
| 2021-06-09 | ESG | Futures | 393.13 | 393.27 | 391.81 | 391.81 | 952.0 |
| 2021-06-09 | EW | Futures | 2940.1 | 2946.1 | 2921.0 | 2921.8 | 9665.0 |
| 2021-06-09 | FBON | Futures | 147.92 | 148.47 | 147.81 | 148.28 | 704.0 |
| 2021-06-09 | FBTP | Futures | 137.96 | 138.68 | 137.88 | 138.35 | 149460.0 |
| 2021-06-09 | FBTS | Futures | 110.224 | 110.273 | 110.205 | 110.224 | 98860.0 |
| 2021-06-09 | FCE | Futures | 6539.0 | 6549.0 | 6510.1 | 6541.5 | 41293.0 |
| 2021-06-09 | FDAX | Futures | 16694.4 | 16713.6 | 16523.8 | 16620.8 | 54259.0 |
| 2021-06-09 | FDIV | Futures | 189.41 | 189.61 | 189.41 | 189.61 | 10.0 |
| 2021-06-09 | FDXM | Futures | 16674.1 | 16694.3 | 16503.7 | 16600.6 | 49539.0 |
| 2021-06-09 | FDXS | Futures | 16603.2 | 16603.2 | 16415.7 | 16512.1 | 3578.0 |
| 2021-06-09 | FESX | Futures | 3879.2 | 3883.9 | 3852.8 | 3875.4 | 711001.0 |
| 2021-06-09 | FGBL | Futures | 166.72 | 167.44 | 166.69 | 167.16 | 716062.0 |
| 2021-06-09 | FGBM | Futures | 134.66 | 134.9 | 134.66 | 134.81 | 424482.0 |
| 2021-06-09 | FGBS | Futures | 112.589 | 112.619 | 112.584 | 112.609 | 313756.0 |
| 2021-06-09 | FGBX | Futures | 215.39 | 217.49 | 215.26 | 216.53 | 84537.0 |
| 2021-06-09 | FMWO | Futures | 10571.8 | 10590.6 | 10555.4 | 10582.4 | 15672.0 |
| 2021-06-09 | FOAT | Futures | 154.78 | 155.4 | 154.74 | 155.17 | 186198.0 |
| 2021-06-09 | FTDX | Futures | 3490.5 | 3508.5 | 3490.5 | 3508.5 | 22.0 |
| 2021-06-09 | FTI | Futures | 686.03 | 689.13 | 684.27 | 688.24 | 16215.0 |
| 2021-06-09 | FTUK | Futures | 6912.8 | 6923.5 | 6860.6 | 6897.7 | 98752.0 |
| 2021-06-09 | FVSA | Futures | 93.23 | 94.53 | 91.14 | 91.66 | 18800.0 |
> showing 50 of 123 rows — these rows as CSV