PREVIEW / futures_daily / 2020-09-30
file: by_date/futures_daily/2020/2020-09-30.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-09-30 | ES | Futures | 3741.19 | 3801.86 | 3697.66 | 3765.91 | 2170601.0 |
| 2020-09-30 | NQ | Futures | 13106.42 | 13343.75 | 12928.14 | 13206.28 | 647968.0 |
| 2020-09-30 | YM | Futures | 29448.7 | 30040.9 | 29109.6 | 29782.5 | 297638.0 |
| 2020-09-30 | CL | Futures | 28.12 | 28.98 | 27.77 | 28.88 | 340294.0 |
| 2020-09-30 | GC | Futures | 2247.7 | 2253.6 | 2227.2 | 2238.6 | 259868.0 |
| 2020-09-30 | ZN | Futures | 138.590144 | 138.652133 | 138.202718 | 138.388683 | 1728153.0 |
| 2020-09-30 | A6 | Futures | 0.73184 | 0.73677 | 0.72896 | 0.73533 | 99764.0 |
| 2020-09-30 | AD | Futures | 0.75695 | 0.76202 | 0.75528 | 0.76136 | 94363.0 |
| 2020-09-30 | ALI | Futures | 2137.98 | 2137.98 | 2137.98 | 2137.98 | 0.0 |
| 2020-09-30 | B | Futures | 26.1 | 26.81 | 25.76 | 26.69 | 317193.0 |
| 2020-09-30 | B6 | Futures | 1.3044 | 1.3129 | 1.2989 | 1.3085 | 132548.0 |
| 2020-09-30 | BR | Futures | 0.13833 | 0.14014 | 0.13833 | 0.13967 | 459.0 |
| 2020-09-30 | BTC | Futures | 14578.5 | 14699.4 | 14410.5 | 14471.0 | 5671.0 |
| 2020-09-30 | BZ | Futures | 25.61 | 26.29 | 25.27 | 26.17 | 35524.0 |
| 2020-09-30 | C | Futures | 1633.0 | 1649.0 | 1591.0 | 1596.0 | 6249.0 |
| 2020-09-30 | CB | Futures | 167.73 | 167.73 | 167.73 | 167.73 | 3.0 |
| 2020-09-30 | CC | Futures | 1700.0 | 1717.0 | 1659.0 | 1672.0 | 15535.0 |
| 2020-09-30 | CNH | Futures | 6.7061 | 6.7084 | 6.6691 | 6.6691 | 817.0 |
| 2020-09-30 | CSC | Futures | 3.39 | 3.412 | 3.386 | 3.394 | 53.0 |
| 2020-09-30 | CT | Futures | 64.51 | 65.46 | 64.33 | 65.02 | 13871.0 |
| 2020-09-30 | DC | Futures | 27.86 | 28.03 | 27.81 | 27.92 | 101.0 |
| 2020-09-30 | DX | Futures | 90.704 | 91.042 | 90.511 | 90.73 | 20007.0 |
| 2020-09-30 | E1 | Futures | 1.23288 | 1.23831 | 1.22744 | 1.23163 | 39762.0 |
| 2020-09-30 | E6 | Futures | 1.25947 | 1.26118 | 1.25358 | 1.25711 | 215416.0 |
| 2020-09-30 | E7 | Futures | 1.253 | 1.2548 | 1.2472 | 1.2508 | 7840.0 |
| 2020-09-30 | EBM | Futures | 232.37 | 239.0 | 232.37 | 238.39 | 49268.0 |
| 2020-09-30 | ED | Futures | 96.4842 | 96.4939 | 96.4793 | 96.489 | 192667.0 |
| 2020-09-30 | ER | Futures | 98.435 | 98.44 | 98.431 | 98.435 | 48304.0 |
| 2020-09-30 | ESG | Futures | 311.54 | 314.36 | 310.19 | 311.93 | 29.0 |
| 2020-09-30 | EW | Futures | 1976.7 | 2003.6 | 1952.4 | 1984.0 | 18692.0 |
| 2020-09-30 | FBON | Futures | 148.35 | 148.41 | 147.97 | 147.98 | 299.0 |
| 2020-09-30 | FBTP | Futures | 135.4 | 135.59 | 135.09 | 135.2 | 124597.0 |
| 2020-09-30 | FBTS | Futures | 109.373 | 109.411 | 109.305 | 109.334 | 55267.0 |
| 2020-09-30 | FCE | Futures | 4647.3 | 4706.5 | 4630.8 | 4656.1 | 73591.0 |
| 2020-09-30 | FDAX | Futures | 13684.3 | 13735.5 | 13505.2 | 13624.6 | 74759.0 |
| 2020-09-30 | FDIV | Futures | 147.58 | 148.1 | 147.35 | 147.35 | 160.0 |
| 2020-09-30 | FDXM | Futures | 13608.9 | 13663.0 | 13438.1 | 13555.9 | 59884.0 |
| 2020-09-30 | FESX | Futures | 2966.7 | 2979.7 | 2926.0 | 2952.9 | 1073520.0 |
| 2020-09-30 | FGBL | Futures | 170.0 | 170.14 | 169.55 | 169.72 | 714372.0 |
| 2020-09-30 | FGBM | Futures | 135.18 | 135.24 | 135.07 | 135.1 | 388286.0 |
| 2020-09-30 | FGBS | Futures | 112.775 | 112.785 | 112.749 | 112.759 | 317658.0 |
| 2020-09-30 | FGBX | Futures | 233.29 | 234.14 | 231.7 | 232.43 | 72273.0 |
| 2020-09-30 | FMWO | Futures | 8347.8 | 8388.1 | 8222.3 | 8363.2 | 1910.0 |
| 2020-09-30 | FOAT | Futures | 158.05 | 158.19 | 157.59 | 157.72 | 189446.0 |
| 2020-09-30 | FTDX | Futures | 3153.2 | 3186.7 | 3128.0 | 3155.3 | 143.0 |
| 2020-09-30 | FTI | Futures | 507.88 | 514.27 | 506.35 | 510.29 | 26723.0 |
| 2020-09-30 | FTUK | Futures | 5615.6 | 5643.3 | 5559.2 | 5583.5 | 109087.0 |
| 2020-09-30 | FVSA | Futures | 207.27 | 209.13 | 196.5 | 197.24 | 18251.0 |
| 2020-09-30 | FXXP | Futures | 330.7 | 335.6 | 330.2 | 333.9 | 54557.0 |
| 2020-09-30 | G | Futures | 127.27 | 127.3 | 126.66 | 126.85 | 280826.0 |
> showing 50 of 120 rows — these rows as CSV