PREVIEW / futures_daily / 2019-12-03
file: by_date/futures_daily/2019/2019-12-03.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 |
|---|---|---|---|---|---|---|---|
| 2019-12-03 | ES | Futures | 3371.39 | 3379.5 | 3322.94 | 3346.22 | 2146620.0 |
| 2019-12-03 | NQ | Futures | 9580.94 | 9608.31 | 9413.26 | 9508.91 | 614317.0 |
| 2019-12-03 | YM | Futures | 29171.6 | 29233.5 | 28671.9 | 28855.6 | 260953.0 |
| 2019-12-03 | CL | Futures | 57.14 | 58.0 | 56.52 | 57.28 | 560554.0 |
| 2019-12-03 | GC | Futures | 1806.0 | 1830.3 | 1802.8 | 1826.2 | 400899.0 |
| 2019-12-03 | ZN | Futures | 127.870275 | 128.892246 | 127.653493 | 128.799339 | 81149.0 |
| 2019-12-03 | A6 | Futures | 0.69968 | 0.7043 | 0.69958 | 0.70225 | 128371.0 |
| 2019-12-03 | AD | Futures | 0.75693 | 0.75844 | 0.75617 | 0.75733 | 79971.0 |
| 2019-12-03 | ALI | Futures | 2189.45 | 2192.79 | 2161.51 | 2163.03 | 70.0 |
| 2019-12-03 | B | Futures | 49.24 | 49.67 | 48.63 | 49.05 | 248550.0 |
| 2019-12-03 | B6 | Futures | 1.3166 | 1.3235 | 1.3152 | 1.3215 | 115090.0 |
| 2019-12-03 | BR | Futures | 0.19287 | 0.19287 | 0.19218 | 0.19218 | 3.0 |
| 2019-12-03 | BTC | Futures | 11089.0 | 11201.9 | 10923.5 | 11043.9 | 1711.0 |
| 2019-12-03 | BZ | Futures | 48.47 | 49.01 | 47.98 | 48.4 | 32863.0 |
| 2019-12-03 | C | Futures | 1758.0 | 1762.0 | 1742.0 | 1747.0 | 3351.0 |
| 2019-12-03 | CB | Futures | 248.19 | 248.19 | 246.421 | 246.421 | 89.0 |
| 2019-12-03 | CC | Futures | 1668.0 | 1685.0 | 1660.0 | 1678.0 | 20952.0 |
| 2019-12-03 | CNH | Futures | 7.0322 | 7.0747 | 7.0259 | 7.0577 | 962.0 |
| 2019-12-03 | CSC | Futures | 3.444 | 3.444 | 3.439 | 3.439 | 45.0 |
| 2019-12-03 | CT | Futures | 61.54 | 61.76 | 60.89 | 60.92 | 20753.0 |
| 2019-12-03 | DC | Futures | 28.79 | 28.87 | 28.57 | 28.72 | 65.0 |
| 2019-12-03 | DX | Futures | 94.594 | 94.604 | 94.319 | 94.411 | 12745.0 |
| 2019-12-03 | E1 | Futures | 1.16174 | 1.16807 | 1.1599 | 1.16657 | 38611.0 |
| 2019-12-03 | E6 | Futures | 1.20163 | 1.20342 | 1.20033 | 1.20195 | 177238.0 |
| 2019-12-03 | E7 | Futures | 1.1953 | 1.1971 | 1.1939 | 1.1958 | 2796.0 |
| 2019-12-03 | EBM | Futures | 204.67 | 205.49 | 201.66 | 204.12 | 10810.0 |
| 2019-12-03 | ED | Futures | 95.3326 | 95.3569 | 95.3277 | 95.3545 | 361608.0 |
| 2019-12-03 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.396 | 71650.0 |
| 2019-12-03 | ESG | Futures | 276.84 | 276.84 | 273.93 | 275.38 | 275.0 |
| 2019-12-03 | EW | Futures | 2097.2 | 2102.4 | 2066.8 | 2084.3 | 16237.0 |
| 2019-12-03 | FBON | Futures | 142.04 | 143.22 | 142.0 | 143.14 | 2438.0 |
| 2019-12-03 | FBTP | Futures | 127.41 | 128.05 | 126.93 | 127.91 | 259545.0 |
| 2019-12-03 | FBTS | Futures | 107.96 | 108.047 | 107.864 | 108.018 | 165570.0 |
| 2019-12-03 | FCE | Futures | 5248.0 | 5255.2 | 5152.0 | 5180.5 | 112589.0 |
| 2019-12-03 | FDAX | Futures | 13681.2 | 13807.8 | 13636.8 | 13705.9 | 151544.0 |
| 2019-12-03 | FDIV | Futures | 159.13 | 159.13 | 157.83 | 157.83 | 215.0 |
| 2019-12-03 | FDXM | Futures | 13524.4 | 13627.5 | 13457.7 | 13527.0 | 61882.0 |
| 2019-12-03 | FESX | Futures | 3177.2 | 3196.5 | 3149.2 | 3165.0 | 1396327.0 |
| 2019-12-03 | FGBL | Futures | 164.24 | 165.32 | 163.97 | 165.23 | 1645820.0 |
| 2019-12-03 | FGBM | Futures | 133.59 | 133.98 | 133.51 | 133.95 | 1072714.0 |
| 2019-12-03 | FGBS | Futures | 112.654 | 112.714 | 112.644 | 112.709 | 867467.0 |
| 2019-12-03 | FGBX | Futures | 212.49 | 215.9 | 211.52 | 215.61 | 172916.0 |
| 2019-12-03 | FMWO | Futures | 7583.7 | 7596.2 | 7483.6 | 7506.4 | 6681.0 |
| 2019-12-03 | FOAT | Futures | 151.47 | 152.65 | 151.38 | 152.57 | 395669.0 |
| 2019-12-03 | FTDX | Futures | 2976.1 | 2991.9 | 2952.4 | 2965.8 | 116.0 |
| 2019-12-03 | FTI | Futures | 563.44 | 565.59 | 555.97 | 557.93 | 44058.0 |
| 2019-12-03 | FTUK | Futures | 6764.3 | 6774.5 | 6612.3 | 6642.5 | 177361.0 |
| 2019-12-03 | FVSA | Futures | 143.93 | 159.14 | 141.4 | 156.09 | 63111.0 |
| 2019-12-03 | FXXP | Futures | 363.5 | 364.5 | 359.2 | 360.5 | 72834.0 |
| 2019-12-03 | G | Futures | 120.45 | 121.47 | 120.34 | 121.26 | 246210.0 |
> showing 50 of 121 rows — these rows as CSV