PREVIEW / futures_daily / 2020-05-07
file: by_date/futures_daily/2020/2020-05-07.parquet size: 10 KB rows: 119
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-07 | ES | Futures | 3133.57 | 3203.28 | 3123.61 | 3186.68 | 1494330.0 |
| 2020-05-07 | NQ | Futures | 10257.77 | 10462.41 | 10237.99 | 10441.49 | 383884.0 |
| 2020-05-07 | YM | Futures | 25068.3 | 25608.2 | 24998.9 | 25441.7 | 169833.0 |
| 2020-05-07 | CL | Futures | 17.93 | 19.91 | 17.08 | 17.53 | 310261.0 |
| 2020-05-07 | GC | Futures | 2044.7 | 2101.9 | 2042.1 | 2092.9 | 250704.0 |
| 2020-05-07 | ZN | Futures | 136.94485 | 137.654888 | 136.821365 | 137.608582 | 1313439.0 |
| 2020-05-07 | A6 | Futures | 0.6574 | 0.6685 | 0.65545 | 0.66655 | 78134.0 |
| 2020-05-07 | AD | Futures | 0.71619 | 0.72632 | 0.71497 | 0.72424 | 59183.0 |
| 2020-05-07 | ALI | Futures | 1797.33 | 1797.33 | 1796.13 | 1796.43 | 31.0 |
| 2020-05-07 | B | Futures | 19.57 | 21.03 | 19.2 | 19.45 | 259890.0 |
| 2020-05-07 | B6 | Futures | 1.2529 | 1.2608 | 1.2452 | 1.2545 | 94427.0 |
| 2020-05-07 | BR | Futures | 0.14263 | 0.14263 | 0.13747 | 0.14018 | 7370.0 |
| 2020-05-07 | BTC | Futures | 13032.1 | 14068.2 | 12663.5 | 13922.2 | 12108.0 |
| 2020-05-07 | BZ | Futures | 19.26 | 20.36 | 18.58 | 18.83 | 36701.0 |
| 2020-05-07 | C | Futures | 1830.0 | 1859.0 | 1823.0 | 1855.0 | 1225.0 |
| 2020-05-07 | CB | Futures | 150.011 | 153.357 | 150.011 | 151.489 | 19.0 |
| 2020-05-07 | CC | Futures | 1552.0 | 1568.0 | 1535.0 | 1556.0 | 12741.0 |
| 2020-05-07 | CNH | Futures | 7.0767 | 7.0767 | 7.0316 | 7.0319 | 531.0 |
| 2020-05-07 | CSC | Futures | 2.637 | 2.639 | 2.593 | 2.607 | 36.0 |
| 2020-05-07 | CT | Futures | 53.22 | 55.03 | 53.05 | 53.99 | 14437.0 |
| 2020-05-07 | DC | Futures | 21.65 | 21.66 | 21.06 | 21.15 | 410.0 |
| 2020-05-07 | DX | Futures | 96.954 | 97.138 | 96.528 | 96.607 | 13984.0 |
| 2020-05-07 | E1 | Futures | 1.16893 | 1.17178 | 1.16506 | 1.17121 | 17342.0 |
| 2020-05-07 | E6 | Futures | 1.16091 | 1.16526 | 1.15795 | 1.16446 | 123984.0 |
| 2020-05-07 | E7 | Futures | 1.1548 | 1.1592 | 1.1519 | 1.1584 | 6781.0 |
| 2020-05-07 | EBM | Futures | 223.94 | 225.74 | 223.65 | 225.44 | 23236.0 |
| 2020-05-07 | ED | Futures | 96.3388 | 96.3678 | 96.3388 | 96.3629 | 219999.0 |
| 2020-05-07 | ER | Futures | 98.274 | 98.284 | 98.259 | 98.279 | 60600.0 |
| 2020-05-07 | ESG | Futures | 260.26 | 261.77 | 259.82 | 260.09 | 1285.0 |
| 2020-05-07 | EW | Futures | 1676.9 | 1731.3 | 1668.6 | 1713.3 | 8082.0 |
| 2020-05-07 | FBON | Futures | 139.41 | 139.61 | 138.41 | 139.61 | 272.0 |
| 2020-05-07 | FBTP | Futures | 121.72 | 122.62 | 121.01 | 122.44 | 86691.0 |
| 2020-05-07 | FBTS | Futures | 106.672 | 106.845 | 106.479 | 106.806 | 58952.0 |
| 2020-05-07 | FCE | Futures | 4289.4 | 4365.9 | 4289.4 | 4351.4 | 30173.0 |
| 2020-05-07 | FDAX | Futures | 11170.8 | 11421.5 | 11161.8 | 11364.9 | 65092.0 |
| 2020-05-07 | FDXM | Futures | 11221.0 | 11477.1 | 11218.9 | 11419.2 | 56432.0 |
| 2020-05-07 | FESX | Futures | 2573.6 | 2636.0 | 2572.7 | 2625.9 | 764253.0 |
| 2020-05-07 | FEU3 | Futures | 99.001 | 99.016 | 99.001 | 99.016 | 550.0 |
| 2020-05-07 | FGBL | Futures | 168.64 | 169.21 | 168.06 | 169.03 | 652672.0 |
| 2020-05-07 | FGBM | Futures | 135.04 | 135.26 | 134.87 | 135.18 | 361601.0 |
| 2020-05-07 | FGBS | Futures | 112.966 | 113.011 | 112.925 | 112.986 | 293102.0 |
| 2020-05-07 | FGBX | Futures | 227.12 | 228.75 | 225.06 | 228.18 | 54783.0 |
| 2020-05-07 | FMWO | Futures | 7011.5 | 7071.5 | 7010.4 | 7050.4 | 2218.0 |
| 2020-05-07 | FOAT | Futures | 152.36 | 153.1 | 151.94 | 152.97 | 205985.0 |
| 2020-05-07 | FTDX | Futures | 2932.0 | 3005.3 | 2932.0 | 2985.0 | 89.0 |
| 2020-05-07 | FTI | Futures | 473.13 | 484.38 | 473.13 | 482.83 | 19369.0 |
| 2020-05-07 | FTUK | Futures | 5460.7 | 5601.2 | 5460.7 | 5586.1 | 88294.0 |
| 2020-05-07 | FVSA | Futures | 305.17 | 308.77 | 293.01 | 295.71 | 13265.0 |
| 2020-05-07 | FXXP | Futures | 307.6 | 312.7 | 307.6 | 311.5 | 51945.0 |
| 2020-05-07 | G | Futures | 125.86 | 126.3 | 125.71 | 126.12 | 217004.0 |
> showing 50 of 119 rows — these rows as CSV