PREVIEW / futures_daily / 2020-09-14
file: by_date/futures_daily/2020/2020-09-14.parquet size: 10 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-14 | ES | Futures | 3752.43 | 3811.41 | 3748.21 | 3788.66 | 2219334.0 |
| 2020-09-14 | NQ | Futures | 12838.41 | 13139.13 | 12838.41 | 13043.33 | 546567.0 |
| 2020-09-14 | YM | Futures | 29687.7 | 30109.8 | 29687.7 | 30005.3 | 159725.0 |
| 2020-09-14 | CL | Futures | 27.0 | 27.26 | 26.65 | 26.97 | 185186.0 |
| 2020-09-14 | GC | Futures | 2301.7 | 2329.5 | 2297.3 | 2319.2 | 200091.0 |
| 2020-09-14 | ZN | Futures | 138.450671 | 138.574647 | 138.357689 | 138.435174 | 746895.0 |
| 2020-09-14 | A6 | Futures | 0.74785 | 0.75001 | 0.74601 | 0.74878 | 52863.0 |
| 2020-09-14 | AD | Futures | 0.76845 | 0.77068 | 0.7681 | 0.76921 | 50794.0 |
| 2020-09-14 | ALI | Futures | 2140.91 | 2156.99 | 2137.34 | 2156.99 | 177.0 |
| 2020-09-14 | B | Futures | 25.36 | 25.56 | 25.05 | 25.25 | 200092.0 |
| 2020-09-14 | B6 | Futures | 1.2977 | 1.3107 | 1.2975 | 1.3042 | 82386.0 |
| 2020-09-14 | BR | Futures | 0.14773 | 0.14871 | 0.14773 | 0.14871 | 344.0 |
| 2020-09-14 | BTC | Futures | 13927.1 | 14588.6 | 13866.3 | 14453.6 | 6525.0 |
| 2020-09-14 | BZ | Futures | 24.8 | 25.0 | 24.51 | 24.7 | 22118.0 |
| 2020-09-14 | C | Futures | 1600.0 | 1611.0 | 1593.0 | 1603.0 | 7726.0 |
| 2020-09-14 | CB | Futures | 168.365 | 168.365 | 168.365 | 168.365 | 2.0 |
| 2020-09-14 | CC | Futures | 1677.0 | 1698.0 | 1673.0 | 1678.0 | 12486.0 |
| 2020-09-14 | CNH | Futures | 6.7297 | 6.7297 | 6.7 | 6.7039 | 807.0 |
| 2020-09-14 | CSC | Futures | 3.322 | 3.322 | 3.3 | 3.3 | 48.0 |
| 2020-09-14 | CT | Futures | 65.41 | 66.59 | 65.41 | 66.2 | 38.0 |
| 2020-09-14 | DC | Futures | 26.82 | 26.93 | 26.63 | 26.63 | 113.0 |
| 2020-09-14 | DX | Futures | 90.158 | 90.163 | 89.704 | 89.893 | 24009.0 |
| 2020-09-14 | E1 | Futures | 1.24964 | 1.25337 | 1.24783 | 1.25054 | 15097.0 |
| 2020-09-14 | E6 | Futures | 1.27088 | 1.27607 | 1.26997 | 1.27355 | 129471.0 |
| 2020-09-14 | E7 | Futures | 1.2644 | 1.2695 | 1.2635 | 1.2671 | 4180.0 |
| 2020-09-14 | EBM | Futures | 227.54 | 228.45 | 226.94 | 227.54 | 18933.0 |
| 2020-09-14 | ED | Futures | 96.4407 | 96.4503 | 96.4358 | 96.4455 | 151597.0 |
| 2020-09-14 | ER | Futures | 98.416 | 98.426 | 98.411 | 98.416 | 114616.0 |
| 2020-09-14 | ESG | Futures | 312.41 | 315.1 | 312.36 | 313.6 | 1057.0 |
| 2020-09-14 | EW | Futures | 1984.1 | 2020.1 | 1983.2 | 2016.5 | 41515.0 |
| 2020-09-14 | FBON | Futures | 147.3 | 147.8 | 147.27 | 147.5 | 270.0 |
| 2020-09-14 | FBTP | Futures | 133.47 | 133.92 | 133.47 | 133.62 | 74142.0 |
| 2020-09-14 | FBTS | Futures | 109.074 | 109.151 | 109.035 | 109.093 | 38667.0 |
| 2020-09-14 | FCE | Futures | 4900.5 | 4925.2 | 4872.3 | 4889.3 | 46479.0 |
| 2020-09-14 | FDAX | Futures | 14070.2 | 14171.2 | 13962.9 | 14022.4 | 82516.0 |
| 2020-09-14 | FDIV | Futures | 154.55 | 154.55 | 152.99 | 153.22 | 240.0 |
| 2020-09-14 | FDXM | Futures | 14023.7 | 14129.8 | 13931.4 | 13981.8 | 2189.0 |
| 2020-09-14 | FESX | Futures | 3063.8 | 3085.1 | 3042.5 | 3057.3 | 1207253.0 |
| 2020-09-14 | FEU3 | Futures | 99.149 | 99.159 | 99.149 | 99.159 | 200.0 |
| 2020-09-14 | FGBL | Futures | 169.24 | 169.53 | 169.13 | 169.22 | 433879.0 |
| 2020-09-14 | FGBM | Futures | 135.05 | 135.13 | 134.99 | 135.02 | 276866.0 |
| 2020-09-14 | FGBS | Futures | 112.769 | 112.78 | 112.754 | 112.764 | 285705.0 |
| 2020-09-14 | FGBX | Futures | 229.63 | 230.63 | 229.05 | 229.38 | 38705.0 |
| 2020-09-14 | FMWO | Futures | 8418.9 | 8448.5 | 8373.9 | 8440.2 | 14743.0 |
| 2020-09-14 | FOAT | Futures | 157.06 | 157.4 | 157.03 | 157.15 | 108031.0 |
| 2020-09-14 | FTDX | Futures | 3166.6 | 3174.8 | 3163.5 | 3174.8 | 176.0 |
| 2020-09-14 | FTI | Futures | 517.2 | 519.35 | 513.52 | 514.45 | 7411.0 |
| 2020-09-14 | FTUK | Futures | 5765.2 | 5784.3 | 5715.9 | 5738.4 | 355458.0 |
| 2020-09-14 | FVSA | Futures | 198.36 | 198.73 | 191.3 | 193.53 | 26014.0 |
| 2020-09-14 | FXXP | Futures | 341.6 | 342.6 | 339.1 | 340.4 | 150513.0 |
> showing 50 of 120 rows — these rows as CSV