PREVIEW / futures_daily / 2020-06-09
file: by_date/futures_daily/2020/2020-06-09.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-06-09 | ES | Futures | 3571.46 | 3575.06 | 3529.69 | 3546.84 | 1695764.0 |
| 2020-06-09 | NQ | Futures | 11335.14 | 11470.42 | 11248.29 | 11408.22 | 437442.0 |
| 2020-06-09 | YM | Futures | 29410.1 | 29476.3 | 28944.9 | 29092.1 | 222341.0 |
| 2020-06-09 | CL | Futures | 27.71 | 28.35 | 26.87 | 28.23 | 396033.0 |
| 2020-06-09 | GC | Futures | 2045.7 | 2076.3 | 2038.2 | 2067.3 | 182910.0 |
| 2020-06-09 | ZN | Futures | 136.112065 | 136.66952 | 136.09658 | 136.483702 | 1256988.0 |
| 2020-06-09 | A6 | Futures | 0.72079 | 0.72367 | 0.70877 | 0.71566 | 148483.0 |
| 2020-06-09 | AD | Futures | 0.75703 | 0.7585 | 0.7513 | 0.75662 | 73340.0 |
| 2020-06-09 | ALI | Futures | 1919.04 | 1928.84 | 1912.5 | 1928.84 | 88.0 |
| 2020-06-09 | B | Futures | 26.9 | 27.13 | 26.08 | 26.96 | 222358.0 |
| 2020-06-09 | B6 | Futures | 1.2914 | 1.2948 | 1.2809 | 1.2933 | 118602.0 |
| 2020-06-09 | BR | Futures | 0.16224 | 0.16247 | 0.16057 | 0.16113 | 23.0 |
| 2020-06-09 | BTC | Futures | 13393.7 | 13887.4 | 13379.8 | 13637.1 | 4291.0 |
| 2020-06-09 | BZ | Futures | 26.18 | 26.49 | 25.48 | 26.33 | 26258.0 |
| 2020-06-09 | C | Futures | 1773.0 | 1811.0 | 1764.0 | 1799.0 | 7513.0 |
| 2020-06-09 | CB | Futures | 218.685 | 218.685 | 218.685 | 218.685 | 7.0 |
| 2020-06-09 | CC | Futures | 1556.0 | 1600.0 | 1553.0 | 1587.0 | 34631.0 |
| 2020-06-09 | CNH | Futures | 6.9924 | 7.0237 | 6.9914 | 7.0104 | 657.0 |
| 2020-06-09 | CSC | Futures | 3.523 | 3.572 | 3.523 | 3.572 | 10.0 |
| 2020-06-09 | CT | Futures | 59.32 | 59.78 | 58.69 | 58.99 | 14910.0 |
| 2020-06-09 | DC | Futures | 29.13 | 29.85 | 29.11 | 29.83 | 162.0 |
| 2020-06-09 | DX | Futures | 93.444 | 93.859 | 93.038 | 93.14 | 19691.0 |
| 2020-06-09 | E1 | Futures | 1.18909 | 1.20116 | 1.18829 | 1.19877 | 25600.0 |
| 2020-06-09 | E6 | Futures | 1.21384 | 1.22153 | 1.20825 | 1.21948 | 305661.0 |
| 2020-06-09 | E7 | Futures | 1.2076 | 1.2152 | 1.202 | 1.2132 | 9792.0 |
| 2020-06-09 | EBM | Futures | 222.45 | 222.75 | 220.65 | 220.95 | 15000.0 |
| 2020-06-09 | ED | Futures | 96.3654 | 96.375 | 96.3581 | 96.3654 | 216920.0 |
| 2020-06-09 | ER | Futures | 98.323 | 98.333 | 98.313 | 98.318 | 67275.0 |
| 2020-06-09 | ESG | Futures | 290.09 | 290.09 | 289.26 | 289.29 | 25.0 |
| 2020-06-09 | EW | Futures | 2059.1 | 2061.2 | 2006.7 | 2018.3 | 11329.0 |
| 2020-06-09 | FBON | Futures | 144.01 | 144.01 | 142.68 | 143.0 | 713.0 |
| 2020-06-09 | FBTP | Futures | 127.98 | 128.12 | 127.2 | 127.46 | 70719.0 |
| 2020-06-09 | FBTS | Futures | 108.211 | 108.211 | 108.027 | 108.085 | 51448.0 |
| 2020-06-09 | FCE | Futures | 5057.9 | 5067.1 | 4903.9 | 4945.7 | 85234.0 |
| 2020-06-09 | FDAX | Futures | 13681.7 | 13682.2 | 13223.2 | 13375.5 | 109637.0 |
| 2020-06-09 | FDIV | Futures | 145.21 | 145.21 | 143.45 | 145.02 | 1430.0 |
| 2020-06-09 | FDXM | Futures | 13741.7 | 13741.7 | 13288.0 | 13439.4 | 80101.0 |
| 2020-06-09 | FESX | Futures | 3115.1 | 3115.1 | 3017.8 | 3046.3 | 1541190.0 |
| 2020-06-09 | FGBL | Futures | 165.88 | 166.27 | 165.58 | 165.73 | 646569.0 |
| 2020-06-09 | FGBM | Futures | 134.11 | 134.18 | 133.97 | 134.01 | 391220.0 |
| 2020-06-09 | FGBS | Futures | 112.634 | 112.659 | 112.619 | 112.629 | 219195.0 |
| 2020-06-09 | FGBX | Futures | 216.39 | 219.07 | 216.39 | 217.16 | 63625.0 |
| 2020-06-09 | FMWO | Futures | 7953.9 | 7963.3 | 7851.5 | 7911.5 | 6095.0 |
| 2020-06-09 | FOAT | Futures | 153.3 | 153.48 | 152.62 | 152.9 | 161100.0 |
| 2020-06-09 | FTDX | Futures | 3238.3 | 3238.3 | 3190.8 | 3209.0 | 60.0 |
| 2020-06-09 | FTI | Futures | 531.78 | 531.78 | 519.86 | 523.11 | 26610.0 |
| 2020-06-09 | FTUK | Futures | 6126.5 | 6141.6 | 5949.7 | 5973.3 | 117263.0 |
| 2020-06-09 | FVSA | Futures | 250.18 | 264.2 | 247.01 | 259.68 | 17568.0 |
| 2020-06-09 | FXXP | Futures | 348.1 | 348.1 | 340.7 | 342.1 | 81599.0 |
| 2020-06-09 | G | Futures | 125.37 | 125.69 | 125.26 | 125.45 | 320756.0 |
> showing 50 of 120 rows — these rows as CSV