PREVIEW / futures_daily / 2019-04-03
file: by_date/futures_daily/2019/2019-04-03.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-03 | ES | Futures | 3095.78 | 3120.9 | 3094.97 | 3110.63 | 1240848.0 |
| 2019-04-03 | NQ | Futures | 8661.12 | 8775.48 | 8656.8 | 8736.3 | 483546.0 |
| 2019-04-03 | YM | Futures | 27598.6 | 27763.3 | 27584.9 | 27697.8 | 175360.0 |
| 2019-04-03 | CL | Futures | 64.32 | 64.68 | 63.72 | 64.14 | 799672.0 |
| 2019-04-03 | GC | Futures | 1614.2 | 1616.8 | 1608.9 | 1612.2 | 190367.0 |
| 2019-04-03 | ZN | Futures | 123.134841 | 123.16592 | 122.730814 | 122.824051 | 1565485.0 |
| 2019-04-03 | A6 | Futures | 0.72982 | 0.73611 | 0.72828 | 0.73477 | 118030.0 |
| 2019-04-03 | AD | Futures | 0.75949 | 0.76176 | 0.75853 | 0.75933 | 64984.0 |
| 2019-04-03 | B | Futures | 50.6 | 50.96 | 50.11 | 50.48 | 341499.0 |
| 2019-04-03 | B6 | Futures | 1.3503 | 1.3567 | 1.3489 | 1.3527 | 114546.0 |
| 2019-04-03 | BFX | Futures | 4405.0 | 4423.7 | 4405.0 | 4423.7 | 17.0 |
| 2019-04-03 | BR | Futures | 0.20725 | 0.20781 | 0.20593 | 0.20593 | 234.0 |
| 2019-04-03 | BTC | Futures | 7432.0 | 8227.7 | 7432.0 | 7957.3 | 16115.0 |
| 2019-04-03 | BZ | Futures | 50.69 | 50.82 | 49.98 | 50.35 | 46550.0 |
| 2019-04-03 | C | Futures | 1570.0 | 1586.0 | 1566.0 | 1584.0 | 12250.0 |
| 2019-04-03 | CB | Futures | 277.347 | 277.527 | 277.048 | 277.527 | 39.0 |
| 2019-04-03 | CC | Futures | 1602.0 | 1616.0 | 1585.0 | 1604.0 | 27653.0 |
| 2019-04-03 | CNH | Futures | 6.7364 | 6.7364 | 6.7181 | 6.7238 | 318.0 |
| 2019-04-03 | CSC | Futures | 2.87 | 2.885 | 2.859 | 2.864 | 83.0 |
| 2019-04-03 | CT | Futures | 82.04 | 82.74 | 81.65 | 81.8 | 15407.0 |
| 2019-04-03 | DC | Futures | 24.28 | 24.38 | 24.14 | 24.2 | 198.0 |
| 2019-04-03 | DX | Futures | 92.866 | 92.871 | 92.521 | 92.652 | 12578.0 |
| 2019-04-03 | E1 | Futures | 1.17741 | 1.18068 | 1.17659 | 1.17776 | 18826.0 |
| 2019-04-03 | E6 | Futures | 1.23711 | 1.24304 | 1.23711 | 1.24128 | 178296.0 |
| 2019-04-03 | E7 | Futures | 1.2311 | 1.2368 | 1.2311 | 1.2351 | 3552.0 |
| 2019-04-03 | EBM | Futures | 198.98 | 200.04 | 198.72 | 199.51 | 13880.0 |
| 2019-04-03 | ED | Futures | 95.1453 | 95.1502 | 95.1355 | 95.1404 | 243681.0 |
| 2019-04-03 | ER | Futures | 98.416 | 98.421 | 98.416 | 98.416 | 23062.0 |
| 2019-04-03 | EW | Futures | 2034.2 | 2057.5 | 2033.0 | 2046.8 | 11150.0 |
| 2019-04-03 | FBON | Futures | 134.68 | 134.7 | 134.5 | 134.56 | 707.0 |
| 2019-04-03 | FBTP | Futures | 114.38 | 114.91 | 114.18 | 114.28 | 86298.0 |
| 2019-04-03 | FBTS | Futures | 105.617 | 105.779 | 105.532 | 105.579 | 58767.0 |
| 2019-04-03 | FCE | Futures | 4866.2 | 4874.6 | 4852.3 | 4868.8 | 75511.0 |
| 2019-04-03 | FDAX | Futures | 12404.3 | 12629.0 | 12404.3 | 12610.1 | 116415.0 |
| 2019-04-03 | FDIV | Futures | 145.26 | 146.28 | 145.26 | 146.23 | 115.0 |
| 2019-04-03 | FDXM | Futures | 12304.1 | 12519.1 | 12304.1 | 12500.8 | 55526.0 |
| 2019-04-03 | FESX | Futures | 2908.6 | 2941.8 | 2906.8 | 2934.8 | 1007687.0 |
| 2019-04-03 | FGBL | Futures | 160.15 | 160.21 | 159.42 | 159.63 | 820784.0 |
| 2019-04-03 | FGBM | Futures | 133.11 | 133.14 | 132.87 | 132.95 | 618584.0 |
| 2019-04-03 | FGBS | Futures | 112.829 | 112.829 | 112.754 | 112.769 | 528759.0 |
| 2019-04-03 | FGBX | Futures | 194.61 | 194.94 | 191.95 | 192.69 | 63498.0 |
| 2019-04-03 | FMWO | Futures | 7201.1 | 7219.6 | 7186.0 | 7210.3 | 3132.0 |
| 2019-04-03 | FOAT | Futures | 146.58 | 146.58 | 146.16 | 146.34 | 176902.0 |
| 2019-04-03 | FTDX | Futures | 2700.7 | 2740.2 | 2691.9 | 2736.8 | 437.0 |
| 2019-04-03 | FTI | Futures | 524.16 | 526.18 | 522.85 | 525.47 | 20493.0 |
| 2019-04-03 | FTUK | Futures | 6696.7 | 6744.9 | 6690.8 | 6732.5 | 92170.0 |
| 2019-04-03 | FVSA | Futures | 240.31 | 245.2 | 237.05 | 240.31 | 19916.0 |
| 2019-04-03 | FXXP | Futures | 341.0 | 342.6 | 340.4 | 341.8 | 68856.0 |
| 2019-04-03 | G | Futures | 118.57 | 118.65 | 118.13 | 118.48 | 221788.0 |
| 2019-04-03 | GF | Futures | 310.092 | 310.627 | 307.526 | 309.558 | 1972.0 |
> showing 50 of 116 rows — these rows as CSV