PREVIEW / futures_daily / 2021-08-12
file: by_date/futures_daily/2021/2021-08-12.parquet size: 10 KB rows: 122
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-12 | ES | Futures | 4990.89 | 5009.15 | 4979.93 | 5007.19 | 850527.0 |
| 2021-08-12 | NQ | Futures | 17315.11 | 17409.71 | 17237.53 | 17395.87 | 384239.0 |
| 2021-08-12 | YM | Futures | 38364.3 | 38426.1 | 38227.7 | 38387.1 | 109900.0 |
| 2021-08-12 | CL | Futures | 50.2 | 50.39 | 49.55 | 50.01 | 352465.0 |
| 2021-08-12 | GC | Futures | 2045.0 | 2052.8 | 2033.0 | 2043.7 | 137119.0 |
| 2021-08-12 | ZN | Futures | 135.211711 | 135.401482 | 135.02194 | 135.069383 | 956949.0 |
| 2021-08-12 | A6 | Futures | 0.75644 | 0.75664 | 0.75198 | 0.75203 | 51673.0 |
| 2021-08-12 | AD | Futures | 0.81058 | 0.81094 | 0.80886 | 0.80906 | 49379.0 |
| 2021-08-12 | ALI | Futures | 2992.15 | 3003.28 | 2960.16 | 2965.3 | 1743.0 |
| 2021-08-12 | B | Futures | 47.66 | 47.88 | 47.07 | 47.49 | 224987.0 |
| 2021-08-12 | B6 | Futures | 1.4079 | 1.4092 | 1.4006 | 1.4013 | 61844.0 |
| 2021-08-12 | BR | Futures | 0.15366 | 0.15366 | 0.15174 | 0.15194 | 6072.0 |
| 2021-08-12 | BTC | Futures | 62103.0 | 62103.0 | 58703.9 | 59481.6 | 5190.0 |
| 2021-08-12 | BZ | Futures | 46.53 | 46.73 | 45.94 | 46.35 | 22952.0 |
| 2021-08-12 | C | Futures | 1494.0 | 1497.0 | 1485.0 | 1486.0 | 9081.0 |
| 2021-08-12 | CC | Futures | 1661.0 | 1671.0 | 1653.0 | 1658.0 | 36519.0 |
| 2021-08-12 | CNH | Futures | 6.2617 | 6.2672 | 6.2615 | 6.2626 | 355.0 |
| 2021-08-12 | CSC | Futures | 2.5 | 2.503 | 2.45 | 2.457 | 79.0 |
| 2021-08-12 | CT | Futures | 84.89 | 87.03 | 84.68 | 86.72 | 32.0 |
| 2021-08-12 | DC | Futures | 22.49 | 22.5 | 21.96 | 22.07 | 206.0 |
| 2021-08-12 | DX | Futures | 89.801 | 89.936 | 89.743 | 89.929 | 14188.0 |
| 2021-08-12 | E1 | Futures | 1.21965 | 1.21999 | 1.21628 | 1.2164 | 15574.0 |
| 2021-08-12 | E6 | Futures | 1.24967 | 1.25036 | 1.2477 | 1.24839 | 112289.0 |
| 2021-08-12 | E7 | Futures | 1.2436 | 1.2441 | 1.2414 | 1.2422 | 2279.0 |
| 2021-08-12 | EBM | Futures | 349.38 | 362.99 | 347.91 | 361.52 | 26223.0 |
| 2021-08-12 | ED | Futures | 96.5393 | 96.5442 | 96.5393 | 96.5393 | 37596.0 |
| 2021-08-12 | ER | Futures | 98.465 | 98.47 | 98.465 | 98.465 | 19971.0 |
| 2021-08-12 | ESG | Futures | 411.77 | 413.88 | 411.47 | 413.79 | 491.0 |
| 2021-08-12 | EW | Futures | 2942.2 | 2946.9 | 2920.5 | 2935.7 | 6420.0 |
| 2021-08-12 | FBON | Futures | 151.48 | 151.93 | 151.45 | 151.71 | 36.0 |
| 2021-08-12 | FBTP | Futures | 141.54 | 141.95 | 141.52 | 141.85 | 86770.0 |
| 2021-08-12 | FBTS | Futures | 110.487 | 110.507 | 110.468 | 110.497 | 24644.0 |
| 2021-08-12 | FCE | Futures | 6843.1 | 6877.9 | 6836.5 | 6868.4 | 4611.0 |
| 2021-08-12 | FDAX | Futures | 16979.1 | 17104.4 | 16929.8 | 17072.3 | 59615.0 |
| 2021-08-12 | FDIV | Futures | 188.09 | 189.66 | 188.09 | 189.66 | 15.0 |
| 2021-08-12 | FDXM | Futures | 16882.0 | 17019.5 | 16845.8 | 16987.6 | 37323.0 |
| 2021-08-12 | FDXS | Futures | 16780.1 | 16910.4 | 16739.8 | 16879.6 | 6921.0 |
| 2021-08-12 | FESX | Futures | 3988.7 | 4009.6 | 3978.3 | 4003.9 | 490039.0 |
| 2021-08-12 | FGBL | Futures | 171.23 | 171.24 | 170.83 | 171.05 | 416083.0 |
| 2021-08-12 | FGBM | Futures | 135.78 | 135.79 | 135.67 | 135.72 | 247355.0 |
| 2021-08-12 | FGBS | Futures | 112.759 | 112.764 | 112.734 | 112.744 | 127684.0 |
| 2021-08-12 | FGBX | Futures | 231.55 | 231.76 | 230.57 | 231.4 | 55548.0 |
| 2021-08-12 | FMWO | Futures | 10981.9 | 11007.7 | 10953.7 | 10980.7 | 1860.0 |
| 2021-08-12 | FOAT | Futures | 158.37 | 158.37 | 158.04 | 158.27 | 123067.0 |
| 2021-08-12 | FTDX | Futures | 3880.0 | 3939.0 | 3880.0 | 3932.9 | 110.0 |
| 2021-08-12 | FTI | Futures | 740.14 | 742.37 | 738.9 | 739.82 | 271.0 |
| 2021-08-12 | FTUK | Futures | 7061.6 | 7071.0 | 7037.5 | 7049.3 | 69762.0 |
| 2021-08-12 | FVSA | Futures | 77.12 | 77.31 | 74.01 | 74.98 | 28206.0 |
| 2021-08-12 | FXXP | Futures | 450.3 | 451.7 | 450.1 | 451.3 | 32100.0 |
| 2021-08-12 | G | Futures | 123.86 | 123.94 | 123.45 | 123.61 | 194586.0 |
> showing 50 of 122 rows — these rows as CSV