PREVIEW / futures_daily / 2020-01-07
file: by_date/futures_daily/2020/2020-01-07.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-01-07 | ES | Futures | 3503.02 | 3514.9 | 3484.12 | 3494.11 | 1293494.0 |
| 2020-01-07 | NQ | Futures | 10154.85 | 10202.45 | 10123.3 | 10154.56 | 510004.0 |
| 2020-01-07 | YM | Futures | 30073.7 | 30181.8 | 29874.1 | 29958.1 | 198208.0 |
| 2020-01-07 | CL | Futures | 64.49 | 64.74 | 63.67 | 64.28 | 582649.0 |
| 2020-01-07 | GC | Futures | 1928.3 | 1942.8 | 1915.5 | 1936.8 | 435869.0 |
| 2020-01-07 | ZN | Futures | 128.087098 | 128.241961 | 127.99418 | 128.009666 | 1450885.0 |
| 2020-01-07 | A6 | Futures | 0.7127 | 0.7127 | 0.7044 | 0.70532 | 108237.0 |
| 2020-01-07 | AD | Futures | 0.77733 | 0.77779 | 0.77345 | 0.77491 | 70839.0 |
| 2020-01-07 | ALI | Futures | 2228.12 | 2231.14 | 2207.01 | 2210.03 | 150.0 |
| 2020-01-07 | B | Futures | 56.11 | 56.21 | 55.31 | 55.82 | 284919.0 |
| 2020-01-07 | B6 | Futures | 1.3384 | 1.3424 | 1.3305 | 1.3331 | 83489.0 |
| 2020-01-07 | BR | Futures | 0.19912 | 0.19928 | 0.19794 | 0.19928 | 254.0 |
| 2020-01-07 | BTC | Futures | 11710.1 | 12581.7 | 11710.1 | 12551.4 | 11526.0 |
| 2020-01-07 | BZ | Futures | 55.28 | 55.41 | 54.53 | 55.03 | 41178.0 |
| 2020-01-07 | C | Futures | 1700.0 | 1741.0 | 1695.0 | 1733.0 | 7437.0 |
| 2020-01-07 | CB | Futures | 243.533 | 243.533 | 241.233 | 242.265 | 150.0 |
| 2020-01-07 | CC | Futures | 1629.0 | 1667.0 | 1620.0 | 1657.0 | 17979.0 |
| 2020-01-07 | CNH | Futures | 6.938 | 6.9382 | 6.9034 | 6.9165 | 641.0 |
| 2020-01-07 | CSC | Futures | 3.348 | 3.376 | 3.348 | 3.372 | 83.0 |
| 2020-01-07 | CT | Futures | 66.65 | 66.82 | 66.07 | 66.42 | 14186.0 |
| 2020-01-07 | DC | Futures | 27.88 | 28.22 | 27.88 | 28.15 | 82.0 |
| 2020-01-07 | DX | Futures | 93.536 | 93.949 | 93.478 | 93.858 | 11605.0 |
| 2020-01-07 | E1 | Futures | 1.18575 | 1.18587 | 1.17947 | 1.18221 | 26247.0 |
| 2020-01-07 | E6 | Futures | 1.21153 | 1.21158 | 1.20453 | 1.20577 | 154584.0 |
| 2020-01-07 | E7 | Futures | 1.2051 | 1.2052 | 1.1982 | 1.1995 | 2666.0 |
| 2020-01-07 | EBM | Futures | 206.87 | 207.42 | 206.6 | 207.15 | 13780.0 |
| 2020-01-07 | ED | Futures | 95.3326 | 95.3423 | 95.3277 | 95.3326 | 208297.0 |
| 2020-01-07 | ER | Futures | 98.377 | 98.382 | 98.372 | 98.377 | 80801.0 |
| 2020-01-07 | ESG | Futures | 288.73 | 289.29 | 288.73 | 289.29 | 10.0 |
| 2020-01-07 | EW | Futures | 2161.3 | 2168.7 | 2151.2 | 2158.4 | 13956.0 |
| 2020-01-07 | FBON | Futures | 143.45 | 143.71 | 143.39 | 143.55 | 339.0 |
| 2020-01-07 | FBTP | Futures | 128.35 | 128.39 | 128.03 | 128.05 | 61175.0 |
| 2020-01-07 | FBTS | Futures | 108.22 | 108.22 | 108.134 | 108.143 | 35653.0 |
| 2020-01-07 | FCE | Futures | 5466.2 | 5491.1 | 5430.4 | 5442.6 | 77149.0 |
| 2020-01-07 | FDAX | Futures | 13889.0 | 14042.3 | 13887.9 | 13984.7 | 120417.0 |
| 2020-01-07 | FDIV | Futures | 159.5 | 159.64 | 159.31 | 159.31 | 61.0 |
| 2020-01-07 | FDXM | Futures | 13725.6 | 13866.6 | 13711.0 | 13809.1 | 57743.0 |
| 2020-01-07 | FESX | Futures | 3297.7 | 3322.4 | 3289.8 | 3303.0 | 898188.0 |
| 2020-01-07 | FEU3 | Futures | 99.08 | 99.09 | 99.08 | 99.09 | 99.0 |
| 2020-01-07 | FGBL | Futures | 164.49 | 164.58 | 164.2 | 164.4 | 582593.0 |
| 2020-01-07 | FGBM | Futures | 133.79 | 133.82 | 133.69 | 133.77 | 415382.0 |
| 2020-01-07 | FGBS | Futures | 112.694 | 112.694 | 112.669 | 112.684 | 217738.0 |
| 2020-01-07 | FGBX | Futures | 211.98 | 212.36 | 211.1 | 211.75 | 51220.0 |
| 2020-01-07 | FMWO | Futures | 7898.4 | 7918.9 | 7863.3 | 7886.0 | 2669.0 |
| 2020-01-07 | FOAT | Futures | 151.77 | 152.05 | 151.7 | 151.91 | 117654.0 |
| 2020-01-07 | FTDX | Futures | 3044.9 | 3067.0 | 3043.9 | 3050.4 | 44.0 |
| 2020-01-07 | FTI | Futures | 583.51 | 586.29 | 581.98 | 583.81 | 28841.0 |
| 2020-01-07 | FTUK | Futures | 7064.4 | 7090.7 | 7034.4 | 7044.2 | 78532.0 |
| 2020-01-07 | FVSA | Futures | 130.66 | 133.47 | 128.32 | 128.79 | 26097.0 |
| 2020-01-07 | FXXP | Futures | 379.9 | 381.1 | 378.0 | 379.5 | 68616.0 |
> showing 50 of 121 rows — these rows as CSV