PREVIEW / futures_daily / 2020-12-30
file: by_date/futures_daily/2020/2020-12-30.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-30 | ES | Futures | 4174.43 | 4189.84 | 4165.46 | 4174.15 | 769995.0 |
| 2020-12-30 | NQ | Futures | 14833.83 | 14890.35 | 14787.41 | 14811.63 | 334304.0 |
| 2020-12-30 | YM | Futures | 32692.4 | 32846.8 | 32625.5 | 32723.7 | 96134.0 |
| 2020-12-30 | CL | Futures | 33.98 | 34.35 | 33.61 | 34.17 | 266957.0 |
| 2020-12-30 | GC | Futures | 2213.4 | 2233.6 | 2210.6 | 2227.0 | 133658.0 |
| 2020-12-30 | ZN | Futures | 137.149314 | 137.24256 | 137.009445 | 137.227019 | 741740.0 |
| 2020-12-30 | A6 | Futures | 0.78069 | 0.789 | 0.78069 | 0.78797 | 76426.0 |
| 2020-12-30 | AD | Futures | 0.79044 | 0.79469 | 0.78993 | 0.79368 | 47221.0 |
| 2020-12-30 | ALI | Futures | 2358.71 | 2358.71 | 2358.71 | 2358.71 | 0.0 |
| 2020-12-30 | B | Futures | 32.46 | 32.79 | 32.17 | 32.61 | 236911.0 |
| 2020-12-30 | B6 | Futures | 1.3722 | 1.3844 | 1.3708 | 1.3829 | 86234.0 |
| 2020-12-30 | BR | Futures | 0.15016 | 0.15129 | 0.14895 | 0.15059 | 95.0 |
| 2020-12-30 | BTC | Futures | 35524.0 | 38196.6 | 35420.0 | 37917.0 | 13789.0 |
| 2020-12-30 | BZ | Futures | 31.76 | 32.13 | 31.52 | 31.95 | 23958.0 |
| 2020-12-30 | C | Futures | 1426.0 | 1487.0 | 1418.0 | 1482.0 | 8359.0 |
| 2020-12-30 | CB | Futures | 150.884 | 151.807 | 149.961 | 149.961 | 20.0 |
| 2020-12-30 | CC | Futures | 1645.0 | 1713.0 | 1642.0 | 1707.0 | 19037.0 |
| 2020-12-30 | CNH | Futures | 6.3934 | 6.3934 | 6.3733 | 6.3797 | 553.0 |
| 2020-12-30 | CSC | Futures | 3.178 | 3.204 | 3.178 | 3.204 | 25.0 |
| 2020-12-30 | CT | Futures | 74.39 | 75.42 | 74.3 | 75.33 | 13031.0 |
| 2020-12-30 | DC | Futures | 27.04 | 27.22 | 26.84 | 27.01 | 75.0 |
| 2020-12-30 | DX | Futures | 86.885 | 86.919 | 86.547 | 86.677 | 23431.0 |
| 2020-12-30 | E1 | Futures | 1.27996 | 1.28357 | 1.27714 | 1.28188 | 22909.0 |
| 2020-12-30 | E6 | Futures | 1.31056 | 1.31649 | 1.31019 | 1.31419 | 133830.0 |
| 2020-12-30 | E7 | Futures | 1.3041 | 1.3099 | 1.3037 | 1.3077 | 10351.0 |
| 2020-12-30 | EBM | Futures | 260.08 | 264.39 | 260.08 | 262.54 | 14681.0 |
| 2020-12-30 | ED | Futures | 96.5276 | 96.5276 | 96.5228 | 96.5276 | 44870.0 |
| 2020-12-30 | ER | Futures | 98.46 | 98.465 | 98.455 | 98.46 | 45790.0 |
| 2020-12-30 | ESG | Futures | 346.17 | 346.32 | 344.8 | 344.8 | 156.0 |
| 2020-12-30 | EW | Futures | 2444.3 | 2475.9 | 2434.4 | 2460.5 | 11652.0 |
| 2020-12-30 | FBON | Futures | 150.62 | 150.81 | 150.56 | 150.67 | 146.0 |
| 2020-12-30 | FBTP | Futures | 139.19 | 139.29 | 138.84 | 139.12 | 42752.0 |
| 2020-12-30 | FBTS | Futures | 110.078 | 110.097 | 110.049 | 110.049 | 18164.0 |
| 2020-12-30 | FCE | Futures | 5434.5 | 5459.3 | 5403.4 | 5433.0 | 31391.0 |
| 2020-12-30 | FDAX | Futures | 14587.9 | 14698.7 | 14549.5 | 14654.0 | 25782.0 |
| 2020-12-30 | FDIV | Futures | 163.87 | 164.11 | 163.49 | 163.68 | 134.0 |
| 2020-12-30 | FDXM | Futures | 14547.0 | 14656.5 | 14500.2 | 14612.9 | 23770.0 |
| 2020-12-30 | FESX | Futures | 3296.0 | 3323.9 | 3286.7 | 3300.7 | 525690.0 |
| 2020-12-30 | FGBL | Futures | 170.28 | 170.39 | 169.84 | 170.2 | 357909.0 |
| 2020-12-30 | FGBM | Futures | 135.2 | 135.21 | 135.05 | 135.16 | 171596.0 |
| 2020-12-30 | FGBS | Futures | 112.689 | 112.699 | 112.669 | 112.689 | 209310.0 |
| 2020-12-30 | FGBX | Futures | 236.28 | 236.63 | 234.62 | 235.77 | 35942.0 |
| 2020-12-30 | FMWO | Futures | 9496.7 | 9509.8 | 9469.5 | 9495.6 | 2044.0 |
| 2020-12-30 | FOAT | Futures | 158.88 | 159.0 | 158.54 | 158.85 | 98765.0 |
| 2020-12-30 | FTDX | Futures | 3324.2 | 3332.5 | 3311.4 | 3322.2 | 29.0 |
| 2020-12-30 | FTI | Futures | 587.25 | 589.26 | 583.8 | 586.33 | 11477.0 |
| 2020-12-30 | FTUK | Futures | 6300.1 | 6331.9 | 6218.3 | 6266.4 | 86808.0 |
| 2020-12-30 | FVSA | Futures | 169.87 | 172.51 | 166.47 | 170.25 | 11377.0 |
| 2020-12-30 | FXXP | Futures | 372.1 | 373.4 | 369.6 | 371.3 | 36845.0 |
| 2020-12-30 | G | Futures | 127.03 | 127.2 | 126.69 | 127.03 | 113617.0 |
> showing 50 of 121 rows — these rows as CSV