PREVIEW / futures_daily / 2020-02-21
file: by_date/futures_daily/2020/2020-02-21.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-21 | ES | Futures | 3636.41 | 3638.84 | 3594.29 | 3606.44 | 2293728.0 |
| 2020-02-21 | NQ | Futures | 11031.17 | 11038.63 | 10795.17 | 10848.51 | 911839.0 |
| 2020-02-21 | YM | Futures | 30617.7 | 30640.8 | 30320.5 | 30436.0 | 322584.0 |
| 2020-02-21 | CL | Futures | 54.87 | 54.99 | 53.66 | 54.5 | 707555.0 |
| 2020-02-21 | GC | Futures | 1979.6 | 2014.3 | 1977.1 | 2010.3 | 489193.0 |
| 2020-02-21 | ZN | Futures | 130.33261 | 130.967547 | 130.270664 | 130.688794 | 3397725.0 |
| 2020-02-21 | A6 | Futures | 0.67805 | 0.68092 | 0.67539 | 0.6801 | 139318.0 |
| 2020-02-21 | AD | Futures | 0.76 | 0.76333 | 0.75945 | 0.76287 | 92180.0 |
| 2020-02-21 | ALI | Futures | 2072.73 | 2075.74 | 2066.71 | 2072.73 | 104.0 |
| 2020-02-21 | B | Futures | 48.9 | 49.11 | 47.85 | 48.49 | 236494.0 |
| 2020-02-21 | B6 | Futures | 1.3066 | 1.3172 | 1.3066 | 1.3164 | 116940.0 |
| 2020-02-21 | BR | Futures | 0.1848 | 0.18553 | 0.18273 | 0.18484 | 12283.0 |
| 2020-02-21 | BTC | Futures | 14481.1 | 14751.2 | 14406.0 | 14616.1 | 2125.0 |
| 2020-02-21 | BZ | Futures | 48.31 | 48.4 | 47.15 | 47.77 | 39006.0 |
| 2020-02-21 | C | Futures | 1910.0 | 1925.0 | 1895.0 | 1901.0 | 2678.0 |
| 2020-02-21 | CB | Futures | 221.392 | 221.392 | 219.747 | 221.085 | 61.0 |
| 2020-02-21 | CC | Futures | 1876.0 | 1888.0 | 1853.0 | 1862.0 | 13301.0 |
| 2020-02-21 | CNH | Futures | 7.0139 | 7.0236 | 7.0015 | 7.0037 | 836.0 |
| 2020-02-21 | CSC | Futures | 3.255 | 3.27 | 3.245 | 3.249 | 103.0 |
| 2020-02-21 | CT | Futures | 65.39 | 65.62 | 64.68 | 65.57 | 3750.0 |
| 2020-02-21 | DC | Futures | 26.94 | 27.12 | 26.86 | 26.91 | 441.0 |
| 2020-02-21 | DX | Futures | 96.831 | 96.856 | 96.225 | 96.271 | 23262.0 |
| 2020-02-21 | E1 | Futures | 1.16234 | 1.17079 | 1.16222 | 1.16976 | 38214.0 |
| 2020-02-21 | E6 | Futures | 1.16327 | 1.17194 | 1.16321 | 1.17124 | 259525.0 |
| 2020-02-21 | E7 | Futures | 1.1574 | 1.1659 | 1.1573 | 1.1651 | 4983.0 |
| 2020-02-21 | EBM | Futures | 215.12 | 216.21 | 213.74 | 214.29 | 28802.0 |
| 2020-02-21 | ED | Futures | 95.3956 | 95.4199 | 95.3956 | 95.415 | 340915.0 |
| 2020-02-21 | ER | Futures | 98.391 | 98.396 | 98.391 | 98.396 | 38767.0 |
| 2020-02-21 | ESG | Futures | 300.69 | 301.07 | 298.05 | 298.61 | 2292.0 |
| 2020-02-21 | EW | Futures | 2214.3 | 2215.3 | 2187.9 | 2194.4 | 16892.0 |
| 2020-02-21 | FBON | Futures | 146.66 | 146.85 | 146.48 | 146.6 | 621.0 |
| 2020-02-21 | FBTP | Futures | 132.91 | 133.08 | 132.75 | 132.96 | 98637.0 |
| 2020-02-21 | FBTS | Futures | 108.663 | 108.701 | 108.624 | 108.672 | 33804.0 |
| 2020-02-21 | FCE | Futures | 5474.3 | 5485.2 | 5419.2 | 5451.3 | 127770.0 |
| 2020-02-21 | FDAX | Futures | 14478.0 | 14494.4 | 14268.6 | 14341.6 | 148846.0 |
| 2020-02-21 | FDIV | Futures | 159.41 | 159.41 | 158.8 | 159.08 | 80.0 |
| 2020-02-21 | FDXM | Futures | 14303.1 | 14312.5 | 14090.0 | 14161.6 | 109754.0 |
| 2020-02-21 | FESX | Futures | 3370.8 | 3375.2 | 3323.3 | 3341.8 | 1626515.0 |
| 2020-02-21 | FGBL | Futures | 167.13 | 167.51 | 166.93 | 167.09 | 955610.0 |
| 2020-02-21 | FGBM | Futures | 134.35 | 134.42 | 134.25 | 134.31 | 571076.0 |
| 2020-02-21 | FGBS | Futures | 112.734 | 112.754 | 112.719 | 112.739 | 316445.0 |
| 2020-02-21 | FGBX | Futures | 221.22 | 223.11 | 220.91 | 221.45 | 81884.0 |
| 2020-02-21 | FMWO | Futures | 8043.6 | 8043.6 | 7984.6 | 8013.0 | 2666.0 |
| 2020-02-21 | FOAT | Futures | 155.04 | 155.24 | 154.75 | 154.86 | 164805.0 |
| 2020-02-21 | FTDX | Futures | 3254.9 | 3290.6 | 3239.3 | 3251.4 | 125.0 |
| 2020-02-21 | FTI | Futures | 595.8 | 596.76 | 588.22 | 592.29 | 43143.0 |
| 2020-02-21 | FTUK | Futures | 6948.5 | 6950.9 | 6873.9 | 6900.7 | 125801.0 |
| 2020-02-21 | FVSA | Futures | 119.99 | 127.71 | 118.77 | 124.05 | 63301.0 |
| 2020-02-21 | FXXP | Futures | 390.8 | 392.2 | 387.8 | 389.4 | 68221.0 |
| 2020-02-21 | G | Futures | 122.61 | 122.77 | 122.31 | 122.67 | 457684.0 |
> showing 50 of 119 rows — these rows as CSV