PREVIEW / futures_daily / 2019-10-21
file: by_date/futures_daily/2019/2019-10-21.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 |
|---|---|---|---|---|---|---|---|
| 2019-10-21 | ES | Futures | 3231.19 | 3255.82 | 3230.11 | 3254.74 | 886557.0 |
| 2019-10-21 | NQ | Futures | 9074.45 | 9163.76 | 9064.65 | 9159.73 | 275031.0 |
| 2019-10-21 | YM | Futures | 28055.7 | 28173.2 | 28030.5 | 28131.2 | 112065.0 |
| 2019-10-21 | CL | Futures | 54.99 | 55.34 | 53.99 | 54.67 | 509426.0 |
| 2019-10-21 | GC | Futures | 1844.9 | 1848.7 | 1831.6 | 1835.6 | 284292.0 |
| 2019-10-21 | ZN | Futures | 128.923215 | 128.954183 | 128.365776 | 128.458682 | 926760.0 |
| 2019-10-21 | A6 | Futures | 0.70399 | 0.70707 | 0.70286 | 0.70543 | 76444.0 |
| 2019-10-21 | AD | Futures | 0.76756 | 0.77038 | 0.767 | 0.77013 | 70777.0 |
| 2019-10-21 | ALI | Futures | 2122.95 | 2133.27 | 2110.8 | 2114.14 | 155.0 |
| 2019-10-21 | B | Futures | 46.92 | 47.17 | 46.15 | 46.71 | 212574.0 |
| 2019-10-21 | B6 | Futures | 1.3159 | 1.3256 | 1.3113 | 1.3211 | 134064.0 |
| 2019-10-21 | BFX | Futures | 4584.9 | 4587.3 | 4563.1 | 4563.1 | 200.0 |
| 2019-10-21 | BR | Futures | 0.1957 | 0.1957 | 0.19421 | 0.19497 | 151.0 |
| 2019-10-21 | BTC | Futures | 11872.9 | 12052.7 | 11736.3 | 11801.0 | 3642.0 |
| 2019-10-21 | BZ | Futures | 46.37 | 46.51 | 45.51 | 46.05 | 35588.0 |
| 2019-10-21 | C | Futures | 1665.0 | 1670.0 | 1642.0 | 1655.0 | 6490.0 |
| 2019-10-21 | CB | Futures | 247.983 | 247.983 | 247.127 | 247.157 | 6.0 |
| 2019-10-21 | CC | Futures | 1635.0 | 1644.0 | 1608.0 | 1624.0 | 14956.0 |
| 2019-10-21 | CNH | Futures | 7.0679 | 7.0691 | 7.058 | 7.0643 | 807.0 |
| 2019-10-21 | CSC | Futures | 3.234 | 3.308 | 3.221 | 3.308 | 332.0 |
| 2019-10-21 | CT | Futures | 63.45 | 63.74 | 62.72 | 62.84 | 18874.0 |
| 2019-10-21 | DC | Futures | 27.03 | 27.72 | 27.02 | 27.65 | 562.0 |
| 2019-10-21 | DX | Futures | 93.811 | 93.879 | 93.642 | 93.801 | 14796.0 |
| 2019-10-21 | E1 | Futures | 1.17336 | 1.17371 | 1.16968 | 1.1721 | 19029.0 |
| 2019-10-21 | E6 | Futures | 1.21382 | 1.21626 | 1.21182 | 1.21263 | 131323.0 |
| 2019-10-21 | E7 | Futures | 1.2075 | 1.21 | 1.2056 | 1.2063 | 2312.0 |
| 2019-10-21 | EBM | Futures | 198.37 | 199.47 | 197.55 | 197.83 | 24107.0 |
| 2019-10-21 | ED | Futures | 95.3618 | 95.3666 | 95.3423 | 95.352 | 157328.0 |
| 2019-10-21 | ER | Futures | 98.411 | 98.416 | 98.406 | 98.406 | 17208.0 |
| 2019-10-21 | EW | Futures | 2032.4 | 2056.2 | 2032.2 | 2046.1 | 9520.0 |
| 2019-10-21 | FBON | Futures | 145.02 | 145.02 | 144.48 | 144.6 | 230.0 |
| 2019-10-21 | FBTP | Futures | 131.57 | 131.65 | 130.78 | 130.97 | 78825.0 |
| 2019-10-21 | FBTS | Futures | 108.481 | 108.491 | 108.365 | 108.394 | 26257.0 |
| 2019-10-21 | FCE | Futures | 5122.4 | 5140.1 | 5102.8 | 5124.2 | 51481.0 |
| 2019-10-21 | FDAX | Futures | 13362.0 | 13483.8 | 13334.0 | 13452.7 | 85798.0 |
| 2019-10-21 | FDIV | Futures | 154.63 | 155.51 | 154.63 | 155.14 | 160.0 |
| 2019-10-21 | FDXM | Futures | 13185.9 | 13307.8 | 13159.9 | 13277.1 | 31803.0 |
| 2019-10-21 | FESX | Futures | 3136.9 | 3156.2 | 3128.1 | 3150.1 | 644221.0 |
| 2019-10-21 | FGBL | Futures | 165.62 | 165.63 | 164.98 | 165.08 | 432790.0 |
| 2019-10-21 | FGBM | Futures | 134.1 | 134.12 | 133.98 | 134.03 | 268510.0 |
| 2019-10-21 | FGBS | Futures | 112.78 | 112.79 | 112.759 | 112.764 | 152968.0 |
| 2019-10-21 | FGBX | Futures | 216.15 | 216.23 | 213.64 | 213.84 | 43753.0 |
| 2019-10-21 | FMWO | Futures | 7326.7 | 7365.4 | 7326.7 | 7359.7 | 3571.0 |
| 2019-10-21 | FOAT | Futures | 152.95 | 153.06 | 152.41 | 152.5 | 102765.0 |
| 2019-10-21 | FTDX | Futures | 2743.7 | 2796.5 | 2743.7 | 2792.5 | 101.0 |
| 2019-10-21 | FTI | Futures | 545.21 | 548.26 | 544.59 | 547.55 | 20959.0 |
| 2019-10-21 | FTUK | Futures | 6609.6 | 6649.9 | 6598.0 | 6621.6 | 77769.0 |
| 2019-10-21 | FVSA | Futures | 167.24 | 168.31 | 161.93 | 164.59 | 13802.0 |
| 2019-10-21 | FXXP | Futures | 353.8 | 356.2 | 353.6 | 355.9 | 63312.0 |
| 2019-10-21 | G | Futures | 120.62 | 120.62 | 120.03 | 120.41 | 157690.0 |
> showing 50 of 121 rows — these rows as CSV