PREVIEW / futures_daily / 2021-07-15
file: by_date/futures_daily/2021/2021-07-15.parquet size: 10 KB rows: 124
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-15 | ES | Futures | 4908.27 | 4912.48 | 4870.05 | 4891.97 | 1611726.0 |
| 2021-07-15 | NQ | Futures | 17184.17 | 17262.33 | 16968.72 | 17060.15 | 634785.0 |
| 2021-07-15 | YM | Futures | 37732.1 | 37818.9 | 37509.9 | 37803.7 | 165523.0 |
| 2021-07-15 | CL | Futures | 52.42 | 52.46 | 51.4 | 51.66 | 329013.0 |
| 2021-07-15 | GC | Futures | 2138.9 | 2146.3 | 2129.4 | 2139.3 | 175611.0 |
| 2021-07-15 | ZN | Futures | 135.116825 | 135.496367 | 135.053568 | 135.417296 | 1503254.0 |
| 2021-07-15 | A6 | Futures | 0.76741 | 0.76803 | 0.76013 | 0.76085 | 66923.0 |
| 2021-07-15 | AD | Futures | 0.81008 | 0.81094 | 0.80374 | 0.80409 | 97477.0 |
| 2021-07-15 | ALI | Futures | 2906.46 | 2906.46 | 2906.46 | 2906.46 | 36.0 |
| 2021-07-15 | B | Futures | 49.19 | 49.25 | 48.32 | 48.51 | 322328.0 |
| 2021-07-15 | B6 | Futures | 1.4077 | 1.4115 | 1.4018 | 1.4024 | 112204.0 |
| 2021-07-15 | BFX | Futures | 4254.0 | 4254.5 | 4235.1 | 4235.1 | 3.0 |
| 2021-07-15 | BR | Futures | 0.15691 | 0.15763 | 0.15507 | 0.15511 | 739.0 |
| 2021-07-15 | BTC | Futures | 46912.4 | 47268.6 | 44120.2 | 44747.0 | 6733.0 |
| 2021-07-15 | BZ | Futures | 48.11 | 48.17 | 47.22 | 47.42 | 41748.0 |
| 2021-07-15 | C | Futures | 1438.0 | 1439.0 | 1410.0 | 1413.0 | 7247.0 |
| 2021-07-15 | CB | Futures | 142.009 | 142.009 | 140.405 | 140.405 | 54.0 |
| 2021-07-15 | CC | Futures | 1566.0 | 1574.0 | 1550.0 | 1554.0 | 12612.0 |
| 2021-07-15 | CNH | Futures | 6.2566 | 6.2664 | 6.2533 | 6.2583 | 400.0 |
| 2021-07-15 | CSC | Futures | 2.586 | 2.593 | 2.49 | 2.49 | 99.0 |
| 2021-07-15 | CT | Futures | 83.63 | 83.91 | 83.09 | 83.09 | 37.0 |
| 2021-07-15 | DC | Futures | 23.49 | 23.5 | 22.58 | 22.58 | 364.0 |
| 2021-07-15 | DX | Futures | 89.317 | 89.598 | 89.192 | 89.536 | 16279.0 |
| 2021-07-15 | E1 | Futures | 1.22976 | 1.23347 | 1.22336 | 1.22504 | 20931.0 |
| 2021-07-15 | E6 | Futures | 1.26015 | 1.26195 | 1.25616 | 1.25733 | 127524.0 |
| 2021-07-15 | E7 | Futures | 1.2541 | 1.2555 | 1.2499 | 1.2511 | 3544.0 |
| 2021-07-15 | EBM | Futures | 306.72 | 309.3 | 304.52 | 307.09 | 12835.0 |
| 2021-07-15 | ED | Futures | 96.549 | 96.549 | 96.5393 | 96.5442 | 136815.0 |
| 2021-07-15 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 28389.0 |
| 2021-07-15 | ESG | Futures | 405.95 | 408.64 | 403.47 | 405.08 | 449.0 |
| 2021-07-15 | EW | Futures | 2852.0 | 2852.1 | 2817.8 | 2839.3 | 8690.0 |
| 2021-07-15 | FBON | Futures | 149.45 | 149.68 | 149.34 | 149.43 | 617.0 |
| 2021-07-15 | FBTP | Futures | 139.76 | 140.02 | 139.55 | 139.66 | 101128.0 |
| 2021-07-15 | FBTS | Futures | 110.292 | 110.302 | 110.244 | 110.253 | 46166.0 |
| 2021-07-15 | FCE | Futures | 6531.8 | 6537.3 | 6450.9 | 6474.9 | 60898.0 |
| 2021-07-15 | FDAX | Futures | 16869.8 | 16890.1 | 16683.4 | 16723.0 | 86861.0 |
| 2021-07-15 | FDIV | Futures | 187.75 | 187.75 | 186.91 | 186.91 | 45.0 |
| 2021-07-15 | FDXM | Futures | 16788.2 | 16807.4 | 16601.7 | 16640.1 | 54398.0 |
| 2021-07-15 | FDXS | Futures | 16673.1 | 16692.2 | 16497.3 | 16534.4 | 11068.0 |
| 2021-07-15 | FESX | Futures | 3866.9 | 3871.6 | 3821.4 | 3835.2 | 702825.0 |
| 2021-07-15 | FGBL | Futures | 169.09 | 169.42 | 168.99 | 169.11 | 623769.0 |
| 2021-07-15 | FGBM | Futures | 135.09 | 135.16 | 135.04 | 135.09 | 323834.0 |
| 2021-07-15 | FGBS | Futures | 112.604 | 112.619 | 112.594 | 112.609 | 166024.0 |
| 2021-07-15 | FGBX | Futures | 222.87 | 224.63 | 222.87 | 223.41 | 82550.0 |
| 2021-07-15 | FMWO | Futures | 10783.3 | 10783.3 | 10697.5 | 10741.0 | 2364.0 |
| 2021-07-15 | FOAT | Futures | 156.62 | 156.93 | 156.55 | 156.67 | 226974.0 |
| 2021-07-15 | FTDX | Futures | 3713.2 | 3718.9 | 3694.3 | 3703.0 | 137.0 |
| 2021-07-15 | FTI | Futures | 707.93 | 709.75 | 701.52 | 704.78 | 16162.0 |
| 2021-07-15 | FTUK | Futures | 6906.5 | 6933.6 | 6823.3 | 6830.7 | 114086.0 |
| 2021-07-15 | FVSA | Futures | 81.97 | 85.14 | 81.97 | 83.24 | 36982.0 |
> showing 50 of 124 rows — these rows as CSV