PREVIEW / futures_daily / 2020-07-16
file: by_date/futures_daily/2020/2020-07-16.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-07-16 | ES | Futures | 3628.05 | 3633.96 | 3588.93 | 3595.69 | 1471311.0 |
| 2020-07-16 | NQ | Futures | 12410.72 | 12416.81 | 12158.28 | 12200.35 | 628898.0 |
| 2020-07-16 | YM | Futures | 28736.3 | 28783.5 | 28362.3 | 28456.6 | 198313.0 |
| 2020-07-16 | CL | Futures | 30.06 | 30.19 | 29.69 | 29.87 | 203851.0 |
| 2020-07-16 | GC | Futures | 2176.8 | 2180.6 | 2154.0 | 2161.5 | 196566.0 |
| 2020-07-16 | ZN | Futures | 138.063159 | 138.310917 | 138.016705 | 138.233493 | 629126.0 |
| 2020-07-16 | A6 | Futures | 0.721 | 0.72152 | 0.71638 | 0.71689 | 89195.0 |
| 2020-07-16 | AD | Futures | 0.75149 | 0.75195 | 0.74743 | 0.74789 | 54761.0 |
| 2020-07-16 | ALI | Futures | 2008.78 | 2046.41 | 2008.78 | 2036.1 | 402.0 |
| 2020-07-16 | B | Futures | 28.48 | 28.54 | 28.11 | 28.26 | 172155.0 |
| 2020-07-16 | B6 | Futures | 1.2785 | 1.2822 | 1.2716 | 1.2742 | 78674.0 |
| 2020-07-16 | BR | Futures | 0.14595 | 0.14877 | 0.14595 | 0.14877 | 59.0 |
| 2020-07-16 | BTC | Futures | 12726.1 | 12760.5 | 12450.7 | 12595.3 | 3344.0 |
| 2020-07-16 | BZ | Futures | 27.8 | 27.9 | 27.48 | 27.62 | 20484.0 |
| 2020-07-16 | C | Futures | 1397.0 | 1404.0 | 1385.0 | 1399.0 | 5772.0 |
| 2020-07-16 | CB | Futures | 193.382 | 193.382 | 189.503 | 191.242 | 138.0 |
| 2020-07-16 | CC | Futures | 1400.0 | 1427.0 | 1387.0 | 1417.0 | 12624.0 |
| 2020-07-16 | CNH | Futures | 6.9003 | 6.9174 | 6.8979 | 6.9126 | 261.0 |
| 2020-07-16 | CSC | Futures | 3.991 | 4.156 | 3.954 | 4.156 | 22.0 |
| 2020-07-16 | CT | Futures | 63.01 | 63.59 | 63.01 | 63.59 | 5.0 |
| 2020-07-16 | DC | Futures | 33.14 | 34.23 | 32.32 | 34.16 | 508.0 |
| 2020-07-16 | DX | Futures | 92.705 | 93.097 | 92.58 | 93.038 | 18268.0 |
| 2020-07-16 | E1 | Futures | 1.20445 | 1.20638 | 1.2015 | 1.20388 | 20283.0 |
| 2020-07-16 | E6 | Futures | 1.22614 | 1.2293 | 1.22158 | 1.22244 | 206720.0 |
| 2020-07-16 | E7 | Futures | 1.22 | 1.2231 | 1.2154 | 1.2164 | 7009.0 |
| 2020-07-16 | EBM | Futures | 224.84 | 226.64 | 222.15 | 222.45 | 20663.0 |
| 2020-07-16 | ED | Futures | 96.4088 | 96.4185 | 96.4088 | 96.4137 | 51955.0 |
| 2020-07-16 | ER | Futures | 98.357 | 98.372 | 98.357 | 98.372 | 94815.0 |
| 2020-07-16 | ESG | Futures | 290.77 | 291.37 | 289.84 | 290.88 | 252.0 |
| 2020-07-16 | EW | Futures | 1955.1 | 1958.7 | 1927.0 | 1940.0 | 13173.0 |
| 2020-07-16 | FBON | Futures | 145.67 | 146.06 | 145.34 | 145.75 | 678.0 |
| 2020-07-16 | FBTP | Futures | 130.64 | 130.98 | 130.36 | 130.95 | 66772.0 |
| 2020-07-16 | FBTS | Futures | 108.483 | 108.541 | 108.415 | 108.541 | 37051.0 |
| 2020-07-16 | FCE | Futures | 4911.7 | 4931.1 | 4875.2 | 4911.3 | 49688.0 |
| 2020-07-16 | FDAX | Futures | 13677.7 | 13714.3 | 13589.0 | 13675.0 | 78259.0 |
| 2020-07-16 | FDXM | Futures | 13628.9 | 13663.8 | 13539.9 | 13625.7 | 47190.0 |
| 2020-07-16 | FESX | Futures | 3104.4 | 3110.9 | 3076.7 | 3100.7 | 781485.0 |
| 2020-07-16 | FGBL | Futures | 168.32 | 168.87 | 168.23 | 168.75 | 472933.0 |
| 2020-07-16 | FGBM | Futures | 134.65 | 134.9 | 134.65 | 134.86 | 390323.0 |
| 2020-07-16 | FGBS | Futures | 112.704 | 112.764 | 112.704 | 112.754 | 271850.0 |
| 2020-07-16 | FGBX | Futures | 227.24 | 228.35 | 226.54 | 228.0 | 33690.0 |
| 2020-07-16 | FMWO | Futures | 8014.8 | 8027.8 | 7979.2 | 8011.2 | 3445.0 |
| 2020-07-16 | FOAT | Futures | 155.71 | 156.14 | 155.56 | 156.07 | 152816.0 |
| 2020-07-16 | FTDX | Futures | 3125.2 | 3156.4 | 3124.7 | 3148.2 | 147.0 |
| 2020-07-16 | FTI | Futures | 533.85 | 537.45 | 530.16 | 534.28 | 15907.0 |
| 2020-07-16 | FTUK | Futures | 5926.5 | 5927.9 | 5852.3 | 5882.1 | 80188.0 |
| 2020-07-16 | FVSA | Futures | 257.9 | 266.04 | 252.02 | 255.18 | 7093.0 |
| 2020-07-16 | FXXP | Futures | 341.3 | 343.6 | 340.3 | 342.7 | 46194.0 |
| 2020-07-16 | G | Futures | 127.41 | 127.76 | 127.34 | 127.66 | 209307.0 |
| 2020-07-16 | GF | Futures | 270.175 | 278.801 | 269.303 | 276.427 | 7822.0 |
> showing 50 of 119 rows — these rows as CSV