PREVIEW / futures_daily / 2019-05-17
file: by_date/futures_daily/2019/2019-05-17.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 |
|---|---|---|---|---|---|---|---|
| 2019-05-17 | ES | Futures | 3110.63 | 3119.01 | 3081.2 | 3091.46 | 1926351.0 |
| 2019-05-17 | NQ | Futures | 8757.62 | 8779.8 | 8649.02 | 8654.79 | 626777.0 |
| 2019-05-17 | YM | Futures | 27316.8 | 27390.6 | 27051.8 | 27212.3 | 280261.0 |
| 2019-05-17 | CL | Futures | 64.97 | 65.5 | 64.35 | 64.58 | 537033.0 |
| 2019-05-17 | GC | Futures | 1602.1 | 1604.3 | 1586.4 | 1587.8 | 264569.0 |
| 2019-05-17 | ZN | Futures | 123.834118 | 124.098289 | 123.678723 | 123.803039 | 1357736.0 |
| 2019-05-17 | A6 | Futures | 0.71085 | 0.71147 | 0.70807 | 0.70838 | 89026.0 |
| 2019-05-17 | AD | Futures | 0.7517 | 0.75302 | 0.74852 | 0.75251 | 95414.0 |
| 2019-05-17 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-17 | B | Futures | 53.66 | 53.96 | 52.9 | 53.21 | 255528.0 |
| 2019-05-17 | B6 | Futures | 1.3125 | 1.3128 | 1.3043 | 1.3054 | 93937.0 |
| 2019-05-17 | BR | Futures | 0.1978 | 0.1978 | 0.19448 | 0.19484 | 6473.0 |
| 2019-05-17 | BTC | Futures | 12279.1 | 12356.4 | 9773.8 | 11103.8 | 15465.0 |
| 2019-05-17 | BZ | Futures | 53.49 | 53.81 | 52.75 | 53.06 | 43365.0 |
| 2019-05-17 | C | Futures | 1693.0 | 1696.0 | 1673.0 | 1679.0 | 5665.0 |
| 2019-05-17 | CB | Futures | 284.106 | 284.106 | 282.7 | 283.508 | 20.0 |
| 2019-05-17 | CC | Futures | 1599.0 | 1601.0 | 1577.0 | 1584.0 | 14620.0 |
| 2019-05-17 | CNH | Futures | 6.9414 | 6.9629 | 6.9341 | 6.9575 | 1444.0 |
| 2019-05-17 | CSC | Futures | 2.964 | 2.998 | 2.957 | 2.996 | 92.0 |
| 2019-05-17 | CT | Futures | 69.78 | 69.92 | 68.91 | 69.08 | 12236.0 |
| 2019-05-17 | DC | Futures | 24.83 | 25.26 | 24.72 | 25.2 | 450.0 |
| 2019-05-17 | DX | Futures | 93.614 | 93.801 | 93.542 | 93.766 | 8629.0 |
| 2019-05-17 | E1 | Futures | 1.15886 | 1.16014 | 1.15606 | 1.15722 | 18511.0 |
| 2019-05-17 | E6 | Futures | 1.22959 | 1.23042 | 1.22724 | 1.22773 | 142331.0 |
| 2019-05-17 | E7 | Futures | 1.2235 | 1.2243 | 1.221 | 1.2217 | 3294.0 |
| 2019-05-17 | EBM | Futures | 200.66 | 201.81 | 199.5 | 200.08 | 17630.0 |
| 2019-05-17 | ED | Futures | 95.199 | 95.2039 | 95.1917 | 95.1917 | 242206.0 |
| 2019-05-17 | ER | Futures | 98.421 | 98.43 | 98.421 | 98.426 | 122714.0 |
| 2019-05-17 | EW | Futures | 2031.4 | 2033.5 | 2004.3 | 2005.9 | 16015.0 |
| 2019-05-17 | FBON | Futures | 137.54 | 138.07 | 137.54 | 137.8 | 863.0 |
| 2019-05-17 | FBTP | Futures | 114.98 | 115.54 | 114.86 | 115.06 | 118192.0 |
| 2019-05-17 | FBTS | Futures | 105.56 | 105.789 | 105.503 | 105.674 | 77907.0 |
| 2019-05-17 | FCE | Futures | 4855.2 | 4891.1 | 4845.2 | 4878.8 | 107052.0 |
| 2019-05-17 | FDAX | Futures | 12915.9 | 12950.6 | 12785.9 | 12891.7 | 131947.0 |
| 2019-05-17 | FDIV | Futures | 146.93 | 147.53 | 146.93 | 147.48 | 205.0 |
| 2019-05-17 | FDXM | Futures | 12816.5 | 12837.3 | 12675.6 | 12779.9 | 60664.0 |
| 2019-05-17 | FESX | Futures | 2968.9 | 2980.3 | 2948.8 | 2971.5 | 1227149.0 |
| 2019-05-17 | FGBL | Futures | 161.22 | 161.57 | 161.04 | 161.24 | 627131.0 |
| 2019-05-17 | FGBM | Futures | 133.56 | 133.68 | 133.51 | 133.57 | 378820.0 |
| 2019-05-17 | FGBS | Futures | 112.89 | 112.905 | 112.875 | 112.88 | 284897.0 |
| 2019-05-17 | FGBX | Futures | 197.82 | 198.74 | 197.43 | 197.72 | 34378.0 |
| 2019-05-17 | FMWO | Futures | 7127.0 | 7159.4 | 7095.8 | 7151.3 | 7550.0 |
| 2019-05-17 | FOAT | Futures | 147.84 | 148.13 | 147.74 | 147.81 | 139546.0 |
| 2019-05-17 | FTDX | Futures | 2823.1 | 2836.0 | 2810.3 | 2828.6 | 129.0 |
| 2019-05-17 | FTI | Futures | 524.23 | 526.45 | 522.16 | 525.55 | 30643.0 |
| 2019-05-17 | FTUK | Futures | 6729.8 | 6732.5 | 6688.0 | 6727.5 | 95355.0 |
| 2019-05-17 | FVSA | Futures | 222.4 | 227.39 | 216.7 | 216.7 | 22865.0 |
| 2019-05-17 | FXXP | Futures | 339.4 | 340.2 | 337.6 | 339.6 | 52271.0 |
| 2019-05-17 | G | Futures | 118.75 | 119.25 | 118.6 | 118.89 | 162833.0 |
| 2019-05-17 | GF | Futures | 281.997 | 286.608 | 281.457 | 285.529 | 6414.0 |
> showing 50 of 119 rows — these rows as CSV