PREVIEW / futures_daily / 2021-05-04
file: by_date/futures_daily/2021/2021-05-04.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 |
|---|---|---|---|---|---|---|---|
| 2021-05-04 | ES | Futures | 4695.37 | 4696.78 | 4623.84 | 4666.2 | 2003587.0 |
| 2021-05-04 | NQ | Futures | 15899.88 | 15908.53 | 15433.61 | 15612.68 | 667316.0 |
| 2021-05-04 | YM | Futures | 36789.7 | 36850.3 | 36424.9 | 36821.1 | 209871.0 |
| 2021-05-04 | CL | Futures | 45.95 | 47.13 | 45.77 | 46.77 | 370208.0 |
| 2021-05-04 | GC | Futures | 2102.2 | 2109.6 | 2074.1 | 2082.1 | 246585.0 |
| 2021-05-04 | ZN | Futures | 133.002649 | 133.41097 | 132.829898 | 133.096877 | 1989203.0 |
| 2021-05-04 | A6 | Futures | 0.79597 | 0.79618 | 0.78705 | 0.79054 | 98800.0 |
| 2021-05-04 | AD | Futures | 0.82534 | 0.82539 | 0.82022 | 0.82331 | 86854.0 |
| 2021-05-04 | ALI | Futures | 2790.34 | 2797.48 | 2786.34 | 2792.05 | 122.0 |
| 2021-05-04 | B | Futures | 44.31 | 45.46 | 44.06 | 45.05 | 249641.0 |
| 2021-05-04 | B6 | Futures | 1.4125 | 1.4129 | 1.4053 | 1.4107 | 92883.0 |
| 2021-05-04 | BFX | Futures | 4087.1 | 4087.1 | 4024.2 | 4024.2 | 2.0 |
| 2021-05-04 | BR | Futures | 0.14522 | 0.14589 | 0.14403 | 0.1453 | 10833.0 |
| 2021-05-04 | BTC | Futures | 79255.8 | 79759.8 | 73497.0 | 75285.4 | 8065.0 |
| 2021-05-04 | BZ | Futures | 43.18 | 44.32 | 43.01 | 43.97 | 27613.0 |
| 2021-05-04 | C | Futures | 1448.0 | 1449.0 | 1414.0 | 1416.0 | 4546.0 |
| 2021-05-04 | CB | Futures | 146.64 | 146.971 | 145.732 | 146.145 | 24.0 |
| 2021-05-04 | CC | Futures | 1576.0 | 1589.0 | 1543.0 | 1548.0 | 30344.0 |
| 2021-05-04 | CNH | Futures | 6.286 | 6.3086 | 6.286 | 6.3009 | 157.0 |
| 2021-05-04 | CSC | Futures | 2.997 | 3.021 | 2.986 | 3.019 | 93.0 |
| 2021-05-04 | CT | Futures | 82.2 | 82.31 | 80.52 | 81.28 | 10909.0 |
| 2021-05-04 | DC | Futures | 27.85 | 27.96 | 27.52 | 27.92 | 287.0 |
| 2021-05-04 | DX | Futures | 87.924 | 88.316 | 87.905 | 88.205 | 26327.0 |
| 2021-05-04 | E1 | Futures | 1.23612 | 1.23657 | 1.22982 | 1.23319 | 20561.0 |
| 2021-05-04 | E6 | Futures | 1.2864 | 1.28661 | 1.27958 | 1.28096 | 160001.0 |
| 2021-05-04 | E7 | Futures | 1.2799 | 1.2799 | 1.2731 | 1.2745 | 4766.0 |
| 2021-05-04 | EBM | Futures | 309.4 | 325.68 | 306.84 | 322.17 | 1558.0 |
| 2021-05-04 | ED | Futures | 96.4883 | 96.4932 | 96.4883 | 96.4932 | 67659.0 |
| 2021-05-04 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 44550.0 |
| 2021-05-04 | ESG | Futures | 388.58 | 388.58 | 382.81 | 386.03 | 753.0 |
| 2021-05-04 | EW | Futures | 2927.5 | 2928.9 | 2886.2 | 2917.8 | 14564.0 |
| 2021-05-04 | FBON | Futures | 147.1 | 147.63 | 146.61 | 147.57 | 620.0 |
| 2021-05-04 | FBTP | Futures | 137.03 | 137.63 | 136.62 | 137.53 | 136268.0 |
| 2021-05-04 | FBTS | Futures | 109.991 | 110.059 | 109.942 | 110.049 | 69650.0 |
| 2021-05-04 | FCE | Futures | 6176.0 | 6227.8 | 6110.3 | 6124.1 | 77845.0 |
| 2021-05-04 | FDAX | Futures | 16193.4 | 16289.3 | 15812.8 | 15836.2 | 96839.0 |
| 2021-05-04 | FDIV | Futures | 182.84 | 183.28 | 179.36 | 179.36 | 85.0 |
| 2021-05-04 | FDXM | Futures | 16175.8 | 16269.5 | 15795.7 | 15817.0 | 107573.0 |
| 2021-05-04 | FDXS | Futures | 16082.1 | 16181.7 | 15710.4 | 15732.6 | 5483.0 |
| 2021-05-04 | FESX | Futures | 3730.8 | 3766.7 | 3669.4 | 3672.2 | 1112732.0 |
| 2021-05-04 | FEU3 | Futures | 99.193 | 99.198 | 99.193 | 99.198 | 99.0 |
| 2021-05-04 | FGBL | Futures | 166.25 | 167.0 | 165.7 | 166.86 | 877359.0 |
| 2021-05-04 | FGBM | Futures | 134.49 | 134.73 | 134.3 | 134.69 | 543756.0 |
| 2021-05-04 | FGBS | Futures | 112.629 | 112.654 | 112.599 | 112.644 | 446156.0 |
| 2021-05-04 | FGBX | Futures | 214.16 | 216.56 | 212.78 | 216.2 | 84017.0 |
| 2021-05-04 | FMWO | Futures | 10346.3 | 10401.5 | 10199.5 | 10219.4 | 3609.0 |
| 2021-05-04 | FOAT | Futures | 154.49 | 155.08 | 153.94 | 154.96 | 165770.0 |
| 2021-05-04 | FTDX | Futures | 3578.4 | 3627.7 | 3483.8 | 3485.9 | 278.0 |
| 2021-05-04 | FTI | Futures | 672.83 | 674.77 | 656.89 | 658.16 | 29428.0 |
| 2021-05-04 | FTUK | Futures | 6788.1 | 6826.5 | 6699.9 | 6702.8 | 112266.0 |
> showing 50 of 125 rows — these rows as CSV