PREVIEW / futures_daily / 2021-05-24
file: by_date/futures_daily/2021/2021-05-24.parquet size: 10 KB rows: 121
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-24 | ES | Futures | 4658.62 | 4720.06 | 4648.52 | 4706.03 | 1046500.0 |
| 2021-05-24 | NQ | Futures | 15436.5 | 15785.69 | 15405.64 | 15727.16 | 368611.0 |
| 2021-05-24 | YM | Futures | 36961.8 | 37261.6 | 36908.7 | 37180.4 | 102697.0 |
| 2021-05-24 | CL | Futures | 45.46 | 47.08 | 45.29 | 47.01 | 466647.0 |
| 2021-05-24 | GC | Futures | 2208.1 | 2213.3 | 2199.0 | 2209.3 | 183312.0 |
| 2021-05-24 | ZN | Futures | 133.20681 | 133.363856 | 133.143991 | 133.301038 | 2367110.0 |
| 2021-05-24 | A6 | Futures | 0.79274 | 0.79546 | 0.79013 | 0.7951 | 61234.0 |
| 2021-05-24 | AD | Futures | 0.83993 | 0.84145 | 0.83831 | 0.841 | 45567.0 |
| 2021-05-24 | ALI | Futures | 2674.18 | 2727.16 | 2673.05 | 2719.83 | 1150.0 |
| 2021-05-24 | B | Futures | 43.64 | 44.89 | 43.47 | 44.78 | 227254.0 |
| 2021-05-24 | B6 | Futures | 1.4368 | 1.4391 | 1.433 | 1.4377 | 57506.0 |
| 2021-05-24 | BR | Futures | 0.14716 | 0.14886 | 0.14712 | 0.14866 | 8171.0 |
| 2021-05-24 | BTC | Futures | 49833.5 | 57954.4 | 48935.2 | 57621.1 | 3060.0 |
| 2021-05-24 | BZ | Futures | 42.54 | 43.81 | 42.43 | 43.7 | 29400.0 |
| 2021-05-24 | C | Futures | 1482.0 | 1528.0 | 1474.0 | 1477.0 | 8887.0 |
| 2021-05-24 | CB | Futures | 155.227 | 155.227 | 150.434 | 151.637 | 20.0 |
| 2021-05-24 | CC | Futures | 1631.0 | 1659.0 | 1587.0 | 1591.0 | 21438.0 |
| 2021-05-24 | CNH | Futures | 6.2455 | 6.2503 | 6.2193 | 6.22 | 835.0 |
| 2021-05-24 | CSC | Futures | 2.739 | 2.745 | 2.662 | 2.668 | 135.0 |
| 2021-05-24 | CT | Futures | 77.11 | 77.33 | 76.57 | 77.22 | 9200.0 |
| 2021-05-24 | DC | Futures | 25.42 | 25.49 | 24.7 | 24.77 | 433.0 |
| 2021-05-24 | DX | Futures | 86.987 | 87.074 | 86.731 | 86.816 | 15799.0 |
| 2021-05-24 | E1 | Futures | 1.25379 | 1.25705 | 1.25063 | 1.25547 | 15241.0 |
| 2021-05-24 | E6 | Futures | 1.29876 | 1.30377 | 1.29743 | 1.3019 | 128352.0 |
| 2021-05-24 | E7 | Futures | 1.2919 | 1.2971 | 1.2909 | 1.2953 | 3493.0 |
| 2021-05-24 | EBM | Futures | 308.93 | 309.3 | 304.15 | 306.36 | 17426.0 |
| 2021-05-24 | ED | Futures | 96.5294 | 96.5391 | 96.5294 | 96.5391 | 110653.0 |
| 2021-05-24 | ER | Futures | 98.46 | 98.46 | 98.455 | 98.455 | 21894.0 |
| 2021-05-24 | ESG | Futures | 387.58 | 389.93 | 387.54 | 388.95 | 110.0 |
| 2021-05-24 | EW | Futures | 2918.7 | 2919.0 | 2869.8 | 2889.3 | 7945.0 |
| 2021-05-24 | FBON | Futures | 146.13 | 146.33 | 145.97 | 146.28 | 250.0 |
| 2021-05-24 | FBTP | Futures | 136.12 | 136.17 | 135.7 | 136.08 | 94931.0 |
| 2021-05-24 | FBTS | Futures | 109.932 | 109.942 | 109.893 | 109.942 | 40663.0 |
| 2021-05-24 | FCE | Futures | 6354.5 | 6383.4 | 6346.0 | 6372.5 | 32970.0 |
| 2021-05-24 | FDAX | Futures | 16481.2 | 16614.4 | 16446.0 | 16587.8 | 23344.0 |
| 2021-05-24 | FDXM | Futures | 16464.3 | 16594.2 | 16428.1 | 16567.6 | 22496.0 |
| 2021-05-24 | FDXS | Futures | 16382.9 | 16504.7 | 16355.4 | 16479.3 | 1401.0 |
| 2021-05-24 | FESX | Futures | 3802.7 | 3829.1 | 3797.9 | 3821.6 | 379781.0 |
| 2021-05-24 | FGBL | Futures | 165.41 | 165.64 | 165.26 | 165.55 | 465550.0 |
| 2021-05-24 | FGBM | Futures | 134.21 | 134.28 | 134.15 | 134.26 | 300744.0 |
| 2021-05-24 | FGBS | Futures | 112.584 | 112.594 | 112.564 | 112.574 | 208436.0 |
| 2021-05-24 | FGBX | Futures | 211.78 | 212.38 | 211.0 | 211.87 | 56732.0 |
| 2021-05-24 | FMWO | Futures | 10389.8 | 10473.2 | 10385.1 | 10457.9 | 3305.0 |
| 2021-05-24 | FOAT | Futures | 153.45 | 153.65 | 153.26 | 153.57 | 125950.0 |
| 2021-05-24 | FTDX | Futures | 3447.8 | 3511.1 | 3447.8 | 3493.6 | 6.0 |
| 2021-05-24 | FTI | Futures | 672.88 | 678.12 | 672.02 | 676.24 | 11432.0 |
| 2021-05-24 | FTUK | Futures | 6828.0 | 6873.8 | 6823.1 | 6863.1 | 56820.0 |
| 2021-05-24 | FVSA | Futures | 111.2 | 111.2 | 104.95 | 105.99 | 11766.0 |
| 2021-05-24 | FXXP | Futures | 421.7 | 423.3 | 420.6 | 422.6 | 24669.0 |
| 2021-05-24 | G | Futures | 121.38 | 121.59 | 121.29 | 121.53 | 599635.0 |
> showing 50 of 121 rows — these rows as CSV