PREVIEW / futures_daily / 2020-05-11
file: by_date/futures_daily/2020/2020-05-11.parquet size: 10 KB rows: 118
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-11 | ES | Futures | 3231.77 | 3260.81 | 3197.47 | 3233.98 | 1528302.0 |
| 2020-05-11 | NQ | Futures | 10541.23 | 10706.6 | 10453.81 | 10637.82 | 398142.0 |
| 2020-05-11 | YM | Futures | 25852.6 | 26111.9 | 25580.5 | 25741.6 | 175632.0 |
| 2020-05-11 | CL | Futures | 18.23 | 19.04 | 17.62 | 17.97 | 179591.0 |
| 2020-05-11 | GC | Futures | 2068.9 | 2078.4 | 2052.0 | 2059.2 | 202173.0 |
| 2020-05-11 | ZN | Futures | 137.253562 | 137.377047 | 136.929414 | 136.94485 | 981624.0 |
| 2020-05-11 | A6 | Futures | 0.67025 | 0.67425 | 0.66326 | 0.66614 | 68932.0 |
| 2020-05-11 | AD | Futures | 0.72723 | 0.72901 | 0.72161 | 0.72267 | 44545.0 |
| 2020-05-11 | ALI | Futures | 1803.6 | 1803.9 | 1796.73 | 1800.61 | 51.0 |
| 2020-05-11 | B | Futures | 20.27 | 20.78 | 19.38 | 19.57 | 242212.0 |
| 2020-05-11 | B6 | Futures | 1.2594 | 1.2627 | 1.2468 | 1.2518 | 72655.0 |
| 2020-05-11 | BR | Futures | 0.14153 | 0.14341 | 0.14013 | 0.14042 | 4363.0 |
| 2020-05-11 | BTC | Futures | 12267.1 | 12899.9 | 11432.6 | 12232.3 | 19225.0 |
| 2020-05-11 | BZ | Futures | 19.61 | 20.11 | 18.77 | 18.94 | 33638.0 |
| 2020-05-11 | C | Futures | 1855.0 | 1899.0 | 1853.0 | 1896.0 | 14498.0 |
| 2020-05-11 | CB | Futures | 158.376 | 165.012 | 158.376 | 163.953 | 16.0 |
| 2020-05-11 | CC | Futures | 1565.0 | 1617.0 | 1560.0 | 1609.0 | 20028.0 |
| 2020-05-11 | CNH | Futures | 7.036 | 7.0523 | 7.0265 | 7.0458 | 403.0 |
| 2020-05-11 | CSC | Futures | 2.783 | 2.815 | 2.75 | 2.815 | 82.0 |
| 2020-05-11 | CT | Futures | 54.34 | 55.71 | 54.34 | 55.2 | 10207.0 |
| 2020-05-11 | DC | Futures | 21.99 | 22.95 | 21.99 | 22.95 | 587.0 |
| 2020-05-11 | DX | Futures | 96.562 | 97.036 | 96.398 | 96.959 | 14197.0 |
| 2020-05-11 | E1 | Futures | 1.17315 | 1.1752 | 1.17064 | 1.17178 | 16592.0 |
| 2020-05-11 | E6 | Futures | 1.16499 | 1.16693 | 1.16155 | 1.16252 | 110064.0 |
| 2020-05-11 | E7 | Futures | 1.1592 | 1.1609 | 1.1555 | 1.1565 | 4918.0 |
| 2020-05-11 | EBM | Futures | 225.74 | 226.34 | 224.24 | 225.14 | 8269.0 |
| 2020-05-11 | ED | Futures | 96.3629 | 96.3726 | 96.3484 | 96.3484 | 146765.0 |
| 2020-05-11 | ER | Futures | 98.274 | 98.289 | 98.264 | 98.269 | 34890.0 |
| 2020-05-11 | ESG | Futures | 262.98 | 265.85 | 262.75 | 264.74 | 2070.0 |
| 2020-05-11 | EW | Futures | 1769.3 | 1788.7 | 1737.8 | 1762.7 | 14049.0 |
| 2020-05-11 | FBON | Futures | 139.75 | 139.75 | 139.51 | 139.66 | 53.0 |
| 2020-05-11 | FBTP | Futures | 123.3 | 123.83 | 122.61 | 122.72 | 56630.0 |
| 2020-05-11 | FBTS | Futures | 107.047 | 107.172 | 106.912 | 106.941 | 45804.0 |
| 2020-05-11 | FCE | Futures | 4415.8 | 4423.1 | 4315.6 | 4345.6 | 60693.0 |
| 2020-05-11 | FDAX | Futures | 11588.6 | 11666.3 | 11352.7 | 11450.6 | 65532.0 |
| 2020-05-11 | FDXM | Futures | 11654.6 | 11720.5 | 11407.0 | 11505.3 | 63460.0 |
| 2020-05-11 | FESX | Futures | 2663.5 | 2681.9 | 2610.3 | 2631.4 | 768709.0 |
| 2020-05-11 | FGBL | Futures | 168.62 | 168.88 | 168.29 | 168.68 | 445976.0 |
| 2020-05-11 | FGBM | Futures | 135.14 | 135.23 | 134.97 | 135.12 | 276305.0 |
| 2020-05-11 | FGBS | Futures | 113.066 | 113.066 | 112.941 | 112.966 | 251467.0 |
| 2020-05-11 | FGBX | Futures | 226.67 | 227.31 | 225.61 | 226.84 | 34907.0 |
| 2020-05-11 | FMWO | Futures | 7159.8 | 7197.4 | 7078.6 | 7131.5 | 2238.0 |
| 2020-05-11 | FOAT | Futures | 152.83 | 153.04 | 152.51 | 152.74 | 79818.0 |
| 2020-05-11 | FTDX | Futures | 3048.2 | 3050.7 | 3001.2 | 3015.9 | 105.0 |
| 2020-05-11 | FTI | Futures | 486.89 | 487.82 | 478.72 | 483.21 | 6065.0 |
| 2020-05-11 | FTUK | Futures | 5648.9 | 5657.3 | 5548.4 | 5583.8 | 93182.0 |
| 2020-05-11 | FVSA | Futures | 266.01 | 284.01 | 252.96 | 265.11 | 14514.0 |
| 2020-05-11 | FXXP | Futures | 315.9 | 316.5 | 310.6 | 313.1 | 62619.0 |
| 2020-05-11 | G | Futures | 125.95 | 126.03 | 125.66 | 125.82 | 147842.0 |
| 2020-05-11 | GF | Futures | 265.571 | 265.814 | 256.897 | 257.187 | 4946.0 |
> showing 50 of 118 rows — these rows as CSV