PREVIEW / futures_daily / 2020-09-22
file: by_date/futures_daily/2020/2020-09-22.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-22 | ES | Futures | 3675.47 | 3718.16 | 3658.62 | 3706.64 | 1576319.0 |
| 2020-09-22 | NQ | Futures | 12695.73 | 12955.92 | 12616.13 | 12907.88 | 573572.0 |
| 2020-09-22 | YM | Futures | 29067.6 | 29290.5 | 28914.8 | 29221.6 | 199343.0 |
| 2020-09-22 | CL | Futures | 28.6 | 28.91 | 28.14 | 28.58 | 287807.0 |
| 2020-09-22 | GC | Futures | 2265.3 | 2274.0 | 2242.6 | 2252.9 | 282714.0 |
| 2020-09-22 | ZN | Futures | 138.435174 | 138.481665 | 138.342191 | 138.481665 | 816613.0 |
| 2020-09-22 | A6 | Futures | 0.74159 | 0.74293 | 0.73461 | 0.73584 | 118387.0 |
| 2020-09-22 | AD | Futures | 0.76156 | 0.76308 | 0.75948 | 0.76161 | 78609.0 |
| 2020-09-22 | ALI | Futures | 2136.79 | 2144.81 | 2129.96 | 2132.33 | 146.0 |
| 2020-09-22 | B | Futures | 26.64 | 26.9 | 26.27 | 26.59 | 210739.0 |
| 2020-09-22 | B6 | Futures | 1.2996 | 1.3052 | 1.2894 | 1.2917 | 147054.0 |
| 2020-09-22 | BR | Futures | 0.14313 | 0.14329 | 0.14313 | 0.14329 | 6.0 |
| 2020-09-22 | BTC | Futures | 14156.6 | 14210.6 | 13974.3 | 14170.1 | 4081.0 |
| 2020-09-22 | BZ | Futures | 26.06 | 26.31 | 25.7 | 26.02 | 19914.0 |
| 2020-09-22 | C | Futures | 1675.0 | 1696.0 | 1642.0 | 1648.0 | 7347.0 |
| 2020-09-22 | CB | Futures | 173.803 | 174.819 | 171.77 | 174.819 | 33.0 |
| 2020-09-22 | CC | Futures | 1736.0 | 1740.0 | 1673.0 | 1678.0 | 17211.0 |
| 2020-09-22 | CNH | Futures | 6.6799 | 6.6915 | 6.6662 | 6.6808 | 518.0 |
| 2020-09-22 | CSC | Futures | 3.417 | 3.441 | 3.315 | 3.355 | 99.0 |
| 2020-09-22 | CT | Futures | 64.65 | 65.04 | 64.28 | 64.56 | 12.0 |
| 2020-09-22 | DC | Futures | 28.09 | 28.13 | 26.92 | 27.41 | 460.0 |
| 2020-09-22 | DX | Futures | 90.4 | 90.916 | 90.318 | 90.818 | 23402.0 |
| 2020-09-22 | E1 | Futures | 1.24069 | 1.24228 | 1.23265 | 1.23379 | 25316.0 |
| 2020-09-22 | E6 | Futures | 1.26279 | 1.26327 | 1.25459 | 1.25609 | 214789.0 |
| 2020-09-22 | E7 | Futures | 1.257 | 1.257 | 1.2483 | 1.2497 | 9393.0 |
| 2020-09-22 | EBM | Futures | 232.97 | 235.98 | 232.67 | 234.78 | 41592.0 |
| 2020-09-22 | ED | Futures | 96.4648 | 96.4648 | 96.46 | 96.46 | 50515.0 |
| 2020-09-22 | ER | Futures | 98.45 | 98.45 | 98.435 | 98.435 | 35972.0 |
| 2020-09-22 | ESG | Futures | 303.68 | 308.33 | 303.68 | 307.0 | 78.0 |
| 2020-09-22 | EW | Futures | 1944.2 | 1958.8 | 1931.1 | 1954.2 | 11983.0 |
| 2020-09-22 | FBON | Futures | 148.06 | 148.24 | 147.97 | 148.18 | 339.0 |
| 2020-09-22 | FBTP | Futures | 134.77 | 135.39 | 134.65 | 135.35 | 116166.0 |
| 2020-09-22 | FBTS | Futures | 109.286 | 109.392 | 109.267 | 109.382 | 68938.0 |
| 2020-09-22 | FCE | Futures | 4659.9 | 4672.1 | 4610.5 | 4619.7 | 73603.0 |
| 2020-09-22 | FDAX | Futures | 13478.5 | 13518.5 | 13366.6 | 13450.8 | 82094.0 |
| 2020-09-22 | FDIV | Futures | 145.55 | 145.69 | 145.26 | 145.26 | 200.0 |
| 2020-09-22 | FDXM | Futures | 13407.4 | 13450.9 | 13299.2 | 13383.0 | 35902.0 |
| 2020-09-22 | FESX | Futures | 2937.1 | 2946.4 | 2905.7 | 2924.2 | 972116.0 |
| 2020-09-22 | FGBL | Futures | 169.76 | 169.94 | 169.46 | 169.58 | 591252.0 |
| 2020-09-22 | FGBM | Futures | 135.19 | 135.26 | 135.1 | 135.15 | 289770.0 |
| 2020-09-22 | FGBS | Futures | 112.805 | 112.82 | 112.78 | 112.795 | 308364.0 |
| 2020-09-22 | FGBX | Futures | 232.2 | 232.45 | 230.09 | 230.72 | 77570.0 |
| 2020-09-22 | FMWO | Futures | 8183.2 | 8223.5 | 8139.4 | 8165.4 | 1961.0 |
| 2020-09-22 | FOAT | Futures | 157.77 | 157.95 | 157.59 | 157.67 | 114239.0 |
| 2020-09-22 | FTDX | Futures | 3096.6 | 3129.6 | 3096.6 | 3118.3 | 187.0 |
| 2020-09-22 | FTI | Futures | 501.59 | 508.44 | 500.47 | 503.63 | 26039.0 |
| 2020-09-22 | FTUK | Futures | 5575.4 | 5601.7 | 5506.6 | 5560.1 | 122376.0 |
| 2020-09-22 | FVSA | Futures | 211.73 | 212.84 | 204.3 | 208.39 | 17799.0 |
| 2020-09-22 | FXXP | Futures | 330.8 | 332.5 | 329.3 | 330.8 | 58321.0 |
| 2020-09-22 | G | Futures | 127.43 | 127.59 | 126.91 | 127.08 | 270087.0 |
> showing 50 of 120 rows — these rows as CSV