PREVIEW / futures_daily / 2019-02-20
file: by_date/futures_daily/2019/2019-02-20.parquet size: 10 KB rows: 116
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-20 | ES | Futures | 3007.39 | 3021.46 | 3002.51 | 3017.4 | 1284923.0 |
| 2019-02-20 | NQ | Futures | 8183.87 | 8225.84 | 8141.61 | 8189.08 | 418267.0 |
| 2019-02-20 | YM | Futures | 27297.5 | 27408.2 | 27239.4 | 27386.1 | 187898.0 |
| 2019-02-20 | CL | Futures | 58.29 | 59.54 | 57.65 | 59.09 | 685111.0 |
| 2019-02-20 | GC | Futures | 1679.9 | 1687.2 | 1674.7 | 1684.9 | 246722.0 |
| 2019-02-20 | ZN | Futures | 121.798271 | 121.876078 | 121.642658 | 121.658219 | 1418484.0 |
| 2019-02-20 | A6 | Futures | 0.73816 | 0.74033 | 0.7361 | 0.7393 | 90183.0 |
| 2019-02-20 | AD | Futures | 0.76663 | 0.77043 | 0.76653 | 0.77012 | 71015.0 |
| 2019-02-20 | B | Futures | 48.07 | 48.85 | 47.58 | 48.63 | 276479.0 |
| 2019-02-20 | B6 | Futures | 1.3431 | 1.3478 | 1.3378 | 1.3428 | 146993.0 |
| 2019-02-20 | BR | Futures | 0.21504 | 0.21596 | 0.21229 | 0.21464 | 2520.0 |
| 2019-02-20 | BTC | Futures | 5765.2 | 5846.2 | 5706.2 | 5802.0 | 5226.0 |
| 2019-02-20 | BZ | Futures | 47.61 | 48.33 | 47.08 | 48.12 | 29155.0 |
| 2019-02-20 | C | Futures | 1558.0 | 1560.0 | 1541.0 | 1546.0 | 3007.0 |
| 2019-02-20 | CB | Futures | 275.403 | 275.403 | 274.536 | 274.686 | 18.0 |
| 2019-02-20 | CC | Futures | 1589.0 | 1592.0 | 1548.0 | 1564.0 | 25839.0 |
| 2019-02-20 | CNH | Futures | 6.7481 | 6.7546 | 6.7198 | 6.7265 | 1175.0 |
| 2019-02-20 | CSC | Futures | 2.801 | 2.803 | 2.76 | 2.764 | 142.0 |
| 2019-02-20 | CT | Futures | 76.58 | 77.18 | 76.47 | 76.56 | 8618.0 |
| 2019-02-20 | DC | Futures | 23.59 | 23.78 | 23.35 | 23.41 | 295.0 |
| 2019-02-20 | DX | Futures | 91.875 | 92.027 | 91.67 | 91.835 | 19013.0 |
| 2019-02-20 | E1 | Futures | 1.17701 | 1.18066 | 1.17619 | 1.17819 | 18098.0 |
| 2019-02-20 | E6 | Futures | 1.25547 | 1.25923 | 1.25398 | 1.25685 | 175231.0 |
| 2019-02-20 | E7 | Futures | 1.2494 | 1.2529 | 1.2477 | 1.2507 | 4144.0 |
| 2019-02-20 | EBM | Futures | 199.46 | 200.23 | 195.35 | 198.17 | 28577.0 |
| 2019-02-20 | ED | Futures | 95.0965 | 95.1062 | 95.0867 | 95.1038 | 341126.0 |
| 2019-02-20 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.401 | 13124.0 |
| 2019-02-20 | EW | Futures | 2040.2 | 2054.4 | 2038.2 | 2050.2 | 16436.0 |
| 2019-02-20 | FBON | Futures | 132.21 | 132.3 | 132.2 | 132.26 | 288.0 |
| 2019-02-20 | FBTP | Futures | 111.71 | 111.91 | 111.13 | 111.35 | 108479.0 |
| 2019-02-20 | FBTS | Futures | 105.152 | 105.237 | 104.954 | 105.029 | 56058.0 |
| 2019-02-20 | FCE | Futures | 4608.5 | 4643.3 | 4599.6 | 4633.0 | 61559.0 |
| 2019-02-20 | FDAX | Futures | 11890.4 | 12026.0 | 11866.2 | 11986.6 | 104859.0 |
| 2019-02-20 | FDIV | Futures | 139.84 | 140.74 | 139.84 | 140.74 | 5.0 |
| 2019-02-20 | FDXM | Futures | 11859.4 | 11996.7 | 11837.3 | 11957.4 | 48186.0 |
| 2019-02-20 | FESX | Futures | 2769.7 | 2791.0 | 2762.8 | 2785.0 | 835529.0 |
| 2019-02-20 | FGBL | Futures | 158.26 | 158.49 | 158.17 | 158.32 | 493448.0 |
| 2019-02-20 | FGBM | Futures | 132.56 | 132.59 | 132.49 | 132.54 | 348040.0 |
| 2019-02-20 | FGBS | Futures | 112.678 | 112.688 | 112.663 | 112.678 | 227893.0 |
| 2019-02-20 | FGBX | Futures | 189.38 | 190.13 | 188.99 | 189.56 | 38960.0 |
| 2019-02-20 | FMWO | Futures | 6981.7 | 7010.9 | 6970.1 | 7001.6 | 3424.0 |
| 2019-02-20 | FOAT | Futures | 143.57 | 143.76 | 143.52 | 143.66 | 122298.0 |
| 2019-02-20 | FTDX | Futures | 2623.3 | 2627.3 | 2591.5 | 2601.5 | 131.0 |
| 2019-02-20 | FTI | Futures | 506.21 | 507.9 | 503.3 | 506.93 | 22206.0 |
| 2019-02-20 | FTUK | Futures | 6500.3 | 6557.3 | 6486.7 | 6542.2 | 113446.0 |
| 2019-02-20 | FVSA | Futures | 272.63 | 279.62 | 269.13 | 273.5 | 18301.0 |
| 2019-02-20 | FXXP | Futures | 323.9 | 326.2 | 323.4 | 325.5 | 42397.0 |
| 2019-02-20 | G | Futures | 117.58 | 117.73 | 117.46 | 117.53 | 202878.0 |
| 2019-02-20 | GF | Futures | 314.251 | 315.181 | 313.213 | 314.634 | 4219.0 |
| 2019-02-20 | GSCI | Futures | 485.96 | 488.65 | 485.96 | 488.65 | 2.0 |
> showing 50 of 116 rows — these rows as CSV