PREVIEW / futures_daily / 2020-09-03
file: by_date/futures_daily/2020/2020-09-03.parquet size: 10 KB rows: 122
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-03 | ES | Futures | 4028.19 | 4036.92 | 3854.57 | 3896.22 | 2872337.0 |
| 2020-09-03 | NQ | Futures | 14401.8 | 14436.9 | 13531.32 | 13696.13 | 931583.0 |
| 2020-09-03 | YM | Futures | 31160.5 | 31272.0 | 30063.1 | 30383.5 | 328250.0 |
| 2020-09-03 | CL | Futures | 30.11 | 30.22 | 29.09 | 29.92 | 417634.0 |
| 2020-09-03 | GC | Futures | 2301.7 | 2310.8 | 2276.0 | 2288.6 | 303029.0 |
| 2020-09-03 | ZN | Futures | 138.465766 | 138.759979 | 138.326402 | 138.667069 | 31479.0 |
| 2020-09-03 | A6 | Futures | 0.75444 | 0.75485 | 0.74744 | 0.74837 | 91042.0 |
| 2020-09-03 | AD | Futures | 0.77789 | 0.77839 | 0.77119 | 0.77286 | 87452.0 |
| 2020-09-03 | ALI | Futures | 2135.55 | 2139.72 | 2117.39 | 2128.41 | 183.0 |
| 2020-09-03 | B | Futures | 28.46 | 28.46 | 27.51 | 28.09 | 274933.0 |
| 2020-09-03 | B6 | Futures | 1.3559 | 1.3565 | 1.3446 | 1.3476 | 101514.0 |
| 2020-09-03 | BR | Futures | 0.14659 | 0.14848 | 0.14659 | 0.14848 | 1.0 |
| 2020-09-03 | BTC | Futures | 15446.0 | 15567.5 | 14122.8 | 14473.9 | 15412.0 |
| 2020-09-03 | BZ | Futures | 27.67 | 27.82 | 26.91 | 27.48 | 30615.0 |
| 2020-09-03 | C | Futures | 1621.0 | 1655.0 | 1617.0 | 1622.0 | 4296.0 |
| 2020-09-03 | CB | Futures | 177.462 | 177.462 | 175.023 | 175.023 | 6.0 |
| 2020-09-03 | CC | Futures | 1773.0 | 1778.0 | 1723.0 | 1730.0 | 17819.0 |
| 2020-09-03 | CNH | Futures | 6.7329 | 6.7491 | 6.7259 | 6.7458 | 732.0 |
| 2020-09-03 | CSC | Futures | 3.377 | 3.377 | 3.315 | 3.315 | 54.0 |
| 2020-09-03 | CT | Futures | 64.51 | 64.51 | 64.25 | 64.28 | 15.0 |
| 2020-09-03 | DC | Futures | 27.46 | 27.51 | 26.77 | 26.82 | 201.0 |
| 2020-09-03 | DX | Futures | 89.547 | 89.914 | 89.527 | 89.574 | 20735.0 |
| 2020-09-03 | E1 | Futures | 1.24693 | 1.25079 | 1.24261 | 1.24977 | 25587.0 |
| 2020-09-03 | E6 | Futures | 1.27206 | 1.27335 | 1.26514 | 1.27244 | 219832.0 |
| 2020-09-03 | E7 | Futures | 1.2656 | 1.2669 | 1.2587 | 1.2661 | 9907.0 |
| 2020-09-03 | EBM | Futures | 230.53 | 232.33 | 225.74 | 227.24 | 2867.0 |
| 2020-09-03 | ED | Futures | 96.4378 | 96.4403 | 96.4354 | 96.4378 | 111352.0 |
| 2020-09-03 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.406 | 71434.0 |
| 2020-09-03 | ESG | Futures | 321.86 | 321.86 | 313.41 | 315.23 | 98.0 |
| 2020-09-03 | EW | Futures | 2088.9 | 2095.2 | 2014.5 | 2026.1 | 21077.0 |
| 2020-09-03 | FBON | Futures | 146.74 | 147.18 | 146.52 | 146.92 | 1234.0 |
| 2020-09-03 | FBTP | Futures | 133.51 | 133.98 | 133.25 | 133.41 | 311223.0 |
| 2020-09-03 | FBTS | Futures | 109.035 | 109.093 | 108.987 | 109.016 | 167749.0 |
| 2020-09-03 | FCE | Futures | 4919.4 | 4993.4 | 4817.2 | 4873.2 | 88077.0 |
| 2020-09-03 | FDAX | Futures | 14204.1 | 14300.8 | 13737.2 | 13848.7 | 118567.0 |
| 2020-09-03 | FDIV | Futures | 154.31 | 154.69 | 150.57 | 150.81 | 587.0 |
| 2020-09-03 | FDXM | Futures | 14144.4 | 14249.2 | 13687.1 | 13798.8 | 110718.0 |
| 2020-09-03 | FESX | Futures | 3108.1 | 3134.9 | 3015.8 | 3040.7 | 1304240.0 |
| 2020-09-03 | FEU3 | Futures | 99.149 | 99.154 | 99.149 | 99.154 | 150.0 |
| 2020-09-03 | FGBL | Futures | 168.87 | 169.29 | 168.63 | 169.18 | 1289954.0 |
| 2020-09-03 | FGBM | Futures | 135.02 | 135.11 | 134.89 | 135.07 | 944784.0 |
| 2020-09-03 | FGBS | Futures | 112.785 | 112.81 | 112.759 | 112.795 | 916217.0 |
| 2020-09-03 | FGBX | Futures | 227.61 | 229.88 | 226.48 | 229.26 | 178500.0 |
| 2020-09-03 | FMWO | Futures | 8781.5 | 8794.6 | 8458.0 | 8532.7 | 3890.0 |
| 2020-09-03 | FOAT | Futures | 156.5 | 156.83 | 156.33 | 156.73 | 484189.0 |
| 2020-09-03 | FTDX | Futures | 3252.4 | 3252.4 | 3069.5 | 3107.3 | 82.0 |
| 2020-09-03 | FTI | Futures | 525.21 | 529.63 | 506.89 | 512.04 | 36970.0 |
| 2020-09-03 | FTUK | Futures | 5648.6 | 5670.3 | 5476.6 | 5524.8 | 130493.0 |
| 2020-09-03 | FVSA | Futures | 222.43 | 264.34 | 210.39 | 236.12 | 49270.0 |
| 2020-09-03 | FXXP | Futures | 344.2 | 347.0 | 334.5 | 337.2 | 74747.0 |
> showing 50 of 122 rows — these rows as CSV