PREVIEW / futures_daily / 2018-05-08
file: by_date/futures_daily/2018/2018-05-08.parquet size: 10 KB rows: 113
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-08 | ES | Futures | 2901.36 | 2908.16 | 2884.24 | 2903.81 | 1281751.0 |
| 2018-05-08 | NQ | Futures | 7978.84 | 8002.84 | 7925.0 | 7982.94 | 370356.0 |
| 2018-05-08 | YM | Futures | 25580.8 | 25655.6 | 25423.8 | 25605.0 | 219324.0 |
| 2018-05-08 | CL | Futures | 70.29 | 70.66 | 67.88 | 69.31 | 1253566.0 |
| 2018-05-08 | GC | Futures | 1677.7 | 1683.3 | 1667.6 | 1677.2 | 407409.0 |
| 2018-05-08 | ZN | Futures | 118.749213 | 118.826756 | 118.485567 | 118.625145 | 1208157.0 |
| 2018-05-08 | A6 | Futures | 0.77283 | 0.77406 | 0.7644 | 0.76594 | 142668.0 |
| 2018-05-08 | AD | Futures | 0.78596 | 0.78632 | 0.77893 | 0.78146 | 103149.0 |
| 2018-05-08 | B | Futures | 55.4 | 55.83 | 53.57 | 54.85 | 519797.0 |
| 2018-05-08 | B6 | Futures | 1.4065 | 1.4101 | 1.3987 | 1.4042 | 127536.0 |
| 2018-05-08 | BR | Futures | 0.21359 | 0.2137 | 0.21161 | 0.21317 | 3014.0 |
| 2018-05-08 | BTC | Futures | 13214.3 | 13326.6 | 12652.6 | 12968.5 | 4435.0 |
| 2018-05-08 | BZ | Futures | 54.88 | 55.26 | 53.02 | 54.29 | 50813.0 |
| 2018-05-08 | C | Futures | 1779.0 | 1788.0 | 1741.0 | 1742.0 | 2165.0 |
| 2018-05-08 | CB | Futures | 291.563 | 292.798 | 290.513 | 292.798 | 104.0 |
| 2018-05-08 | CC | Futures | 2064.0 | 2075.0 | 2011.0 | 2022.0 | 19359.0 |
| 2018-05-08 | CNH | Futures | 6.4579 | 6.4693 | 6.4579 | 6.4659 | 9.0 |
| 2018-05-08 | CSC | Futures | 3.505 | 3.547 | 3.503 | 3.536 | 54.0 |
| 2018-05-08 | CT | Futures | 97.9 | 98.75 | 96.75 | 97.06 | 18277.0 |
| 2018-05-08 | DC | Futures | 28.25 | 28.55 | 28.25 | 28.39 | 388.0 |
| 2018-05-08 | DX | Futures | 87.292 | 87.839 | 87.244 | 87.672 | 29976.0 |
| 2018-05-08 | E1 | Futures | 1.20454 | 1.20779 | 1.20273 | 1.20562 | 30569.0 |
| 2018-05-08 | E6 | Futures | 1.347 | 1.34869 | 1.33737 | 1.33945 | 287935.0 |
| 2018-05-08 | E7 | Futures | 1.3397 | 1.3414 | 1.3303 | 1.3323 | 4462.0 |
| 2018-05-08 | EBM | Futures | 181.51 | 183.87 | 181.25 | 183.34 | 12108.0 |
| 2018-05-08 | ED | Futures | 94.9111 | 94.9403 | 94.9063 | 94.9354 | 379390.0 |
| 2018-05-08 | ER | Futures | 98.347 | 98.347 | 98.342 | 98.347 | 10203.0 |
| 2018-05-08 | EW | Futures | 2020.4 | 2028.9 | 2013.5 | 2026.6 | 15972.0 |
| 2018-05-08 | FBON | Futures | 129.59 | 129.59 | 129.02 | 129.09 | 452.0 |
| 2018-05-08 | FBTP | Futures | 116.07 | 116.07 | 114.86 | 114.95 | 146415.0 |
| 2018-05-08 | FBTS | Futures | 104.306 | 104.306 | 104.213 | 104.223 | 68828.0 |
| 2018-05-08 | FCE | Futures | 4911.4 | 4913.2 | 4879.7 | 4903.4 | 61275.0 |
| 2018-05-08 | FDAX | Futures | 13445.8 | 13462.9 | 13363.2 | 13422.9 | 78974.0 |
| 2018-05-08 | FDXM | Futures | 13325.0 | 13343.6 | 13244.7 | 13303.4 | 23750.0 |
| 2018-05-08 | FESX | Futures | 2928.1 | 2932.2 | 2911.4 | 2924.7 | 761172.0 |
| 2018-05-08 | FEU3 | Futures | 99.021 | 99.026 | 99.021 | 99.026 | 205.0 |
| 2018-05-08 | FGBL | Futures | 149.86 | 149.89 | 149.41 | 149.48 | 547045.0 |
| 2018-05-08 | FGBM | Futures | 129.71 | 129.75 | 129.58 | 129.63 | 335055.0 |
| 2018-05-08 | FGBS | Futures | 112.517 | 112.527 | 112.502 | 112.517 | 220988.0 |
| 2018-05-08 | FGBX | Futures | 170.12 | 170.26 | 169.02 | 169.19 | 37765.0 |
| 2018-05-08 | FMWO | Futures | 6973.6 | 6973.6 | 6936.3 | 6957.3 | 821.0 |
| 2018-05-08 | FOAT | Futures | 138.88 | 138.9 | 138.38 | 138.47 | 90901.0 |
| 2018-05-08 | FTDX | Futures | 2720.6 | 2720.6 | 2698.3 | 2715.1 | 164.0 |
| 2018-05-08 | FTI | Futures | 512.98 | 515.7 | 512.47 | 514.23 | 20528.0 |
| 2018-05-08 | FTUK | Futures | 6667.8 | 6677.5 | 6624.5 | 6646.6 | 111323.0 |
| 2018-05-08 | FVSA | Futures | 327.2 | 338.68 | 323.75 | 332.94 | 16899.0 |
| 2018-05-08 | FXXP | Futures | 333.8 | 334.7 | 332.7 | 334.2 | 36655.0 |
| 2018-05-08 | G | Futures | 114.03 | 114.19 | 113.6 | 113.68 | 188464.0 |
| 2018-05-08 | GF | Futures | 296.169 | 297.084 | 292.511 | 296.384 | 1840.0 |
| 2018-05-08 | GSCI | Futures | 538.79 | 542.51 | 533.44 | 538.12 | 3187.0 |
> showing 50 of 113 rows — these rows as CSV