PREVIEW / futures_daily / 2020-07-02
file: by_date/futures_daily/2020/2020-07-02.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 |
|---|---|---|---|---|---|---|---|
| 2020-07-02 | ES | Futures | 3491.29 | 3552.92 | 3484.25 | 3521.96 | 1552517.0 |
| 2020-07-02 | NQ | Futures | 11906.42 | 12096.47 | 11892.49 | 12019.29 | 404764.0 |
| 2020-07-02 | YM | Futures | 27380.6 | 27958.3 | 27344.2 | 27605.7 | 201493.0 |
| 2020-07-02 | CL | Futures | 28.84 | 29.53 | 28.61 | 29.47 | 347096.0 |
| 2020-07-02 | GC | Futures | 2135.9 | 2151.1 | 2120.6 | 2149.1 | 186306.0 |
| 2020-07-02 | ZN | Futures | 137.722492 | 137.93928 | 137.490219 | 137.846371 | 890404.0 |
| 2020-07-02 | A6 | Futures | 0.71133 | 0.71524 | 0.7102 | 0.71185 | 81183.0 |
| 2020-07-02 | AD | Futures | 0.74748 | 0.74865 | 0.74515 | 0.74688 | 59070.0 |
| 2020-07-02 | ALI | Futures | 1973.41 | 1980.06 | 1966.76 | 1972.2 | 114.0 |
| 2020-07-02 | B | Futures | 27.26 | 28.16 | 27.19 | 28.11 | 196692.0 |
| 2020-07-02 | B6 | Futures | 1.2676 | 1.2729 | 1.2653 | 1.2658 | 82196.0 |
| 2020-07-02 | BR | Futures | 0.14841 | 0.15015 | 0.14758 | 0.14873 | 109.0 |
| 2020-07-02 | BTC | Futures | 12781.2 | 12856.9 | 12326.7 | 12478.2 | 6562.0 |
| 2020-07-02 | BZ | Futures | 26.76 | 27.53 | 26.59 | 27.48 | 21825.0 |
| 2020-07-02 | C | Futures | 1531.0 | 1555.0 | 1520.0 | 1533.0 | 1156.0 |
| 2020-07-02 | CB | Futures | 202.208 | 202.208 | 202.208 | 202.208 | 20.0 |
| 2020-07-02 | CC | Futures | 1431.0 | 1455.0 | 1418.0 | 1429.0 | 16591.0 |
| 2020-07-02 | CNH | Futures | 6.9857 | 6.9943 | 6.9835 | 6.991 | 373.0 |
| 2020-07-02 | CSC | Futures | 3.85 | 3.887 | 3.837 | 3.884 | 34.0 |
| 2020-07-02 | CT | Futures | 64.05 | 64.27 | 63.41 | 64.27 | 26.0 |
| 2020-07-02 | DC | Futures | 31.47 | 32.18 | 31.42 | 32.08 | 338.0 |
| 2020-07-02 | DX | Futures | 93.831 | 94.019 | 93.493 | 93.986 | 17418.0 |
| 2020-07-02 | E1 | Futures | 1.20354 | 1.2074 | 1.20241 | 1.20275 | 17199.0 |
| 2020-07-02 | E6 | Futures | 1.20902 | 1.21471 | 1.20618 | 1.20666 | 168215.0 |
| 2020-07-02 | E7 | Futures | 1.2029 | 1.2087 | 1.2002 | 1.2007 | 5803.0 |
| 2020-07-02 | EBM | Futures | 216.76 | 217.36 | 216.46 | 216.76 | 8964.0 |
| 2020-07-02 | ED | Futures | 96.404 | 96.4088 | 96.3895 | 96.404 | 145018.0 |
| 2020-07-02 | ER | Futures | 98.377 | 98.386 | 98.377 | 98.382 | 47661.0 |
| 2020-07-02 | ESG | Futures | 285.78 | 286.57 | 283.21 | 283.55 | 94.0 |
| 2020-07-02 | EW | Futures | 1876.1 | 1923.1 | 1872.8 | 1887.3 | 12310.0 |
| 2020-07-02 | FBON | Futures | 144.45 | 145.06 | 144.42 | 144.99 | 591.0 |
| 2020-07-02 | FBTP | Futures | 129.79 | 130.6 | 129.79 | 130.51 | 77876.0 |
| 2020-07-02 | FBTS | Futures | 108.396 | 108.463 | 108.367 | 108.444 | 44876.0 |
| 2020-07-02 | FCE | Futures | 4839.9 | 4952.6 | 4835.5 | 4927.6 | 73157.0 |
| 2020-07-02 | FDAX | Futures | 13029.1 | 13433.3 | 12979.7 | 13378.6 | 97231.0 |
| 2020-07-02 | FDIV | Futures | 144.93 | 145.26 | 144.93 | 145.26 | 100.0 |
| 2020-07-02 | FDXM | Futures | 12998.0 | 13384.3 | 12935.5 | 13330.4 | 49310.0 |
| 2020-07-02 | FESX | Futures | 2971.5 | 3063.8 | 2960.4 | 3048.1 | 1192917.0 |
| 2020-07-02 | FEU3 | Futures | 99.134 | 99.134 | 99.129 | 99.129 | 59.0 |
| 2020-07-02 | FGBL | Futures | 167.39 | 168.22 | 167.24 | 168.17 | 628124.0 |
| 2020-07-02 | FGBM | Futures | 134.47 | 134.76 | 134.46 | 134.75 | 419228.0 |
| 2020-07-02 | FGBS | Futures | 112.729 | 112.764 | 112.709 | 112.754 | 220799.0 |
| 2020-07-02 | FGBX | Futures | 222.83 | 225.05 | 222.29 | 224.91 | 52594.0 |
| 2020-07-02 | FMWO | Futures | 7796.7 | 7890.4 | 7787.3 | 7833.5 | 3698.0 |
| 2020-07-02 | FOAT | Futures | 154.56 | 155.44 | 154.56 | 155.41 | 243673.0 |
| 2020-07-02 | FTDX | Futures | 3055.2 | 3058.3 | 3012.3 | 3053.1 | 220.0 |
| 2020-07-02 | FTI | Futures | 524.04 | 529.88 | 523.39 | 529.3 | 22716.0 |
| 2020-07-02 | FTUK | Futures | 5796.5 | 5882.1 | 5781.9 | 5858.9 | 82431.0 |
| 2020-07-02 | FVSA | Futures | 257.43 | 260.12 | 242.18 | 248.91 | 15704.0 |
| 2020-07-02 | FXXP | Futures | 334.1 | 339.0 | 333.6 | 338.2 | 46525.0 |
> showing 50 of 121 rows — these rows as CSV