PREVIEW / futures_daily / 2020-05-28
file: by_date/futures_daily/2020/2020-05-28.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-05-28 | ES | Futures | 3358.18 | 3391.93 | 3341.03 | 3361.5 | 1881295.0 |
| 2020-05-28 | NQ | Futures | 10818.38 | 10966.27 | 10685.39 | 10845.61 | 510617.0 |
| 2020-05-28 | YM | Futures | 27255.7 | 27523.6 | 27008.2 | 27164.0 | 230294.0 |
| 2020-05-28 | CL | Futures | 23.27 | 24.8 | 22.57 | 24.44 | 440168.0 |
| 2020-05-28 | GC | Futures | 2071.1 | 2093.5 | 2065.1 | 2075.0 | 164817.0 |
| 2020-05-28 | ZN | Futures | 137.377047 | 137.531403 | 137.207255 | 137.268998 | 1019614.0 |
| 2020-05-28 | A6 | Futures | 0.6798 | 0.68504 | 0.67692 | 0.68412 | 88612.0 |
| 2020-05-28 | AD | Futures | 0.73651 | 0.73782 | 0.73483 | 0.73635 | 59460.0 |
| 2020-05-28 | ALI | Futures | 1834.37 | 1834.37 | 1834.37 | 1834.37 | 0.0 |
| 2020-05-28 | B | Futures | 22.67 | 23.98 | 22.48 | 23.58 | 253375.0 |
| 2020-05-28 | B6 | Futures | 1.2447 | 1.2532 | 1.2419 | 1.253 | 81977.0 |
| 2020-05-28 | BR | Futures | 0.1475 | 0.1475 | 0.1475 | 0.1475 | 33.0 |
| 2020-05-28 | BTC | Futures | 12719.1 | 13414.5 | 12698.3 | 13296.3 | 3729.0 |
| 2020-05-28 | BZ | Futures | 22.3 | 23.41 | 21.84 | 23.03 | 34976.0 |
| 2020-05-28 | C | Futures | 1830.0 | 1880.0 | 1830.0 | 1878.0 | 7838.0 |
| 2020-05-28 | CB | Futures | 186.695 | 188.594 | 186.695 | 188.594 | 3.0 |
| 2020-05-28 | CC | Futures | 1535.0 | 1591.0 | 1533.0 | 1587.0 | 16527.0 |
| 2020-05-28 | CNH | Futures | 7.1182 | 7.1244 | 7.0942 | 7.0969 | 907.0 |
| 2020-05-28 | CSC | Futures | 3.352 | 3.377 | 3.35 | 3.354 | 17.0 |
| 2020-05-28 | CT | Futures | 57.01 | 57.06 | 56.08 | 56.12 | 8639.0 |
| 2020-05-28 | DC | Futures | 27.53 | 27.78 | 27.53 | 27.72 | 55.0 |
| 2020-05-28 | DX | Futures | 95.663 | 95.822 | 95.088 | 95.123 | 25980.0 |
| 2020-05-28 | E1 | Futures | 1.17679 | 1.18306 | 1.17224 | 1.1826 | 21073.0 |
| 2020-05-28 | E6 | Futures | 1.18337 | 1.19267 | 1.18165 | 1.19219 | 186555.0 |
| 2020-05-28 | E7 | Futures | 1.1772 | 1.1865 | 1.1755 | 1.186 | 7853.0 |
| 2020-05-28 | EBM | Futures | 223.05 | 224.24 | 222.45 | 224.24 | 10306.0 |
| 2020-05-28 | ED | Futures | 96.3775 | 96.3895 | 96.3726 | 96.3895 | 146778.0 |
| 2020-05-28 | ER | Futures | 98.274 | 98.289 | 98.269 | 98.289 | 50470.0 |
| 2020-05-28 | ESG | Futures | 273.6 | 275.91 | 272.94 | 273.15 | 25.0 |
| 2020-05-28 | EW | Futures | 1906.2 | 1927.2 | 1870.4 | 1878.2 | 12254.0 |
| 2020-05-28 | FBON | Futures | 142.61 | 143.36 | 142.33 | 143.28 | 626.0 |
| 2020-05-28 | FBTP | Futures | 126.78 | 127.77 | 126.61 | 127.59 | 83339.0 |
| 2020-05-28 | FBTS | Futures | 107.72 | 107.922 | 107.605 | 107.855 | 66839.0 |
| 2020-05-28 | FCE | Futures | 4591.7 | 4643.2 | 4556.3 | 4624.3 | 68002.0 |
| 2020-05-28 | FDAX | Futures | 12430.5 | 12517.2 | 12324.7 | 12482.8 | 85601.0 |
| 2020-05-28 | FDIV | Futures | 133.61 | 134.12 | 133.61 | 133.89 | 133.0 |
| 2020-05-28 | FDXM | Futures | 12478.2 | 12575.9 | 12382.5 | 12542.5 | 53125.0 |
| 2020-05-28 | FESX | Futures | 2808.6 | 2842.5 | 2793.9 | 2837.9 | 1311974.0 |
| 2020-05-28 | FGBL | Futures | 167.02 | 167.5 | 166.88 | 167.24 | 637402.0 |
| 2020-05-28 | FGBM | Futures | 134.2 | 134.46 | 134.18 | 134.36 | 384778.0 |
| 2020-05-28 | FGBS | Futures | 112.694 | 112.749 | 112.674 | 112.714 | 372364.0 |
| 2020-05-28 | FGBX | Futures | 222.98 | 224.64 | 222.79 | 223.51 | 51467.0 |
| 2020-05-28 | FMWO | Futures | 7499.8 | 7533.9 | 7443.3 | 7510.3 | 10485.0 |
| 2020-05-28 | FOAT | Futures | 152.73 | 153.43 | 152.6 | 153.33 | 165285.0 |
| 2020-05-28 | FTDX | Futures | 3158.9 | 3208.5 | 3158.9 | 3207.0 | 132.0 |
| 2020-05-28 | FTI | Futures | 497.09 | 502.67 | 494.11 | 501.31 | 27341.0 |
| 2020-05-28 | FTUK | Futures | 5820.0 | 5950.2 | 5800.2 | 5869.5 | 98219.0 |
| 2020-05-28 | FVSA | Futures | 259.68 | 271.44 | 255.61 | 261.49 | 10479.0 |
| 2020-05-28 | FXXP | Futures | 326.8 | 329.5 | 324.8 | 329.2 | 70129.0 |
| 2020-05-28 | G | Futures | 126.78 | 127.01 | 126.63 | 126.82 | 223559.0 |
> showing 50 of 120 rows — these rows as CSV