PREVIEW / futures_daily / 2020-03-10
file: by_date/futures_daily/2020/2020-03-10.parquet size: 10 KB rows: 112
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-03-10 | ES | Futures | 2951.68 | 3115.57 | 2910.91 | 3095.05 | 3423140.0 |
| 2020-03-10 | NQ | Futures | 9054.28 | 9610.59 | 8963.09 | 9556.39 | 982070.0 |
| 2020-03-10 | YM | Futures | 25075.7 | 26545.1 | 24851.7 | 26381.8 | 5149.0 |
| 2020-03-10 | CL | Futures | 31.01 | 35.76 | 30.84 | 35.08 | 1064632.0 |
| 2020-03-10 | GC | Futures | 2047.9 | 2049.9 | 2000.9 | 2024.3 | 385479.0 |
| 2020-03-10 | ZN | Futures | 137.268998 | 137.732067 | 135.401287 | 135.95697 | 3051818.0 |
| 2020-03-10 | A6 | Futures | 0.67672 | 0.67867 | 0.66367 | 0.66655 | 38041.0 |
| 2020-03-10 | AD | Futures | 0.73939 | 0.74441 | 0.73433 | 0.73727 | 47944.0 |
| 2020-03-10 | ALI | Futures | 2031.8 | 2057.38 | 2024.28 | 2039.33 | 216.0 |
| 2020-03-10 | B | Futures | 30.49 | 32.51 | 29.77 | 31.66 | 551292.0 |
| 2020-03-10 | B6 | Futures | 1.3299 | 1.3323 | 1.3087 | 1.3119 | 50303.0 |
| 2020-03-10 | BR | Futures | 0.17369 | 0.1757 | 0.17369 | 0.17439 | 1127.0 |
| 2020-03-10 | BTC | Futures | 11440.3 | 11936.7 | 11323.5 | 11673.9 | 5067.0 |
| 2020-03-10 | BZ | Futures | 27.7 | 31.64 | 27.69 | 30.82 | 67054.0 |
| 2020-03-10 | C | Futures | 1717.0 | 1745.0 | 1712.0 | 1740.0 | 12911.0 |
| 2020-03-10 | CB | Futures | 214.784 | 219.44 | 214.784 | 216.652 | 37.0 |
| 2020-03-10 | CC | Futures | 1665.0 | 1705.0 | 1660.0 | 1688.0 | 29838.0 |
| 2020-03-10 | CNH | Futures | 6.9119 | 6.921 | 6.888 | 6.9169 | 581.0 |
| 2020-03-10 | CSC | Futures | 3.154 | 3.163 | 3.137 | 3.139 | 121.0 |
| 2020-03-10 | CT | Futures | 59.93 | 60.57 | 58.74 | 59.12 | 19931.0 |
| 2020-03-10 | DC | Futures | 25.91 | 26.1 | 25.73 | 25.83 | 274.0 |
| 2020-03-10 | DX | Futures | 92.08 | 93.279 | 91.921 | 93.099 | 10294.0 |
| 2020-03-10 | E1 | Futures | 1.23692 | 1.23715 | 1.21597 | 1.21939 | 9026.0 |
| 2020-03-10 | E6 | Futures | 1.23523 | 1.23641 | 1.21648 | 1.21873 | 152792.0 |
| 2020-03-10 | E7 | Futures | 1.2288 | 1.2288 | 1.2103 | 1.2124 | 2638.0 |
| 2020-03-10 | EBM | Futures | 201.01 | 201.29 | 199.06 | 199.33 | 30626.0 |
| 2020-03-10 | ED | Futures | 96.2711 | 96.2856 | 96.1793 | 96.2228 | 508650.0 |
| 2020-03-10 | ER | Futures | 98.48 | 98.48 | 98.45 | 98.465 | 181216.0 |
| 2020-03-10 | EW | Futures | 1714.5 | 1783.5 | 1705.9 | 1783.5 | 25.0 |
| 2020-03-10 | FBON | Futures | 143.87 | 145.72 | 143.87 | 144.77 | 338.0 |
| 2020-03-10 | FBTP | Futures | 126.71 | 128.74 | 126.7 | 127.42 | 212423.0 |
| 2020-03-10 | FBTS | Futures | 106.874 | 107.48 | 106.854 | 107.143 | 138525.0 |
| 2020-03-10 | FCE | Futures | 4372.7 | 4452.7 | 4168.7 | 4191.3 | 279477.0 |
| 2020-03-10 | FDAX | Futures | 11135.7 | 11665.5 | 11013.6 | 11110.9 | 174845.0 |
| 2020-03-10 | FDXM | Futures | 11158.3 | 11716.2 | 11080.7 | 11170.5 | 935.0 |
| 2020-03-10 | FESX | Futures | 2620.4 | 2761.7 | 2587.4 | 2603.9 | 238857.0 |
| 2020-03-10 | FGBL | Futures | 172.59 | 172.94 | 170.51 | 172.62 | 1287347.0 |
| 2020-03-10 | FGBM | Futures | 136.31 | 136.58 | 135.98 | 136.47 | 593380.0 |
| 2020-03-10 | FGBS | Futures | 113.323 | 113.479 | 113.268 | 113.418 | 514359.0 |
| 2020-03-10 | FGBX | Futures | 245.08 | 247.54 | 238.25 | 246.2 | 76603.0 |
| 2020-03-10 | FMWO | Futures | 6906.2 | 6908.4 | 6584.1 | 6646.5 | 9346.0 |
| 2020-03-10 | FOAT | Futures | 156.87 | 156.96 | 155.78 | 156.54 | 262133.0 |
| 2020-03-10 | FTDX | Futures | 2659.0 | 2729.8 | 2649.9 | 2649.9 | 3.0 |
| 2020-03-10 | FTI | Futures | 470.55 | 477.77 | 450.25 | 452.51 | 159.0 |
| 2020-03-10 | FTUK | Futures | 5620.1 | 5779.0 | 5509.8 | 5557.8 | 1564.0 |
| 2020-03-10 | FVSA | Futures | 311.56 | 364.84 | 293.25 | 353.86 | 79496.0 |
| 2020-03-10 | FXXP | Futures | 310.5 | 318.5 | 302.4 | 304.2 | 15236.0 |
| 2020-03-10 | G | Futures | 126.24 | 126.61 | 125.03 | 126.36 | 446071.0 |
| 2020-03-10 | GF | Futures | 266.61 | 273.046 | 264.274 | 265.675 | 9807.0 |
| 2020-03-10 | GSCI | Futures | 340.34 | 341.67 | 336.5 | 341.67 | 2583.0 |
> showing 50 of 112 rows — these rows as CSV