PREVIEW / futures_daily / 2019-04-11
file: by_date/futures_daily/2019/2019-04-11.parquet size: 10 KB rows: 116
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-04-11 | ES | Futures | 3126.84 | 3132.51 | 3116.58 | 3123.6 | 968649.0 |
| 2019-04-11 | NQ | Futures | 8807.45 | 8827.04 | 8758.48 | 8776.63 | 340950.0 |
| 2019-04-11 | YM | Futures | 27644.0 | 27686.2 | 27507.8 | 27584.9 | 156461.0 |
| 2019-04-11 | CL | Futures | 66.21 | 66.22 | 65.01 | 65.29 | 760504.0 |
| 2019-04-11 | GC | Futures | 1633.4 | 1634.3 | 1609.2 | 1609.7 | 324740.0 |
| 2019-04-11 | ZN | Futures | 123.16592 | 123.181459 | 122.839591 | 122.886209 | 1142422.0 |
| 2019-04-11 | A6 | Futures | 0.74013 | 0.74023 | 0.73467 | 0.73477 | 86408.0 |
| 2019-04-11 | AD | Futures | 0.76035 | 0.7604 | 0.7558 | 0.75676 | 68206.0 |
| 2019-04-11 | B | Futures | 52.12 | 52.21 | 51.4 | 51.59 | 278088.0 |
| 2019-04-11 | B6 | Futures | 1.3446 | 1.3471 | 1.341 | 1.3418 | 79761.0 |
| 2019-04-11 | BR | Futures | 0.20789 | 0.20789 | 0.20665 | 0.20665 | 6.0 |
| 2019-04-11 | BTC | Futures | 8189.1 | 8274.0 | 7671.4 | 7841.4 | 11268.0 |
| 2019-04-11 | BZ | Futures | 52.05 | 52.07 | 51.27 | 51.45 | 39968.0 |
| 2019-04-11 | C | Futures | 1609.0 | 1620.0 | 1594.0 | 1610.0 | 6261.0 |
| 2019-04-11 | CB | Futures | 276.151 | 276.151 | 275.643 | 275.643 | 15.0 |
| 2019-04-11 | CC | Futures | 1629.0 | 1639.0 | 1598.0 | 1601.0 | 29235.0 |
| 2019-04-11 | CNH | Futures | 6.7301 | 6.7403 | 6.7273 | 6.7388 | 284.0 |
| 2019-04-11 | CSC | Futures | 2.892 | 2.896 | 2.873 | 2.884 | 101.0 |
| 2019-04-11 | CT | Futures | 82.57 | 82.75 | 81.6 | 81.73 | 26656.0 |
| 2019-04-11 | DC | Futures | 24.35 | 24.4 | 24.17 | 24.25 | 173.0 |
| 2019-04-11 | DX | Futures | 92.521 | 92.842 | 92.497 | 92.793 | 10058.0 |
| 2019-04-11 | E1 | Futures | 1.17146 | 1.17286 | 1.16866 | 1.16983 | 22566.0 |
| 2019-04-11 | E6 | Futures | 1.24414 | 1.24556 | 1.24145 | 1.24205 | 135586.0 |
| 2019-04-11 | E7 | Futures | 1.2381 | 1.2394 | 1.2353 | 1.2359 | 3290.0 |
| 2019-04-11 | EBM | Futures | 200.04 | 200.57 | 199.51 | 200.31 | 14223.0 |
| 2019-04-11 | ED | Futures | 95.155 | 95.155 | 95.1404 | 95.1502 | 222555.0 |
| 2019-04-11 | ER | Futures | 98.416 | 98.421 | 98.416 | 98.416 | 41119.0 |
| 2019-04-11 | EW | Futures | 2068.8 | 2076.9 | 2065.1 | 2074.5 | 9253.0 |
| 2019-04-11 | FBON | Futures | 135.6 | 136.25 | 135.55 | 136.07 | 580.0 |
| 2019-04-11 | FBTP | Futures | 115.5 | 116.13 | 115.38 | 116.03 | 91689.0 |
| 2019-04-11 | FBTS | Futures | 105.789 | 105.989 | 105.77 | 105.96 | 71378.0 |
| 2019-04-11 | FCE | Futures | 4866.2 | 4896.5 | 4847.9 | 4884.4 | 102498.0 |
| 2019-04-11 | FDAX | Futures | 12580.1 | 12623.2 | 12495.9 | 12604.3 | 100399.0 |
| 2019-04-11 | FDIV | Futures | 146.51 | 147.62 | 146.0 | 147.16 | 29.0 |
| 2019-04-11 | FDXM | Futures | 12463.8 | 12513.8 | 12387.6 | 12495.1 | 43901.0 |
| 2019-04-11 | FESX | Futures | 2933.1 | 2943.5 | 2916.5 | 2940.9 | 858900.0 |
| 2019-04-11 | FGBL | Futures | 160.04 | 160.09 | 159.74 | 159.81 | 510886.0 |
| 2019-04-11 | FGBM | Futures | 133.13 | 133.14 | 133.01 | 133.03 | 339705.0 |
| 2019-04-11 | FGBS | Futures | 112.774 | 112.779 | 112.744 | 112.754 | 215223.0 |
| 2019-04-11 | FGBX | Futures | 194.3 | 194.49 | 193.53 | 193.65 | 31373.0 |
| 2019-04-11 | FMWO | Futures | 7211.5 | 7230.0 | 7201.1 | 7219.6 | 1723.0 |
| 2019-04-11 | FOAT | Futures | 147.23 | 147.3 | 147.01 | 147.04 | 96794.0 |
| 2019-04-11 | FTDX | Futures | 2704.2 | 2709.6 | 2688.4 | 2704.7 | 66.0 |
| 2019-04-11 | FTI | Futures | 524.52 | 526.79 | 522.9 | 525.55 | 2950.0 |
| 2019-04-11 | FTUK | Futures | 6748.6 | 6773.8 | 6718.3 | 6751.8 | 99462.0 |
| 2019-04-11 | FVSA | Futures | 237.05 | 238.68 | 214.24 | 215.06 | 56731.0 |
| 2019-04-11 | FXXP | Futures | 340.2 | 341.9 | 339.3 | 341.1 | 49712.0 |
| 2019-04-11 | G | Futures | 118.23 | 118.24 | 117.65 | 117.73 | 166072.0 |
| 2019-04-11 | GF | Futures | 310.886 | 313.853 | 309.845 | 311.979 | 5975.0 |
| 2019-04-11 | GSCI | Futures | 508.62 | 511.05 | 506.99 | 506.99 | 2419.0 |
> showing 50 of 116 rows — these rows as CSV