PREVIEW / futures_daily / 2021-04-09
file: by_date/futures_daily/2021/2021-04-09.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-09 | ES | Futures | 4598.59 | 4624.96 | 4579.51 | 4622.71 | 1090560.0 |
| 2021-04-09 | NQ | Futures | 15901.61 | 15965.34 | 15742.15 | 15951.21 | 494768.0 |
| 2021-04-09 | YM | Futures | 36205.2 | 36468.2 | 36118.6 | 36455.2 | 131737.0 |
| 2021-04-09 | CL | Futures | 42.54 | 42.68 | 42.07 | 42.23 | 351436.0 |
| 2021-04-09 | GC | Futures | 2059.2 | 2061.2 | 2029.1 | 2045.5 | 171395.0 |
| 2021-04-09 | ZN | Futures | 132.719966 | 132.751375 | 132.138894 | 132.405873 | 1570458.0 |
| 2021-04-09 | A6 | Futures | 0.78485 | 0.78572 | 0.77818 | 0.78203 | 81425.0 |
| 2021-04-09 | AD | Futures | 0.80655 | 0.80898 | 0.80346 | 0.80888 | 65815.0 |
| 2021-04-09 | ALI | Futures | 2647.74 | 2647.74 | 2628.69 | 2631.0 | 80.0 |
| 2021-04-09 | B | Futures | 40.92 | 41.06 | 40.47 | 40.71 | 216243.0 |
| 2021-04-09 | B6 | Futures | 1.3946 | 1.3964 | 1.3882 | 1.393 | 76524.0 |
| 2021-04-09 | BFX | Futures | 3964.5 | 3971.1 | 3964.5 | 3971.1 | 1.0 |
| 2021-04-09 | BR | Futures | 0.1415 | 0.1415 | 0.13877 | 0.13885 | 1861.0 |
| 2021-04-09 | BTC | Futures | 75463.9 | 77278.7 | 75450.9 | 76439.6 | 3954.0 |
| 2021-04-09 | BZ | Futures | 39.93 | 40.03 | 39.47 | 39.71 | 29073.0 |
| 2021-04-09 | C | Futures | 1504.0 | 1505.0 | 1462.0 | 1466.0 | 15551.0 |
| 2021-04-09 | CB | Futures | 155.021 | 157.704 | 155.021 | 157.704 | 30.0 |
| 2021-04-09 | CC | Futures | 1586.0 | 1598.0 | 1573.0 | 1590.0 | 25292.0 |
| 2021-04-09 | CNH | Futures | 6.3798 | 6.3981 | 6.3798 | 6.3845 | 135.0 |
| 2021-04-09 | CSC | Futures | 3.085 | 3.095 | 3.071 | 3.079 | 129.0 |
| 2021-04-09 | CT | Futures | 76.95 | 78.94 | 76.89 | 77.96 | 20738.0 |
| 2021-04-09 | DC | Futures | 27.73 | 27.73 | 27.31 | 27.45 | 283.0 |
| 2021-04-09 | DX | Futures | 88.978 | 89.321 | 88.939 | 89.06 | 19961.0 |
| 2021-04-09 | E1 | Futures | 1.21957 | 1.22036 | 1.21451 | 1.21879 | 24751.0 |
| 2021-04-09 | E6 | Futures | 1.27121 | 1.2718 | 1.26615 | 1.26999 | 150628.0 |
| 2021-04-09 | E7 | Futures | 1.2656 | 1.2656 | 1.2598 | 1.2636 | 3938.0 |
| 2021-04-09 | EBM | Futures | 271.08 | 274.91 | 269.49 | 271.72 | 15678.0 |
| 2021-04-09 | ED | Futures | 96.498 | 96.5028 | 96.4932 | 96.498 | 169783.0 |
| 2021-04-09 | ER | Futures | 98.47 | 98.47 | 98.465 | 98.465 | 17275.0 |
| 2021-04-09 | ESG | Futures | 379.69 | 382.74 | 378.95 | 382.7 | 210.0 |
| 2021-04-09 | EW | Futures | 2847.8 | 2855.2 | 2832.3 | 2851.8 | 6608.0 |
| 2021-04-09 | FBON | Futures | 148.64 | 148.64 | 147.96 | 148.07 | 940.0 |
| 2021-04-09 | FBTP | Futures | 138.96 | 139.01 | 138.12 | 138.3 | 179902.0 |
| 2021-04-09 | FBTS | Futures | 110.107 | 110.107 | 110.0 | 110.02 | 101256.0 |
| 2021-04-09 | FCE | Futures | 6013.6 | 6039.4 | 6008.7 | 6018.0 | 37017.0 |
| 2021-04-09 | FDAX | Futures | 16253.1 | 16287.2 | 16172.0 | 16247.7 | 41885.0 |
| 2021-04-09 | FDIV | Futures | 184.26 | 184.26 | 183.97 | 184.17 | 128.0 |
| 2021-04-09 | FDXM | Futures | 16216.2 | 16265.2 | 16153.4 | 16228.0 | 34590.0 |
| 2021-04-09 | FESX | Futures | 3718.5 | 3723.3 | 3703.4 | 3711.0 | 506490.0 |
| 2021-04-09 | FGBL | Futures | 168.15 | 168.24 | 167.34 | 167.55 | 739728.0 |
| 2021-04-09 | FGBM | Futures | 135.04 | 135.07 | 134.75 | 134.8 | 442622.0 |
| 2021-04-09 | FGBS | Futures | 112.684 | 112.689 | 112.644 | 112.659 | 219351.0 |
| 2021-04-09 | FGBX | Futures | 220.31 | 220.8 | 218.08 | 219.12 | 82597.0 |
| 2021-04-09 | FMWO | Futures | 10172.5 | 10232.4 | 10150.1 | 10177.1 | 3914.0 |
| 2021-04-09 | FOAT | Futures | 156.3 | 156.37 | 155.54 | 155.71 | 215020.0 |
| 2021-04-09 | FTDX | Futures | 3556.3 | 3580.4 | 3556.3 | 3576.3 | 29.0 |
| 2021-04-09 | FTI | Futures | 668.81 | 669.61 | 667.07 | 668.8 | 12915.0 |
| 2021-04-09 | FTUK | Futures | 6735.0 | 6737.9 | 6686.3 | 6700.4 | 82356.0 |
| 2021-04-09 | FVSA | Futures | 96.91 | 98.05 | 94.35 | 97.2 | 15337.0 |
| 2021-04-09 | FXXP | Futures | 410.1 | 411.0 | 409.4 | 410.5 | 35624.0 |
> showing 50 of 122 rows — these rows as CSV