PREVIEW / futures_daily / 2019-05-08
file: by_date/futures_daily/2019/2019-05-08.parquet size: 10 KB rows: 118
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-08 | ES | Futures | 3121.44 | 3131.97 | 3098.75 | 3118.74 | 2043325.0 |
| 2019-05-08 | NQ | Futures | 8830.21 | 8869.67 | 8756.76 | 8811.49 | 621509.0 |
| 2019-05-08 | YM | Futures | 27388.5 | 27527.9 | 27232.3 | 27459.3 | 306195.0 |
| 2019-05-08 | CL | Futures | 63.08 | 64.03 | 62.7 | 63.78 | 791769.0 |
| 2019-05-08 | GC | Futures | 1600.1 | 1609.0 | 1593.4 | 1594.9 | 302694.0 |
| 2019-05-08 | ZN | Futures | 123.243617 | 123.507788 | 122.979446 | 123.072683 | 2020026.0 |
| 2019-05-08 | A6 | Futures | 0.72333 | 0.72498 | 0.72075 | 0.72106 | 108391.0 |
| 2019-05-08 | AD | Futures | 0.75115 | 0.75266 | 0.75034 | 0.75089 | 73187.0 |
| 2019-05-08 | B | Futures | 51.49 | 52.1 | 51.09 | 51.85 | 295443.0 |
| 2019-05-08 | B6 | Futures | 1.342 | 1.3425 | 1.333 | 1.3347 | 102024.0 |
| 2019-05-08 | BR | Futures | 0.20184 | 0.20344 | 0.20088 | 0.20328 | 7418.0 |
| 2019-05-08 | BTC | Futures | 9101.1 | 9147.5 | 8722.2 | 9124.3 | 7023.0 |
| 2019-05-08 | BZ | Futures | 51.31 | 52.03 | 50.94 | 51.71 | 45312.0 |
| 2019-05-08 | C | Futures | 1672.0 | 1691.0 | 1669.0 | 1670.0 | 8412.0 |
| 2019-05-08 | CB | Futures | 276.958 | 277.527 | 276.809 | 276.929 | 35.0 |
| 2019-05-08 | CC | Futures | 1548.0 | 1569.0 | 1542.0 | 1552.0 | 14742.0 |
| 2019-05-08 | CNH | Futures | 6.8102 | 6.8215 | 6.7907 | 6.8192 | 1139.0 |
| 2019-05-08 | CSC | Futures | 3.015 | 3.015 | 2.989 | 2.991 | 58.0 |
| 2019-05-08 | CT | Futures | 76.57 | 77.14 | 75.26 | 75.69 | 28039.0 |
| 2019-05-08 | DC | Futures | 25.43 | 25.43 | 25.09 | 25.17 | 204.0 |
| 2019-05-08 | DX | Futures | 93.307 | 93.398 | 93.149 | 93.348 | 13543.0 |
| 2019-05-08 | E1 | Futures | 1.14917 | 1.15174 | 1.14719 | 1.148 | 24304.0 |
| 2019-05-08 | E6 | Futures | 1.23256 | 1.23481 | 1.23135 | 1.23239 | 180222.0 |
| 2019-05-08 | E7 | Futures | 1.2266 | 1.2287 | 1.2253 | 1.2263 | 4981.0 |
| 2019-05-08 | EBM | Futures | 198.93 | 198.93 | 196.91 | 198.06 | 6211.0 |
| 2019-05-08 | ED | Futures | 95.1697 | 95.1843 | 95.1648 | 95.1697 | 193957.0 |
| 2019-05-08 | ER | Futures | 98.411 | 98.416 | 98.411 | 98.411 | 15625.0 |
| 2019-05-08 | EW | Futures | 2062.7 | 2068.8 | 2048.2 | 2051.8 | 12434.0 |
| 2019-05-08 | FBON | Futures | 136.42 | 136.94 | 136.42 | 136.85 | 899.0 |
| 2019-05-08 | FBTP | Futures | 115.27 | 115.61 | 114.55 | 115.42 | 142487.0 |
| 2019-05-08 | FBTS | Futures | 105.827 | 105.931 | 105.693 | 105.874 | 89361.0 |
| 2019-05-08 | FCE | Futures | 4836.2 | 4871.8 | 4825.4 | 4861.5 | 95790.0 |
| 2019-05-08 | FDAX | Futures | 12712.7 | 12873.2 | 12705.3 | 12853.2 | 143959.0 |
| 2019-05-08 | FDIV | Futures | 146.83 | 147.34 | 146.69 | 147.34 | 101.0 |
| 2019-05-08 | FDXM | Futures | 12599.4 | 12762.2 | 12596.3 | 12741.8 | 67583.0 |
| 2019-05-08 | FESX | Futures | 2926.9 | 2954.0 | 2921.7 | 2948.8 | 1274929.0 |
| 2019-05-08 | FGBL | Futures | 160.27 | 160.67 | 160.14 | 160.41 | 811576.0 |
| 2019-05-08 | FGBM | Futures | 133.21 | 133.35 | 133.15 | 133.27 | 537217.0 |
| 2019-05-08 | FGBS | Futures | 112.799 | 112.829 | 112.784 | 112.819 | 366729.0 |
| 2019-05-08 | FGBX | Futures | 194.53 | 195.86 | 194.2 | 195.08 | 42550.0 |
| 2019-05-08 | FMWO | Futures | 7167.5 | 7193.0 | 7129.3 | 7175.6 | 3137.0 |
| 2019-05-08 | FOAT | Futures | 147.11 | 147.34 | 146.98 | 147.26 | 133904.0 |
| 2019-05-08 | FTDX | Futures | 2803.9 | 2830.0 | 2793.5 | 2828.6 | 159.0 |
| 2019-05-08 | FTI | Futures | 525.42 | 529.16 | 523.9 | 528.09 | 34919.0 |
| 2019-05-08 | FTUK | Futures | 6576.1 | 6636.7 | 6576.1 | 6623.4 | 124922.0 |
| 2019-05-08 | FVSA | Futures | 234.61 | 240.89 | 226.23 | 230.42 | 56174.0 |
| 2019-05-08 | FXXP | Futures | 338.2 | 339.7 | 336.9 | 339.1 | 87520.0 |
| 2019-05-08 | G | Futures | 117.66 | 118.35 | 117.64 | 117.92 | 223433.0 |
| 2019-05-08 | GF | Futures | 285.747 | 287.724 | 282.051 | 282.676 | 922.0 |
| 2019-05-08 | GSCI | Futures | 491.13 | 494.24 | 491.13 | 492.54 | 2687.0 |
> showing 50 of 118 rows — these rows as CSV