PREVIEW / futures_daily / 2020-02-06
file: by_date/futures_daily/2020/2020-02-06.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-02-06 | ES | Futures | 3604.01 | 3626.42 | 3599.15 | 3612.92 | 1462323.0 |
| 2020-02-06 | NQ | Futures | 10770.51 | 10855.39 | 10738.97 | 10845.64 | 545054.0 |
| 2020-02-06 | YM | Futures | 30716.4 | 30954.8 | 30651.3 | 30800.4 | 238290.0 |
| 2020-02-06 | CL | Futures | 52.48 | 53.53 | 51.52 | 52.25 | 750659.0 |
| 2020-02-06 | GC | Futures | 1902.0 | 1916.6 | 1897.2 | 1914.2 | 229003.0 |
| 2020-02-06 | ZN | Futures | 129.387946 | 129.49635 | 129.062734 | 129.403432 | 1858725.0 |
| 2020-02-06 | A6 | Futures | 0.69199 | 0.69394 | 0.69005 | 0.69046 | 95137.0 |
| 2020-02-06 | AD | Futures | 0.75869 | 0.75924 | 0.75703 | 0.75809 | 72515.0 |
| 2020-02-06 | ALI | Futures | 2095.67 | 2121.15 | 2081.28 | 2113.96 | 241.0 |
| 2020-02-06 | B | Futures | 46.05 | 46.89 | 44.96 | 45.53 | 379871.0 |
| 2020-02-06 | B6 | Futures | 1.3196 | 1.3196 | 1.3114 | 1.3118 | 89454.0 |
| 2020-02-06 | BFX | Futures | 4859.7 | 4892.8 | 4859.7 | 4892.8 | 2.0 |
| 2020-02-06 | BR | Futures | 0.19101 | 0.19251 | 0.18898 | 0.18963 | 8681.0 |
| 2020-02-06 | BTC | Futures | 14706.2 | 15021.3 | 14533.6 | 14848.7 | 12014.0 |
| 2020-02-06 | BZ | Futures | 45.38 | 46.19 | 44.29 | 44.86 | 50605.0 |
| 2020-02-06 | C | Futures | 1868.0 | 1904.0 | 1853.0 | 1900.0 | 11465.0 |
| 2020-02-06 | CB | Futures | 229.915 | 231.035 | 229.915 | 230.209 | 38.0 |
| 2020-02-06 | CC | Futures | 1829.0 | 1883.0 | 1826.0 | 1876.0 | 42433.0 |
| 2020-02-06 | CNH | Futures | 6.9454 | 6.9506 | 6.9307 | 6.9479 | 465.0 |
| 2020-02-06 | CSC | Futures | 3.331 | 3.337 | 3.305 | 3.337 | 246.0 |
| 2020-02-06 | CT | Futures | 64.23 | 64.87 | 64.21 | 64.6 | 25014.0 |
| 2020-02-06 | DC | Futures | 27.65 | 27.98 | 27.52 | 27.86 | 838.0 |
| 2020-02-06 | DX | Futures | 95.293 | 95.55 | 95.191 | 95.488 | 14236.0 |
| 2020-02-06 | E1 | Futures | 1.17616 | 1.17673 | 1.17364 | 1.1741 | 20715.0 |
| 2020-02-06 | E6 | Futures | 1.18767 | 1.18918 | 1.18384 | 1.18519 | 177799.0 |
| 2020-02-06 | E7 | Futures | 1.1815 | 1.1831 | 1.1777 | 1.179 | 2901.0 |
| 2020-02-06 | EBM | Futures | 212.64 | 213.19 | 211.82 | 212.09 | 18158.0 |
| 2020-02-06 | ED | Futures | 95.3665 | 95.3762 | 95.3617 | 95.3714 | 150549.0 |
| 2020-02-06 | ER | Futures | 98.386 | 98.391 | 98.386 | 98.391 | 19631.0 |
| 2020-02-06 | EW | Futures | 2192.6 | 2204.9 | 2177.8 | 2179.0 | 11871.0 |
| 2020-02-06 | FBON | Futures | 145.12 | 145.12 | 144.76 | 145.05 | 425.0 |
| 2020-02-06 | FBTP | Futures | 132.24 | 132.45 | 131.94 | 132.36 | 117598.0 |
| 2020-02-06 | FBTS | Futures | 108.644 | 108.653 | 108.586 | 108.634 | 67467.0 |
| 2020-02-06 | FCE | Futures | 5463.9 | 5484.3 | 5444.9 | 5472.0 | 67598.0 |
| 2020-02-06 | FDAX | Futures | 14278.7 | 14386.5 | 14264.4 | 14345.3 | 88290.0 |
| 2020-02-06 | FDIV | Futures | 160.01 | 160.01 | 159.31 | 159.31 | 150.0 |
| 2020-02-06 | FDXM | Futures | 14092.1 | 14202.8 | 14082.7 | 14165.2 | 58168.0 |
| 2020-02-06 | FESX | Futures | 3325.9 | 3351.5 | 3321.5 | 3346.2 | 1152667.0 |
| 2020-02-06 | FGBL | Futures | 165.92 | 166.16 | 165.64 | 166.03 | 763504.0 |
| 2020-02-06 | FGBM | Futures | 134.15 | 134.17 | 134.03 | 134.12 | 430204.0 |
| 2020-02-06 | FGBS | Futures | 112.724 | 112.729 | 112.694 | 112.704 | 456023.0 |
| 2020-02-06 | FGBX | Futures | 215.64 | 216.41 | 214.87 | 215.85 | 70140.0 |
| 2020-02-06 | FMWO | Futures | 8041.3 | 8075.4 | 8027.7 | 8051.5 | 4877.0 |
| 2020-02-06 | FOAT | Futures | 153.5 | 153.73 | 153.32 | 153.65 | 244005.0 |
| 2020-02-06 | FTDX | Futures | 3235.8 | 3235.8 | 3204.1 | 3221.7 | 38.0 |
| 2020-02-06 | FTI | Futures | 589.55 | 591.99 | 589.41 | 591.56 | 28932.0 |
| 2020-02-06 | FTUK | Futures | 6977.1 | 7011.9 | 6960.3 | 6984.7 | 83098.0 |
| 2020-02-06 | FVSA | Futures | 115.22 | 117.77 | 113.09 | 114.79 | 31164.0 |
| 2020-02-06 | FXXP | Futures | 387.4 | 387.9 | 385.6 | 386.9 | 59017.0 |
| 2020-02-06 | G | Futures | 122.04 | 122.35 | 121.83 | 122.26 | 186650.0 |
> showing 50 of 120 rows — these rows as CSV