PREVIEW / futures_daily / 2020-06-25
file: by_date/futures_daily/2020/2020-06-25.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-06-25 | ES | Futures | 3429.38 | 3466.25 | 3382.39 | 3456.4 | 1967245.0 |
| 2020-06-25 | NQ | Futures | 11612.49 | 11730.58 | 11473.5 | 11708.82 | 514249.0 |
| 2020-06-25 | YM | Futures | 27198.5 | 27498.5 | 26795.5 | 27431.0 | 263063.0 |
| 2020-06-25 | CL | Futures | 27.58 | 28.44 | 26.88 | 28.07 | 451640.0 |
| 2020-06-25 | GC | Futures | 2127.9 | 2136.6 | 2118.0 | 2125.8 | 152200.0 |
| 2020-06-25 | ZN | Futures | 137.629583 | 137.815401 | 137.552158 | 137.660553 | 1104239.0 |
| 2020-06-25 | A6 | Futures | 0.70681 | 0.70917 | 0.70455 | 0.70712 | 80097.0 |
| 2020-06-25 | AD | Futures | 0.74454 | 0.74601 | 0.74261 | 0.74378 | 57241.0 |
| 2020-06-25 | ALI | Futures | 1924.14 | 1924.14 | 1924.14 | 1924.14 | 10.0 |
| 2020-06-25 | B | Futures | 26.39 | 27.12 | 25.86 | 26.79 | 270612.0 |
| 2020-06-25 | B6 | Futures | 1.262 | 1.2662 | 1.2585 | 1.2605 | 78735.0 |
| 2020-06-25 | BR | Futures | 0.1471 | 0.14845 | 0.1471 | 0.14845 | 1.0 |
| 2020-06-25 | BTC | Futures | 12870.7 | 12932.7 | 12519.5 | 12863.8 | 2169.0 |
| 2020-06-25 | BZ | Futures | 25.77 | 26.52 | 25.3 | 26.19 | 24715.0 |
| 2020-06-25 | C | Futures | 1742.0 | 1826.0 | 1742.0 | 1810.0 | 4504.0 |
| 2020-06-25 | CB | Futures | 201.165 | 206.461 | 201.165 | 202.208 | 22.0 |
| 2020-06-25 | CC | Futures | 1515.0 | 1571.0 | 1513.0 | 1565.0 | 20188.0 |
| 2020-06-25 | CNH | Futures | 7.0029 | 7.0107 | 6.999 | 7.0044 | 196.0 |
| 2020-06-25 | CSC | Futures | 3.609 | 3.654 | 3.535 | 3.615 | 156.0 |
| 2020-06-25 | CT | Futures | 60.38 | 61.08 | 60.28 | 61.08 | 7.0 |
| 2020-06-25 | DC | Futures | 30.1 | 30.32 | 29.03 | 29.95 | 458.0 |
| 2020-06-25 | DX | Futures | 93.898 | 94.261 | 93.826 | 94.07 | 16119.0 |
| 2020-06-25 | E1 | Futures | 1.20161 | 1.20161 | 1.19718 | 1.19979 | 18408.0 |
| 2020-06-25 | E6 | Futures | 1.20972 | 1.21031 | 1.20285 | 1.20564 | 156984.0 |
| 2020-06-25 | E7 | Futures | 1.2037 | 1.2043 | 1.1968 | 1.1996 | 5194.0 |
| 2020-06-25 | EBM | Futures | 211.97 | 213.47 | 211.97 | 212.27 | 9183.0 |
| 2020-06-25 | ED | Futures | 96.3943 | 96.3943 | 96.3847 | 96.3895 | 89847.0 |
| 2020-06-25 | ER | Futures | 98.357 | 98.362 | 98.347 | 98.362 | 61780.0 |
| 2020-06-25 | ESG | Futures | 275.95 | 279.26 | 275.27 | 279.26 | 76.0 |
| 2020-06-25 | EW | Futures | 1844.5 | 1863.8 | 1809.1 | 1860.8 | 13428.0 |
| 2020-06-25 | FBON | Futures | 144.98 | 145.07 | 144.67 | 144.97 | 214.0 |
| 2020-06-25 | FBTP | Futures | 129.85 | 130.08 | 129.23 | 129.54 | 109942.0 |
| 2020-06-25 | FBTS | Futures | 108.425 | 108.454 | 108.27 | 108.357 | 60764.0 |
| 2020-06-25 | FCE | Futures | 4749.7 | 4854.1 | 4666.4 | 4788.9 | 73186.0 |
| 2020-06-25 | FDAX | Futures | 12862.3 | 13078.0 | 12668.9 | 12959.0 | 109485.0 |
| 2020-06-25 | FDIV | Futures | 141.71 | 141.9 | 141.71 | 141.9 | 100.0 |
| 2020-06-25 | FDXM | Futures | 12820.1 | 13035.0 | 12621.1 | 12912.2 | 54241.0 |
| 2020-06-25 | FESX | Futures | 2937.3 | 2991.8 | 2885.6 | 2962.2 | 1117077.0 |
| 2020-06-25 | FEU3 | Futures | 99.109 | 99.109 | 99.109 | 99.109 | 6.0 |
| 2020-06-25 | FGBL | Futures | 168.27 | 168.85 | 168.25 | 168.69 | 526982.0 |
| 2020-06-25 | FGBM | Futures | 134.78 | 135.0 | 134.75 | 134.95 | 424685.0 |
| 2020-06-25 | FGBS | Futures | 112.774 | 112.825 | 112.769 | 112.815 | 335982.0 |
| 2020-06-25 | FGBX | Futures | 225.94 | 227.96 | 225.92 | 227.51 | 47844.0 |
| 2020-06-25 | FMWO | Futures | 7649.8 | 7718.5 | 7545.5 | 7633.2 | 13349.0 |
| 2020-06-25 | FOAT | Futures | 155.35 | 155.63 | 155.33 | 155.57 | 137723.0 |
| 2020-06-25 | FTDX | Futures | 2963.2 | 2994.4 | 2945.3 | 2985.7 | 1685.0 |
| 2020-06-25 | FTI | Futures | 516.15 | 524.78 | 508.92 | 518.94 | 30328.0 |
| 2020-06-25 | FTUK | Futures | 5740.8 | 5839.1 | 5658.1 | 5784.7 | 100243.0 |
| 2020-06-25 | FVSA | Futures | 303.18 | 316.18 | 280.75 | 293.76 | 16810.0 |
| 2020-06-25 | FXXP | Futures | 327.4 | 333.9 | 323.4 | 330.7 | 59876.0 |
> showing 50 of 121 rows — these rows as CSV