PREVIEW / futures_daily / 2020-08-13
file: by_date/futures_daily/2020/2020-08-13.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-08-13 | ES | Futures | 3790.7 | 3806.74 | 3779.16 | 3790.7 | 1205758.0 |
| 2020-08-13 | NQ | Futures | 12901.09 | 13075.76 | 12876.42 | 12970.44 | 413661.0 |
| 2020-08-13 | YM | Futures | 29855.2 | 29935.6 | 29694.4 | 29817.7 | 141138.0 |
| 2020-08-13 | CL | Futures | 31.06 | 31.26 | 30.71 | 30.82 | 329507.0 |
| 2020-08-13 | GC | Futures | 2276.2 | 2332.3 | 2271.1 | 2327.1 | 349891.0 |
| 2020-08-13 | ZN | Futures | 137.877341 | 138.187038 | 137.645068 | 137.722492 | 1322300.0 |
| 2020-08-13 | A6 | Futures | 0.73685 | 0.73952 | 0.73417 | 0.73479 | 79931.0 |
| 2020-08-13 | AD | Futures | 0.76611 | 0.76946 | 0.76591 | 0.76763 | 58258.0 |
| 2020-08-13 | ALI | Futures | 2173.58 | 2173.88 | 2145.05 | 2149.3 | 351.0 |
| 2020-08-13 | B | Futures | 29.22 | 29.38 | 28.89 | 28.98 | 148411.0 |
| 2020-08-13 | B6 | Futures | 1.3234 | 1.3329 | 1.3234 | 1.3255 | 79803.0 |
| 2020-08-13 | BR | Futures | 0.14504 | 0.14793 | 0.14504 | 0.14738 | 6012.0 |
| 2020-08-13 | BTC | Futures | 15869.6 | 16088.5 | 15513.9 | 15855.9 | 5062.0 |
| 2020-08-13 | BZ | Futures | 28.6 | 28.69 | 28.22 | 28.3 | 13877.0 |
| 2020-08-13 | C | Futures | 1535.0 | 1543.0 | 1524.0 | 1538.0 | 3453.0 |
| 2020-08-13 | CB | Futures | 174.552 | 174.552 | 172.252 | 172.252 | 63.0 |
| 2020-08-13 | CC | Futures | 1613.0 | 1639.0 | 1613.0 | 1629.0 | 19525.0 |
| 2020-08-13 | CNH | Futures | 6.8451 | 6.8628 | 6.8393 | 6.8601 | 574.0 |
| 2020-08-13 | CSC | Futures | 3.459 | 3.509 | 3.449 | 3.482 | 119.0 |
| 2020-08-13 | CT | Futures | 63.08 | 63.37 | 62.94 | 63.14 | 5.0 |
| 2020-08-13 | DC | Futures | 27.95 | 28.76 | 27.78 | 28.3 | 416.0 |
| 2020-08-13 | DX | Futures | 90.184 | 90.208 | 89.74 | 90.138 | 19290.0 |
| 2020-08-13 | E1 | Futures | 1.24602 | 1.25158 | 1.24602 | 1.24806 | 20103.0 |
| 2020-08-13 | E6 | Futures | 1.26541 | 1.27389 | 1.26525 | 1.26686 | 194916.0 |
| 2020-08-13 | E7 | Futures | 1.2592 | 1.2675 | 1.259 | 1.2606 | 6329.0 |
| 2020-08-13 | EBM | Futures | 213.17 | 214.06 | 212.27 | 213.47 | 10813.0 |
| 2020-08-13 | ED | Futures | 96.4282 | 96.433 | 96.4185 | 96.4233 | 145585.0 |
| 2020-08-13 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.396 | 104182.0 |
| 2020-08-13 | ESG | Futures | 307.06 | 307.06 | 306.02 | 306.46 | 6.0 |
| 2020-08-13 | EW | Futures | 2078.6 | 2086.2 | 2066.7 | 2075.1 | 11006.0 |
| 2020-08-13 | FBON | Futures | 147.01 | 147.08 | 146.03 | 146.1 | 244.0 |
| 2020-08-13 | FBTP | Futures | 133.41 | 133.63 | 132.56 | 132.8 | 95855.0 |
| 2020-08-13 | FBTS | Futures | 108.938 | 108.958 | 108.774 | 108.832 | 75478.0 |
| 2020-08-13 | FCE | Futures | 4915.1 | 4934.5 | 4887.8 | 4903.4 | 201.0 |
| 2020-08-13 | FDAX | Futures | 13882.2 | 13903.4 | 13721.2 | 13821.6 | 61245.0 |
| 2020-08-13 | FDXM | Futures | 13845.9 | 13855.4 | 13671.2 | 13771.8 | 31370.0 |
| 2020-08-13 | FESX | Futures | 3103.5 | 3107.2 | 3065.7 | 3087.8 | 597444.0 |
| 2020-08-13 | FGBL | Futures | 168.57 | 168.73 | 167.46 | 167.74 | 636221.0 |
| 2020-08-13 | FGBM | Futures | 134.76 | 134.82 | 134.43 | 134.49 | 395599.0 |
| 2020-08-13 | FGBS | Futures | 112.714 | 112.724 | 112.659 | 112.659 | 360602.0 |
| 2020-08-13 | FGBX | Futures | 227.86 | 228.73 | 223.67 | 224.95 | 44597.0 |
| 2020-08-13 | FMWO | Futures | 8384.5 | 8411.8 | 8365.6 | 8408.2 | 1522.0 |
| 2020-08-13 | FOAT | Futures | 156.39 | 156.5 | 155.49 | 155.59 | 185812.0 |
| 2020-08-13 | FTDX | Futures | 3157.4 | 3189.6 | 3157.4 | 3188.0 | 10.0 |
| 2020-08-13 | FTI | Futures | 532.76 | 532.76 | 528.98 | 530.36 | 229.0 |
| 2020-08-13 | FTUK | Futures | 5902.4 | 5902.4 | 5813.1 | 5847.1 | 85769.0 |
| 2020-08-13 | FVSA | Futures | 205.0 | 209.56 | 202.92 | 206.24 | 9805.0 |
| 2020-08-13 | FXXP | Futures | 345.1 | 345.1 | 342.1 | 344.0 | 27803.0 |
| 2020-08-13 | G | Futures | 126.62 | 126.79 | 126.23 | 126.38 | 172465.0 |
| 2020-08-13 | GF | Futures | 282.046 | 282.475 | 280.095 | 280.524 | 5534.0 |
> showing 50 of 119 rows — these rows as CSV