PREVIEW / futures_daily / 2020-09-15
file: by_date/futures_daily/2020/2020-09-15.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-09-15 | ES | Futures | 3785.85 | 3829.95 | 3781.92 | 3814.22 | 1903406.0 |
| 2020-09-15 | NQ | Futures | 13041.01 | 13292.53 | 13004.54 | 13256.06 | 518258.0 |
| 2020-09-15 | YM | Futures | 29983.8 | 30282.0 | 29937.5 | 30045.2 | 149422.0 |
| 2020-09-15 | CL | Futures | 27.0 | 27.87 | 26.82 | 27.68 | 217077.0 |
| 2020-09-15 | GC | Futures | 2322.1 | 2341.2 | 2309.6 | 2322.1 | 239538.0 |
| 2020-09-15 | ZN | Futures | 138.419677 | 138.450671 | 138.280203 | 138.357689 | 747829.0 |
| 2020-09-15 | A6 | Futures | 0.74857 | 0.75401 | 0.74631 | 0.75042 | 70372.0 |
| 2020-09-15 | AD | Futures | 0.76911 | 0.77169 | 0.76779 | 0.76901 | 55124.0 |
| 2020-09-15 | ALI | Futures | 2156.99 | 2173.04 | 2146.3 | 2146.3 | 151.0 |
| 2020-09-15 | B | Futures | 25.31 | 26.02 | 25.11 | 25.84 | 214799.0 |
| 2020-09-15 | B6 | Futures | 1.3032 | 1.3113 | 1.3 | 1.3085 | 80998.0 |
| 2020-09-15 | BR | Futures | 0.1506 | 0.1506 | 0.14867 | 0.14867 | 1.0 |
| 2020-09-15 | BTC | Futures | 14514.4 | 14818.2 | 14372.6 | 14602.1 | 4052.0 |
| 2020-09-15 | BZ | Futures | 24.73 | 25.46 | 24.56 | 25.27 | 25333.0 |
| 2020-09-15 | C | Futures | 1602.0 | 1692.0 | 1602.0 | 1686.0 | 19702.0 |
| 2020-09-15 | CB | Futures | 167.45 | 167.705 | 167.45 | 167.705 | 10.0 |
| 2020-09-15 | CC | Futures | 1684.0 | 1772.0 | 1683.0 | 1769.0 | 35168.0 |
| 2020-09-15 | CNH | Futures | 6.7039 | 6.7039 | 6.6616 | 6.6736 | 579.0 |
| 2020-09-15 | CSC | Futures | 3.322 | 3.329 | 3.249 | 3.249 | 10.0 |
| 2020-09-15 | CT | Futures | 66.24 | 66.24 | 65.1 | 66.13 | 22.0 |
| 2020-09-15 | DC | Futures | 26.65 | 27.03 | 26.23 | 26.31 | 130.0 |
| 2020-09-15 | DX | Futures | 89.902 | 90.013 | 89.632 | 89.917 | 18636.0 |
| 2020-09-15 | E1 | Futures | 1.25043 | 1.25428 | 1.24918 | 1.25032 | 15186.0 |
| 2020-09-15 | E6 | Futures | 1.27355 | 1.2773 | 1.27066 | 1.27221 | 136172.0 |
| 2020-09-15 | E7 | Futures | 1.2671 | 1.2707 | 1.2643 | 1.2658 | 5403.0 |
| 2020-09-15 | EBM | Futures | 227.54 | 227.84 | 224.83 | 225.13 | 37506.0 |
| 2020-09-15 | ED | Futures | 96.4407 | 96.4503 | 96.4407 | 96.4455 | 157576.0 |
| 2020-09-15 | ER | Futures | 98.421 | 98.426 | 98.416 | 98.421 | 65639.0 |
| 2020-09-15 | ESG | Futures | 315.27 | 316.7 | 315.2 | 315.2 | 995.0 |
| 2020-09-15 | EW | Futures | 2009.5 | 2035.0 | 2009.5 | 2017.1 | 19826.0 |
| 2020-09-15 | FBON | Futures | 147.67 | 147.75 | 147.21 | 147.67 | 510.0 |
| 2020-09-15 | FBTP | Futures | 133.71 | 133.92 | 133.35 | 133.83 | 79142.0 |
| 2020-09-15 | FBTS | Futures | 109.103 | 109.151 | 109.054 | 109.132 | 31760.0 |
| 2020-09-15 | FCE | Futures | 4886.9 | 4925.2 | 4871.8 | 4905.3 | 59164.0 |
| 2020-09-15 | FDAX | Futures | 13985.2 | 14089.9 | 13952.8 | 14049.0 | 97944.0 |
| 2020-09-15 | FDIV | Futures | 153.41 | 153.65 | 153.32 | 153.65 | 80.0 |
| 2020-09-15 | FDXM | Futures | 13952.6 | 14042.8 | 13913.4 | 14008.9 | 3941.0 |
| 2020-09-15 | FESX | Futures | 3049.9 | 3081.4 | 3038.8 | 3072.1 | 1521957.0 |
| 2020-09-15 | FGBL | Futures | 169.27 | 169.36 | 169.0 | 169.22 | 474526.0 |
| 2020-09-15 | FGBM | Futures | 135.04 | 135.07 | 134.93 | 134.99 | 323118.0 |
| 2020-09-15 | FGBS | Futures | 112.754 | 112.769 | 112.734 | 112.749 | 313197.0 |
| 2020-09-15 | FGBX | Futures | 229.49 | 229.9 | 228.57 | 229.49 | 41549.0 |
| 2020-09-15 | FMWO | Futures | 8443.8 | 8503.1 | 8441.4 | 8490.0 | 30136.0 |
| 2020-09-15 | FOAT | Futures | 157.25 | 157.38 | 156.97 | 157.25 | 106055.0 |
| 2020-09-15 | FTDX | Futures | 3191.8 | 3191.8 | 3160.4 | 3177.4 | 413.0 |
| 2020-09-15 | FTI | Futures | 513.99 | 519.35 | 513.43 | 517.81 | 10836.0 |
| 2020-09-15 | FTUK | Futures | 5740.8 | 5828.2 | 5719.7 | 5821.1 | 406262.0 |
| 2020-09-15 | FVSA | Futures | 192.41 | 196.5 | 189.81 | 193.16 | 28472.0 |
| 2020-09-15 | FXXP | Futures | 339.4 | 343.4 | 339.4 | 343.0 | 201756.0 |
| 2020-09-15 | G | Futures | 127.18 | 127.21 | 126.77 | 126.91 | 234106.0 |
> showing 50 of 119 rows — these rows as CSV