PREVIEW / futures_daily / 2020-04-14
file: by_date/futures_daily/2020/2020-04-14.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-04-14 | ES | Futures | 3053.9 | 3149.06 | 3045.6 | 3145.74 | 1716496.0 |
| 2020-04-14 | NQ | Futures | 9557.87 | 9985.49 | 9537.23 | 9965.43 | 431916.0 |
| 2020-04-14 | YM | Futures | 24883.7 | 25526.0 | 24809.0 | 25481.2 | 174571.0 |
| 2020-04-14 | CL | Futures | 21.74 | 22.3 | 20.29 | 20.4 | 436459.0 |
| 2020-04-14 | GC | Futures | 2136.2 | 2169.3 | 2118.7 | 2145.2 | 241194.0 |
| 2020-04-14 | ZN | Futures | 136.296554 | 136.713315 | 136.173069 | 136.543524 | 1076610.0 |
| 2020-04-14 | A6 | Futures | 0.65617 | 0.66234 | 0.65504 | 0.66131 | 62047.0 |
| 2020-04-14 | AD | Futures | 0.72941 | 0.73169 | 0.7284 | 0.72921 | 44209.0 |
| 2020-04-14 | ALI | Futures | 1813.16 | 1813.16 | 1813.16 | 1813.16 | 1.0 |
| 2020-04-14 | B | Futures | 24.7 | 24.76 | 22.5 | 22.67 | 297548.0 |
| 2020-04-14 | B6 | Futures | 1.2713 | 1.2844 | 1.27 | 1.2824 | 64673.0 |
| 2020-04-14 | BR | Futures | 0.15734 | 0.15853 | 0.1571 | 0.15767 | 28.0 |
| 2020-04-14 | BTC | Futures | 9723.8 | 9943.7 | 9624.5 | 9858.6 | 2232.0 |
| 2020-04-14 | BZ | Futures | 23.85 | 24.06 | 21.85 | 22.0 | 32146.0 |
| 2020-04-14 | C | Futures | 1698.0 | 1699.0 | 1668.0 | 1673.0 | 2386.0 |
| 2020-04-14 | CB | Futures | 149.76 | 150.011 | 146.386 | 146.721 | 40.0 |
| 2020-04-14 | CC | Futures | 1491.0 | 1505.0 | 1484.0 | 1495.0 | 16276.0 |
| 2020-04-14 | CNH | Futures | 6.9897 | 7.0035 | 6.9795 | 6.9846 | 265.0 |
| 2020-04-14 | CSC | Futures | 2.413 | 2.439 | 2.362 | 2.43 | 132.0 |
| 2020-04-14 | CT | Futures | 50.8 | 51.09 | 50.4 | 50.56 | 12622.0 |
| 2020-04-14 | DC | Futures | 19.08 | 19.58 | 18.83 | 19.39 | 407.0 |
| 2020-04-14 | DX | Futures | 96.098 | 96.151 | 95.552 | 95.619 | 11125.0 |
| 2020-04-14 | E1 | Futures | 1.17964 | 1.18932 | 1.17952 | 1.18852 | 19361.0 |
| 2020-04-14 | E6 | Futures | 1.17472 | 1.18278 | 1.17451 | 1.18219 | 120234.0 |
| 2020-04-14 | E7 | Futures | 1.1685 | 1.1766 | 1.1684 | 1.1761 | 3641.0 |
| 2020-04-14 | EBM | Futures | 222.57 | 223.41 | 220.05 | 220.61 | 22675.0 |
| 2020-04-14 | ED | Futures | 96.1841 | 96.2373 | 96.1744 | 96.2179 | 271977.0 |
| 2020-04-14 | ER | Futures | 98.215 | 98.264 | 98.2 | 98.254 | 94859.0 |
| 2020-04-14 | ESG | Futures | 255.04 | 256.69 | 255.04 | 256.69 | 20.0 |
| 2020-04-14 | EW | Futures | 1630.8 | 1681.8 | 1627.3 | 1659.7 | 10442.0 |
| 2020-04-14 | FBON | Futures | 139.88 | 139.88 | 138.8 | 139.02 | 156.0 |
| 2020-04-14 | FBTP | Futures | 125.54 | 125.66 | 123.39 | 123.65 | 52309.0 |
| 2020-04-14 | FBTS | Futures | 106.912 | 107.172 | 106.287 | 106.402 | 26319.0 |
| 2020-04-14 | FCE | Futures | 4410.5 | 4410.5 | 4327.7 | 4353.3 | 53312.0 |
| 2020-04-14 | FDAX | Futures | 11160.8 | 11434.7 | 11160.8 | 11307.3 | 65924.0 |
| 2020-04-14 | FDXM | Futures | 11248.6 | 11489.9 | 11248.6 | 11361.3 | 41476.0 |
| 2020-04-14 | FESX | Futures | 2621.3 | 2681.9 | 2620.4 | 2647.9 | 1046860.0 |
| 2020-04-14 | FEU3 | Futures | 98.996 | 98.996 | 98.991 | 98.991 | 100.0 |
| 2020-04-14 | FGBL | Futures | 165.7 | 166.91 | 165.52 | 166.74 | 274951.0 |
| 2020-04-14 | FGBM | Futures | 133.91 | 134.34 | 133.87 | 134.29 | 183496.0 |
| 2020-04-14 | FGBS | Futures | 112.719 | 112.835 | 112.704 | 112.825 | 173210.0 |
| 2020-04-14 | FGBX | Futures | 220.29 | 223.62 | 219.69 | 223.15 | 20368.0 |
| 2020-04-14 | FMWO | Futures | 6885.7 | 6971.5 | 6866.8 | 6897.4 | 3608.0 |
| 2020-04-14 | FOAT | Futures | 150.68 | 151.44 | 150.48 | 151.21 | 61284.0 |
| 2020-04-14 | FTDX | Futures | 2881.9 | 2927.9 | 2871.3 | 2908.2 | 93.0 |
| 2020-04-14 | FTI | Futures | 477.26 | 478.52 | 470.37 | 472.08 | 11177.0 |
| 2020-04-14 | FTUK | Futures | 5483.8 | 5594.6 | 5434.3 | 5446.1 | 100860.0 |
| 2020-04-14 | FVSA | Futures | 312.82 | 320.92 | 306.07 | 311.02 | 19751.0 |
| 2020-04-14 | FXXP | Futures | 309.2 | 310.6 | 306.2 | 306.8 | 80706.0 |
| 2020-04-14 | G | Futures | 125.25 | 125.44 | 124.92 | 125.05 | 159550.0 |
> showing 50 of 118 rows — these rows as CSV