PREVIEW / futures_daily / 2020-03-11
file: by_date/futures_daily/2020/2020-03-11.parquet size: 10 KB rows: 113
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-03-11 | ES | Futures | 3088.3 | 3099.1 | 2919.01 | 2959.51 | 2992894.0 |
| 2020-03-11 | NQ | Futures | 9539.76 | 9559.54 | 9053.14 | 9180.17 | 990236.0 |
| 2020-03-11 | YM | Futures | 26373.3 | 26373.3 | 24726.8 | 25012.8 | 8193.0 |
| 2020-03-11 | CL | Futures | 35.35 | 37.12 | 33.25 | 33.67 | 874646.0 |
| 2020-03-11 | GC | Futures | 2010.9 | 2038.4 | 1990.3 | 2002.4 | 404351.0 |
| 2020-03-11 | ZN | Futures | 135.648257 | 136.913978 | 135.354981 | 135.725435 | 2719666.0 |
| 2020-03-11 | A6 | Futures | 0.66829 | 0.67158 | 0.66562 | 0.66696 | 119970.0 |
| 2020-03-11 | AD | Futures | 0.73752 | 0.74036 | 0.73438 | 0.73575 | 54879.0 |
| 2020-03-11 | ALI | Futures | 2028.79 | 2035.71 | 2027.89 | 2033.31 | 326.0 |
| 2020-03-11 | B | Futures | 31.7 | 33.77 | 30.07 | 30.44 | 471772.0 |
| 2020-03-11 | B6 | Futures | 1.3084 | 1.3185 | 1.3011 | 1.3047 | 84514.0 |
| 2020-03-11 | BR | Futures | 0.17496 | 0.17496 | 0.17181 | 0.17181 | 128.0 |
| 2020-03-11 | BTC | Futures | 11666.6 | 11717.7 | 11111.8 | 11469.5 | 3910.0 |
| 2020-03-11 | BZ | Futures | 31.3 | 32.8 | 29.28 | 29.63 | 60513.0 |
| 2020-03-11 | C | Futures | 1750.0 | 1783.0 | 1741.0 | 1772.0 | 12826.0 |
| 2020-03-11 | CB | Futures | 217.265 | 217.265 | 215.286 | 216.206 | 66.0 |
| 2020-03-11 | CC | Futures | 1706.0 | 1731.0 | 1690.0 | 1719.0 | 22809.0 |
| 2020-03-11 | CNH | Futures | 6.9169 | 6.9197 | 6.9047 | 6.9188 | 276.0 |
| 2020-03-11 | CSC | Futures | 3.143 | 3.143 | 3.128 | 3.128 | 61.0 |
| 2020-03-11 | CT | Futures | 59.12 | 59.63 | 59.03 | 59.26 | 14480.0 |
| 2020-03-11 | DC | Futures | 25.86 | 25.86 | 25.67 | 25.73 | 114.0 |
| 2020-03-11 | DX | Futures | 93.033 | 93.347 | 92.646 | 93.257 | 10276.0 |
| 2020-03-11 | E1 | Futures | 1.21529 | 1.22679 | 1.21529 | 1.2195 | 22109.0 |
| 2020-03-11 | E6 | Futures | 1.21793 | 1.22609 | 1.21449 | 1.21701 | 315574.0 |
| 2020-03-11 | E7 | Futures | 1.2116 | 1.2196 | 1.2081 | 1.2107 | 7951.0 |
| 2020-03-11 | EBM | Futures | 199.61 | 199.76 | 197.94 | 198.5 | 33421.0 |
| 2020-03-11 | ED | Futures | 96.1889 | 96.3146 | 96.1841 | 96.2711 | 639036.0 |
| 2020-03-11 | ER | Futures | 98.455 | 98.509 | 98.455 | 98.489 | 172405.0 |
| 2020-03-11 | EW | Futures | 1745.6 | 1745.6 | 1664.3 | 1664.3 | 611.0 |
| 2020-03-11 | FBON | Futures | 144.67 | 146.18 | 144.61 | 146.08 | 406.0 |
| 2020-03-11 | FBTP | Futures | 127.77 | 129.82 | 127.54 | 129.49 | 156973.0 |
| 2020-03-11 | FBTS | Futures | 107.124 | 107.653 | 107.124 | 107.585 | 89377.0 |
| 2020-03-11 | FCE | Futures | 4196.3 | 4310.7 | 4076.0 | 4167.4 | 235960.0 |
| 2020-03-11 | FDAX | Futures | 11318.1 | 11376.3 | 10792.5 | 11005.6 | 149493.0 |
| 2020-03-11 | FDXM | Futures | 11374.0 | 11432.5 | 10851.2 | 11063.2 | 1527.0 |
| 2020-03-11 | FESX | Futures | 2661.7 | 2681.0 | 2531.4 | 2589.2 | 266432.0 |
| 2020-03-11 | FEU3 | Futures | 99.228 | 99.228 | 99.228 | 99.228 | 100.0 |
| 2020-03-11 | FGBL | Futures | 172.12 | 172.94 | 171.61 | 171.83 | 1013470.0 |
| 2020-03-11 | FGBM | Futures | 136.28 | 136.63 | 136.18 | 136.28 | 482695.0 |
| 2020-03-11 | FGBS | Futures | 113.408 | 113.509 | 113.353 | 113.418 | 424367.0 |
| 2020-03-11 | FGBX | Futures | 244.38 | 247.71 | 242.47 | 245.36 | 93723.0 |
| 2020-03-11 | FMWO | Futures | 6724.7 | 6766.7 | 6526.3 | 6620.4 | 7144.0 |
| 2020-03-11 | FOAT | Futures | 156.54 | 157.08 | 155.76 | 156.63 | 299438.0 |
| 2020-03-11 | FTDX | Futures | 2618.5 | 2627.6 | 2618.5 | 2627.6 | 1.0 |
| 2020-03-11 | FTI | Futures | 455.55 | 463.9 | 445.92 | 452.3 | 268.0 |
| 2020-03-11 | FTUK | Futures | 5632.8 | 5659.7 | 5355.6 | 5439.0 | 4439.0 |
| 2020-03-11 | FVSA | Futures | 370.53 | 390.87 | 346.13 | 367.28 | 56897.0 |
| 2020-03-11 | FXXP | Futures | 311.3 | 311.3 | 298.9 | 300.5 | 4003.0 |
| 2020-03-11 | G | Futures | 125.98 | 126.06 | 125.33 | 125.65 | 392045.0 |
| 2020-03-11 | GF | Futures | 264.377 | 265.675 | 256.331 | 256.487 | 6355.0 |
> showing 50 of 113 rows — these rows as CSV