PREVIEW / futures_daily / 2020-02-11
file: by_date/futures_daily/2020/2020-02-11.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-02-11 | ES | Futures | 3619.13 | 3644.51 | 3617.24 | 3626.15 | 1486164.0 |
| 2020-02-11 | NQ | Futures | 10925.36 | 11022.28 | 10898.12 | 10927.94 | 589570.0 |
| 2020-02-11 | YM | Futures | 30704.8 | 30870.8 | 30626.1 | 30696.4 | 198861.0 |
| 2020-02-11 | CL | Futures | 50.88 | 51.98 | 50.85 | 51.22 | 725733.0 |
| 2020-02-11 | GC | Futures | 1920.9 | 1923.4 | 1908.4 | 1914.4 | 231832.0 |
| 2020-02-11 | ZN | Futures | 129.960939 | 130.022884 | 129.713158 | 129.837048 | 1579786.0 |
| 2020-02-11 | A6 | Futures | 0.68564 | 0.69107 | 0.68533 | 0.68882 | 96823.0 |
| 2020-02-11 | AD | Futures | 0.75657 | 0.75899 | 0.75647 | 0.75809 | 69045.0 |
| 2020-02-11 | ALI | Futures | 2081.28 | 2109.46 | 2081.28 | 2109.46 | 110.0 |
| 2020-02-11 | B | Futures | 44.44 | 45.33 | 44.42 | 44.76 | 272814.0 |
| 2020-02-11 | B6 | Futures | 1.3108 | 1.3163 | 1.3087 | 1.3158 | 91993.0 |
| 2020-02-11 | BR | Futures | 0.18772 | 0.18849 | 0.18666 | 0.18683 | 4292.0 |
| 2020-02-11 | BTC | Futures | 14901.2 | 15861.6 | 14691.2 | 15614.0 | 15832.0 |
| 2020-02-11 | BZ | Futures | 43.57 | 44.64 | 43.57 | 44.11 | 36294.0 |
| 2020-02-11 | C | Futures | 1902.0 | 1943.0 | 1900.0 | 1904.0 | 4923.0 |
| 2020-02-11 | CB | Futures | 227.085 | 227.232 | 226.377 | 226.672 | 16.0 |
| 2020-02-11 | CC | Futures | 1880.0 | 1913.0 | 1879.0 | 1883.0 | 33146.0 |
| 2020-02-11 | CNH | Futures | 6.9468 | 6.9497 | 6.9325 | 6.9394 | 671.0 |
| 2020-02-11 | CSC | Futures | 3.329 | 3.348 | 3.314 | 3.338 | 72.0 |
| 2020-02-11 | CT | Futures | 64.68 | 65.2 | 64.58 | 64.9 | 24289.0 |
| 2020-02-11 | DC | Futures | 27.85 | 27.98 | 27.72 | 27.83 | 415.0 |
| 2020-02-11 | DX | Futures | 95.846 | 95.948 | 95.686 | 95.695 | 14347.0 |
| 2020-02-11 | E1 | Futures | 1.17147 | 1.17422 | 1.1693 | 1.17364 | 25138.0 |
| 2020-02-11 | E6 | Futures | 1.17786 | 1.17937 | 1.17571 | 1.17905 | 171113.0 |
| 2020-02-11 | E7 | Futures | 1.1719 | 1.1732 | 1.1696 | 1.1729 | 2827.0 |
| 2020-02-11 | EBM | Futures | 214.02 | 214.29 | 210.72 | 211.54 | 28394.0 |
| 2020-02-11 | ED | Futures | 95.415 | 95.415 | 95.3908 | 95.3908 | 205553.0 |
| 2020-02-11 | ER | Futures | 98.391 | 98.401 | 98.386 | 98.396 | 120733.0 |
| 2020-02-11 | ESG | Futures | 301.05 | 301.98 | 300.77 | 300.77 | 103.0 |
| 2020-02-11 | EW | Futures | 2170.4 | 2195.9 | 2170.1 | 2186.6 | 11816.0 |
| 2020-02-11 | FBON | Futures | 145.37 | 145.53 | 145.25 | 145.33 | 343.0 |
| 2020-02-11 | FBTP | Futures | 132.52 | 132.56 | 132.21 | 132.29 | 125063.0 |
| 2020-02-11 | FBTS | Futures | 108.644 | 108.682 | 108.634 | 108.644 | 44272.0 |
| 2020-02-11 | FCE | Futures | 5498.8 | 5498.8 | 5467.1 | 5487.9 | 56071.0 |
| 2020-02-11 | FDAX | Futures | 14308.8 | 14450.5 | 14303.5 | 14426.7 | 94797.0 |
| 2020-02-11 | FDIV | Futures | 159.92 | 160.1 | 159.59 | 159.73 | 162.0 |
| 2020-02-11 | FDXM | Futures | 14123.5 | 14268.6 | 14119.3 | 14245.6 | 62264.0 |
| 2020-02-11 | FESX | Futures | 3349.7 | 3371.7 | 3347.9 | 3369.1 | 996108.0 |
| 2020-02-11 | FGBL | Futures | 166.66 | 166.72 | 166.32 | 166.45 | 766465.0 |
| 2020-02-11 | FGBM | Futures | 134.28 | 134.35 | 134.18 | 134.23 | 509240.0 |
| 2020-02-11 | FGBS | Futures | 112.724 | 112.749 | 112.709 | 112.719 | 310798.0 |
| 2020-02-11 | FGBX | Futures | 218.21 | 218.21 | 216.81 | 217.15 | 61603.0 |
| 2020-02-11 | FMWO | Futures | 8076.5 | 8101.4 | 8061.7 | 8087.8 | 4318.0 |
| 2020-02-11 | FOAT | Futures | 154.26 | 154.37 | 154.0 | 154.1 | 171650.0 |
| 2020-02-11 | FTDX | Futures | 3215.7 | 3269.5 | 3215.7 | 3268.0 | 87.0 |
| 2020-02-11 | FTI | Futures | 595.08 | 598.1 | 595.08 | 597.11 | 20.0 |
| 2020-02-11 | FTUK | Futures | 6958.4 | 7003.4 | 6953.2 | 6984.2 | 88124.0 |
| 2020-02-11 | FVSA | Futures | 114.79 | 116.07 | 111.81 | 112.67 | 32488.0 |
| 2020-02-11 | FXXP | Futures | 388.3 | 390.2 | 388.0 | 389.9 | 41490.0 |
| 2020-02-11 | G | Futures | 122.41 | 122.7 | 122.21 | 122.53 | 283116.0 |
> showing 50 of 119 rows — these rows as CSV