PREVIEW / futures_daily / 2020-05-14
file: by_date/futures_daily/2020/2020-05-14.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 |
|---|---|---|---|---|---|---|---|
| 2020-05-14 | ES | Futures | 3120.57 | 3157.63 | 3054.18 | 3150.16 | 2501222.0 |
| 2020-05-14 | NQ | Futures | 10332.58 | 10437.19 | 10142.55 | 10409.1 | 639071.0 |
| 2020-05-14 | YM | Futures | 24789.8 | 25173.9 | 24226.4 | 25112.0 | 328589.0 |
| 2020-05-14 | CL | Futures | 18.83 | 20.49 | 18.53 | 20.21 | 413435.0 |
| 2020-05-14 | GC | Futures | 2089.6 | 2118.0 | 2081.0 | 2111.2 | 212914.0 |
| 2020-05-14 | ZN | Futures | 137.515968 | 137.82468 | 137.469661 | 137.732067 | 1097438.0 |
| 2020-05-14 | A6 | Futures | 0.66295 | 0.6646 | 0.65792 | 0.661 | 82642.0 |
| 2020-05-14 | AD | Futures | 0.71877 | 0.72222 | 0.71664 | 0.72004 | 57083.0 |
| 2020-05-14 | ALI | Futures | 1782.39 | 1782.39 | 1782.39 | 1782.39 | 29.0 |
| 2020-05-14 | B | Futures | 19.49 | 20.83 | 19.07 | 20.56 | 222209.0 |
| 2020-05-14 | B6 | Futures | 1.2419 | 1.2428 | 1.2349 | 1.238 | 76319.0 |
| 2020-05-14 | BFX | Futures | 2922.8 | 2926.7 | 2922.8 | 2926.7 | 199.0 |
| 2020-05-14 | BR | Futures | 0.1385 | 0.14104 | 0.1371 | 0.14022 | 12585.0 |
| 2020-05-14 | BTC | Futures | 13073.8 | 14005.6 | 13011.2 | 13525.8 | 8874.0 |
| 2020-05-14 | BZ | Futures | 18.79 | 20.13 | 18.48 | 19.9 | 25953.0 |
| 2020-05-14 | C | Futures | 1885.0 | 1912.0 | 1861.0 | 1874.0 | 7477.0 |
| 2020-05-14 | CB | Futures | 176.221 | 180.961 | 176.221 | 180.961 | 30.0 |
| 2020-05-14 | CC | Futures | 1607.0 | 1614.0 | 1571.0 | 1577.0 | 12082.0 |
| 2020-05-14 | CNH | Futures | 7.0511 | 7.069 | 7.0471 | 7.0584 | 335.0 |
| 2020-05-14 | CSC | Futures | 3.007 | 3.256 | 2.98 | 3.256 | 448.0 |
| 2020-05-14 | CT | Futures | 56.22 | 56.76 | 55.37 | 56.39 | 9917.0 |
| 2020-05-14 | DC | Futures | 24.57 | 25.61 | 24.41 | 25.61 | 762.0 |
| 2020-05-14 | DX | Futures | 96.934 | 97.283 | 96.891 | 97.188 | 13873.0 |
| 2020-05-14 | E1 | Futures | 1.17235 | 1.17337 | 1.16836 | 1.16973 | 18828.0 |
| 2020-05-14 | E6 | Futures | 1.16338 | 1.16397 | 1.15871 | 1.15957 | 148648.0 |
| 2020-05-14 | E7 | Futures | 1.1576 | 1.1578 | 1.1526 | 1.1535 | 6243.0 |
| 2020-05-14 | EBM | Futures | 219.75 | 222.15 | 219.15 | 221.55 | 14755.0 |
| 2020-05-14 | ED | Futures | 96.3533 | 96.3678 | 96.3339 | 96.3629 | 266994.0 |
| 2020-05-14 | ER | Futures | 98.264 | 98.269 | 98.254 | 98.264 | 52469.0 |
| 2020-05-14 | ESG | Futures | 253.09 | 258.18 | 250.73 | 258.18 | 461.0 |
| 2020-05-14 | EW | Futures | 1645.2 | 1663.6 | 1577.8 | 1656.9 | 14920.0 |
| 2020-05-14 | FBON | Futures | 140.42 | 140.78 | 140.09 | 140.25 | 291.0 |
| 2020-05-14 | FBTP | Futures | 123.51 | 123.9 | 123.15 | 123.43 | 61237.0 |
| 2020-05-14 | FBTS | Futures | 107.066 | 107.143 | 106.922 | 106.97 | 50735.0 |
| 2020-05-14 | FCE | Futures | 4154.3 | 4180.0 | 4063.0 | 4140.2 | 39730.0 |
| 2020-05-14 | FDAX | Futures | 11089.4 | 11121.6 | 10744.6 | 10911.7 | 117083.0 |
| 2020-05-14 | FDIV | Futures | 116.63 | 116.63 | 114.36 | 114.78 | 333.0 |
| 2020-05-14 | FDXM | Futures | 11156.2 | 11172.1 | 10795.9 | 10963.8 | 96400.0 |
| 2020-05-14 | FESX | Futures | 2547.9 | 2556.1 | 2469.0 | 2511.2 | 1795693.0 |
| 2020-05-14 | FGBL | Futures | 168.71 | 169.21 | 168.65 | 168.79 | 540361.0 |
| 2020-05-14 | FGBM | Futures | 135.07 | 135.22 | 135.04 | 135.07 | 323145.0 |
| 2020-05-14 | FGBS | Futures | 112.92 | 112.966 | 112.92 | 112.925 | 181529.0 |
| 2020-05-14 | FGBX | Futures | 228.45 | 230.09 | 228.11 | 228.67 | 36639.0 |
| 2020-05-14 | FMWO | Futures | 6885.7 | 6955.1 | 6766.8 | 6850.4 | 5790.0 |
| 2020-05-14 | FOAT | Futures | 153.21 | 153.48 | 152.81 | 152.98 | 99560.0 |
| 2020-05-14 | FTDX | Futures | 2967.8 | 2993.1 | 2911.7 | 2949.1 | 115.0 |
| 2020-05-14 | FTI | Futures | 466.54 | 471.85 | 457.92 | 464.22 | 16608.0 |
| 2020-05-14 | FTUK | Futures | 5520.1 | 5520.6 | 5329.2 | 5398.5 | 142012.0 |
| 2020-05-14 | FVSA | Futures | 308.54 | 327.99 | 292.25 | 314.42 | 16811.0 |
| 2020-05-14 | FXXP | Futures | 304.4 | 305.7 | 297.6 | 301.1 | 93354.0 |
> showing 50 of 120 rows — these rows as CSV