PREVIEW / futures_daily / 2020-02-28
file: by_date/futures_daily/2020/2020-02-28.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-02-28 | ES | Futures | 3186.04 | 3235.72 | 3081.55 | 3187.12 | 5715227.0 |
| 2020-02-28 | NQ | Futures | 9574.17 | 9835.4 | 9320.96 | 9696.9 | 1527204.0 |
| 2020-02-28 | YM | Futures | 26803.3 | 27065.9 | 25913.8 | 26637.4 | 735823.0 |
| 2020-02-28 | CL | Futures | 47.47 | 48.02 | 44.77 | 45.7 | 1101659.0 |
| 2020-02-28 | GC | Futures | 2007.0 | 2013.0 | 1906.9 | 1910.2 | 745843.0 |
| 2020-02-28 | ZN | Futures | 132.516176 | 133.786052 | 132.361313 | 133.646675 | 275925.0 |
| 2020-02-28 | A6 | Futures | 0.67405 | 0.67539 | 0.65991 | 0.66882 | 240975.0 |
| 2020-02-28 | AD | Futures | 0.75269 | 0.7532 | 0.74841 | 0.75189 | 199686.0 |
| 2020-02-28 | ALI | Futures | 2005.62 | 2038.12 | 2004.72 | 2036.92 | 63.0 |
| 2020-02-28 | B | Futures | 43.45 | 43.5 | 41.63 | 42.25 | 521480.0 |
| 2020-02-28 | B6 | Futures | 1.3076 | 1.3108 | 1.2911 | 1.2978 | 179290.0 |
| 2020-02-28 | BR | Futures | 0.18164 | 0.18164 | 0.18062 | 0.18099 | 174.0 |
| 2020-02-28 | BTC | Futures | 12929.6 | 13090.3 | 12382.1 | 12703.3 | 3889.0 |
| 2020-02-28 | BZ | Futures | 42.27 | 42.66 | 40.52 | 41.12 | 53362.0 |
| 2020-02-28 | C | Futures | 1860.0 | 1860.0 | 1817.0 | 1831.0 | 7968.0 |
| 2020-02-28 | CB | Futures | 215.118 | 217.042 | 215.118 | 217.042 | 7.0 |
| 2020-02-28 | CC | Futures | 1780.0 | 1784.0 | 1733.0 | 1750.0 | 29460.0 |
| 2020-02-28 | CNH | Futures | 6.972 | 6.9848 | 6.9427 | 6.9564 | 1035.0 |
| 2020-02-28 | CSC | Futures | 3.181 | 3.192 | 3.178 | 3.181 | 112.0 |
| 2020-02-28 | CT | Futures | 60.17 | 60.43 | 57.94 | 59.2 | 41090.0 |
| 2020-02-28 | DC | Futures | 25.91 | 26.21 | 25.84 | 26.11 | 242.0 |
| 2020-02-28 | DX | Futures | 95.497 | 95.715 | 95.031 | 95.197 | 41689.0 |
| 2020-02-28 | E1 | Futures | 1.18095 | 1.18986 | 1.17936 | 1.18415 | 74340.0 |
| 2020-02-28 | E6 | Futures | 1.18654 | 1.19187 | 1.18088 | 1.18928 | 410546.0 |
| 2020-02-28 | E7 | Futures | 1.1803 | 1.1856 | 1.1747 | 1.1831 | 10719.0 |
| 2020-02-28 | EBM | Futures | 209.62 | 209.9 | 203.58 | 206.05 | 20716.0 |
| 2020-02-28 | ED | Futures | 95.5702 | 95.6939 | 95.5654 | 95.6818 | 1128418.0 |
| 2020-02-28 | ER | Futures | 98.421 | 98.465 | 98.416 | 98.435 | 151578.0 |
| 2020-02-28 | ESG | Futures | 259.58 | 264.64 | 259.58 | 263.62 | 4618.0 |
| 2020-02-28 | EW | Futures | 1935.1 | 1950.4 | 1861.6 | 1908.1 | 63815.0 |
| 2020-02-28 | FBON | Futures | 145.2 | 145.85 | 144.84 | 145.76 | 1294.0 |
| 2020-02-28 | FBTP | Futures | 130.87 | 131.26 | 129.52 | 130.73 | 254776.0 |
| 2020-02-28 | FBTS | Futures | 108.317 | 108.413 | 108.047 | 108.288 | 164064.0 |
| 2020-02-28 | FCE | Futures | 4766.6 | 4861.1 | 4724.5 | 4799.6 | 334485.0 |
| 2020-02-28 | FDAX | Futures | 12785.4 | 12855.2 | 12392.0 | 12498.9 | 244639.0 |
| 2020-02-28 | FDIV | Futures | 140.29 | 140.29 | 138.71 | 139.32 | 113.0 |
| 2020-02-28 | FDXM | Futures | 12645.8 | 12692.8 | 12235.5 | 12342.0 | 348970.0 |
| 2020-02-28 | FESX | Futures | 2972.7 | 2993.9 | 2887.3 | 2919.0 | 4413413.0 |
| 2020-02-28 | FGBL | Futures | 168.6 | 169.82 | 168.6 | 169.5 | 1465072.0 |
| 2020-02-28 | FGBM | Futures | 134.92 | 135.34 | 134.92 | 135.24 | 829630.0 |
| 2020-02-28 | FGBS | Futures | 112.956 | 113.056 | 112.946 | 113.026 | 770125.0 |
| 2020-02-28 | FGBX | Futures | 226.12 | 231.03 | 225.99 | 229.82 | 140832.0 |
| 2020-02-28 | FMWO | Futures | 7044.5 | 7150.0 | 6934.5 | 7035.5 | 28071.0 |
| 2020-02-28 | FOAT | Futures | 155.8 | 156.28 | 155.6 | 155.96 | 380435.0 |
| 2020-02-28 | FTDX | Futures | 2823.8 | 2874.5 | 2783.6 | 2842.4 | 505.0 |
| 2020-02-28 | FTI | Futures | 517.24 | 523.14 | 509.42 | 517.42 | 90568.0 |
| 2020-02-28 | FTUK | Futures | 6252.4 | 6254.3 | 6031.0 | 6124.8 | 397196.0 |
| 2020-02-28 | FVSA | Futures | 207.03 | 225.33 | 201.74 | 216.38 | 215747.0 |
| 2020-02-28 | FXXP | Futures | 340.4 | 345.7 | 337.6 | 340.8 | 375044.0 |
| 2020-02-28 | G | Futures | 124.37 | 124.5 | 123.83 | 124.03 | 411777.0 |
> showing 50 of 121 rows — these rows as CSV