PREVIEW / futures_daily / 2020-11-16
file: by_date/futures_daily/2020/2020-11-16.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-11-16 | ES | Futures | 4029.93 | 4086.1 | 4029.36 | 4070.37 | 1303941.0 |
| 2020-11-16 | NQ | Futures | 13843.02 | 13967.76 | 13720.88 | 13898.3 | 471101.0 |
| 2020-11-16 | YM | Futures | 31689.1 | 32295.2 | 31689.1 | 32152.0 | 164292.0 |
| 2020-11-16 | CL | Futures | 28.76 | 30.12 | 28.74 | 29.57 | 238437.0 |
| 2020-11-16 | GC | Futures | 2228.1 | 2241.6 | 2198.5 | 2229.5 | 222937.0 |
| 2020-11-16 | ZN | Futures | 136.947457 | 137.117924 | 136.715001 | 136.900966 | 1254900.0 |
| 2020-11-16 | A6 | Futures | 0.74611 | 0.75227 | 0.74611 | 0.75093 | 74603.0 |
| 2020-11-16 | AD | Futures | 0.77169 | 0.7757 | 0.77129 | 0.77392 | 51357.0 |
| 2020-11-16 | ALI | Futures | 2298.45 | 2320.85 | 2298.45 | 2319.37 | 222.0 |
| 2020-11-16 | B | Futures | 26.91 | 28.15 | 26.91 | 27.61 | 268433.0 |
| 2020-11-16 | B6 | Futures | 1.3382 | 1.3429 | 1.3351 | 1.3377 | 73644.0 |
| 2020-11-16 | BR | Futures | 0.14356 | 0.14651 | 0.14356 | 0.14462 | 10425.0 |
| 2020-11-16 | BTC | Futures | 21161.8 | 22349.6 | 21003.5 | 22296.8 | 5400.0 |
| 2020-11-16 | BZ | Futures | 26.36 | 27.56 | 26.3 | 27.03 | 37770.0 |
| 2020-11-16 | C | Futures | 1439.0 | 1475.0 | 1437.0 | 1474.0 | 4445.0 |
| 2020-11-16 | CB | Futures | 151.951 | 151.951 | 149.816 | 150.146 | 31.0 |
| 2020-11-16 | CC | Futures | 1583.0 | 1619.0 | 1581.0 | 1600.0 | 27185.0 |
| 2020-11-16 | CNH | Futures | 6.4744 | 6.4744 | 6.4416 | 6.4502 | 1110.0 |
| 2020-11-16 | CSC | Futures | 3.39 | 3.39 | 3.225 | 3.24 | 179.0 |
| 2020-11-16 | CT | Futures | 67.6 | 69.18 | 67.6 | 68.75 | 14210.0 |
| 2020-11-16 | DC | Futures | 27.81 | 28.06 | 26.52 | 26.66 | 1171.0 |
| 2020-11-16 | DX | Futures | 89.559 | 89.69 | 89.289 | 89.477 | 29487.0 |
| 2020-11-16 | E1 | Futures | 1.24148 | 1.24556 | 1.23831 | 1.24137 | 16756.0 |
| 2020-11-16 | E6 | Futures | 1.269 | 1.27227 | 1.26627 | 1.26938 | 124456.0 |
| 2020-11-16 | E7 | Futures | 1.2626 | 1.2657 | 1.2599 | 1.2629 | 6593.0 |
| 2020-11-16 | EBM | Futures | 252.56 | 252.86 | 251.05 | 252.26 | 13681.0 |
| 2020-11-16 | ED | Futures | 96.4866 | 96.489 | 96.4842 | 96.489 | 117708.0 |
| 2020-11-16 | ER | Futures | 98.45 | 98.46 | 98.45 | 98.455 | 81281.0 |
| 2020-11-16 | ESG | Futures | 335.21 | 335.75 | 333.45 | 335.55 | 603.0 |
| 2020-11-16 | EW | Futures | 2267.4 | 2314.4 | 2265.5 | 2301.9 | 13332.0 |
| 2020-11-16 | FBON | Futures | 150.08 | 150.18 | 149.61 | 150.0 | 425.0 |
| 2020-11-16 | FBTP | Futures | 138.06 | 138.27 | 137.72 | 138.18 | 111446.0 |
| 2020-11-16 | FBTS | Futures | 109.952 | 110.0 | 109.904 | 110.0 | 85128.0 |
| 2020-11-16 | FCE | Futures | 5301.7 | 5375.9 | 5260.3 | 5327.6 | 16771.0 |
| 2020-11-16 | FDAX | Futures | 14037.7 | 14153.4 | 13930.6 | 14028.7 | 74080.0 |
| 2020-11-16 | FDIV | Futures | 156.02 | 156.07 | 156.02 | 156.07 | 100.0 |
| 2020-11-16 | FDXM | Futures | 13953.7 | 14078.9 | 13861.4 | 13957.9 | 50421.0 |
| 2020-11-16 | FESX | Futures | 3196.0 | 3231.1 | 3176.6 | 3208.0 | 1042736.0 |
| 2020-11-16 | FGBL | Futures | 170.13 | 170.47 | 169.65 | 170.12 | 679267.0 |
| 2020-11-16 | FGBM | Futures | 135.26 | 135.37 | 135.1 | 135.23 | 339174.0 |
| 2020-11-16 | FGBS | Futures | 112.795 | 112.81 | 112.754 | 112.775 | 331328.0 |
| 2020-11-16 | FGBX | Futures | 234.14 | 235.67 | 232.55 | 234.66 | 67306.0 |
| 2020-11-16 | FMWO | Futures | 8967.3 | 9051.4 | 8967.3 | 9021.8 | 5213.0 |
| 2020-11-16 | FOAT | Futures | 158.74 | 158.99 | 158.27 | 158.75 | 135741.0 |
| 2020-11-16 | FTDX | Futures | 3143.5 | 3156.8 | 3114.1 | 3120.3 | 126.0 |
| 2020-11-16 | FTI | Futures | 563.96 | 564.24 | 558.21 | 561.97 | 4859.0 |
| 2020-11-16 | FTUK | Futures | 6072.9 | 6166.6 | 6038.5 | 6134.6 | 105488.0 |
| 2020-11-16 | FVSA | Futures | 160.6 | 165.04 | 156.9 | 160.23 | 28051.0 |
| 2020-11-16 | FXXP | Futures | 359.9 | 362.6 | 357.4 | 361.2 | 83703.0 |
| 2020-11-16 | G | Futures | 125.64 | 125.76 | 125.08 | 125.48 | 211085.0 |
> showing 50 of 120 rows — these rows as CSV