PREVIEW / futures_daily / 2020-10-29
file: by_date/futures_daily/2020/2020-10-29.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 |
|---|---|---|---|---|---|---|---|
| 2020-10-29 | ES | Futures | 3683.89 | 3745.4 | 3651.59 | 3710.01 | 1965277.0 |
| 2020-10-29 | NQ | Futures | 12943.77 | 13264.74 | 12902.67 | 13131.6 | 606325.0 |
| 2020-10-29 | YM | Futures | 28510.0 | 28855.6 | 28165.5 | 28590.7 | 288636.0 |
| 2020-10-29 | CL | Futures | 26.65 | 26.92 | 24.89 | 25.78 | 568816.0 |
| 2020-10-29 | GC | Futures | 2217.3 | 2226.3 | 2195.7 | 2206.1 | 225159.0 |
| 2020-10-29 | ZN | Futures | 137.675818 | 137.753303 | 137.226404 | 137.272895 | 1974950.0 |
| 2020-10-29 | A6 | Futures | 0.72363 | 0.7265 | 0.7189 | 0.72137 | 117832.0 |
| 2020-10-29 | AD | Futures | 0.76065 | 0.76328 | 0.75695 | 0.7606 | 95936.0 |
| 2020-10-29 | ALI | Futures | 2156.59 | 2156.59 | 2153.63 | 2154.82 | 33.0 |
| 2020-10-29 | B | Futures | 25.02 | 25.18 | 23.48 | 24.11 | 467010.0 |
| 2020-10-29 | B6 | Futures | 1.3173 | 1.3211 | 1.3064 | 1.311 | 119714.0 |
| 2020-10-29 | BFX | Futures | 3265.5 | 3273.1 | 3265.5 | 3273.1 | 11.0 |
| 2020-10-29 | BR | Futures | 0.1368 | 0.1368 | 0.13562 | 0.13644 | 10106.0 |
| 2020-10-29 | BTC | Futures | 17671.2 | 18350.8 | 17394.0 | 18185.8 | 4563.0 |
| 2020-10-29 | BZ | Futures | 24.53 | 24.75 | 22.98 | 23.6 | 64923.0 |
| 2020-10-29 | C | Futures | 1451.0 | 1461.0 | 1439.0 | 1440.0 | 6210.0 |
| 2020-10-29 | CB | Futures | 151.442 | 152.484 | 151.442 | 152.459 | 27.0 |
| 2020-10-29 | CC | Futures | 1563.0 | 1567.0 | 1533.0 | 1536.0 | 16328.0 |
| 2020-10-29 | CNH | Futures | 6.6039 | 6.6047 | 6.5779 | 6.5884 | 883.0 |
| 2020-10-29 | CSC | Futures | 3.93 | 4.01 | 3.93 | 3.961 | 229.0 |
| 2020-10-29 | CT | Futures | 69.33 | 69.63 | 68.76 | 69.0 | 22637.0 |
| 2020-10-29 | DC | Futures | 32.24 | 32.87 | 32.06 | 32.46 | 480.0 |
| 2020-10-29 | DX | Futures | 90.289 | 90.936 | 90.178 | 90.778 | 26344.0 |
| 2020-10-29 | E1 | Futures | 1.24522 | 1.24737 | 1.23605 | 1.23763 | 24239.0 |
| 2020-10-29 | E6 | Futures | 1.25925 | 1.26075 | 1.24913 | 1.25138 | 235294.0 |
| 2020-10-29 | E7 | Futures | 1.253 | 1.2543 | 1.2428 | 1.245 | 7740.0 |
| 2020-10-29 | EBM | Futures | 244.12 | 247.43 | 243.52 | 247.13 | 25674.0 |
| 2020-10-29 | ED | Futures | 96.4939 | 96.4939 | 96.489 | 96.4939 | 50220.0 |
| 2020-10-29 | ER | Futures | 98.445 | 98.465 | 98.445 | 98.46 | 217661.0 |
| 2020-10-29 | ESG | Futures | 305.44 | 309.45 | 304.73 | 307.55 | 82.0 |
| 2020-10-29 | EW | Futures | 2030.5 | 2051.9 | 2004.0 | 2041.6 | 22126.0 |
| 2020-10-29 | FBON | Futures | 148.83 | 149.56 | 148.64 | 149.39 | 609.0 |
| 2020-10-29 | FBTP | Futures | 136.64 | 137.29 | 136.21 | 137.08 | 199552.0 |
| 2020-10-29 | FBTS | Futures | 109.653 | 109.788 | 109.595 | 109.749 | 118188.0 |
| 2020-10-29 | FCE | Futures | 4437.0 | 4451.0 | 4357.2 | 4414.3 | 87245.0 |
| 2020-10-29 | FDAX | Futures | 12318.5 | 12469.9 | 12199.1 | 12332.4 | 126242.0 |
| 2020-10-29 | FDIV | Futures | 135.59 | 136.49 | 135.31 | 135.31 | 80.0 |
| 2020-10-29 | FDXM | Futures | 12245.8 | 12406.0 | 12137.6 | 12270.2 | 73316.0 |
| 2020-10-29 | FESX | Futures | 2729.1 | 2756.9 | 2694.0 | 2726.4 | 1466877.0 |
| 2020-10-29 | FGBL | Futures | 171.19 | 171.59 | 171.08 | 171.46 | 698940.0 |
| 2020-10-29 | FGBM | Futures | 135.75 | 135.89 | 135.72 | 135.88 | 374796.0 |
| 2020-10-29 | FGBS | Futures | 112.93 | 112.965 | 112.915 | 112.955 | 422018.0 |
| 2020-10-29 | FGBX | Futures | 238.3 | 239.82 | 238.04 | 239.15 | 84186.0 |
| 2020-10-29 | FMWO | Futures | 8171.4 | 8187.9 | 8063.6 | 8131.1 | 1896.0 |
| 2020-10-29 | FOAT | Futures | 158.88 | 159.37 | 158.78 | 159.31 | 181520.0 |
| 2020-10-29 | FTDX | Futures | 2908.9 | 2937.2 | 2886.8 | 2913.0 | 206.0 |
| 2020-10-29 | FTI | Futures | 494.2 | 499.03 | 488.54 | 494.78 | 34721.0 |
| 2020-10-29 | FTUK | Futures | 5303.0 | 5359.9 | 5264.3 | 5304.0 | 140829.0 |
| 2020-10-29 | FVSA | Futures | 227.24 | 242.63 | 219.73 | 230.47 | 35732.0 |
| 2020-10-29 | FXXP | Futures | 317.3 | 318.4 | 312.8 | 315.6 | 85884.0 |
> showing 50 of 121 rows — these rows as CSV