PREVIEW / futures_daily / 2019-05-10
file: by_date/futures_daily/2019/2019-05-10.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-10 | ES | Futures | 3099.83 | 3124.95 | 3052.57 | 3118.47 | 2848095.0 |
| 2019-05-10 | NQ | Futures | 8746.39 | 8819.55 | 8567.51 | 8768.57 | 802652.0 |
| 2019-05-10 | YM | Futures | 27229.1 | 27461.4 | 26878.7 | 27406.5 | 368236.0 |
| 2019-05-10 | CL | Futures | 63.28 | 64.16 | 63.06 | 63.3 | 786494.0 |
| 2019-05-10 | GC | Futures | 1599.3 | 1605.9 | 1598.0 | 1602.3 | 238643.0 |
| 2019-05-10 | ZN | Futures | 123.383473 | 123.538867 | 123.15038 | 123.305775 | 2112004.0 |
| 2019-05-10 | A6 | Futures | 0.72106 | 0.72415 | 0.71993 | 0.72199 | 118194.0 |
| 2019-05-10 | AD | Futures | 0.75094 | 0.7562 | 0.75059 | 0.75393 | 120711.0 |
| 2019-05-10 | B | Futures | 51.91 | 52.49 | 51.71 | 52.04 | 300458.0 |
| 2019-05-10 | B6 | Futures | 1.3352 | 1.3389 | 1.3331 | 1.3349 | 82051.0 |
| 2019-05-10 | BR | Futures | 0.20236 | 0.203 | 0.20124 | 0.20212 | 2987.0 |
| 2019-05-10 | BTC | Futures | 9472.2 | 9943.9 | 9449.0 | 9843.4 | 9795.0 |
| 2019-05-10 | BZ | Futures | 51.66 | 52.34 | 51.57 | 51.9 | 50395.0 |
| 2019-05-10 | C | Futures | 1672.0 | 1675.0 | 1652.0 | 1660.0 | 12418.0 |
| 2019-05-10 | CB | Futures | 280.517 | 280.697 | 280.517 | 280.697 | 23.0 |
| 2019-05-10 | CC | Futures | 1568.0 | 1583.0 | 1551.0 | 1557.0 | 13321.0 |
| 2019-05-10 | CNH | Futures | 6.846 | 6.8773 | 6.8302 | 6.8612 | 1529.0 |
| 2019-05-10 | CSC | Futures | 3.006 | 3.006 | 2.998 | 2.998 | 40.0 |
| 2019-05-10 | CT | Futures | 73.6 | 74.86 | 71.55 | 71.65 | 26951.0 |
| 2019-05-10 | DC | Futures | 25.06 | 25.1 | 24.94 | 24.98 | 181.0 |
| 2019-05-10 | DX | Futures | 93.211 | 93.211 | 92.885 | 93.096 | 14285.0 |
| 2019-05-10 | E1 | Futures | 1.15361 | 1.15921 | 1.15256 | 1.15617 | 27268.0 |
| 2019-05-10 | E6 | Futures | 1.23503 | 1.23881 | 1.23481 | 1.23634 | 148422.0 |
| 2019-05-10 | E7 | Futures | 1.2288 | 1.2326 | 1.2287 | 1.2302 | 2742.0 |
| 2019-05-10 | EBM | Futures | 196.34 | 196.62 | 194.32 | 194.61 | 10688.0 |
| 2019-05-10 | ED | Futures | 95.1843 | 95.199 | 95.1795 | 95.1941 | 236410.0 |
| 2019-05-10 | ER | Futures | 98.411 | 98.416 | 98.411 | 98.416 | 23094.0 |
| 2019-05-10 | EW | Futures | 2046.0 | 2058.7 | 2014.6 | 2052.8 | 12541.0 |
| 2019-05-10 | FBON | Futures | 136.5 | 136.77 | 136.49 | 136.54 | 416.0 |
| 2019-05-10 | FBTP | Futures | 114.87 | 115.11 | 114.7 | 114.82 | 63816.0 |
| 2019-05-10 | FBTS | Futures | 105.703 | 105.731 | 105.636 | 105.684 | 35887.0 |
| 2019-05-10 | FCE | Futures | 4811.9 | 4854.7 | 4779.5 | 4793.9 | 94274.0 |
| 2019-05-10 | FDAX | Futures | 12758.0 | 12856.9 | 12599.6 | 12719.0 | 138708.0 |
| 2019-05-10 | FDIV | Futures | 145.63 | 145.63 | 145.26 | 145.26 | 1.0 |
| 2019-05-10 | FDXM | Futures | 12649.5 | 12744.5 | 12491.9 | 12608.8 | 65659.0 |
| 2019-05-10 | FESX | Futures | 2929.6 | 2942.7 | 2895.5 | 2911.2 | 1202902.0 |
| 2019-05-10 | FGBL | Futures | 160.33 | 160.6 | 160.16 | 160.45 | 617069.0 |
| 2019-05-10 | FGBM | Futures | 133.3 | 133.36 | 133.24 | 133.33 | 409256.0 |
| 2019-05-10 | FGBS | Futures | 112.839 | 112.849 | 112.814 | 112.829 | 257931.0 |
| 2019-05-10 | FGBX | Futures | 194.96 | 195.51 | 194.16 | 195.04 | 41346.0 |
| 2019-05-10 | FMWO | Futures | 7092.3 | 7153.6 | 7048.3 | 7061.1 | 2463.0 |
| 2019-05-10 | FOAT | Futures | 147.07 | 147.14 | 146.84 | 147.07 | 112979.0 |
| 2019-05-10 | FTDX | Futures | 2791.1 | 2791.1 | 2772.8 | 2778.2 | 200.0 |
| 2019-05-10 | FTI | Futures | 519.19 | 523.15 | 516.21 | 517.19 | 1366.0 |
| 2019-05-10 | FTUK | Futures | 6608.7 | 6643.1 | 6555.5 | 6579.8 | 91442.0 |
| 2019-05-10 | FVSA | Futures | 231.12 | 247.18 | 217.85 | 238.8 | 61463.0 |
| 2019-05-10 | FXXP | Futures | 335.6 | 338.5 | 334.2 | 335.3 | 58750.0 |
| 2019-05-10 | G | Futures | 117.95 | 118.13 | 117.86 | 118.0 | 146429.0 |
| 2019-05-10 | GF | Futures | 283.665 | 290.631 | 281.359 | 288.129 | 8062.0 |
| 2019-05-10 | GSCI | Futures | 490.63 | 491.81 | 490.63 | 491.47 | 2169.0 |
> showing 50 of 118 rows — these rows as CSV