PREVIEW / futures_daily / 2021-03-02
file: by_date/futures_daily/2021/2021-03-02.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-03-02 | ES | Futures | 4374.77 | 4378.41 | 4332.46 | 4334.7 | 1641396.0 |
| 2021-03-02 | NQ | Futures | 15354.6 | 15373.06 | 15050.1 | 15058.17 | 563138.0 |
| 2021-03-02 | YM | Futures | 34057.4 | 34111.4 | 33781.0 | 33864.1 | 207247.0 |
| 2021-03-02 | CL | Futures | 42.84 | 43.54 | 42.24 | 42.5 | 464133.0 |
| 2021-03-02 | GC | Futures | 2022.5 | 2040.1 | 2001.2 | 2035.2 | 235964.0 |
| 2021-03-02 | ZN | Futures | 133.699212 | 134.118819 | 133.543802 | 133.916786 | 19829.0 |
| 2021-03-02 | A6 | Futures | 0.79736 | 0.80403 | 0.79356 | 0.8031 | 118247.0 |
| 2021-03-02 | AD | Futures | 0.80092 | 0.80386 | 0.79768 | 0.8028 | 62552.0 |
| 2021-03-02 | ALI | Futures | 2502.93 | 2619.18 | 2490.98 | 2606.65 | 308.0 |
| 2021-03-02 | B | Futures | 40.4 | 41.05 | 39.93 | 40.13 | 367119.0 |
| 2021-03-02 | B6 | Futures | 1.4146 | 1.4194 | 1.4074 | 1.4182 | 72922.0 |
| 2021-03-02 | BFX | Futures | 3850.2 | 3850.2 | 3848.7 | 3848.7 | 1.0 |
| 2021-03-02 | BR | Futures | 0.13921 | 0.13929 | 0.13747 | 0.13929 | 46.0 |
| 2021-03-02 | BTC | Futures | 64184.8 | 65645.8 | 61353.8 | 62100.5 | 5993.0 |
| 2021-03-02 | BZ | Futures | 39.72 | 40.19 | 39.08 | 39.29 | 37996.0 |
| 2021-03-02 | C | Futures | 1653.0 | 1670.0 | 1629.0 | 1666.0 | 4155.0 |
| 2021-03-02 | CB | Futures | 146.062 | 149.448 | 146.062 | 149.448 | 13.0 |
| 2021-03-02 | CC | Futures | 1757.0 | 1789.0 | 1745.0 | 1783.0 | 20469.0 |
| 2021-03-02 | CNH | Futures | 6.3145 | 6.3305 | 6.3136 | 6.321 | 382.0 |
| 2021-03-02 | CSC | Futures | 2.873 | 2.886 | 2.872 | 2.88 | 11.0 |
| 2021-03-02 | CT | Futures | 86.1 | 86.53 | 85.28 | 86.09 | 14340.0 |
| 2021-03-02 | DC | Futures | 25.28 | 25.53 | 25.26 | 25.4 | 64.0 |
| 2021-03-02 | DX | Futures | 88.051 | 88.374 | 87.722 | 87.78 | 30960.0 |
| 2021-03-02 | E1 | Futures | 1.23448 | 1.2355 | 1.22782 | 1.23482 | 28069.0 |
| 2021-03-02 | E6 | Futures | 1.28686 | 1.29166 | 1.28067 | 1.29059 | 213958.0 |
| 2021-03-02 | E7 | Futures | 1.2804 | 1.2852 | 1.2744 | 1.2842 | 6681.0 |
| 2021-03-02 | EBM | Futures | 309.38 | 311.23 | 299.21 | 301.98 | 5524.0 |
| 2021-03-02 | ED | Futures | 96.5276 | 96.5276 | 96.5228 | 96.5228 | 92209.0 |
| 2021-03-02 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.46 | 57106.0 |
| 2021-03-02 | ESG | Futures | 357.87 | 359.85 | 356.91 | 356.91 | 2427.0 |
| 2021-03-02 | EW | Futures | 2747.0 | 2749.1 | 2699.8 | 2703.4 | 10552.0 |
| 2021-03-02 | FBON | Futures | 148.12 | 148.17 | 147.61 | 148.04 | 1771.0 |
| 2021-03-02 | FBTP | Futures | 138.11 | 138.23 | 137.6 | 137.97 | 312618.0 |
| 2021-03-02 | FBTS | Futures | 109.932 | 109.981 | 109.874 | 109.922 | 176632.0 |
| 2021-03-02 | FCE | Futures | 5622.1 | 5674.2 | 5611.0 | 5647.9 | 48568.0 |
| 2021-03-02 | FDAX | Futures | 14952.5 | 15029.2 | 14839.5 | 14969.5 | 67406.0 |
| 2021-03-02 | FDIV | Futures | 169.41 | 170.12 | 169.41 | 169.98 | 90.0 |
| 2021-03-02 | FDXM | Futures | 14903.1 | 14987.1 | 14798.9 | 14927.5 | 56877.0 |
| 2021-03-02 | FESX | Futures | 3448.5 | 3464.3 | 3426.2 | 3444.8 | 815150.0 |
| 2021-03-02 | FGBL | Futures | 167.43 | 167.6 | 166.84 | 167.35 | 1415547.0 |
| 2021-03-02 | FGBM | Futures | 134.66 | 134.73 | 134.51 | 134.66 | 1209394.0 |
| 2021-03-02 | FGBS | Futures | 112.639 | 112.664 | 112.624 | 112.649 | 908538.0 |
| 2021-03-02 | FGBX | Futures | 222.5 | 222.79 | 219.76 | 221.41 | 161086.0 |
| 2021-03-02 | FMWO | Futures | 9792.9 | 9854.5 | 9760.9 | 9809.5 | 9520.0 |
| 2021-03-02 | FOAT | Futures | 155.99 | 156.09 | 155.38 | 155.89 | 372548.0 |
| 2021-03-02 | FTDX | Futures | 3477.9 | 3511.9 | 3473.2 | 3473.2 | 148.0 |
| 2021-03-02 | FTI | Futures | 621.09 | 625.26 | 617.54 | 620.55 | 18892.0 |
| 2021-03-02 | FTUK | Futures | 6331.9 | 6388.2 | 6282.3 | 6350.7 | 96754.0 |
| 2021-03-02 | FVSA | Futures | 142.97 | 146.59 | 141.0 | 143.3 | 21779.0 |
| 2021-03-02 | FXXP | Futures | 381.7 | 386.1 | 381.5 | 384.1 | 65797.0 |
> showing 50 of 122 rows — these rows as CSV