PREVIEW / futures_daily / 2020-02-19
file: by_date/futures_daily/2020/2020-02-19.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-19 | ES | Futures | 3641.81 | 3665.3 | 3640.46 | 3658.28 | 1163426.0 |
| 2020-02-19 | NQ | Futures | 11060.99 | 11182.0 | 11058.7 | 11164.51 | 419130.0 |
| 2020-02-19 | YM | Futures | 30708.0 | 30872.9 | 30699.6 | 30809.9 | 153041.0 |
| 2020-02-19 | CL | Futures | 53.46 | 55.0 | 53.26 | 54.62 | 655495.0 |
| 2020-02-19 | GC | Futures | 1956.7 | 1970.2 | 1953.7 | 1965.2 | 307885.0 |
| 2020-02-19 | ZN | Futures | 130.007398 | 130.084829 | 129.775103 | 129.91448 | 1663072.0 |
| 2020-02-19 | A6 | Futures | 0.68574 | 0.688 | 0.68359 | 0.68441 | 88164.0 |
| 2020-02-19 | AD | Futures | 0.7603 | 0.76292 | 0.76015 | 0.76181 | 81291.0 |
| 2020-02-19 | ALI | Futures | 2091.38 | 2098.0 | 2082.36 | 2090.48 | 65.0 |
| 2020-02-19 | B | Futures | 47.74 | 49.23 | 47.67 | 49.0 | 262150.0 |
| 2020-02-19 | B6 | Futures | 1.3192 | 1.3216 | 1.3098 | 1.3111 | 113124.0 |
| 2020-02-19 | BFX | Futures | 4886.2 | 4889.9 | 4886.2 | 4889.9 | 40.0 |
| 2020-02-19 | BR | Futures | 0.18606 | 0.18614 | 0.18537 | 0.18565 | 4033.0 |
| 2020-02-19 | BTC | Futures | 15426.5 | 15824.1 | 13873.3 | 15343.9 | 9019.0 |
| 2020-02-19 | BZ | Futures | 47.12 | 48.51 | 46.99 | 48.28 | 36217.0 |
| 2020-02-19 | C | Futures | 1880.0 | 1901.0 | 1878.0 | 1890.0 | 5152.0 |
| 2020-02-19 | CB | Futures | 225.67 | 225.67 | 222.929 | 223.901 | 52.0 |
| 2020-02-19 | CC | Futures | 1874.0 | 1890.0 | 1860.0 | 1864.0 | 14689.0 |
| 2020-02-19 | CNH | Futures | 6.97 | 6.9821 | 6.9608 | 6.9795 | 572.0 |
| 2020-02-19 | CSC | Futures | 3.294 | 3.294 | 3.27 | 3.27 | 90.0 |
| 2020-02-19 | CT | Futures | 64.62 | 65.66 | 64.62 | 65.14 | 9243.0 |
| 2020-02-19 | DC | Futures | 27.51 | 27.51 | 27.09 | 27.12 | 414.0 |
| 2020-02-19 | DX | Futures | 96.395 | 96.691 | 96.356 | 96.668 | 13998.0 |
| 2020-02-19 | E1 | Futures | 1.16393 | 1.16451 | 1.16222 | 1.16234 | 24026.0 |
| 2020-02-19 | E6 | Futures | 1.16456 | 1.16661 | 1.16337 | 1.16494 | 180548.0 |
| 2020-02-19 | E7 | Futures | 1.1586 | 1.1606 | 1.157 | 1.1589 | 3700.0 |
| 2020-02-19 | EBM | Futures | 215.94 | 216.21 | 214.29 | 215.12 | 14817.0 |
| 2020-02-19 | ED | Futures | 95.3956 | 95.4005 | 95.3811 | 95.3835 | 327482.0 |
| 2020-02-19 | ER | Futures | 98.396 | 98.396 | 98.391 | 98.396 | 15064.0 |
| 2020-02-19 | ESG | Futures | 302.87 | 303.81 | 302.87 | 303.36 | 1108.0 |
| 2020-02-19 | EW | Futures | 2202.2 | 2218.5 | 2200.8 | 2209.0 | 13296.0 |
| 2020-02-19 | FBON | Futures | 145.64 | 145.92 | 145.6 | 145.91 | 215.0 |
| 2020-02-19 | FBTP | Futures | 132.65 | 132.88 | 132.26 | 132.61 | 90070.0 |
| 2020-02-19 | FBTS | Futures | 108.653 | 108.682 | 108.557 | 108.615 | 66759.0 |
| 2020-02-19 | FCE | Futures | 5508.3 | 5525.0 | 5489.7 | 5523.6 | 66544.0 |
| 2020-02-19 | FDAX | Futures | 14515.5 | 14577.4 | 14494.4 | 14573.2 | 85009.0 |
| 2020-02-19 | FDIV | Futures | 161.03 | 161.17 | 161.03 | 161.17 | 65.0 |
| 2020-02-19 | FDXM | Futures | 14335.4 | 14395.0 | 14312.5 | 14390.3 | 59954.0 |
| 2020-02-19 | FESX | Futures | 3387.6 | 3401.7 | 3384.1 | 3399.0 | 927183.0 |
| 2020-02-19 | FGBL | Futures | 166.59 | 166.9 | 166.46 | 166.83 | 635280.0 |
| 2020-02-19 | FGBM | Futures | 134.27 | 134.37 | 134.24 | 134.33 | 377251.0 |
| 2020-02-19 | FGBS | Futures | 112.739 | 112.754 | 112.729 | 112.739 | 192536.0 |
| 2020-02-19 | FGBX | Futures | 218.05 | 219.26 | 217.61 | 218.92 | 64865.0 |
| 2020-02-19 | FMWO | Futures | 8086.7 | 8112.8 | 8076.5 | 8111.6 | 9314.0 |
| 2020-02-19 | FOAT | Futures | 154.34 | 154.66 | 154.22 | 154.59 | 159798.0 |
| 2020-02-19 | FTDX | Futures | 3271.5 | 3311.2 | 3271.5 | 3311.2 | 60.0 |
| 2020-02-19 | FTI | Futures | 600.93 | 603.57 | 600.93 | 603.21 | 22572.0 |
| 2020-02-19 | FTUK | Futures | 6898.3 | 6963.5 | 6897.4 | 6948.1 | 95644.0 |
| 2020-02-19 | FVSA | Futures | 111.44 | 112.26 | 110.22 | 111.44 | 30926.0 |
| 2020-02-19 | FXXP | Futures | 393.0 | 394.8 | 392.5 | 394.6 | 53805.0 |
> showing 50 of 120 rows — these rows as CSV