PREVIEW / futures_daily / 2019-08-15
file: by_date/futures_daily/2019/2019-08-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 |
|---|---|---|---|---|---|---|---|
| 2019-08-15 | ES | Futures | 3060.2 | 3098.78 | 3040.51 | 3073.69 | 2495340.0 |
| 2019-08-15 | NQ | Futures | 8599.24 | 8718.69 | 8506.27 | 8630.62 | 705042.0 |
| 2019-08-15 | YM | Futures | 26642.3 | 26993.0 | 26487.9 | 26854.4 | 326623.0 |
| 2019-08-15 | CL | Futures | 56.41 | 56.82 | 55.22 | 55.89 | 373771.0 |
| 2019-08-15 | GC | Futures | 1883.1 | 1896.8 | 1872.9 | 1888.8 | 436117.0 |
| 2019-08-15 | ZN | Futures | 129.835494 | 130.737561 | 129.711071 | 130.348739 | 2722396.0 |
| 2019-08-15 | A6 | Futures | 0.69493 | 0.69925 | 0.69473 | 0.69771 | 82974.0 |
| 2019-08-15 | AD | Futures | 0.75707 | 0.75909 | 0.75612 | 0.75692 | 84153.0 |
| 2019-08-15 | ALI | Futures | 2186.62 | 2186.62 | 2185.71 | 2186.02 | 2.0 |
| 2019-08-15 | B | Futures | 44.56 | 44.83 | 43.51 | 43.93 | 298674.0 |
| 2019-08-15 | B6 | Futures | 1.2326 | 1.242 | 1.2317 | 1.2377 | 108450.0 |
| 2019-08-15 | BFX | Futures | 4164.8 | 4164.8 | 4151.5 | 4151.5 | 175.0 |
| 2019-08-15 | BR | Futures | 0.19756 | 0.20031 | 0.19692 | 0.19976 | 16615.0 |
| 2019-08-15 | BTC | Futures | 14098.7 | 14374.1 | 13079.9 | 13947.3 | 7407.0 |
| 2019-08-15 | BZ | Futures | 43.97 | 44.25 | 42.96 | 43.36 | 45864.0 |
| 2019-08-15 | C | Futures | 1578.0 | 1587.0 | 1546.0 | 1549.0 | 5943.0 |
| 2019-08-15 | CB | Futures | 276.866 | 276.866 | 275.495 | 275.495 | 28.0 |
| 2019-08-15 | CC | Futures | 1458.0 | 1462.0 | 1439.0 | 1442.0 | 20620.0 |
| 2019-08-15 | CNH | Futures | 7.0573 | 7.074 | 7.0399 | 7.0547 | 1233.0 |
| 2019-08-15 | CSC | Futures | 3.105 | 3.107 | 3.094 | 3.094 | 53.0 |
| 2019-08-15 | CT | Futures | 59.15 | 59.37 | 58.78 | 58.92 | 8.0 |
| 2019-08-15 | DC | Futures | 26.13 | 26.23 | 26.02 | 26.08 | 211.0 |
| 2019-08-15 | DX | Futures | 94.177 | 94.447 | 94.047 | 94.36 | 17083.0 |
| 2019-08-15 | E1 | Futures | 1.19519 | 1.19612 | 1.18951 | 1.19055 | 32378.0 |
| 2019-08-15 | E6 | Futures | 1.21818 | 1.22004 | 1.21267 | 1.21447 | 196530.0 |
| 2019-08-15 | E7 | Futures | 1.2118 | 1.2137 | 1.2064 | 1.2081 | 3898.0 |
| 2019-08-15 | EBM | Futures | 192.02 | 193.75 | 191.73 | 193.46 | 10491.0 |
| 2019-08-15 | ED | Futures | 95.4207 | 95.4791 | 95.4158 | 95.4596 | 463082.0 |
| 2019-08-15 | ER | Futures | 98.543 | 98.573 | 98.538 | 98.563 | 97761.0 |
| 2019-08-15 | EW | Futures | 1927.4 | 1951.4 | 1916.7 | 1927.0 | 16634.0 |
| 2019-08-15 | FBON | Futures | 146.01 | 147.39 | 145.86 | 147.24 | 611.0 |
| 2019-08-15 | FBTP | Futures | 125.65 | 128.04 | 125.6 | 127.84 | 94455.0 |
| 2019-08-15 | FBTS | Futures | 107.379 | 107.81 | 107.274 | 107.695 | 50572.0 |
| 2019-08-15 | FCE | Futures | 4757.2 | 4783.5 | 4681.6 | 4742.7 | 92894.0 |
| 2019-08-15 | FDAX | Futures | 12059.9 | 12150.9 | 11853.5 | 12014.6 | 166771.0 |
| 2019-08-15 | FDXM | Futures | 11921.7 | 11999.7 | 11708.5 | 11866.6 | 96047.0 |
| 2019-08-15 | FESX | Futures | 2863.2 | 2886.8 | 2821.3 | 2865.0 | 1608261.0 |
| 2019-08-15 | FEU3 | Futures | 99.169 | 99.193 | 99.169 | 99.193 | 200.0 |
| 2019-08-15 | FGBL | Futures | 169.63 | 170.83 | 169.42 | 170.26 | 886527.0 |
| 2019-08-15 | FGBM | Futures | 135.91 | 136.23 | 135.82 | 136.1 | 559256.0 |
| 2019-08-15 | FGBS | Futures | 113.333 | 113.408 | 113.313 | 113.393 | 320284.0 |
| 2019-08-15 | FGBX | Futures | 229.85 | 235.21 | 228.98 | 232.76 | 95231.0 |
| 2019-08-15 | FMWO | Futures | 7030.2 | 7062.5 | 6947.2 | 7002.5 | 5000.0 |
| 2019-08-15 | FOAT | Futures | 155.88 | 156.86 | 155.6 | 156.62 | 166358.0 |
| 2019-08-15 | FTDX | Futures | 2658.8 | 2658.8 | 2566.5 | 2606.0 | 336.0 |
| 2019-08-15 | FTI | Futures | 506.12 | 508.67 | 499.68 | 505.56 | 23724.0 |
| 2019-08-15 | FTUK | Futures | 6530.9 | 6587.7 | 6469.9 | 6506.9 | 161666.0 |
| 2019-08-15 | FVSA | Futures | 240.17 | 257.1 | 235.78 | 242.68 | 44398.0 |
| 2019-08-15 | FXXP | Futures | 327.6 | 328.8 | 322.9 | 326.6 | 117842.0 |
| 2019-08-15 | G | Futures | 123.99 | 124.45 | 123.81 | 124.37 | 234899.0 |
> showing 50 of 121 rows — these rows as CSV