PREVIEW / futures_daily / 2021-08-19
file: by_date/futures_daily/2021/2021-08-19.parquet size: 10 KB rows: 123
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-08-19 | ES | Futures | 4934.4 | 4962.5 | 4887.19 | 4947.61 | 1924058.0 |
| 2021-08-19 | NQ | Futures | 17120.72 | 17304.15 | 16971.31 | 17222.24 | 734184.0 |
| 2021-08-19 | YM | Futures | 37799.4 | 37879.6 | 37402.5 | 37753.8 | 258172.0 |
| 2021-08-19 | CL | Futures | 47.21 | 47.29 | 45.71 | 46.51 | 494970.0 |
| 2021-08-19 | GC | Futures | 2087.7 | 2094.1 | 2070.3 | 2080.3 | 151245.0 |
| 2021-08-19 | ZN | Futures | 135.84428 | 136.160565 | 135.796837 | 135.95498 | 1408900.0 |
| 2021-08-19 | A6 | Futures | 0.74218 | 0.7428 | 0.73254 | 0.73331 | 119768.0 |
| 2021-08-19 | AD | Futures | 0.8009 | 0.80151 | 0.7901 | 0.79076 | 120308.0 |
| 2021-08-19 | ALI | Futures | 2917.75 | 2938.84 | 2899.22 | 2929.15 | 783.0 |
| 2021-08-19 | B | Futures | 45.0 | 45.05 | 43.67 | 44.25 | 345974.0 |
| 2021-08-19 | B6 | Futures | 1.3958 | 1.397 | 1.3842 | 1.3849 | 102683.0 |
| 2021-08-19 | BR | Futures | 0.1483 | 0.1485 | 0.14646 | 0.1473 | 22318.0 |
| 2021-08-19 | BTC | Futures | 59709.5 | 62880.7 | 58864.8 | 62619.2 | 6208.0 |
| 2021-08-19 | BZ | Futures | 43.83 | 43.97 | 42.62 | 43.19 | 35816.0 |
| 2021-08-19 | C | Futures | 1518.0 | 1525.0 | 1508.0 | 1523.0 | 2866.0 |
| 2021-08-19 | CB | Futures | 137.677 | 137.677 | 136.393 | 137.195 | 16.0 |
| 2021-08-19 | CC | Futures | 1712.0 | 1712.0 | 1680.0 | 1688.0 | 21785.0 |
| 2021-08-19 | CNH | Futures | 6.2643 | 6.2857 | 6.2643 | 6.281 | 1197.0 |
| 2021-08-19 | CSC | Futures | 2.502 | 2.522 | 2.467 | 2.473 | 327.0 |
| 2021-08-19 | CT | Futures | 88.08 | 88.31 | 86.26 | 86.44 | 21.0 |
| 2021-08-19 | DC | Futures | 22.34 | 22.72 | 22.25 | 22.32 | 635.0 |
| 2021-08-19 | DX | Futures | 90.1 | 90.477 | 90.1 | 90.461 | 20625.0 |
| 2021-08-19 | E1 | Futures | 1.22549 | 1.22875 | 1.22044 | 1.22325 | 21908.0 |
| 2021-08-19 | E6 | Futures | 1.24595 | 1.24674 | 1.24137 | 1.24244 | 134972.0 |
| 2021-08-19 | E7 | Futures | 1.2399 | 1.2405 | 1.2352 | 1.2363 | 3951.0 |
| 2021-08-19 | EBM | Futures | 373.29 | 385.43 | 369.24 | 383.96 | 9246.0 |
| 2021-08-19 | ED | Futures | 96.5393 | 96.5418 | 96.5345 | 96.5345 | 235606.0 |
| 2021-08-19 | ER | Futures | 98.47 | 98.47 | 98.465 | 98.47 | 9175.0 |
| 2021-08-19 | ESG | Futures | 404.19 | 410.6 | 403.91 | 409.03 | 365.0 |
| 2021-08-19 | EW | Futures | 2855.2 | 2863.2 | 2809.5 | 2836.9 | 12370.0 |
| 2021-08-19 | FBON | Futures | 151.83 | 151.83 | 151.54 | 151.66 | 262.0 |
| 2021-08-19 | FBTP | Futures | 141.87 | 141.95 | 141.65 | 141.74 | 105084.0 |
| 2021-08-19 | FBTS | Futures | 110.497 | 110.536 | 110.497 | 110.507 | 32846.0 |
| 2021-08-19 | FCE | Futures | 6712.1 | 6712.1 | 6547.4 | 6594.3 | 83345.0 |
| 2021-08-19 | FDAX | Futures | 17011.2 | 17025.1 | 16727.3 | 16866.6 | 105890.0 |
| 2021-08-19 | FDXM | Futures | 16930.0 | 16940.7 | 16644.3 | 16782.9 | 73092.0 |
| 2021-08-19 | FDXS | Futures | 16817.2 | 16827.7 | 16537.5 | 16676.3 | 18024.0 |
| 2021-08-19 | FESX | Futures | 3950.8 | 3952.7 | 3866.0 | 3904.8 | 1099756.0 |
| 2021-08-19 | FGBL | Futures | 171.47 | 171.69 | 171.32 | 171.5 | 518027.0 |
| 2021-08-19 | FGBM | Futures | 135.84 | 135.87 | 135.77 | 135.84 | 283764.0 |
| 2021-08-19 | FGBS | Futures | 112.744 | 112.764 | 112.744 | 112.759 | 212386.0 |
| 2021-08-19 | FGBX | Futures | 232.94 | 234.03 | 232.64 | 233.24 | 65693.0 |
| 2021-08-19 | FMWO | Futures | 10796.2 | 10851.5 | 10709.3 | 10803.3 | 4552.0 |
| 2021-08-19 | FOAT | Futures | 158.51 | 158.64 | 158.32 | 158.52 | 135116.0 |
| 2021-08-19 | FTDX | Futures | 3954.4 | 3954.4 | 3894.9 | 3931.8 | 241.0 |
| 2021-08-19 | FTI | Futures | 731.64 | 734.65 | 721.5 | 731.47 | 16508.0 |
| 2021-08-19 | FTUK | Futures | 6980.9 | 6990.7 | 6863.7 | 6924.2 | 130612.0 |
| 2021-08-19 | FVSA | Futures | 81.39 | 87.99 | 80.22 | 85.47 | 59559.0 |
| 2021-08-19 | FXXP | Futures | 446.7 | 446.9 | 440.6 | 443.9 | 67503.0 |
| 2021-08-19 | G | Futures | 124.11 | 124.37 | 124.05 | 124.19 | 181423.0 |
> showing 50 of 123 rows — these rows as CSV