PREVIEW / futures_daily / 2021-01-07
file: by_date/futures_daily/2021/2021-01-07.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 |
|---|---|---|---|---|---|---|---|
| 2021-01-07 | ES | Futures | 4205.81 | 4263.53 | 4194.04 | 4254.0 | 1302021.0 |
| 2021-01-07 | NQ | Futures | 14600.56 | 14947.16 | 14586.71 | 14911.4 | 435939.0 |
| 2021-01-07 | YM | Futures | 33250.7 | 33571.5 | 33149.2 | 33414.9 | 167866.0 |
| 2021-01-07 | CL | Futures | 35.67 | 36.2 | 35.57 | 35.88 | 369292.0 |
| 2021-01-07 | GC | Futures | 2260.0 | 2269.6 | 2243.6 | 2250.8 | 199982.0 |
| 2021-01-07 | ZN | Futures | 136.496592 | 136.558756 | 136.108067 | 136.216854 | 1719014.0 |
| 2021-01-07 | A6 | Futures | 0.8011 | 0.80233 | 0.7929 | 0.79628 | 99274.0 |
| 2021-01-07 | AD | Futures | 0.799 | 0.79996 | 0.79556 | 0.79864 | 60813.0 |
| 2021-01-07 | ALI | Futures | 2384.35 | 2393.97 | 2357.55 | 2378.23 | 319.0 |
| 2021-01-07 | B | Futures | 34.19 | 34.67 | 34.07 | 34.34 | 267188.0 |
| 2021-01-07 | B6 | Futures | 1.3827 | 1.385 | 1.3747 | 1.3787 | 81321.0 |
| 2021-01-07 | BR | Futures | 0.14759 | 0.14763 | 0.14407 | 0.1445 | 532.0 |
| 2021-01-07 | BTC | Futures | 47397.9 | 53321.8 | 47397.9 | 51533.6 | 16834.0 |
| 2021-01-07 | BZ | Futures | 33.5 | 33.97 | 33.38 | 33.65 | 30800.0 |
| 2021-01-07 | C | Futures | 1424.0 | 1461.0 | 1417.0 | 1455.0 | 5651.0 |
| 2021-01-07 | CB | Futures | 154.576 | 155.037 | 153.422 | 154.114 | 65.0 |
| 2021-01-07 | CC | Futures | 1630.0 | 1677.0 | 1622.0 | 1674.0 | 22080.0 |
| 2021-01-07 | CNH | Futures | 6.3107 | 6.3345 | 6.2997 | 6.3305 | 751.0 |
| 2021-01-07 | CSC | Futures | 3.404 | 3.5 | 3.36 | 3.414 | 144.0 |
| 2021-01-07 | CT | Futures | 77.28 | 77.97 | 76.95 | 77.06 | 14656.0 |
| 2021-01-07 | DC | Futures | 28.87 | 29.75 | 28.48 | 29.04 | 380.0 |
| 2021-01-07 | DX | Futures | 86.368 | 86.987 | 86.363 | 86.814 | 23326.0 |
| 2021-01-07 | E1 | Futures | 1.28684 | 1.28842 | 1.27601 | 1.27736 | 23588.0 |
| 2021-01-07 | E6 | Futures | 1.31803 | 1.3199 | 1.30923 | 1.31168 | 160942.0 |
| 2021-01-07 | E7 | Futures | 1.3116 | 1.3133 | 1.3027 | 1.3052 | 10284.0 |
| 2021-01-07 | EBM | Futures | 265.01 | 265.62 | 263.46 | 264.39 | 27342.0 |
| 2021-01-07 | ED | Futures | 96.518 | 96.5228 | 96.5131 | 96.518 | 159100.0 |
| 2021-01-07 | ER | Futures | 98.47 | 98.475 | 98.47 | 98.47 | 44814.0 |
| 2021-01-07 | ESG | Futures | 347.32 | 351.4 | 347.28 | 350.74 | 947.0 |
| 2021-01-07 | EW | Futures | 2557.2 | 2591.6 | 2547.3 | 2587.3 | 13881.0 |
| 2021-01-07 | FBON | Futures | 150.43 | 150.86 | 150.43 | 150.66 | 289.0 |
| 2021-01-07 | FBTP | Futures | 138.84 | 139.22 | 138.75 | 139.1 | 115260.0 |
| 2021-01-07 | FBTS | Futures | 110.029 | 110.058 | 110.01 | 110.049 | 46852.0 |
| 2021-01-07 | FCE | Futures | 5500.6 | 5528.8 | 5469.5 | 5509.3 | 59607.0 |
| 2021-01-07 | FDAX | Futures | 14793.6 | 14927.9 | 14793.6 | 14903.4 | 42275.0 |
| 2021-01-07 | FDIV | Futures | 166.68 | 167.3 | 166.68 | 167.21 | 210.0 |
| 2021-01-07 | FDXM | Futures | 14764.9 | 14882.9 | 14760.6 | 14861.6 | 35366.0 |
| 2021-01-07 | FESX | Futures | 3347.2 | 3368.5 | 3337.9 | 3361.1 | 814210.0 |
| 2021-01-07 | FGBL | Futures | 170.03 | 170.24 | 169.75 | 169.82 | 792789.0 |
| 2021-01-07 | FGBM | Futures | 135.12 | 135.21 | 135.06 | 135.1 | 354683.0 |
| 2021-01-07 | FGBS | Futures | 112.684 | 112.704 | 112.684 | 112.684 | 267318.0 |
| 2021-01-07 | FGBX | Futures | 234.92 | 235.54 | 233.53 | 233.64 | 90917.0 |
| 2021-01-07 | FMWO | Futures | 9597.4 | 9676.8 | 9552.4 | 9651.9 | 2489.0 |
| 2021-01-07 | FOAT | Futures | 158.54 | 158.89 | 158.45 | 158.54 | 275157.0 |
| 2021-01-07 | FTDX | Futures | 3332.0 | 3351.1 | 3320.6 | 3349.5 | 154.0 |
| 2021-01-07 | FTI | Futures | 597.71 | 599.86 | 593.84 | 595.16 | 17405.0 |
| 2021-01-07 | FTUK | Futures | 6550.0 | 6655.0 | 6497.6 | 6577.5 | 125024.0 |
| 2021-01-07 | FVSA | Futures | 160.81 | 165.34 | 158.54 | 159.3 | 23548.0 |
| 2021-01-07 | FXXP | Futures | 380.1 | 380.1 | 377.0 | 379.5 | 49179.0 |
| 2021-01-07 | G | Futures | 126.55 | 126.75 | 126.13 | 126.18 | 244910.0 |
> showing 50 of 121 rows — these rows as CSV