PREVIEW / futures_daily / 2020-04-07
file: by_date/futures_daily/2020/2020-04-07.parquet size: 10 KB rows: 121
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-04-07 | ES | Futures | 2927.21 | 3042.84 | 2902.87 | 2923.34 | 2486524.0 |
| 2020-04-07 | NQ | Futures | 9210.78 | 9519.18 | 9111.9 | 9185.28 | 531043.0 |
| 2020-04-07 | YM | Futures | 24004.4 | 25051.2 | 23795.3 | 23999.1 | 275755.0 |
| 2020-04-07 | CL | Futures | 26.1 | 27.0 | 23.33 | 23.42 | 797707.0 |
| 2020-04-07 | GC | Futures | 2070.2 | 2113.3 | 2027.7 | 2041.9 | 204497.0 |
| 2020-04-07 | ZN | Futures | 136.759622 | 136.790493 | 135.833485 | 136.234811 | 1441115.0 |
| 2020-04-07 | A6 | Futures | 0.62525 | 0.63799 | 0.62443 | 0.63665 | 78102.0 |
| 2020-04-07 | AD | Futures | 0.71857 | 0.72723 | 0.7171 | 0.7249 | 63078.0 |
| 2020-04-07 | ALI | Futures | 1790.1 | 1824.09 | 1790.1 | 1814.38 | 68.0 |
| 2020-04-07 | B | Futures | 25.78 | 26.18 | 24.31 | 24.41 | 303419.0 |
| 2020-04-07 | B6 | Futures | 1.2422 | 1.2582 | 1.2358 | 1.2534 | 76241.0 |
| 2020-04-07 | BR | Futures | 0.15562 | 0.15784 | 0.15562 | 0.15661 | 103.0 |
| 2020-04-07 | BTC | Futures | 10426.0 | 10660.0 | 10078.4 | 10397.6 | 7749.0 |
| 2020-04-07 | BZ | Futures | 24.75 | 25.4 | 23.58 | 23.68 | 36246.0 |
| 2020-04-07 | C | Futures | 1751.0 | 1768.0 | 1748.0 | 1759.0 | 4862.0 |
| 2020-04-07 | CB | Futures | 158.934 | 162.559 | 158.934 | 162.559 | 27.0 |
| 2020-04-07 | CC | Futures | 1545.0 | 1570.0 | 1545.0 | 1563.0 | 27732.0 |
| 2020-04-07 | CNH | Futures | 7.0356 | 7.0399 | 6.9841 | 6.9967 | 563.0 |
| 2020-04-07 | CSC | Futures | 2.716 | 2.752 | 2.714 | 2.752 | 480.0 |
| 2020-04-07 | CT | Futures | 51.43 | 51.59 | 50.41 | 50.93 | 24014.0 |
| 2020-04-07 | DC | Futures | 21.06 | 21.95 | 21.06 | 21.95 | 424.0 |
| 2020-04-07 | DX | Futures | 97.5 | 97.5 | 96.422 | 96.614 | 15561.0 |
| 2020-04-07 | E1 | Futures | 1.167 | 1.17896 | 1.16609 | 1.1785 | 19635.0 |
| 2020-04-07 | E6 | Futures | 1.16247 | 1.17714 | 1.16155 | 1.17445 | 165316.0 |
| 2020-04-07 | E7 | Futures | 1.1566 | 1.1708 | 1.1555 | 1.1684 | 6898.0 |
| 2020-04-07 | EBM | Futures | 217.25 | 220.05 | 216.97 | 218.93 | 12748.0 |
| 2020-04-07 | ED | Futures | 96.1454 | 96.1454 | 96.0777 | 96.1019 | 435732.0 |
| 2020-04-07 | ER | Futures | 98.254 | 98.254 | 98.186 | 98.195 | 199768.0 |
| 2020-04-07 | ESG | Futures | 246.14 | 246.14 | 239.48 | 239.48 | 180.0 |
| 2020-04-07 | EW | Futures | 1517.5 | 1620.3 | 1505.3 | 1546.0 | 13714.0 |
| 2020-04-07 | FBON | Futures | 140.44 | 140.48 | 139.48 | 139.65 | 466.0 |
| 2020-04-07 | FBTP | Futures | 126.58 | 126.79 | 125.31 | 125.51 | 58659.0 |
| 2020-04-07 | FBTS | Futures | 107.191 | 107.249 | 106.874 | 106.902 | 35533.0 |
| 2020-04-07 | FCE | Futures | 4282.1 | 4385.3 | 4228.4 | 4297.2 | 64039.0 |
| 2020-04-07 | FDAX | Futures | 10828.7 | 11181.4 | 10661.6 | 10929.7 | 117047.0 |
| 2020-04-07 | FDIV | Futures | 117.93 | 119.97 | 117.23 | 117.23 | 752.0 |
| 2020-04-07 | FDXM | Futures | 10861.8 | 11235.9 | 10715.2 | 10981.9 | 100129.0 |
| 2020-04-07 | FESX | Futures | 2579.1 | 2647.9 | 2537.8 | 2591.0 | 1758501.0 |
| 2020-04-07 | FEU3 | Futures | 98.942 | 98.942 | 98.932 | 98.932 | 100.0 |
| 2020-04-07 | FGBL | Futures | 167.01 | 167.09 | 165.48 | 165.72 | 567499.0 |
| 2020-04-07 | FGBM | Futures | 134.24 | 134.31 | 133.79 | 133.88 | 311276.0 |
| 2020-04-07 | FGBS | Futures | 112.78 | 112.795 | 112.704 | 112.729 | 227622.0 |
| 2020-04-07 | FGBX | Futures | 224.83 | 225.06 | 219.86 | 220.71 | 41533.0 |
| 2020-04-07 | FMWO | Futures | 6639.8 | 6776.2 | 6549.2 | 6678.6 | 6931.0 |
| 2020-04-07 | FOAT | Futures | 151.19 | 151.33 | 149.9 | 150.13 | 85190.0 |
| 2020-04-07 | FTDX | Futures | 2775.2 | 2779.8 | 2708.5 | 2725.7 | 164.0 |
| 2020-04-07 | FTI | Futures | 465.12 | 476.13 | 461.04 | 467.75 | 28761.0 |
| 2020-04-07 | FTUK | Futures | 5342.8 | 5443.3 | 5244.3 | 5353.7 | 131452.0 |
| 2020-04-07 | FVSA | Futures | 365.03 | 394.29 | 351.08 | 383.03 | 17587.0 |
| 2020-04-07 | FXXP | Futures | 298.5 | 305.7 | 296.1 | 300.5 | 126840.0 |
> showing 50 of 121 rows — these rows as CSV