PREVIEW / futures_daily / 2020-06-11
file: by_date/futures_daily/2020/2020-06-11.parquet size: 10 KB rows: 117
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-11 | ES | Futures | 3522.77 | 3528.03 | 3315.31 | 3330.8 | 3528726.0 |
| 2020-06-11 | NQ | Futures | 11563.28 | 11587.07 | 10988.05 | 11025.03 | 828944.0 |
| 2020-06-11 | YM | Futures | 28755.6 | 28774.9 | 26721.6 | 26825.5 | 15536.0 |
| 2020-06-11 | CL | Futures | 28.34 | 28.34 | 25.67 | 26.34 | 513912.0 |
| 2020-06-11 | GC | Futures | 2097.0 | 2107.0 | 2074.1 | 2088.8 | 205348.0 |
| 2020-06-11 | ZN | Futures | 137.381825 | 137.846371 | 137.36634 | 137.799916 | 1466637.0 |
| 2020-06-11 | A6 | Futures | 0.71936 | 0.72059 | 0.70362 | 0.70444 | 56210.0 |
| 2020-06-11 | AD | Futures | 0.75713 | 0.75753 | 0.74469 | 0.74606 | 67000.0 |
| 2020-06-11 | ALI | Futures | 1922.9 | 1922.9 | 1919.63 | 1921.11 | 4.0 |
| 2020-06-11 | B | Futures | 26.8 | 26.84 | 24.76 | 25.23 | 290169.0 |
| 2020-06-11 | B6 | Futures | 1.2949 | 1.2957 | 1.2786 | 1.2795 | 82194.0 |
| 2020-06-11 | BR | Futures | 0.15617 | 0.15621 | 0.15348 | 0.15348 | 5.0 |
| 2020-06-11 | BTC | Futures | 13831.8 | 13991.7 | 12642.6 | 12934.7 | 10869.0 |
| 2020-06-11 | BZ | Futures | 26.41 | 26.41 | 24.19 | 24.65 | 36881.0 |
| 2020-06-11 | C | Futures | 1782.0 | 1798.0 | 1754.0 | 1762.0 | 6021.0 |
| 2020-06-11 | CB | Futures | 221.493 | 223.339 | 217.24 | 218.899 | 54.0 |
| 2020-06-11 | CC | Futures | 1554.0 | 1563.0 | 1495.0 | 1503.0 | 26839.0 |
| 2020-06-11 | CNH | Futures | 6.9786 | 7.01 | 6.9781 | 7.0094 | 616.0 |
| 2020-06-11 | CSC | Futures | 3.562 | 3.562 | 3.461 | 3.476 | 11.0 |
| 2020-06-11 | CT | Futures | 58.68 | 58.98 | 57.85 | 58.51 | 21245.0 |
| 2020-06-11 | DC | Futures | 29.56 | 29.56 | 28.74 | 28.89 | 140.0 |
| 2020-06-11 | DX | Futures | 92.826 | 93.546 | 92.647 | 93.428 | 25342.0 |
| 2020-06-11 | E1 | Futures | 1.20706 | 1.21467 | 1.20388 | 1.2074 | 20645.0 |
| 2020-06-11 | E6 | Futures | 1.22356 | 1.22619 | 1.21396 | 1.21514 | 207094.0 |
| 2020-06-11 | E7 | Futures | 1.2175 | 1.22 | 1.2078 | 1.2091 | 3613.0 |
| 2020-06-11 | EBM | Futures | 220.65 | 220.95 | 218.26 | 218.56 | 17246.0 |
| 2020-06-11 | ED | Futures | 96.3798 | 96.3847 | 96.3412 | 96.3847 | 272016.0 |
| 2020-06-11 | ER | Futures | 98.318 | 98.323 | 98.318 | 98.323 | 61330.0 |
| 2020-06-11 | ESG | Futures | 270.88 | 270.88 | 270.88 | 270.88 | 306.0 |
| 2020-06-11 | EW | Futures | 1962.7 | 1962.7 | 1821.2 | 1824.1 | 15107.0 |
| 2020-06-11 | FBON | Futures | 142.67 | 143.11 | 142.42 | 143.04 | 366.0 |
| 2020-06-11 | FBTP | Futures | 127.07 | 127.8 | 126.88 | 127.65 | 110208.0 |
| 2020-06-11 | FBTS | Futures | 107.959 | 108.056 | 107.882 | 108.008 | 75014.0 |
| 2020-06-11 | FCE | Futures | 4802.5 | 4819.9 | 4592.2 | 4675.3 | 100597.0 |
| 2020-06-11 | FDAX | Futures | 13152.9 | 13215.3 | 12434.7 | 12721.9 | 136397.0 |
| 2020-06-11 | FDIV | Futures | 140.66 | 141.14 | 138.53 | 138.53 | 925.0 |
| 2020-06-11 | FDXM | Futures | 13166.3 | 13166.3 | 12436.9 | 12710.6 | 675.0 |
| 2020-06-11 | FESX | Futures | 2992.7 | 3005.6 | 2823.7 | 2887.4 | 237050.0 |
| 2020-06-11 | FEU3 | Futures | 99.07 | 99.07 | 99.07 | 99.07 | 100.0 |
| 2020-06-11 | FGBL | Futures | 166.52 | 167.53 | 166.36 | 167.43 | 598135.0 |
| 2020-06-11 | FGBM | Futures | 134.19 | 134.54 | 134.16 | 134.52 | 375243.0 |
| 2020-06-11 | FGBS | Futures | 112.639 | 112.734 | 112.639 | 112.724 | 293150.0 |
| 2020-06-11 | FGBX | Futures | 220.08 | 224.21 | 219.92 | 223.9 | 61327.0 |
| 2020-06-11 | FMWO | Futures | 7756.2 | 7756.2 | 7418.6 | 7611.5 | 10443.0 |
| 2020-06-11 | FOAT | Futures | 153.32 | 154.15 | 153.2 | 154.06 | 170637.0 |
| 2020-06-11 | FTI | Futures | 507.81 | 510.12 | 492.5 | 500.15 | 241.0 |
| 2020-06-11 | FTUK | Futures | 5878.3 | 5883.9 | 5600.4 | 5717.6 | 21876.0 |
| 2020-06-11 | FVSA | Futures | 285.01 | 378.66 | 282.75 | 310.8 | 39964.0 |
| 2020-06-11 | FXXP | Futures | 331.4 | 331.4 | 318.6 | 324.4 | 33842.0 |
| 2020-06-11 | G | Futures | 126.64 | 127.08 | 126.45 | 126.95 | 225508.0 |
> showing 50 of 117 rows — these rows as CSV