PREVIEW / futures_daily / 2020-06-15
file: by_date/futures_daily/2020/2020-06-15.parquet size: 10 KB rows: 119
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-06-15 | ES | Futures | 3357.91 | 3453.58 | 3290.94 | 3446.55 | 2970664.0 |
| 2020-06-15 | NQ | Futures | 11057.41 | 11377.75 | 10873.16 | 11360.92 | 425514.0 |
| 2020-06-15 | YM | Futures | 26837.3 | 27599.3 | 26158.9 | 27515.7 | 269965.0 |
| 2020-06-15 | CL | Futures | 26.29 | 27.21 | 25.13 | 27.13 | 262235.0 |
| 2020-06-15 | GC | Futures | 2089.9 | 2093.6 | 2048.5 | 2073.7 | 200225.0 |
| 2020-06-15 | ZN | Futures | 137.583128 | 137.846371 | 137.288915 | 137.490219 | 1056998.0 |
| 2020-06-15 | A6 | Futures | 0.70228 | 0.71247 | 0.69714 | 0.71144 | 135817.0 |
| 2020-06-15 | AD | Futures | 0.74657 | 0.74946 | 0.7418 | 0.74865 | 81195.0 |
| 2020-06-15 | ALI | Futures | 1921.11 | 1925.95 | 1921.11 | 1925.95 | 26.0 |
| 2020-06-15 | B | Futures | 25.4 | 26.12 | 24.38 | 26.0 | 215424.0 |
| 2020-06-15 | B6 | Futures | 1.2718 | 1.2807 | 1.2653 | 1.2786 | 101540.0 |
| 2020-06-15 | BR | Futures | 0.1536 | 0.15483 | 0.1515 | 0.15388 | 114.0 |
| 2020-06-15 | BTC | Futures | 13032.1 | 13247.6 | 12420.1 | 13129.4 | 5850.0 |
| 2020-06-15 | BZ | Futures | 24.74 | 25.5 | 23.81 | 25.39 | 30674.0 |
| 2020-06-15 | C | Futures | 1791.0 | 1791.0 | 1745.0 | 1761.0 | 3874.0 |
| 2020-06-15 | CB | Futures | 213.442 | 213.576 | 212.64 | 212.64 | 35.0 |
| 2020-06-15 | CC | Futures | 1513.0 | 1513.0 | 1460.0 | 1486.0 | 20164.0 |
| 2020-06-15 | CNH | Futures | 7.0079 | 7.0247 | 6.9984 | 6.999 | 272.0 |
| 2020-06-15 | CSC | Futures | 3.508 | 3.539 | 3.506 | 3.539 | 9.0 |
| 2020-06-15 | CT | Futures | 58.29 | 58.29 | 57.21 | 57.52 | 9617.0 |
| 2020-06-15 | DC | Futures | 28.41 | 29.54 | 28.41 | 29.51 | 118.0 |
| 2020-06-15 | DX | Futures | 93.937 | 94.063 | 93.261 | 93.357 | 18517.0 |
| 2020-06-15 | E1 | Futures | 1.19423 | 1.20138 | 1.19287 | 1.20104 | 24358.0 |
| 2020-06-15 | E6 | Futures | 1.20892 | 1.21857 | 1.20714 | 1.21686 | 176721.0 |
| 2020-06-15 | E7 | Futures | 1.2032 | 1.2124 | 1.2012 | 1.2108 | 6497.0 |
| 2020-06-15 | EBM | Futures | 219.15 | 219.45 | 216.76 | 217.06 | 9649.0 |
| 2020-06-15 | ED | Futures | 96.3702 | 96.3847 | 96.3653 | 96.375 | 204331.0 |
| 2020-06-15 | ER | Futures | 98.328 | 98.328 | 98.323 | 98.328 | 60375.0 |
| 2020-06-15 | ESG | Futures | 267.52 | 276.42 | 267.52 | 276.29 | 138.0 |
| 2020-06-15 | EW | Futures | 1866.0 | 1903.3 | 1775.8 | 1893.5 | 60199.0 |
| 2020-06-15 | FBON | Futures | 143.49 | 143.88 | 143.47 | 143.72 | 338.0 |
| 2020-06-15 | FBTP | Futures | 128.27 | 128.56 | 127.87 | 128.2 | 67947.0 |
| 2020-06-15 | FBTS | Futures | 108.182 | 108.328 | 108.144 | 108.241 | 49589.0 |
| 2020-06-15 | FCE | Futures | 4582.7 | 4751.7 | 4542.0 | 4681.6 | 40141.0 |
| 2020-06-15 | FDAX | Futures | 12506.1 | 12798.5 | 12257.6 | 12615.6 | 129622.0 |
| 2020-06-15 | FDIV | Futures | 134.98 | 137.82 | 134.98 | 137.82 | 300.0 |
| 2020-06-15 | FDXM | Futures | 12520.6 | 12788.4 | 12247.5 | 12604.2 | 2342.0 |
| 2020-06-15 | FESX | Futures | 2853.3 | 2911.5 | 2787.7 | 2870.8 | 1526222.0 |
| 2020-06-15 | FEU3 | Futures | 99.07 | 99.075 | 99.07 | 99.075 | 345.0 |
| 2020-06-15 | FGBL | Futures | 167.8 | 168.14 | 167.47 | 167.7 | 475771.0 |
| 2020-06-15 | FGBM | Futures | 134.75 | 134.81 | 134.52 | 134.59 | 318033.0 |
| 2020-06-15 | FGBS | Futures | 112.759 | 112.8 | 112.719 | 112.734 | 219156.0 |
| 2020-06-15 | FGBX | Futures | 223.69 | 225.32 | 223.22 | 223.96 | 42039.0 |
| 2020-06-15 | FMWO | Futures | 7404.5 | 7588.0 | 7296.2 | 7468.0 | 20669.0 |
| 2020-06-15 | FOAT | Futures | 154.65 | 154.77 | 154.37 | 154.46 | 110444.0 |
| 2020-06-15 | FTDX | Futures | 3052.1 | 3129.3 | 3052.1 | 3129.3 | 647.0 |
| 2020-06-15 | FTI | Futures | 493.2 | 508.04 | 490.37 | 501.68 | 4412.0 |
| 2020-06-15 | FTUK | Futures | 5687.4 | 5771.9 | 5570.6 | 5696.3 | 392474.0 |
| 2020-06-15 | FVSA | Futures | 336.36 | 343.54 | 294.21 | 311.25 | 36592.0 |
| 2020-06-15 | FXXP | Futures | 317.0 | 327.6 | 315.6 | 324.0 | 145504.0 |
> showing 50 of 119 rows — these rows as CSV