PREVIEW / futures_daily / 2020-12-18
file: by_date/futures_daily/2020/2020-12-18.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-12-18 | ES | Futures | 4161.54 | 4172.75 | 4121.47 | 4153.97 | 1731161.0 |
| 2020-12-18 | NQ | Futures | 14703.21 | 14751.94 | 14544.61 | 14662.84 | 460979.0 |
| 2020-12-18 | YM | Futures | 32624.4 | 32703.2 | 32318.8 | 32519.6 | 168183.0 |
| 2020-12-18 | CL | Futures | 34.29 | 34.9 | 34.08 | 34.76 | 300144.0 |
| 2020-12-18 | GC | Futures | 2224.5 | 2229.7 | 2213.5 | 2221.7 | 153231.0 |
| 2020-12-18 | ZN | Futures | 137.056068 | 137.211478 | 136.993904 | 137.009445 | 800916.0 |
| 2020-12-18 | A6 | Futures | 0.78269 | 0.78305 | 0.77869 | 0.78197 | 84677.0 |
| 2020-12-18 | AD | Futures | 0.79662 | 0.79667 | 0.79181 | 0.79242 | 60667.0 |
| 2020-12-18 | ALI | Futures | 2445.54 | 2446.12 | 2412.03 | 2425.14 | 74.0 |
| 2020-12-18 | B | Futures | 32.5 | 33.16 | 32.31 | 33.02 | 246122.0 |
| 2020-12-18 | B6 | Futures | 1.3807 | 1.3811 | 1.3692 | 1.3727 | 93703.0 |
| 2020-12-18 | BR | Futures | 0.15254 | 0.15332 | 0.15254 | 0.15332 | 1044.0 |
| 2020-12-18 | BTC | Futures | 30028.3 | 30503.8 | 29227.1 | 29780.7 | 7105.0 |
| 2020-12-18 | BZ | Futures | 31.8 | 32.43 | 31.61 | 32.3 | 24749.0 |
| 2020-12-18 | C | Futures | 1451.0 | 1459.0 | 1431.0 | 1438.0 | 5908.0 |
| 2020-12-18 | CB | Futures | 152.268 | 152.268 | 151.115 | 151.115 | 11.0 |
| 2020-12-18 | CC | Futures | 1670.0 | 1679.0 | 1638.0 | 1647.0 | 14133.0 |
| 2020-12-18 | CNH | Futures | 6.3898 | 6.4054 | 6.3862 | 6.3981 | 824.0 |
| 2020-12-18 | CSC | Futures | 3.005 | 3.024 | 2.998 | 3.009 | 102.0 |
| 2020-12-18 | CT | Futures | 74.58 | 74.79 | 74.25 | 74.55 | 14192.0 |
| 2020-12-18 | DC | Futures | 25.46 | 25.59 | 25.43 | 25.47 | 185.0 |
| 2020-12-18 | DX | Futures | 86.823 | 87.069 | 86.779 | 86.971 | 17930.0 |
| 2020-12-18 | E1 | Futures | 1.28041 | 1.28256 | 1.27646 | 1.28086 | 17896.0 |
| 2020-12-18 | E6 | Futures | 1.31323 | 1.31328 | 1.30853 | 1.31029 | 154512.0 |
| 2020-12-18 | E7 | Futures | 1.3066 | 1.3066 | 1.3021 | 1.3038 | 7412.0 |
| 2020-12-18 | EBM | Futures | 256.38 | 257.92 | 255.76 | 256.99 | 18204.0 |
| 2020-12-18 | ED | Futures | 96.518 | 96.5276 | 96.518 | 96.5276 | 95918.0 |
| 2020-12-18 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 45849.0 |
| 2020-12-18 | ESG | Futures | 343.79 | 344.58 | 340.11 | 342.42 | 496.0 |
| 2020-12-18 | EW | Futures | 2454.1 | 2468.1 | 2431.1 | 2443.2 | 21907.0 |
| 2020-12-18 | FBON | Futures | 150.98 | 150.98 | 150.5 | 150.74 | 64.0 |
| 2020-12-18 | FBTP | Futures | 139.24 | 139.27 | 138.62 | 138.87 | 86072.0 |
| 2020-12-18 | FBTS | Futures | 110.117 | 110.127 | 110.049 | 110.058 | 37169.0 |
| 2020-12-18 | FCE | Futures | 5368.9 | 5417.0 | 5335.8 | 5357.2 | 85770.0 |
| 2020-12-18 | FDAX | Futures | 14566.0 | 14671.6 | 14485.5 | 14528.2 | 61830.0 |
| 2020-12-18 | FDIV | Futures | 164.01 | 164.01 | 163.53 | 163.77 | 90.0 |
| 2020-12-18 | FDXM | Futures | 14532.1 | 14632.0 | 14446.0 | 14487.4 | 45266.0 |
| 2020-12-18 | FESX | Futures | 3293.2 | 3319.3 | 3267.2 | 3279.3 | 1077471.0 |
| 2020-12-18 | FGBL | Futures | 170.29 | 170.4 | 169.85 | 170.22 | 416574.0 |
| 2020-12-18 | FGBM | Futures | 135.24 | 135.27 | 135.1 | 135.21 | 229053.0 |
| 2020-12-18 | FGBS | Futures | 112.734 | 112.734 | 112.699 | 112.719 | 171451.0 |
| 2020-12-18 | FGBX | Futures | 235.75 | 236.28 | 234.33 | 235.65 | 41319.0 |
| 2020-12-18 | FMWO | Futures | 9420.9 | 9465.9 | 9343.9 | 9390.1 | 3199.0 |
| 2020-12-18 | FOAT | Futures | 158.78 | 158.9 | 158.38 | 158.74 | 115130.0 |
| 2020-12-18 | FTDX | Futures | 3240.2 | 3299.0 | 3240.2 | 3289.7 | 283.0 |
| 2020-12-18 | FTI | Futures | 581.23 | 587.25 | 581.09 | 583.58 | 22028.0 |
| 2020-12-18 | FTUK | Futures | 6273.6 | 6319.4 | 6222.1 | 6234.6 | 116147.0 |
| 2020-12-18 | FVSA | Futures | 161.19 | 169.11 | 159.68 | 166.09 | 17847.0 |
| 2020-12-18 | FXXP | Futures | 367.3 | 370.2 | 366.2 | 367.1 | 54777.0 |
| 2020-12-18 | G | Futures | 126.5 | 126.87 | 126.35 | 126.75 | 147771.0 |
> showing 50 of 121 rows — these rows as CSV