PREVIEW / futures_daily / 2019-10-08
file: by_date/futures_daily/2019/2019-10-08.parquet size: 10 KB rows: 120
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-10-08 | ES | Futures | 3176.79 | 3193.57 | 3129.16 | 3131.33 | 1865325.0 |
| 2019-10-08 | NQ | Futures | 8915.13 | 8971.02 | 8773.96 | 8783.75 | 552145.0 |
| 2019-10-08 | YM | Futures | 27733.4 | 27870.9 | 27391.1 | 27439.4 | 234008.0 |
| 2019-10-08 | CL | Futures | 54.22 | 54.69 | 53.19 | 54.03 | 658324.0 |
| 2019-10-08 | GC | Futures | 1848.7 | 1869.2 | 1840.6 | 1855.1 | 371439.0 |
| 2019-10-08 | ZN | Futures | 130.301327 | 130.76586 | 130.022608 | 130.518109 | 1396465.0 |
| 2019-10-08 | A6 | Futures | 0.69209 | 0.69465 | 0.69127 | 0.69178 | 95433.0 |
| 2019-10-08 | AD | Futures | 0.75723 | 0.75854 | 0.75572 | 0.75678 | 76621.0 |
| 2019-10-08 | ALI | Futures | 2111.23 | 2134.78 | 2109.42 | 2123.0 | 208.0 |
| 2019-10-08 | B | Futures | 46.32 | 46.68 | 45.46 | 46.14 | 274743.0 |
| 2019-10-08 | B6 | Futures | 1.2525 | 1.2538 | 1.2429 | 1.2451 | 107747.0 |
| 2019-10-08 | BR | Futures | 0.19598 | 0.19732 | 0.19598 | 0.19724 | 204.0 |
| 2019-10-08 | BTC | Futures | 11880.1 | 12031.1 | 11642.8 | 11750.6 | 2275.0 |
| 2019-10-08 | BZ | Futures | 45.67 | 46.03 | 44.81 | 45.49 | 38868.0 |
| 2019-10-08 | C | Futures | 1697.0 | 1719.0 | 1681.0 | 1706.0 | 6919.0 |
| 2019-10-08 | CB | Futures | 250.079 | 250.345 | 248.574 | 248.574 | 18.0 |
| 2019-10-08 | CC | Futures | 1586.0 | 1620.0 | 1569.0 | 1607.0 | 23521.0 |
| 2019-10-08 | CNH | Futures | 7.1316 | 7.1606 | 7.1144 | 7.1477 | 1274.0 |
| 2019-10-08 | CSC | Futures | 3.158 | 3.177 | 3.158 | 3.177 | 63.0 |
| 2019-10-08 | CT | Futures | 59.98 | 60.16 | 59.17 | 59.69 | 14979.0 |
| 2019-10-08 | DC | Futures | 26.34 | 26.67 | 26.34 | 26.64 | 184.0 |
| 2019-10-08 | DX | Futures | 95.362 | 95.643 | 95.242 | 95.514 | 13917.0 |
| 2019-10-08 | E1 | Futures | 1.16266 | 1.16761 | 1.1614 | 1.16393 | 30887.0 |
| 2019-10-08 | E6 | Futures | 1.19458 | 1.1974 | 1.19144 | 1.19312 | 165114.0 |
| 2019-10-08 | E7 | Futures | 1.1886 | 1.1911 | 1.1852 | 1.1869 | 3869.0 |
| 2019-10-08 | EBM | Futures | 192.63 | 195.09 | 192.35 | 194.82 | 27325.0 |
| 2019-10-08 | ED | Futures | 95.3715 | 95.4152 | 95.352 | 95.4055 | 403634.0 |
| 2019-10-08 | ER | Futures | 98.47 | 98.47 | 98.46 | 98.47 | 26456.0 |
| 2019-10-08 | EW | Futures | 1989.3 | 1998.5 | 1953.5 | 1955.3 | 13566.0 |
| 2019-10-08 | FBON | Futures | 146.09 | 146.41 | 145.92 | 146.41 | 225.0 |
| 2019-10-08 | FBTP | Futures | 132.08 | 132.43 | 131.96 | 132.29 | 44858.0 |
| 2019-10-08 | FBTS | Futures | 108.548 | 108.548 | 108.481 | 108.519 | 29760.0 |
| 2019-10-08 | FCE | Futures | 5005.6 | 5014.2 | 4931.8 | 4939.1 | 87033.0 |
| 2019-10-08 | FDAX | Futures | 12738.9 | 12810.6 | 12560.6 | 12635.0 | 121073.0 |
| 2019-10-08 | FDIV | Futures | 143.63 | 144.7 | 143.63 | 144.7 | 280.0 |
| 2019-10-08 | FDXM | Futures | 12585.1 | 12642.3 | 12395.5 | 12470.0 | 52210.0 |
| 2019-10-08 | FESX | Futures | 3029.0 | 3043.1 | 2991.3 | 3003.6 | 1012577.0 |
| 2019-10-08 | FGBL | Futures | 168.32 | 168.75 | 167.95 | 168.73 | 556102.0 |
| 2019-10-08 | FGBM | Futures | 135.24 | 135.36 | 135.15 | 135.35 | 352940.0 |
| 2019-10-08 | FGBS | Futures | 113.021 | 113.056 | 113.016 | 113.051 | 184902.0 |
| 2019-10-08 | FGBX | Futures | 225.14 | 226.3 | 223.06 | 226.22 | 41481.0 |
| 2019-10-08 | FMWO | Futures | 7190.2 | 7190.2 | 7066.2 | 7083.3 | 1924.0 |
| 2019-10-08 | FOAT | Futures | 154.77 | 155.45 | 154.64 | 155.44 | 88477.0 |
| 2019-10-08 | FTDX | Futures | 2752.1 | 2754.0 | 2653.4 | 2663.2 | 147.0 |
| 2019-10-08 | FTI | Futures | 540.54 | 541.77 | 533.38 | 533.6 | 30360.0 |
| 2019-10-08 | FTUK | Futures | 6634.6 | 6668.4 | 6584.1 | 6606.3 | 106436.0 |
| 2019-10-08 | FVSA | Futures | 190.87 | 216.13 | 190.87 | 207.71 | 34519.0 |
| 2019-10-08 | FXXP | Futures | 345.7 | 346.4 | 340.8 | 341.6 | 70994.0 |
| 2019-10-08 | G | Futures | 123.37 | 123.93 | 123.27 | 123.87 | 177755.0 |
| 2019-10-08 | GF | Futures | 296.348 | 298.232 | 295.616 | 297.29 | 1010.0 |
> showing 50 of 120 rows — these rows as CSV