PREVIEW / futures_daily / 2020-05-06
file: by_date/futures_daily/2020/2020-05-06.parquet size: 10 KB rows: 121
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-05-06 | ES | Futures | 3162.06 | 3193.59 | 3133.57 | 3135.23 | 1466641.0 |
| 2020-05-06 | NQ | Futures | 10235.99 | 10382.73 | 10177.81 | 10262.93 | 414045.0 |
| 2020-05-06 | YM | Futures | 25355.3 | 25603.9 | 25072.5 | 25089.6 | 179243.0 |
| 2020-05-06 | CL | Futures | 19.0 | 19.42 | 16.81 | 17.86 | 381165.0 |
| 2020-05-06 | GC | Futures | 2078.7 | 2081.8 | 2041.0 | 2047.7 | 203370.0 |
| 2020-05-06 | ZN | Futures | 137.114642 | 137.130077 | 136.58983 | 136.867672 | 1272785.0 |
| 2020-05-06 | A6 | Futures | 0.66069 | 0.66305 | 0.65689 | 0.65925 | 59107.0 |
| 2020-05-06 | AD | Futures | 0.72156 | 0.72262 | 0.71578 | 0.71761 | 42461.0 |
| 2020-05-06 | ALI | Futures | 1799.12 | 1800.31 | 1793.44 | 1794.64 | 35.0 |
| 2020-05-06 | B | Futures | 21.31 | 21.31 | 18.93 | 19.63 | 268457.0 |
| 2020-05-06 | B6 | Futures | 1.2631 | 1.2641 | 1.2522 | 1.2533 | 62311.0 |
| 2020-05-06 | BR | Futures | 0.14644 | 0.14661 | 0.14296 | 0.1439 | 3231.0 |
| 2020-05-06 | BTC | Futures | 12566.1 | 13233.7 | 12489.6 | 12990.3 | 6330.0 |
| 2020-05-06 | BZ | Futures | 20.38 | 20.77 | 18.33 | 19.0 | 37505.0 |
| 2020-05-06 | C | Futures | 1830.0 | 1839.0 | 1805.0 | 1820.0 | 2131.0 |
| 2020-05-06 | CB | Futures | 150.569 | 155.03 | 149.454 | 152.242 | 45.0 |
| 2020-05-06 | CC | Futures | 1547.0 | 1557.0 | 1524.0 | 1544.0 | 14587.0 |
| 2020-05-06 | CNH | Futures | 7.0571 | 7.0698 | 7.0394 | 7.0625 | 523.0 |
| 2020-05-06 | CSC | Futures | 2.659 | 2.688 | 2.631 | 2.648 | 184.0 |
| 2020-05-06 | CT | Futures | 52.25 | 53.66 | 51.86 | 53.14 | 13765.0 |
| 2020-05-06 | DC | Futures | 21.55 | 21.92 | 21.17 | 21.66 | 665.0 |
| 2020-05-06 | DX | Futures | 96.543 | 96.954 | 96.504 | 96.829 | 8857.0 |
| 2020-05-06 | E1 | Futures | 1.17224 | 1.17269 | 1.16814 | 1.16939 | 15360.0 |
| 2020-05-06 | E6 | Futures | 1.16607 | 1.16639 | 1.15967 | 1.16209 | 117816.0 |
| 2020-05-06 | E7 | Futures | 1.1595 | 1.1602 | 1.1537 | 1.1561 | 5730.0 |
| 2020-05-06 | EBM | Futures | 221.85 | 223.65 | 221.25 | 223.05 | 13617.0 |
| 2020-05-06 | ED | Futures | 96.3388 | 96.3533 | 96.3291 | 96.3388 | 267134.0 |
| 2020-05-06 | ER | Futures | 98.303 | 98.308 | 98.254 | 98.279 | 93473.0 |
| 2020-05-06 | ESG | Futures | 259.88 | 259.88 | 257.2 | 257.2 | 10.0 |
| 2020-05-06 | EW | Futures | 1700.1 | 1720.0 | 1678.2 | 1684.7 | 6632.0 |
| 2020-05-06 | FBON | Futures | 139.79 | 139.85 | 139.12 | 139.12 | 58.0 |
| 2020-05-06 | FBTP | Futures | 122.5 | 123.11 | 121.47 | 121.7 | 81113.0 |
| 2020-05-06 | FBTS | Futures | 106.816 | 106.97 | 106.585 | 106.623 | 69943.0 |
| 2020-05-06 | FCE | Futures | 4317.0 | 4339.3 | 4257.0 | 4285.5 | 33882.0 |
| 2020-05-06 | FDAX | Futures | 11251.7 | 11397.2 | 11142.3 | 11231.6 | 65114.0 |
| 2020-05-06 | FDIV | Futures | 120.34 | 120.34 | 119.32 | 119.32 | 171.0 |
| 2020-05-06 | FDXM | Futures | 11301.8 | 11451.6 | 11201.9 | 11285.3 | 50006.0 |
| 2020-05-06 | FESX | Futures | 2592.9 | 2623.1 | 2569.0 | 2588.3 | 826980.0 |
| 2020-05-06 | FEU3 | Futures | 99.021 | 99.021 | 98.991 | 99.011 | 102.0 |
| 2020-05-06 | FGBL | Futures | 169.28 | 169.36 | 168.35 | 168.45 | 599719.0 |
| 2020-05-06 | FGBM | Futures | 135.23 | 135.31 | 134.97 | 135.0 | 378570.0 |
| 2020-05-06 | FGBS | Futures | 113.041 | 113.056 | 112.956 | 112.971 | 350064.0 |
| 2020-05-06 | FGBX | Futures | 229.98 | 230.13 | 226.21 | 226.78 | 49955.0 |
| 2020-05-06 | FMWO | Futures | 7029.2 | 7045.7 | 6945.7 | 6988.0 | 1384.0 |
| 2020-05-06 | FOAT | Futures | 153.25 | 153.38 | 152.27 | 152.4 | 116325.0 |
| 2020-05-06 | FTDX | Futures | 2930.9 | 2930.9 | 2917.8 | 2917.8 | 32.0 |
| 2020-05-06 | FTI | Futures | 474.68 | 477.91 | 470.37 | 472.75 | 18644.0 |
| 2020-05-06 | FTUK | Futures | 5472.5 | 5562.1 | 5439.0 | 5498.9 | 78369.0 |
| 2020-05-06 | FVSA | Futures | 313.27 | 315.52 | 303.82 | 313.27 | 11644.0 |
| 2020-05-06 | FXXP | Futures | 307.6 | 310.6 | 305.7 | 307.7 | 62784.0 |
> showing 50 of 121 rows — these rows as CSV