PREVIEW / futures_daily / 2021-04-07
file: by_date/futures_daily/2021/2021-04-07.parquet size: 10 KB rows: 122
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-04-07 | ES | Futures | 4563.8 | 4573.34 | 4552.02 | 4567.17 | 1101579.0 |
| 2021-04-07 | NQ | Futures | 15664.01 | 15733.79 | 15585.58 | 15691.98 | 434828.0 |
| 2021-04-07 | YM | Futures | 36077.5 | 36157.6 | 35969.3 | 36072.1 | 129135.0 |
| 2021-04-07 | CL | Futures | 42.19 | 42.74 | 41.37 | 42.55 | 475537.0 |
| 2021-04-07 | GC | Futures | 2045.0 | 2046.2 | 2029.6 | 2041.8 | 122802.0 |
| 2021-04-07 | ZN | Futures | 132.343054 | 132.625738 | 132.248826 | 132.500101 | 1409520.0 |
| 2021-04-07 | A6 | Futures | 0.78572 | 0.78736 | 0.77952 | 0.78003 | 85434.0 |
| 2021-04-07 | AD | Futures | 0.80604 | 0.80634 | 0.80199 | 0.8026 | 69080.0 |
| 2021-04-07 | ALI | Futures | 2631.58 | 2632.44 | 2614.84 | 2630.42 | 495.0 |
| 2021-04-07 | B | Futures | 40.48 | 41.1 | 39.84 | 40.85 | 321390.0 |
| 2021-04-07 | B6 | Futures | 1.4038 | 1.4057 | 1.3939 | 1.3949 | 100049.0 |
| 2021-04-07 | BFX | Futures | 3961.0 | 3961.0 | 3956.5 | 3956.5 | 1.0 |
| 2021-04-07 | BR | Futures | 0.14162 | 0.14202 | 0.13948 | 0.13992 | 117.0 |
| 2021-04-07 | BTC | Futures | 75841.2 | 76855.9 | 72426.4 | 73252.5 | 11417.0 |
| 2021-04-07 | BZ | Futures | 39.54 | 40.07 | 38.86 | 39.84 | 42225.0 |
| 2021-04-07 | C | Futures | 1563.0 | 1567.0 | 1547.0 | 1553.0 | 4731.0 |
| 2021-04-07 | CB | Futures | 153.163 | 154.402 | 153.163 | 154.402 | 8.0 |
| 2021-04-07 | CC | Futures | 1618.0 | 1618.0 | 1593.0 | 1606.0 | 21309.0 |
| 2021-04-07 | CNH | Futures | 6.3719 | 6.3832 | 6.3719 | 6.3788 | 178.0 |
| 2021-04-07 | CSC | Futures | 2.95 | 3.019 | 2.95 | 3.016 | 27.0 |
| 2021-04-07 | CT | Futures | 74.96 | 76.3 | 74.6 | 75.22 | 18192.0 |
| 2021-04-07 | DC | Futures | 26.66 | 27.37 | 26.66 | 27.2 | 374.0 |
| 2021-04-07 | DX | Futures | 89.195 | 89.403 | 89.055 | 89.361 | 18609.0 |
| 2021-04-07 | E1 | Futures | 1.21046 | 1.21631 | 1.21023 | 1.21237 | 23102.0 |
| 2021-04-07 | E6 | Futures | 1.2669 | 1.27137 | 1.26557 | 1.26615 | 174211.0 |
| 2021-04-07 | E7 | Futures | 1.2604 | 1.2649 | 1.2592 | 1.2598 | 4144.0 |
| 2021-04-07 | EBM | Futures | 261.82 | 265.33 | 260.55 | 264.7 | 16542.0 |
| 2021-04-07 | ED | Futures | 96.5028 | 96.5077 | 96.498 | 96.5028 | 78695.0 |
| 2021-04-07 | ER | Futures | 98.46 | 98.47 | 98.46 | 98.465 | 56520.0 |
| 2021-04-07 | ESG | Futures | 376.16 | 377.6 | 375.97 | 377.56 | 336.0 |
| 2021-04-07 | EW | Futures | 2854.8 | 2858.9 | 2819.3 | 2828.1 | 9488.0 |
| 2021-04-07 | FBON | Futures | 148.53 | 148.85 | 148.42 | 148.46 | 537.0 |
| 2021-04-07 | FBTP | Futures | 138.82 | 139.13 | 138.62 | 138.75 | 202272.0 |
| 2021-04-07 | FBTS | Futures | 110.068 | 110.117 | 110.049 | 110.068 | 75686.0 |
| 2021-04-07 | FCE | Futures | 5977.5 | 6003.8 | 5968.2 | 5979.9 | 39589.0 |
| 2021-04-07 | FDAX | Futures | 16234.9 | 16264.8 | 16173.1 | 16201.9 | 40174.0 |
| 2021-04-07 | FDIV | Futures | 184.51 | 184.51 | 184.51 | 184.51 | 1.0 |
| 2021-04-07 | FDXM | Futures | 16209.9 | 16245.0 | 16154.5 | 16182.2 | 39533.0 |
| 2021-04-07 | FESX | Futures | 3703.4 | 3706.2 | 3686.4 | 3694.9 | 528594.0 |
| 2021-04-07 | FEU3 | Futures | 99.203 | 99.208 | 99.203 | 99.208 | 55.0 |
| 2021-04-07 | FGBL | Futures | 167.85 | 168.23 | 167.78 | 167.85 | 666395.0 |
| 2021-04-07 | FGBM | Futures | 134.95 | 135.04 | 134.93 | 134.96 | 348152.0 |
| 2021-04-07 | FGBS | Futures | 112.669 | 112.679 | 112.659 | 112.664 | 140764.0 |
| 2021-04-07 | FGBX | Futures | 219.85 | 220.99 | 219.1 | 219.44 | 77709.0 |
| 2021-04-07 | FMWO | Futures | 10104.3 | 10124.3 | 10082.0 | 10105.5 | 1711.0 |
| 2021-04-07 | FOAT | Futures | 156.13 | 156.38 | 155.98 | 156.05 | 169275.0 |
| 2021-04-07 | FTDX | Futures | 3539.8 | 3548.6 | 3534.7 | 3542.9 | 40.0 |
| 2021-04-07 | FTI | Futures | 666.37 | 668.48 | 664.54 | 665.74 | 14116.0 |
| 2021-04-07 | FTUK | Futures | 6611.8 | 6681.4 | 6605.4 | 6665.8 | 92477.0 |
| 2021-04-07 | FVSA | Futures | 100.05 | 101.19 | 97.2 | 98.62 | 16246.0 |
> showing 50 of 122 rows — these rows as CSV