PREVIEW / futures_daily / 2020-06-05
file: by_date/futures_daily/2020/2020-06-05.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-06-05 | ES | Futures | 3444.77 | 3552.37 | 3437.3 | 3526.09 | 2444330.0 |
| 2020-06-05 | NQ | Futures | 11055.69 | 11288.13 | 11007.83 | 11244.86 | 513656.0 |
| 2020-06-05 | YM | Futures | 28045.4 | 29157.2 | 27969.6 | 28887.3 | 295068.0 |
| 2020-06-05 | CL | Futures | 27.06 | 28.77 | 26.86 | 28.67 | 396856.0 |
| 2020-06-05 | GC | Futures | 2066.0 | 2068.9 | 2007.1 | 2020.6 | 273683.0 |
| 2020-06-05 | ZN | Futures | 136.497217 | 136.682444 | 135.46303 | 135.879792 | 25910.0 |
| 2020-06-05 | A6 | Futures | 0.71309 | 0.72059 | 0.71206 | 0.71586 | 100757.0 |
| 2020-06-05 | AD | Futures | 0.75054 | 0.75672 | 0.74993 | 0.75429 | 80665.0 |
| 2020-06-05 | ALI | Futures | 1889.03 | 1918.14 | 1889.03 | 1909.53 | 107.0 |
| 2020-06-05 | B | Futures | 26.08 | 27.81 | 26.0 | 27.69 | 250309.0 |
| 2020-06-05 | B6 | Futures | 1.2782 | 1.2924 | 1.2773 | 1.286 | 131706.0 |
| 2020-06-05 | BR | Futures | 0.15736 | 0.15911 | 0.15736 | 0.15887 | 29.0 |
| 2020-06-05 | BTC | Futures | 13720.5 | 13838.7 | 13456.3 | 13630.1 | 4508.0 |
| 2020-06-05 | BZ | Futures | 25.53 | 27.16 | 25.39 | 27.04 | 28827.0 |
| 2020-06-05 | C | Futures | 1823.0 | 1823.0 | 1786.0 | 1786.0 | 6586.0 |
| 2020-06-05 | CB | Futures | 227.886 | 229.41 | 212.212 | 215.047 | 43.0 |
| 2020-06-05 | CC | Futures | 1572.0 | 1577.0 | 1562.0 | 1564.0 | 19905.0 |
| 2020-06-05 | CNH | Futures | 7.0415 | 7.0523 | 7.0034 | 7.0066 | 821.0 |
| 2020-06-05 | CSC | Futures | 3.492 | 3.492 | 3.478 | 3.478 | 23.0 |
| 2020-06-05 | CT | Futures | 58.38 | 60.75 | 58.24 | 60.23 | 26742.0 |
| 2020-06-05 | DC | Futures | 29.08 | 29.2 | 28.89 | 28.94 | 176.0 |
| 2020-06-05 | DX | Futures | 93.569 | 93.845 | 93.245 | 93.721 | 23985.0 |
| 2020-06-05 | E1 | Futures | 1.19262 | 1.19387 | 1.18021 | 1.18397 | 33618.0 |
| 2020-06-05 | E6 | Futures | 1.21862 | 1.22368 | 1.21239 | 1.214 | 243548.0 |
| 2020-06-05 | E7 | Futures | 1.2122 | 1.2172 | 1.2061 | 1.2077 | 8840.0 |
| 2020-06-05 | EBM | Futures | 224.24 | 225.44 | 222.45 | 223.65 | 15944.0 |
| 2020-06-05 | ED | Futures | 96.3823 | 96.3871 | 96.375 | 96.3799 | 188286.0 |
| 2020-06-05 | ER | Futures | 98.318 | 98.323 | 98.313 | 98.318 | 46670.0 |
| 2020-06-05 | ESG | Futures | 286.95 | 287.86 | 286.87 | 287.27 | 55.0 |
| 2020-06-05 | EW | Futures | 1964.3 | 2058.5 | 1957.9 | 2023.6 | 13381.0 |
| 2020-06-05 | FBON | Futures | 143.59 | 144.05 | 143.45 | 143.59 | 1904.0 |
| 2020-06-05 | FBTP | Futures | 127.96 | 128.2 | 127.46 | 127.78 | 127300.0 |
| 2020-06-05 | FBTS | Futures | 108.115 | 108.231 | 108.076 | 108.134 | 76562.0 |
| 2020-06-05 | FCE | Futures | 4917.1 | 5047.2 | 4907.3 | 5044.3 | 80622.0 |
| 2020-06-05 | FDAX | Futures | 13135.9 | 13608.7 | 13114.8 | 13598.6 | 123827.0 |
| 2020-06-05 | FDIV | Futures | 145.02 | 146.97 | 144.1 | 146.97 | 403.0 |
| 2020-06-05 | FDXM | Futures | 13204.0 | 13674.8 | 13177.4 | 13663.6 | 81364.0 |
| 2020-06-05 | FESX | Futures | 2984.8 | 3105.0 | 2978.3 | 3103.2 | 1976453.0 |
| 2020-06-05 | FGBL | Futures | 165.77 | 165.92 | 164.88 | 165.06 | 786513.0 |
| 2020-06-05 | FGBM | Futures | 134.01 | 134.04 | 133.74 | 133.83 | 523414.0 |
| 2020-06-05 | FGBS | Futures | 112.629 | 112.639 | 112.573 | 112.593 | 383313.0 |
| 2020-06-05 | FGBX | Futures | 216.64 | 217.16 | 212.95 | 213.53 | 84404.0 |
| 2020-06-05 | FMWO | Futures | 7748.0 | 7928.0 | 7748.0 | 7917.4 | 12648.0 |
| 2020-06-05 | FOAT | Futures | 152.67 | 152.97 | 152.31 | 152.47 | 190900.0 |
| 2020-06-05 | FTDX | Futures | 3310.6 | 3310.6 | 3244.9 | 3288.3 | 154.0 |
| 2020-06-05 | FTI | Futures | 526.61 | 534.2 | 524.05 | 533.38 | 29721.0 |
| 2020-06-05 | FTUK | Futures | 5975.1 | 6127.4 | 5968.1 | 6115.7 | 107575.0 |
| 2020-06-05 | FVSA | Futures | 237.06 | 243.84 | 233.89 | 235.7 | 22417.0 |
| 2020-06-05 | FXXP | Futures | 342.7 | 348.0 | 341.3 | 347.7 | 91939.0 |
| 2020-06-05 | G | Futures | 125.27 | 125.55 | 124.85 | 125.06 | 195094.0 |
> showing 50 of 121 rows — these rows as CSV