PREVIEW / futures_daily / 2020-11-24
file: by_date/futures_daily/2020/2020-11-24.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-11-24 | ES | Futures | 4017.57 | 4089.47 | 4016.72 | 4081.32 | 1288993.0 |
| 2020-11-24 | NQ | Futures | 13788.02 | 14013.49 | 13745.19 | 13980.49 | 401635.0 |
| 2020-11-24 | YM | Futures | 31823.7 | 32369.5 | 31815.1 | 32295.2 | 153621.0 |
| 2020-11-24 | CL | Futures | 30.47 | 32.15 | 30.46 | 31.94 | 418527.0 |
| 2020-11-24 | GC | Futures | 2168.0 | 2169.4 | 2122.4 | 2131.3 | 367879.0 |
| 2020-11-24 | ZN | Futures | 137.19541 | 137.241901 | 137.040439 | 137.117924 | 3331076.0 |
| 2020-11-24 | A6 | Futures | 0.74806 | 0.75642 | 0.74801 | 0.75504 | 114142.0 |
| 2020-11-24 | AD | Futures | 0.77453 | 0.7799 | 0.77418 | 0.77919 | 85563.0 |
| 2020-11-24 | ALI | Futures | 2325.56 | 2339.11 | 2325.27 | 2336.17 | 56.0 |
| 2020-11-24 | B | Futures | 28.92 | 30.26 | 28.91 | 30.16 | 263239.0 |
| 2020-11-24 | B6 | Futures | 1.3509 | 1.357 | 1.348 | 1.354 | 79593.0 |
| 2020-11-24 | BR | Futures | 0.14439 | 0.14525 | 0.14314 | 0.14462 | 96.0 |
| 2020-11-24 | BTC | Futures | 24296.2 | 25755.3 | 23840.2 | 25240.7 | 4363.0 |
| 2020-11-24 | BZ | Futures | 28.27 | 29.63 | 28.27 | 29.52 | 31692.0 |
| 2020-11-24 | C | Futures | 1644.0 | 1729.0 | 1642.0 | 1677.0 | 6518.0 |
| 2020-11-24 | CB | Futures | 146.662 | 146.754 | 144.886 | 144.932 | 55.0 |
| 2020-11-24 | CC | Futures | 1823.0 | 1854.0 | 1809.0 | 1830.0 | 29992.0 |
| 2020-11-24 | CNH | Futures | 6.452 | 6.4661 | 6.4411 | 6.4492 | 1116.0 |
| 2020-11-24 | CSC | Futures | 3.0 | 3.005 | 2.99 | 2.997 | 123.0 |
| 2020-11-24 | CT | Futures | 71.3 | 71.38 | 69.42 | 70.51 | 19602.0 |
| 2020-11-24 | DC | Futures | 24.94 | 24.96 | 24.88 | 24.9 | 72.0 |
| 2020-11-24 | DX | Futures | 89.361 | 89.405 | 88.97 | 89.081 | 23193.0 |
| 2020-11-24 | E1 | Futures | 1.24148 | 1.24522 | 1.24001 | 1.24216 | 21916.0 |
| 2020-11-24 | E6 | Futures | 1.26905 | 1.27495 | 1.26868 | 1.27339 | 148296.0 |
| 2020-11-24 | E7 | Futures | 1.2625 | 1.2685 | 1.2622 | 1.267 | 6100.0 |
| 2020-11-24 | EBM | Futures | 254.37 | 257.38 | 254.06 | 256.48 | 18212.0 |
| 2020-11-24 | ED | Futures | 96.4914 | 96.4914 | 96.4793 | 96.4842 | 211720.0 |
| 2020-11-24 | ER | Futures | 98.46 | 98.46 | 98.455 | 98.455 | 25816.0 |
| 2020-11-24 | ESG | Futures | 332.69 | 335.64 | 331.76 | 335.53 | 138.0 |
| 2020-11-24 | EW | Futures | 2328.8 | 2376.5 | 2328.8 | 2369.6 | 12700.0 |
| 2020-11-24 | FBON | Futures | 150.32 | 150.56 | 150.32 | 150.48 | 298.0 |
| 2020-11-24 | FBTP | Futures | 138.45 | 138.75 | 138.42 | 138.64 | 67742.0 |
| 2020-11-24 | FBTS | Futures | 110.02 | 110.077 | 110.02 | 110.077 | 29740.0 |
| 2020-11-24 | FCE | Futures | 5395.4 | 5434.9 | 5390.5 | 5414.9 | 56593.0 |
| 2020-11-24 | FDAX | Futures | 14096.9 | 14211.0 | 14055.3 | 14165.2 | 61761.0 |
| 2020-11-24 | FDIV | Futures | 158.77 | 159.29 | 158.77 | 159.29 | 80.0 |
| 2020-11-24 | FDXM | Futures | 14015.2 | 14139.3 | 13983.4 | 14093.7 | 36286.0 |
| 2020-11-24 | FESX | Futures | 3222.8 | 3251.5 | 3217.3 | 3240.4 | 776512.0 |
| 2020-11-24 | FGBL | Futures | 170.55 | 170.65 | 170.31 | 170.44 | 520857.0 |
| 2020-11-24 | FGBM | Futures | 135.34 | 135.42 | 135.29 | 135.34 | 266631.0 |
| 2020-11-24 | FGBS | Futures | 112.81 | 112.825 | 112.8 | 112.81 | 245079.0 |
| 2020-11-24 | FGBX | Futures | 235.94 | 236.44 | 235.21 | 235.83 | 55619.0 |
| 2020-11-24 | FMWO | Futures | 9040.7 | 9140.2 | 9025.3 | 9116.5 | 2303.0 |
| 2020-11-24 | FOAT | Futures | 158.94 | 159.18 | 158.91 | 159.03 | 105823.0 |
| 2020-11-24 | FTDX | Futures | 3150.7 | 3150.7 | 3107.5 | 3107.5 | 54.0 |
| 2020-11-24 | FTI | Futures | 565.93 | 568.82 | 564.66 | 567.62 | 17280.0 |
| 2020-11-24 | FTUK | Futures | 6082.0 | 6156.1 | 6071.0 | 6127.9 | 111408.0 |
| 2020-11-24 | FVSA | Futures | 154.68 | 156.16 | 153.2 | 155.79 | 13485.0 |
| 2020-11-24 | FXXP | Futures | 362.5 | 364.5 | 361.6 | 363.3 | 67855.0 |
| 2020-11-24 | G | Futures | 125.77 | 126.12 | 125.71 | 125.87 | 283325.0 |
> showing 50 of 120 rows — these rows as CSV