PREVIEW / futures_daily / 2020-05-05
file: by_date/futures_daily/2020/2020-05-05.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-05 | ES | Futures | 3128.04 | 3197.47 | 3125.27 | 3162.61 | 1474765.0 |
| 2020-05-05 | NQ | Futures | 10095.84 | 10340.89 | 10086.95 | 10231.12 | 367233.0 |
| 2020-05-05 | YM | Futures | 25168.6 | 25670.1 | 25157.9 | 25354.2 | 177193.0 |
| 2020-05-05 | CL | Futures | 15.81 | 18.98 | 15.73 | 18.28 | 387240.0 |
| 2020-05-05 | GC | Futures | 2075.0 | 2083.2 | 2056.1 | 2074.5 | 184728.0 |
| 2020-05-05 | ZN | Futures | 137.238127 | 137.299869 | 136.94485 | 137.176384 | 962282.0 |
| 2020-05-05 | A6 | Futures | 0.66018 | 0.66542 | 0.65936 | 0.66357 | 60867.0 |
| 2020-05-05 | AD | Futures | 0.71923 | 0.72338 | 0.71892 | 0.72257 | 47511.0 |
| 2020-05-05 | ALI | Futures | 1792.55 | 1800.02 | 1791.35 | 1800.02 | 28.0 |
| 2020-05-05 | B | Futures | 18.56 | 21.17 | 18.34 | 20.45 | 267135.0 |
| 2020-05-05 | B6 | Futures | 1.2631 | 1.2674 | 1.2609 | 1.2643 | 65416.0 |
| 2020-05-05 | BR | Futures | 0.1478 | 0.14919 | 0.14595 | 0.14661 | 4788.0 |
| 2020-05-05 | BTC | Futures | 12594.0 | 12830.4 | 12288.0 | 12496.6 | 4675.0 |
| 2020-05-05 | BZ | Futures | 17.86 | 20.26 | 17.77 | 19.8 | 38518.0 |
| 2020-05-05 | C | Futures | 1842.0 | 1854.0 | 1818.0 | 1819.0 | 2494.0 |
| 2020-05-05 | CB | Futures | 146.665 | 147.195 | 145.02 | 147.195 | 41.0 |
| 2020-05-05 | CC | Futures | 1560.0 | 1582.0 | 1544.0 | 1554.0 | 12253.0 |
| 2020-05-05 | CNH | Futures | 7.0693 | 7.0746 | 7.0505 | 7.0542 | 259.0 |
| 2020-05-05 | CSC | Futures | 2.589 | 2.659 | 2.576 | 2.659 | 147.0 |
| 2020-05-05 | CT | Futures | 53.07 | 53.93 | 52.11 | 52.23 | 11088.0 |
| 2020-05-05 | DC | Futures | 20.75 | 21.77 | 20.75 | 21.68 | 813.0 |
| 2020-05-05 | DX | Futures | 96.291 | 96.765 | 96.093 | 96.467 | 12347.0 |
| 2020-05-05 | E1 | Futures | 1.18055 | 1.18192 | 1.1711 | 1.17303 | 23966.0 |
| 2020-05-05 | E6 | Futures | 1.17252 | 1.17526 | 1.1644 | 1.1672 | 162382.0 |
| 2020-05-05 | E7 | Futures | 1.1665 | 1.1692 | 1.1584 | 1.1611 | 7496.0 |
| 2020-05-05 | EBM | Futures | 220.05 | 222.75 | 219.45 | 222.45 | 11914.0 |
| 2020-05-05 | ED | Futures | 96.3291 | 96.3436 | 96.3243 | 96.3291 | 255734.0 |
| 2020-05-05 | ER | Futures | 98.333 | 98.333 | 98.298 | 98.308 | 95087.0 |
| 2020-05-05 | ESG | Futures | 260.64 | 260.75 | 258.71 | 258.71 | 25.0 |
| 2020-05-05 | EW | Futures | 1679.5 | 1733.6 | 1677.8 | 1698.8 | 7874.0 |
| 2020-05-05 | FBON | Futures | 140.06 | 140.75 | 139.21 | 139.83 | 302.0 |
| 2020-05-05 | FBTP | Futures | 123.72 | 124.22 | 122.03 | 122.65 | 118102.0 |
| 2020-05-05 | FBTS | Futures | 107.104 | 107.201 | 106.623 | 106.825 | 90713.0 |
| 2020-05-05 | FCE | Futures | 4288.4 | 4343.2 | 4272.0 | 4334.0 | 47796.0 |
| 2020-05-05 | FDAX | Futures | 11216.3 | 11372.8 | 11125.9 | 11357.5 | 85900.0 |
| 2020-05-05 | FDXM | Futures | 11281.6 | 11427.2 | 11179.6 | 11411.8 | 53479.0 |
| 2020-05-05 | FESX | Futures | 2588.3 | 2623.1 | 2569.9 | 2617.6 | 1025072.0 |
| 2020-05-05 | FEU3 | Futures | 99.05 | 99.05 | 99.045 | 99.045 | 106.0 |
| 2020-05-05 | FGBL | Futures | 169.26 | 169.67 | 168.57 | 169.53 | 642956.0 |
| 2020-05-05 | FGBM | Futures | 135.3 | 135.49 | 135.04 | 135.42 | 397740.0 |
| 2020-05-05 | FGBS | Futures | 113.001 | 113.086 | 112.961 | 113.066 | 476765.0 |
| 2020-05-05 | FGBX | Futures | 230.09 | 231.34 | 228.16 | 230.47 | 48374.0 |
| 2020-05-05 | FMWO | Futures | 6986.8 | 7046.8 | 6938.6 | 7037.4 | 2712.0 |
| 2020-05-05 | FOAT | Futures | 153.28 | 153.49 | 152.88 | 153.43 | 119108.0 |
| 2020-05-05 | FTDX | Futures | 2867.8 | 2913.3 | 2857.1 | 2913.3 | 111.0 |
| 2020-05-05 | FTI | Futures | 471.63 | 478.1 | 467.32 | 476.86 | 30935.0 |
| 2020-05-05 | FTUK | Futures | 5448.9 | 5515.4 | 5438.6 | 5500.3 | 89591.0 |
| 2020-05-05 | FVSA | Futures | 311.47 | 327.67 | 307.87 | 308.77 | 15265.0 |
| 2020-05-05 | FXXP | Futures | 306.9 | 309.4 | 304.8 | 309.1 | 76742.0 |
| 2020-05-05 | G | Futures | 125.95 | 126.56 | 125.94 | 126.48 | 245063.0 |
> showing 50 of 119 rows — these rows as CSV