PREVIEW / futures_daily / 2020-02-03
file: by_date/futures_daily/2020/2020-02-03.parquet size: 10 KB rows: 121
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-03 | ES | Futures | 3480.61 | 3528.67 | 3479.8 | 3505.18 | 1919477.0 |
| 2020-02-03 | NQ | Futures | 10303.39 | 10501.82 | 10294.5 | 10454.22 | 680726.0 |
| 2020-02-03 | YM | Futures | 29572.7 | 30007.5 | 29548.6 | 29784.9 | 269200.0 |
| 2020-02-03 | CL | Futures | 52.31 | 53.3 | 51.07 | 51.39 | 876044.0 |
| 2020-02-03 | GC | Futures | 1948.1 | 1949.0 | 1918.1 | 1929.4 | 320599.0 |
| 2020-02-03 | ZN | Futures | 130.688794 | 130.735253 | 129.960939 | 130.410041 | 2331880.0 |
| 2020-02-03 | A6 | Futures | 0.68574 | 0.6881 | 0.68553 | 0.68615 | 113479.0 |
| 2020-02-03 | AD | Futures | 0.76086 | 0.76151 | 0.75743 | 0.75788 | 91949.0 |
| 2020-02-03 | ALI | Futures | 2090.58 | 2092.38 | 2053.71 | 2053.71 | 120.0 |
| 2020-02-03 | B | Futures | 46.55 | 47.05 | 44.82 | 45.13 | 477224.0 |
| 2020-02-03 | B6 | Futures | 1.3381 | 1.3386 | 1.3181 | 1.3196 | 160403.0 |
| 2020-02-03 | BR | Futures | 0.1889 | 0.19149 | 0.18743 | 0.19064 | 6885.0 |
| 2020-02-03 | BTC | Futures | 14248.5 | 14691.2 | 13910.8 | 14120.9 | 8918.0 |
| 2020-02-03 | BZ | Futures | 45.61 | 46.35 | 44.15 | 44.46 | 66338.0 |
| 2020-02-03 | C | Futures | 1856.0 | 1858.0 | 1820.0 | 1840.0 | 13177.0 |
| 2020-02-03 | CB | Futures | 234.867 | 235.662 | 233.511 | 233.57 | 32.0 |
| 2020-02-03 | CC | Futures | 1817.0 | 1831.0 | 1792.0 | 1805.0 | 33923.0 |
| 2020-02-03 | CNH | Futures | 6.9938 | 7.0019 | 6.9582 | 6.9874 | 1204.0 |
| 2020-02-03 | CSC | Futures | 3.45 | 3.45 | 3.372 | 3.385 | 130.0 |
| 2020-02-03 | CT | Futures | 64.01 | 64.74 | 63.49 | 63.58 | 29333.0 |
| 2020-02-03 | DC | Futures | 28.62 | 28.67 | 27.98 | 28.11 | 398.0 |
| 2020-02-03 | DX | Futures | 94.385 | 94.88 | 94.371 | 94.754 | 18794.0 |
| 2020-02-03 | E1 | Futures | 1.18929 | 1.18998 | 1.1837 | 1.18575 | 28269.0 |
| 2020-02-03 | E6 | Futures | 1.19758 | 1.19796 | 1.1916 | 1.19499 | 179792.0 |
| 2020-02-03 | E7 | Futures | 1.1913 | 1.1916 | 1.1854 | 1.1888 | 2141.0 |
| 2020-02-03 | EBM | Futures | 208.25 | 209.35 | 207.97 | 208.25 | 19984.0 |
| 2020-02-03 | ED | Futures | 95.4247 | 95.4296 | 95.3811 | 95.3908 | 307853.0 |
| 2020-02-03 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.396 | 46138.0 |
| 2020-02-03 | ESG | Futures | 289.8 | 291.26 | 289.56 | 290.92 | 61.0 |
| 2020-02-03 | EW | Futures | 2115.0 | 2147.1 | 2114.2 | 2136.6 | 18180.0 |
| 2020-02-03 | FBON | Futures | 145.82 | 145.82 | 145.49 | 145.66 | 356.0 |
| 2020-02-03 | FBTP | Futures | 132.49 | 132.72 | 132.19 | 132.46 | 83940.0 |
| 2020-02-03 | FBTS | Futures | 108.605 | 108.663 | 108.586 | 108.644 | 42425.0 |
| 2020-02-03 | FCE | Futures | 5274.0 | 5308.4 | 5259.5 | 5285.8 | 78328.0 |
| 2020-02-03 | FDAX | Futures | 13703.4 | 13830.8 | 13703.4 | 13791.1 | 109170.0 |
| 2020-02-03 | FDIV | Futures | 153.33 | 153.7 | 153.33 | 153.65 | 2.0 |
| 2020-02-03 | FDXM | Futures | 13529.3 | 13655.6 | 13528.2 | 13618.0 | 63906.0 |
| 2020-02-03 | FESX | Futures | 3194.7 | 3229.0 | 3193.8 | 3218.5 | 1028622.0 |
| 2020-02-03 | FGBL | Futures | 167.25 | 167.29 | 166.79 | 167.04 | 692886.0 |
| 2020-02-03 | FGBM | Futures | 134.56 | 134.56 | 134.42 | 134.49 | 414696.0 |
| 2020-02-03 | FGBS | Futures | 112.795 | 112.805 | 112.774 | 112.79 | 385351.0 |
| 2020-02-03 | FGBX | Futures | 220.37 | 220.55 | 219.05 | 219.78 | 65291.0 |
| 2020-02-03 | FMWO | Futures | 7836.1 | 7862.2 | 7800.9 | 7837.2 | 5269.0 |
| 2020-02-03 | FOAT | Futures | 154.57 | 154.59 | 154.2 | 154.43 | 130050.0 |
| 2020-02-03 | FTDX | Futures | 3068.0 | 3083.6 | 3046.9 | 3078.0 | 155.0 |
| 2020-02-03 | FTI | Futures | 564.58 | 568.37 | 563.38 | 566.24 | 32543.0 |
| 2020-02-03 | FTUK | Futures | 6770.3 | 6848.6 | 6765.6 | 6825.2 | 123941.0 |
| 2020-02-03 | FVSA | Futures | 134.77 | 134.77 | 127.55 | 132.22 | 39300.0 |
| 2020-02-03 | FXXP | Futures | 373.9 | 375.5 | 372.6 | 374.2 | 68454.0 |
| 2020-02-03 | G | Futures | 123.0 | 123.24 | 122.76 | 122.98 | 180952.0 |
> showing 50 of 121 rows — these rows as CSV