PREVIEW / futures_daily / 2019-03-07
file: by_date/futures_daily/2019/2019-03-07.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-03-07 | ES | Futures | 2999.54 | 3005.76 | 2964.89 | 2977.34 | 1919820.0 |
| 2019-03-07 | NQ | Futures | 8230.47 | 8246.97 | 8108.04 | 8136.11 | 556540.0 |
| 2019-03-07 | YM | Futures | 27073.8 | 27115.0 | 26725.8 | 26861.8 | 275341.0 |
| 2019-03-07 | CL | Futures | 58.09 | 58.91 | 57.97 | 58.57 | 628824.0 |
| 2019-03-07 | GC | Futures | 1609.1 | 1612.0 | 1601.0 | 1607.6 | 257922.0 |
| 2019-03-07 | ZN | Futures | 121.471484 | 121.922761 | 121.455923 | 121.922761 | 16332.0 |
| 2019-03-07 | A6 | Futures | 0.72405 | 0.72652 | 0.72178 | 0.7224 | 107858.0 |
| 2019-03-07 | AD | Futures | 0.75337 | 0.75494 | 0.7519 | 0.75246 | 78191.0 |
| 2019-03-07 | B | Futures | 47.78 | 48.6 | 47.69 | 48.09 | 276242.0 |
| 2019-03-07 | B6 | Futures | 1.3533 | 1.3544 | 1.3424 | 1.3431 | 122504.0 |
| 2019-03-07 | BR | Futures | 0.20817 | 0.20817 | 0.2046 | 0.2046 | 3730.0 |
| 2019-03-07 | BTC | Futures | 5926.5 | 5980.3 | 5888.0 | 5949.5 | 4092.0 |
| 2019-03-07 | BZ | Futures | 47.44 | 48.2 | 47.32 | 47.71 | 35738.0 |
| 2019-03-07 | C | Futures | 1497.0 | 1497.0 | 1464.0 | 1467.0 | 2230.0 |
| 2019-03-07 | CB | Futures | 274.536 | 276.929 | 274.536 | 275.134 | 22.0 |
| 2019-03-07 | CC | Futures | 1513.0 | 1513.0 | 1461.0 | 1473.0 | 21920.0 |
| 2019-03-07 | CNH | Futures | 6.7292 | 6.7453 | 6.7233 | 6.7435 | 630.0 |
| 2019-03-07 | CSC | Futures | 2.789 | 2.796 | 2.787 | 2.794 | 23.0 |
| 2019-03-07 | CT | Futures | 78.94 | 79.23 | 77.55 | 77.62 | 17142.0 |
| 2019-03-07 | DC | Futures | 23.89 | 23.91 | 23.66 | 23.68 | 60.0 |
| 2019-03-07 | DX | Futures | 92.304 | 93.143 | 92.285 | 93.108 | 27952.0 |
| 2019-03-07 | E1 | Futures | 1.17066 | 1.17243 | 1.16232 | 1.16255 | 29448.0 |
| 2019-03-07 | E6 | Futures | 1.25022 | 1.25171 | 1.2358 | 1.23652 | 365760.0 |
| 2019-03-07 | E7 | Futures | 1.2442 | 1.2455 | 1.2298 | 1.2305 | 8865.0 |
| 2019-03-07 | EBM | Futures | 196.87 | 197.4 | 195.01 | 195.28 | 21108.0 |
| 2019-03-07 | ED | Futures | 95.1062 | 95.1087 | 95.0989 | 95.1038 | 184808.0 |
| 2019-03-07 | ER | Futures | 98.411 | 98.411 | 98.406 | 98.406 | 51776.0 |
| 2019-03-07 | EW | Futures | 2004.1 | 2007.7 | 1981.1 | 1986.7 | 27349.0 |
| 2019-03-07 | FBON | Futures | 133.38 | 134.28 | 133.05 | 134.17 | 1503.0 |
| 2019-03-07 | FBTP | Futures | 113.81 | 114.97 | 113.11 | 114.59 | 179800.0 |
| 2019-03-07 | FBTS | Futures | 105.817 | 106.15 | 105.57 | 106.017 | 119360.0 |
| 2019-03-07 | FCE | Futures | 4704.8 | 4733.4 | 4681.6 | 4698.6 | 97134.0 |
| 2019-03-07 | FDAX | Futures | 12142.1 | 12204.6 | 12030.7 | 12095.9 | 150097.0 |
| 2019-03-07 | FDIV | Futures | 142.44 | 142.44 | 141.77 | 142.18 | 50.0 |
| 2019-03-07 | FDXM | Futures | 12114.1 | 12174.9 | 12001.9 | 12066.4 | 72360.0 |
| 2019-03-07 | FESX | Futures | 2832.9 | 2852.6 | 2813.2 | 2825.2 | 1863224.0 |
| 2019-03-07 | FGBL | Futures | 157.89 | 158.84 | 157.73 | 158.8 | 1047328.0 |
| 2019-03-07 | FGBM | Futures | 132.28 | 132.66 | 132.26 | 132.65 | 697007.0 |
| 2019-03-07 | FGBS | Futures | 112.623 | 112.698 | 112.618 | 112.693 | 474837.0 |
| 2019-03-07 | FGBX | Futures | 187.78 | 189.77 | 187.21 | 189.75 | 75670.0 |
| 2019-03-07 | FMWO | Futures | 6970.1 | 6984.1 | 6908.3 | 6924.6 | 3990.0 |
| 2019-03-07 | FOAT | Futures | 144.01 | 145.23 | 143.8 | 145.18 | 290120.0 |
| 2019-03-07 | FTDX | Futures | 2612.9 | 2618.4 | 2598.5 | 2604.4 | 277.0 |
| 2019-03-07 | FTI | Futures | 504.99 | 508.09 | 501.61 | 503.9 | 33582.0 |
| 2019-03-07 | FTUK | Futures | 6519.9 | 6550.4 | 6488.9 | 6506.3 | 130397.0 |
| 2019-03-07 | FVSA | Futures | 258.65 | 263.89 | 249.03 | 258.65 | 36769.0 |
| 2019-03-07 | FXXP | Futures | 328.7 | 330.7 | 327.1 | 328.1 | 104816.0 |
| 2019-03-07 | G | Futures | 116.74 | 117.56 | 116.71 | 117.54 | 229319.0 |
| 2019-03-07 | GF | Futures | 307.964 | 312.83 | 307.144 | 312.502 | 2725.0 |
| 2019-03-07 | GSCI | Futures | 485.56 | 485.56 | 483.1 | 483.44 | 2200.0 |
> showing 50 of 116 rows — these rows as CSV