PREVIEW / futures_daily / 2020-08-25
file: by_date/futures_daily/2020/2020-08-25.parquet size: 10 KB rows: 120
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-25 | ES | Futures | 3857.39 | 3881.87 | 3851.48 | 3875.4 | 1133837.0 |
| 2020-08-25 | NQ | Futures | 13505.2 | 13628.52 | 13434.11 | 13609.95 | 495891.0 |
| 2020-08-25 | YM | Futures | 30268.8 | 30521.8 | 30052.4 | 30214.2 | 184066.0 |
| 2020-08-25 | CL | Futures | 30.63 | 31.51 | 30.6 | 31.35 | 330800.0 |
| 2020-08-25 | GC | Futures | 2286.3 | 2296.0 | 2266.5 | 2271.2 | 274113.0 |
| 2020-08-25 | ZN | Futures | 138.218008 | 138.233493 | 137.768947 | 138.063159 | 3003000.0 |
| 2020-08-25 | A6 | Futures | 0.73695 | 0.74055 | 0.73551 | 0.74024 | 66000.0 |
| 2020-08-25 | AD | Futures | 0.76789 | 0.77093 | 0.76672 | 0.76992 | 59138.0 |
| 2020-08-25 | ALI | Futures | 2105.48 | 2124.83 | 2102.2 | 2123.64 | 287.0 |
| 2020-08-25 | B | Futures | 29.09 | 29.65 | 29.06 | 29.51 | 231571.0 |
| 2020-08-25 | B6 | Futures | 1.3266 | 1.3376 | 1.3261 | 1.335 | 82681.0 |
| 2020-08-25 | BR | Futures | 0.14163 | 0.14187 | 0.14163 | 0.14187 | 14.0 |
| 2020-08-25 | BTC | Futures | 16114.3 | 16168.3 | 15203.0 | 15446.0 | 2883.0 |
| 2020-08-25 | BZ | Futures | 28.41 | 29.0 | 28.41 | 28.87 | 20026.0 |
| 2020-08-25 | C | Futures | 1529.0 | 1555.0 | 1529.0 | 1540.0 | 2343.0 |
| 2020-08-25 | CB | Futures | 174.311 | 174.311 | 174.311 | 174.311 | 9.0 |
| 2020-08-25 | CC | Futures | 1633.0 | 1651.0 | 1628.0 | 1633.0 | 13477.0 |
| 2020-08-25 | CNH | Futures | 6.8114 | 6.8169 | 6.8057 | 6.808 | 689.0 |
| 2020-08-25 | CSC | Futures | 3.318 | 3.417 | 3.313 | 3.417 | 98.0 |
| 2020-08-25 | CT | Futures | 65.94 | 66.54 | 65.72 | 65.72 | 10.0 |
| 2020-08-25 | DC | Futures | 26.95 | 27.82 | 26.85 | 27.82 | 507.0 |
| 2020-08-25 | DX | Futures | 90.093 | 90.17 | 89.793 | 89.85 | 16287.0 |
| 2020-08-25 | E1 | Futures | 1.24625 | 1.25226 | 1.24522 | 1.2517 | 17012.0 |
| 2020-08-25 | E6 | Futures | 1.26546 | 1.27136 | 1.26498 | 1.27024 | 154929.0 |
| 2020-08-25 | E7 | Futures | 1.2593 | 1.2649 | 1.2587 | 1.2639 | 6299.0 |
| 2020-08-25 | EBM | Futures | 222.75 | 223.94 | 222.45 | 223.35 | 7570.0 |
| 2020-08-25 | ED | Futures | 96.4475 | 96.4499 | 96.4378 | 96.4451 | 138464.0 |
| 2020-08-25 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.406 | 46802.0 |
| 2020-08-25 | ESG | Futures | 312.87 | 314.45 | 312.85 | 314.45 | 940.0 |
| 2020-08-25 | EW | Futures | 2059.1 | 2077.0 | 2040.5 | 2057.4 | 14030.0 |
| 2020-08-25 | FBON | Futures | 146.74 | 146.74 | 145.92 | 145.98 | 811.0 |
| 2020-08-25 | FBTP | Futures | 133.7 | 133.72 | 132.55 | 132.74 | 97528.0 |
| 2020-08-25 | FBTS | Futures | 108.997 | 109.045 | 108.861 | 108.88 | 64224.0 |
| 2020-08-25 | FCE | Futures | 4893.2 | 4936.0 | 4856.2 | 4871.7 | 56621.0 |
| 2020-08-25 | FDAX | Futures | 13910.9 | 14046.9 | 13818.4 | 13890.7 | 64707.0 |
| 2020-08-25 | FDIV | Futures | 151.9 | 151.9 | 150.81 | 151.0 | 200.0 |
| 2020-08-25 | FDXM | Futures | 13859.6 | 13995.1 | 13769.7 | 13840.6 | 39087.0 |
| 2020-08-25 | FESX | Futures | 3079.5 | 3111.8 | 3058.3 | 3074.0 | 780967.0 |
| 2020-08-25 | FGBL | Futures | 169.07 | 169.07 | 167.92 | 168.06 | 760035.0 |
| 2020-08-25 | FGBM | Futures | 134.92 | 134.92 | 134.57 | 134.62 | 431040.0 |
| 2020-08-25 | FGBS | Futures | 112.734 | 112.734 | 112.669 | 112.679 | 497145.0 |
| 2020-08-25 | FGBX | Futures | 228.83 | 228.97 | 224.99 | 225.41 | 96384.0 |
| 2020-08-25 | FMWO | Futures | 8531.5 | 8548.1 | 8469.9 | 8488.8 | 5444.0 |
| 2020-08-25 | FOAT | Futures | 156.52 | 156.6 | 155.61 | 155.73 | 184725.0 |
| 2020-08-25 | FTDX | Futures | 3203.9 | 3206.4 | 3195.7 | 3198.8 | 20.0 |
| 2020-08-25 | FTI | Futures | 524.6 | 527.12 | 519.57 | 521.22 | 21360.0 |
| 2020-08-25 | FTUK | Futures | 5784.2 | 5833.4 | 5680.7 | 5703.0 | 76424.0 |
| 2020-08-25 | FVSA | Futures | 201.26 | 206.24 | 196.7 | 205.0 | 26109.0 |
| 2020-08-25 | FXXP | Futures | 343.8 | 345.1 | 340.1 | 341.4 | 48526.0 |
| 2020-08-25 | G | Futures | 126.85 | 126.85 | 126.15 | 126.3 | 341492.0 |
> showing 50 of 120 rows — these rows as CSV