PREVIEW / futures_daily / 2020-11-11
file: by_date/futures_daily/2020/2020-11-11.parquet size: 10 KB rows: 118
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-11 | ES | Futures | 3984.14 | 4018.41 | 3967.01 | 4008.58 | 1324983.0 |
| 2020-11-11 | NQ | Futures | 13466.76 | 13797.29 | 13400.77 | 13760.53 | 546218.0 |
| 2020-11-11 | YM | Futures | 31608.4 | 31834.4 | 31418.9 | 31555.6 | 167386.0 |
| 2020-11-11 | CL | Futures | 29.79 | 30.69 | 29.45 | 29.55 | 443772.0 |
| 2020-11-11 | GC | Futures | 2215.7 | 2223.3 | 2189.5 | 2198.6 | 215170.0 |
| 2020-11-11 | ZN | Futures | 136.374066 | 136.544533 | 136.126113 | 136.482545 | 553673.0 |
| 2020-11-11 | A6 | Futures | 0.74806 | 0.75145 | 0.74539 | 0.74703 | 75966.0 |
| 2020-11-11 | AD | Futures | 0.77777 | 0.77909 | 0.77499 | 0.77549 | 48037.0 |
| 2020-11-11 | ALI | Futures | 2291.05 | 2291.05 | 2280.68 | 2283.35 | 46.0 |
| 2020-11-11 | B | Futures | 27.58 | 28.54 | 27.47 | 27.6 | 346768.0 |
| 2020-11-11 | B6 | Futures | 1.3458 | 1.3512 | 1.3379 | 1.34 | 94660.0 |
| 2020-11-11 | BR | Futures | 0.14513 | 0.14627 | 0.14407 | 0.14529 | 7080.0 |
| 2020-11-11 | BTC | Futures | 20389.8 | 21234.4 | 20257.8 | 20858.3 | 6198.0 |
| 2020-11-11 | BZ | Futures | 27.11 | 27.95 | 26.9 | 27.02 | 43047.0 |
| 2020-11-11 | C | Futures | 1431.0 | 1436.0 | 1418.0 | 1421.0 | 2438.0 |
| 2020-11-11 | CB | Futures | 155.508 | 155.508 | 154.009 | 154.847 | 24.0 |
| 2020-11-11 | CC | Futures | 1566.0 | 1581.0 | 1554.0 | 1560.0 | 15841.0 |
| 2020-11-11 | CNH | Futures | 6.4763 | 6.5031 | 6.4575 | 6.4942 | 1013.0 |
| 2020-11-11 | CSC | Futures | 3.831 | 3.871 | 3.63 | 3.644 | 209.0 |
| 2020-11-11 | CT | Futures | 69.12 | 69.55 | 68.44 | 68.47 | 22323.0 |
| 2020-11-11 | DC | Futures | 31.77 | 32.16 | 29.93 | 30.13 | 759.0 |
| 2020-11-11 | DX | Futures | 89.574 | 90.018 | 89.443 | 89.858 | 23547.0 |
| 2020-11-11 | E1 | Futures | 1.23888 | 1.24013 | 1.23288 | 1.23548 | 18791.0 |
| 2020-11-11 | E6 | Futures | 1.26681 | 1.26847 | 1.25904 | 1.26215 | 138880.0 |
| 2020-11-11 | E7 | Futures | 1.2605 | 1.2619 | 1.2527 | 1.2558 | 8042.0 |
| 2020-11-11 | EBM | Futures | 256.78 | 257.08 | 254.37 | 254.67 | 26687.0 |
| 2020-11-11 | ED | Futures | 96.4939 | 96.4939 | 96.4745 | 96.4745 | 237649.0 |
| 2020-11-11 | ER | Futures | 98.45 | 98.455 | 98.445 | 98.45 | 167729.0 |
| 2020-11-11 | ESG | Futures | 329.48 | 331.6 | 329.28 | 330.95 | 485.0 |
| 2020-11-11 | EW | Futures | 2257.9 | 2268.0 | 2233.1 | 2248.8 | 9623.0 |
| 2020-11-11 | FBON | Futures | 148.6 | 149.53 | 148.6 | 149.22 | 471.0 |
| 2020-11-11 | FBTP | Futures | 136.71 | 137.5 | 136.58 | 137.19 | 137620.0 |
| 2020-11-11 | FBTS | Futures | 109.798 | 109.933 | 109.788 | 109.855 | 108978.0 |
| 2020-11-11 | FCE | Futures | 5240.0 | 5284.5 | 5227.4 | 5264.2 | 62456.0 |
| 2020-11-11 | FDAX | Futures | 13988.2 | 14115.6 | 13958.3 | 14100.7 | 70016.0 |
| 2020-11-11 | FDIV | Futures | 155.36 | 156.07 | 155.36 | 156.07 | 200.0 |
| 2020-11-11 | FDXM | Futures | 13918.7 | 14044.9 | 13885.8 | 14029.5 | 58231.0 |
| 2020-11-11 | FESX | Futures | 3171.0 | 3208.9 | 3162.7 | 3206.2 | 1041962.0 |
| 2020-11-11 | FEU3 | Futures | 99.183 | 99.188 | 99.183 | 99.188 | 50.0 |
| 2020-11-11 | FGBL | Futures | 169.23 | 169.7 | 168.89 | 169.51 | 653875.0 |
| 2020-11-11 | FGBM | Futures | 135.04 | 135.16 | 134.93 | 135.09 | 403124.0 |
| 2020-11-11 | FGBS | Futures | 112.764 | 112.78 | 112.744 | 112.759 | 403297.0 |
| 2020-11-11 | FGBX | Futures | 230.38 | 232.24 | 229.09 | 231.53 | 75809.0 |
| 2020-11-11 | FMWO | Futures | 8822.8 | 8919.9 | 8808.6 | 8908.1 | 5191.0 |
| 2020-11-11 | FOAT | Futures | 157.53 | 158.24 | 157.49 | 158.06 | 143841.0 |
| 2020-11-11 | FTDX | Futures | 3042.6 | 3120.8 | 3029.3 | 3112.6 | 366.0 |
| 2020-11-11 | FTI | Futures | 554.19 | 560.08 | 550.22 | 559.23 | 220.0 |
| 2020-11-11 | FTUK | Futures | 5966.4 | 6096.3 | 5963.5 | 6092.5 | 134018.0 |
| 2020-11-11 | FVSA | Futures | 169.63 | 172.49 | 162.83 | 163.19 | 25398.0 |
| 2020-11-11 | FXXP | Futures | 356.0 | 360.1 | 356.0 | 359.9 | 86448.0 |
> showing 50 of 118 rows — these rows as CSV