PREVIEW / futures_daily / 2020-01-03
file: by_date/futures_daily/2020/2020-01-03.parquet size: 10 KB rows: 120
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-03 | ES | Futures | 3521.92 | 3524.62 | 3463.33 | 3494.38 | 1755057.0 |
| 2020-01-03 | NQ | Futures | 10203.31 | 10216.79 | 10019.5 | 10105.24 | 599887.0 |
| 2020-01-03 | YM | Futures | 30292.1 | 30343.6 | 29858.4 | 30038.0 | 245778.0 |
| 2020-01-03 | CL | Futures | 62.72 | 65.7 | 62.67 | 64.64 | 885861.0 |
| 2020-01-03 | GC | Futures | 1884.4 | 1915.0 | 1882.8 | 1909.9 | 436740.0 |
| 2020-01-03 | ZN | Futures | 127.514105 | 128.288419 | 127.483132 | 128.241961 | 1817748.0 |
| 2020-01-03 | A6 | Futures | 0.71732 | 0.71752 | 0.71178 | 0.71455 | 103832.0 |
| 2020-01-03 | AD | Futures | 0.77627 | 0.77758 | 0.77476 | 0.77572 | 75859.0 |
| 2020-01-03 | ALI | Futures | 2185.9 | 2216.06 | 2183.49 | 2216.06 | 90.0 |
| 2020-01-03 | B | Futures | 54.19 | 56.82 | 54.14 | 56.09 | 479696.0 |
| 2020-01-03 | B6 | Futures | 1.3354 | 1.3371 | 1.3263 | 1.3288 | 82163.0 |
| 2020-01-03 | BFX | Futures | 4701.9 | 4709.0 | 4701.9 | 4709.0 | 7.0 |
| 2020-01-03 | BR | Futures | 0.20005 | 0.2005 | 0.19908 | 0.19985 | 236.0 |
| 2020-01-03 | BTC | Futures | 10550.4 | 11369.0 | 10398.9 | 11194.7 | 8657.0 |
| 2020-01-03 | BZ | Futures | 53.43 | 56.01 | 53.38 | 55.3 | 78848.0 |
| 2020-01-03 | C | Futures | 1746.0 | 1774.0 | 1736.0 | 1739.0 | 9680.0 |
| 2020-01-03 | CB | Futures | 247.6 | 247.6 | 247.247 | 247.247 | 47.0 |
| 2020-01-03 | CC | Futures | 1658.0 | 1685.0 | 1646.0 | 1648.0 | 16723.0 |
| 2020-01-03 | CNH | Futures | 6.9359 | 6.9472 | 6.931 | 6.9377 | 308.0 |
| 2020-01-03 | CSC | Futures | 3.342 | 3.35 | 3.342 | 3.348 | 30.0 |
| 2020-01-03 | CT | Futures | 65.64 | 66.21 | 65.16 | 65.82 | 19512.0 |
| 2020-01-03 | DC | Futures | 28.03 | 28.03 | 27.81 | 27.9 | 113.0 |
| 2020-01-03 | DX | Futures | 93.604 | 93.949 | 93.56 | 93.683 | 12636.0 |
| 2020-01-03 | E1 | Futures | 1.18198 | 1.18472 | 1.1781 | 1.18118 | 33575.0 |
| 2020-01-03 | E6 | Futures | 1.20894 | 1.2097 | 1.20372 | 1.20841 | 169558.0 |
| 2020-01-03 | E7 | Futures | 1.2026 | 1.2038 | 1.1975 | 1.2021 | 2731.0 |
| 2020-01-03 | EBM | Futures | 207.15 | 207.7 | 206.6 | 207.15 | 14884.0 |
| 2020-01-03 | ED | Futures | 95.318 | 95.3471 | 95.3132 | 95.3229 | 392017.0 |
| 2020-01-03 | ER | Futures | 98.367 | 98.377 | 98.367 | 98.372 | 64212.0 |
| 2020-01-03 | EW | Futures | 2177.7 | 2179.5 | 2139.8 | 2165.3 | 17655.0 |
| 2020-01-03 | FBON | Futures | 143.49 | 144.03 | 143.42 | 143.82 | 401.0 |
| 2020-01-03 | FBTP | Futures | 128.0 | 128.71 | 128.0 | 128.5 | 66955.0 |
| 2020-01-03 | FBTS | Futures | 108.22 | 108.268 | 108.163 | 108.23 | 41332.0 |
| 2020-01-03 | FCE | Futures | 5444.9 | 5468.4 | 5420.9 | 5465.7 | 75611.0 |
| 2020-01-03 | FDAX | Futures | 14218.4 | 14223.1 | 13865.7 | 13952.4 | 138933.0 |
| 2020-01-03 | FDIV | Futures | 158.62 | 159.45 | 158.62 | 159.36 | 50.0 |
| 2020-01-03 | FDXM | Futures | 14045.1 | 14045.1 | 13691.1 | 13777.3 | 57663.0 |
| 2020-01-03 | FESX | Futures | 3344.4 | 3345.3 | 3286.3 | 3306.5 | 863617.0 |
| 2020-01-03 | FGBL | Futures | 163.43 | 164.65 | 163.43 | 164.4 | 530177.0 |
| 2020-01-03 | FGBM | Futures | 133.42 | 133.85 | 133.42 | 133.76 | 329230.0 |
| 2020-01-03 | FGBS | Futures | 112.644 | 112.704 | 112.639 | 112.684 | 275854.0 |
| 2020-01-03 | FGBX | Futures | 209.37 | 213.11 | 209.37 | 212.15 | 53224.0 |
| 2020-01-03 | FMWO | Futures | 7880.3 | 7891.6 | 7807.7 | 7875.8 | 2608.0 |
| 2020-01-03 | FOAT | Futures | 151.43 | 152.06 | 151.42 | 151.84 | 95483.0 |
| 2020-01-03 | FTDX | Futures | 3056.9 | 3059.4 | 3026.8 | 3044.9 | 54.0 |
| 2020-01-03 | FTI | Futures | 585.14 | 585.72 | 581.26 | 585.09 | 32680.0 |
| 2020-01-03 | FTUK | Futures | 7105.2 | 7106.1 | 7024.1 | 7082.7 | 84638.0 |
| 2020-01-03 | FVSA | Futures | 131.13 | 137.22 | 129.73 | 133.01 | 41192.0 |
| 2020-01-03 | FXXP | Futures | 379.9 | 380.2 | 377.3 | 379.6 | 45000.0 |
| 2020-01-03 | G | Futures | 120.45 | 120.87 | 120.37 | 120.61 | 150928.0 |
> showing 50 of 120 rows — these rows as CSV