PREVIEW / futures_daily / 2020-10-20
file: by_date/futures_daily/2020/2020-10-20.parquet size: 10 KB rows: 120
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-10-20 | ES | Futures | 3860.28 | 3898.2 | 3840.9 | 3856.07 | 1702183.0 |
| 2020-10-20 | NQ | Futures | 13542.3 | 13651.7 | 13427.69 | 13499.75 | 622702.0 |
| 2020-10-20 | YM | Futures | 30340.2 | 30645.9 | 30195.9 | 30340.2 | 170395.0 |
| 2020-10-20 | CL | Futures | 29.18 | 29.87 | 28.84 | 29.73 | 360574.0 |
| 2020-10-20 | GC | Futures | 2251.5 | 2264.7 | 2239.9 | 2262.1 | 163912.0 |
| 2020-10-20 | ZN | Futures | 137.691315 | 137.753303 | 137.520848 | 137.567339 | 1249462.0 |
| 2020-10-20 | A6 | Futures | 0.72527 | 0.72619 | 0.72085 | 0.72537 | 84504.0 |
| 2020-10-20 | AD | Futures | 0.76855 | 0.77342 | 0.76754 | 0.77245 | 68223.0 |
| 2020-10-20 | ALI | Futures | 2211.97 | 2211.97 | 2196.57 | 2196.87 | 27.0 |
| 2020-10-20 | B | Futures | 26.79 | 27.32 | 26.62 | 27.23 | 252053.0 |
| 2020-10-20 | B6 | Futures | 1.3125 | 1.3166 | 1.3092 | 1.3127 | 81551.0 |
| 2020-10-20 | BR | Futures | 0.14018 | 0.14152 | 0.13994 | 0.14065 | 235.0 |
| 2020-10-20 | BTC | Futures | 15848.2 | 16271.5 | 15774.3 | 16083.4 | 4060.0 |
| 2020-10-20 | BZ | Futures | 26.25 | 26.8 | 26.1 | 26.7 | 31677.0 |
| 2020-10-20 | C | Futures | 1479.0 | 1485.0 | 1458.0 | 1461.0 | 3142.0 |
| 2020-10-20 | CB | Futures | 162.877 | 162.877 | 159.573 | 159.573 | 28.0 |
| 2020-10-20 | CC | Futures | 1588.0 | 1589.0 | 1558.0 | 1564.0 | 12335.0 |
| 2020-10-20 | CNH | Futures | 6.5642 | 6.568 | 6.5419 | 6.5472 | 724.0 |
| 2020-10-20 | CSC | Futures | 3.791 | 3.849 | 3.76 | 3.767 | 51.0 |
| 2020-10-20 | CT | Futures | 70.14 | 70.81 | 69.47 | 70.19 | 18384.0 |
| 2020-10-20 | DC | Futures | 31.14 | 31.61 | 30.72 | 30.8 | 430.0 |
| 2020-10-20 | DX | Futures | 90.235 | 90.322 | 89.81 | 89.884 | 22350.0 |
| 2020-10-20 | E1 | Futures | 1.24522 | 1.25236 | 1.24488 | 1.25088 | 20681.0 |
| 2020-10-20 | E6 | Futures | 1.26177 | 1.26986 | 1.26118 | 1.2683 | 167607.0 |
| 2020-10-20 | E7 | Futures | 1.2556 | 1.2634 | 1.2548 | 1.2618 | 5913.0 |
| 2020-10-20 | EBM | Futures | 256.17 | 257.98 | 253.46 | 254.67 | 28224.0 |
| 2020-10-20 | ED | Futures | 96.4987 | 96.5035 | 96.4939 | 96.4987 | 125996.0 |
| 2020-10-20 | ER | Futures | 98.445 | 98.45 | 98.44 | 98.44 | 63751.0 |
| 2020-10-20 | ESG | Futures | 319.61 | 322.43 | 319.11 | 319.54 | 97.0 |
| 2020-10-20 | EW | Futures | 2118.2 | 2139.5 | 2106.1 | 2117.4 | 11672.0 |
| 2020-10-20 | FBON | Futures | 149.14 | 149.2 | 148.77 | 148.91 | 555.0 |
| 2020-10-20 | FBTP | Futures | 136.94 | 137.03 | 136.34 | 136.64 | 164153.0 |
| 2020-10-20 | FBTS | Futures | 109.653 | 109.682 | 109.537 | 109.633 | 94554.0 |
| 2020-10-20 | FCE | Futures | 4746.9 | 4801.0 | 4732.9 | 4761.9 | 48351.0 |
| 2020-10-20 | FDAX | Futures | 13630.5 | 13686.4 | 13543.0 | 13587.8 | 74470.0 |
| 2020-10-20 | FDIV | Futures | 147.39 | 147.39 | 146.92 | 146.92 | 20.0 |
| 2020-10-20 | FDXM | Futures | 13550.6 | 13617.4 | 13474.2 | 13519.3 | 46814.0 |
| 2020-10-20 | FESX | Futures | 2975.0 | 2999.1 | 2965.8 | 2982.4 | 699641.0 |
| 2020-10-20 | FEU3 | Futures | 99.178 | 99.183 | 99.178 | 99.183 | 300.0 |
| 2020-10-20 | FGBL | Futures | 171.26 | 171.4 | 170.83 | 170.98 | 586005.0 |
| 2020-10-20 | FGBM | Futures | 135.74 | 135.79 | 135.61 | 135.68 | 274991.0 |
| 2020-10-20 | FGBS | Futures | 112.925 | 112.93 | 112.89 | 112.915 | 561320.0 |
| 2020-10-20 | FGBX | Futures | 237.82 | 238.55 | 236.56 | 237.15 | 60132.0 |
| 2020-10-20 | FMWO | Futures | 8539.7 | 8591.8 | 8507.7 | 8529.0 | 2234.0 |
| 2020-10-20 | FOAT | Futures | 159.03 | 159.13 | 158.77 | 158.88 | 150243.0 |
| 2020-10-20 | FTDX | Futures | 3237.6 | 3237.6 | 3194.4 | 3198.0 | 21.0 |
| 2020-10-20 | FTI | Futures | 522.42 | 524.41 | 520.05 | 521.76 | 19166.0 |
| 2020-10-20 | FTUK | Futures | 5597.9 | 5631.3 | 5573.0 | 5613.6 | 68991.0 |
| 2020-10-20 | FVSA | Futures | 185.73 | 188.24 | 181.44 | 187.16 | 28350.0 |
| 2020-10-20 | FXXP | Futures | 337.2 | 339.7 | 336.5 | 338.1 | 36863.0 |
> showing 50 of 120 rows — these rows as CSV