PREVIEW / futures_daily / 2020-10-07
file: by_date/futures_daily/2020/2020-10-07.parquet size: 10 KB rows: 119
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-07 | ES | Futures | 3750.18 | 3838.65 | 3743.72 | 3827.42 | 1400616.0 |
| 2020-10-07 | NQ | Futures | 12990.07 | 13321.18 | 12975.6 | 13278.92 | 443046.0 |
| 2020-10-07 | YM | Futures | 29679.1 | 30413.4 | 29647.9 | 30336.9 | 193674.0 |
| 2020-10-07 | CL | Futures | 28.6 | 28.97 | 28.2 | 28.68 | 433065.0 |
| 2020-10-07 | GC | Futures | 2223.4 | 2246.8 | 2216.9 | 2233.1 | 188588.0 |
| 2020-10-07 | ZN | Futures | 137.985759 | 138.001256 | 137.505351 | 137.582836 | 1348929.0 |
| 2020-10-07 | A6 | Futures | 0.72927 | 0.7343 | 0.72866 | 0.73317 | 71444.0 |
| 2020-10-07 | AD | Futures | 0.76126 | 0.7646 | 0.75968 | 0.76389 | 54329.0 |
| 2020-10-07 | ALI | Futures | 2128.77 | 2157.88 | 2128.77 | 2149.86 | 162.0 |
| 2020-10-07 | B | Futures | 26.41 | 26.77 | 26.1 | 26.49 | 241200.0 |
| 2020-10-07 | B6 | Futures | 1.3061 | 1.3114 | 1.3028 | 1.3096 | 105461.0 |
| 2020-10-07 | BR | Futures | 0.14104 | 0.14136 | 0.13955 | 0.13975 | 277.0 |
| 2020-10-07 | BTC | Futures | 14242.6 | 14457.6 | 14235.9 | 14403.8 | 2260.0 |
| 2020-10-07 | BZ | Futures | 25.95 | 26.25 | 25.59 | 25.98 | 30170.0 |
| 2020-10-07 | C | Futures | 1509.0 | 1522.0 | 1498.0 | 1519.0 | 7006.0 |
| 2020-10-07 | CB | Futures | 162.877 | 162.877 | 156.626 | 157.058 | 95.0 |
| 2020-10-07 | CC | Futures | 1592.0 | 1620.0 | 1585.0 | 1610.0 | 14505.0 |
| 2020-10-07 | CNH | Futures | 6.6334 | 6.637 | 6.6148 | 6.6203 | 220.0 |
| 2020-10-07 | CSC | Futures | 3.463 | 3.48 | 3.452 | 3.461 | 35.0 |
| 2020-10-07 | CT | Futures | 65.92 | 67.03 | 65.64 | 66.8 | 18892.0 |
| 2020-10-07 | DC | Futures | 28.52 | 28.6 | 28.22 | 28.22 | 137.0 |
| 2020-10-07 | DX | Futures | 90.694 | 90.776 | 90.419 | 90.49 | 20276.0 |
| 2020-10-07 | E1 | Futures | 1.23582 | 1.23843 | 1.23503 | 1.23696 | 13212.0 |
| 2020-10-07 | E6 | Futures | 1.25872 | 1.26391 | 1.25775 | 1.26225 | 133058.0 |
| 2020-10-07 | E7 | Futures | 1.2524 | 1.2574 | 1.2513 | 1.2559 | 4521.0 |
| 2020-10-07 | EBM | Futures | 242.01 | 243.82 | 240.5 | 241.71 | 35727.0 |
| 2020-10-07 | ED | Futures | 96.489 | 96.4939 | 96.489 | 96.4939 | 44833.0 |
| 2020-10-07 | ER | Futures | 98.445 | 98.45 | 98.44 | 98.445 | 51532.0 |
| 2020-10-07 | ESG | Futures | 315.18 | 318.05 | 315.12 | 316.51 | 115.0 |
| 2020-10-07 | EW | Futures | 2061.7 | 2109.0 | 2058.3 | 2102.6 | 12035.0 |
| 2020-10-07 | FBON | Futures | 148.33 | 148.38 | 148.03 | 148.09 | 149.0 |
| 2020-10-07 | FBTP | Futures | 136.11 | 136.38 | 135.96 | 136.17 | 91770.0 |
| 2020-10-07 | FBTS | Futures | 109.547 | 109.605 | 109.547 | 109.595 | 60884.0 |
| 2020-10-07 | FCE | Futures | 4734.1 | 4767.1 | 4716.2 | 4732.7 | 46867.0 |
| 2020-10-07 | FDAX | Futures | 13645.9 | 13803.7 | 13627.8 | 13753.1 | 62331.0 |
| 2020-10-07 | FDIV | Futures | 149.38 | 149.38 | 148.44 | 149.15 | 217.0 |
| 2020-10-07 | FDXM | Futures | 13576.0 | 13732.0 | 13559.1 | 13683.7 | 42483.0 |
| 2020-10-07 | FESX | Futures | 2958.4 | 2992.6 | 2955.6 | 2979.7 | 626539.0 |
| 2020-10-07 | FGBL | Futures | 169.78 | 169.81 | 169.15 | 169.34 | 722896.0 |
| 2020-10-07 | FGBM | Futures | 135.16 | 135.17 | 134.96 | 135.01 | 310170.0 |
| 2020-10-07 | FGBS | Futures | 112.749 | 112.759 | 112.724 | 112.734 | 315175.0 |
| 2020-10-07 | FGBX | Futures | 232.28 | 232.62 | 230.07 | 230.88 | 68869.0 |
| 2020-10-07 | FMWO | Futures | 8370.3 | 8486.4 | 8365.6 | 8450.9 | 1873.0 |
| 2020-10-07 | FOAT | Futures | 157.9 | 158.04 | 157.43 | 157.62 | 162613.0 |
| 2020-10-07 | FTDX | Futures | 3194.4 | 3194.4 | 3169.2 | 3184.1 | 188.0 |
| 2020-10-07 | FTI | Futures | 515.57 | 518.23 | 513.85 | 516.65 | 19155.0 |
| 2020-10-07 | FTUK | Futures | 5612.7 | 5684.9 | 5612.7 | 5661.9 | 74613.0 |
| 2020-10-07 | FVSA | Futures | 197.99 | 197.99 | 190.93 | 193.53 | 9092.0 |
| 2020-10-07 | FXXP | Futures | 337.0 | 339.2 | 336.6 | 337.6 | 40398.0 |
| 2020-10-07 | G | Futures | 126.34 | 126.37 | 125.87 | 125.93 | 283074.0 |
> showing 50 of 119 rows — these rows as CSV