PREVIEW / futures_daily / 2021-07-19
file: by_date/futures_daily/2021/2021-07-19.parquet size: 10 KB rows: 125
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-19 | ES | Futures | 4856.0 | 4856.84 | 4748.09 | 4778.72 | 2599774.0 |
| 2021-07-19 | NQ | Futures | 16930.36 | 16939.01 | 16665.01 | 16775.47 | 720291.0 |
| 2021-07-19 | YM | Futures | 37468.7 | 37494.7 | 36458.1 | 36692.3 | 293528.0 |
| 2021-07-19 | CL | Futures | 51.45 | 51.68 | 47.45 | 48.02 | 731958.0 |
| 2021-07-19 | GC | Futures | 2118.9 | 2126.4 | 2099.5 | 2116.1 | 249675.0 |
| 2021-07-19 | ZN | Futures | 135.464738 | 136.429407 | 135.43311 | 136.318707 | 2253335.0 |
| 2021-07-19 | A6 | Futures | 0.7588 | 0.7589 | 0.75111 | 0.75172 | 107831.0 |
| 2021-07-19 | AD | Futures | 0.80369 | 0.80404 | 0.79157 | 0.79456 | 139044.0 |
| 2021-07-19 | ALI | Futures | 2862.19 | 2868.19 | 2788.21 | 2793.07 | 349.0 |
| 2021-07-19 | B | Futures | 48.1 | 48.42 | 44.73 | 45.31 | 510920.0 |
| 2021-07-19 | B6 | Futures | 1.3981 | 1.3985 | 1.3865 | 1.387 | 146696.0 |
| 2021-07-19 | BFX | Futures | 4186.5 | 4186.5 | 4154.9 | 4170.2 | 4.0 |
| 2021-07-19 | BR | Futures | 0.15559 | 0.15559 | 0.15154 | 0.15158 | 292.0 |
| 2021-07-19 | BTC | Futures | 45245.6 | 45388.1 | 43137.2 | 43721.3 | 3945.0 |
| 2021-07-19 | BZ | Futures | 47.11 | 47.3 | 43.79 | 44.29 | 58659.0 |
| 2021-07-19 | C | Futures | 1400.0 | 1401.0 | 1371.0 | 1372.0 | 9260.0 |
| 2021-07-19 | CB | Futures | 139.522 | 139.923 | 139.522 | 139.883 | 11.0 |
| 2021-07-19 | CC | Futures | 1508.0 | 1510.0 | 1466.0 | 1468.0 | 26442.0 |
| 2021-07-19 | CNH | Futures | 6.2699 | 6.2936 | 6.2699 | 6.2931 | 446.0 |
| 2021-07-19 | CSC | Futures | 2.49 | 2.498 | 2.47 | 2.493 | 88.0 |
| 2021-07-19 | CT | Futures | 83.74 | 83.74 | 80.4 | 80.56 | 205.0 |
| 2021-07-19 | DC | Futures | 22.5 | 22.66 | 22.24 | 22.51 | 243.0 |
| 2021-07-19 | DX | Futures | 89.603 | 89.941 | 89.535 | 89.796 | 24198.0 |
| 2021-07-19 | E1 | Futures | 1.22302 | 1.22729 | 1.21943 | 1.22448 | 24690.0 |
| 2021-07-19 | E6 | Futures | 1.25738 | 1.25919 | 1.25265 | 1.25557 | 224040.0 |
| 2021-07-19 | E7 | Futures | 1.2512 | 1.2529 | 1.2464 | 1.2493 | 5488.0 |
| 2021-07-19 | EBM | Futures | 319.6 | 319.96 | 312.61 | 315.18 | 15885.0 |
| 2021-07-19 | ED | Futures | 96.5393 | 96.549 | 96.5248 | 96.5345 | 288050.0 |
| 2021-07-19 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 20455.0 |
| 2021-07-19 | ESG | Futures | 400.39 | 400.39 | 393.35 | 395.67 | 871.0 |
| 2021-07-19 | EW | Futures | 2805.9 | 2805.9 | 2731.9 | 2756.1 | 14812.0 |
| 2021-07-19 | FBON | Futures | 150.02 | 150.18 | 149.7 | 149.99 | 473.0 |
| 2021-07-19 | FBTP | Futures | 140.14 | 140.18 | 139.72 | 139.94 | 92107.0 |
| 2021-07-19 | FBTS | Futures | 110.331 | 110.331 | 110.244 | 110.273 | 52614.0 |
| 2021-07-19 | FCE | Futures | 6395.0 | 6400.5 | 6234.9 | 6278.3 | 84808.0 |
| 2021-07-19 | FDAX | Futures | 16574.1 | 16579.5 | 16102.8 | 16169.2 | 132395.0 |
| 2021-07-19 | FDIV | Futures | 183.68 | 183.68 | 180.34 | 180.34 | 50.0 |
| 2021-07-19 | FDXM | Futures | 16478.0 | 16498.3 | 16021.8 | 16089.0 | 82195.0 |
| 2021-07-19 | FDXS | Futures | 16378.7 | 16378.7 | 15922.2 | 15986.8 | 17183.0 |
| 2021-07-19 | FESX | Futures | 3797.2 | 3798.2 | 3692.5 | 3711.4 | 1168199.0 |
| 2021-07-19 | FGBL | Futures | 169.67 | 170.22 | 169.54 | 170.02 | 742943.0 |
| 2021-07-19 | FGBM | Futures | 135.22 | 135.35 | 135.17 | 135.31 | 314394.0 |
| 2021-07-19 | FGBS | Futures | 112.624 | 112.649 | 112.614 | 112.634 | 234421.0 |
| 2021-07-19 | FGBX | Futures | 225.29 | 227.85 | 225.14 | 227.0 | 92070.0 |
| 2021-07-19 | FMWO | Futures | 10614.1 | 10614.1 | 10423.8 | 10472.0 | 4859.0 |
| 2021-07-19 | FOAT | Futures | 157.11 | 157.46 | 156.98 | 157.27 | 180907.0 |
| 2021-07-19 | FTDX | Futures | 3679.4 | 3679.4 | 3612.7 | 3641.4 | 156.0 |
| 2021-07-19 | FTI | Futures | 696.59 | 696.97 | 682.32 | 687.03 | 33159.0 |
| 2021-07-19 | FTUK | Futures | 6794.3 | 6796.2 | 6632.3 | 6664.3 | 152110.0 |
| 2021-07-19 | FVSA | Futures | 86.41 | 103.52 | 86.41 | 95.07 | 84214.0 |
> showing 50 of 125 rows — these rows as CSV