PREVIEW / futures_daily / 2021-05-18
file: by_date/futures_daily/2021/2021-05-18.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 |
|---|---|---|---|---|---|---|---|
| 2021-05-18 | ES | Futures | 4667.04 | 4690.04 | 4613.74 | 4626.64 | 1285520.0 |
| 2021-05-18 | NQ | Futures | 15350.28 | 15493.01 | 15200.33 | 15238.97 | 442088.0 |
| 2021-05-18 | YM | Futures | 37118.7 | 37257.2 | 36698.8 | 36795.1 | 130449.0 |
| 2021-05-18 | CL | Futures | 47.2 | 47.7 | 45.65 | 46.62 | 484415.0 |
| 2021-05-18 | GC | Futures | 2189.1 | 2199.2 | 2184.7 | 2189.9 | 229016.0 |
| 2021-05-18 | ZN | Futures | 132.924126 | 133.128286 | 132.908421 | 133.065468 | 998216.0 |
| 2021-05-18 | A6 | Futures | 0.79664 | 0.80125 | 0.79623 | 0.79997 | 78234.0 |
| 2021-05-18 | AD | Futures | 0.83942 | 0.84343 | 0.83861 | 0.84024 | 65089.0 |
| 2021-05-18 | ALI | Futures | 2863.0 | 2863.0 | 2812.83 | 2824.95 | 1036.0 |
| 2021-05-18 | B | Futures | 45.53 | 45.94 | 44.0 | 44.94 | 378016.0 |
| 2021-05-18 | B6 | Futures | 1.4354 | 1.4442 | 1.4354 | 1.4411 | 85416.0 |
| 2021-05-18 | BR | Futures | 0.15032 | 0.15112 | 0.14969 | 0.15052 | 4192.0 |
| 2021-05-18 | BTC | Futures | 60073.6 | 63187.8 | 58388.8 | 59590.3 | 8310.0 |
| 2021-05-18 | BZ | Futures | 44.38 | 44.83 | 42.94 | 43.86 | 43138.0 |
| 2021-05-18 | C | Futures | 1546.0 | 1552.0 | 1528.0 | 1529.0 | 5928.0 |
| 2021-05-18 | CB | Futures | 152.523 | 153.555 | 152.503 | 152.668 | 9.0 |
| 2021-05-18 | CC | Futures | 1689.0 | 1691.0 | 1665.0 | 1668.0 | 17015.0 |
| 2021-05-18 | CNH | Futures | 6.2552 | 6.2552 | 6.2303 | 6.2303 | 389.0 |
| 2021-05-18 | CSC | Futures | 2.886 | 2.886 | 2.798 | 2.808 | 144.0 |
| 2021-05-18 | CT | Futures | 76.76 | 78.6 | 76.76 | 78.33 | 14835.0 |
| 2021-05-18 | DC | Futures | 26.74 | 26.77 | 25.98 | 26.08 | 507.0 |
| 2021-05-18 | DX | Futures | 87.151 | 87.156 | 86.658 | 86.715 | 21722.0 |
| 2021-05-18 | E1 | Futures | 1.24715 | 1.25682 | 1.24647 | 1.25626 | 23073.0 |
| 2021-05-18 | E6 | Futures | 1.29578 | 1.30441 | 1.29562 | 1.30377 | 178672.0 |
| 2021-05-18 | E7 | Futures | 1.2892 | 1.2978 | 1.2891 | 1.2972 | 5149.0 |
| 2021-05-18 | EBM | Futures | 318.12 | 321.43 | 314.81 | 316.29 | 14946.0 |
| 2021-05-18 | ED | Futures | 96.5246 | 96.5294 | 96.5222 | 96.527 | 151270.0 |
| 2021-05-18 | ER | Futures | 98.455 | 98.465 | 98.455 | 98.46 | 67912.0 |
| 2021-05-18 | ESG | Futures | 387.25 | 387.3 | 382.26 | 382.33 | 681.0 |
| 2021-05-18 | EW | Futures | 2908.9 | 2919.5 | 2867.7 | 2875.2 | 11767.0 |
| 2021-05-18 | FBON | Futures | 145.39 | 145.7 | 145.13 | 145.52 | 879.0 |
| 2021-05-18 | FBTP | Futures | 135.05 | 135.4 | 134.81 | 135.25 | 144118.0 |
| 2021-05-18 | FBTS | Futures | 109.777 | 109.845 | 109.757 | 109.845 | 67659.0 |
| 2021-05-18 | FCE | Futures | 6356.5 | 6373.0 | 6280.7 | 6307.6 | 52597.0 |
| 2021-05-18 | FDAX | Futures | 16458.8 | 16564.3 | 16330.9 | 16422.6 | 51211.0 |
| 2021-05-18 | FDIV | Futures | 187.94 | 187.99 | 187.35 | 187.45 | 32.0 |
| 2021-05-18 | FDXM | Futures | 16434.5 | 16544.2 | 16303.6 | 16402.6 | 40549.0 |
| 2021-05-18 | FDXS | Futures | 16360.7 | 16456.0 | 16224.1 | 16315.1 | 2643.0 |
| 2021-05-18 | FESX | Futures | 3793.2 | 3813.1 | 3760.1 | 3785.6 | 673747.0 |
| 2021-05-18 | FEU3 | Futures | 99.203 | 99.203 | 99.203 | 99.203 | 50.0 |
| 2021-05-18 | FGBL | Futures | 165.07 | 165.37 | 164.93 | 165.06 | 842696.0 |
| 2021-05-18 | FGBM | Futures | 134.11 | 134.17 | 134.05 | 134.1 | 479797.0 |
| 2021-05-18 | FGBS | Futures | 112.569 | 112.579 | 112.554 | 112.569 | 292652.0 |
| 2021-05-18 | FGBX | Futures | 210.42 | 211.46 | 209.76 | 210.21 | 93295.0 |
| 2021-05-18 | FMWO | Futures | 10407.4 | 10407.4 | 10300.5 | 10365.1 | 4678.0 |
| 2021-05-18 | FOAT | Futures | 152.78 | 153.13 | 152.65 | 152.88 | 226653.0 |
| 2021-05-18 | FTDX | Futures | 3431.4 | 3465.3 | 3407.2 | 3427.8 | 247.0 |
| 2021-05-18 | FTI | Futures | 671.88 | 674.31 | 665.97 | 669.39 | 12233.0 |
| 2021-05-18 | FTUK | Futures | 6857.2 | 6901.1 | 6807.1 | 6844.6 | 77984.0 |
| 2021-05-18 | FVSA | Futures | 109.37 | 112.76 | 105.99 | 108.33 | 42537.0 |
> showing 50 of 122 rows — these rows as CSV