PREVIEW / futures_daily / 2020-07-13
file: by_date/futures_daily/2020/2020-07-13.parquet size: 10 KB rows: 118
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-07-13 | ES | Futures | 3583.31 | 3631.43 | 3534.91 | 3543.63 | 2074726.0 |
| 2020-07-13 | NQ | Futures | 12590.91 | 12834.93 | 12258.09 | 12302.78 | 736178.0 |
| 2020-07-13 | YM | Futures | 27890.8 | 28425.5 | 27771.8 | 27829.7 | 265051.0 |
| 2020-07-13 | CL | Futures | 29.25 | 29.52 | 28.61 | 29.07 | 370715.0 |
| 2020-07-13 | GC | Futures | 2165.2 | 2183.7 | 2163.6 | 2178.0 | 230398.0 |
| 2020-07-13 | ZN | Futures | 137.908311 | 138.125099 | 137.768947 | 137.97025 | 774599.0 |
| 2020-07-13 | A6 | Futures | 0.71555 | 0.71956 | 0.71401 | 0.71648 | 91973.0 |
| 2020-07-13 | AD | Futures | 0.74677 | 0.75007 | 0.74591 | 0.74718 | 55225.0 |
| 2020-07-13 | ALI | Futures | 2054.43 | 2056.85 | 2035.38 | 2035.99 | 156.0 |
| 2020-07-13 | B | Futures | 28.09 | 28.24 | 27.45 | 27.83 | 200310.0 |
| 2020-07-13 | B6 | Futures | 1.2821 | 1.2866 | 1.2748 | 1.2772 | 82281.0 |
| 2020-07-13 | BR | Futures | 0.14675 | 0.14758 | 0.14675 | 0.14758 | 30.0 |
| 2020-07-13 | BTC | Futures | 12795.0 | 12960.2 | 12726.1 | 12767.4 | 2844.0 |
| 2020-07-13 | BZ | Futures | 27.46 | 27.6 | 26.87 | 27.21 | 22911.0 |
| 2020-07-13 | C | Futures | 1434.0 | 1435.0 | 1415.0 | 1427.0 | 4812.0 |
| 2020-07-13 | CB | Futures | 192.151 | 193.676 | 191.51 | 193.676 | 19.0 |
| 2020-07-13 | CC | Futures | 1419.0 | 1441.0 | 1409.0 | 1438.0 | 12745.0 |
| 2020-07-13 | CNH | Futures | 6.9266 | 6.9266 | 6.9141 | 6.919 | 409.0 |
| 2020-07-13 | CSC | Futures | 4.26 | 4.338 | 4.26 | 4.297 | 68.0 |
| 2020-07-13 | DC | Futures | 34.44 | 35.82 | 34.44 | 35.32 | 475.0 |
| 2020-07-13 | DX | Futures | 93.295 | 93.348 | 92.928 | 93.123 | 18709.0 |
| 2020-07-13 | E1 | Futures | 1.2099 | 1.21138 | 1.2057 | 1.20854 | 20526.0 |
| 2020-07-13 | E6 | Futures | 1.21476 | 1.22238 | 1.21444 | 1.22002 | 192221.0 |
| 2020-07-13 | E7 | Futures | 1.2085 | 1.2164 | 1.2084 | 1.2139 | 7568.0 |
| 2020-07-13 | EBM | Futures | 223.65 | 224.54 | 220.95 | 221.25 | 15329.0 |
| 2020-07-13 | ED | Futures | 96.4185 | 96.4282 | 96.4088 | 96.4137 | 182894.0 |
| 2020-07-13 | ER | Futures | 98.372 | 98.377 | 98.357 | 98.362 | 77551.0 |
| 2020-07-13 | ESG | Futures | 291.51 | 293.34 | 287.23 | 287.59 | 365.0 |
| 2020-07-13 | EW | Futures | 1891.5 | 1916.0 | 1858.6 | 1860.6 | 14069.0 |
| 2020-07-13 | FBON | Futures | 145.54 | 145.54 | 145.11 | 145.16 | 352.0 |
| 2020-07-13 | FBTP | Futures | 130.32 | 130.52 | 129.91 | 130.22 | 55407.0 |
| 2020-07-13 | FBTS | Futures | 108.454 | 108.473 | 108.376 | 108.463 | 27760.0 |
| 2020-07-13 | FCE | Futures | 4864.4 | 4884.7 | 4785.1 | 4877.4 | 38937.0 |
| 2020-07-13 | FDAX | Futures | 13513.5 | 13667.6 | 13301.1 | 13590.6 | 84714.0 |
| 2020-07-13 | FDIV | Futures | 146.21 | 146.21 | 146.07 | 146.07 | 10.0 |
| 2020-07-13 | FDXM | Futures | 13465.9 | 13618.3 | 13253.1 | 13541.5 | 49799.0 |
| 2020-07-13 | FESX | Futures | 3056.4 | 3088.7 | 3025.0 | 3086.9 | 847095.0 |
| 2020-07-13 | FGBL | Futures | 168.62 | 168.63 | 167.72 | 167.81 | 503277.0 |
| 2020-07-13 | FGBM | Futures | 134.84 | 134.85 | 134.51 | 134.54 | 310758.0 |
| 2020-07-13 | FGBS | Futures | 112.769 | 112.774 | 112.689 | 112.694 | 320747.0 |
| 2020-07-13 | FGBX | Futures | 228.19 | 228.19 | 224.75 | 225.03 | 45139.0 |
| 2020-07-13 | FMWO | Futures | 7986.3 | 8048.0 | 7859.5 | 8046.8 | 3838.0 |
| 2020-07-13 | FOAT | Futures | 155.59 | 155.74 | 155.11 | 155.18 | 100390.0 |
| 2020-07-13 | FTDX | Futures | 3128.8 | 3156.9 | 3106.3 | 3155.8 | 57.0 |
| 2020-07-13 | FTI | Futures | 537.5 | 539.13 | 533.71 | 538.53 | 7894.0 |
| 2020-07-13 | FTUK | Futures | 5776.2 | 5822.5 | 5719.5 | 5813.5 | 84950.0 |
| 2020-07-13 | FVSA | Futures | 255.64 | 276.9 | 253.83 | 256.09 | 11048.0 |
| 2020-07-13 | FXXP | Futures | 341.7 | 342.4 | 335.2 | 341.2 | 46594.0 |
| 2020-07-13 | G | Futures | 127.22 | 127.4 | 126.88 | 127.0 | 133524.0 |
| 2020-07-13 | GF | Futures | 263.924 | 267.219 | 263.633 | 265.668 | 6320.0 |
> showing 50 of 118 rows — these rows as CSV