PREVIEW / futures_daily / 2021-11-16
file: by_date/futures_daily/2021/2021-11-16.parquet size: 10 KB rows: 124
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-16 | ES | Futures | 5265.34 | 5297.96 | 5254.09 | 5282.49 | 1043587.0 |
| 2021-11-16 | NQ | Futures | 18679.23 | 18823.66 | 18614.07 | 18797.14 | 424380.0 |
| 2021-11-16 | YM | Futures | 39194.2 | 39428.1 | 39110.4 | 39235.5 | 139663.0 |
| 2021-11-16 | CL | Futures | 60.02 | 60.68 | 59.4 | 59.98 | 208598.0 |
| 2021-11-16 | GC | Futures | 2175.7 | 2192.7 | 2159.5 | 2163.1 | 220431.0 |
| 2021-11-16 | ZN | Futures | 132.526078 | 132.748544 | 132.303612 | 132.383064 | 1407795.0 |
| 2021-11-16 | A6 | Futures | 0.75306 | 0.75536 | 0.74757 | 0.74849 | 78127.0 |
| 2021-11-16 | AD | Futures | 0.81125 | 0.81262 | 0.8077 | 0.80831 | 56127.0 |
| 2021-11-16 | ALI | Futures | 2930.86 | 2930.86 | 2867.42 | 2867.42 | 43.0 |
| 2021-11-16 | B | Futures | 56.06 | 56.83 | 55.73 | 56.35 | 340716.0 |
| 2021-11-16 | B6 | Futures | 1.361 | 1.3676 | 1.3607 | 1.3631 | 92690.0 |
| 2021-11-16 | BR | Futures | 0.1478 | 0.14914 | 0.14703 | 0.14731 | 8764.0 |
| 2021-11-16 | BTC | Futures | 84250.3 | 84342.6 | 77084.0 | 78684.6 | 9161.0 |
| 2021-11-16 | BZ | Futures | 54.81 | 55.5 | 54.44 | 55.03 | 25767.0 |
| 2021-11-16 | C | Futures | 1453.0 | 1454.0 | 1427.0 | 1444.0 | 1863.0 |
| 2021-11-16 | CB | Futures | 153.777 | 153.935 | 153.777 | 153.935 | 7.0 |
| 2021-11-16 | CC | Futures | 1595.0 | 1613.0 | 1584.0 | 1606.0 | 18902.0 |
| 2021-11-16 | CNH | Futures | 6.1239 | 6.1372 | 6.1039 | 6.1303 | 669.0 |
| 2021-11-16 | CSC | Futures | 2.361 | 2.361 | 2.308 | 2.323 | 223.0 |
| 2021-11-16 | CT | Futures | 109.99 | 110.52 | 109.26 | 110.11 | 11986.0 |
| 2021-11-16 | DC | Futures | 22.55 | 22.66 | 22.01 | 22.19 | 964.0 |
| 2021-11-16 | DX | Futures | 92.26 | 92.738 | 92.177 | 92.671 | 20581.0 |
| 2021-11-16 | E1 | Futures | 1.21172 | 1.21317 | 1.20343 | 1.20376 | 27866.0 |
| 2021-11-16 | E6 | Futures | 1.20835 | 1.21031 | 1.20213 | 1.20293 | 187699.0 |
| 2021-11-16 | E7 | Futures | 1.2018 | 1.2036 | 1.1955 | 1.1963 | 4578.0 |
| 2021-11-16 | EBM | Futures | 433.53 | 435.73 | 423.98 | 424.71 | 25954.0 |
| 2021-11-16 | ED | Futures | 96.5247 | 96.5247 | 96.5175 | 96.5175 | 128886.0 |
| 2021-11-16 | ER | Futures | 98.494 | 98.499 | 98.489 | 98.499 | 36652.0 |
| 2021-11-16 | ESG | Futures | 440.28 | 442.97 | 439.74 | 442.08 | 643.0 |
| 2021-11-16 | EW | Futures | 3128.4 | 3144.6 | 3119.5 | 3130.4 | 10077.0 |
| 2021-11-16 | FBON | Futures | 148.82 | 148.94 | 148.42 | 148.86 | 311.0 |
| 2021-11-16 | FBTP | Futures | 137.86 | 138.09 | 137.5 | 138.04 | 104257.0 |
| 2021-11-16 | FBTS | Futures | 110.312 | 110.351 | 110.215 | 110.351 | 41527.0 |
| 2021-11-16 | FCE | Futures | 7205.2 | 7241.6 | 7197.6 | 7228.5 | 40007.0 |
| 2021-11-16 | FDAX | Futures | 17240.5 | 17380.5 | 17221.2 | 17364.5 | 60325.0 |
| 2021-11-16 | FDIV | Futures | 188.28 | 188.48 | 188.28 | 188.43 | 50.0 |
| 2021-11-16 | FDXM | Futures | 17287.4 | 17431.0 | 17271.3 | 17413.9 | 31736.0 |
| 2021-11-16 | FDXS | Futures | 17113.1 | 17268.1 | 17112.0 | 17252.2 | 15975.0 |
| 2021-11-16 | FESX | Futures | 4189.7 | 4216.5 | 4185.3 | 4209.8 | 495062.0 |
| 2021-11-16 | FGBL | Futures | 168.02 | 168.34 | 167.84 | 168.25 | 618967.0 |
| 2021-11-16 | FGBM | Futures | 134.55 | 134.8 | 134.48 | 134.78 | 370765.0 |
| 2021-11-16 | FGBS | Futures | 112.699 | 112.79 | 112.689 | 112.785 | 303261.0 |
| 2021-11-16 | FGBX | Futures | 228.61 | 229.22 | 227.68 | 228.76 | 75010.0 |
| 2021-11-16 | FMWO | Futures | 11457.2 | 11507.9 | 11450.1 | 11498.4 | 2751.0 |
| 2021-11-16 | FOAT | Futures | 155.52 | 155.77 | 155.3 | 155.68 | 141429.0 |
| 2021-11-16 | FTDX | Futures | 4008.3 | 4028.3 | 4008.3 | 4026.8 | 42.0 |
| 2021-11-16 | FTI | Futures | 785.38 | 790.35 | 784.53 | 788.3 | 11594.0 |
| 2021-11-16 | FTUK | Futures | 7244.3 | 7266.5 | 7217.6 | 7231.0 | 82333.0 |
| 2021-11-16 | FVSA | Futures | 60.95 | 61.26 | 60.15 | 60.47 | 30995.0 |
| 2021-11-16 | FXXP | Futures | 466.0 | 467.4 | 465.6 | 466.4 | 97763.0 |
> showing 50 of 124 rows — these rows as CSV