PREVIEW / futures_daily / 2020-04-22
file: by_date/futures_daily/2020/2020-04-22.parquet size: 10 KB rows: 119
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-04-22 | ES | Futures | 3028.73 | 3107.01 | 3006.6 | 3085.44 | 1369529.0 |
| 2020-04-22 | NQ | Futures | 9683.98 | 9974.03 | 9630.09 | 9902.95 | 373067.0 |
| 2020-04-22 | YM | Futures | 24516.6 | 25078.9 | 24344.8 | 24922.1 | 179294.0 |
| 2020-04-22 | CL | Futures | 9.77 | 12.05 | 7.64 | 10.26 | 1235218.0 |
| 2020-04-22 | GC | Futures | 2065.4 | 2113.0 | 2056.1 | 2108.1 | 193728.0 |
| 2020-04-22 | ZN | Futures | 137.732067 | 137.840116 | 137.145513 | 137.361612 | 954669.0 |
| 2020-04-22 | A6 | Futures | 0.646 | 0.65288 | 0.64497 | 0.6496 | 58777.0 |
| 2020-04-22 | AD | Futures | 0.71396 | 0.71816 | 0.71198 | 0.71457 | 54334.0 |
| 2020-04-22 | ALI | Futures | 1831.09 | 1845.14 | 1831.09 | 1845.14 | 56.0 |
| 2020-04-22 | B | Futures | 15.5 | 17.2 | 12.24 | 15.6 | 344764.0 |
| 2020-04-22 | B6 | Futures | 1.2492 | 1.2578 | 1.2464 | 1.2508 | 63782.0 |
| 2020-04-22 | BR | Futures | 0.15316 | 0.15403 | 0.14997 | 0.15132 | 3173.0 |
| 2020-04-22 | BTC | Futures | 9816.0 | 10206.1 | 9688.3 | 10092.6 | 3504.0 |
| 2020-04-22 | BZ | Futures | 14.53 | 16.69 | 11.89 | 15.14 | 51051.0 |
| 2020-04-22 | C | Futures | 1763.0 | 1846.0 | 1759.0 | 1844.0 | 3190.0 |
| 2020-04-22 | CB | Futures | 145.55 | 145.55 | 141.367 | 141.367 | 55.0 |
| 2020-04-22 | CC | Futures | 1527.0 | 1560.0 | 1516.0 | 1552.0 | 16508.0 |
| 2020-04-22 | CNH | Futures | 7.0456 | 7.0456 | 7.0282 | 7.0375 | 484.0 |
| 2020-04-22 | CSC | Futures | 2.116 | 2.222 | 2.099 | 2.186 | 155.0 |
| 2020-04-22 | CT | Futures | 50.77 | 54.21 | 50.35 | 54.19 | 3175.0 |
| 2020-04-22 | DC | Futures | 17.51 | 17.94 | 16.99 | 17.57 | 378.0 |
| 2020-04-22 | DX | Futures | 97.017 | 97.302 | 96.688 | 97.208 | 11260.0 |
| 2020-04-22 | E1 | Futures | 1.17611 | 1.17998 | 1.17201 | 1.17337 | 12371.0 |
| 2020-04-22 | E6 | Futures | 1.16816 | 1.17139 | 1.16247 | 1.16424 | 119418.0 |
| 2020-04-22 | E7 | Futures | 1.1623 | 1.1653 | 1.1564 | 1.1582 | 5799.0 |
| 2020-04-22 | EBM | Futures | 227.05 | 227.89 | 226.49 | 227.61 | 14887.0 |
| 2020-04-22 | ED | Futures | 96.2228 | 96.2469 | 96.2083 | 96.2373 | 238572.0 |
| 2020-04-22 | ER | Futures | 98.171 | 98.176 | 98.102 | 98.122 | 156788.0 |
| 2020-04-22 | ESG | Futures | 250.9 | 253.25 | 250.9 | 252.26 | 515.0 |
| 2020-04-22 | EW | Futures | 1573.9 | 1617.2 | 1571.6 | 1596.6 | 8841.0 |
| 2020-04-22 | FBON | Futures | 136.91 | 136.91 | 135.35 | 135.84 | 629.0 |
| 2020-04-22 | FBTP | Futures | 119.66 | 120.89 | 118.49 | 120.39 | 125667.0 |
| 2020-04-22 | FBTS | Futures | 105.642 | 106.027 | 105.334 | 105.873 | 79033.0 |
| 2020-04-22 | FCE | Futures | 4230.8 | 4261.3 | 4195.5 | 4245.8 | 33060.0 |
| 2020-04-22 | FDAX | Futures | 10846.7 | 11071.4 | 10813.3 | 11010.6 | 71440.0 |
| 2020-04-22 | FDIV | Futures | 114.96 | 115.56 | 114.96 | 115.56 | 4.0 |
| 2020-04-22 | FDXM | Futures | 10901.1 | 11122.2 | 10868.2 | 11063.2 | 46674.0 |
| 2020-04-22 | FESX | Futures | 2529.5 | 2580.0 | 2524.9 | 2569.9 | 956974.0 |
| 2020-04-22 | FGBL | Futures | 167.88 | 168.11 | 166.87 | 167.19 | 517771.0 |
| 2020-04-22 | FGBM | Futures | 134.56 | 134.65 | 134.25 | 134.35 | 256762.0 |
| 2020-04-22 | FGBS | Futures | 112.845 | 112.88 | 112.79 | 112.815 | 242662.0 |
| 2020-04-22 | FGBX | Futures | 226.95 | 227.8 | 224.15 | 225.21 | 43914.0 |
| 2020-04-22 | FMWO | Futures | 6743.3 | 6852.7 | 6743.3 | 6809.2 | 2450.0 |
| 2020-04-22 | FOAT | Futures | 151.22 | 151.37 | 150.51 | 150.8 | 119120.0 |
| 2020-04-22 | FTDX | Futures | 2897.1 | 2940.0 | 2895.1 | 2924.4 | 72.0 |
| 2020-04-22 | FTI | Futures | 465.26 | 477.54 | 463.99 | 474.09 | 25883.0 |
| 2020-04-22 | FTUK | Futures | 5326.3 | 5445.2 | 5294.3 | 5432.0 | 93486.0 |
| 2020-04-22 | FVSA | Futures | 367.28 | 372.68 | 353.78 | 359.18 | 7691.0 |
| 2020-04-22 | FXXP | Futures | 299.9 | 304.2 | 298.9 | 303.3 | 71542.0 |
| 2020-04-22 | G | Futures | 125.26 | 125.4 | 125.03 | 125.24 | 193909.0 |
> showing 50 of 119 rows — these rows as CSV