PREVIEW / futures_daily / 2020-07-15
file: by_date/futures_daily/2020/2020-07-15.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-07-15 | ES | Futures | 3606.38 | 3639.3 | 3592.87 | 3623.83 | 1937696.0 |
| 2020-07-15 | NQ | Futures | 12425.81 | 12496.03 | 12246.2 | 12399.4 | 719947.0 |
| 2020-07-15 | YM | Futures | 28554.1 | 29003.2 | 28475.9 | 28683.8 | 242949.0 |
| 2020-07-15 | CL | Futures | 29.76 | 30.25 | 29.42 | 30.21 | 248300.0 |
| 2020-07-15 | GC | Futures | 2174.4 | 2184.5 | 2165.9 | 2177.7 | 183055.0 |
| 2020-07-15 | ZN | Futures | 137.954765 | 138.187038 | 137.861856 | 138.094129 | 789589.0 |
| 2020-07-15 | A6 | Futures | 0.71792 | 0.72409 | 0.71792 | 0.72018 | 104465.0 |
| 2020-07-15 | AD | Futures | 0.74581 | 0.7518 | 0.74581 | 0.7516 | 69330.0 |
| 2020-07-15 | ALI | Futures | 1998.5 | 2020.27 | 1991.85 | 2008.78 | 78.0 |
| 2020-07-15 | B | Futures | 28.06 | 28.57 | 27.82 | 28.53 | 232180.0 |
| 2020-07-15 | B6 | Futures | 1.2756 | 1.2849 | 1.2756 | 1.278 | 85958.0 |
| 2020-07-15 | BR | Futures | 0.14817 | 0.14892 | 0.1469 | 0.1471 | 380.0 |
| 2020-07-15 | BTC | Futures | 12801.9 | 12836.3 | 12622.8 | 12657.2 | 2330.0 |
| 2020-07-15 | BZ | Futures | 27.48 | 27.92 | 27.2 | 27.89 | 23596.0 |
| 2020-07-15 | C | Futures | 1412.0 | 1423.0 | 1390.0 | 1393.0 | 8883.0 |
| 2020-07-15 | CB | Futures | 195.789 | 195.789 | 191.51 | 193.382 | 85.0 |
| 2020-07-15 | CC | Futures | 1419.0 | 1426.0 | 1394.0 | 1400.0 | 12839.0 |
| 2020-07-15 | CNH | Futures | 6.9157 | 6.9228 | 6.8984 | 6.9003 | 241.0 |
| 2020-07-15 | CSC | Futures | 4.199 | 4.199 | 4.067 | 4.067 | 169.0 |
| 2020-07-15 | CT | Futures | 63.94 | 64.03 | 63.3 | 63.3 | 12.0 |
| 2020-07-15 | DC | Futures | 34.42 | 34.76 | 33.22 | 33.22 | 417.0 |
| 2020-07-15 | DX | Futures | 92.845 | 92.937 | 92.459 | 92.767 | 14528.0 |
| 2020-07-15 | E1 | Futures | 1.21092 | 1.21422 | 1.20286 | 1.20331 | 23544.0 |
| 2020-07-15 | E6 | Futures | 1.22533 | 1.23048 | 1.22394 | 1.22555 | 188870.0 |
| 2020-07-15 | E7 | Futures | 1.2192 | 1.2243 | 1.2178 | 1.2195 | 7031.0 |
| 2020-07-15 | EBM | Futures | 222.75 | 224.54 | 221.55 | 224.24 | 20291.0 |
| 2020-07-15 | ED | Futures | 96.4088 | 96.4185 | 96.4088 | 96.4137 | 104642.0 |
| 2020-07-15 | ER | Futures | 98.357 | 98.362 | 98.352 | 98.362 | 49249.0 |
| 2020-07-15 | ESG | Futures | 291.01 | 292.43 | 290.86 | 292.22 | 64.0 |
| 2020-07-15 | EW | Futures | 1911.5 | 1955.2 | 1906.2 | 1948.5 | 17023.0 |
| 2020-07-15 | FBON | Futures | 145.69 | 145.9 | 145.5 | 145.51 | 385.0 |
| 2020-07-15 | FBTP | Futures | 130.53 | 130.83 | 130.44 | 130.61 | 56424.0 |
| 2020-07-15 | FBTS | Futures | 108.473 | 108.512 | 108.454 | 108.473 | 25419.0 |
| 2020-07-15 | FCE | Futures | 4893.9 | 4970.7 | 4865.4 | 4934.0 | 63093.0 |
| 2020-07-15 | FDAX | Futures | 13642.1 | 13799.3 | 13553.9 | 13741.4 | 101881.0 |
| 2020-07-15 | FDIV | Futures | 146.82 | 148.06 | 146.82 | 148.06 | 230.0 |
| 2020-07-15 | FDXM | Futures | 13591.8 | 13749.5 | 13504.0 | 13691.9 | 60687.0 |
| 2020-07-15 | FESX | Futures | 3090.6 | 3131.2 | 3074.9 | 3116.4 | 1104749.0 |
| 2020-07-15 | FEU3 | Futures | 99.1 | 99.109 | 99.1 | 99.109 | 100.0 |
| 2020-07-15 | FGBL | Futures | 168.19 | 168.61 | 168.08 | 168.28 | 538076.0 |
| 2020-07-15 | FGBM | Futures | 134.63 | 134.77 | 134.59 | 134.7 | 407780.0 |
| 2020-07-15 | FGBS | Futures | 112.704 | 112.739 | 112.694 | 112.724 | 299258.0 |
| 2020-07-15 | FGBX | Futures | 226.97 | 228.31 | 226.29 | 226.95 | 41297.0 |
| 2020-07-15 | FMWO | Futures | 8019.5 | 8093.0 | 8012.4 | 8061.0 | 4868.0 |
| 2020-07-15 | FOAT | Futures | 155.57 | 155.89 | 155.46 | 155.64 | 112653.0 |
| 2020-07-15 | FTDX | Futures | 3117.0 | 3146.6 | 3106.3 | 3134.9 | 115.0 |
| 2020-07-15 | FTI | Futures | 538.34 | 542.03 | 535.39 | 537.52 | 16954.0 |
| 2020-07-15 | FTUK | Futures | 5878.7 | 5945.9 | 5834.3 | 5926.5 | 109569.0 |
| 2020-07-15 | FVSA | Futures | 258.8 | 263.78 | 251.11 | 258.35 | 12209.0 |
| 2020-07-15 | FXXP | Futures | 341.6 | 345.6 | 340.4 | 344.3 | 78341.0 |
> showing 50 of 121 rows — these rows as CSV