PREVIEW / futures_daily / 2021-01-15
file: by_date/futures_daily/2021/2021-01-15.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-15 | ES | Futures | 4251.2 | 4256.53 | 4193.48 | 4216.74 | 1781463.0 |
| 2021-01-15 | NQ | Futures | 14889.49 | 14915.15 | 14698.6 | 14766.36 | 539769.0 |
| 2021-01-15 | YM | Futures | 33374.9 | 33431.1 | 32944.0 | 33175.1 | 198844.0 |
| 2021-01-15 | CL | Futures | 37.97 | 38.04 | 36.65 | 37.02 | 391293.0 |
| 2021-01-15 | GC | Futures | 2172.8 | 2183.7 | 2143.1 | 2152.3 | 231105.0 |
| 2021-01-15 | ZN | Futures | 135.797247 | 136.216854 | 135.781706 | 136.123608 | 1385980.0 |
| 2021-01-15 | A6 | Futures | 0.79803 | 0.79926 | 0.78818 | 0.7911 | 114166.0 |
| 2021-01-15 | AD | Futures | 0.80097 | 0.80178 | 0.79358 | 0.79596 | 89672.0 |
| 2021-01-15 | ALI | Futures | 2322.01 | 2322.01 | 2322.01 | 2322.01 | 44.0 |
| 2021-01-15 | B | Futures | 35.63 | 35.68 | 34.51 | 34.8 | 298410.0 |
| 2021-01-15 | B6 | Futures | 1.3906 | 1.3915 | 1.3787 | 1.3796 | 76673.0 |
| 2021-01-15 | BR | Futures | 0.1495 | 0.14958 | 0.14684 | 0.14755 | 248.0 |
| 2021-01-15 | BTC | Futures | 50987.4 | 51995.3 | 44939.9 | 46331.5 | 14051.0 |
| 2021-01-15 | BZ | Futures | 34.92 | 35.05 | 33.82 | 34.1 | 30604.0 |
| 2021-01-15 | C | Futures | 1458.0 | 1487.0 | 1458.0 | 1479.0 | 5845.0 |
| 2021-01-15 | CB | Futures | 150.423 | 150.423 | 147.447 | 147.654 | 23.0 |
| 2021-01-15 | CC | Futures | 1665.0 | 1682.0 | 1651.0 | 1661.0 | 14459.0 |
| 2021-01-15 | CNH | Futures | 6.329 | 6.3478 | 6.3253 | 6.3478 | 548.0 |
| 2021-01-15 | CSC | Futures | 3.345 | 3.357 | 3.308 | 3.357 | 69.0 |
| 2021-01-15 | CT | Futures | 78.38 | 78.67 | 77.87 | 77.97 | 12908.0 |
| 2021-01-15 | DC | Futures | 29.07 | 29.07 | 28.14 | 28.9 | 254.0 |
| 2021-01-15 | DX | Futures | 87.209 | 87.78 | 87.205 | 87.745 | 29416.0 |
| 2021-01-15 | E1 | Futures | 1.27274 | 1.27443 | 1.26777 | 1.26845 | 14955.0 |
| 2021-01-15 | E6 | Futures | 1.29898 | 1.30026 | 1.2907 | 1.29113 | 142815.0 |
| 2021-01-15 | E7 | Futures | 1.2928 | 1.2937 | 1.2841 | 1.2848 | 6003.0 |
| 2021-01-15 | EBM | Futures | 289.66 | 290.58 | 284.73 | 285.34 | 49009.0 |
| 2021-01-15 | ED | Futures | 96.5131 | 96.5228 | 96.5131 | 96.518 | 102550.0 |
| 2021-01-15 | ER | Futures | 98.47 | 98.475 | 98.465 | 98.47 | 35263.0 |
| 2021-01-15 | ESG | Futures | 347.91 | 349.72 | 345.62 | 347.3 | 611.0 |
| 2021-01-15 | EW | Futures | 2620.6 | 2621.5 | 2561.3 | 2589.9 | 15847.0 |
| 2021-01-15 | FBON | Futures | 150.56 | 150.61 | 150.34 | 150.41 | 423.0 |
| 2021-01-15 | FBTP | Futures | 138.26 | 138.63 | 138.2 | 138.51 | 121616.0 |
| 2021-01-15 | FBTS | Futures | 109.816 | 109.922 | 109.806 | 109.884 | 62264.0 |
| 2021-01-15 | FCE | Futures | 5464.7 | 5487.0 | 5392.3 | 5440.9 | 88653.0 |
| 2021-01-15 | FDAX | Futures | 14882.1 | 14899.2 | 14561.2 | 14687.0 | 69030.0 |
| 2021-01-15 | FDIV | Futures | 166.49 | 166.68 | 163.96 | 164.63 | 350.0 |
| 2021-01-15 | FDXM | Futures | 14846.7 | 14854.2 | 14520.4 | 14645.8 | 48503.0 |
| 2021-01-15 | FESX | Futures | 3369.5 | 3371.3 | 3309.0 | 3333.2 | 1078250.0 |
| 2021-01-15 | FGBL | Futures | 170.21 | 170.48 | 170.06 | 170.22 | 547660.0 |
| 2021-01-15 | FGBM | Futures | 135.25 | 135.33 | 135.2 | 135.24 | 321451.0 |
| 2021-01-15 | FGBS | Futures | 112.729 | 112.744 | 112.709 | 112.719 | 272162.0 |
| 2021-01-15 | FGBX | Futures | 234.58 | 235.65 | 233.83 | 234.52 | 67496.0 |
| 2021-01-15 | FMWO | Futures | 9628.2 | 9647.2 | 9525.2 | 9583.2 | 2258.0 |
| 2021-01-15 | FOAT | Futures | 158.69 | 158.92 | 158.54 | 158.66 | 131324.0 |
| 2021-01-15 | FTDX | Futures | 3382.5 | 3382.5 | 3343.3 | 3354.7 | 29.0 |
| 2021-01-15 | FTI | Futures | 611.06 | 613.64 | 606.09 | 610.08 | 27858.0 |
| 2021-01-15 | FTUK | Futures | 6497.1 | 6507.7 | 6384.9 | 6437.8 | 118157.0 |
| 2021-01-15 | FVSA | Futures | 159.14 | 168.03 | 158.79 | 162.34 | 25949.0 |
| 2021-01-15 | FXXP | Futures | 380.0 | 381.3 | 375.8 | 378.2 | 59601.0 |
| 2021-01-15 | G | Futures | 126.29 | 126.31 | 126.01 | 126.26 | 145749.0 |
> showing 50 of 121 rows — these rows as CSV